Home | Contact Us | About Us | Shipping & Returns   
  Antique sterling silver specialists. American and English silver, Tiffany, Jensen and more.

Flatware, silverware, hollowware, complete sets, rare items, serving and accessories.

Leonce Antiques & Consignments ~ 1435 Post Rd East, Westport, Connecticut 06880
Quick Find
Advanced Search
 Andirons and Fire Related
 Canes & Umbrella Stands
 Nautical Antiques
 Out of the ordinary
 Sterling Silver Flatware
 Sterling Hollowware
   Sterling Accessories
   Sterling Ashtrays
   Sterling Baby Items
   Sterling Baskets
   Sterling Bowls
   Sterling Boxes & Cases
   Sterling Bread Baskets
   Sterling Candelabras
   Sterling Candlesticks
   Sterling Charger & Plates
   Sterling Cocktail Shakers
   Sterling Coffee Pots
   Sterling Compotes
   Sterling Covered Entrees
   Sterling Creamer/Sugar
   Sterling Cups & Goblets
   Sterling Desk Items
   Sterling Dinner Bells
   Sterling Flasks
   Sterling Gravy Boats
   Sterling Jiggers
   Sterling Match Strikers
   Sterling Napkin Rings
   Sterling Nut Dishes
   Sterling perfume bottles
   Sterling Salt & Pepper
   Sterling Sugar Castors
   Sterling Tea Caddy
   Sterling Tea Pots
   Sterling Tea Sets
   Sterling Tea Strainers
   Sterling Tongs
   Sterling Trays
   Sterling Trophies
   Sterling Vases
   Sterling Water Pitchers
   Sterling Wine Items
   Sterling Rare Items
 Shop By Initials/Name
 Antique Furniture
 Antique Lighting
 Antique Porcelain
 Other Antique Items
What´s New more
Gorham Sterling and Cut Crystal Pitcher
Gorham Sterling and Cut Crystal Pitcher
Shopping Cart more
0 items
3 - Error writing file '/tmp/MY5Mf5Uc' (Errcode: 28)

select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '36' order by pd.products_name limit 0, 999999