We spent five nights in John's house. It was in a fantastic location for sightseeing, dining and experiencing all that San Francisco has to offer.
John provided us with advice prior to our arrival (how best to reach his house, whether we would need a hire car and availability of nearby supermarkets) and was waiting for us as arranged. The house was equipped with all you would need (including a washer and dryer and modern appliances) and was very clean and comfortable. There are LOTS of dining options within walking distance as well as two nearby supermarkets for supplies etc.
We would definitely choose to stay at John's house again when visiting San Francisco.