If you don't want CoD, consider a $214 shipped OEM 9800 Pro @ NewEgg. It'll be faster than the 5900SE in every way, especially in future DX9 games.
If you want CoD and that PNY price is before tax, consider a
$214 OEM 9800P +
$30 OEM CoD = $234 shipped @ NewEgg instead. (OEM means NewEgg warranties the product, not the manufacturer. That means one year for the 9800P. I'm not sure about CoD, but it's two CD's--make a backup copy to CD-R's or your HD and you'll be set.) You end up with a faster, more future-proof card and the same game for about the same price. The only con is a lesser warranty, but I don't think the card will fail unless you OC it (and maybe then only if you OC it severely).
If you want CoD and an nVidia card, then I think these are your two best options:
1. If both prices are total (including shipping &/ tax), go with the PNY,
2. If the PNY price is tax addtl., then I'd go with
this MSI 5900XT and that OEM CoD. You get VIVO and extra games and a known quiet, one-slot cooler.
BBA = Built By ATi. Sapphire builds ATi's cards, so that's why so many ppl recommend them (same card with lesser warranty for usually much less).