Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Waterford Crystal 9" Sailboat Sculpture, Clear
Waterford Crystal 9" Sailboat Sculpture, ClearSale
Item # 40027993
Now Only $79.00
Cashs Ireland, Baby Block Crystal Paperweight
Cashs Ireland, Baby Block Crystal PaperweightSale
Item # 20988C
Now Only $29.99
Waterford Humpback Whale Sculpture Paperweight
Waterford Humpback Whale Sculpture PaperweightSale
Item # 1050407
Now Only $79.00
Waterford The Jolly Snowman 7 1/2" Sculpture
Waterford The Jolly Snowman 7 1/2" SculptureSale
Item # 1052762
Now Only $69.00
Lalique Crystal, Red Fish Sculpture
Lalique Crystal, Red Fish SculptureNew
Item # 3003100
$99.00
Belleek China Harp Paperweight
Belleek China Harp PaperweightNew
Item # B0514
$135.00
Waterford Shamrock Paperweight
Waterford Shamrock PaperweightSale
Item # 1052592
Now Only $49.00
Lalique Crystal, Figure Happy Buddha
Lalique Crystal, Figure Happy BuddhaNew
Item # 1401600
$650.00
Lalique Crystal, Double Fish Sculpture
Lalique Crystal, Double Fish SculptureNew
Item # 1162200
$5,300.00
Swarovski Crystal Lovebirds Sculpture
Swarovski Crystal Lovebirds SculptureNew
Item # 5379552
$779.00
Lalique Crystal, Figure Swan Head Up
Lalique Crystal, Figure Swan Head UpNew
Item # 1161600
$7,500.00
Lalique Crystal, Chrysis Sculpture
Lalique Crystal, Chrysis SculptureNew
Item # 1180900
$850.00
Lalique Crystal, Grey Fish Sculpture
Lalique Crystal, Grey Fish SculptureNew
Item # 3001400
$99.00
Lalique Crystal, Pink Fish Sculpture
Lalique Crystal, Pink Fish SculptureNew
Item # 3002800
$99.00
Lalique Crystal, Figure Bamara Lion
Lalique Crystal, Figure Bamara LionNew
Item # 1165600
$1,900.00
Lalique Crystal, Horse's Head Sculpture
Lalique Crystal, Horse's Head SculptureNew
Item # 1162400
$39,500.00
Lalique Crystal, Figure Swan Head Down
Lalique Crystal, Figure Swan Head DownNew
Item # 1161500
$7,500.00
Kosta Boda Wide Life Leaf Sculpture
Kosta Boda Wide Life Leaf SculptureNew
Item # 7091021
$310.00
Lalique Crystal, Vitesse Sculpture
Lalique Crystal, Vitesse SculptureNew
Item # 10066400
$975.00
Lalique Crystal, Victoire Sculpture
Lalique Crystal, Victoire SculptureNew
Item # 10108200
$1,250.00
Lalique Crystal, Horse Head Figure Black
Lalique Crystal, Horse Head Figure BlackNew
Item # 10056600
$44,000.00
Lalique Crystal, Falcon Sculpture
Lalique Crystal, Falcon SculptureNew
Item # 10206000
$2,900.00
Lalique Crystal, Golden Eagle Sculpture
Lalique Crystal, Golden Eagle SculptureNew
Item # 10364100
$7,400.00
Lalique Crystal, Flore Sculpture
Lalique Crystal, Flore SculptureNew
Item # 10442900
$395.00
Nambe Madonna Sculpture
Nambe Madonna SculptureNew
Item # MT0764N
$50.00
Lalique Crystal, Bulldog Sculpture
Lalique Crystal, Bulldog SculptureNew
Item # 10520200
$495.00
Swarovski Crystal Myriad Mahiri Sculpture
Swarovski Crystal Myriad Mahiri SculptureNew
Item # 5239445
$18,000.00
Ralph Lauren Albin Desk Sculpture
Ralph Lauren Albin Desk SculptureNew
Item # 682557740001
$250.00
Moser Crystal Heart Sculpture 7.9" Rosalin
Moser Crystal Heart Sculpture 7.9" RosalinNew
Item # HRT-30100-1-RSL
$2,500.00
Lalique Bear Sculpture, Clear
Lalique Bear Sculpture, ClearNew
Item # 10641100
$2,400.00
Lalique Taureau, Bull Sculpture, Clear
Lalique Taureau, Bull Sculpture, ClearNew
Item # 10647700
$2,500.00
Lalique Cheval, Horse Sculpture, Clear
Lalique Cheval, Horse Sculpture, ClearNew
Item # 10647600
$5,600.00
Lalique Cochon, Pig Sculpture, Clear
Lalique Cochon, Pig Sculpture, ClearNew
Item # 10647800
$575.00
Swarovski Crystal Myriad Pegasus Sculpture
Swarovski Crystal Myriad Pegasus SculptureNew
Item # 5405969
$15,000.00
Ralph Lauren 1955 Jaguar XKD Sculpture
Ralph Lauren 1955 Jaguar XKD SculptureNew
Item # 682723213002
$1,595.00
Ralph Lauren Ferrari 250 GTO Sculpture
Ralph Lauren Ferrari 250 GTO SculptureNew
Item # 682723771001
$1,595.00
Baccarat Crystal Rigot Greyhound Sculpture
Baccarat Crystal Rigot Greyhound SculptureNew
Item # 1764451B
$10,000.00
Baccarat Crystal Rigot Cat Sculpture
Baccarat Crystal Rigot Cat SculptureNew
Item # 1764450B
$10,000.00
Baccarat Bloom White Flower Sculpture
Baccarat Bloom White Flower SculptureNew
Item # 2812807B
$150.00
Baccarat Crystal Polar Bear Sculpture
Baccarat Crystal Polar Bear SculptureNew
Item # 2606796B
$1,600.00
Baccarat Bloom Amber Flower Sculpture
Baccarat Bloom Amber Flower SculptureNew
Item # 2813014B
$120.00
Baccarat Bloom Red Flower Sculpture
Baccarat Bloom Red Flower SculptureNew
Item # 2813016B
$120.00
Baccarat Bloom Gold Flower Sculpture
Baccarat Bloom Gold Flower SculptureNew
Item # 2813017B
$150.00
Baccarat Bloom Peony Flower Sculpture
Baccarat Bloom Peony Flower SculptureNew
Item # 2813013B
$150.00
Aerin Heart Puzzle Sculpture
Aerin Heart Puzzle SculptureNew
Item # 23114628091AE
$250.00
Aerin Marguerite Brass Flower Sculpture
Aerin Marguerite Brass Flower SculptureNew
Item # 18120039AE
$250.00
Aerin Lily Flower Sculpture
Aerin Lily Flower SculptureNew
Item # 18120040AE
$350.00
Aerin Dahlia Porcelain Flower Sculpture
Aerin Dahlia Porcelain Flower SculptureNew
Item # 17120064AE
$125.00
Aerin Antonin Sculpture, Limited Edition
Aerin Antonin Sculpture, Limited EditionNew
Item # 18220057AE
$1,250.00
Aerin Maxime Sculpture, Limited Edition
Aerin Maxime Sculpture, Limited EditionNew
Item # 18120038AE
$795.00
Aerin Bregenz Sculpture, Limited Edition
Aerin Bregenz Sculpture, Limited EditionNew
Item # 23094528001AE
$1,495.00
Aerin Margot Sculpture, Limited Edition
Aerin Margot Sculpture, Limited EditionNew
Item # 23094628100AE
$750.00
Aerin Luc Sculpture, Limited Edition
Aerin Luc Sculpture, Limited EditionNew
Item # 171200630AE
$750.00
Lalique Double Fish Sculpture, Clear
Lalique Double Fish Sculpture, ClearNew
Item # 10672800
$595.00
Nambe Mini Snowman Figure
Nambe Mini Snowman FigureNew
Item # MT1368N
$40.00
Lalique Rat Sculpture, Gold Luster
Lalique Rat Sculpture, Gold LusterNew
Item # 10686200
$680.00
Lalique Mouse Sculpture, Gold Luster
Lalique Mouse Sculpture, Gold LusterNew
Item # 10686800
$99.00
Lalique Rat Sculpture, Clear
Lalique Rat Sculpture, ClearNew
Item # 1404000
$785.00
Steuben Atkins Eagle Sculpture
Steuben Atkins Eagle SculptureNew
Item # 8496VAA
$600.00
Steuben Baby's Block Paperweight
Steuben Baby's Block PaperweightNew
Item # 9539ST
$295.00
Steuben Beacon of Light Sculpture
Steuben Beacon of Light SculptureNew
Item # 9056ST
$1,900.00
Steuben Beaver Sculpture
Steuben Beaver SculptureNew
Item # 9156CIC
$2,400.00
Steuben Bunny Hand Cooler Paperweight
Steuben Bunny Hand Cooler PaperweightNew
Item # 5547VAA
$250.00
Steuben Cat Hand Cooler Paperweight
Steuben Cat Hand Cooler PaperweightNew
Item # 5520VAA
$250.00
Steuben Celebrate Cupcake Sculpture
Steuben Celebrate Cupcake SculptureNew
Item # 9053VAA
$190.00
Steuben Cheetah Sculpture
Steuben Cheetah SculptureNew
Item # 9597VAA
$800.00
Steuben Christmas Tree Large Sculpture
Steuben Christmas Tree Large SculptureNew
Item # 10009VAA
$600.00
Steuben Christmas Tree Sculpture
Steuben Christmas Tree SculptureNew
Item # 8984VAA
$350.00
Steuben Dancing Hearts Paperweight
Steuben Dancing Hearts PaperweightNew
Item # 9143VAA
$650.00
Steuben Apple Paperweight
Steuben Apple PaperweightNew
Item # 7874VAA
$750.00
Steuben Egret Sculpture
Steuben Egret SculptureNew
Item # 9668VAA
$620.00
Steuben Gander Sculpture
Steuben Gander SculptureNew
Item # 8658ST
$600.00
Steuben Heart of My Heart Paperweight
Steuben Heart of My Heart PaperweightNew
Item # 9487VAA
$500.00
Steuben Horse Head Sculpture
Steuben Horse Head SculptureNew
Item # 7779VAA
$450.00
Steuben Houston Eagle Sculpture
Steuben Houston Eagle SculptureNew
Item # 8130ST
$1,200.00
Steuben Keepsake Heart Paperweight
Steuben Keepsake Heart PaperweightNew
Item # 10019VAA
$500.00
Steuben Kodiak Bear Sculpture
Steuben Kodiak Bear SculptureNew
Item # 9020VAA
$480.00
Steuben Lion Sculpture
Steuben Lion SculptureNew
Item # 1126VAA
$3,900.00
Steuben Loving Heart Sculpture
Steuben Loving Heart SculptureNew
Item # 8771VAA
$325.00
Steuben Penguin Sculpture
Steuben Penguin SculptureNew
Item # 8295ST
$350.00
Steuben Pollard Eagle Sculpture
Steuben Pollard Eagle SculptureNew
Item # 8304VAA
$1,000.00
Steuben Preening Goose Sculpture
Steuben Preening Goose SculptureNew
Item # 8344ST
$600.00
Steuben Pumpkin Sculpture
Steuben Pumpkin SculptureNew
Item # 10017ST
$600.00
Steuben Rabbit Redux Sculpture
Steuben Rabbit Redux SculptureNew
Item # 9662VAA
$400.00
Steuben Snail Sculpture
Steuben Snail SculptureNew
Item # 7982ST
$350.00
Steuben Star of David Sculpture
Steuben Star of David SculptureNew
Item # 8686ST
$400.00
Steuben Trout and Fly Sculpture
Steuben Trout and Fly SculptureNew
Item # 1002ST
$4,200.00
Steuben Wall Street Sculpture
Steuben Wall Street SculptureNew
Item # 1165ST
$5,800.00
Baccarat Dice Paperweight
Baccarat Dice PaperweightNew
Item # 2813749B
$240.00
Michael Aram Dove 14" Moon Gate Sculpture
Michael Aram Dove 14" Moon Gate SculptureNew
Item # 176104MA
$1,500.00
Aerin Damien Sculpture
Aerin Damien SculptureNew
Item # 19222029AE
$1,600.00
Aerin Oak Leaf Sculpture
Aerin Oak Leaf SculptureNew
Item # 19222030AE
$250.00
Aerin Acorn Sculpture
Aerin Acorn SculptureNew
Item # 19222031AE
$250.00
Moser Heart Large Sculpture Clear
Moser Heart Large Sculpture ClearNew
Item # HRT-30100-1-00
$2,490.00
Moser Heart Large Sculpture Alexandrite
Moser Heart Large Sculpture AlexandriteNew
Item # HRT-30100-1-ALX
$2,735.00
Moser Heart Sculpture Alexandrite
Moser Heart Sculpture AlexandriteNew
Item # HRT-30101-1-ALX
$1,250.00
Moser Heart Sculpture Clear
Moser Heart Sculpture ClearNew
Item # HRT-30101-1-00
$1,115.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 'sculpture|paperweight|figure|figurine' and p.ss_name not like '%plate%' and p.ss_name not like '%mug%' and p.ss_name not like '%nativity%' and p.ss_name not like '%angel%' and p.ss_name not like '%cross%' and p.ss_name not like '%bowl%' and p.ss_name not like '%raisin%' and p.ss_name not like '%ladies%' group by p.ss_sku order by c desc


^ Back to Top