I've been there and this has been my solution. 1 fix plumbing issue2 spread lime (garden lime) thickly over affected area.3 let nature take its course our Florida sand sucks up moisture and nutrients in no time.

Depends on your soil type and moisture. 

If it's remediated then it is essentially gone unless the moisture comes back (that's the more serious problem; is the water leakage fixed?).

.-  Basement has an obvious moisture problem.-  Subfloors are saturated with moisture at some parts, leading to wood rot, fungus/mold, and obvious safety issues.-  The floor unit above the basement's problem site has a concerning issue with floor sloping/alignment.

How do experienced investors view things like water/moisture in the basement of a property?

A simple way to know that the members have been dried enough is to invest in a non-intrusive moisture meter and gauge the moisture content.

It backs to rt 59 and is very loud and I heard there is issues with the stucco and moisture that has got behind the walls.

In a market that only has 30% market penetration, zoned so "Stupid" money will have a hard time moving in. 

I'll just run through a list of where I'd look first:Occupancy and ADR penetration vs. comp set - is there room to improve revenue?

Anything requiring penetrations, moving electrical, moving plumbing, HVAC, wiring up of overhead lights and extra outlets, etc.5.