And I don't mean a simple onmouseover effect. I am talking about those flash-based where you can click zoom-in, and it will zoom-in on the specific area of the photo.

Example: http://www.veer.com/zoom/