There's one big downside to this property, but let's start with the positive. One, the apartment is very spacious, it has three full sized bedrooms, a living room, a kitchen and 1.5 bathrooms. Each of our kids had a room of their own. Two, it's quite isolated (in the good sense). You get the entire 2nd floor of a detached two storey house, and the first floor looks uninhabited, so basically you have the house to yourselves. Three, location. We needed a "base camp" for exploring San Francisco, and this place was perfect, we could reach places like downtown or Fisherman's wharf in less than 30 mins (note: we were using our own car, so don't know what the situation with public transport is). This is the closest you can get to SF without actually renting a property within the city (which would be much more expensive). The San Bruno area itself, while not interesting for tourists, has a lot of shops and restaurants (there is what looks like a good Mediterranean restaurant literally next door, but unfortunately our schedule didn't let us visit it). The apartment is also very close (5 mins drive) from the San Francisco airport. It wasn't a factor for us, but might be for others. Four, the hosts were very responsive (more on this below), and provided some nice touches (such as welcome snacks, and the dishes being washed by someone invisible while we were out and about).
Now to the downside. ***The apartment is freezing cold***. We visited in December, and, if we understood the host correctly, the heating system was broken. I don't know when they're going to fix it, but I wouldn't advice staying there until they do. We had to move around wearing our jackets and sleep under three layers of blankets. To be fair to the hosts, they provided space heaters, and when we complained that this wasn't enough, they brought more heaters and blankets. This made our stay bearable, but definitely not enjoyable. On the bright side, thanks to this, we got to be outside and explore the city more than we had planned :)
Besides the heating problem, the apartment is somewhat ramshackle. Things mostly work, but there were some issues with the amenities. For example, of the four burners on the range, only one ignited properly. The TV is quite old, and not of the smart variety. Also, on one evening a fuse blew several times (probably due to excessive use of heaters). Again, to be fair to the hosts, they arrived promptly and showed us the fuse box (it was on the first floor).
Separate note on the noise situation. As I mentioned, it's very close to SFO, so you can hear the planes. It's also located on a busy street, so you get the noise from the cars too. It wasn't a major problem for us, probably because we were out most of the day and came back quite tired. But if you're sensitive to noise, this is something to consider.