We had a great time at David's place! It is a couple of blocks away from both Cole Valley and Haight Street, which means about 15-20 restaurants within walking distance. It is also close to the N line, which we found to be a great way of getting around -- you can be at Union Square in 30 minutes. Golden Gate park is nearby, which is nice when traveling with a young kid: playgrounds, the Academy of Sciences, the Conservatory of Flowers are all within a mile.
The Internet was fast and stable and there is a big TV (50"?) with every conceivable streaming app. This was great for the occasional lazy afternoon.
The place was quiet both at night and in the morning, so it should fit every sleep schedule.
If you're renting a car, street parking can be a hassle. There are a few streets nearby which are not covered by permits. Be sure to check the parking permit area map!