facebook
 
 
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_name` IN ('Dust Mop Frames','Duster Refills','Poles & Handles','Brooms & Sweepers','Brushes & Dusters','Dust Pans')) 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 '%BroomsDustersandAccessories' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('BroomsDustersandAccessories' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+BroomsDustersandAccessories' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"BroomsDustersandAccessories"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"BroomsDustersandAccessories"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"BroomsDustersandAccessories"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"BroomsDustersandAccessories"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+BroomsDustersandAccessories' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='BroomsDustersandAccessories',`category_4` ='BroomsDustersandAccessories') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'BroomsDustersandAccessories,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('BroomsDustersandAccessories', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Brooms Dusters And Accessories

Refine Search

  GO
 
Brand

Genuine Joe(78)

Rubbermaid Commercial(58)

Ettore(16)

Impact Products(15)

Unger(12)

Clorox(6)

Oreck(5)

Swiffer(5)

LobbyMaster(2)

Scotch-Brite(2)

3M(2)

Microfiber Technologies(1)

Microfiber(1)

SKILCRAFT(1)

 
Color

Black(52)

Yellow(39)

White(30)

Natural(24)

Blue(22)

Brown(17)

Gray(17)

Gold(8)

Silver(8)

Green(4)

Metallic(4)

Orange(3)

Stainless Steel(2)

Chrome(2)

Maroon(2)

Assorted(2)

Amber(1)

Cream(1)

Navy Blue(1)

Lacquer(1)

Tan(1)

Multi(1)

Graphite(1)

Rainbow(1)

Nickel(1)

Black/Silver(1)

Woodgrain(1)

Oak(1)

Aluminum(1)

 
Recycled

No(203)

 
Height

1.5"(5)

2.8"(4)

2.5"(3)

83"(2)

44"(2)

7"(2)

8.8"(2)

7.8"(2)

2"(2)

32"(2)

3.1"(2)

1.3"(2)

48"(2)

7.5"(2)

6"(1)

29"(1)

1.6"(1)

3.3"(1)

35"(1)

30"(1)

0.3"(1)

34"(1)

36"(1)

4"(1)

24"(1)

23"(1)

28"(1)

4.8"(1)

 
Depth

1.7"(1)

11"(1)

1.1"(1)

12"(1)

2"(1)

 
Size

12" Wide(8)

48" Width x 5" Depth(2)

16" Wide(2)

12.50" Wide(2)

5" Width x 36" Length(1)

36" Width x 5" Depth(1)

 
Diameter

13"(3)

12"(2)

1.6"(2)

1"(1)

 
Manufacturer Part Number

14884(1)

2018728CT(1)

16942(1)

16942CT(1)

37108(1)

1822352(1)

2017161(1)

2017161CT(1)

2018727(1)

2018727CT(1)

2018728(1)

2018784(1)

11804(1)

2018806(1)

2018806CT(1)

2018807(1)

2018807CT(1)

253100 BLA(1)

253100BKCT(1)

421288BK(1)

421288BKCT(1)

421388BK(1)

421388BKCT(1)

11804CT(1)

237058(1)

421588BKCT(1)

4603(1)

3103CT(1)

3106(1)

3106CT(1)

3125W(1)

3125WCT(1)

3147(1)

3147CT(1)

333(1)

37036(1)

37036CT(1)

4603CT(1)

237057(1)

LFSO100(1)

LFSO100CT(1)

549X4(1)

560R(1)

59247(1)

59247CT(1)

7920-01-458-8208(1)

237.047(1)

237.048(1)

237.049(1)

421588BK(1)

631000WE(1)

2600CSCT(1)

T13000GYCT(1)

Q75500YL00CT(1)

Q76000 YL00(1)

Q76000CT(1)

Q76500YL00(1)

Q76500YL00CT(1)

Q85000BK(1)

Q85000BKCT(1)

Q85500BK(1)

T13000GY(1)

95021(1)

Q560YLCT(1)

AL140(1)

AL140CT(1)

BBWHR(1)

BBWHRCT(1)

COBW0(1)

EP24R(1)

EP24RCT(1)

SB20G(1)

SB20GCT(1)

WALB0(1)

Q75500YL00(1)

Q560YL(1)

631000WECT(1)

637500 GRAY(1)

632000BRN(1)

632000BRNCT(1)

633700BE(1)

633700BECT(1)

6342(1)

6342CT(1)

636100LAC(1)

636100LACCT(1)

637400 BLA(1)

637400BKCT(1)

637500GYCT(1)

H14600BL00CT(1)

648200 COBLT(1)

6482COBCT(1)

9B29(1)

9B29CT(1)

9B3400(1)

9B3400CT(1)

9B5600BK(1)

9B5600BKCT(1)

FG638906B(1)

FG638906BCT(1)

3103(1)

2600CS(1)

03191BD(1)

02408CT(1)

02310EA(1)

02331(1)

02331CT(1)

02332(1)

02332CT(1)

02406(1)

02406CT(1)

02407(1)

02408(1)

09570(1)

02309CT(1)

11501CT(1)

11501EA(1)

12001CT(1)

12001EA(1)

12002CT(1)

12002EA(1)

12501CT(1)

12501EA(1)

20128(1)

20129(1)

02309EA(1)

00485EA(1)

37061CT(1)

42105(1)

03191CT(1)

03191PL(1)

14882BD(1)

14882PL(1)

1628(1)

1628CT(1)

1692(1)

1692CT(1)

42104(1)

42104CT(1)

42105CT(1)

00485CT(1)

42108(1)

42108CT(1)

48212(1)

48212CT(1)

48221(1)

48221CT(1)

48720(1)

48720CT(1)

00365CT(1)

00365EA(1)

37061(1)

48264CT(1)

225CT(1)

98218CT(1)

90118CT(1)

90218(1)

90218CT(1)

98215(1)

98215CT(1)

98216(1)

98216CT(1)

98217(1)

98217CT(1)

98218(1)

99652CT(1)

90112CT(1)

99653CT(1)

99654CT(1)

99655(1)

99655CT(1)

99656(1)

99656CT(1)

99657(1)

99658(1)

99658CT(1)

225(1)

90118(1)

90112(1)

48264EA(1)

60468(1)

48266(1)

48266CT(1)

48267(1)

48267CT(1)

58143(1)

58143CT(1)

58562(1)

58563(1)

58564(1)

60467(1)

60478(1)

85151CT(1)

80161(1)

80161CT(1)

80260(1)

80360(1)

80460(1)

85136(1)

85136CT(1)

85147(1)

85147CT(1)

85151(1)

WALB0CT(1)

 
Country of Origin

China(87)

United States(54)

Sri Lanka(19)

Mexico(11)

Brazil(9)

Indonesia(6)

South Africa(4)

Canada(4)

Germany(4)

Italy(2)

India(2)

Thailand(2)

 
Width

5"(5)

3.5"(4)

8.3"(4)

7.5"(3)

1.7"(2)

1.5"(2)

10"(2)

2"(2)

4.1"(2)

4"(2)

12.6"(2)

11"(2)

12"(2)

0.7"(1)

2.5"(1)

1.6"(1)

2.3"(1)

1.1"(1)

3.3"(1)

1.3"(1)

1"(1)

6.5"(1)

4.8"(1)

3.8"(1)

16.9"(1)

1.4"(1)

9"(1)

6.4"(1)

10.3"(1)

7"(1)

 
Material

Plastic(36)

Aluminum(20)

Polypropylene(17)

Metal(15)

Wood(15)

Nylon(11)

Steel(9)

Corn Fiber(7)

Anodized Aluminum(6)

MicroFiber(6)

Cotton(6)

Vinyl(6)

Galvanized Steel(5)

Lamb's Wool(5)

Natural Fiber(5)

Tampico(4)

Polyvinyl Chloride (PVC)(4)

Lacquered Wood(4)

ABS Plastic(4)

Palmyra(4)

Synthetic Polypropylene(3)

Rubber(3)

Ostrich Feather(3)

Hardwood(3)

Synthetic Fiber(3)

Fiber(3)

Synthetic(3)

Fiberglass(2)

Chrome Plated(2)

Polypropylene Fiber(2)

Tampico Fiber(2)

Iron(2)

Polyethylene Terephthalate (PET)(2)

Horsehair(2)

Foam(1)

Polywool(1)

Polyester(1)

Polyester Fiber(1)

Poly Fiber(1)

 
Weight (Approximate)

1 lb(4)

7.05 oz(2)

9.52 oz(2)

2.50 lb(2)

3.30 lb(2)

1.32 lb(2)

1.40 lb(2)

1.08 lb(2)

11.60 lb(1)

6.35 oz(1)

3.52 lb(1)

1.35 lb(1)

9.60 oz(1)

3.46 lb(1)

0.16 oz(1)

3 lb(1)

4.75 lb(1)

 
Length

58.1"(4)

16"(3)

24"(3)

8.5"(3)

23"(3)

60"(3)

11.5"(3)

18.1"(2)

18.5"(2)

9"(2)

37"(2)

44.5"(2)

48"(2)

22"(2)

28.8"(2)

8.3"(2)

52"(2)

56"(2)

9.4"(2)

18"(2)

54.5"(2)

57"(2)

36"(2)

33"(1)

2.5"(1)

29"(1)

53.1"(1)

3.1"(1)

8.8"(1)

11"(1)

53.3"(1)

11.3"(1)

7.5"(1)

58.8"(1)

12.5"(1)

28"(1)

14.5"(1)

20"(1)

1.7"(1)

2.6"(1)

62.5"(1)

15.5"(1)

 
Bristle Material

Polypropylene(19)

Nylon(8)

Palmyra(5)

Corn Fiber(4)

Plastic(4)

Tampico Fiber(4)

Synthetic Polypropylene(3)

Fiber(3)

Lamb's Wool(3)

MicroFiber(2)

Horsehair(2)

Polyvinyl Chloride (PVC)(2)

Synthetic Fiber(1)

Corn(1)

Natural Fiber(1)

Synthetic(1)

Polyethylene Terephthalate (PET)(1)

 
Product Type

Manual Broom(39)

Brush(35)

Duster(28)

Mop Handle(14)

Mop Frame(13)

Toilet Bowl Brush(10)

Upright Dust Pan(9)

Handle(8)

Sweeper(8)

Extension Pole(6)

Scope Dust Pan(6)

Dust Mop Refill(5)

Broom Handle(4)

Squeegee Handle(4)

Dust Pole(3)

Replacement Brush(2)

Toilet Cleaning System(2)

Dusting Wand(2)

Scrubber(2)

Dust Mop(1)

Dust Pan Set(1)

Scrubber Refill(1)

Accessory Kit(1)

 
Packaged Quantity

1 Each(97)

12 / Carton(41)

6 / Carton(40)

1 / Each(5)

10 / Carton(3)

4 / Carton(3)

5 / Carton(2)

150 / Carton(1)

1 / Kit(1)

24 / Carton(1)

8 / Carton(1)

1 Kit(1)

6 / Kit(1)

5 / Kit(1)

108 / Bundle(1)

3840 / Pallet(1)

1920 / Bundle(1)

216 / Pallet(1)

12 Carton(1)

 
Assembly Required

No(197)

Yes(6)

 
Product Model

Q560(2)

09570(1)

631000WE(1)

Q75500YL00(1)

Q850(1)

 
Product Line

HYGEN(7)

Maximizer(6)

ToiletWand(4)

SmartColor(4)

StarDuster(3)

REA-C-H(2)

MicroSwipe(2)

360° Dusters(2)

HiDuster(2)

Lobby Pro(1)

Invader(1)

ProAlu(1)

 
Handle Material

Plastic(12)

Metal(8)

Steel(7)

Wood(5)

Lacquered Wood(5)

Iron(4)

Vinyl(4)

Hardwood(1)

 
Handle Type

Telescopic(5)

Threaded(3)

Tapered(2)

Jaw(1)

 
Handle Color

Black(4)

White(2)

Red(1)

 
Handle Length

42"(3)

26"(3)

60"(3)

9"(3)

8"(2)

28"(2)

17"(2)

31"(2)

44.50"(2)

10"(2)

30"(2)

34"(2)

38"(2)

24"(2)

47"(2)

102"(2)

32"(1)

20"(1)

46"(1)

56"(1)

14.50"(1)

 
Head Width

36"(2)

17"(1)

8"(1)

9.50"(1)

10"(1)

 
Head Material

Metal(5)

Plastic(2)

MicroFiber(1)

 
Handle Diameter

1"(2)

1.25"(1)

3.50"(1)

0.66"(1)