Water is now leaking through the ceiling into my tenant's unit, and it's worsening with every rain also the neighboring unit has sever water damage (like a pool inside and it is owned by the HoA) and water from it leaking very dirty water from the shared wall to mine.

Are you aware that over 80% of Wall Street / Stock market companies DONT last that long?     

The only big issue I ran into is on of the basement walls needed extra support, I don't think a newer build would have that issue. 

they said around 90% of market value.I tried to get them to understand that this property needs a LOT of work, almost a full gut, some holes in walls (small) old carpet needs to be ripped up, i mean like the works on this thing, you can prob get away with touching up the kitchen since its real hardwood and the bathrooms as well but this prop needs at least 80k.Found out owner actually owes 140k on property, and zillow is zestimating it to be 127k.

In our student houses we use a programmable thermostat, but our building monitoring system has its own sensors and can override the wall thermostat and will not allow the temperature to get below 10C (50F) ... we are presently testing a new software load that will also prevent them from cooling the house too far in the summer.

However the thermostat is mounted  to the wall a few feet from the front door in a highly accessed retail store where the door is constantly opened.

For example, the 2nd to last photo of a random wall and floor with part of open door; what is that supposed to be telling?

They are far more common now and harder to find models without but:1) these add cost to the purchase price2) they don't bring a lot of value3) they can leak or detach and damage the propertyI own around 50 doors and I cap off the line at the wall or in the basement with a valve and a cap so the potential for leaks is 0.00001% :-) 

Sorry for the long winded back story, but end game is to put a A frame on the existing 20x40' stem wall above near where I"m standing, and put some stairs into a drop down area below for chairs/fire-pit overlooking the river canyon below (but out of view) under where the drone is flying.

The grout between the tiles allows a run off of water and a gripping surface for your feet.3. if you’re smart, use durock on the walls too, right up to the ceiling.