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(20)

Hoover Commercial(13)

Oreck Commercial(5)

Shop-Vac(5)

Eureka(4)

DataVac(4)

Swiffer(2)

Mercury Floor Machines(1)

 
Height

44 1/2"(1)

44.7"(1)

44"(1)

15 3/10"(1)

36"(1)

33.25"(1)

28"(1)

17.75"(1)

21.5"(1)

10"(1)

 
Color(s)

Black(17)

Red(10)

Yellow/Black(4)

Gray/Red/Black(3)

Gray(3)

Gray/Orange(3)

Yellow(2)

Blue(2)

Red/Gray(2)

Green/Silver(2)

Red/Black(1)

Gray/Red(1)

Chrome/Red(1)

White(1)

Gray/Blue(1)

Black/Yellow(1)

 
Depth

13.78"(1)

12.4"(1)

16"(1)

42"(1)

12 7/8"(1)

28.5"(1)

17.25"(1)

16.5"(1)

18"(1)

 
Diameter

7"(2)

1.6"(1)

4"(1)

17"(1)

12"(1)

1 1/2"(1)

1.5"(1)

1.25"(1)

10"(1)

 
Manufacturer Part Number

3670G(1)

MDV-3TCA(1)

CH3000(1)

CH32008(1)

CH34006(1)

CH53005(1)

CH53010(1)

CH54113(1)

CH54115(1)

ED500(1)

MDV-1BA(1)

MDV-2TCA(1)

WVP-20(1)

C2401(1)

23T(1)

BB900DGR(1)

U2000R1(1)

U2000RB1(1)

XL2100RHS(1)

92705CT(1)

92705KT(1)

3942010(1)

5812600(1)

5870210(1)

9653610(1)

CH20110(1)

C1800010(1)

71B(1)

SC5845B(1)

NEU188(1)

NEU562(1)

887D(1)

SC3683B(1)

SC3700A(1)

SC412B(1)

SC530B(1)

SC535(1)

SC5713B(1)

SC5745B(1)

SC5815D(1)

SC6093(1)

C1703900(1)

SC679J(1)

SC684F(1)

SC688A(1)

SC689(1)

SC886F(1)

SC888M(1)

SC889A(1)

SC899G(1)

SC9180B(1)

C1433010(1)

C1660900(1)

9991910(1)

 
Country of Origin

US(20)

MX(17)

CN(17)

 
Width

13.4"(1)

12 1/2"(1)

13"(1)

14 1/4"(1)

16"(1)

17"(1)

12 7/8"(1)

21.5"(1)

14"(1)

14.5"(1)

10"(1)

 
Weight

15.2 lbs(1)

9 lbs(1)

 
Height Adjustment

No(8)

Six Position(7)

Seven Position(4)

Five-Position(4)

Four-Position(3)

Yes(2)

Adjustable by removing pieces of the handle(2)

Automatic(1)

Four Position(1)

Three-Position(1)

Six-Position(1)

 
Voltage

120 V(23)

110 V(3)

18 V(1)

12 V(1)

 
Body Material

Plastic(18)

ABS Plastic(5)

Polypropylene(4)

Steel(4)

Metal/Plastic(2)

Polycarbonate(2)

Chrome Steel Motor Hood; Plastic(2)

Plastic/Aluminum(2)

Plastic; Metal(1)

Chrome/Steel(1)

Aluminum/Plastic(1)

 
Power

1.7 hp(2)

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)

1.5 hp(1)

 
Surface Type

Dry; Wet(1)

 
Current

10 amp(11)

7 amp(9)

12 amp(6)

4 amp(4)

9 amp(2)

5 amp(2)

AC(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)

12 A(1)

 
Furniture Guard

Yes(28)

No(17)

 
Headlight

No(39)

Yes(5)

 
Cleaning Path

12"(13)

14"(8)

10"(5)

13"(5)

15"(4)

10 1/2"(2)

11"(2)

12.6"(1)

28"(1)

16"(1)

9 1/2"(1)

6"(1)

 
Replacement Filter

