We stayed at John's place for several months while renovating our own house in the City.
This apartment would work well for anyone coming into town for business or pleasure. It's comfortable, clean, safe, and has nice views out towards one of the hills.
The location is great: walkable to core transit services (BART, Muni) as well as a cluster of restaurants and other amenities. If you're driving down the Peninsula, the freeway is close by, too. When we stayed there, we were given an off-street spot, but parking is pretty easy in the neighborhood.
The internet worked great (we had no trouble taking video conferences when working from home), and there's an Apple TV and a smart TV that you can hook up to your own Netflix or Amazon Prime if you're staying long enough to bother.
Overall, we liked it and would recommend it to others.