If you're doing a lot of electrical work, you might need to redo your panel and put in grounding rods in the yard.

I did this type of work for several years.This is from 9 months ago, however, the "B Box" is really a valve in the front yard with an access pipe on top of it that can be manipulated with a valve key. 

Their biggest advantage is the houses and yards and the weather are all nearly ideal for zero maintenance.

Does anyone know of a company/person that would take care of the details like yard maintenance, cleaning/laundry and any other details related to AirBNB that I'd be able to use remotely from out of state to care for the property?

You need to forget the whole "lot value" thing, particularly since your contractor now says the house can be salvaged.

Large yard that is .8 acre with garden, deck, and basketball court. 

That's a bummer re: the HPR zoning and codes - while on the one hand, I understand, since the yard area is common, that's a tough situation for those who bought thinking they'd be good to go under the regulations.  

Rental turns, property maintenance, rent payment management, renter issues management, etc. all were too much for me to manage on my own.From a maintenance perspective, in a single family home, the tenant can be responsible for the yard upkeep, weekly garbage pickup, etc.

Tenant pays for individual yard up keep, electric, internet & TV.

I owned it that way for over 25 years before selling, and it appears to be an easement that all neighboring property owners give to form the alley, an alley for access to the back yard of 10 attached properties.