select id, redirect from sf_404 where url like 'buy/house/waterford-city/auguste-ballindud'Would redirect