However, if you look around the better areas of Mt View, Cupertino, Sunnyvale, Santa Clara, and even West San Jose you will discover many neighborhoods with these units that are very well maintained.
I have recommended for many years that first time and other younger buyers as well as aging buyers consider buying 2-4 units as their primary home. That will allow their tenants to pay a sizable portion of their mortgage payment and even in some cases paying all of their payment allowing the owner to live almost free! That is a wise move. I know some families that started out that way years ago and are now living with very large monthly incomes from their long term purchases of small income properties.
My company specializes in investment property of all types especially foreclosures and other distressed properties. Please be aware that financing a 2-4 unit property is the same as financing a single family home. Above 4 units becomes a commercial property. Please contact me if I can be of service to you.