select id, redirect from sf_404 where url like 'buy/apartment/dublin/kiltipper/175-kiltipper-gate-dublin-24'Would redirect