select id, redirect from sf_404 where url like 'buy/bungalow/cork/carrigrohane/shournagh-lodge-templehill-crk230457'Would redirect