select id, redirect from sf_404 where url like 'buy/house/dublin/drumcondra/1-st-alphonsus-avenue-dublin-9'Would redirect