Sasha:
There is a difference between SATA and eSATA in terms of connectors. Motherboards and SATA drive mechanisms come with SATA ports. (As CM noted earlier, all modern motherboards come with SATA II ports.) These are for internal connection of SATA drives. When external SATA enclosures first appeared they had the same kind of connectors as those on the drive mechanisms and motherboards. Experience showed that these connectors were not robust enough for external enclosures where they would have to survive repeated insertions and removals of cables. As a result a new kind of connector, eSATA, was developed for external SATA drive enclosures. External drives housed in eSATA enclosures can be run from the motherboard by wiring some of the SATA ports on the motherboard with SATA to eSATA cables - - the eSATA end of the cable being attached to an open slot on the rear of the computer. The device pictured at
http://www.usb-ware.com/sata-dual-internal-esata-adapter.htm
is an example of this kind of device.
(The MacPro has two unused SATA ports on its motherboard, Newer Technology makes a similar device, called an eSATA extender cable for connecting these ports to an empty slot on the back of the computer. However, installation is, reputedly, a delicate affair and the drives cso connected do not have hot swap capability.) You can see this device at: http://eshop.macsales.com/item/Newer%20Technology/MPQXES2/
After installing the cable from motherboard SATA ports to an eSATA connector affixed to an empty slot on the back of the computer, an eSATA to eSATA cable connects to the eSATA ports on the computer. Alternately, you can purchase a card PCI-X or PCIe SATA cards with external eSATA ports. Either solution would allow you to use external drives such as the Seagate Free Agent Pro drives you mention. However, connecting to ports on the motherboard may not - - as is the case with the MacPro - - allow you to hot swap drives in an external enclosure, while most SATA cards do allow hot swapping.
You don't mention what kind of computer you have or whether whether it has free PCI-X or PCIe slots, etc. This would be important information to know when advising you. I am also not familiar with card you mention. If you have a Mac (or even if you don't - - since all enclosures and most cards will work with Windows machines or Macs) there are comprehensive reviews of SATA cards and enclosures at www.amug.com.