Local property experts say these hotspots offer the best value for money, range of amenities and strong transport links