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

Currently Filtered by

Category

Vacuums And Accessories

Refine Search

  GO
 
Brand

Hoover(18)

Sanitaire(16)

BISSELL(9)

Oreck(7)

Hoover Commercial(3)

Eureka(3)

BigGreen(1)

TTI(1)

Swiffer(1)

 
Color

White(15)

Black(13)

Red(12)

Gray(5)

Green(5)

Yellow(3)

Silver(3)

Blue(3)

Orange(2)

 
Recycled

No(22)

Yes(2)

 
Packaged Quantity

5 / Pack(6)

10 / Pack(4)

3 / Pack(3)

25 / Pack(2)

9 / Pack(2)

50 / Carton(1)

1 Each(1)

36 / Carton(1)

2 / Pack(1)

24 / Carton(1)

6 / Carton(1)

40 / Carton(1)

1(1)

 
Assembly Required

No(24)

 
Limited Warranty

2 Year(12)

1 Year(9)

 
Weight (Approximate)

11.50 lb(3)

10.70 lb(2)

18.50 lb(2)

9 lb(2)

15.40 lb(1)

5.40 lb(1)

9.20 lb(1)

8.30 lb(1)

15 lb(1)

8.20 lb(1)

12.40 lb(1)

24 lb(1)

 
Warranty

Manufacturer's limited two-year warranty for commercial use.(1)

Manufacturer's limited two-year commercial warranty.(1)

Manufacturer's limited one-year warranty.(1)

 
Compatibility

Hoover HushTone Vacuum Cleaners(2)

Sanitaire Backpack Vacuums:

  • SC530
  • SC535
(1)

  • Hoover upright Vacuum Cleaners
  • Hoover WindTunnel uprights Cleaners
(1)

Oreck Vacuum Cleaners:

  • XL2000
  • XL8000
  • XL9000 Series 9
(1)

Oreck Commercial Upright Vacuum(1)

Oreck Commercial Series Upright Vacuum Cleaners:

  • XL2000
  • XL8000
  • XL9000
  • U2000
(1)

Hoover - Portapower(1)

Hoover Commercial 6-quart Hush Tone Backpack Vacuums(1)

Hoover HushTone Vacuum Cleaners:

  • CH54013
  • CH54015
  • CH54113
  • CH54115
(1)

Hoover Insight Upright Vacuum Cleaners(1)

Hoover HushTone Cacuum Cleaners:

  • CH54013
  • CH54015
  • CH54113
  • CH54115
(1)

Hoover WindTunnel Upright Vacuum Cleaners(1)

Sanitaire Series Vacuum Cleaners:

  • SC600
  • SC800
(1)

Hoover TaskVac Commercial Vacuum Cleaners(1)

WindTunnel HVRC1703-900 Upright Vacuum

(1)

Hoover Conquest 14" and 18" Vacuum Cleaners(1)

Hoover Upright Vacuum Cleaners

  • C1632 Nla Professional
  • C1515 Commercial
(1)

Hoover Portapower Cleaners:

  • 7065
  • C2094
  • CH30000
(1)

Sanitaire SC9050B DuraLite Vacuum Cleaner(1)

Eureka Vacuum Cleaner Series:

  • SC9100
  • SC9150
  • SC9180
(1)

  • Sanitaire SC5713A Vacuum Cleaner
Sanitaire Upright Bagged Vacuum Cleaner Series:
  • 5700
  • 5800
(1)

Commercial Upright Vacuum Cleaners:

  • 5700
  • 5800
  • SC5713A
(1)

Sanitaire S3680 Vaccum Cleaner(1)

Oreck Vacuum Cleaners:

  • XL200S
  • XL-9200
  • XL-9400
  • XL9100HG
  • U2000R-1
(1)

 
Special Features

Allergen CC1(1)

Swiffer Bissell SteamBoost Mop Starter Kit(1)

 
Application

Floor Maintenance(1)

 
Recycled Content

100%(1)

10%(1)

 
For Use With

Swiffer SteamBoost Pad Refill(1)

 
Carrying Options

Shoulder Strap(1)

 
Input Voltage

120 V AC(2)

12 V DC(2)

 
Attachments

Crevice Tool(11)

Brushroll(11)

Hose(9)

Dusting Brush(8)

Wand(8)

Upholstery Tool(7)

Filter(6)

Brush(5)

Floor Tool(3)

Nozzle(3)

Upholstery Brush(3)

Telescopic Wand(2)

Brush Tool(2)

Extension Hose(1)

Pet Hair Tool(1)

Carpet Tool(1)

Dirt Cup(1)

Extension Tube(1)

Scrub Brush(1)

 
Input Current

10 A(3)

12 A(3)

7 A(1)

9 A(1)

11.50 A(1)

2 A(1)

5.40 A(1)

 
Dust Capacity

4.50 gal(4)

1.13 gal(2)

3.50 quart(2)

1.50 gal(2)

1.53 gal(1)

1.65 gal(1)

2.50 gal(1)

1.60 gal(1)

1.06 gal(1)

 
Dust Collection

Bagged(12)

Bagless(6)

 
Floor Type

Carpet(19)

Bare Floor(6)

Hard Floor(4)

Tile Floor(3)

Wooden Floor(3)

Hardwood(2)

Laminate Floor(2)

 
Air Flow

1084.7 gal/min(1)

897.7 gal/min(1)

1137 gal/min(1)

 
Motor

1200 W(2)

840 W(1)

1000 W(1)

1400 W(1)

 
Sound Emission

69 dB(A)(2)

70.6 dB(A)(2)

69 dB(2)

68 dB(A)(1)

68 dB(1)

63 dB(A)(1)

 
Air Watts

1380 W(1)

 
Manufacturer Part Number

SC3683D(1)

CH30000(1)

AH10040CT(1)

AH10143(1)

AH10170(1)

AH10243(1)

AH10263(1)

AH10273CT(1)

AH10363(1)

AH10363CT(1)

C1703900(1)

C2401(1)

CH01005(1)

CH20110(1)

CH53010(1)

4010103B(1)

CH54113(1)

CH54115(1)

3670G(1)

NEU180(1)

NEU188(1)

ORB550MC(1)

PK800025(1)

PK800025D(1)

PK80009(1)

PK80009DW(1)

U2000RB1(1)

XL2100RHS(1)

AH10040(1)

4010100Y(1)

SC5713D(1)

530B(1)

SC5745D(1)

SC5845D(1)

SC679K(1)

SC684G(1)

SC689B(1)

SC886G(1)

SC887E(1)

SC888N(1)

SC889B(1)

SC899H(1)

SC9050E(1)

SC9180D(1)

6213510(1)

4010100ACT(1)

63213B10(1)

63253A10(1)

63256A10(1)

63256A10CT(1)

63262B10(1)

63881A10(1)

SC3700(1)

SC412A(1)

SC535(1)

SC889A(1)

4010050N(1)

4010100A(1)

85801(1)

 
Country of Origin

China(29)

Mexico(15)

United States(9)

MX(2)

CN(2)

US(1)

 
Material

Paper(2)

 
Height

8.5"(4)

11.3"(2)

10"(2)

10.5"(2)

32.8"(1)

23"(1)

12"(1)

44"(1)

14"(1)

43"(1)

44.5"(1)

 
Width

17.3"(4)

19"(3)

14.5"(3)

17.8"(1)

16.5"(1)

12.5"(1)

33.8"(1)

13"(1)

1.9"(1)

11"(1)

9"(1)

14"(1)

 
Depth

10.5"(1)

9"(1)

16"(1)

12"(1)

16.5"(1)

13.4"(1)

 
Color(s)

Black(2)

Gray/Red(1)

 
Length

21.3"(5)

26.5"(2)

19.2"(1)

20.5"(1)

15.5"(1)

 
Quantity

1 each(1)

 
OEM/Compatible

OEM(1)

 
Weight

18 lbs(1)

15.2 lbs(1)

7 lbs(1)

 
Height Adjustment

Eight-Position(1)

Five-Position(1)

 
Handle Material

Aluminum/Plastic(1)

 
Size Group

Allergen CC1(1)

 
Capacity

1.13 gal(1)

 
Power Source

AC Supply(4)

 
Cable Length

50 ft(8)

40 ft(4)

35 ft(2)

48 ft(1)

25 ft(1)

18 ft(1)

 
Handle Color

Blue/Silver(1)

 
Voltage

18 V(1)

 
Handle Length

48"(1)

 
Mop Head Size

10" x 5"(1)

 
Cord Length

50 ft(1)

35 ft(1)

 
Mop Head Material

Nonwoven Fiber(1)

 
Mop Head Color

White(1)

 
Body Material

Plastic(1)

 
Current

7 amp(1)

12 amp(1)

 
Hose Length

60"(3)

96"(3)

62"(1)

84"(1)

 
Filter Types

Allergen(1)

Allergen Filtration(1)

Two-Layer Micro Filtration(1)

 
Cleaning Path

13"(6)

12"(5)

14"(3)

11"(3)

15"(2)

12.60"(2)

16"(1)

 
Filter Type

HEPA(11)

Foam(1)

 
Headlight

No(2)

Yes(1)

 
On-Board Tools

No(2)

Yes(1)

 
Furniture Guard

Yes(2)

 
Dust/Dirt Cup

No(2)

Yes(1)

 
Replacement Filter

HVRAH10040(1)

 
Replacement Belt

EUK-52100C-12(1)

HVR40201160(1)

 
Replacement Bag

EUK-63213A-10(1)

HVR4010100Y(1)

 
 
 

© 2021-2022 Office Hub, All Rights Reserved