select id, redirect from sf_404 where url like 'buy/house/cork/city-centre-nth/152-lower-glanmire-road-cork-32695'Would redirect