My research on this has not scratched the surface of how a majority of Universities are dealing with this (please do some google searches and contribute any findings to this thread). 

You can certainly borrow money from your 401(k) in this fashion....if your 401(k) would allow it (your plan administrator or the plan "terms and conditions" would be able to tell you). 

The property is in a flood plain....over time as development occurs there is very often a need to expand or adjust the natural flood control system by adding flow capacity, storage volume or surface area.

I've looked at creative lending options but none appear to work other than old fashioned saving and a conventional loan.

I’ve done some surface level research and know that you can pay third-party services, but wondering if I can outright cancel due to medical reasons for my dad (cancer) who is too weak to travel.

Other than that, without re-doing it in my own analysis, on the surface it looks fine, especially because you're down payment is larger and loan is smaller.What aren't we seeing in the spreadsheet?

I have only just scratched the surface of this awesome tool (BP).

Although there was no elevated humidity or surface areas affected with mold, several of the air samples came back with very elevated levels.Almost immediately upon receiving this notice we offered to let them break their lease without penalty.

One of the upstairs bedrooms had this sticker on the wall.In the basement and the garage it appears that they sprayed white paint of some sort on all the surfaces. 

ADR and Occupancy rates are more of an art than a science, but using sites like AirDNA are great places to start and then verify thru local property management or just good old fashioned research on Airbnb and VRBO for active rentals in the area.