SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (111) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 8) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (111) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 8 ) ORDER BY position ASC LIMIT 1
Brass Full CZ Cuban Chain
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale Brass Jewelry > Brass Chains

Item #: BRCH28

Brass CZ Cuban Chain W/CZ Clasp

Gold Plated 12MM (20 inch)
Gold Plated 12MM (24 inch)
Gold Plated 12MM (8.5inch)
Silver Plated 12MM (20'' inch)
Silver Plated 12MM (24'' inch)
Silver Plated 12MM (8.5'' inch)
Gold plated 15MM (24 inch)
Gold plated 15MM (8.5 inch)