I moved to SF in 2009 and there were very few tech companies in town and it was in the middle of recession. Even then good places had a bidding war. If you read this Bay Area housing market report[1], you will see that it still showing strength in SFH market. My guess is SF will continue to do fine
[1] https://www.bayareamarketreports.com/trend/san-francisco-hom...