I created this site while employed as the webmaster for this company. They built and reconditioned very large diesel engines for large machines and generators. I built a database for this site to track their entire inventory and to keep track of prices.
Here is what the main inventory area looked like. The inventory was listed in a summary format. If the customer was interested in something they could click on the item itself and it would take you to a page with more information and several pictures of the item. An example of this detail screen is below.