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

Currently Filtered by

Category

Fans And Heaters

Refine Search

  GO
 
Brand

Lorell(20)

Honeywell(6)

Shop-Vac(3)

Bionaire(1)

Champion Sports(1)

Holmes(1)

Chillout(1)

Tatco(1)

 
Color

Black(15)

White(13)

Blue(1)

Gray(1)

Dark Gray(1)

Silver(1)

Light Gray(1)

Yellow(1)

 
Recycled

No(19)

 
Height

9.5"(2)

24.2"(2)

7.7"(2)

16.2"(1)

13.3"(1)

32.5"(1)

18.5"(1)

48"(1)

21"(1)

7"(1)

19.5"(1)

32"(1)

8.1"(1)

30.2"(1)

47.3"(1)

11"(1)

23.2"(1)

6.1"(1)

12"(1)

 
Depth

6"(2)

6.1"(1)

6.7"(1)

11"(1)

17.8"(1)

9.5"(1)

7.2"(1)

8.2"(1)

11.5"(1)

18.3"(1)

18.1"(1)

 
Manufacturer Part Number

BFF1222AR-BM(1)

33979(1)

1186200(1)

1185000(1)

1032000(1)

99844(1)

99843(1)

99841(1)

49256(1)

49251(1)

44575(1)

44565(1)

44564(1)

44552BD(1)

44552(1)

44551(1)

33978(1)

EP1500(1)

HZ7300(1)

HT38RB-U(1)

GF3B(1)

HCE311V(1)

HCE323V(1)

HHF360W(1)

HT-900(1)

HZ789(1)

33568(1)

00074(1)

00075(1)

00301(1)

00311(1)

29552(1)

33558(1)

39100(1)

 
Country of Origin

China(32)

United States(2)

 
Width

7.9"(2)

5.8"(2)

6.9"(1)

13.9"(1)

20.8"(1)

12.3"(1)

9.3"(1)

4.7"(1)

4.1"(1)

9.9"(1)

7.5"(1)

4.4"(1)

7.6"(1)

24.2"(1)

9.5"(1)

17.8"(1)

6"(1)

8.7"(1)

6.1"(1)

0.5"(1)

 
Material

Plastic Blade(2)

Metal Grille(1)

Galvanized Metal(1)

Galvanized Steel(1)

Aluminum Blade(1)

Plastic(1)

Stainless Steel Body(1)

 
Limited Warranty

1 Year(14)

3 Year(1)

 
Weight (Approximate)

2.40 lb(2)

9.20 lb(1)

4 lb(1)

 
Length

4.8"(2)

16.7"(1)

6.3"(1)

9.5"(1)

8.5"(1)

20.6"(1)

31.3"(1)

20.8"(1)

18.8"(1)

 
Form Factor

Portable(5)

Tower(4)

Wall Mount(1)

 
Power Source

Electric(10)

 
Input Voltage

110 V AC(2)

 
Power Consumption

1500 W(6)

33.60 W(2)

149.14 W(1)

90 W(1)

200 W(1)

 
Mount Type

Floor(2)

Wall(1)

 
Number of Blades

3(3)

6(1)

 
Input Current

1.80 A(1)

 
Speed Settings

3(10)

2(4)

1(1)

 
Number of Heat Settings

2(8)

3(4)

 
Maximum Heat Power

1500 W(8)

200 W(1)

 
Timer

Yes(3)

 
Minimum Heat Power

900 W(2)

750 W(1)

800 W(1)

600 W(1)

 
Product Type

Convection Heater(12)

Floor Fan(5)

Desk Fan(4)

Radiative Heater(2)

Portable Fan(2)

USB Fan(2)

Electric Air Inflator(1)

Pedestal Fan(1)

Floor/Wall Mount Fan(1)

Exhaust Fan(1)

Wall Mount Fan(1)

Handy Air Blower(1)

 
Packaged Quantity

1 Each(17)

2 / Bundle(1)

1 / Each(1)

 
Assembly Required

No(18)

Yes(1)

 
Product Model

BFF1222AR-BM(1)

HT38RB-U(1)

GF3B(1)

HCE311V(1)

HCE323V(1)

HHF360W(1)

HT-900(1)

HZ-7300(1)

249D-15AG-GWS(1)

169D-90CB-SS(1)

 
Product Line

Energy Smart(2)

Shop-Air(2)

Air Mover(1)

 
Fan Diameter

16" Blade Span(4)

12" Blade Span(2)

152.4 mm Blade Span(2)

127 mm Blade Span(2)

114.3 mm Blade Span(1)

193 mm Blade Span(1)

30" Blade Span(1)

20" Blade Span(1)

24" Blade Span(1)

 
Air Flow

3740.3 gal/min(1)

 
Heating Element

Ceramic(6)

Oil Filled(1)

Quartz(1)