Log In  |  My Account  |  View Cart  |  Checkout   
Dresses | Tops | Bottoms | Plus Sizes | Shoes | Accessories
New Arrivals
Girl's (7-14)
Best Seller
Special Promo
Dresses
      -Cocktail Dresses
      -Prints and Plaids
      -Solid Color
      -Maxi Dress
      -Rompers and Jumpsuits
Tops
      -Casual Tops
      -Graphic Tees
      -Dressy Blouses
Outerwear
      -Vests and Cardigans
      -Sweaters
      -Jackets and Coats
Bottoms
      -Skirts
      -Pants
      -Shorts and Bermudas
      -Jeans
Pre-Orders
Plus Sizes
      -Plus Size Dresses
      -Plus Size Tops
      -Plus Size Outerwear
      -Plus Size Bottoms
Seamless
Yoga and sportswear
Shoes
      -Causal Shoes
      -Sandals
      -High Heels
      -Wedges
      -Flats
      -Boots
Accessories
      -Everything else
      -Rings
      -Watches
      -Sunglasses
      -Bangles/Bracelets
      -Belts
      -Hats
      -Necklace and Earrings
      -Handbags and Clutches
      -Scarves
      -Hair Accessories
      -Keychains
      -Pantyhose
Beauty Supply
      -Eyelash
      -Cosmetic Kits
      -Nail Art Supply
Special Sale
Print Catalog
Shop with Confidence
- 21 Day exchange guarantee!
- No restocking fee! *
- 100% safe SSL encrypted shopping!
- Price Match Guarantee
Official PayPal Seal
Merchant Services
Enter Tracking#:

Enter Tracking#:


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 != '113596' and pd.products_id = p.products_id and p.products_status = '1' and ( pd.products_name like '%EARRINGS%' && pd.products_name not like '%earring%' && pd.products_name like '%RING' &) ) order by p.products_id desc limit 7

[TEP STOP]

 Previous   Product 51 of 6060 of category Necklace and Earrings   Next  
TEXTURED POLISHED LINKED RING EARRINGS


TEXTURED POLISHED LINKED RING EARRINGS

NameTEXTURED POLISHED LINKED RING EARRINGS
IDE51771C2
Unit PriceLogin

 

  • Lead/Nickel compliant
  • Drop Approx. 2.5"
  • Fish hook

Option Price Qty.
Silver $
Gold $

Total Price  $ Total Qty.
117


Silver

Gold