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

Currently Filtered by

Category

Vacuums

Refine Search

  GO
 
Brand

Sanitaire(20)

Hoover Commercial(14)

Shop-Vac(8)

Eureka(5)

DataVac(5)

Oreck Commercial(5)

Mercury Floor Machines(3)

Metrovac(2)

Swiffer(2)

 
Height

44 1/2"(2)

44.7"(1)

11 1/2"(1)

44"(1)

15 3/10"(1)

36"(1)

33.25"(1)

28"(1)

15"(1)

29"(1)

26"(1)

30"(1)

10"(1)

 
Color(s)

Black(20)

Red(10)

Yellow(4)

Yellow/Black(4)

Blue(3)

Gray/Red/Black(3)

Gray(3)

Gray/Orange(3)

Red/Gray(2)

Green/Silver(2)

Black/Yellow(2)

Red/Black(1)

Gray/Red(1)

Chrome/Red(1)

White(1)

Gray/Blue(1)

 
Depth

13.78"(1)

12.4"(1)

16 1/2"(1)

16"(1)

42"(1)

12 7/8"(1)

28.5"(1)

12"(1)

24"(1)

18"(1)

 
Diameter

7"(3)

4"(2)

1.6"(1)

21"(1)

6 3/4"(1)

17"(1)

12"(1)

1 1/2"(1)

11"(1)

18.375"(1)

18"(1)

19"(1)

10"(1)

 
Manufacturer Part Number

3670G(1)

WVP-20(1)

CH53005(1)

CH53010(1)

CH54113(1)

CH54115(1)

DV3ESD1(1)

ED500(1)

ED500ESD(1)

MDV-1BA(1)

MDV1ESD(1)

MDV-2TCA(1)

MDV-3TCA(1)

50-1001(1)

PRO-12-100-2(1)

23T(1)

CH32008(1)

BB900DGR(1)

U2000R1(1)

U2000RB1(1)

XL2100RHS(1)

92705CT(1)

92705KT(1)

3942010(1)

5812600(1)

5890210(1)

9623710(1)

9623810(1)

9625210(1)

9625710(1)

CH34006(1)

CH3000(1)

71B(1)

SC5845B(1)

NEU188(1)

NEU192(1)

NEU562(1)

6055A(1)

887(1)

899(1)

SC3683B(1)

SC3700A(1)

SC412B(1)

SC535(1)

SC5713B(1)

SC5745B(1)

SC5815D(1)

SC6093(1)

CH20110(1)

SC679J(1)

SC684F(1)

SC688A(1)

SC689(1)

SC886E(1)

SC888K(1)

SC889A(1)

SC9180B(1)

C1433010(1)

C1660900(1)

C1703900(1)

C1800010(1)

C2401(1)

C3820(1)

9991910(1)

 
Country of Origin

US(30)

CN(18)

MX(16)

 
Width

13.4"(1)

12.1"(1)

12 1/2"(1)

22"(1)

13"(1)

14 1/4"(1)

16"(1)

17"(1)

12 7/8"(1)

21.5"(1)

11"(1)

18"(1)

10"(1)

 
Weight

17.5 lbs(2)

9 lbs(2)

18.5 lbs(1)

18 lbs(1)

65 lbs(1)

32 lbs(1)

31 lbs(1)

39 lbs(1)

 
Orientation

Horizontal(1)

 
Height Adjustment

No(14)

Six Position(5)

Seven Position(4)

Five-Position(4)

Six-Position(3)

Four-Position(3)

Automatic(2)

Yes(2)

Adjustable by removing pieces of the handle(2)

Four Position(1)

Three-Position(1)

 
Voltage

120 V(30)

110 V(3)

18 V(1)

12 V(1)

115 V(1)

110-120 V(1)

 
Body Material

Plastic(22)

Steel(7)

Polypropylene(4)

ABS Plastic(4)

Metal/Plastic(2)

Polycarbonate(2)

Chrome Steel Motor Hood(2)

Plastic/Aluminum(2)

Plastic; Metal(1)

Chrome/Steel(1)

Aluminum/Plastic(1)

 
Power

1.7 hp(3)

500 W(3)

1400 W(2)

6.5 hp(2)

2.5 hp(2)

1200 W(1)

2.2 hp(1)

1300 W(1)

0.5 hp(1)

2.67 hp(1)

5 hp(1)

1.5 hp(1)

 
Surface Type

Dry; Wet(1)

 
Current

10 amp(12)

7 amp(9)

12 amp(7)

4 amp(4)

8 amp(3)

9 amp(3)

4.5 amp(2)

5 amp(2)

12 A(1)

10.4 A(1)

804 Watt(1)

6 amp(1)

7.9 A(1)

6.5 amp(1)

5.5 amp(1)

11.3 amp(1)

8 A(1)

11.9 amp(1)

 
Power Type