Sanitaire 61840(3)

HVR440007773; HVR440007774(2)

PGC 06174(2)

38333(1)

Standard(1)

HVR40140201(1)

HVRAH10040(1)

HVR303172001(1)

SHO-9039700(1)

Shop Vac 9035000(1)

SHO9039700; SHO9052600(1)

SHO9035000; SHO9058500(1)

 
Tank Capacity

4.5 qt(3)

5 gal(2)

6 oz(2)

10 qt(2)

3.5 qt(2)

9.5 qt(2)

2 qt(1)

6 qt(1)

6 gal(1)

16 gal(1)

1.25 qt(1)

20 gal(1)

18 qt(1)

6.4 qt(1)

4 qt(1)

2.1(1)

1.5 gal(1)

1 gal(1)

2.6 qt(1)

1.9 qt(1)

1 qt(1)

 
Cleaning Width

14"(1)

 
Replacement Bag

Reusable "Shake Out" Cloth Bag (incl.)(3)

ORKPK800025; ORKPK800025DW; ORKPK80009; ORKPK80009DW(3)

SHO9067100(2)

HVRAH10243; HVRAH10143(2)

EUK-63213A-10(2)

HVR401000BP; HVR2KE2105000(1)

No(1)

SHO-9067100(1)

HVRAH10273; HVRAH10173(1)

HVRAH10263; HVRAH10363(1)

HVR4010038N(1)

60295C; 60296C(1)

HVR58642015(1)

EUK-62370-10(1)

EUK-63262B-10(1)

EUR-63213B-10(1)

68103(1)

Sanitaire 63256A(1)

EUK-63256A-10(1)

62135(1)

HVR4010100Y(1)

 
Replacement Belt

EUK-52100C-12(5)

52100B(2)

Sanitaire 61120G(2)

HVR440007804(2)

EUK-54312C-12(1)

EUK-61120D12(1)

16250CP(1)

EUR-66100(1)

EUK-52100C12(1)

HVRAH20075(1)

HVR40201190(1)

HVR40201160(1)

ORK0300604; ORK7585501(1)

ORK7585501(1)

ORK0300604(1)

No(1)

 
Replacement Belt Unit

2/PK(10)

EA(1)

 
Capacity

18 qt.(3)

6.1 qt.(3)

16 gal(1)

5 gal(1)

6 gal(1)

 
Cord Length

50 ft(13)

40 ft(9)

20 ft(6)

35 ft(6)

30 ft(5)

12 ft(4)

32 ft(1)

60 ft(1)

50 ft Pigtail(1)

48 ft(1)

33 ft(1)

18 ft(1)

 
Filter Types

HEPA(7)

Sealed HEPA(5)

Standard(4)

High Filtration Bag(3)

HEPA Media(3)

Premium Allergen Synthetic(2)

Swiffer Sweeper Vac Filter(2)

Allergen Filtration(2)

Foam(1)

Triple(1)

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

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

Ultra Web(1)

Cartridge; Collection Bag; Foam Sleeve(1)

Washable Cloth(1)

Bagless Style(1)

Fiberglass Micro; Toner Bag; Triple: Cloth Bag(1)

Two-Layer Micro Filtration(1)

Teflon Coated HEPA(1)

Bagless System(1)

Premium Allergen(1)

Disposable Filter Bag(1)

Four-Stage(1)

Allergen(1)

Collection Bag; Secondary Filter(1)

 
Motor HP

6.5 hp(1)

6 hp(1)

3 hp(1)

 
Hose Length

8 ft(8)

5 ft(5)

10 ft(4)

12 ft(2)

7 ft(2)

6 ft(2)

3 ft(2)

9 ft(1)

19 ft(1)

18 ft(1)

 
On-Board Tools

Yes(27)

No(17)

 
Dust/Dirt Cup

Yes(16)

No(15)

 
Air Watts

180 W(1)

145 W(1)

 
Hose Diameter

1 1/2"(1)

1.5"(1)

1.25"(1)

 
 
 

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