We’ve just returned from a 6 night stay at the Garden Retreat. It was a perfect location for us as it is a peaceful neighbourhood away from downtown, but all the sights were easily accessible by public transport - about 15 mins on the metro.
Cole Valley is nearby with some great places to eat and it only takes 30 minutes to walk up to the Twin Peaks viewing point for unparalleled views of the city.
Can’t recommend the area and the accommodation enough.