Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Waterford Huntley Stemless Red Wine Glasses, Pair
Waterford Huntley Stemless Red Wine Glasses, PairSale
Item # 40030853
Pair Now Only $69.00
Waterford Crystal, Lismore Roly Poly Glasses, Set of Four
Waterford Crystal, Lismore Roly Poly Glasses, Set of FourSale
Item # 136673
Set of Four Only $200.00
Waterford Crystal Huntley Toasting Flutes Pair
Waterford Crystal Huntley Toasting Flutes PairSale
Item # 40016158
Pair Only $79.00
Waterford Crystal Huntley 6" Vase
Waterford Crystal Huntley 6" VaseSale
Item # 40009187
Now Only $39.00
Waterford Crystal, Huntley Irish Coffee Glasses, Pair
Waterford Crystal, Huntley Irish Coffee Glasses, PairSale
Item # 40030850
Pair Now Only $79.00
Waterford Huntley Stemless White Wine Glasses, Pair
Waterford Huntley Stemless White Wine Glasses, PairSale
Item # 40030845
Pair Only $69.00
Waterford Crystal Grant 10" Vase
Waterford Crystal Grant 10" VaseSale
Item # 40011235
Now Only $69.00
Waterford Crystal Grant 10" Bowl
Waterford Crystal Grant 10" BowlSale
Item # 40011234
Now Only $69.00
Waterford Crystal Praying Cherub
Waterford Crystal Praying CherubSale
Item # 156236
Now Only $59.00
Waterford Crystal Round Ring Holder
Waterford Crystal Round Ring HolderSale
Item # 40034378
Now Only $39.00
Waterford Crystal 9" Sailboat Sculpture, Clear
Waterford Crystal 9" Sailboat Sculpture, ClearSale
Item # 40027993
Now Only $79.00
Waterford Heart Ring Dish
Waterford Heart Ring DishSale
Item # 1052564
Now Only $39.00
Waterford Crystal Lion Sculpture
Waterford Crystal Lion SculptureSale
Item # 1050409
Now Only $99.00
Waterford Humpback Whale Sculpture Paperweight
Waterford Humpback Whale Sculpture PaperweightSale
Item # 1050407
Now Only $79.00
Waterford Crystal Huntley Balloon Wine Glasses, Pair
Waterford Crystal Huntley Balloon Wine Glasses, PairSale
Item # 40033505
Pair Now Only $79.00
Waterford Crystal Huntley 8" Flared Salad Bowl
Waterford Crystal Huntley 8" Flared Salad BowlSale
Item # 40033513
Now Only $99.00
Waterford Bolton Crystal Decanter
Waterford Bolton Crystal DecanterSale
Item # 40030927
Now Only $149.99
Waterford Huntley Brandy Cognac Glass, Single
Waterford Huntley Brandy Cognac Glass, SingleSale
Item # 40033465
Now Only $39.00
Waterford Huntley 6" Footed Bowl
Waterford Huntley 6" Footed BowlSale
Item # 1052559
Now Only $49.00
Waterford Crystal Tracy Nut Bowl
Waterford Crystal Tracy Nut BowlSale
Item # 1052579
Now Only $39.00
Waterford Crystal Normandy 10" Vase
Waterford Crystal Normandy 10" VaseSale
Item # 40015223
Now Only $89.00
Waterford Bolton Crystal DOF Tumblers, Set of Four
Waterford Bolton Crystal DOF Tumblers, Set of FourSale
Item # 40030928
Now Only $99.99
Waterford Crystal Huntley Square Whiskey Decanter
Waterford Crystal Huntley Square Whiskey DecanterSale
Item # 40033503
Now Only $149.00
Waterford Crystal Huntley Juice Pitcher
Waterford Crystal Huntley Juice PitcherSale
Item # 40033508
Now Only $69.00
Waterford Crystal, Westbridge 10" Crystal Vase
Waterford Crystal, Westbridge 10" Crystal VaseSale
Item # 40031018
Now Only $149.00
Waterford Crystal Huntley Pilsner Beer Glasses, Pair
Waterford Crystal Huntley Pilsner Beer Glasses, PairSale
Item # 40033506
Pair Only $99.00
Waterford Crystal Huntley 8 1/2" Bowl
Waterford Crystal Huntley 8 1/2" BowlSale
Item # 40024501
Now Only $59.00
Waterford Crystal Daisy Floral Votive, Single
Waterford Crystal Daisy Floral Votive, SingleSale
Item # 1052628
Now Only $29.00
Waterford Crystal Rosalee Ring Bowl
Waterford Crystal Rosalee Ring BowlSale
Item # 1052624
Now Only $39.00
Waterford Crystal, Eastbridge 8" Crystal Vase
Waterford Crystal, Eastbridge 8" Crystal VaseSale
Item # 40027693
Now Only $99.00
Waterford Crystal Huntley Round Whiskey Decanter
Waterford Crystal Huntley Round Whiskey DecanterSale
Item # 40033504
Now Only $149.00
Waterford Crystal Huntley Lola Vase
Waterford Crystal Huntley Lola VaseSale
Item # 1050317
Now Only $39.00
Waterford The Jolly Snowman 7 1/2" Sculpture
Waterford The Jolly Snowman 7 1/2" SculptureSale
Item # 1052762
Now Only $69.00
Waterford Rectangular 7" Cookie Tray
Waterford Rectangular 7" Cookie TraySale
Item # 1052722
Now Only $79.00
Waterford Crystal, Eastbridge 8" Crystal Bowl
Waterford Crystal, Eastbridge 8" Crystal BowlSale
Item # 40027694
Now Only $99.00
Waterford Crystal, Westbridge 10" Crystal Bowl
Waterford Crystal, Westbridge 10" Crystal BowlSale
Item # 40031017
Now Only $149.00
Waterford Huntley 6" Footed Crystal Vase
Waterford Huntley 6" Footed Crystal VaseSale
Item # 1052560
Now Only $39.00
Waterford Crystal Huntley Pint Beer Glasses, Pair
Waterford Crystal Huntley Pint Beer Glasses, PairSale
Item # 1050313
Pair Only $99.00
Waterford Crystal Cassidy 10" Bowl
Waterford Crystal Cassidy 10" BowlSale
Item # 1052570
Now Only $99.00
Waterford Huntley Best Wishes Toasting Flutes, Pair
Waterford Huntley Best Wishes Toasting Flutes, PairSale
Item # 1052563
Pair Only $79.00
Waterford Abbey Crystal Clock
Waterford Abbey Crystal ClockSale
Item # 1052627
Now Only $79.00
Waterford Bolton Wine Carafe
Waterford Bolton Wine CarafeSale
Item # 40033704
Now Only $149.99
Waterford Crystal, Westbrooke 10" Crystal Vase
Waterford Crystal, Westbrooke 10" Crystal VaseSale
Item # 40033745
Now Only $149.00
Waterford Shamrock Paperweight
Waterford Shamrock PaperweightSale
Item # 1052592
Now Only $49.00
Waterford Crystal Holiday Heritage Votives, Pair
Waterford Crystal Holiday Heritage Votives, PairSale
Item # 1052652
Clearance $29.00
Waterford Giftology Lismore Bon Bon 6" Crystal Vase
Waterford Giftology Lismore Bon Bon 6" Crystal VaseSale
Item # 40016059
Now Only $65.00
Waterford Crystal, Westbrooke 10" Crystal Bowl
Waterford Crystal, Westbrooke 10" Crystal BowlSale
Item # 40033746
Now Only $149.00
Waterford Crystal Merilee Toasting Flutes, Pair
Waterford Crystal Merilee Toasting Flutes, PairSale
Item # 1052609
Pair Only $79.00
Waterford Crystal, Huntley Ships Decanter
Waterford Crystal, Huntley Ships DecanterSale
Item # 1050315
Now Only $149.00
Waterford Crystal Huntley Square Spirit Decanter
Waterford Crystal Huntley Square Spirit DecanterSale
Item # 1050316
Now Only $149.00
Waterford Crystal, Northbrooke 10" Crystal Vase
Waterford Crystal, Northbrooke 10" Crystal VaseSale
Item # 1050330
Now Only $149.99
Waterford China Ballet Ribbon Tea Saucer
Waterford China Ballet Ribbon Tea SaucerSale
Item # 140278
Clearance, Now Only $11.99
Waterford China Ballet Icing Pearl Bread and Butter, Single
Waterford China Ballet Icing Pearl Bread and Butter, SingleSale
Item # 151052
Clearance, Now Only $14.99
Waterford China Ballet Icing Pearl Tea Saucer, Single
Waterford China Ballet Icing Pearl Tea Saucer, SingleSale
Item # 151054
Clearance, Now Only $9.95
Waterford China Lismore 8" Salad/Dessert Plate, Single
Waterford China Lismore 8" Salad/Dessert Plate, SingleSale
Item # 100114
Clearance, Now Only $14.99
Waterford Crystal Darcy Goblet, Pair
Waterford Crystal Darcy Goblet, PairSale
Item # 40034533
Clearance, Only $79.00
Waterford Crystal Ardan Mara Wine Glasses, Set of 6
Waterford Crystal Ardan Mara Wine Glasses, Set of 6Sale
Item # 40033785
Set Only $180.00
Waterford Crystal Ardan Mara Flutes, Set of 6
Waterford Crystal Ardan Mara Flutes, Set of 6Sale
Item # 40035321
Set Only $180.00
Waterford Crystal Ardan Mara DOF Tumblers, Set of 6
Waterford Crystal Ardan Mara DOF Tumblers, Set of 6Sale
Item # 40033787
Set Only $160.00
Waterford Crystal Huntley 10" Footed Bowl
Waterford Crystal Huntley 10" Footed BowlSale
Item # 1052562
Now Only $99.00
Waterford Huntley Joy Toasting Flutes, Pair
Waterford Huntley Joy Toasting Flutes, PairSale
Item # 1052561
Pair Only $79.00
Waterford Crystal Hilton 6.5" Vase
Waterford Crystal Hilton 6.5" VaseSale
Item # 1052585
Now Only $69.00
Waterford Crystal 8" Heart Tray
Waterford Crystal 8" Heart TraySale
Item # 1052767
Now Only $69.00
Waterford Crystal Merilee DOF Tumblers, Pair
Waterford Crystal Merilee DOF Tumblers, PairSale
Item # 1052611
Pair Only $69.00
Waterford Woodmont DOF Tumbler, Pair
Waterford Woodmont DOF Tumbler, PairSale
Item # 1052617
Pair Only $69.00
Waterford Crystal Balmoral 7 1/2" Footed Vase
Waterford Crystal Balmoral 7 1/2" Footed VaseSale
Item # 1052622
Now Only $69.00
Waterford Huntley Set of Three Whiskey Decanters
Waterford Huntley Set of Three Whiskey DecantersSale
Item # 400023562W
Set Only $425.00
Waterford Crystal, Northbrooke 10" Crystal Bowl
Waterford Crystal, Northbrooke 10" Crystal BowlSale
Item # 1050331
Now Only $149.99
Waterford Southbridge Whiskey Decanter
Waterford Southbridge Whiskey DecanterSale
Item # 40030930
Now Only $149.99
Waterford Southbridge DOF Tumblers, Set of Four
Waterford Southbridge DOF Tumblers, Set of FourSale
Item # 40030931
Now Only $99.99

select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.ss_sku, p.ss_price, p.ss_searchkeywords, p.ss_productfield1, p.ss_productfield2, p.ss_productfield3, p.ss_productfield4, p.ss_productfield5, p.ss_productfield6, p.ss_productfield7, p.ss_productfield8, p.ss_productfield10, p.ss_productfield11, p.ss_productfield12, p.ss_productfield13, p.ss_productfield14, p.ss_productfield15, p.ss_productfield16, p.ss_productfield17, p.ss_productfield18, p.ss_productfield19, ss_productdescription, ss_moreinfotext, ss_QuantityOnHand, count(o.ss_sku) as c from ss_Products p LEFT JOIN ss_MostPopular o ON o.ss_sku = p.ss_sku where p.ss_productfield4 != '' and p.ss_productfield6 != '' and p.ss_productfield12 not REGEXP '(DSC|Web|INFO|AMZ)' and p.ss_productfield3 = 'unchecked' and p.ss_name REGEXP 'Waterford' and p.ss_name not like '%%Marquis%%' and p.ss_productfield8='checked' group by p.ss_sku order by c desc


^ Back to Top