I traveled to SF to compete in the Escape from Alcatraz Triathlon, and this place was absolutely perfect. It's a cozy little studio within walking distance from everything you need.
Don't let the small size scare you. My sister and I were very comfortable. I had a large suitcase and bike bag with me that easily fit in the closet. The kitchenette was perfect to make small meals and pre-race snacks. I was able to do a practice swim in Aquatic Park, and walk my bike to the race venue. The host was very accommodating and let me use his hose to wash off my muddy gear after the race.
My sister and I dined out several times just down the street where there were many restaurants. Ghirardelli Square, Pier 39, and Fisherman's Wharf are all within a 5-10 minute walk. This place is a true gem and perfect for anybody that wants to get out and explore.