Good advice, but somewhat ironic coming from a NY guy :)3.

Roots can penetrate cast iron pipes, so they can go through cinder blocks or concrete piers like a knife through butter.

Cast iron?

If the seller was so serious about implementing an iron-clad "as-is" sale then they should not have allowed the inspection period in the first place.

Ironically, I have a colleague who bought some properties in Indy in 2015, at about the same ~$100k price point that you've used in your example.

Ironically, this attorney was recommended to me by the brother in law of one of these guys, the one who thinks he is a business genius (I am not making this up).

There were cemented pieces of corresponding angle iron in the ground which the windmill tower was attached to with bolts.

I recommend first ironing out what goals/targets you're wanting to achieve from your MF investing strategy and then start looking for markets that align with your strategy. 

I've got a lot of irons in the fire already, but I'd be game for a meetup if anyone ever wants to chat in the Iowa City area.  

The home inspector pointed out a few potential foundation issues my real estate agent and I thought warranted contacting a structural engineer: 45 degree angle drywall crack on a corner of just one doorframe, trouble with opening a few different windows, "minor" cracking in the foundation, cracked tile in a bathroom, and a more major issue: one of the cast iron sewer pipes has a positive sloping portion in the crawl space.The structural engineer completed his inspection today and I was able to discuss his findings over the phone with him.