My husband and I stayed at Scott's place for 3 nights. It is a comfortable studio apartment perfect for two people, including your own private courtyard. We found it great to come back to after a long day exploring San Fran! Also, if you walk to the very top of the hill past Scott's place, there is an amazing view of San Fran!
It is conveniently located, with buses just around the corner on Mission that will take you right into Downtown. Buses are $2 per trip from memory or if you are going to be catching the cable car a couple times it's worth buying the day pass for $15 which you can get from the hardware store just around the corner on Mission. Also, finding a parking spot can be challenging in San Fran so only use a car if you really need to.
Scott's place is also close to some fantastic places to eat and drink.
There are quite a few dive bars on Mission but if you're looking for great food try Bernal Heights as there are some fantastic restaurants up there!
If you're looking for more alternative shopping, vintage clothing, art galleries and coffee shops, try Valencia down near 19th and 20th.
Scott was a wonderful, friendly host who met us when we arrived and ran us through everything. He's happy to answer your questions and has some great tips on where to eat and explore.