select id, redirect from sf_404 where url like 'buy/house/meath/trim/16-the-green-clady-meadows'Would redirect