SELECT `p`.`id`, `p`.currency_id, `p`.`bg_title` AS productTitle, `p`.`bg_text` AS productText, `p`.`new`, `t`.`id` AS typeId, `t`.`bg_title` AS typeTitle, `v`.`id` AS vidId, `v`.`bg_title` as vidTitle, `p`.`shum` as shum, `p`.`info_url` as infoUrl, ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS price, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS pprice, IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) AS real_price, `p`.`dds`, `p`.`nalichnost`, `p`.`diameter`, `p`.`width`, `p`.`height`, `p`.`t_index`, `p`.`s_index`, `p`.`rft`, `p`.`shum`, `p`.`shum_db`, `p`.`povedenie_mokro`, `p`.`sypr_tyrk`, `p`.`bg_seotitle` as title, `p`.`bg_seodesc` as descr, `p`.`bg_seokeywords` as keyw, `b`.`id` AS brandId, `b`.`bg_title` AS brandTitle, `b`.`image` AS brandImage, `i`.`image` AS modelImage, CASE WHEN `p`.`shum_db` > 0 AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 1 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 2 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 3 ELSE 0 END AS noise, (SELECT IFNULL(AVG(`rating`), 0) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '' AND `rating` > 0) AS rating, (SELECT COUNT(`id`) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '') AS reviews FROM `g_products` AS p LEFT JOIN `g_brands` AS b ON `p`.`brand_id` = `b`.`id` LEFT JOIN `g_types` AS t ON `p`.`type_id` = `t`.`id` LEFT JOIN `g_vidove` AS v ON `p`.`vid_id` = `v`.`id` LEFT JOIN `g_models_image` AS i ON `p`.`bg_title` = `i`.`model` AND `p`.`brand_id` = `i`.`brand_id` WHERE `p`.`active` = 1 AND `p`.`enabled` = 1 AND `p`.`status` = 1 AND p.nalichnost > 1 AND `b`.`active` = 1 AND `v`.`active` = 1 AND `v`.`enabled` = 1 AND `b`.`enabled` = 1 AND `t`.`enabled` = 1 AND `t`.`active` = 1 AND IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) > 0 AND `p`.`id` = 94431

SELECT `p`.`id`, `p`.currency_id, `p`.`bg_title` AS productTitle, `p`.`bg_text` AS productText, `p`.`new`, `t`.`id` AS typeId, `t`.`bg_title` AS typeTitle, `v`.`id` AS vidId, `v`.`bg_title` as vidTitle, `p`.`shum` as shum, `p`.`info_url` as infoUrl, ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS price, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS pprice, IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) AS real_price, `p`.`dds`, `p`.`nalichnost`, `p`.`diameter`, `p`.`width`, `p`.`height`, `p`.`t_index`, `p`.`s_index`, `p`.`rft`, `p`.`shum`, `p`.`shum_db`, `p`.`povedenie_mokro`, `p`.`sypr_tyrk`, `p`.`bg_seotitle` as title, `p`.`bg_seodesc` as descr, `p`.`bg_seokeywords` as keyw, `b`.`id` AS brandId, `b`.`bg_title` AS brandTitle, `b`.`image` AS brandImage, `i`.`image` AS modelImage, CASE WHEN `p`.`shum_db` > 0 AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 1 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 2 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 3 ELSE 0 END AS noise, (SELECT IFNULL(AVG(`rating`), 0) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '' AND `rating` > 0) AS rating, (SELECT COUNT(`id`) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '') AS reviews FROM `g_products` AS p LEFT JOIN `g_brands` AS b ON `p`.`brand_id` = `b`.`id` LEFT JOIN `g_types` AS t ON `p`.`type_id` = `t`.`id` LEFT JOIN `g_vidove` AS v ON `p`.`vid_id` = `v`.`id` LEFT JOIN `g_models_image` AS i ON `p`.`bg_title` = `i`.`model` AND `p`.`brand_id` = `i`.`brand_id` WHERE `p`.`active` = 1 AND `p`.`enabled` = 1 AND `p`.`status` = 1 AND p.nalichnost > 1 AND `b`.`active` = 1 AND `v`.`active` = 1 AND `v`.`enabled` = 1 AND `b`.`enabled` = 1 AND `t`.`enabled` = 1 AND `t`.`active` = 1 AND IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) > 0 AND `p`.`id` = 94431

