I was a visiting scholar at Stanford (main campus) for 3 months. The accommodation was just perfect for my needs with a great host family and the location standing out as main positive features. Also, for me there were no real downsides with the accommodation.
The location was great and very convenient with 20 min biking / 4$ Über / 1 hour walk to campus. For me the nice biking / walking paths made a great difference.
All the basic things (towels, bathroom, linen, coffee in the morning, wifi etc.) worked without any complaints. While the room was small, it was more than sufficient for my needs, specially considering the nice yard that I had access to if I was home during some weekend. The room never was too hot during the late summer (when it was unbearable outside).
While I was away working most of the time, when I was at home while the host family was awake / around they were very friendly and open and really made me feel at home. I learnt a lot about life in Palo Alto / California while discussing with the different family members. In addition, they put an extra effort into making the house nice for the Holidays with great decorations. In my case as a foreigner it gave me a great opportunity to see what their celebration of holidays such as Halloween was all about.
Their dog is just great and I will surely miss him.
Overall I can really recommend the place for staying a few months at Stanford or some start-up / internship in Palo Alto, specially if you value location and nice and friendly hosts.