This is the only decent site for sound effects I've been able to find thus far. Some of the stuff sucks but some is relatively actually pretty good. I think you have to register to download. Most of the stuff I think is under Creative Commons license as well.
I'm now trying Sounddogs. Will give this a try too. Thanks
Update : Wow. the site you gave me is waaay more useful. THANKS!
Edited by graphidz - 11/10/12 at 10:29am