I'm stacking some solid connections in Columbus and plan on visiting to get the lay of the land at some point.

I am currently in the process of laying the groundwork for an Air BNB Arbitrage Business model specifically targeting the Anchorage/Wasilla region in Alaska.

The books you’ve read are excellent resources, and they lay a solid foundation for making informed decisions.

When rent vs buy influencers like Remit lay out their case for renting, I always raise my hand and say how about the hybrid of househacking.  

Lay it out for them in detail.

Full guts of the bathrooms, replacing all fixtures, throwing modern tile finishes for the tub/shower, new vanity, new cabinets in the kitchen, island, new stainless-steel appliances, new flooring throughout, new recess lighting, and likely new siding on the property to give it a more freshened pop for when it goes back on the market.

That window well should have a drain in it going to the exterior drain tile , which then goes to the sump pump . 

Plus the house had an industrial tile drop ceiling - weird.

Drain tile (which is basically a black pipe with holes in it) should be installed around the outside of the foundation and go in under the basement floor to the sump.

By "partial" I mean renovating the kitchen and bathroom, painting the place, re-tiling the floor and maybe adding some smaller features that can make a difference to prospective buyers, such as new A/C units, new internal doors, or maybe even sell the place furnished (home staging is not really an option here); with no or minimal demolition, and hopefully without electricity or plumbing issues.