select id, redirect from sf_404 where url like 'buy/house/dublin/clontarf/36-charlemont-road-dublin-3'Would redirect