select id, redirect from sf_404 where url like 'buy/house/tipperary/thurles/9-butler-avenue-thurles'Would redirect