Waterford Holiday Heirloom Ornaments
Sort by:  Popular Newest Name Price Price Filter by:  All On Sale

The items in this collection are no longer available, try searching for something similar...

select o.date, p.ss_created, p.ss_name, sku, 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.sku) as c from ss_products p LEFT JOIN ss_orders o ON o.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 'Holiday Heirloom' and p.ss_name not like '%Ceramic%' and p.ss_productfield13 like 'Waterford' group by p.ss_sku order by ss_created desc
Related Collections:

Waterford Snowflake Wishes Collection
Listing of 10-year series of collectible crystal giftware celebrating winter's snowflake from Waterford...
Waterford Christmas Collection
Listing of Waterford Crystal Christmas items...
Waterford Times Square 2017 Collection
Listing of limited edition pieces featuring the theme "Gift of Kindness"...
 
Marquis By Waterford Ornaments Collection
Listing of ornaments issued by Marquis by Waterford Crystal...
 
Waterford 12 Days of Christmas Collection
Listing of beautiful holiday pieces in the 12 Days of Christmas theme by Waterford...
Wedgwood Ornaments Collection
Complete listing of the porcelain Wedgwood Christmas ornaments...
 
Royal Albert Ornaments Collection
The complete collection of wonderful holiday items from Royal Doulton and Royal Albert...
 
Waterford Holiday Heirlooms Ornament Collection
Listing of beautiful heirloom ornaments by Waterford.
^ Back to Top