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 < 6) 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 > 6 ) ORDER BY position ASC LIMIT 1

Item #: BRCH10

Brass Full CZ 3 Sided Chain & Bracelet Sets 6mm

 Brass Full CZ 3 Sided Chain & Bracelet Sets 6mm

Bracelet 8.5"


Rhodium Chain (20 inch) 6mm
Rhodium Chain (22 inch) 6mm
Rhodium Chain (24 inch) 6mm
Rhodium Chain (26 inch) 6mm
Rhodium Chain (28 inch) 6mm
Rhodium Chain (30inch) 6mm
Rhodium Bracelet 6mm