г.Хабаровск, ул. Лучистая, 23
8 (4212) 28-86-80, 8 (914) 543-86-80
главная
Каталог ОБВЕСОВ
Доставка и оплата
Наши работы
Наши установки
Полезная информация
Рекомендации
Контакты
Instagram
Автотюнинг - реплика
HONDA
LEXUS
MAZDA
MERCEDES-BENZ
MITSUBISHI
NISSAN
Cedric 32
Cedric 33
Datsun 21
Fuga
Murano 51
Silvia 15
Skyline 33
Skyline 34
Skyline 35
Skyline 35 Купе
Terrano 21
Tiida
Tiida Latio
Wingroad 12
SUBARU
TOYOTA
Главная
Автотюнинг - реплика
NISSAN
Tiida
jshopCategory Object ( [_list_fields] => Array ( [0] => category_id [1] => category_image [2] => category_parent_id [3] => category_publish [4] => category_ordertype [5] => category_template [6] => ordering [7] => category_add_date [8] => products_page [9] => products_row [10] => name_en-GB [11] => alias_en-GB [12] => short_description_en-GB [13] => description_en-GB [14] => meta_title_en-GB [15] => meta_description_en-GB [16] => meta_keyword_en-GB [17] => name_ru-RU [18] => alias_ru-RU [19] => short_description_ru-RU [20] => description_ru-RU [21] => meta_title_ru-RU [22] => meta_description_ru-RU [23] => meta_keyword_ru-RU ) [_tbl] => #__jshopping_categories [_tbl_key] => category_id [_db] => JDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name FROM `tuning_jshopping_products` AS prod LEFT JOIN `tuning_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `tuning_jshopping_manufacturers` as man on prod.product_manufacturer_id=man.manufacturer_id WHERE categ.category_id = '148' AND prod.product_publish = '1' AND prod.product_manufacturer_id!=0 order by name [_errorNum] => 0 [_errorMsg] => [_table_prefix] => tuning_ [_resource] => Resource id #26 [_cursor] => Resource id #131 [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) ) [_errors] => Array ( ) [category_id] => 148 [category_image] => 56fdcd2061c956bc48b7a6bf1661212b.jpg [category_parent_id] => 46 [category_publish] => 1 [category_ordertype] => 1 [ordering] => 13 [category_add_date] => 2013-07-23 05:17:33 [products_page] => 15 [products_row] => 3 [name_en-GB] => [alias_en-GB] => [short_description_en-GB] => [description_en-GB] => [meta_title_en-GB] => [meta_description_en-GB] => [meta_keyword_en-GB] => [name_ru-RU] => Tiida [alias_ru-RU] => [short_description_ru-RU] => [description_ru-RU] => [meta_title_ru-RU] => [meta_description_ru-RU] => [meta_keyword_ru-RU] => [name] => Tiida [description] => [short_description] => [meta_title] => Tiida [meta_keyword] => [meta_description] => [category_template] => default )
Tiida
Количество:
5
10
15
20
25
50
Производитель:
Все
Цена:
от
До
Сбросить фильтр
Обвес аэродинамический Тюнинг
Передняя, задняя накладки, пороги.
18 000.00
Подробнее
Обвес аэродинамический Тюнинг
Комплект: передняя, задняя накладки, пороги Материал стеклопластик (высококачественные, импортные компоненты) прочен, эластичен, морозоустойчив.
18 000.00
Подробнее
Тюнинг Tiida
Передняя накладка стоковая
4 500.00
Подробнее
Категории