0
Киев каталог товаров
Киев
Адреса магазинов
Личный кабинет
Блокнот0

Применить
Применить

Снаряжение

Показать все товарные группы
Фильтры
Сортировать

Цена

 грн.
0 3

Наличие

Размеры (Int)

Бренд

Для кого

Сезон

Array ( [1643603] => Array ( [name] => Материал рамы [type] => dict [vals] => Array ( [1643893] => алюминий [1643894] => карбон [1643895] => сталь [1643896] => титан [1643897] => пластик ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643603 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643734] => Array ( [name] => Ход подвески, мм [type] => dict [vals] => Array ( [2145182] => 80 [2145183] => 100 [2145184] => 110 [2145185] => 120 [2145186] => 130 [2145187] => 140 [2145188] => 145 [2145189] => 150 [2145190] => 160 [2145191] => 165 [2145192] => 190 [2145193] => 200 [2145194] => 210 ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643734 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643568] => Array ( [name] => Конструкция вилки [type] => dict [vals] => Array ( [1643848] => пружинная [1643849] => пружинно-эластомерная [1643850] => воздушная [1643851] => масляно-воздушная [1643852] => масляно-пружинная [1643853] => жесткая ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643568 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643733] => Array ( [name] => Ход заднего амортизатора, мм [type] => num [vals] => Array ( [0] => 120 ) [real_vals] => Array ( ) [_sql] => select distinct(gpv.gpv_float_value) from cat_goods_paramvalues gpv left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and gpv.gpv_param_id = 1643733 and g.lastyrs_or_present = 1 and s.`sport_id` = 51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604) order by gpv_float_value asc ) [1643560] => Array ( [name] => Количество скоростей [type] => dict [vals] => Array ( [1643825] => 1 [1643826] => 2 [1643827] => 3 [1643828] => 4 [1643829] => 5 [1643830] => 6 [1643831] => 7 [1643832] => 8 [1643833] => 9 [1643834] => 10 [1643835] => 11 [1643836] => 12 [1643837] => 13 [2157943] => 14 [1643838] => 16 [1643839] => 18 [1643840] => 20 [1643841] => 21 [1643842] => 22 [1643843] => 24 [1643844] => 27 ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643560 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643661] => Array ( [name] => Размер колес в дюймах [type] => dict [vals] => Array ( [1644147] => 27,5 [1644138] => 8 [1644139] => 10 [1644140] => 12 [1644141] => 14 [1644142] => 16 [2145081] => 18 [1644143] => 20 [1644144] => 22 [1644145] => 24 [1644146] => 26 [1644148] => 28 [1644149] => 29 ) [real_vals] => Array ( [1644140] => 12 ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643661 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643715] => Array ( [name] => Тип тормозов [type] => dict [vals] => Array ( [1644224] => дисковые гидравлические [1644225] => дисковые механические [1644226] => v-brake [1644227] => клещевые [1644228] => кантилеверные [1644229] => барабанные ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643715 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643614] => Array ( [name] => Назначение [type] => dict [vals] => Array ( ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643614 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643709] => Array ( [name] => Тип велосипеда [type] => dict [vals] => Array ( [1644211] => ригид [1644212] => хардтейл [1644213] => двухподвес ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643709 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) [1643619] => Array ( [name] => Уровень оборудования [type] => dict [vals] => Array ( [1644101] => начальный [1644102] => начальный улучшенный [1644103] => средний [1644104] => полупрофессиональный [1644105] => профессиональный [1644106] => элитный ) [real_vals] => Array ( ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643619 and ( pdi_podgr2_id in (1434604) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51516 and g.`gds_podgr1_id` = 1070639 and g.`gds_podgr2_id` in (1434604)order by pdi_int_value asc ) ) 1

Размер колес в дюймах

Скидка

Найдено N товаровПоказать
Погода:   Киев +22°С
Список  \  Плитка
    нет в наличии
30% Mongoose TITLE TOT Бренд: Mongoose Сезон: 2020 3 720 грн. 2 604 грн. Наличие
50% GT MACH ONE PUSH 12" Естественное желание, которому подвержен любой ребёнок – это тяга к познанию… Бренд: GT Сезон: 2017 3 780 грн. 1 905 грн. в наличии в других городах

Информация по наличию товаров в магазинах обновляется с интервалом в 1 сутки

Уточняйте о наличии и цене товара по телефонам магазинов. Характеристики товаров в магазинах могут отличаться от приведенных на сайте

Спортивные магазины «Драйв-Спорт» в Виннице, Киеве, Днепре, Харькове, Одессе, Кривом Роге, Запорожье и Львове. Снаряжение, одежда и аксессуары для активного отдыха и спорта! Велосипеды горные и bmx, роликовые коньки и скейтборды, горные лыжи, сноуборды, ледовые коньки, туристическое снаряжение, палатки, спальные мешки. Известные марки и отличные цены!