select id, redirect from sf_404 where url like 'buy/house/clare/ennis/4-bed-semi-detached---a-rated'Would redirect