select id, redirect from sf_404 where url like 'buy/apartment/dublin/south-city-centre-d2/45-harcourt-green-charlemont-street'Would redirect