select id, redirect from sf_404 where url like 'buy/house/waterford-city/47-ardleigh-bracken-grove'Would redirect