SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('40204')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%AirCleanerMachines' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('AirCleanerMachines' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+AirCleanerMachines' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"AirCleanerMachines"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"AirCleanerMachines"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"AirCleanerMachines"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"AirCleanerMachines"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+AirCleanerMachines' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='AirCleanerMachines',`category_4` ='AirCleanerMachines') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'AirCleanerMachines,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('AirCleanerMachines', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Air Cleaner Machines

Refine Search
  GO
 
Brand

Honeywell(6)

Therapure(3)

Fellowes(2)

Ionic Pro(2)

Alera(1)

Envion(1)

Allergy Pro(1)

TruSens(1)

 
Country of Origin

CN(17)

 
Height

26"(2)

19.7"(1)

20.5"(1)

25.12"(1)

28.93"(1)

9.6"(1)

22 3/10"(1)

15"(1)

22.3"(1)

18.75"(1)

25.87"(1)

26.1"(1)

8.25"(1)

25"(1)

25.5"(1)

27.3"(1)

 
Width

8.5"(2)

12.8"(1)

13"(1)

16"(1)

11.5"(1)

5.7"(1)

20 4/5"(1)

13.9"(1)

10.8"(1)

6.37"(1)

7.63"(1)

9.6"(1)

9.5"(1)

4"(1)

9.25"(1)

14.7"(1)

 
Depth

8"(2)

7.5"(2)

6.9"(1)

7.12"(1)

8.12"(1)

11.21"(1)

5.7"(1)

9.5"(1)

10 4/5"(1)

9.2"(1)

10.8"(1)

6.5"(1)

7.9"(1)

3"(1)

18.4"(1)

 
Color(s)

Black(10)

White(5)

Black/Silver(1)

 
Length

7.13"(1)

8.13"(1)

 
Voltage

120 V(2)

 
Filter Types

True HEPA, Carbon(1)

 
Speeds

3(1)

 
Replacement Filter

Alera APFILTER(1)

Fellowes 9287101, 9324101(1)

Fellowes 9287514, 9324201(1)

Honeywell HRFK2(1)

Honeywell HRF-G1(1)

Honeywell HRF-G1, HRF-AP1(1)

Honeywell HRF-R3(1)

Honeywell HRF-R1, HRF-AP1(1)

Honeywell HRF-R1, HRF-R2, HRF-R3(1)

Envion TPP640F(1)

Allergy Pro 10AP200RF01(1)

TruSens AFCHZ6000-01(1)

 
Air Cleaner Machine Type

HEPA(5)

True HEPA(3)

HEPA/Carbon(2)

Ionic(2)

HEPA Type(2)

ifD(1)

Collection Blade(1)

True HEPA with UV-C(1)

 
CADR

200(1)

129 (Dust); 124 (Pollen); 126 (Smoke)(1)

196 (Dust); 188 (Pollen); 191 (Smoke)(1)

150 (Dust); 160 (Pollen); 146 (Smoke)(1)

60 (Smoke)(1)

124 (Dust); 117 (Pollen); 110 (Smoke)(1)

300 (smoke); 320 (dust); 300 (pollen)(1)

125(1)

Smoke (325)(1)

80 (Smoke)(1)

107 (Dust); 116 (Pollen); 107 (Smoke)(1)

151 (Dust); 159 (Pollen); 152 (Smoke)(1)

132 (Dust); 155 (Pollen); 137 (Smoke)(1)

145(1)

156 (Dust); 197 (Pollen); 137 (Smoke)(1)

485(1)

 
Maximum Room Size

Large(3)

Medium to Large(3)

10 x 20(1)

32 x 23.5(1)

29 x 40(1)

15 x 15(1)

10 x 9(1)

12 x 14(1)

21 ft x 22 ft(1)

Medium(1)

20 x 25(1)

Small(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander