As someone in the bay area in a SFH, I can tell you that in my neighborhood that is incorrect. People are incredibly aware of zoning, it isn't obscure, and people obsess over it in the neighborhood groups and lists.