Каталог

Фильтры

Сбросить фильтры

Цена (руб)

от

до

Производители

Ballu

NEOCLIMA

Rexant

Ресанта

РЭМО

Наличие

Только в наличии

В наличии Петрозаводск

В наличии Архангельск

Под заказ

Select catalog_props.* from catalog_props, catalog_props_value, catalog where catalog_props.id=catalog_props_value.idp and catalog.id=catalog_props_value.idc and catalog.category=632 group by catalog_props.id order by min(catalog_props_value.pos) asc

Disk full (/tmp/#sql_76e4_12.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Климатическое оборудование: конвекторыс доставкой по России

товаров: 6

Сортировать

Код: 217327

Конвектор Fast 1500W с механическим термостатом NeoClima

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="b72866c1-0fac-11ec-80bd-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

2900c

В корзину

под заказ

Код: 226266

Конвектор BEC ETM-1000 с механическим термостатом Ballu Camino Eco Turbo

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="e90c550e-29b7-11ed-80be-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

2900c

В корзину

под заказ

Код: 246452

Конвектор REXANT 1000В Стич с механическим термостатом 60-0093 REXANT

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="ad81056f-7c96-11ef-80d4-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

2950c

В корзину

в наличии

Код: 123629

Конвектор BEC SMT-1000 с механическим термостатом Ballu Solo Turbo

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="e731cf56-e98e-11e9-8cb1-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

3050c

В корзину

под заказ

Код: 253661

Конвектор Такса СБ-1500.2 1500W с механическим термостатом РЭМО

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="fd822d36-897e-11f0-b6fb-b8ca3a5ee0db" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

3500c

В корзину

под заказ

Код: 246454

Конвектор REXANT 1000В X с механическим термостатом с ножками 60-0115 REXANT

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="ad810573-7c96-11ef-80d4-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

3700c

В корзину

в наличии