select id, redirect from sf_404 where url like 'buy/apartment/dublin/south-city-centre-d8/52-bertram-court-christchurch'Would redirect