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

Item #: STCB16

316L S.Steel Miami Cuban Chain & Bracelet


IP Gold Chain(6mm)
IP Silver Chain(6mm)
IP Gold Bracelet(6mm)
IP Gold Chain(8mm)
IP Silver Chain(8mm)
IP Gold Bracelet(8mm)
IP Gold Chain(10mm)
IP Silver Chain(10mm)
IP Gold Bracelet(10mm)
IP Silver Bracelet(10mm)
IP Gold Chain(12mm)
IP Silver Chain(12mm)
IP Gold Bracelet(12mm)
IP Silver Bracelet(12mm)
IP Gold Chain(14mm)
IP Silver Chain(14mm)
IP Gold Bracelet(14mm)
IP Silver Bracelet(14mm)
IP Gold Chain(16mm)
IP Silver Chain(16mm)
IP Gold Bracelet(16mm)
IP Silver Bracelet(16mm)