Currently, I live with 2 wonderful people in one of the best neighborhoods in the city. It's where the Mission meets the Castro meets Noe Valley.
Public transport to anywhere in the city is a breeze, and the highways are pretty close.
Food and bars in these neighborhoods are pretty impossible to beat... anywhere.