Multi family house hacking in the Bay area

[Kanti Pudipeddi]

Hello All , 

My husband & I recently moved from the midwest to Bay Area California. Currently we are renting a place but would like to get a house once our lease is up . We cannot afford getting a single family home as of yet so have been considering getting a multifamily (Duplex) and do a house hack. 

Looking for some advice ,on the following :

- Is it a good idea to house hack in the bay area 

- Locations with possibilities of getting good rental income 

Appreciate your help!!

TIA