select id, redirect from sf_404 where url like 'buy/bungalow/kerry/killarney/14-coolmagort-ave-beaufort'Would redirect