SELECT `p`.`id`, `p`.currency_id, `p`.`bg_title` AS productTitle, `p`.`bg_text` AS productText, `p`.`new`, `t`.`id` AS typeId, `t`.`bg_title` AS typeTitle, `v`.`id` AS vidId, `v`.`bg_title` as vidTitle, `p`.`shum` as shum, `p`.`info_url` as infoUrl, ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS price, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS pprice, IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) AS real_price, `p`.`dds`, `p`.`nalichnost`, `p`.`diameter`, `p`.`width`, `p`.`height`, `p`.`t_index`, `p`.`s_index`, `p`.`rft`, `p`.`shum`, `p`.`shum_db`, `p`.`povedenie_mokro`, `p`.`sypr_tyrk`, `p`.`bg_seotitle` as title, `p`.`bg_seodesc` as descr, `p`.`bg_seokeywords` as keyw, `b`.`id` AS brandId, `b`.`bg_title` AS brandTitle, `b`.`image` AS brandImage, `i`.`image` AS modelImage, CASE WHEN `p`.`shum_db` > 0 AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 1 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 2 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 3 ELSE 0 END AS noise, (SELECT IFNULL(AVG(`rating`), 0) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '' AND `rating` > 0) AS rating, (SELECT COUNT(`id`) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '') AS reviews FROM `g_products` AS p LEFT JOIN `g_brands` AS b ON `p`.`brand_id` = `b`.`id` LEFT JOIN `g_types` AS t ON `p`.`type_id` = `t`.`id` LEFT JOIN `g_vidove` AS v ON `p`.`vid_id` = `v`.`id` LEFT JOIN `g_models_image` AS i ON `p`.`bg_title` = `i`.`model` AND `p`.`brand_id` = `i`.`brand_id` WHERE `p`.`active` = 1 AND `p`.`enabled` = 1 AND `p`.`status` = 1 AND p.nalichnost > 1 AND `b`.`active` = 1 AND `v`.`active` = 1 AND `v`.`enabled` = 1 AND `b`.`enabled` = 1 AND `t`.`enabled` = 1 AND `t`.`active` = 1 AND IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) > 0 AND `p`.`id` = 94431

