SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (47) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 15) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (47) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 15 ) ORDER BY position ASC LIMIT 1
316L Stainless Steel Cuban Chain & Bracelet
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Product Promotions > New Arrival

Item #: STCB16

316L S.Steel Miami Cuban Chain & Bracelet

IP Gold Chain(6mm)
IP Silver Chain(6mm)
IP Gold Bracelet(6mm)
IP Gold Chain(8mm)
IP Silver Chain(8mm)
IP Gold Bracelet(8mm)
IP Gold Chain(10mm)
IP Silver Chain(10mm)
IP Gold Bracelet(10mm)
IP Silver Bracelet(10mm)
IP Gold Chain(12mm)
IP Silver Chain(12mm)
IP Gold Bracelet(12mm)
IP Silver Bracelet(12mm)
IP Gold Chain(14mm)
IP Silver Chain(14mm)
IP Gold Bracelet(14mm)
IP Silver Bracelet(14mm)
IP Gold Chain(16mm)
IP Silver Chain(16mm)
IP Gold Bracelet(16mm)
IP Silver Bracelet(16mm)