I was even looking at 4 unit multiplex in Oakland, CA since I'm from the Bay Area so I can easily manage it myself but that place is such a mess. 

Buyers get spooked easily, plus every year the process gets more complicated with financing, appraisal and inspection issues (which can vary from lender to lender) that could be easily overcome threatening to crash deals without someone experienced in there herding all the "cats" (lol- elements) in the deal to a successful close of escrow.Also most of those comps you are seeing-maybe even all of them- have had a commission and some fees paid by the seller, and the appraisors are aware of that.I hope your home sale goes smoothly.

Having leaving leases line up so that any future owner can easily move in or even get financing is ideal.

The odds are against us since the seller could easily list their property via traditional means in 2yrs when they retire.

Excel can easily do all this.You can likely download a free template that already has all the formulas you need.

The savings in cost and time could easily pay the financed payments for the machines and provide good return.  

Yes you can easily cash out refinance these properties into a DSCR loan.

Well if foreclosures are motivated, and AI can easily find people in foreclosure, in 3 seconds, this means that AI can target motivated sellers.Wrong!

There is very little easily build able infill left. 

We're still a small enough city that you can easily discern the path-of-progress (POP) when a neighborhood is getting "squeezed" by adjacent areas that are growing/renovating quickly.