Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Lenox China Butterfly Meadow Hydrangea 12 Piece Set
Lenox China Butterfly Meadow Hydrangea 12 Piece SetSale
Item # 849407L
Set Now Only $99.95
Lenox 2018 Holiday Collectors Plate, 28th Edition - Cabin
Lenox 2018 Holiday Collectors Plate, 28th Edition - CabinNew
Item # 879271L
Clearance, Only $47.99
Lenox Butterfly Meadow Bakeware Covered Casserole
Lenox Butterfly Meadow Bakeware Covered CasseroleNew
Item # 855622L
Now Only $49.95
Lenox China Donna Karan Devore, Service/Large Dinner Plate
Lenox China Donna Karan Devore, Service/Large Dinner PlateSale
Item # 823312L
Clearance, Now Only $29.99
Lenox China Autumn, 5 Piece Place Setting
Lenox China Autumn, 5 Piece Place SettingNew
Item # 116890610L
Now Only $199.95
Lenox China Eternal, 5 Piece Place Setting
Lenox China Eternal, 5 Piece Place SettingNew
Item # 140190600L
Set Now Only $99.95
Lenox China Federal Platinum, 5 Piece Place Setting
Lenox China Federal Platinum, 5 Piece Place SettingNew
Item # 100291602L
Set Now Only $99.95
Lenox China Lace Couture, 5 Piece Place Setting
Lenox China Lace Couture, 5 Piece Place SettingNew
Item # 773732L
Set Now Only $119.95
Lenox China Opal Innocence, 5 Piece Place Setting
Lenox China Opal Innocence, 5 Piece Place SettingNew
Item # 6140990L
Set Now Only $129.95
Lenox China Opal Innocence Stripe, 5 Piece Place Setting
Lenox China Opal Innocence Stripe, 5 Piece Place SettingNew
Item # 806506L
Set Now Only $129.95
Lenox China Venetian Lace, 5 Piece Place Setting
Lenox China Venetian Lace, 5 Piece Place SettingNew
Item # 762014L
Set Now Only $129.95
Lenox China Vintage Jewel, 5 Piece Place Setting
Lenox China Vintage Jewel, 5 Piece Place SettingNew
Item # 104291602L
Set Now Only $139.95
Lenox China Butterfly Meadow, 4 Piece Place Setting
Lenox China Butterfly Meadow, 4 Piece Place SettingNew
Item # 817044L
Set Now Only $49.95
Lenox 2019 Holiday Plate, Barn Scene
Lenox 2019 Holiday Plate, Barn SceneSale
Item # 887099L
Clearance $54.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 '5|setting|place|plate|patter|cup|dinner|butter|accent|pot' and p.ss_name not like '%frame%' and p.ss_name not like '%crystal%' and p.ss_name not like '%flute%' and p.ss_name not like '%vase%' and p.ss_name not like '%Flatware%' and p.ss_name not like '%votive%' and p.ss_name not like '%monogram%' and p.ss_productfield12 REGEXP 'CHI|ZOM' and p.ss_productfield13 like 'Lenox' group by p.ss_sku order by c desc


^ Back to Top