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

Holmes(10)

Alera(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/10"(1)

42"(1)

11"(1)

20.75"(1)

22 7/8"(1)

17"(1)

17 18/25"(1)

32 7/8"(1)

12 3/10"(1)

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

22"(1)

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

21"(1)

19"(1)

19 1/4"(1)

8"(1)

13 1/4"(1)

5 1/2"(1)

16 9/10"(1)

18 1/4"(1)

14 3/8"(1)

10"(1)

6"(1)

Color(s)

Black(20)

White(11)

Stainless Steel(3)

Black/Silver(2)

Yellow(1)

Charcoal(1)

Metallic Silver/Black(1)

Width

6"(4)

6 3/10"(4)

17 13/25"(4)

5"(4)

10"(4)

18"(4)

5 9/10"(4)

18 1/8"(4)

20 1/2"(4)

11 7/8"(4)

8 1/4"(2)

5 7/8"(2)

11"(2)

18 1/2"(2)

13.25"(2)

15 3/4"(2)

13 1/2"(2)

24 1/2"(2)

14 17/100"(2)

7 6/7"(2)

33"(2)

38"(2)

13 5/8"(2)

11 1/4"(2)

7"(2)

12 3/5"(2)

19 2/3"(2)

20 1/4"(2)

10 3/8"(2)

8 3/4"(2)

9 2/5"(2)

Depth

2"(2)

7 3/10"(2)

6 3/10"(2)

14 24/25"(2)

18 1/8"(2)

9 2/5"(2)

6 1/2"(2)

11 7/8"(2)

18"(1)

4 5/8"(1)

10 6/25"(1)

10"(1)

7"(1)

8 5/8"(1)

20.75"(1)

15 3/4"(1)

23"(1)

14"(1)

10.75"(1)

10 3/8"(1)

8"(1)

12 3/5"(1)

6 4/5"(1)

13"(1)

10 5/8"(1)

7 3/8"(1)

4 1/8"(1)

4"(1)

3 3/8"(1)

8 2/3"(1)

4 3/4"(1)

Diameter

16"(1)

Country of Origin

CN(38)

US(4)

Material(s)

Plastic(22)

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 1/8"(1)

21 5/8"(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(8)

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(5)

Stand(3)

Pedestal(3)

Oscillating Tower(2)

Air Circulator(2)

Oscillating(1)

High-Velocity(1)

Wall(1)

Wall/Ceiling Mount(1)

Box(1)

Wall Mount(1)

Desk/Hanging(1)

Pedestal/Clip(1)

Fan Head Size

16"(9)

6"(3)

12"(3)

9"(3)

11"(2)

4"(2)

30"(2)

20"(2)

36"(2)

8"(1)

14"(1)

3"(1)

7"(1)

10"(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

© 2019-2020 United Supply Corp, All Rights Reserved

Powered by SITS Erp