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

Currently Filtered by

Category

Brushes And Dusters

Refine Search

  GO
 
Brand

Rubbermaid Commercial(27)

Impact Products(18)

Unger(17)

Genuine Joe(15)

Ettore(6)

Swiffer(6)

BALKAMP(5)

Oreck(5)

Carlisle(2)

Clorox(2)

Microfiber Technologies(2)

SKILCRAFT(2)

 
Color

White(28)

Yellow(21)

Black(21)

Gray(16)

Blue(14)

Brown(12)

Red(5)

Green(5)

Assorted(4)

Silver(2)

Wood Grain(1)

Multi(1)

Rainbow(1)

Graphite(1)

Orange(1)

Tan(1)

Navy Blue(1)

Cream(1)

Neutral Gray(1)

 
Recycled

No(107)

 
Packaged Quantity

1 Each(57)

12 / Carton(21)

6 / Carton(13)

5 / Carton(3)

10 / Carton(3)

24 / Carton(2)

1 / Each(2)

1 / Kit(2)

1 Kit(1)

12 Carton(1)

5 / Kit(1)

6 / Kit(1)

 
Assembly Required

No(106)

 
Limited Warranty

1 Year(4)

 
Weight (Approximate)

1 lb(3)

7.05 oz(3)

9.52 oz(2)

3 lb(1)

4 lb(1)

11.60 lb(1)

12.70 oz(1)

3 oz(1)

6.35 oz(1)

 
Compatibility

Oreck Orbiter Floor Machine(3)

Oreck Floor Cleaners:

  • Orbiter ultra
  • Orbiter
  • Ceramic
  • Stone
(1)

  • Oreck Orbiter Floor Machine
  • Oreck Dry Carpet Cleaning System
(1)

Unger AL140 pro aluminum handle or AL14G knock-down handle(1)

All Unger telescopic poles(1)

 
Recycled Content

No(1)

 
Diameter

13"(3)

12"(2)

 
Manufacturer Part Number

7601391(1)

633700BE(1)

9B29(1)

9B0900BKCT(1)

9B0900BK(1)

9B0700BKCT(1)

9B0700BK(1)

6482COBCT(1)

648200 COBLT(1)

6342CT(1)

6342(1)

633700BECT(1)

632000BRNCT(1)

9B32(1)

632000BRN(1)

631000WECT(1)

631000WE(1)

630100YEL(1)

82074CT(1)

82074(1)

16942CT(1)

16942(1)

11804CT(1)

11804(1)

237058(1)

9B29CT(1)

9B32CT(1)

237.049(1)

BSRHR(1)

WALB0(1)

SB20GCT(1)

SB20G(1)

PB45R(1)

EC45R(1)

COBW0(1)

CEDUGCT(1)

CEDUG(1)

CB20GCT(1)

CB20G(1)

BBWHRCT(1)

9B3400(1)

BBWHR(1)

BBCORCT(1)

BBCOR(1)

95021(1)

T13000GYCT(1)

T13000GY(1)

Q85000BKCT(1)

Q85000BK(1)

9B5600BKCT(1)

9B5600BK(1)

9B3400CT(1)

237057(1)

237.048(1)

7601832(1)

48720CT(1)

98217(1)

98216(1)

98215CT(1)

98215(1)

90218CT(1)

90218(1)

90118CT(1)

90118(1)

90112CT(1)

90112(1)

48720(1)

98218(1)

48221CT(1)

48221(1)

48212CT(1)

48212(1)

03191CT(1)

14884(1)

4505403(1)

4188100(1)

8215223(1)

8191056(1)

8135013(1)

98217CT(1)

98218CT(1)

237.047(1)

3147CT(1)

7920-00-178-8315(1)

7920-00-061-0038(1)

7400(1)

4603CT(1)

4603(1)

37336(1)

37036(1)

333(1)

3149CT(1)

3149(1)

3147(1)

99657(1)

3125WCT(1)

3125W(1)

3106CT(1)

3106(1)

3103CT(1)

3103(1)

3100CT(1)

3100(1)

225CT(1)

225(1)

99658(1)

WALB0CT(1)

 
Country of Origin

China(51)

United States(21)

Indonesia(10)

Sri Lanka(9)

South Africa(4)

Canada(4)

Germany(3)

Mexico(2)

India(2)

Taiwan(1)

 
Material

Plastic(29)

Polypropylene(16)

MicroFiber(11)

Nylon(11)

Tampico(7)

Lamb's Wool(7)

Natural Fiber(6)

Synthetic(5)

Palmyra(5)

Plastic Foam(4)

Hardwood(4)

Polyethylene Terephthalate (PET)(4)

Synthetic Fiber(3)

Tampico Fiber(3)

Vinyl(3)

Fiber(3)

Synthetic Polypropylene(3)

Ostrich Feather(3)

Cotton(2)

Aluminum(2)

Polypropylene Fiber(2)

Iron(2)

Horsehair(2)

Lacquered Wood(1)

Polywool(1)

Poly Fiber(1)

Foam Rubber(1)

 
Height

2.8"(4)

7.5"(2)

3.1"(2)

30"(1)

28"(1)

4.8"(1)

23"(1)

3"(1)

1.5"(1)

5.1"(1)

3.3"(1)

3.9"(1)

1.3"(1)

2.6"(1)

 
Width

11"(2)

7.5"(2)

3.5"(2)

12.6"(2)

1"(1)

0.7"(1)

4.8"(1)

9"(1)

3"(1)

3.8"(1)

3.3"(1)

1.1"(1)

9.1"(1)

5"(1)

5.3"(1)

2.3"(1)

6.9"(1)

2.5"(1)

10"(1)

 
Depth

3.8"(1)

2"(1)

 
Length

11.5"(3)

8.5"(3)

20"(3)

16"(3)

52"(2)

8.3"(2)

28.8"(2)

18.5"(2)

9.4"(2)

9"(2)

60"(2)

15.5"(1)

2.5"(1)

18.9"(1)

3.1"(1)

9.8"(1)

8.8"(1)

25.2"(1)

12.5"(1)

28"(1)

14.5"(1)

17.8"(1)

13"(1)

11.3"(1)

23"(1)

24"(1)

10"(1)

 
Handle Material

Plastic(12)

Iron(3)

Vinyl(2)

Wood(1)

Hardwood(1)

 
Handle Color

White(4)

Black(2)

Gray(2)

 
Handle Length

9"(3)

8"(3)

26"(3)

42"(2)

10"(2)

17"(2)

20"(2)

102"(2)

5"(1)

36"(1)

14.50"(1)

 
Head Width

10"(3)

24"(2)

36"(1)

 
Bristle Material

Nylon(12)

Polypropylene(6)

Palmyra(5)

MicroFiber(3)

Lamb's Wool(3)

Plastic(3)

Synthetic Polypropylene(3)

Synthetic(3)

Tampico(3)

Polyethylene Terephthalate (PET)(3)

Fiber(2)

Horsehair(2)

Tampico Fiber(1)

 
Handle Diameter

1.75"(1)

 
 
 
 
 

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