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') 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)

General(1)

MetroVac(1)

 
Color

White(130)

Stainless Steel(1)

 
Recycled

Yes(129)

No(5)

 
Packaged Quantity

4(129)

1 Each(4)

1 / Each(1)

 
Assembly Required

No(134)

 
Limited Warranty

1 Year(3)

 
Weight (Approximate)

2.75 lb(1)

4 oz(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)

 
Input Voltage

120 V AC(1)

 
Measurement System

Metric(1)

Imperial(1)

 
Measuring Edge

Triple(1)

 
Speed Settings

3(1)

 
Air Flow

523.6 gal/min(1)

 
Fan Diameter

16" Blade Span(1)

24" Blade Span(1)

 
Manufacturer Part Number

FD12X124(1)

FD12X204(1)

FD12X244(1)

FD10X244(1)

FD10X204(1)

FB24X304(1)

FB25X254(1)

FD12X304(1)

FD13X215A4(1)

FD14X254(1)

FD14X304(1)

FD15X204(1)

FD14X244(1)

FD14X204(1)

FD14X144(1)

FD14X184(1)

FB24X244(1)

FB22X244(1)

FB20X204(1)

FB20X215A4(1)

FB20X21A4(1)

FB1988X215A4(1)

FB18X304(1)

FB18X244(1)

FB18X254(1)

FB20X224(1)

FB20X22A4(1)

FB21X23A4(1)

FB22X224(1)

FB215X2325A4(1)

FB20X304(1)

FB20X244(1)

FB20X254(1)

FD1638X215A4(1)

FD16X164(1)

FD21X23A4(1)

FD22X224(1)

FD22X244(1)

FD215X2325A4(1)

FD20X304(1)

FD20X244(1)

FD20X254(1)

FD24X244(1)

FD24X304(1)

1185000(1)

1186200(1)

1034200(1)

ED-500(1)

FD25X254(1)

3001(1)

FD20X22A4(1)

FD20X224(1)

FD17X224(1)

FD18X184(1)

FD18X204(1)

FD16X304(1)

FD16X254(1)

FD16X204(1)

FD16X244(1)

FD18X20A4(1)

FD18X244(1)

FD20X215A4(1)

FD20X21A4(1)

FD20X204(1)

FD1988X215A4(1)

FD18X254(1)

FD18X304(1)

FB18X20A4(1)

FB18X204(1)

FA17X224(1)

FA18X184(1)

FA18X204(1)

FA16X304(1)

FA16X254(1)

FA16X204(1)

FA16X244(1)

FA18X20A4(1)

FA18X244(1)

FA20X215A4(1)

FA20X21A4(1)

FA20X204(1)

FA1988X215A4(1)

FA18X254(1)

FA18X304(1)

FA16X164(1)

FA1638X215A4(1)

FA12X204(1)

FA12X244(1)

FA12X304(1)

FA12X124(1)

FA10X244(1)

240(1)

FA10X204(1)

FA13X215A4(1)

FA14X144(1)

FA14X304(1)

FA15X204(1)

FA14X254(1)

FA14X244(1)

FA14X184(1)

FA14X204(1)

FA20X224(1)

FA20X22A4(1)

FB14X254(1)

FB14X304(1)

FB15X204(1)

FB14X244(1)

FB14X204(1)

FB14X144(1)

FB14X184(1)

FB1638X215A4(1)

FB16X164(1)

FB17X224(1)

FB18X184(1)

FB16X304(1)

FB16X254(1)

FB16X204(1)

FB16X244(1)

FB13X215A4(1)

FB12X304(1)

FA21X23A4(1)

FA22X224(1)

FA22X244(1)

FA215X2325A4(1)

FA20X304(1)

FA20X244(1)

FA20X254(1)

FA24X244(1)

FA24X304(1)

FB12X204(1)

FB12X244(1)

FB12X124(1)

FB10X244(1)

FA25X254(1)

FB10X204(1)

238(1)

 
Country of Origin

United States(134)

US(2)

 
Material

Plastic(1)

Stainless Steel Body(1)

Plastic Blade(1)

Aluminum Blade(1)

Galvanized Steel(1)

Steel(1)

Stainless Steel(1)

Galvanized Metal(1)

Aluminum(1)

 
Height

20"(22)

14"(18)

18"(15)

16"(15)

12"(12)

10"(6)

22"(6)

24"(6)

21.5"(3)

25"(3)

21"(3)

17.8"(3)

13"(3)

15"(3)

16.4"(3)

17"(3)

19.9"(3)

19.5"(2)

13.3"(1)

32.5"(1)

 
Width

24"(23)

20"(22)

30"(18)

25"(15)

21.5"(13)

22"(10)

18"(6)

21"(4)

23"(3)

23.3"(3)

16"(3)

12"(3)

14"(3)

19.8"(2)

20.8"(1)

12.3"(1)

1"(1)

23.8"(1)

 
Depth

1"(129)

 
Color(s)

Stainless Steel(1)

Silver(1)

 
Material(s)

Stainless Steel(1)

Aluminum(1)

 
Length

12"(2)

20.8"(1)

6"(1)

31.3"(1)

 
Power Consumption

90 W(1)

149.14 W(1)

 
Graduations

1/32(1)

1(1)

1/2(1)

1/4(1)

1/8(1)

1/16(1)

 
Number of Blades

6(1)

3(1)

 
Ruler Type

Standard/Metric(1)

Triangular Scale(1)

 
Standard Scale

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

 
 
 

© 2019-2020 Dawkins Office Supply, All Rights Reserved