Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Waterford Heart Ring Dish
Waterford Heart Ring DishSale
Item # 1052564
Now Only $39.00
Waterford Crystal Grant 10" Bowl
Waterford Crystal Grant 10" BowlSale
Item # 40011234
Now Only $69.00
Waterford The Jolly Snowman 7 1/2" Sculpture
Waterford The Jolly Snowman 7 1/2" SculptureSale
Item # 1052762
Now Only $69.00
Waterford Crystal Grant 10" Vase
Waterford Crystal Grant 10" VaseSale
Item # 40011235
Now Only $69.00
Waterford Crystal Round Ring Holder
Waterford Crystal Round Ring HolderSale
Item # 40034378
Now Only $39.00
Waterford Lismore Diamond Heritage Standing Cross
Waterford Lismore Diamond Heritage Standing CrossSale
Item # 1052546
Now Only $79.00
Waterford Crystal Lion Sculpture
Waterford Crystal Lion SculptureSale
Item # 1050409
Now Only $99.00
Waterford Crystal Tracy Nut Bowl
Waterford Crystal Tracy Nut BowlSale
Item # 1052579
Now Only $39.00
Waterford Rectangular 7" Cookie Tray
Waterford Rectangular 7" Cookie TraySale
Item # 1052722
Now Only $79.00
Waterford Huntley 6" Footed Bowl
Waterford Huntley 6" Footed BowlSale
Item # 1052559
Now Only $49.00
Waterford Crystal Praying Cherub
Waterford Crystal Praying CherubSale
Item # 156236
Now Only $59.00
Waterford Huntley Best Wishes Toasting Flutes, Pair
Waterford Huntley Best Wishes Toasting Flutes, PairSale
Item # 1052563
Pair Only $79.00
Waterford Huntley Stemless Red Wine Glasses, Pair
Waterford Huntley Stemless Red Wine Glasses, PairSale
Item # 40030853
Pair Now Only $69.00
Waterford Crystal Huntley Pilsner Beer Glasses, Pair
Waterford Crystal Huntley Pilsner Beer Glasses, PairSale
Item # 40033506
Pair Only $99.00
Waterford Crystal, Huntley Irish Coffee Glasses, Pair
Waterford Crystal, Huntley Irish Coffee Glasses, PairSale
Item # 40030850
Pair Now Only $79.00
Waterford Crystal, Westbrooke 10" Crystal Bowl
Waterford Crystal, Westbrooke 10" Crystal BowlSale
Item # 40033746
Now Only $149.00
Waterford Crystal Holiday Heritage Votives, Pair
Waterford Crystal Holiday Heritage Votives, PairSale
Item # 1052652
Clearance $29.00
Waterford Crystal Daisy Floral Votive, Single
Waterford Crystal Daisy Floral Votive, SingleSale
Item # 1052628
Now Only $29.00
Waterford Crystal Huntley 8 1/2" Bowl
Waterford Crystal Huntley 8 1/2" BowlSale
Item # 40024501
Now Only $59.00
Waterford Crystal Huntley 8" Flared Salad Bowl
Waterford Crystal Huntley 8" Flared Salad BowlSale
Item # 40033513
Now Only $99.00
Waterford Crystal Huntley 6" Vase
Waterford Crystal Huntley 6" VaseSale
Item # 40009187
Now Only $39.00
Waterford Crystal, Heart Ring Holder
Waterford Crystal, Heart Ring HolderNew
Item # 7878140065
$65.00
Waterford Huntley Stemless White Wine Glasses, Pair
Waterford Huntley Stemless White Wine Glasses, PairSale
Item # 40030845
Pair Only $69.00
Waterford Crystal Rosalee Ring Bowl
Waterford Crystal Rosalee Ring BowlSale
Item # 1052624
Now Only $39.00
Waterford Huntley Brandy Cognac Glass, Single
Waterford Huntley Brandy Cognac Glass, SingleSale
Item # 40033465
Now Only $39.00
Waterford Crystal Huntley Juice Pitcher
Waterford Crystal Huntley Juice PitcherSale
Item # 40033508
Now Only $69.00
Waterford Crystal Cassidy 10" Bowl
Waterford Crystal Cassidy 10" BowlSale
Item # 1052570
Now Only $99.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 9" Sailboat Sculpture, Clear
Waterford Crystal 9" Sailboat Sculpture, ClearSale
Item # 40027993
Now Only $79.00
Waterford Bolton Crystal Decanter
Waterford Bolton Crystal DecanterSale
Item # 40030927
Now Only $149.99
Waterford Crystal Merilee Toasting Flutes, Pair
Waterford Crystal Merilee Toasting Flutes, PairSale
Item # 1052609
Pair Only $79.00

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 DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= FROM_UNIXTIME(o.ss_date) group by p.ss_sku order by c desc limit 126


^ Back to Top