Basic Product
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.