Banner1 Banner1
 
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 ('113081')) 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(21)

Betco(7)

Hoover(6)

Shop-Vac(5)

Oreck(3)

Eureka(2)

Bissell(1)

BigGreen(1)

 
Color

Red(23)

Black(14)

Gray(9)

Yellow(5)

Silver(4)

Orange(2)

Blue(2)

Chrome(1)

 
Limited Warranty

1 Year(8)

2 Year(3)

3 Year(2)

 
Weight (Approximate)

90 lb(3)

11.50 lb(3)

18.50 lb(3)

9 lb(2)

17 lb(2)

282 lb(1)

25 lb(1)

22 lb(1)

24 lb(1)

12.40 lb(1)

15 lb(1)

8.30 lb(1)

1.01 lb(1)

16.70 lb(1)

17.50 lb(1)

14 lb(1)

8 lb(1)

15.40 lb(1)

11 lb(1)

67 lb(1)

16 lb(1)

 
Input Voltage

120 V AC(10)

12 V DC(3)

24 V DC(1)

110 V AC(1)

110 V(1)

230 V AC(1)

 
Attachments

Filter(17)

Brushroll(16)

Crevice Tool(16)

Hose(13)

Brush(11)

Dusting Brush(8)

Nozzle(6)

Wand(6)

Dirt Cup(6)

Upholstery Tool(6)

Telescopic Wand(4)

Squeegee(3)

Extension Wand(3)

Brush Tool(2)

Scrub Brush(2)

Upholstery Brush(2)

Claw Nozzle(2)

Floor Nozzle(2)

Floor Tool(1)

Scrubbing Pad(1)

Extension Tube(1)

Upholstery Nozzle(1)

Extension Hose(1)

Pet Hair Tool(1)

Utility Nozzle(1)

 
Battery Rechargeable

Yes(1)

 
Input Current

10 A(5)

12 A(4)

7 A(4)

11.50 A(4)

5 A(2)

9 A(1)

6.50 A(1)

2 A(1)

5.40 A(1)

8.90 A(1)

11.80 A(1)

8.40 A(1)

 
Dust Capacity

4.50 gal(6)

1.13 gal(2)

1.53 gal(2)

1.50 gal(2)

3.50 quart(2)

1 gal(1)

12 gal(1)

16 gal(1)

5 gal(1)

1.06 gal(1)

1.32 gal(1)

1.90 quart(1)

1.89 quart(1)

2.50 gal(1)

2.60 quart(1)

1.65 gal(1)

6 gal(1)

 
Dust Collection

Bagged(14)

Bagless(11)

 
Floor Type

Carpet(29)

Bare Floor(8)

Dry Surface(5)

Wet Surface(5)

Hard Floor(4)

Hardwood(3)

Tile Floor(3)

Wooden Floor(3)

Laminate Floor(2)

Ceramic Tile(1)

Concrete(1)

Vinyl Floor(1)

Rug(1)

 
Air Flow

897.7 gal/min(3)

1084.7 gal/min(2)

1009.9 gal/min(2)

890.2 gal/min(1)

1137 gal/min(1)

1122.1 gal/min(1)

486.2 gal/min(1)

598.4 gal/min(1)

785.5 gal/min(1)

523.6 gal/min(1)

 
Motor

1118.55 W(4)

1200 W(4)

1000 W(2)

840 W(2)

600 W(2)

2237.10 W(2)

372.85 W(1)

246.08 W(1)

1400 W(1)

3728.50 W(1)

4474.20 W(1)

4101.35 W(1)

 
Sound Emission

69 dB(3)

70 dB(1)

65 dB(A)(1)

66 dB(A)(1)

69 dB(A)(1)

71 dB(1)

68 dB(1)

63 dB(A)(1)

78 dB(1)

79 dB(A)(1)

 
Air Watts

1380 W(1)

179.86 W(1)

224.82 W(1)

324.74 W(1)

144.88 W(1)

 
Water Tank Capacity

5 gal(1)

 
Manufacturer Part Number

E2993700(1)

CH54113(1)

SC887D(1)

SC888M(1)

SC899G(1)

SC9180B(1)

C1660900(1)

C1800010(1)

CH30000(1)

CH53010(1)

CH54115(1)

SC679J(1)

NEU180(1)

NEU188(1)

ORB550MC(1)

U2000RB1(1)

XL2100RHS(1)

3942010(1)

5870210(1)

9593410(1)

9627110(1)

SC689A(1)

SC5845B(1)

E8301000(1)

SC887E(1)

E8301300(1)

E8301400(1)

E8301500(1)

E8303900(1)

E8590300(1)

SC679K(1)

SC684G(1)

SC689B(1)

SC886G(1)

SC888N(1)

SC5713B(1)

SC889B(1)

SC899H(1)

530B(1)

5745B(1)

9050D(1)

SC3683B(1)

SC3700(1)

SC412A(1)

SC535(1)

9653610(1)

 
Country of Origin

Mexico(20)

United States(17)

China(7)

Italy(2)

 
Height

50"(4)

8.5"(4)

10"(2)

10.5"(2)

38"(1)

44"(1)

22.5"(1)

23"(1)

12"(1)

45"(1)

44.5"(1)

17.3"(1)

29"(1)

21.5"(1)

 
Width

17.3"(4)

14.5"(3)

18"(2)

16.5"(2)

14"(2)

22"(1)

20"(1)

21"(1)

17"(1)

12.5"(1)

33.8"(1)

13"(1)

16"(1)

 
Depth

9"(1)

16"(1)

13.4"(1)

 
Length

21.3"(5)

29"(2)

25"(2)

26.5"(2)

43"(1)

35"(1)

20.5"(1)

15.5"(1)

17.3"(1)

18.3"(1)

16.5"(1)

 
Power Source

AC Supply(13)

Battery(2)

 
Cable Length

50 ft(14)

40 ft(4)

35 ft(4)

30 ft(3)

20 ft(2)

18 ft(2)

75 ft(1)

1.97"(1)

25 ft(1)

6 ft(1)

12 ft(1)

 
Hose Length

96"(4)

60"(3)

84"(3)

12 ft(2)

48"(1)

10 ft(1)

18 ft(1)

 
Cleaning Path

12"(8)

14"(5)

13"(5)

20"(4)

15"(3)

16"(2)

12.60"(2)

17"(1)

10"(1)

11"(1)

12.47 ft(1)

1.50"(1)

1.26"(1)

 
Filter Type

HEPA(12)

Foam(1)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved