select id, redirect from sf_404 where url like 'buy/house/cork/coachford/cnoic-eoin-coachford-co-cork-4907'Would redirect