select id, redirect from sf_404 where url like 'buy/bungalow/waterford-city/25-cannon-street-waterford'Would redirect