select id, redirect from sf_404 where url like 'buy/bungalow/waterford-city/4-the-bungalow-upper-yellow-road'Would redirect