First hand accounts re older properties. All Bay Area cities have to follow mandatory orders for building quotas from a Bay Area organization called ABAG. They advocate high density new developments.

Re newer developments, here is an example: https://www.lennar.com/new-homes/california/san-francisco-ba... : plan 5, icona. Three stories, 2300 sq ft built area approximately. 1.2ish million.

On a related note, I browsed that random google link and clicked on ‘home automation’..basically it’s an Amazon home. Alexa would run your household. I am not sure if that’s a good thing or a bad thing.