AC(3)

 
Furniture Guard

Yes(28)

No(21)

 
Headlight

No(44)

Yes(6)

 
Cleaning Path

12"(14)

14"(10)

10"(5)

13"(5)

15"(4)

12.6"(2)

10 1/2"(2)

11"(2)

6"(2)

16"(1)

28"(1)

4"(1)

9 1/2"(1)

 
Caster/Glide/Wheel Type

Two 3" Fixed(1)

Two 3" Swivel; Two 10" Fixed(1)

 
Replacement Filter

Sanitaire 61840(3)

HVR440007773; HVR440007774(2)

PGC 06174(2)

38333(1)

Standard(1)

HVR40140201(1)

HVRAH10040(1)

HVR303172001(1)

Foam Filter part #MVC49(1)

Foam Filter part #MVC-56F(1)

SHO-9039700(1)

Shop Vac 9035000(1)

SHO9039700(1)

SHO9035000(1)

 
Tank Capacity

4.5 qt(3)

6 oz(2)

16 gal(2)

3.5 qt(2)

9.5 qt(2)

2 qt(1)

1 cup(1)

18 gal(1)

12 gal(1)

22 gal(1)

2.5 gal(1)

5 gal(1)

1.25 qt(1)

20 gal(1)

6.4 qt(1)

6 qt(1)

4.1 qt(1)

4 qt(1)

10 qt(1)

1.5 gal(1)

1 gal(1)

2.6 qt(1)

18 qt(1)

1.9 qt(1)

2.1(1)

1 qt(1)

 
Cleaning Width

14"(1)

 
Replacement Bag

ORKPK800025; ORKPK800025DW; ORKPK80009; ORKPK80009DW(3)

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

EUK-63213A-10(3)

HVRAH10243; HVRAH10143(2)

60295C; 60296C(1)

HVRAH10263; HVRAH10363(1)

No(1)

SHO-9067100(1)

DV-5PBRP(1)

HVRAH10273; HVRAH10173(1)

HVR401000BP; HVR2KE2105000(1)

HVR4010038N(1)

EUK-62370-10(1)

HVR58642015(1)

HVR4010100Y(1)

EUK-63262B-10(1)

68103(1)

Sanitaire 63256A(1)

EUK-63256A-10(1)

SHO9067300(1)

 
Replacement Belt

EUK-52100C-12(6)

No(3)

52100B(2)

Sanitaire 61120G(2)

HVR440007804(2)

EUK-54312C-12(1)

EUK-61120D12(1)

16250CP(1)

EUK-52100C12(1)

HVRAH20075(1)

HVR40201190(1)

HVR40201160(1)

ORK0300604; ORK7585501(1)

ORK7585501(1)

ORK0300604(1)

 
Power Capacity

0.5 hp(1)

 
Replacement Belt Unit

2/PK(10)

EA(1)

 
Capacity

18 qt.(2)

6.1 qt.(2)

16 gal(1)

 
Cord Length

50 ft(12)

40 ft(9)

35 ft(8)

20 ft(6)

30 ft(6)

12 ft(4)

18 ft(4)

6 ft(2)

32 ft(1)

60 ft(1)

50 ft Pigtail(1)

48 ft(1)

33 ft(1)

 
Filter Types

HEPA(8)

Sealed HEPA(5)

Standard(4)

HEPA Media(3)

High Filtration Bag(3)

Allergen Filtration(2)

Swiffer Sweeper Vac Filter(2)

Foam(1)

Cartridge; Collection Bag; Foam Sleeve(1)

Cartridge Filter(1)

Ultra Web(1)

Triple(1)

Disposable Filter Bag; Foam Sleeve; Ultra Web Cartridge(1)

Ultra Web Cartridge; High Efficiency Filter Bag(1)

Large Ultra-Web Cartridge Filter(1)

Ultra Web Cartridge; High Efficiency Disposable Filter Bag(1)

Washable Cloth(1)

Two-Layer Micro Filtration(1)

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

Paper Disposable Bag(1)

Foam Filters(1)

Bagless Style(1)

Teflon Coated HEPA(1)

Bagless System(1)

Premium Allergen Synthetic(1)

Micro-Filtration 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)

 
Hose Length

8 ft(7)

5 ft(5)

12 ft(5)

10 ft(4)

6 ft(4)

7 ft(3)

3 ft(2)

9 ft(1)

19 ft(1)

18 ft(1)

4 ft(1)

 
On-Board Tools

Yes(29)

No(19)

12' x 1.5" Diameter Locking Hose; 2 Wands; 14" Wide Floor Nozzle; Claw Nozzle; Crevice Tool; Hose Adapter(1)

 
Dust/Dirt Cup

Yes(16)

No(15)

 
Hose Diameter

1 1/2"(1)

 
Vacuum Hose Length

25 ft(1)

 
Airflow

3400 fpm(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved