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 < 73) 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 > 73 ) ORDER BY position ASC LIMIT 1
Brass Full CZ Cuban Chain
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Product Promotions > New Arrival

Item #: BRCH30

Brass 14MM CZ Cuban Chain

Gold Plated(18 inch)
Silver Plated(18 inch)
Two Tone Color(18 inch)
Gold Plated(20 inch)
Silver Plated(20 inch)
Two Tone Color(20 inch)
Gold Plated(22 inch)
Silver Plated(22 inch)
Two Tone Color(22inch)
Gold Plated(24 inch)
Silver Plated(24 inch)
Rose Color(24 inch)
Two Tone Color(24 inch)
Gold Plated(8.5 inch)
Silver Plated(8.5 inch)
Rose Color(8.5 inch)
Two Tone Color(8.5 inch)