select id, redirect from sf_404 where url like 'buy/house/wicklow/rathnew/house-type-c---4-bed-semi-detached'Would redirect