I thinik a lot of municipalities are going to face money issues now and in the next few years where it will be too counterproductive to ban STRs (even if thats what the particular constituency wants) and give up the revenue

Thank you, this is EXACTLY what I was looking for, particularly the zoning bit.

I've been eyeing a particular 3 unit multifamily in Union City for a while, to by as an investment. 

Buying a home is the bay area retirement planYes, there are a lot details and differences for everyone's particular situation.

It varies a lot by market, guest type and even the neighborhood and type of home within a particular market.

Investing in real estate, particularly through avenues like foreclosures and tax sales, indeed requires a solid understanding of multiple aspects, including legal considerations.

There’s a real opportunity to hit those $1,500 to $2,000 rent ranges, particularly for updated homes or new construction (built to rent homes) in the right neighborhoods.

Build an SMB on top of your real estate (the reverse of #2)Short-term rentals and high owner-participation real estate businesses can have great returns.Obviously not for you if you just want passive RE.We are in the deep end here, where each case should be judged on its own facts and merits by your CPA.You should hire a professional to review your particular situation before you make an investment.

Have you thought about targeting mid-term rentals, particularly given the med school proximity, or STR given the hotels nearby?

I mostly agree with your philosophies, particularly around efficient investments.