SELECT `p`.`id`, `p`.currency_id, `p`.`bg_title` AS productTitle, `p`.`bg_text` AS productText, `p`.`new`, `t`.`id` AS typeId, `t`.`bg_title` AS typeTitle, `v`.`id` AS vidId, `v`.`bg_title` as vidTitle, `p`.`shum` as shum, `p`.`info_url` as infoUrl, ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS price, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) AS pprice, IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) AS real_price, `p`.`dds`, `p`.`nalichnost`, `p`.`diameter`, `p`.`width`, `p`.`height`, `p`.`t_index`, `p`.`s_index`, `p`.`rft`, `p`.`shum`, `p`.`shum_db`, `p`.`povedenie_mokro`, `p`.`sypr_tyrk`, `p`.`bg_seotitle` as title, `p`.`bg_seodesc` as descr, `p`.`bg_seokeywords` as keyw, `b`.`id` AS brandId, `b`.`bg_title` AS brandTitle, `b`.`image` AS brandImage, `i`.`image` AS modelImage, CASE WHEN `p`.`shum_db` > 0 AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 1 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) - 3 + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) AND `p`.`shum_db` <= (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 2 WHEN `p`.`shum_db` > (SELECT IF( `t`.`id` = 2, `limit_value_ms`, `limit_value` ) + IF( `v`.`id` IN ( 1, 2 ), 0, 2 ) AS limit_value FROM `g_noises` WHERE CONVERT( `p`.`width`, UNSIGNED ) >= `min_width` AND CONVERT( `p`.`width`, UNSIGNED ) <= `max_width` LIMIT 1) THEN 3 ELSE 0 END AS noise, (SELECT IFNULL(AVG(`rating`), 0) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '' AND `rating` > 0) AS rating, (SELECT COUNT(`id`) FROM `g_opinions` WHERE `product_id` = `p`.`id` AND `bg_title` <> '' AND `mail` <> '') AS reviews FROM `g_products` AS p LEFT JOIN `g_brands` AS b ON `p`.`brand_id` = `b`.`id` LEFT JOIN `g_types` AS t ON `p`.`type_id` = `t`.`id` LEFT JOIN `g_vidove` AS v ON `p`.`vid_id` = `v`.`id` LEFT JOIN `g_models_image` AS i ON `p`.`bg_title` = `i`.`model` AND `p`.`brand_id` = `i`.`brand_id` WHERE `p`.`active` = 1 AND `p`.`enabled` = 1 AND `p`.`status` = 1 AND p.nalichnost > 1 AND `b`.`active` = 1 AND `v`.`active` = 1 AND `v`.`enabled` = 1 AND `b`.`enabled` = 1 AND `t`.`enabled` = 1 AND `t`.`active` = 1 AND IF( `p`.`pprice` > 0, ROUND ( IF ( `p`.`dds` = 1, `p`.`pprice`, `p`.`pprice` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ), ROUND ( IF ( `p`.`dds` = 1, `p`.`price`, `p`.`price` * 1.2 ) * ( SELECT IF ( `b`.`charge` = 0, 1, 1 + ( `b`.`charge` / 100 ) ) FROM `g_brands` WHERE `g_brands`.`id` = `p`.`brand_id` ) / 100, 2 ) ) > 0 AND `p`.`id` = 94431

Летни гуми TOYO OPEN COUNTRY A/T Ⅲ | 265/65 R17 | E-gumi
Продукти:0
0.00
Рейтинг

Летни гуми TOYO OPEN COUNTRY A/T Ⅲ

265/65 R17

Налични над 20 +
Всички доставки на летни гуми са с нов ДОТ!
Безплатна доставка при поръчка над 400 евро / 782.33 лв
Товарен индекс
Скоростен индекс
Run-flat
112
H
не

73
D
D
167.33 €
Сподели в
TOYO
265/65 R17 112H
C1
A B C
73dB

Подобни гуми
Летни гуми LINGLONG GREEN-MAX 4×4 HP 265/65 R17
C
C
72
Налични над 10 +|Доставка от 1 до 2 дни
98.60 €
виж повече
Летни гуми MICHELIN LATITUDE CROSS 265/65 R17
C
C
71
Налични над 20 +|Доставка от 1 до 2 дни
219.89 €
виж повече
Летни гуми GRIPMAX STATURE H/T 265/65 R17
B
C
72
Налични над 10 +|Доставка от 1 до 2 дни
99.47 €
виж повече
Летни гуми NANKANG CONQUEROR R/T RT 265/65 R17
P.O.R.
P.O.R.
73
Налични над 10 +|Доставка от 1 до 2 дни
143.02 €
виж повече

Добави отзив за Летни гуми TOYO OPEN COUNTRY A/T Ⅲ 265/65 R17

Добави оценка



Клиентите за нас

APOLLO (177)
ATTAR (1)
AUSTONE (118)
AUTEL (1)
BARUM (279)
BFGOODRICH (390)
BRIDGESTONE (615)
COMFORCER (1)
CONTINENTAL (788)
COOPER (109)
DEBICA (113)
DUNLOP (126)
FIRESTONE (280)
FORTUNE (16)
FULDA (202)
GENERAL TIRE (175)
GISLAVED (6)
GOODRIDE (307)
GOODYEAR (514)
GRIPMAX (202)
KLEBER (122)
KORMORAN (289)
KUMHO (626)
LINGLONG (368)
MARSHAL (82)
MATADOR (227)
MATRAX (62)
MICHELIN (991)
MILEVER (9)
NANKANG (408)
NEXEN (429)
ONYX (142)
PIRELLI (743)
POINT S (49)
PRINX (43)
RIKEN (317)
ROADSTONE (2)
SAVA (1)
SONIX (170)
TAURUS (302)
TOYO (456)
TRIANGLE (245)
UNIROYAL (316)
VREDESTEIN (500)
РУСКИ (1)