Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Cashs Ireland, Cooper Craft Ale Crystal Beer Glass, 1+1 Free
Cashs Ireland, Cooper Craft Ale Crystal Beer Glass, 1+1 FreeSale
Item # 17980C
1+1 Free Now Only $50.00
Cashs Ireland, Shot Glass Mixed Set of Four Patterns
Cashs Ireland, Shot Glass Mixed Set of Four PatternsSale
Item # 16397C
Set of Four $100.00
Cashs Ireland, Cooper Martini Glasses, 1+1 Free
Cashs Ireland, Cooper Martini Glasses, 1+1 FreeSale
Item # 16221C
1+1 Free $50.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 'Single Malt|Beer|Shot Glass|Bottle Stopper|Decanter|Flutes|Champagne|Martini|Brandy|Scotch|Tankard|Pitcher|Ashtray|wine|Carafe|Whiskey|Pinot Noir|Coaster|bucket' and p.ss_productfield13 like 'Cashs' group by p.ss_sku order by c desc

Since 1976 Cashs of Ireland has been synonimus with fine crystal and Irish gifts fashioned by hand in traditional ways by skilled Irish craftsmen.
First founded in Cork, Ireland, Cashs crystal and jewelry are now hand crafted in several factories in Waterford, Ireland, long known as a center of fine crystal.
Each piece of Cashs Crystal is hand cut and polished by skilled artisans with hundreds of years of combined experience in creating crystal masterpieces.
Some items that require technology not available in Ireland are crafted on old continental European production lines, using Irish design and glass mixtures, never compromising the quality.
Each piece of Cashs is hand wrapped in soft velvet pouch and delivered to our customers in an immaculate gift box.

^ Back to Top