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

Hoover Commercial(11)

DataVac(5)

Oreck Commercial(5)

Shop-Vac(4)

Mercury Floor Machines(3)

Eureka(2)

Metrovac(2)

Swiffer(2)

 
Height

44 1/2"(1)

11 1/2"(1)

15 3/10"(1)

36"(1)

33.25"(1)

28"(1)

17.75"(1)

10"(1)

 
Color(s)

Black(18)

Red(6)

Gray/Orange(3)

Yellow/Black(3)

Gray(2)

Red/Gray(2)

Green/Silver(2)

Yellow(1)

Blue(1)

Red/Black(1)

Gray/Red(1)

White(1)

Gray/Blue(1)

Black/Yellow(1)

 
Depth

13.78"(1)

16 1/2"(1)

42"(1)

12 7/8"(1)

28.5"(1)

17.25"(1)

18"(1)

 
Diameter

7"(3)

4"(2)

1.6"(1)

6 3/4"(1)

17"(1)

12"(1)

1 1/2"(1)

1.5"(1)

10"(1)

 
Manufacturer Part Number

3670G(1)

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

CH54115(1)

BB900DGR(1)

U2000R1(1)

U2000RB1(1)

XL2100RHS(1)

92705CT(1)

92705KT(1)

3942010(1)

5812600(1)

5870210(1)

DV3ESD1(1)

CH54113(1)

NEU188(1)

SC6093(1)

6055A(1)

SC3683B(1)

SC3700A(1)

SC412B(1)

SC535(1)

SC5713B(1)

SC5745B(1)

SC5815D(1)

SC5845B(1)

SC679J(1)

CH53010(1)

SC9180B(1)

C1660900(1)

C1800010(1)

C2401(1)

C3820(1)

CH20110(1)

CH3000(1)

CH34006(1)

CH53005(1)

9991910(1)

 
Country of Origin

US(25)

CN(13)

MX(8)

 
Width

13.4"(1)

22"(1)

14 1/4"(1)

16"(1)

17"(1)

12 7/8"(1)

21.5"(1)

14"(1)

10"(1)

 
Weight

12 lbs(1)

25 lbs(1)

9 lbs(1)

 
Orientation

Horizontal(1)

 
Height Adjustment

No(9)

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

110 V(3)

18 V(1)

12 V(1)

115 V(1)

110-120 V(1)

 
Body Material

Plastic(15)

Steel(7)

Polypropylene(4)

ABS Plastic(4)

Plastic/Aluminum(2)

Polycarbonate(1)

Chrome/Steel(1)

Aluminum/Plastic(1)

 
Power

1.7 hp(3)

500 W(3)

1400 W(2)

1200 W(1)

2.2 hp(1)

1300 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(9)

12 amp(5)

4 amp(4)

9 amp(2)

7 amp(2)

4.5 amp(2)

8 A(1)

5 amp(1)

11.3 amp(1)

6.5 amp(1)

8 amp(1)

7.9 A(1)

804 Watt(1)

10.4 A(1)

12 A(1)

AC(1)

 
Power Type

AC(3)

 
Furniture Guard

Yes(17)

No(14)

 
Headlight

No(29)

Yes(4)

 
Cleaning Path

14"(7)

10"(5)

12"(5)

13"(4)

15"(4)

11"(2)

12.6"(1)

28"(1)

4"(1)

9 1/2"(1)

6"(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)

HVR40140201(1)

HVR303172001(1)

Foam Filter part #MVC49(1)

Foam Filter part #MVC-56F(1)

SHO-9039700(1)

Shop Vac 9035000(1)

SHO9039700; SHO9052600(1)

 
Tank Capacity

4.5 qt(3)

5 gal(2)

6 oz(2)

3.5 qt(2)

2 qt(1)

1 cup(1)

16 gal(1)

1.25 qt(1)

20 gal(1)

6.4 qt(1)

6 qt(1)

2.6 qt(1)

4 qt(1)

10 qt(1)

1.5 gal(1)

1 gal(1)

1 qt(1)

 
Cleaning Width

14"(1)

 
Replacement Bag

ORKPK800025; ORKPK800025DW; ORKPK80009; ORKPK80009DW(3)

HVRAH10243; HVRAH10143(2)

60295C; 60296C(1)

HVR4010038N(1)

No(1)

SHO-9067100(1)

DV-5PBRP(1)

HVRAH10273; HVRAH10173(1)

HVR401000BP; HVR2KE2105000(1)

EUK-62370-10(1)

HVR58642015(1)

EUK-63262B-10(1)

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

68103(1)

Sanitaire 63256A(1)

EUK-63256A-10(1)

SHO9067100(1)

 
Replacement Belt

HVR440007804(2)

Sanitaire 61120G(2)

EUK-54312C-12(1)

EUK-61120D12(1)

16250CP(1)

EUK-52100C-12(1)

HVR40201190(1)

ORK0300604; ORK7585501(1)

ORK7585501(1)

ORK0300604(1)

No(1)

 
Power Capacity

0.5 hp(1)

 
Replacement Belt Unit

2/PK(4)

 
Capacity

16 gal(1)

5 gal(1)

 
Cord Length

40 ft(8)

20 ft(6)

50 ft(5)

30 ft(4)

35 ft(4)

12 ft(4)

18 ft(2)

32 ft(1)

60 ft(1)

48 ft(1)

33 ft(1)

6 ft(1)

 
Filter Types

HEPA(5)

Sealed HEPA(5)

High Filtration Bag(3)

HEPA Media(3)

Swiffer Sweeper Vac Filter(2)

Foam(1)

Triple(1)

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

Ultra Web(1)

Cartridge; Collection Bag; Foam Sleeve(1)

Allergen Filtration(1)

Washable Cloth(1)

Foam Filters(1)

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

Paper Disposable Bag(1)

Allergen(1)

Two-Layer Micro Filtration(1)

Bagless Style(1)

Teflon Coated HEPA(1)

Standard(1)

Disposable Filter Bag(1)

Four-Stage(1)

Collection Bag; Secondary Filter(1)

 
Motor HP

6.5 hp(1)

6 hp(1)

 
Hose Length

8 ft(7)

5 ft(5)

10 ft(4)

6 ft(4)

7 ft(2)

3 ft(2)

9 ft(1)

19 ft(1)

18 ft(1)

12 ft(1)

 
On-Board Tools

Yes(22)

No(12)

 
Dust/Dirt Cup

Yes(12)

No(6)

 
Air Watts

180 W(1)

 
Hose Diameter

1 1/2"(1)

1.5"(1)

 
Vacuum Hose Length

25 ft(1)

 
Airflow

3400 fpm(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved