SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (81) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 173) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (81) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 173 ) ORDER BY position ASC LIMIT 1
925 S.Silver AAA Grade CZ Hoops Earrings
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale Sterling Silver Jewelry > Earrings

Item #: STZSER5042

925 S.Silver AAA Grade CZ Hoops Earrings

Micro Pave AAA Grade CZ Hoop Earrings Look Of A Real Diamonds.

Comes with retail price Tag and description. 

Style (2) E-5220
Style (3) E-6757
Style (4) E-3525
Style (7) E-5791
Style (11) E-5800
Style (12) E-5788
Style (13) E-3283