Fortunately, San Diego has outstanding historical rent appreciation.  

If the mortgage being foreclosed upon is in first lien position, meaning any other outstanding mortgages were recorded AFTER the mortgage in default, then all the liens that appear of record after the foreclosed mortgage are removed and do not transfer to the new owner.

For example I know down in New Castle County, Delaware that a tax sale will wipe out any other liens, however...if you simply buy a bank owned foreclosure at the auction...you still possibly have to pay the back taxes and outstanding utility bills and fees.

@Alex Chau Prices in the bay area are outstanding.

I'll post screenshots of the damn PDF to prove my point.

But noticed nothing outstanding.

35802 is an outstanding zip code. . . except for the condos near Golf Rd, which is clearly what you are referencing. 

If you want to BRRRR a small multi in Columbus plan on most likely having a 6 figure rehab budget or damn near it, and expect to spend about $150K-$200K for a duplex that needs gutted. 

In addition, they have experienced outstanding appreciation resulting in a great ROI. 

@Wilson LeeDamned if you do, damned if you don't.