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

Item #: BRCH30

Brass 14MM CZ Cuban Chain


Gold Plated(18 inch)
Gold 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)
Two Tone Color(24 inch)
Gold Plated(8.5 inch)
Silver Plated(8.5 inch)
Two Tone Color(8.5 inch)