select id, redirect from sf_404 where url like 'buy/bungalow/kilkenny/the-poppy---4-bed-detached'Would redirect