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 < 153) 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 > 153 ) ORDER BY position ASC LIMIT 1
316L Stainless Steel Rope Chains 6mm
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Product Promotions > New Arrival

Item #: STC05

316L Stainless Steel Rope Chains 6mm

Gold 20 inch
Gold 22inch
Gold 24 inch
Gold 36 inch
Rhodium 20 inch
Rhodium 22 inch
Rhodium 24 inch
Rhodium 30 inch
Rhodium 36 inch
Black 20 inch
Black 22 inch
Black 24 inch
Black 30 inch
Black 36 inch