Tur Himalaya Hydroscud® Jacket black/grey
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1 AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND variation_group_products.group_id IN (10996) GROUP BY products.product_id ORDER BY product asc, products.product_id ASC LIMIT 0, 100SELECT SQL_CALC_FOUND_ROWS products.product_id, products.amount, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1 AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND variation_group_products.group_id IN (10996) GROUP BY products.product_id ORDER BY NULL asc- View all variations as list
- Also available in
- Compatible Products
4-season adventure jacket, EN 17092:2020 certified – class AA.
Features
- The main fabric is made of Polystrong 600D, with Drop Safe treatment.
- Sides and sleeves made of high–tenacity Profiber stretch fabric.
- Presence of high–tenacity Xtr–M mesh inserts.
- The removable membrane is HYDROSCUD® 100% waterproof and
breathable.
- The removable thermal padding is highly thermoregulating.
- The fixed inner lining is made of breathable, perforated polyester.
- At the front 2 AIRFLOW System air intakes.
- Two AIRFLOW System ventilation holes on the back, adjustable
through zips.
- AIRFLOW System ventilation holes on the sleeves, adjustable
through zips.
- The protectors on the shoulders and elbows are EASYFLEX – Level 2.
- Attachment system for CPS back protection – Level 2 (optional – Code
T8024).
- Presence of high–visibility reflective zones.
- 4 pockets (2 waterproof) on the front + 1 large pocket on the back.
- 4 pockets inside + 1 mobile phone pocket.
- Adjustments on arm, forearm and waist with zip.
- The collar with soft insert is equipped with a micrometric closure and
an anti–flapping hook.
- Elastic device for connecting jacket to trousers, with universal zip.
- Crotch straps.
- Graphics
- For Men
No reviews found
