select id, redirect from sf_404 where url like 'buy/house/cork/douglas/2-hawthorn-villas-south-douglas-road-cork-2067'Would redirect