select id, redirect from sf_404 where url like 'buy/country-homes/tipperary/thurles/moyaliffe-house-ballycahill-thurles-county-tipperary-742'Would redirect