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

Item #: BRCH9

Brass Full CZ 3 Sided Chain & Bracelet Sets 6mm

Brass Full CZ 3 Sided Chain & Bracelet Sets 6mm

Bracelet 8.5"


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