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

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