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=354 and productid=cache_Products.productid) and ( ( [Keywords] like '%quartz%' ) or productname like '%quartz%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%quartz%' or Remark='quartz'))) order by PublishDate desc
0 sql= select ProductID , 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=354 and productid=cache_Products.productid) and ( ( [Keywords] like '%quartz%' ) or productname like '%quartz%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%quartz%' or Remark='quartz'))) order by PublishDate desc
pop_52769_0.jpg
th_52769_0.jpg
th_52769_1.jpg
th_52769_2.jpg
th_52769_4.jpg
up
down
Pamela Love Double Finger Quartz Crystal Ring
$ 525.00
  • 52768 sold out
  • 52768
  • 52769 sold out
  • 52769
SOLD OUT
Details
Size & Fit
Designer

Two-finger sterling silver ring with quartz crystal inset | Rectangular setting.

Available in sterling silver.

Made in the USA.

Ring measures 1.5"H  x 1.5"W.

(SKU: 10111809 | GID: 18080)

email to a friend

Want to keep an eye on this product? Sign up for the OC Stock Notifier!

Pamela Love gives her heavy metal aesthetic a lighter touch for her first-ever resort collection. The designer’s signature tribal spikes return cast in turquoise, pearl, and shell resins for armfuls of semi-precious treasures. Necklaces too look shiny and new with clusters of skulls in bright silver and polished rose gold.



Passport: USA

Established: 2007 by Pamela Love

Drummer-artist-designer Pamela Love may wear many hats, but it clearly hasn’t deterred her from exerting her fullest creative energies into each. Inspired by a myriad of sometimes merry, sometimes macabre influences, the New York-based triple threat crafts instantly affecting, animal-like pieces that seriously construe a mood, adding stunning character to the look of its wearer.

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.

ecommerce web design web development