This is an example of a product with one image attachment. Hover over the product image for a larger version. The script used is called Magic Zoom.
You are not restricted to this particular effect. You can choose between 4 different effects including jQzoom and Lightbox as well as no effects at all!
Remember that you have full control over the image sizes from the theme settings. The Tabbed sections you see at the top of this content area are entirely customizable.
You can have any from 1-5 different tabs, specify the title and add any content you like. Yes, the content areas are widget ready too.