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_1` LIKE 'Facility & Breakroom') AND (`category_2` LIKE 'Climate Control') AND `pinfo`.`country`='US' AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%ClimateControl' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ClimateControl' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ClimateControl' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ClimateControl"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ClimateControl"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ClimateControl"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ClimateControl"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ClimateControl' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ClimateControl',`category_4` ='ClimateControl') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ClimateControl,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ClimateControl', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Climate Control

Refine Search

  GO
 
Brand

Accumulair(129)

Shop-Vac(3)

Chartpak(2)

Church & Dwight(1)

General(1)

MetroVac(1)

 
Color

White(130)

Orange(1)

Stainless Steel(1)

 
Recycled

Yes(129)

No(6)

 
Packaged Quantity

4(129)

1 Each(4)

8(1)

1 / Each(1)

 
Assembly Required

No(135)

 
Limited Warranty

1 Year(3)

 
Weight (Approximate)

4 oz(1)

2.75 lb(1)

 
Special Features

Aluminum Engineers Ruler, 12", Silver(1)

 
Recycled Content

40%(129)

 
Diameter

16"(1)

 
Form Factor

Handheld(1)

 
Device Supported

Furnace(129)

Air Conditioner(129)

Refrigerator(1)

 
Input Voltage

120 V AC(1)

 
Measurement System

Imperial(1)

Metric(1)

 
Measuring Edge

Triple(1)

 
Speed Settings

3(1)

 
Air Flow

523.6 gal/min(1)

 
Fan Diameter

24" Blade Span(1)

16" Blade Span(1)

 
Manufacturer Part Number

3320001710CT(1)

FB24X244(1)

FD14X254(1)

FD14X244(1)

FD14X204(1)

FD14X184(1)

FD14X144(1)

FD13X215A4(1)

FD12X304(1)

FD12X244(1)

FD12X204(1)

FD12X124(1)

FD10X244(1)

FD10X204(1)

FB25X254(1)

FB24X304(1)

FB22X244(1)

FD15X204(1)

FB22X224(1)

FB21X23A4(1)

FB215X2325A4(1)

FB20X304(1)

FB20X254(1)

FB20X244(1)

FB20X22A4(1)

FB20X224(1)

FB20X21A4(1)

FB20X215A4(1)

FB20X204(1)

FB1988X215A4(1)

FB18X304(1)

FB18X254(1)

FD14X304(1)

FD1638X215A4(1)

FB18X20A4(1)

FD20X22A4(1)

1185000(1)

1034200(1)

ED-500(1)

3001(1)

FD25X254(1)

FD24X304(1)

FD24X244(1)

FD22X244(1)

FD22X224(1)

FD21X23A4(1)

FD215X2325A4(1)

FD20X304(1)

FD20X254(1)

FD20X244(1)

FD20X224(1)

FD16X164(1)

FD18X204(1)

FD16X204(1)

FD16X244(1)

FD16X254(1)

FD16X304(1)

FD17X224(1)

FD18X184(1)

FD18X20A4(1)

FD20X21A4(1)

FD18X244(1)

FD18X254(1)

FD18X304(1)

FD1988X215A4(1)

FD20X204(1)

FD20X215A4(1)

FB18X244(1)

FB18X204(1)

238(1)

FA1638X215A4(1)

FA20X204(1)

FA1988X215A4(1)

FA18X304(1)

FA18X254(1)

FA18X244(1)

FA18X20A4(1)

FA18X204(1)

FA18X184(1)

FA17X224(1)

FA16X304(1)

FA16X254(1)

FA16X244(1)

FA16X204(1)

FA16X164(1)

FA15X204(1)

FA20X21A4(1)

FA14X304(1)

FA14X254(1)

FA14X244(1)

FA14X204(1)

FA14X184(1)

FA14X144(1)

FA13X215A4(1)

FA12X304(1)

FA12X244(1)

FA12X204(1)

FA12X124(1)

FA10X244(1)

FA10X204(1)

240(1)

FA20X215A4(1)

FA20X224(1)

FB18X184(1)

FB13X215A4(1)

FB17X224(1)

FB16X304(1)

FB16X254(1)

FB16X244(1)

FB16X204(1)

FB16X164(1)

FB1638X215A4(1)

FB15X204(1)

FB14X304(1)

FB14X254(1)

FB14X244(1)

FB14X204(1)

FB14X184(1)

FB14X144(1)

FB12X304(1)

FA20X22A4(1)

FA22X244(1)

FA20X244(1)

FA20X254(1)

FA20X304(1)

FA215X2325A4(1)

FA21X23A4(1)

FA22X224(1)

FA24X244(1)

FB12X244(1)

FA24X304(1)

FA25X254(1)

FB10X204(1)

FB10X244(1)

FB12X124(1)

FB12X204(1)

1186200(1)

 
Country of Origin

United States(135)

US(2)

 
Material

Aluminum(1)

Steel(1)

Stainless Steel(1)

Galvanized Metal(1)

Galvanized Steel(1)

Aluminum Blade(1)

Plastic(1)

Stainless Steel Body(1)

Plastic Blade(1)

 
Height

20"(22)

14"(18)

16"(15)

18"(15)

12"(12)

10"(6)

24"(6)

22"(6)

25"(3)

21"(3)

21.5"(3)

19.9"(3)

17.8"(3)

17"(3)

16.4"(3)

15"(3)

13"(3)

19.5"(2)

32.5"(1)

13.3"(1)

 
Width

24"(23)

20"(22)

30"(18)

25"(15)

21.5"(13)

22"(10)

18"(6)

21"(4)

23"(3)

12"(3)

14"(3)

16"(3)

23.3"(3)

19.8"(2)

12.3"(1)

1"(1)

23.8"(1)

20.8"(1)

 
Depth

1"(129)

 
Color(s)

Silver(1)

Stainless Steel(1)

 
Material(s)

Aluminum(1)

Stainless Steel(1)

 
Length

12"(2)

6"(1)

31.3"(1)

20.8"(1)

 
Power Consumption

149.14 W(1)

90 W(1)

 
Graduations

1/16(1)

1/8(1)

1/4(1)

1/2(1)

1/32(1)

1(1)

 
Number of Blades

3(1)

6(1)

 
Ruler Type

Triangular Scale(1)

Standard/Metric(1)

 
Standard Scale

1/32"; 1/64"(1)

 
 
 

© 2020-2021 Dawkins Office Supplies and Equipment Co., All Rights Reserved