select id, redirect from sf_404 where url like 'buy/house/wexford/rosslare-strand/39-seabury-rosslare-strand'Would redirect