Shannon is the largest independent Waterford retailer in the U.S. View Waterford Inspiration Gallery!

Popular Waterford Categories:


Waterford Humpback Whale Sculpture Paperweight
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_productfield13 like 'Waterford' and DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= FROM_UNIXTIME(o.ss_date) group by p.ss_sku order by c desc limit 1
Most Popular
Waterford Humpback Whale Sculpture Paperweight
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_productfield13 like 'Waterford' and p.ss_productfield8='checked' group by p.ss_sku order by RAND() limit 1
SALE & Specials
Waterford Humpback Whale Sculpture Paperweight
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_productfield13 like 'Waterford' && DATE_SUB(CURDATE(),interval 365 day) <= FROM_UNIXTIME(p.ss_created) group by p.ss_sku order by ss_created desc limit 1
New Items
Waterford Humpback Whale Sculpture Paperweight
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_productfield12 REGEXP 'ZOM' and p.ss_productfield13 like 'Waterford' and ss_QuantityOnHand<='10' and ss_QuantityOnHand>='1' group by p.ss_sku order by c desc limit 1
Last Chance to Buy

All Waterford Categories:


Waterford Lismore:


Waterford By Pattern:



W

Waterford Crystal Designers:



Shannon is the largest independent retailer of Waterford Crystal. First to open online Waterford Crystal store featuring all crystal gifts from Waterford Lismore to Waterford Crystal Vases, Crystal Bowls, Waterford Lismore Wedding Flutes, Waterford Christmas Ornaments, and famous On-The-Rocks Scotch and Whiskey Crystal Glasses and Waterford Crystal Decanters. Our online store opened one year ahead of Google going live online and has been serving over 1.5 million households since. Shannon also offers one of the most beautiful crystal catalogs, luxuriously printed and mailed quarterly.

When the brothers George and William Penrose founded the Waterford Crystal House in 1783, they made a bold promise - to make Waterford crystal in "as fine a quality as any in Europe in the most elegant style." It was no idle boast. They had in hand the old secrets of mingling minerals and glass to create Waterford crystal of beautiful and mysterious qualities.

It sang sweetly at the tap of a finger. It felt soft and warm to the touch yet possessed strength and durability known only to Waterford crystal. And it radiated a distinctive, silvery white brilliance, which Waterford Crystal's artists enhanced with deeply - cut ornamentation that gave the finished pieces a vivacious, traditional Irish crystal sparkle.

^ Back to Top