select id, redirect from sf_404 where url like 'buy/house/cork/crosshaven/three-bed-end-of-terrace'Would redirect