select id, redirect from sf_404 where url like 'buy/house/dublin/terenure/73-greentrees-road-dublin-12'Would redirect