select id, redirect from sf_404 where url like 'buy/house/waterford-city/9-the-fairways-faithlegg'Would redirect