On the Alexander Furniture Agencies website, I used a Joomla extension call Art Sexy Lightbox to do the photo displays throughout their site as seen below: Art Sexy Lightbox can be bought for $20 and is one of the first Joomla extensions that I purchased because it was easy to implement and did exactly what it said it would with a decent amount of customization. There is a great demo site that they have set up to show you what the extension can do.
Developer Blog