select id, redirect from sf_404 where url like 'buy/house/mayo/castlebar/9-harmony-heights-castlebar'Would redirect