SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ('728')) 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_cost`=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 MATCH(`desc_short`) AGAINST ('Fans' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Fans' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Fans"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Fans"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Fans"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Fans"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Fans' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Fans',`category_4` ='Fans') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Fans,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Fans', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Fans

Refine Search
  GO
Brand

Alera(9)

Holmes(9)

Honeywell(8)

Lakewood(4)

Shop-Air(3)

Bionaire(2)

Patton(2)

Airmaster Fan(2)

TPI Industrial(1)

Shop-Vac(1)

Height

13"(2)

49 3/5"(2)

31"(2)

40"(2)

36"(2)

6 3/10"(2)

15"(2)

11 3/4"(2)

38 1/4"(1)

6 1/2"(1)

11.3"(1)

42"(1)

11"(1)

20.75"(1)

22.78"(1)

17"(1)

17 18/25"(1)

32 7/8"(1)

12.3"(1)

41 3/8" to 49 1/4"(1)

41 3/8" to 49 1/2"(1)

21"(1)

19.25"(1)

19"(1)

22"(1)

8"(1)

5 1/2"(1)

16.9"(1)

18.25"(1)

14 3/8"(1)

13.25"(1)

6"(1)

Color(s)

Black(20)

White(10)

Stainless Steel(3)

Black/Silver(2)

Yellow(1)

Charcoal(1)

Metallic Silver/Black(1)

Width

10"(4)

6"(4)

5 9/10"(4)

6 3/10"(4)

18"(4)

17 13/25"(4)

20.5"(4)

18 1/8"(4)

5 7/8"(2)

15 3/4"(2)

13.25"(2)

5"(2)

11 7/8"(2)

8 1/4"(2)

24.5"(2)

18 1/2"(2)

11"(2)

14 17/100"(2)

13 1/2"(2)

19.67"(2)

38"(2)

33"(2)

11.88"(2)

13.63"(2)

11 1/4"(2)

7"(2)

12.6"(2)

7.86"(2)

20.25"(2)

10 3/8"(2)

8 3/4"(2)

9.4"(2)

Depth

9.4"(2)

18 1/8"(2)

14 24/25"(2)

6.5"(2)

6 3/10"(2)

7 3/10"(2)

10"(1)

11 7/8"(1)

10 6/25"(1)

10.75"(1)

7"(1)

15 3/4"(1)

20.75"(1)

23"(1)

14"(1)

4 3/4"(1)

8.63"(1)

18"(1)

4"(1)

4.13"(1)

13"(1)

11.88"(1)

10.38"(1)

4 5/8"(1)

6.8"(1)

12.6"(1)

8.67"(1)

3 3/8"(1)

7.38"(1)

10 5/8"(1)

8"(1)

2"(1)

Diameter

16"(1)

Country of Origin

CN(37)

US(4)

Material(s)

Plastic(21)

Metal(3)

Metal/Plastic(3)

Stainless Steel(2)

Steel(2)

Metal; Plastic(2)

Aluminum(1)

Plastic; Metal(1)

Length

10 3/4"(1)

Voltage

120 V(3)

120V/60Hz(1)

Blade Material

Plastic(3)

Steel(1)

Maximum Height

22"(2)

6 1/2"(1)

13"(1)

40"(1)

15 3/4"(1)

38 1/4"(1)

49 1/2"(1)

11 1/2"(1)

36.13"(1)

21.63"(1)

49 1/4"(1)

5 1/2"(1)

Housing Material

Stainless Steel(1)

Blade Color

Black(3)

White(2)

Translucent Black(1)

Speeds

3(25)

2(7)

1(5)

5(2)

8(1)

4(1)

Speed Settings

High/Low(1)

Cord Length

5 ft.(2)

10 ft(1)

72"(1)

60"(1)

Tilt (Degrees)

360(5)

Adjustable(5)

90(3)

24(2)

80(2)

45; 90(1)

75(1)

Fan Type

Tower(7)

Desk(6)

Floor(6)

Personal(4)

Stand(3)

Pedestal(3)

Air Circulator(2)

Oscillating Tower(2)

High-Velocity(1)

Oscillating(1)

Wall/Ceiling Mount(1)

Box(1)

Wall Mount(1)

Desk/Hanging(1)

Pedestal/Clip(1)

Wall(1)

Fan Head Size

16"(9)

6"(3)

12"(3)

9"(3)

11"(2)

4"(2)

30"(2)

36"(2)

20"(2)

8"(1)

3"(1)

7"(1)

14"(1)

Air Flow (CFM)

2200(1)

Air Flow Range

1500 to 2200 cfm(1)

Amp

0.37 A(2)

1.7 A(1)

0.3A(1)

Blades

3(3)

6(1)

Fan Width

16"(1)

Guard Color

White(2)

Black(1)

Guard Material

Stainless Steel(1)

Steel(1)

Plastic(1)

Housing Color

Stainless Steel(1)

White(1)

Housing Finish

Stainless Steel(1)

Motor Type

Induction(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved

Powered by SITS Erp