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 < 5) 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 > 5 ) ORDER BY position ASC LIMIT 1
Silicon Band Rings
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale HipHop Jewelry > Men's Rings

Item #: SBR01

Silicon Band Rings

Gray (Size 8)
Gray (Size 9)
Gray (Size 10)
Gray (Size 11)
Gray (Size 12)
Gray (Size 13)
Gray (Size 14)
Black (Size 8)
Black (Size 9)
Black (Size 10)
Black (Size 11)
Black (Size 12)
Black (Size 14)
White (Size 8)
White (Size 9)
White (Size 10)
White (Size 11)
White (Size 12)
White (Size 13)
White (Size 14)