ASUS has opted to use the exclusive Glaciator heatsink/fan combination which looks good. We also see towards the back of the card another heatsink that helps keep some of the other warmer components as cool as possible.
While we don't have any memory sinks, with the fin design on the cooler the air is pushed directly out of the heatsink and over the memory modules.
As far as card features go we see nothing more than what's found on a standard 8800GT or any other mid-range NVIDIA card. We have a single PCI Express connector located towards the back of the card, while if you peak over the cooler you find a single SLI connector.
We then of course also have our two DVI connectors and single TV Out connector.
As you can see below, the 8800GT 1GB from ASUS comes with nothing more than the stock clocks.
A 600MHz core, 1500MHz shader clock and 1800MHz DDR memory clock.