I'm local to the Bay area and I stayed here for a weeklong event in Oakland to save me the commute across the bridge. This location is so great I'm really glad I did. The unit is unfussy and unpretentious, clean and comfortable it feels a little tight (there's not a lot of "extra" space), but both bedrooms are pretty decent and I was able to study and do my daily yoga in the common room/kitchen. The sofa is cozy and fine for a few hours of working if that's your thing.
I never encountered the neighbors but they were always laughing and sound (through their front door when I was coming and going) like nice people. I want to mention one thing -- there was at least one night when evidently they busted out a karaoke machine. Again they were having lots of fun and it wasn't annoying drunk karaoke, it was a family including kids. And this might not be any kind of issue for most people but I am usually asleep by 9pm. I was able to get to sleep and honestly thought it was cute, but it might be an issue for some.
I want to emphasize this place is extremely close to Bart and the freeways and bridge and if you need to get around Oakland there's hardly a better place to be situated.
There's not much of a view to speak of unless you like the view of the Oakland lowlands with the temple off in the distance and quite surprisingly you could hear, faintly, roosters around 5-6AM. Oh, Oakland. How I love thee.
Charming little place, would be quite happy to stay again.