select id, redirect from sf_404 where url like 'buy/house/clare/cratloe/kilshannig-house-cratloe-woods'Would redirect