Doprava Zdarma na všechny objednávky
Vyhledávání pneumatik
×
Šířka
Profil
Palce

Zvolte prosím období, ve kterém chcete vybrat pneumatiky

235/55 R19

:tabulkové podrobné
:nejlevnější | nejdražší
:
: :
SELECT distinct(si) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by si

$sql_shop->num_rows($res)3

1 row fetched

1 row fetched

1 row fetched
W ×
:
SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by prilnavost_na_mokru2

$sql_shop->num_rows($res)1

1 row fetched
×
:
SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by hlucnost2

$sql_shop->num_rows($res)6

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched
×
×

SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `znacka_nocs` <> "") AND skladem>3 order by znacka_nocs

$sql_shop->num_rows($res)3

1 row fetched

1 row fetched

1 row fetched

×

všechny značky

SELECT distinct(li) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `li` <> "") AND skladem>3 order by li

$sql_shop->num_rows($res)1

1 row fetched

101
108

SELECT distinct(si) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `si` <> "") AND skladem>3 order by si

$sql_shop->num_rows($res)3

1 row fetched

1 row fetched

1 row fetched

H
R
T
V
W
Y

SELECT distinct(valivy_odpor2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by valivy_odpor2

$valivy_odpor_select <option value="">---</option><option value="" ></option>

strlen 56

SELECT distinct(RF) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by RF

$sql_shop->num_rows($res)1

1 row fetched

$val_od_db_vals_arr Array ( [0] => Array ( [RF] => XL ) )

count = 1

SELECT distinct(valivy_odpor2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `valivy_odpor2` <> "") AND skladem>3 order by valivy_odpor2

$sql_shop->num_rows($res)0

A
B
C
D
E

SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by prilnavost_na_mokru2

SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `prilnavost_na_mokru2` <> "") AND skladem>3 order by prilnavost_na_mokru2

$sql_shop->num_rows($res)0

A
B
C
D
E

SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and `hlucnost2` <= "66" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by hlucnost2

SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R19" and `si`="W" and `prilnavost_na_mokru2` <= "C" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `hlucnost2` <> "") AND skladem>3 order by hlucnost2

$sql_shop->num_rows($res)5

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

66
67
GREEN-MAX XL
LINGLONG
skladem
LINGLONG GREEN-MAX XL
235/55 R19 XL 105W
72 
expedice: 11.04.2025

2 824

CROSS SEASONS AW-6 XL
NANKANG
skladem
72 
expedice: 09.04.2025

3 033

CROSS SPORT SP-9 XL
NANKANG
skladem
NANKANG CROSS SPORT SP-9 XL
235/55 R19 XL 105W
72 
expedice: 14.04.2025

3 948

S FIT EQ (LK01) XL
LAUFENN
skladem
LAUFENN S FIT EQ (LK01) XL
235/55 R19 XL 105W
72 
expedice: 14.04.2025

7 192

TIP: Objednejte si kompletní kola – vyberte pneu + vyberte disky na Váš vůz, my Vám je zkompletujeme, nahustíme a vyvážíme za 224Kč/kus.

Kontakt a provozní doba

telefon: +420 725 850 112

e-mail: info@expertpneumatiky.cz

Po - Pá: 09:00 - 17:00

vytvořilo intencio s.r.o.