Gaerne G-Dakar GTX Boots black
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 (11671) 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 (11671) GROUP BY products.product_id ORDER BY NULL asc- View all variations as list
| Sort by Price | Sort by Availability | Sort by CODE | Sort by Color | Sort by Size |
|---|---|---|---|---|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-48
|
Color:
|
Size:
|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-40
|
Color:
|
Size:
|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-41
|
Color:
|
Size:
|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-42
|
Color:
|
Size:
|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-44
|
Color:
|
Size:
|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-45
|
Color:
|
Size:
|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-46
|
Color:
|
Size:
|
|
€35990
€39990
(Including tax)
|
In stock
|
GAE000GDA01-47
|
Color:
|
Size:
|
- Also available in
- Compatible Products
For the two-wheeled travellers who goes where the adventure takes them, this boot can easily cope with all weather conditions and any terrain. This made in Italy excellence has the Upper in full grain leather with breathable and Waterproof Goretex Performance Membrane. Innovative ankle pivot system forms a flexible link between upper boot and lower foot area for added control and support. PU shin plates reinforcement, frame-gripping suede inner calf guard, aluminum buckle and Velcro strap for customized fit. The lug-soled Sole tread offers a superior grip on any terrain.
- Solid colour
- For Men
- Waterproof
No reviews found
