Does Red Hat Fedora support Nvidia card 8800GTX and 260 card?
Does any Linux OS support Nvidia card?
In general yes, see here. For the specific card check the Fedora's hardware specs, or respective mailing list / forum. Fedora Project and Red Hat are different, although they share common roots.
If you can't find definitive answer, try LiveCD onto your hardware, and see how it works.