E-Sklep »

Rower,27.5,CTM,CHARISMA 3.0,L,MAT TURKUS

Kod produktu: 223.117

Rama	L (18")	Widelec	Suntour XCT30, HLO DS 100mm, 27,5"
Tylny amortyzator		Manetki	Shimano Altus SL-M310/8sp.
Przerzutka tył	Shimano Altus RD-M370	Przerzutka przód	Shimano FD-TY700
Wolnobieg	1. Shimano HG31/8, 11-34 2. LTWOO CS-A3, 11-34	Mechanizm korbowy	Shimano FC-TY501, 42-34-24T, 170mm
Hamulce	ZOOM HB875/CL160	Obręcze	CTM ZX-lite, 584x19 BA, 32H
Opony	Freedom Transition 27,5x2,25"	Stery	IBEX 127 mm
Pedały	SP 510	Łańcuch	KMC Z7/110L
Piasty	CTM alloy center-lock 32H QR black	Mostek kierownicy	CTM LCS 50/31,8 mm
Kierownica	CTM HB-RB11W, 680/31,8 mm	Oś suportu	Neco semi-integrated
Siodło	CTM lady	Wspornik siodła	CTM SP 350x31,6 mm
Biegi	24 speed	Waga	0
Silnik		Bateria

SQL QUERY: SELECT MIN(price) AS price FROM depot_products_omnibus WHERE product_id = 9526 AND created_at >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) and price != 0.00 and price != 3559 and price !=
Error no.: 1064
Error txt: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/html/func/func_mysql.php on line 165

3559 PLN BRUTTO Najniższa cena z ostatnich 30 dni: 3559 PLN

DO KOSZYKA