Since now you are assuming the risks of his tenants without time to conduct your own DD you at a minimum need protection and I'd push for compensation. 

I also conduct all one on one tenant meetings, transactions, almost all meetings with anyone related to my business activities at either the property or my home office.

You can conduct an inspection or a contractor walk through if there is access.

Have you found a good one in excel to use to easily conduct different scenarios?

Demand a good deposit and make a lease with specific rules pertainig to conduct and parties.

Since it is in another state you will have to hire a resident agent in that state and then you will have to file the LLC to do business in the state you plan to conduct the activity (foreign file).

My original price, after going into contract and conducting all this research, was $1,050,000, a $150K discount to ask.

Who you may admire or follow will certainly influence how you conduct yourself.

So if I understand you correctly, you do have the inspection conducted yourself?

Some states require DBA or fictitious business name filings to be made for the protection of consumers conducting business with the entity.A company is said to be "doing business as" when the name under which they operate their business differs from its legal, registered name.