Had a very nice stay in the Mission District of San Francisco. The apartment is located very close to the Bart and multiple other public trans options. You'll find everything you need from a cozy living room to a comfortable be. Kitchen is equipped for basic cooking if you wish. Check in and out were easy and convenient.
You will hear some street noise from passers by so be prepared for that. The neighborhood is very diverse and colorful, so don't be surprised to see trust fund hipsters and street junkies alike within a few blocks.
There are literally dozens of great Mexican eateries within a few blocks, so be sure to check those out. The area really comes to life at night with plenty of great bars and restaurants within an easy walk.