I still find myself not knowing exactly what questions I should be asking to confirm my interests of the place but to also show professionalism & ability to close.

Airdna can give you some high level Rates/Occupancy to start with for free but I would suggest really doing manual review of the booking sites to confirm or adjust your revenue inputs (which are ADR and Occupancy). 

My engineer has confirmed that all walls coming down are non-load bearing and I can do most of the hammer swinging and plaster/trim repairs myself.

Can anyone confirm?

@Drew Brown good to know and thank you for the confirmation.

I will be confirming those numbers with the subcontractors before accepting the position and put my own scope of work in place to track against.

I have reached out to Aloha Capital and Merchants Mortgage, both local, and confirmed they offer DSCR-based 30 yr fixed loans on single properties, but maybe that is a different type of product than the Portfolio loans you've mentioned?

You all confirmed what I had in mind.

And as soon as I get the ID data, I immediately check the IDs through special software to identify fake IDs (idanalyzer.com).

Confirm that the provider has a pristine reputation (e.g.