Good places to start that are fairly close to SFSU:

Sunset (Inner or Outer)* : Inner is my area. Outer is a little less dense and a little less supported by public tranny.
Richmond (Inner or Outer)* : Used to live in outer. Nice area.
Lauryl Heights : Nica area
SFSU/Stonestown area : Tends to be tilted more towards a younger student population. Not a lot of inventory in this area
Parkside : jr0n's area. Also known as outer sunset since it really is a subset of the outer sunset area.

* Inner tends to be more compact closer to the city and outer is more suburban and some may say remote.

Avoid like the plague:

Ingleside
Bayview
Hunters Point
Tenderloin

Also check out this sweet Map I made for you. Call for more four11.