select id, redirect from sf_404 where url like 'buy/house/cork/youghal/40-larchfield-rise'Would redirect