I stayed for 6 weeks in Sterlings place in Hayes Valley. The place itself is amazing, bed super comfortable, shower great, kitchen fully equipped, couldn't wish for more. The neighborhood is one of my favorite ones in SF, right next to Alamo Square and within a 5 minute walk of the shops on Hayes Street. If you want, even The Mission is within walking distance.
Sterling as a host was super communicative and very nice. I can only recommend Sterling as a host and this place to anyone who is visiting SF (I actually already did to my colleague who will be in SF soon)