I do however think as things clean up systematically, cashflow will improve and the benefits of low capX exposure in near term and appreciation will work out.

You don't provide enough data to know.Every product is only worth what you are willing to pay for it. 

However, I noticed that as a Costco member, they also offer HVAC services, including the same product line (Lennox), along with a 10% Costco Shop Card if you go through them.Has anyone here used Costco for their HVAC needs?

The association has investigated loan products for such work, but has not committed to anything.

I could be wrong but I am unfamiliar with any products existing.

I know hosts have included additional cleaning fees for violations as a deterrent.If none of these solutions work, you could look into completely independent HVAC systems for the two units, though that would be a bigger upfront investment.

Dominated by about 7 tech non physical product companies.  6.  

I walked to the house and met a man who says he was cleaning out due to the loss of their mother in some few weeks back.The guy told me she is  left with 12 years mortgage on the property to pay the bank.

You'll have access to owner occupied loan products, therefore saving on your down payment, typically 3-5% compared to 20-25% for non owner occupied properties.

Thanks What loan product are you shopping for?