select id, redirect from sf_404 where url like 'buy/apartment/clare/shannon/11-maple-house-shannon'Would redirect