Sort by:  Popular Newest Name Price Price Filter by:  All On Sale

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(IF(date >= DATE_SUB(NOW(), INTERVAL 90 DAY), 1, null)) 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 'Ornament|Nativity|Angel' and p.ss_productfield13 like 'Belleek' group by p.ss_sku order by c desc


The festive collection of Belleek China Ornaments and holiday figures are perfect Christmas gifts as well as a great addition to your festive decorations. Beautifully designed and handcrafted in Ireland, featuring hand embossing and hand painted designs. Large collection of ornaments, nativity and angel figurines. Made in Ireland. Crystal Classics is the largest independent retailer of Belleek China.

Belleek Pottery Ltd is a porcelain company that began trading in 1887 in Belleek, County Fermanagh, in what was to become Northern Ireland. The village of Belleek was a natural choice to locate the business especially the part of the village known as Rose Isle. This small isle provided the best opportunity to leash the yet untamed power of the River Erne - power to drive a mill wheel strong enough to grind components into Slip, the term applied to liquid potters clay.

Related Collection:

Ornament Stands Collection
Listing of ornament stands, ideal for displays in the curio cabinets all year long... special
   

^ Back to Top