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, 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' LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_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 ?:product_required_products.product_id = 63174 GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC

SELECT 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 (12550) GROUP BY products.product_id   ORDER BY NULL asc

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, 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' 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  ((1  AND  products.product_id IN (63174, 63175, 63176, 63177, 63178, 63179, 63180)) AND companies.status IN ('A') AND prices.usergroup_id IN (0, 0, 1)) GROUP BY products.product_id   ORDER BY NULL asc

ROAD GEAR :: Boots :: Adventure Boots :: Forma Adventure Brown - Ridersparadise

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, 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' WHERE 1  AND ?:categories.category_id IN (493) AND products.product_id NOT IN (63174) 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 products.parent_product_id = 0 GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 3

SELECT 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 (12713, 12720, 11228) GROUP BY products.product_id   ORDER BY NULL asc

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, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL, MIN(IF (shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount) / 100)), MIN(IF (prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount) / 100))) as price, products.product_type, products.parent_product_id, products.list_price as list_price, MAX(100 - ((prices.price * 100) / products.list_price)) AS sales_discount, IF(COUNT(IF(?:categories.company_id = products.company_id, NULL, ?:categories.company_id)), 'Y', 'N') as is_shared_product FROM ?:products as products  LEFT JOIN ?:product_features_values ON ?:product_features_values.product_id = products.product_id AND ?:product_features_values.lang_code = 'en' LEFT JOIN ?:product_features ON ?:product_features_values.feature_id = ?:product_features.feature_id 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 ?:product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 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 ?:product_popularity as popularity ON popularity.product_id = products.product_id 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' LEFT JOIN ?:ult_product_prices as shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 LEFT JOIN ?:ult_product_prices as shared_prices_2 ON shared_prices.product_id = shared_prices_2.product_id AND shared_prices_2.company_id = 1 AND shared_prices_2.lower_limit = 1 AND shared_prices_2.price < shared_prices.price  AND shared_prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_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 prices_2.price IS NULL AND shared_prices_2.price IS NULL AND products.parent_product_id = 0 GROUP BY products.product_id  HAVING sales_discount > 0 AND price < list_price  ORDER BY sales_discount desc, products.product_id ASC  LIMIT 0, 6

SELECT 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 (13002, 12218, 9760, 9761, 9762, 9763) GROUP BY products.product_id   ORDER BY NULL asc

Home/ROAD GEAR/Boots/Adventure Boots/Forma Adventure Brown

Forma Adventure Brown

Write a review

€279⁹⁰

Add to cart

Forma Adventure Brown

Write a review

€279⁹⁰

(Including tax)

In stock

Color:

BROWN

Size:

42 43 44 45 46 47 48

+ −

Buy now with 1-click

Add to wish list Compare Ask a question

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 (12550) GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 100

SELECT 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 (12550) GROUP BY products.product_id   ORDER BY NULL asc

View all variations as list

Column filling

Sort by Price	Sort by Availability	Sort by CODE	Sort by Color	Sort by Size
€279⁹⁰ (Including tax)	In stock + −	DIA000ADV05-42	Color: BROWN	Size: 42
€279⁹⁰ (Including tax)	In stock + −	DIA000ADV05-43	Color: BROWN	Size: 43
€279⁹⁰ (Including tax)	In stock + −	DIA000ADV05-44	Color: BROWN	Size: 44
€279⁹⁰ (Including tax)	In stock + −	DIA000ADV05-45	Color: BROWN	Size: 45
€279⁹⁰ (Including tax)	In stock + −	DIA000ADV05-46	Color: BROWN	Size: 46
€279⁹⁰ (Including tax)	In stock + −	DIA000ADV05-47	Color: BROWN	Size: 47
€279⁹⁰ (Including tax)	In stock + −	DIA000ADV05-48	Color: BROWN	Size: 48

Delivery

DHL express - Fast

1 day, Door-to-Door, Courier Delivered

from 26€

Fedex express - International shipments

2-3 days, Tracking available

from 14€

Also available in
Compatible Products

Description

Forma Adventure Boots
Designed specifically for ADV riders, the Forma Adventure Boots combine the comfort and flexibility of a road boot with the protective features and full height of off-road boots. Equipped with a vintage leather finish and drytex waterproof/breathable lining, the Adventure Boots keep your feet dry without limiting range of motion. The double density sole offers superb grip on the bike and gives riders a comfortable and grippy surface to walk on when off the bike. Integrated TPU inserts and reinforcements provide protection from impact injuries and unbreakable GH plastic buckles ensure you won't be sidelined if you have a tip over.

Features:
   •   Full-grain oiled leather upper
   •   Updated Drytex waterproof and breathable lining
   •   Vintage leather finish
   •   Adventure double density anti slip rubber sole
   •   Injection molded plastic front plate
   •   Plastic gear pad protection
   •   Internal molded plastic protections
   •   Adjustable VELCRO® brand closures
   •   Unbreakable and adjustable GH plastic buckles
   •   Shin and ankle TPU molded plastic protections
   •   Ankle reinforcements
   •   Special rigid nylon mid-sole with steel shank
   •   Extra soft polymer padding with memory foam
   •   Anti-bacterial replaceable footbed with APS (Air Pump System)

Features