Выберите раздел:
SELECT DISTINCT B.value FROM modx_site_tmplvar_contentvalues as B LEFT JOIN modx_site_content as A ON (B.contentid = A.id) WHERE A.parent IN(18,17,19,20,21,22,23,24,26,1715,12) and B.tmplvarid=5
Mitsubishi Electric PEAD-RP100 JAQ / PUHZ-P100VHA
Mitsubishi Electric PEAD-RP71 JAQ / SUZ-KA71VA
Mitsubishi Electric PEAD-RP60 JAQ / SUZ-KA60VA
Mitsubishi Electric PEAD-RP50 JAQ / SUZ-KA50VA
Mitsubishi Electric PEAD-RP140 JAQ / PUHZ-ZRP140YKA
Mitsubishi Electric PEAD-RP71 JAQ / PUHZ-ZRP71VHA
Mitsubishi Electric PEAD-RP60 JAQ / PUHZ-ZRP60VHA
Mitsubishi Electric PEAD-RP50 JAQ / PUHZ-ZRP50VKA
Mitsubishi Electric PEAD-RP35 JAQ / PUHZ-ZRP35VKA
Mitsubishi Electric PEAD-RP140 JAQ / PUHZ-ZRP140VKA
Mitsubishi Electric PEAD-RP125 JAQ / PUHZ-ZRP125YKA
Mitsubishi Electric PEAD-RP125 JAQ / PUHZ-ZRP125VKA
Mitsubishi Electric PEAD-RP140 JAQ / PU-P140YHA
Mitsubishi Electric PEAD-RP125 JAQ / PU-P125YHA
Mitsubishi Electric PEAD-RP100 JAQ / PU-P100 VHA / YHA
Mitsubishi Electric PEAD-RP71 JAQ / PU-P71VHA / YHA
Mitsubishi Electric PEAD-RP140 JAQ / PUH-P140YHA
Mitsubishi Electric PEAD-RP125 JAQ / PUH-P125YHA
Mitsubishi Electric PEAD-RP100 JAQ / PUH-P100 VHA/YHA
Mitsubishi Electric PEAD-RP71 JAQ / PUH-P71VHA/YHA
Mitsubishi Electric PLA-RP140 ВA / PUHZ-P140YHA
Охлаждение, кВт: 13.6
Площадь, м2: 135
Компрессор: Инвертор
Mitsubishi Electric PLA-RP140 ВA / PUHZ-P140VHA
Mitsubishi Electric PLA-RP125 ВA / PUHZ-P125YHA
Охлаждение, кВт: 12.3
Площадь, м2: 123
Mitsubishi Electric PLA-RP125 ВA / PUHZ-P125VHA
Запрос цены
Получить скидку 15%
Введите номер телефона *:
Заказ в 1 клик
Введите email: