My main concern is the condition of a house through two extreme winters.  

As one of the other guys pointed out if it is a recreational park it operates a lot like a hotel and weather, time of year, ect need to be factored in but if it is long term park it is a lot like a MHP.

Zillow, of course, cannot tell when a home is in distressed condition.

I, like millions of others, have cash ready to invest under the right conditions. 

I mean, I'm not sure if I want to go with this lender yet, as I'm still waiting for the conditional approval from another lender who might come with better terms.

I just sent a message to my property management company now asking if it's customary for them to list the rental on MLS.Also, regarding the rental price; Not only have I completed the lanai mesh, installed blinds and added a whole-house water conditioning system, but I'm also including the Internet connection and the security system in the advertised asking price which I believe should be worth it. 

I don’t want to put the money in to rehabbing it for sale as it would pretty much be a wash if I just sold it as is in the current condition as a fixer upper.

Is it solely due to property condition? 

Property is in great condition, so no repairs are needed, move in ready.

With current market conditions, interest rates, and scarce inventory, 95% of MLS properties will not be cash flow positive.