We can strongly recommend the 2 bed room apartment on San Carlos Street!
1) GREAT location! Valencia Street - with all its restaurants and bars - is just around the corner. Further, the Bart station (to get to the city) is just a 5 min walk away. If you want to stay in the Mission you can't get a better location.
2) Perfect condition. Nice kitchen, bedrooms and bath room. And the apartment feels much bigger than the picture shows. We also appreciated the backyard a lot during sunny days!
3) Reliable hosts: Brian and Leah answered all our questions immediately. We definitely felt we were in safe hands!

If/when we come back to SF this apartment will be our no 1 choice.