It has been placed at the top of a leaderboard of the most appealing places to live in the country