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

Currently Filtered by

Category

Vacuum Cleaners

Refine Search

  GO
 
Brand

Sanitaire(11)

Hoover Commercial(11)

Oreck Commercial(5)

Eureka(4)

Shop-Vac(3)

DataVac(2)

Swiffer(2)

Mercury Floor Machines(1)

 
Height

44 1/2"(1)

44.7"(1)

15 3/10"(1)

36"(1)

33.25"(1)

28"(1)

17.75"(1)

 
Color(s)

Black(14)

Red(6)

Gray/Orange(3)

Yellow(2)

Blue(2)

Gray(2)

Red/Gray(2)

Green/Silver(2)

Yellow/Black(2)

Red/Black(1)

White(1)

Gray/Blue(1)

Black/Yellow(1)

 
Depth

13.78"(1)

12.4"(1)

42"(1)

12 7/8"(1)

28.5"(1)

17.25"(1)

 
Diameter

1.6"(1)

4"(1)

17"(1)

12"(1)

1 1/2"(1)

1.5"(1)

 
Manufacturer Part Number

3670G(1)

23T(1)

CH53005(1)

CH53010(1)

CH54113(1)

CH54115(1)

ED500(1)

MDV-1BA(1)

WVP-20(1)

BB900DGR(1)

CH3000(1)

U2000R1(1)

U2000RB1(1)

XL2100RHS(1)

92705CT(1)

92705KT(1)

3942010(1)

5812600(1)

CH34006(1)

CH20110(1)

71B(1)

SC5713B(1)

NEU188(1)

NEU562(1)

SC3683B(1)

SC3700A(1)

SC412B(1)

SC530B(1)

SC535(1)

SC5745B(1)

C2401(1)

SC5815D(1)

SC5845B(1)

SC6093(1)

SC9180B(1)

C1433010(1)

C1660900(1)

C1800010(1)

5870210(1)

 
Country of Origin

US(17)

CN(15)

MX(7)

 
Width

13.4"(1)

12 1/2"(1)

14 1/4"(1)

12 7/8"(1)

21.5"(1)

14"(1)

 
Weight

19 lbs(1)

25 lbs(1)

 
Height Adjustment

No(8)

Seven Position(4)

Five-Position(3)

Four-Position(3)

Adjustable by removing pieces of the handle(2)

Automatic(1)

Four Position(1)

Three-Position(1)

Six-Position(1)

 
Voltage

120 V(18)

110 V(3)

18 V(1)

12 V(1)

 
Body Material

Plastic(16)

ABS Plastic(5)

Polypropylene(3)

Steel(2)

Plastic/Aluminum(2)

Polycarbonate(1)

Chrome/Steel(1)

Aluminum/Plastic(1)

 
Power

1400 W(2)

1200 W(1)

2.2 hp(1)

1300 W(1)

500 W(1)

0.5 hp(1)

2.67 hp(1)

5 hp(1)

6.5 hp(1)

 
Surface Type

Dry; Wet(1)

 
Current

10 amp(10)

12 amp(5)

4 amp(4)

9 amp(2)

5.5 amp(1)

8 A(1)

11.5 amp(1)

11.3 amp(1)

6 amp(1)

6.5 amp(1)

8 amp(1)

7 amp(1)

12 A(1)

AC(1)

 
Furniture Guard

Yes(18)

No(15)

 
Headlight

No(28)

Yes(4)

 
Cleaning Path

14"(8)

10"(5)

12"(5)

13"(4)

15"(4)

11"(2)

12.6"(1)

10 1/2"(1)

28"(1)

9 1/2"(1)

6"(1)

 
Replacement Filter

Sanitaire 61840(3)

HVR440007773; HVR440007774(2)

PGC 06174(2)

38333(1)

HVR40140201(1)

HVR303172001(1)

SHO-9039700(1)

Shop Vac 9035000(1)

SHO9039700; SHO9052600(1)

 
Tank Capacity

4.5 qt(3)

3.5 qt(2)

10 qt(2)

6 oz(2)

5 gal(2)

2 qt(1)

2.1(1)

2.6 qt(1)

1 gal(1)

1.5 gal(1)

4 qt(1)

6.4 qt(1)

6 qt(1)

20 gal(1)

1.25 qt(1)

16 gal(1)

 
Cleaning Width

14"(1)

 
Replacement Bag

ORKPK800025; ORKPK800025DW; ORKPK80009; ORKPK80009DW(3)

HVRAH10243; HVRAH10143(2)

60295C; 60296C(1)

EUK-62370-10(1)

62135(1)

EUK-63256A-10(1)

Sanitaire 63256A(1)

68103(1)

EUK-63262B-10(1)

HVR58642015(1)

HVR401000BP; HVR2KE2105000(1)

HVR4010038N(1)

HVRAH10273; HVRAH10173(1)

SHO-9067100(1)

No(1)

SHO9067100(1)

 
Replacement Belt

HVR440007804(2)

Sanitaire 61120G(2)

EUK-54312C-12(1)

EUK-61120D12(1)

16250CP(1)

HVRAH20075(1)

HVR40201190(1)

ORK0300604; ORK7585501(1)

ORK7585501(1)

ORK0300604(1)

No(1)

 
Replacement Belt Unit

2/PK(3)

EA(1)

 
Capacity

16 gal(1)

5 gal(1)

 
Cord Length

40 ft(8)

50 ft(7)

20 ft(6)

35 ft(4)

30 ft(3)

32 ft(1)

60 ft(1)

48 ft(1)

33 ft(1)

12 ft(1)

18 ft(1)

 
Filter Types

HEPA(6)

Sealed HEPA(5)

HEPA Media(3)

High Filtration Bag(3)

Swiffer Sweeper Vac Filter(2)

Ultra Web(1)

Cartridge; Collection Bag; Foam Sleeve(1)

Allergen Filtration(1)

Washable Cloth(1)

Foam(1)

Two-Layer Micro Filtration(1)

Bagless Style(1)

Teflon Coated HEPA(1)

Bagless System(1)

Disposable Filter Bag(1)

Four-Stage(1)

Allergen(1)

High Efficiency Collection Bag; Small Foam Sleeve; Small Ultra Web Cartridge Filter(1)

 
Motor HP

6.5 hp(1)

6 hp(1)

 
Hose Length

8 ft(7)

5 ft(5)

10 ft(4)

12 ft(2)

7 ft(2)

6 ft(1)

9 ft(1)

19 ft(1)

18 ft(1)

 
On-Board Tools

Yes(24)

No(9)

 
Dust/Dirt Cup

Yes(14)

No(6)

 
Air Watts

180 W(1)

 
Hose Diameter

1 1/2"(1)

1.5"(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved