Overall great place to stay, with great host, convenient access to attractions and shopping. Would be easy 5+ stars if a few issues below were addressed.
Let's start with the long list of positives:
The location of this place cannot be beaten. Looking from the balcony or from the living room, you get a great view over the bay with Alcatraz right in front of you. It's only a block and a half from Ghirardelli Square, and within walking distance of Fisherman's Wharf, including Pier 39. It's right between two cable car turnarounds as well, and both grocery stores and pharmacies are close by.
Additionally, Robert was a very kind and accommodating host, helping us out with our every need in a very timely manner from start to finish, including storing our bags till the evening of the day we checked-out.
...and a few negatives:
The cleanliness of the apartment left something to be desired, most notably in the sheets and towels. The sheets could have been cleaner, some had stains, and most towels were in need of a replacement. The carpets, as much as not as important for us left something to be desired in terms of cleanliness. There was also a slight odor in the apartment which required scented candles.