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

Currently Filtered by

Category

Desktop Plants

Refine Search

  GO
 
Brand

Sanitaire(17)

Hoover Commercial(13)

MetroVac(11)

Honeywell(4)

Clarke(4)

DataVac(3)

Mercury Floor Machines(3)

Oreck Commercial(3)

ProTeam(2)

Eureka(1)

 
Diameter

1.5"(3)

4"(2)

1.6"(1)

7"(1)

6.75"(1)

17"(1)

 
Air Watts

125 AW(1)

185 AW(1)

 
Country of Origin

US(29)

MX(16)

CN(14)

VN(2)

 
Height

9"(4)

44"(3)

16"(3)

11"(2)

44.5"(1)

44.1"(1)

48"(1)

22.9"(1)

22.4"(1)

36"(1)

13"(1)

46.5"(1)

46"(1)

45.3"(1)

24.5"(1)

26.9"(1)

33.56"(1)

35"(1)

14"(1)

35.75"(1)

23"(1)

 
Width

28"(4)

12"(3)

15"(3)

13.25"(2)

17"(2)

21"(2)

13.4"(1)

9.8"(1)

25"(1)

14"(1)

10.1"(1)

9"(1)

9.5"(1)

8.5"(1)

30"(1)

36"(1)

13"(1)

10.13"(1)

 
Depth

10"(6)

12"(3)

13"(2)

7.87"(2)

8"(2)

13.78"(1)

9"(1)

21"(1)

9.9"(1)

10.5"(1)

13.4"(1)

17"(1)

14"(1)

13.06"(1)

6"(1)

6.75"(1)

16"(1)

10.13"(1)

 
Color(s)

Black(20)

Red(8)

Blue(3)

Gray/Red/Black(3)

Gray/Blue(3)

Gray/Orange(3)

Red/Gray(2)

Silver/Black(2)

White(2)

Black/Red(2)

Graphite(2)

Black/Orange(1)

Dark Silver(1)

Chrome/Red(1)

Gray(1)

Gray/Red(1)

Red/Black(1)

Gray/Black(1)

Gray/Purple(1)

 
Length

13.25"(1)

 
Height Adjustment

No(7)

Six-Position(7)

Seven-Position(4)

Yes(4)

Four-Position(4)

Automatic(3)

Five-Position(1)

 
Voltage

120 V(31)

40 V(3)

110 V(2)

28.8 V(2)

25.2 V(2)

12 V(1)

115 V(1)

110 to 120 V(1)

 
Cord Length

50 ft(16)

12 ft(9)

40 ft(8)

30 ft(5)

35 ft(4)

20 ft(3)

32 ft(1)

48 ft(1)

33 ft(1)

6 ft(1)

18 ft(1)

 
Body Material

Plastic(16)

Steel(14)

ABS Plastic(6)

Metal/Plastic(4)

Chrome Steel Motor Hood; Plastic(2)

Polycarbonate(1)

Polypropylene(1)

Cloth; Plastic(1)

 
Battery Type

Lithium-Ion(1)

 
Power

500 W(6)

1,300 W(3)

450 W(2)

300 W(2)

1,000 W(2)

1,400 W(1)

430 W(1)

2.2 hp(1)

120 CFM(1)

400 W(1)

600 W(1)

1.7 hp(1)

0.5 hp(1)

2.67 hp(1)

924 W(1)

1,108 W(1)

 
Current

10 A(11)

7 A(8)

4.2 A(5)

4 A(4)

9 A(3)

10.8 A(3)

4.5 A(3)

12 A(2)

8 A(2)

5 A(2)

6 A(1)

10 Amps(1)

11.3 A(1)

11.25 A(1)

804 W(1)

10.4 A(1)

9.5 A(1)

 
Hose Length

6 ft(9)

8 ft(7)

70.5"(4)

5 ft(3)

10 ft(3)

15"(2)

15 in(2)

9 ft(1)

6.5 ft(1)

19 ft(1)

7 ft(1)

 
Cleaning Path

12"(14)

14"(6)

13"(5)

15"(4)

11.5"(3)

10"(2)

12.6"(1)

11"(1)

16"(1)

9"(1)

13.5"(1)

8.7"(1)

8.5"(1)

4"(1)

14.5"(1)

 
On-Board Tools

Yes(24)

No(14)

 
Furniture Guard

Yes(26)

No(12)

 
Power Type

AC(3)

 
Batteries Included

Yes(2)

No(1)

 
Run Time

Up to 120 min(1)

 
Dust/Dirt Cup

Yes(13)

No(11)

 
Replacement Filter

Sanitaire 61840(3)

Hoover Commercial 440007773, 440007774(2)

Clarke 1471250600(2)

Clarke 1471104500(2)

Hoover Commercial 303172001(1)

Yes(1)

Hoover Commercial AH40006(1)

Metrovac MVC49(1)

Metrovac MVC56F(1)

ProTeam 1241941(1)

 
Caster/Glide/Wheel Type

Wheel(1)

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

 
Tank Capacity

6 qt(4)

18 qt(4)

4.5 qt(3)

10 qt(3)

3.5 qt(2)

4.2 qt(2)

6.1 qt(2)

0.7 L(1)

20 gal(1)

0.33 qt(1)

550 mL(1)

580 mL(1)

0.8 L(1)

1 gal(1)

2.9 L(1)

1.5 gal(1)

6.4 qt(1)

9.87 qt(1)

4 qt(1)

1.9 qt(1)

9.5 qt(1)

3.25 qt(1)

 
Replacement Belt

Sanitaire 52100C12(7)

Sanitaire 61120G(2)

Sanitaire 52100B(2)

Hoover Commercial 440007804(2)

Sanitaire 61120D12(1)

Sanitaire 66100(1)

Yes(1)

Oreck Commercial 0300604; Oreck Commercial 7585501(1)

Oreck Commercial 7585501(1)

Oreck Commercial 0300604(1)

 
Replacement Bag

Disposable Paper(8)

Oreck Commercial PK800025, PK800025DW, PK80009, PK80009DW(3)

ProTeam 553959, 812348(2)

Hoover Commercial AH10243, AH10143(2)

Sanitaire 63213A10(2)

Clarke 1471059500(2)

Clarke 1471097510(1)

Clarke 1471098510(1)

Metrovac DV5PBRP(1)

Cloth Dust Bag(1)

Sanitaire 63253A10(1)

Yes(1)

Sanitaire 6237010(1)

Hoover Commercial 4010038N(1)

Hoover Commercial 401000BP, 2KE2105000(1)

Hoover Commercial AH10159(1)

Sanitaire 63262B10(1)

Sanitaire 63213B10(1)

Sanitaire 63256A(1)

Sanitaire 63256A10(1)

Hoover Commercial AH10273, AH10173(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved