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','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 '%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

Sanitaire(15)

Hoover(6)

Shop-Vac(5)

Oreck(3)

Eureka(2)

 
Color

Red(14)

Black(13)

Yellow(5)

Gray(4)

Silver(4)

Orange(2)

Blue(2)

Chrome(1)

 
Limited Warranty

1 Year(7)

2 Year(3)

 
Weight (Approximate)

18.50 lb(3)

11.50 lb(3)

17 lb(2)

9 lb(2)

8 lb(1)

14 lb(1)

17.50 lb(1)

1.01 lb(1)

16.70 lb(1)

25 lb(1)

8.30 lb(1)

15 lb(1)

12.40 lb(1)

24 lb(1)

22 lb(1)

16 lb(1)

 
Input Voltage

120 V AC(5)

12 V DC(2)

110 V AC(1)

110 V(1)

230 V AC(1)

 
Attachments

Filter(16)

Crevice Tool(15)

Hose(12)

Brushroll(10)

Brush(9)

Dusting Brush(7)

Wand(6)

Dirt Cup(6)

Nozzle(6)

Upholstery Tool(6)

Telescopic Wand(3)

Extension Wand(3)

Upholstery Brush(2)

Claw Nozzle(2)

Floor Nozzle(2)

Extension Tube(1)

Floor Tool(1)

Upholstery Nozzle(1)

Brush Tool(1)

Extension Hose(1)

Pet Hair Tool(1)

Scrub Brush(1)

Squeegee(1)

Utility Nozzle(1)

 
Input Current

10 A(5)

11.50 A(4)

12 A(3)

7 A(3)

5 A(2)

9 A(1)

6.50 A(1)

2 A(1)

5.40 A(1)

8.90 A(1)

11.80 A(1)

8.40 A(1)

 
Dust Capacity

1.50 gal(2)

3.50 quart(2)

1.13 gal(2)

4.50 gal(2)

1.65 gal(1)

2.60 quart(1)

2.50 gal(1)

1.89 quart(1)

1.90 quart(1)

1.53 gal(1)

1 gal(1)

1.06 gal(1)

5 gal(1)

16 gal(1)

12 gal(1)

6 gal(1)

 
Dust Collection

Bagless(10)

Bagged(9)

 
Floor Type

Carpet(18)

Bare Floor(8)

Dry Surface(5)

Wet Surface(5)

Hardwood(3)

Tile Floor(3)

Wooden Floor(3)

Hard Floor(3)

Laminate Floor(2)

Rug(1)

 
Air Flow

1009.9 gal/min(2)

897.7 gal/min(2)

1084.7 gal/min(1)

890.2 gal/min(1)

1137 gal/min(1)

1122.1 gal/min(1)

486.2 gal/min(1)

598.4 gal/min(1)

785.5 gal/min(1)

523.6 gal/min(1)

 
Motor

1200 W(4)

600 W(2)

2237.10 W(2)

1000 W(1)

1400 W(1)

840 W(1)

3728.50 W(1)

4474.20 W(1)

4101.35 W(1)

 
Sound Emission

69 dB(3)

71 dB(1)

68 dB(1)

63 dB(A)(1)

78 dB(1)

79 dB(A)(1)

 
Air Watts

1380 W(1)

179.86 W(1)

224.82 W(1)

324.74 W(1)

144.88 W(1)

 
Water Tank Capacity

5 gal(1)

 
Manufacturer Part Number

530B(1)

C1800010(1)

9627110(1)

9593410(1)

5870210(1)

3942010(1)

XL2100RHS(1)

U2000RB1(1)

ORB550MC(1)

NEU188(1)

NEU180(1)

CH54115(1)

CH54113(1)

CH53010(1)

CH30000(1)

C1660900(1)

5745B(1)

SC9180B(1)

SC899G(1)

SC888M(1)

SC887D(1)

SC689A(1)

SC679J(1)

SC5845B(1)

SC5713B(1)

SC535(1)

SC412A(1)

SC3700(1)

SC3683B(1)

9050D(1)

9653610(1)

 
Country of Origin

United States(13)

Mexico(12)

China(6)

 
Height

23"(1)

12"(1)

45"(1)

44.5"(1)

17.3"(1)

29"(1)

21.5"(1)

 
Width

14"(2)

12.5"(1)

33.8"(1)

13"(1)

16"(1)

16.5"(1)

 
Depth

9"(1)

16"(1)

13.4"(1)

 
Length

15.5"(1)

17.3"(1)

18.3"(1)

16.5"(1)

 
Power Source

AC Supply(8)

 
Cable Length

50 ft(5)

40 ft(4)

35 ft(4)

30 ft(3)

20 ft(2)

18 ft(2)

1.97"(1)

25 ft(1)

6 ft(1)

12 ft(1)

 
Hose Length

96"(4)

60"(3)

84"(3)

12 ft(2)

10 ft(1)

18 ft(1)

 
Cleaning Path

12"(8)

13"(5)

14"(4)

15"(3)

12.60"(2)

10"(1)

11"(1)

16"(1)

12.47 ft(1)

1.50"(1)

1.26"(1)

 
Filter Type

HEPA(12)

Foam(1)

 
 
 

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