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') 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(19)

Betco(8)

Hoover(8)

Shop-Vac(5)

Oreck(3)

Eureka(2)

Swiffer(1)

 
Color

Red(19)

Black(16)

Gray(8)

Silver(7)

Yellow(5)

Blue(3)

Chrome(2)

Orange(2)

Rick Red(1)

 
Limited Warranty

1 Year(9)

2 Year(4)

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)

15.20 lb(1)

22 lb(1)

24 lb(1)

12.40 lb(1)

15 lb(1)

8.30 lb(1)

7.30 lb(1)

25 lb(1)

22.80 lb(1)

16.70 lb(1)

47 lb(1)

1.01 lb(1)

17.50 lb(1)

15.80 lb(1)

14 lb(1)

8 lb(1)

11 lb(1)

67 lb(1)

16 lb(1)

 
Input Voltage

120 V AC(12)

12 V DC(3)

24 V DC(1)

110 V AC(1)

110 V(1)

230 V AC(1)

 
Attachments

Filter(19)

Crevice Tool(17)

Hose(14)

Brushroll(14)

Brush(13)

Dusting Brush(9)

Nozzle(8)

Wand(7)

Upholstery Tool(7)

Dirt Cup(7)

Telescopic Wand(4)

Squeegee(3)

Extension Wand(3)

Upholstery Brush(2)

Floor Nozzle(2)

Claw Nozzle(2)

Scrub Brush(2)

Pet Hair Tool(1)

Steaming Pad(1)

Extension Tube(1)

Extension Hose(1)

Brush Tool(1)

Upholstery Nozzle(1)

Scrubbing Pad(1)

Floor Tool(1)

Utility Nozzle(1)

 
Battery Rechargeable

Yes(2)

 
Input Current

7 A(6)

12 A(5)

10 A(5)

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

1.53 gal(3)

1.13 gal(2)

3.50 quart(2)

1.50 gal(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(25)

Bare Floor(8)

Hard Floor(5)

Dry Surface(5)

Wet Surface(5)

Tile Floor(4)

Wooden Floor(4)

Hardwood(3)

Laminate Floor(3)

Ceramic Tile(1)

Concrete(1)

Vinyl Floor(1)

Rug(1)

 
Air Flow

897.7 gal/min(3)

1084.7 gal/min(3)

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)

600 W(2)

840 W(2)

2237.10 W(2)

372.85 W(1)

745.70 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)

79 dB(A)(2)

70 dB(1)

65 dB(A)(1)

66 dB(A)(1)

71 dB(1)

68 dB(1)

63 dB(A)(1)

78 dB(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)

CH54115(1)

SC9180B(1)

C1660900(1)

C1703-900(1)

C1800010(1)

CH20110(1)

CH30000(1)

CH53010(1)

CH54113(1)

NEU180(1)

SC889A(1)

NEU188(1)

ORB550MC(1)

U2000RB1(1)

XL2100RHS(1)

85801(1)

3942010(1)

5870210(1)

9593410(1)

9627110(1)

SC899G(1)

SC888M(1)

E2997500(1)

688(1)

E8301000(1)

E8301300(1)

E8301400(1)

E8301500(1)

E8303900(1)

E8590300(1)

530B(1)

5745B(1)

684(1)

9050D(1)

SC887D(1)

SC3683B(1)

SC3700(1)

SC412A(1)

SC535(1)

SC5713B(1)

SC5845B(1)

SC679J(1)

SC689A(1)

SC886F(1)

9653610(1)

 
Country of Origin

United States(18)

Mexico(17)

China(9)

Italy(2)

 
Height

50"(4)

38"(1)

42.5"(1)

44"(1)

22.5"(1)

23"(1)

12"(1)

45"(1)

44.5"(1)

17.3"(1)

29"(1)

21.5"(1)

 
Width

18"(2)

14"(2)

22"(1)

9.3"(1)

20"(1)

21"(1)

17"(1)

12.5"(1)

33.8"(1)

13"(1)

16"(1)

16.5"(1)

 
Depth

9"(1)

16"(1)

13.4"(1)

 
Length

29"(2)

25"(2)

43"(1)

21.3"(1)

35"(1)

15.5"(1)

17.3"(1)

18.3"(1)

16.5"(1)

 
Power Source

AC Supply(14)

Battery(3)

 
Cable Length

50 ft(14)

35 ft(5)

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

13"(6)

20"(5)

14"(5)

15"(3)

11"(2)

12.60"(2)

17"(1)

10"(1)

16"(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