Loved it! The secret lounge had everything we needed and was very cozy. The neighborhood was great with plenty of great food within walking distance. David and Tina were great hosts, providing plenty of great tips for the area. I would recommend this to anyone looking to stay in the San Francisco area.
Note: we had a car so I can't speak to how easy getting to the popular tourist spots like the bridge, Fisherman's Wharf, etc would be by public transit but they were a 20-25 minute drive from The Mission District.