select id, redirect from sf_404 where url like 'buy/house/cork/glengarriff/tikkos-house-dromgarriff-clo230141'Would redirect