She seems to have a knack for tracking down information in nooks and crannies on the web.That said, at least here there's a condemnation process and one of the early steps in a property is declared a public nuisance.I would assume (but am not 100% sure) that by the nature of the title, and it having to go through the court system, as I understand it, that in most places this information would be searchable.I also commend you for that being part of your mindset and prospecting strategy. 

That's just the nature of the appraisal business, so factor that in.

I’ve done the fha loan and house hacking naturally.

The general public and local politicians have little regard for protecting this once prestine natural ressource: the storm sewer overflow issue is without a solution in sight (passing a law to allow the municipal waste water plant to dump raw residential and light industrial sewage into the lake 6 times a year would be political suicide in Europe, just saying) and the DNR recommends to limit fish consumption to once per month, just to keep your mercury intake down a bit..

If they stayed later, the cleaners would naturally show up while they're here and they'd have the awkward interaction haha.

I think our natural inclination to get more cautious as we age coupled with the perception that the real estate we can touch is somehow more secure. 

There is very little natural light and I am wondering if that will put off tenants or potential buyers when I sell?

Also be sure to account for snow removal and things of that nature if you’re buying multifamily

Are there any particular guidelines that need to be followed, and are there any pre-written packets, or something of that nature, that I can present to a potential investor, and any "canned" type presentations that can be tweaked for each potential project?

Most of the work that needs doing is cosmetic in nature.