I've found many properties with title issues wind up with unpaid property taxes so checking on delinquent taxes, tax deed sales and lands available for taxes might help you identify some.

Now the water issue is something.

For the proceeds I have to pay seller I would have to issue him a 1099 right?

to be clear - lots of other issues, lots of other challenges, and BRRRR is difficult right now with interest rates so high. 

:)I am sure this is a solvable issue with some work.

Get a small inground fiberglass pool.No above ground pool unless you have a mobile home.

However, I did take issue with the tone of the message, especially the part where they told me how they’d be paying rent.For context, there are no outstanding maintenance or repair issues, so I’m unsure what the tenant is referring to. 

I own a mobile home that I rent out and I am looking to make my first MFH purchase this upcoming year to house hack. 

There's a good chance the issue(s) you face has already been discussed and answered.Ask questions in the appropriate forum.

If you tell someone too early you aren't renewing their lease, especially one who is aggressive, could lead you to issues.