At this point, I'm considering taking on the "dry in" portion myself by hiring subs to complete the foundation, framing, roof, etc.

The road map for real estate investing success can be found at Bigger Pockets!

I have an HVAC guy who has been really great so far, and might have a foundation guy (not 100% if he's available).

Your inspector can tell you if your roof needs to be replaced, get in the crawl space and inspect the foundation/piers for damage or water issues. 

My family foundation  is most important and we’re sacrificing living in a 1 bedroom.

I am looking for a referral in the Twin Cities (Minnesota) market for someone who is good with foundation repair.

Also, many of the banks in my area won't finance manufactured homes, and the banks who do offer financing will expect that the home is well maintained and is sitting on a permanent foundation and even then the rates for those loans will be higher. 

Seems to me the only reason you should use the commercial lender at those rates are if the house will not qualify for a conventional loan (foundation, roof etc) or you have no extra money for the rehab.

I look at the house with a contractor and it's going to need an easy $50-$60k to dress it up, fix foundation and asbestos issues, among other things and at best you might get $1,900 gross rent each month. 

Specifically the current competitive rates for new construction trades and materials (e.g. foundation, framing, plumbing, electrical, drywall, trim carpentry, painters, tile work, brick layers, roofers).