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

Currently Filtered by

Category

Vacuum Cleaners

Refine Search

  GO
 
Brand

Hoover(12)

Sanitaire(11)

Shop-Vac(6)

Oreck(3)

Swiffer(1)

 
Color

Black(16)

Red(11)

Yellow(6)

Gray(5)

Silver(3)

Blue(2)

Orange(1)

 
Recycled

No(1)

 
Packaged Quantity

1 Each(1)

 
Assembly Required

No(1)

 
Limited Warranty

1 Year(9)

2 Year(1)

3 Year(1)

 
Weight (Approximate)

18.50 lb(2)

9 lb(2)

11.50 lb(2)

18 lb(2)

11.60 lb(1)

15 lb(1)

24 lb(1)

34 lb(1)

8.30 lb(1)

25 lb(1)

14 lb(1)

8 lb(1)

17.50 lb(1)

19 lb(1)

15.20 lb(1)

16.70 lb(1)

7.30 lb(1)

 
Recycled Content

0%(1)

 
Input Voltage

120 V AC(6)

110 V AC(3)

12 V DC(2)

110 V(1)

 
Attachments

Crevice Tool(15)

Filter(14)

Nozzle(13)

Brush(13)

Hose(12)

Brushroll(12)

Wand(10)

Dirt Cup(7)

Dusting Brush(7)

Upholstery Tool(5)

Squeegee(2)

Telescopic Wand(2)

Floor Tool(1)

Utility Nozzle(1)

Steaming Pad(1)

Scrub Brush(1)

Upholstery Brush(1)

Extension Tube(1)

 
Battery Rechargeable

Yes(1)

 
Input Current

12 A(4)

10 A(4)

7 A(3)

8.90 A(2)

6 A(2)

5 A(2)

9 A(2)

9.50 A(1)

5.40 A(1)

6.50 A(1)

 
Dust Capacity

1.50 gal(2)

12 gal(2)

4.50 gal(2)

1.13 gal(1)

6 gal(1)

5 gal(1)

16 gal(1)

2.38 gal(1)

1.89 quart(1)

3.50 quart(1)

1.53 gal(1)

1.65 gal(1)

2.60 quart(1)

1.90 quart(1)

 
Dust Collection

Bagless(9)

Bagged(8)

 
Floor Type

Carpet(10)

Bare Floor(7)

Laminate Floor(3)

Tile Floor(3)

Wooden Floor(3)

Hard Floor(3)

Wet Surface(2)

Hardwood(2)

Dry Surface(2)

 
Air Flow

1084.7 gal/min(2)

748.1 gal/min(2)

897.7 gal/min(2)

1346.5 gal/min(1)

1458.7 gal/min(1)

17953.2 gal/min(1)

1009.9 gal/min(1)

1137 gal/min(1)

1122.1 gal/min(1)

 
Motor

1200 W(4)

3728.50 W(2)

1864.25 W(2)

600 W(2)

2237.10 W(1)

1000 W(1)

4474.20 W(1)

1400 W(1)

 
Sound Emission

69 dB(3)

78 dB(1)

68 dB(1)

71 dB(1)

79 dB(1)

 
Air Watts

280 W(2)

350 W(1)

1380 W(1)

840 W(1)

 
Water Tank Capacity

5 gal(1)

 
Manufacturer Part Number

CH82010(1)

ORB550MC(1)

U2000RB1(1)

CH54115(1)

CH54113(1)

CH32008(1)

CH53010(1)

XL2100RHS(1)

85801(1)

9625110(1)

9650610(1)

9623910(1)

9622110(1)

3942010(1)

5872810(1)

CH30000(1)

CH20110(1)

SC3683B(1)

SC3700(1)

SC412A(1)

9050D(1)

SC899F(1)

5745B(1)

888K(1)

SC679J(1)

SC689A(1)

C1703-900(1)

C1800010(1)

C1660900(1)

C1433-010(1)

SC887B(1)

C1431-010(1)

530B(1)

 
Country of Origin

United States(16)

Mexico(11)

China(6)

 
Material

Polypropylene(1)

 
Height

29.5"(1)

19.5"(1)

45"(1)

23"(1)

 
Width

17.3"(1)

14.5"(1)

13"(1)

12.5"(1)

 
Depth

16"(1)

9"(1)

 
Length

17.3"(1)

19.2"(1)

 
Power Source

AC Supply(7)

Battery(1)

 
Cable Length

50 ft(6)

35 ft(5)

30 ft(3)

40 ft(3)

20 ft(2)

12 ft(1)

6 ft(1)

18 ft(1)

 
Hose Length

96"(4)

84"(2)

18 ft(1)

60"(1)

 
Cleaning Path

12"(10)

14"(4)

13"(4)

15"(2)

11"(2)

10"(2)

10.50"(1)

16"(1)

 
Filter Type

HEPA(8)

Foam(1)

 
 
 

© 2019-2020 National Office Store, Inc., All Rights Reserved