SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (69) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 2) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (69) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 2 ) ORDER BY position ASC LIMIT 1
FASHION RUBY CZ ICED OUT RINGS
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale HipHop Jewelry > Men's Rings

Item #: NEKCZR1

FASHION RUBY CZ ICED OUT RINGS

FASHION RUBY CZ ICED OUT RINGS

Approx. 18MM (L) X15MM (W) X 4MM (T)

Approx. BAND 9MM (W)  

Style (1)Size (7)
Style (1)Size (8)
Style (1)Size (9)
Style (1)Size (10)
Style (1)Size (11)
Style (1)Size (12)
Style (2)Size (7)
Style (2)Size (8)
Style (2)Size (9)
Style (2)Size (10)
Style (2)Size (11)
Style (2)Size (12)
Style (3)Size (7)
Style (3)Size (8)
Style (3)Size (9)
Style (3)Size (10)
Style (3)Size (11)
Style (3)Size (12)
Style (4)Size (7)
Style (4)Size (8)
Style (4)Size (9)
Style (4)Size (10)
Style (4)Size (11)
Style (4)Size (12)