Can anyone recommend a programmers' editor? I'm looking for a programmers' editor. I know Xcode and I use it for application programming but I'm looking for something that will:


Syntax highlight PHP, SQL, Javascript (including jQuery) and CSS not required but would be nice; also Lua, Python, and Perl   
IntelliSense type stuff, start typing and get all the functions/objects/variables it could be and any parameters. Xcode does this well for C/C++/Objective-C but looking for languages that are listed above.
Would be nice if it worked with projects and not just files   
Integrated with SVN, CVS, or GIT
Had upload-to-server functionality built in


I am aware of Coda but am looking for other options before I drop 100 bucks.
TextMate

Doesn't address all of your needs but I think it's pretty snaz.