Of the 3 cities, I am leaning towards Charleston since it is bounded at least partially by water and wetlands which would prevent large-scale urban sprawl and increased supply of housing.

Keep all lavatories, sinks, toilets, disposals, pump systems, and all other water and plumbing apparatus in good order and repair and shall use same only for the purposes for which they were constructed.

My team waiting at the water department for 5 hours to make sure we could get a resident into a home in short order. 8.

Some of his principles are helpful (10x thinking big) but hes a lot sizzle without the steak. 

Tenant now requests a water softener (we live in a very hard water area) due to clothes not being clean, stains, etc.

Example $1300/m for rent + $50/m - water $50/m for gas/eletric

In these instances, you'd have to check things like flooring, plumbing for leaks, roof for leaks, hot water heater, and heating and air conditioning units. 

They will get a $100,000 liability to cover fires, water damage, accidents, and more.As @Greg Scott stated, you should require your tenant to add you as "additional insured" on their policy.

What happens when the water service line has to be replaced?

If you can get a house with a killer view I think that is what sells the most, second being on water.