select id, redirect from sf_404 where url like 'buy/apartment/leitrim/carrick-on-shannon/17-hartley-hall-carrick-on-shannon'Would redirect