Query hiba: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6 (SELECT p.p_id FROM sm_shop_product AS p WHERE p.status_id='1' AND p_quantity > '0' AND p_featured='1' AND mc_id=)Query hiba: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6 (SELECT p.p_id FROM sm_shop_product AS p WHERE p.status_id='1' AND p_quantity > '0' AND p_sale='1' AND mc_id=) Kenda - Multi Motor & Bringa Kft.


KENDA K837 26*1,95
KENDA K837 26*1,95
3 190 Ft
KENDA K841A 26*1,95 KOMFORT
KENDA K841A 26*1,95 KOMFORT
3 190 Ft
KENDA K847 KROSS PLUS 26*1,95
KENDA K847 KROSS PLUS 26*1,95
3 190 Ft
KENDA K849 54-559 26*2,10
KENDA K849 54-559 26*2,10
3 190 Ft
KENDA K879  26X1,95 KWICK
KENDA K879 26X1,95 KWICK
3 190 Ft
KENDA K90 26X1,95 (SLICK)
KENDA K90 26X1,95 (SLICK)
3 190 Ft
KENDA K929 26*2,35 (58-559)
KENDA K929 26*2,35 (58-559)
3 490 Ft
KENDA K935 26*1,95 K-SHIELD PLUS
KENDA K935 26*1,95 K-SHIELD PLUS
7 990 Ft

Multi Motor & Bringa Kft.
Motorkerékpár üzlet: 2370 Dabas, Bartók Béla út 84/a.
Kerékpár üzletház: 2370 Dabas Bartók Béla út. 113.
Motorkerékpár üzlet: +36-29-361-167 +36-20-3-130-132
Motorkerékpár szerviz: +36-70-604-16-85
Kerékpár üzletház: +36-29-362-528, +36-70-3-175-502
Kerékpár szerviz: +36-29-360-244
Ügyvezető: +36-20-9-411-429
E-mail:
motor: motor@surman-motor.hu
kerékpár: info@multi-bringa.hu