select id, redirect from sf_404 where url like 'buy/bungalow/dublin/newcastle/the-commons-hazelhatch'Would redirect