select id, redirect from sf_404 where url like 'buy/bungalow/clare/shannon/28-tullyvarraga-crescent'Would redirect