SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 90) WHERE (`e`.`entity_id` IN('1977', '2106', '2130', '2132')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HEATERS ELECTRIC INFRARED - ELEC. SPACE HEATERS - ELECTRIC HOME COMFORT APPLIANCES - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

HEATERS ELECTRIC INFRARED


View as Grid List

9 Items

per page
Set Descending Direction
  1. WALL MOUNTED INFRARED Call for Price
    HS-1000-WX INFRARED HEATER Learn More
  2. PORTABLE INFRARED QUARTZ HEATER Call for Price
    HS-1500-IPR WALN PRESTON INFRED HTR Learn More
  3. PORTABLE INFRARED QUARTZ HEATER Call for Price
    HS-1500-ISM OAK SMITHFLD INFRD HTR Learn More
  4. COMFORT GLOW COMPACT INFRARED QUARTZ COMFORT SYSTEM Call for Price
    QDE1320 INFRARED HEATER QTZ Learn More
  5. MOJAVE INFRARED HEATER Call for Price
    HS-1500-MJV INFARD HTR MOJAVE 1500W Learn More
  6. PURE HEAT PATIO HEATER Call for Price
    PURE HEAT PATIO HEATER Learn More
  7. PURE HEAT 2 IN 1 Call for Price
    PURE HEAT 2IN1 HEATER BLK Learn More
  8. PUREHEAT SNUG WALL PLUG HEATER Call for Price
    PURE HEAT SNUG HEATER Learn More
  9. PURE HEATER 3 IN 1 Call for Price
    PURE HEAT 3IN1 HEATER Learn More
View as Grid List

9 Items

per page
Set Descending Direction