4) If yes to #3, then may I have the link for such a information from a Limited Partner (investor) perspective?

I bet short term rentals can work right in your own backyard!

Or is it limited to 1 property per individual/LLC per year? 

And they just increased their rental limits to try and keep pace with cash tenants, so if Section 8 is part of your strategy, now is a great time.

That will leave you with limited funds to actually purchase the house.

We just discovered a crack in the concrete slab foundation that is a borderline major problem:- It is a vertical crack about 1/8 inch wide that is at least 9ft long, which is causing a 3/4 inch drop in the flooring and some evidence of old (luckily) limited moisture and termite intrusion. - BUT, it also appears old and probably a symptom of the original house settling.

Aging reports would be another avenue to explore, but again, may not even have these.Lastly, while maybe this property is in a desirable area of town with strong demand from highly qualified tenants, but I get the impression this is a rough part of town, with very limited demand from tenants.

They actually have pretty limited reach as of now and focus primarily on major metro areas.

So if loan due in say 3 years you would need to create 600k in 3 years or sell the property.With limited years left on lease for primary you would need to start saving big chunks of money now because buyer will want higher cap rate to purchase.

Most investors focus on what can they buy now with their available capital instead of simply what is the best investment for their capital without limitations.