Many of its mega mansions are crumbling and derelict but developers are betting that residents will follow in the footsteps of stars like Ariana Grande and Premier League players and settle in new, ultra-secure flats