Affordability will be an issue in nearly half of all metropolitan areas as the home purchase season starts.