We stayed for 6 nights.
Pros
Great location with buses and cable car stops around the block. Managed to go everywhere on public transportation.
Beautiful and very well equipped house. It was great to see the beautiful life style of a local SF couple.
Cons
We did find the cable cars to be noisy at late night and early morning but we also considered this as a privilege of living in a convenient location in San Francisco.