select id, redirect from sf_404 where url like 'buy/house/wicklow/avoca/heather-house-redcross'Would redirect