It's hugely popular with the super rich - but you don't have to be a Premier League star or millionaire to live here ...