Uhhh if you can find a good northwood 478 for retail post it here because I might like to upgrade it. At this stage in the game I would recommend northwood if you can find it, prescots run hot and I mean there really isn't much opportunity for you to upgrade from there.
actually.. i have another question.. how much better are celeron d's compared to the regular old... celerons.. because this is just going to be a family type comuputer.. so maybe a celeron d would do well
actually... prescott is the better choice... the stepping is better and the L2 is usually better as well... yea they run hot but the performance is better. get a decent cooler and your set. You can still find the 3.0-3.2 Prescott's around... hard pressed though is the 3.4's... Though were the last ones to be made... 16k L1, 1M L2 stepping 4 hyper-threading, etc... I've got one of those right now and it still performs... of course not like my game machine, but it's still pretty quick.
Prescott.............I've been running a prescott 3.0gig with 1mb L2 cache and it is extremely stable and realatively cool for an Intel chip (46 degrees under full load). The northwood core is not HT while the Prescott is!! BTW, it is not a gaming machine...used for project studio recoding.