SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (64) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 89) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (64) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 89 ) ORDER BY position ASC LIMIT 1
12 PCS OF ASSORTED S.STEEL BRACELET
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale Stainless Steel Jewelry > S.Steel Bracelets

Item #: STZBRSTA1

12 PCS OF ASSORTED S.STEEL BRACELET

YOU WILL RECEIVE 12 PEICE ASSORTMENT OF 316L STAINLESS STEEL BRACELET OF DIFFRENT STYLES INCLUDING IP RHODIUM, IP GOLD AND IP BLACK.

WIDTH : 8MM APPROX

NOTE : IF YOU PICK MULTIPLE PACKAGE YOU WILL GET ALL DIFFRENT BRACELET YOU WON'T GET THE SAME BRACELET SINCE WE HAVE 250 DIFFRENT STYLES TO CHOOSE FROM.

CONTACT US  FOR MORE DETAIL.

IP Gold
IP Black
Chrome
Mix Assortment