select id, redirect from sf_404 where url like 'buy/house/dublin/blackhorse-ave/3-st-davids-terrace-dublin-7'Would redirect