You can fix this by talking to the utility provider about creating "equal billing" or whatever they call it in your area.

Time horizon matters a lot too, talking to a client in their 60's wanting to retire is very different than someone in their 30's looking to build and accumulate wealth. 

I'm going to send you a message and we can talk offline 

I have a good team helping me, I have a good system, I’m confident in my ability to talk to sellers because I’m a real estate agent and just am nervous that I should be trying to reach more people.

Don't talk yourself into a place because of personal use.Buying a $475k condo that brings in 35k in gross rental income will lose a lot of money.

Don't disqualify yourself without talking to an expert. 

Talk to the seller, but options are to cancel the sale (and risk losing your deposit), renegotiate to lower the price to allow you to fix the problems or ask them to fix it. 

I notice that you mention two different states when you are talking about house hacking.

Otherwise, talk to your bank or credit union.

There is another STR owner in this community I've talked to, and he's been doing it for 1-2 years and he said it's still been a real pain to deal with.