So the workers comp system actually functions to limit claims by employees against employers.

Texas is landlord friendly.Cash flow is a function of how much money you put down vs the rent.   

I didn't find anything that the ADU is already functioning...

If these people have at least one functioning brain cell between them, they already know they are paying far less than what they would be elsewhere.

Cosmetic fixer and repaired many functional issues with the property.

The panels are not functioning in any capacity. 

I have a firm understanding of commercial products and function however I am not accustomed to the short term duration (3-5 years).

I am looking for a tool that can help me identify markets (neighborhoods, zip codes, cities/towns, counties, MSA's, etc) that meet specific criteria (rent/price ratios, historical appreciation, etc.). We can use any n...

I am not sure how the inspector would have caught the plumbing issues unless they didn't run any water, but they are just looking at if its functioning at that time, not code, etc.You'd need to talk to an attorney to see if they could help you determine if these are latent defects.

If you are not paying for heat then efficiency isn't your first concern, make sure it is safe and functional and how much life it has in it.