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










Wholesale Sterling Silver Jewelry > Men's Ring

Item #: R5596

.925 S.Silver AAA Grade CZ Rings

Comes With Retail Price Tag & Description  

IP Gold (Size 7)
IP Gold (Size 8)
IP Gold (Size 9)
IP Gold (Size 10)
IP Gold (Size 11)
IP Silver (Size 7)
IP Silver (Size 8)
IP Silver (Size 9)
IP Silver (Size 10)
IP Silver (Size 11)