Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Nambe Metal Mini Nativity Three Animals, Donkey, Camel, Bull
Nambe Metal Mini Nativity Three Animals, Donkey, Camel, BullNew
Item # MT0907N
In Stock: 1 - Set $79.00
Nambe Metal Mini Nativity Shepherd with Lamb
Nambe Metal Mini Nativity Shepherd with LambNew
Item # MT0908N
In Stock: 3 - Set $39.00
Nambe Metal Mini Nativity 3 Wise Men
Nambe Metal Mini Nativity 3 Wise MenNew
Item # MT0909N
In Stock: 2 - Set $79.00
Nambe Mini Angel Ornament, Set of Three
Nambe Mini Angel Ornament, Set of ThreeNew
Item # MT1058N
In Stock: 2 - Set $25.00
Nambe Joy Ornament
Nambe Joy OrnamentNew
Item # MT0879N
In Stock: 13 -  $30.00
Nambe Metal Mini Spire Christmas Ornaments, Set of Three
Nambe Metal Mini Spire Christmas Ornaments, Set of ThreeNew
Item # MT1179N
In Stock: 15 - Set $25.00
Nambe Christmas Nativity Shepherd and Animals, 4 Piece Set
Nambe Christmas Nativity Shepherd and Animals, 4 Piece SetNew
Item # MT0130N
In Stock: 1 -  $200.00
Nambe Metal Beaded Gold 5x7
Nambe Metal Beaded Gold 5x7" Picture FrameNew
Item # MT0748N
In Stock: 1 -  $75.00
Nambe Metal Kibo Baby Dish
Nambe Metal Kibo Baby DishSale
Item # MT0760N
In Stock: 1 - Clearance, Only $49.00
Nambe Moderne 11
Nambe Moderne 11" Crystal PitcherNew
Item # MT0958N
In Stock: 1 -  $75.00
Nambe Jewelry Silver Twist Cuff Bracelet, Large
Nambe Jewelry Silver Twist Cuff Bracelet, LargeNew
Item # JT0009-LL
In Stock: 1 -  $225.00
Nambe Metal Mini Red Nosed Reindeer
Nambe Metal Mini Red Nosed ReindeerNew
Item # MT1212N
In Stock: 3 -  $29.00
Nambe Tree Christmas Ornament
Nambe Tree Christmas OrnamentNew
Item # MT1339N
In Stock: 13 -  $30.00
Nambe Metal Spiral Wine Coaster
Nambe Metal Spiral Wine CoasterNew
Item # 6189N
In Stock: 1 -  $75.00
Nambe Christmas Blizten Reindeer, Set of 3
Nambe Christmas Blizten Reindeer, Set of 3New
Item # Mt0384N
In Stock: 1 - Set $275.00
Nambe Christmas Sleigh with 2 Reindeer, 3 Piece Set
Nambe Christmas Sleigh with 2 Reindeer, 3 Piece SetNew
Item # MT0133N
In Stock: 2 -  $225.00
Nambe China Skye Cafe Au Lait Cup and Saucer Set
Nambe China Skye Cafe Au Lait Cup and Saucer SetSale
Item # MT0870N
In Stock: 12 - Set Only $8.50
Nambe Jewelry Silver Detached Braid Hoop Earrings, Pair
Nambe Jewelry Silver Detached Braid Hoop Earrings, PairNew
Item # JT0107-00
In Stock: 1 - Pair $150.00
Nambe Metal 9-Piece Miniature Reindeer Set
Nambe Metal 9-Piece Miniature Reindeer SetNew
Item # MT1185N
In Stock: 2 - Set $200.00
Nambe Peace Christmas Ornament
Nambe Peace Christmas OrnamentNew
Item # MT1182N
In Stock: 18 -  $30.00
Nambe Metal Rim Desk Clock
Nambe Metal Rim Desk ClockNew
Item # MT1169N
In Stock: 1 -  $80.00
Nambe 2019 Annual Christmas Ornament
Nambe 2019 Annual Christmas OrnamentSale
Item # MT1338N
In Stock: 11 - Clearance $24.99
Nambe Santa Christmas Ornament
Nambe Santa Christmas OrnamentNew
Item # MT1340N
In Stock: 11 -  $30.00
Nambe Mini Christmas Tree Set of Three
Nambe Mini Christmas Tree Set of ThreeNew
Item # MT1369N
In Stock: 10 - Set of Three $120.00
Nambe Christmas Tree 11.5
Nambe Christmas Tree 11.5" DishNew
Item # MT1371N
In Stock: 1 -  $55.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 'Nambe' and p.ss_productfield12 REGEXP 'ZOM' and ss_QuantityOnHand<='30' and ss_QuantityOnHand>='1' group by p.ss_sku order by c desc


^ Back to Top