select id, redirect from sf_404 where url like 'buy/house/tipperary/portroe/lake-view-house-portroe-nenagh'Would redirect