Homes in these exclusive locations will set the average family back a cool £600,000