Looking for D24T with a manual trans!

[Jason]

Looking for a manual trans car, or everything to change over the auto. Not in a huge rush, the auto is fine, I just enjoy driving a manual much more... If its the whole car, it has to be a sedan, my wife wont let me get a wagon. (her parents had one and she has bad memories of diesel smell and lots of smoke, I'm lucky I got to get the sedan!) I'm only interested in stuff half way close to St.Louis, Mo.

Thanks,
Jason