select id, redirect from sf_404 where url like 'buy/house/kildare/johnstown/3-coach-house-yard'Would redirect