Seems like I should continue to reach out but don't expect the deal I was getting prior.  

If you are purchasing a property with a lease you should also have a Tenant Estoppel letter prior to closing to review each tenants lease, deposits, etc. 

All I hear as an outsider (even prior to the virus) is that retail has been in trouble.

On paper, this is correct, but in reality there is a split driveway the leads to the back where the SFH is.Yes, I know, I should have confirmed the surveyors plans with the city prior to purchase.

But somehow there was a recording issue, and when the prior owner refi'd a pool of assets together, the original mortgage was not found. 

Tenant-1 told me in February that he quit his job (prior to the whole COVID-19 issue). 

A lot learned about using eviction aggressively when needed.The facts:Tenant wanted to leave, gives me '30 day' notice, then says they are leaving in 4 days, then moves out.Tenant wanted security deposit before they move out.Tenant has been model up to this point, communicating, handling turnover, cleaning, pays on time, etc.Police were called prior to my arrival by other tenant and they were told to put my property back.I show up on property unannounced and some of my property tenant knows is mine is still moved next to the door with their moving boxes.Tenant says to my face they were going to take my stuff in case I didn't give them their deposit back?!

If the property is located in a zoning district that does not allow for 3 family use, then look for a document that shows that the property existed as a 3 family PRIOR to the zoning ordinance being established.

Prior to COVID I was preparing for a  mini vacation to Mammoth Lakes and then to Florida.

TISH is what you'd be looking for to assess code violations, etc; however, these reports are typically only completed immediately prior to selling the property (must have a TISH report to list).I'm sure a few other municipalities throughout the Twin Cities offer this online; however, Minneapolis has the best database I'm aware of.