Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Orrefors Gin and Tonic Crystal Glasses, Set of Four
Orrefors Gin and Tonic Crystal Glasses, Set of FourSale
Item # 6313001
Set Now Only $39.99
Orrefors Crystal, Crystal Beer Collection 3 Piece Set
Orrefors Crystal, Crystal Beer Collection 3 Piece SetSale
Item # 6312009
Set Now Only $40.00
Orrefors Crystal, Street DOF Tumbler, Pair
Orrefors Crystal, Street DOF Tumbler, PairNew
Item # 6540104
Pair $90.00
Orrefors Crystal, Crystal Beer Pilsner, Set of Four
Orrefors Crystal, Crystal Beer Pilsner, Set of FourNew
Item # 6312003
Set of Four $50.00
Orrefors Sofiero DOF, Pair
Orrefors Sofiero DOF, PairNew
Item # 6383402
Pair $60.00
Orrefors Crystal, Pulse Crystal Beer, Set of Four
Orrefors Crystal, Pulse Crystal Beer, Set of FourNew
Item # 6295303
Set of Four $50.00
Orrefors Crystal, More Crystal Wine Glass, Set of Four
Orrefors Crystal, More Crystal Wine Glass, Set of FourNew
Item # 6310102
Set of Four $50.00
Orrefors Crystal, Swerve Tumbler, Pair
Orrefors Crystal, Swerve Tumbler, PairNew
Item # 6719582
Pair $90.00
Orrefors Crystal, Erik Crystal DOF Tumbler, Set of Four
Orrefors Crystal, Erik Crystal DOF Tumbler, Set of FourSale
Item # 6242402
Set of Four Now Only $60.00
Orrefors Crystal, Crystal Beer Lager, Set of Four
Orrefors Crystal, Crystal Beer Lager, Set of FourNew
Item # 6312002
Set of Four $50.00
Orrefors Crystal, Pearl Dessert Plates, Set of Four
Orrefors Crystal, Pearl Dessert Plates, Set of FourNew
Item # 6719788
Set of Four $75.00
Orrefors City Coasters, Set of Four
Orrefors City Coasters, Set of FourNew
Item # 6310304
Set of Four $45.00
Orrefors City Spoon, Pair
Orrefors City Spoon, PairNew
Item # 6310302
Pair $50.00
Orrefors City Ice Cubes, Set of Four
Orrefors City Ice Cubes, Set of FourNew
Item # 6310301
Set of Four $30.00
Orrefors Crystal, City Ice Bucket
Orrefors Crystal, City Ice BucketNew
Item # 6310397
$130.00
Orrefors Crystal, City Crystal Highball, Set of 4
Orrefors Crystal, City Crystal Highball, Set of 4New
Item # 6310336
Set of 4 $60.00
Orrefors Morberg Collection Champagne Flute, Set of 4
Orrefors Morberg Collection Champagne Flute, Set of 4New
Item # 6200020
Set of Four $50.00
Orrefors Crystal More Mature Set of Four
Orrefors Crystal More Mature Set of FourNew
Item # 6310123
Set $50.00
Orrefors Crystal More Spirits Set of Four
Orrefors Crystal More Spirits Set of FourNew
Item # 6310124
Set $50.00
Orrefors Crystal More Coupe Set of Four
Orrefors Crystal More Coupe Set of FourNew
Item # 6310125
Set $50.00
Orrefors Crystal, Peak Non Slip Coasters, Set of Four
Orrefors Crystal, Peak Non Slip Coasters, Set of FourNew
Item # 6311175
Set of Four $40.00
Orrefors City Shot Glasses, Pair
Orrefors City Shot Glasses, PairNew
Item # 6310342
Pair $25.00
Orrefors Erik Highball, Set of Four
Orrefors Erik Highball, Set of FourSale
Item # 6242437
Set Only $60.00
Orrefors Metropol Decanter
Orrefors Metropol DecanterNew
Item # 6410083
$200.00
Orrefors More Carafe
Orrefors More CarafeNew
Item # 6310188
$60.00
Orrefors Sofiero Old Fashion, Single
Orrefors Sofiero Old Fashion, SingleNew
Item # 6383440
$35.00
Orrefors Crystal Argyle DOF Tumbler, Pair
Orrefors Crystal Argyle DOF Tumbler, PairNew
Item # 6200041
Pair $90.00
Orrefors Crystal Argyle OF Tumbler, Pair
Orrefors Crystal Argyle OF Tumbler, PairNew
Item # 6200040
Pair $90.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 'Highball|DOF|old fashion|Pilsner|Martini|hiball|hi ball|decanter|stopper|shot glass|brandy|coaster|bucket|pitcher|tumbler|punchbowl|beer|tankard|ale|cube|Malt|Lager|Vodka|Pilsner|beer|carafe| OF|Ashtray|Bottle Opener|High Ball|Irish Coffee|Nut Dish|spoon|Pint Glass' and p.ss_name like '%Orrefors%' and p.ss_name not like '%bowl%' and p.ss_name not like '%vase%' and p.ss_name not like '%votive%' group by p.ss_sku order by c desc


Related Items:

Engrave and Personalize Your Crystal Gift
High quality engraving service is available on all crystal pieces we offer...
   
^ Back to Top