select id, redirect from sf_404 where url like 'buy/house/cork/bandon/type-a3---4-bed-detached'Would redirect