select id, redirect from sf_404 where url like 'buy/house/dublin/blackrock/8-hawthorn-manor-blackrock'Would redirect