select id, redirect from sf_404 where url like 'buy/house/kerry/killarney/site-no-6-lough-ernie-park'Would redirect