While you are looking for more permanent housing, try http://www.couchsurfing.com/ . People offer up spare sleeping space for free. Should let you see where in the bay area you want to stay.