Take a look of this configuration, all the prices are from Newegg
Intel Core 2 Duo E6400 Conroe 2.13GHz LGA 775 Processor Model BX80557E6400 - Retail $237
Intel BOXDP965LTCK Socket T (LGA 775) Intel P965 Express ATX Intel Motherboard - Retail $119.99
Mushkin 2GB (2 x 1GB) 240-Pin DDR2 SDRAM DDR2 800 (PC2 6400) Dual Channel Kit System Memory Model 996527 - Retail $214.99 ($199.99 after $15.00 Mail-In Rebate)
XFX PVT73GUGD3 Geforce 7600GT 256MB GDDR3 PCI Express x16 Video Card - Retail $149.99
Seagate Barracuda 7200.10 ST3250820AS 250GB 7200 RPM SATA 3.0Gb/s Hard Drive - OEM $79.99
Pioneer 16X DVD¡ÓR DVD Burner With 5X DVD-RAM Read Black ATAPI Model DVR-111D - OEM $31.99
Creative Sound Blaster Audigy 4 SB0610 7.1 Channels PCI Interface Sound Card - Retail $71.95 (Optional, you can have the onboard audio instead of it.)
Antec Solo Black/Silver Steel ATX Mid Tower Computer Case - Retail $89.99
Total Cost is $995.89 and shipping cost is not include yet. But I am pretty sure that you can buy this configuration cheaper at somewhere else and the prices will be dropped a little bit lower if you are not going to buy it now. I hope this configuration is good enough for you.
Edit: Oh, btw, I just noticed that the case didn't come with a power supply, but you can look for the case that you like on Newegg, choose one come with the power supply, and maybe it will save you a little bit money.