select ProductID,ProductName,ImagePath,Designer,SalePrice,Price, GRoupID,PreOrder,0 as LC,(select top 1 TypeID from mss_Types where TypeID in (select typeid from mss_types where [sign]='DESIGNERS') and TypeID in (select TypeID from mss_Index where ProductID=cache_products.ProductID)) AS DesignerID from cache_Products where (publishdate < getdate() or publishdate is null) and 1=1 and exists (select top 1 1 from mss_index where typeid=2 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=5 and productid=cache_Products.productid) and ( ( [Keywords] like '%unearthen%' ) or productname like '%unearthen%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%unearthen%' or Remark='unearthen'))) order by PublishDate desc
Unearthen
Apatite - 22" Chain
$ 345.00
There’s a reason you’re enamored with this necklace: each crystal is one-of-a-kind and holds the unique ability to draw you toward its mystical influence. United with a bullet related to the stone’s history, quality, and size, each necklace is carefully designed–and rumor has it, they choose their owners, not the other way around! With that in mind, please note that these necklaces are final sale.
Passport: USA
Established: 2007 by Gia Bahm
There’s a reason you’re enamored with this necklace: each crystal is one-of-a-kind and holds the unique ability to draw you toward its mystical influence. United with a bullet related to the stone’s history, quality, and size, each necklace is carefully designed–and rumor has it, they choose their owners, not the other way around!
CLOSE
This item is low in stock!
Opening Ceremony specializes in stocking one-of-a-kind pieces. By
virtue of their uniqueness, some of these items are available only in
limited quantities.
You will be issued a full refund if we are unable to fulfill your order.
If you have any questions, please contact Sisi at
SISI@OPENINGCEREMONY.US or (646) 237-6078.
