Doprava Zdarma na všechny objednávky
nemáte v košíku žádné zboží
Vyhledávání pneumatik
×
osobní, SUV, dodávky MOTORKOVÉ ČTYŘKOLKOVÉ VETERÁNSKÉ PŘÍVĚSOVÉ
Šířka
Profil
Palce

Letní pneumatiky SUMITOMO 205/70 R15

:tabulkové podrobné
:nejlevnější | nejdražší
:
: : ×
SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by znacka_nocs

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched
SUMITOMO × :
SELECT distinct(valivy_odpor2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by valivy_odpor2

1 row fetched
C × :
SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by prilnavost_na_mokru2

1 row fetched
B × ×

SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `znacka_nocs` <> "") AND skladem>3 order by znacka_nocs

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

1 row fetched

SELECT distinct(li) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `li` <> "") AND skladem>3 order by li

1 row fetched

90
95
96
100
104
106
107

SELECT distinct(si) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `si` <> "") AND skladem>3 order by si

1 row fetched

H
Q
R
S
T
W

SELECT distinct(valivy_odpor2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" 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="C" >C</option>

strlen 58

SELECT distinct(RF) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by RF

1 row fetched

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

count = 1

SELECT distinct(valivy_odpor2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `valivy_odpor2` <> "") AND skladem>3 order by valivy_odpor2

1 row fetched

A
B
C
D
E

SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" 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 ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" 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

1 row fetched

A
B
C
D
E

SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" 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 ( `tmp2`="L" and `sirka`="205" and `profil`="70" and `palce`="R15" and `znacka_nocs`="sumitomo" and `valivy_odpor2` <= "D" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ") AND `hlucnost2` <> "") AND skladem>3 order by hlucnost2

1 row fetched

67
68
69
70
71
72
73
75
BC100
SUMITOMO
skladem
SUMITOMO BC100
205/70 R15 96T
C  B  69 
expedice: 14.04.2025

2 307 Kč

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

ExpertPneumatiky.cz

vytvořilo intencio s.r.o.