+1 800 824 9148

office@asbausa.com

HOME
JEWELRY
- Rings
  - Bands
  - Fashion
  - One of a Kind
  - Pearl
  - Engagement
- Bracelets
- Earrings
- Pendants
- Necklaces
- Pearls
  - Bracelets
  - Earrings
  - Rings
  - Pendants
  - Necklaces
  - Strands
- Akoya Studs
About Us
CONTACT US

Earrings - One of a Kind

Stone Type

Alexandrite` Diamond
Amethyst` Diamond
Blue Topaz
Blue Topaz` Diamond
Citrine` Diamond
Diamond
DIAMOND` SAPPHIRE` BLUE SAPPHIRE
Diamonds
Emerald` Diamond
Garnet` Diamond
Opal` Diamond
Pearl
Peridot` Diamond
Pink Tourmaline` Diamond
Pink Tourmaline` Pink Sapphire` Pink Quartz
Ruby
Ruby` Diamond
Sapphire
Sapphire` Diamond

Select distinct AddInfo4 from CJlryMaster where AddInfo20<>'y' and PQty<>0 and AddInfo4 not in ('','Null','0') and CJlryNote not in ('Null') and MCategory='Jewelry' and SCategory='Earrings' and SSCategory='One of a Kind' order by (AddInfo4) asc