Kiki's apartment is an excellent place to stay if you're visiting SF. It's a large apartment with plenty of shared space, and plenty of facilities (kitchen equipment, lounge area, TV, stereo, blankets for sitting on the roof terrace, etc.). The view of the bay from the kitchen windows never gets boring!
The apartment is located close to Fisherman's Wharf for tourist activities (boat, bike and bus trips), and is also close to some nice local areas (Nob Hill, Russian Hill) with great shops, restaurants and bars.
The apartment is on a really steep hill, so be prepared to do some walking up and down. If walking isn't your thing, there's loads of Uber cars servicing the whole of SF.
A little tip - if you're a light sleeper, take some ear plugs, because the street outside can be a little loud with road noise at night snd early in the morning.