Log In / Register  |  My Account  |  View Cart  |  Checkout   
 * NEW ARRIVALS  |  SPECIALS  |  JEWELRY  |  ACCESSORIES  |  HANDBAGS  |  CLOTHING 
NECKLACES
      CHUNKY NECKLACE
      GEMSTONE NECKLACE
      FASHION NECKLACE
      CRYSTAL NECKLACE
      LONG NECKLACE
      PEARL NECKLACE
      PENDANT NECKLACE
BRACELETS
      FASHION BRACELETS
      BANGLES
      CRYSTAL BRACELETS
      GEMSTONE BRACELETS
      LEATHER BRACELETS
      PEARL BRACELETS
      HAND BRACELETS
EARRINGS
      FASHION EARRINGS
      CLIP EARRINGS
      CRYSTAL EARRINGS
      EAR CUFF
      GEMSTONE EARRINGS
      HOOP EARRINGS
      PEARL EARRINGS
      STUD EARRINGS
RINGS
BROOCHES
ANKLETS & TOE RINGS
BODY JEWELRY
BRIDAL ACCESSORIES
KEY CHAINS
OTHER JEWELRY

Minimum Order : Login

Official PayPal Seal

Accept Credit Cards Online


Enter Tracking#:



Enter Tracking#:



Enter Tracking#:


  Top » Catalog » JEWELRY » RINGS » 139694
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '&) ) order by p.products_id desc limit 7' at line 1

select p.products_id, p.products_image, pd.products_name from products_description pd, products p, products_to_categories p2c where p2c.categories_id > 0 and p2c.products_id = pd.products_id and pd.products_id != '23724' and pd.products_id = p.products_id and p.products_status = '1' and ( pd.products_name like '%Band%' && pd.products_name not like '%earring%' && pd.products_name like '%Ring' &) ) order by p.products_id desc limit 7

[TEP STOP]

 Previous   Product 385 of 386 of category RINGS   Next  
X CZ Stone Pave Hammered Ring Band
X CZ Stone Pave Hammered Ring Band

NameX CZ Stone Pave Hammered Ring Band
Style No.139694
PriceLogin

  • X CZ Stone Pave Hammered Ring Band 
  • CA Lead and Nickel Compliant Product
  • Adult Only 

(6)(8)
AS SHOWN
Total Price  $ Total Qty.


WARNING:
This product can expose you to chemicals including lead and cadmium which are known to the State of California to cause cancer, birth defects or other reproductive harm. For more information go to https://www.p65warnings.ca.gov/



AS SHOWN

Customers who bought this product also purchased
COLOR LINE PATTERN OBLONG SCARF
COLOR LINE PATTERN OBLONG SCARF
Texture Hoop Earring
Texture Hoop Earring
FLAT CHAIN TASSEL FLORAL GEM ORNATE EARRING
FLAT CHAIN TASSEL FLORAL GEM ORNATE EARRING
MULTI BEAD BRACELET
MULTI BEAD BRACELET
CHAIN TASSEL EARRING
CHAIN TASSEL EARRING
TWO TONE SEMI HOOP EARRING
TWO TONE SEMI HOOP EARRING
ELEPHANT MIX PRINT OBLONG TASSEL SCARF
ELEPHANT MIX PRINT OBLONG TASSEL SCARF