If so, what can be done to mitigate or make it more attractive?

A park like this will require a lot more staff to attract and service the daily traffic and keep the amenities looking good.  

Those developments attracted other businesses to relocate here and the impact on housing was intensified and so was traffic, road construction, etc. 

. - Your offer on the house will be potentially less attractive to the seller since closing will be 45-60 days plus all the potential issues that go along with a mortgage.

Does it only attract people looking to move more than one family into the house?

Cash flow is a bit weak but with the equity build up over time, it’s attractive.

I would not remodel or make an improvement unless it increases the rent or attracts a new renter.

I don't want to create a contract that is not attractive to rehabber..

This is one of the most attractive things with RE - after you have paid off a mortgage and you take out a new one, there is no income tax and you can brun the money in Vegas as far as the IRS is concerned.

So you really want a property which will attract a stable family, which is why being in a good school district is important.