select id, redirect from sf_404 where url like 'buy/house/waterford-city/43-morgan-st-waterford-x91-hk1k'Would redirect