select id, redirect from sf_404 where url like 'buy/house/roscommon/35-greenfields-lanesboro-road-rcm240051'Would redirect