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

Currently Filtered by

Category

Brooms

Refine Search

  GO
Brand

Boardwalk(27)

Rubbermaid Commercial(17)

Magnolia Brush(4)

AbilityOne(4)

O-Cedar Commercial(3)

Weiler(2)

Quickie(2)

Libman Commercial(2)

Mr. Clean(2)

BLACK+DECKER(2)

Franklin Cleaning Technology(1)

Butler(1)

Anchor Brand(1)

Scotch-Brite(1)

Color(s)

Black(8)

Yellow/Black(6)

Yellow(5)

Natural(4)

Black/Yellow(4)

White(3)

Gray/Natural(2)

Black/Gray(2)

Natural/Black(2)

Orange/Black(2)

Red Handle(2)

Yellow/Black|FFFF00(1)

Brown(1)

Blue(1)

Yellow/Light Brown(1)

Gray Bristles(1)

Yellow Handle;Gray Bristles(1)

Blue;Yellow(1)

Green/Gray(1)

Straw/Red(1)

White/Silver|FFFFFF(1)

White/Gray/Green(1)

Brown|A52A2A(1)

White|FFFFFF(1)

Black/Natural(1)

Country of Origin

MX(34)

CN(19)

US(14)

IT(1)

LK(1)

For Use With

7920-00-141-5452; 7920-00-177-5106; 7920-01-512-4961(1)

Base Material

Polypropylene(4)

Vinyl-Coated Steel(1)

Bristle Material

Polypropylene(13)

Corn Fiber(12)

Plastic(7)

Corn(6)

PET(5)

Yucca/Corn Fibers(4)

PVC(2)

Rubber Blades(2)

Polyethylene Terephthalate (PET)(2)

Mixed Fibers(2)

Corn/Synthetic Fibers(2)

Synthetic(1)

Nylon Bristle(1)

Boar;Nylon(1)

Flagged Plastic(1)

Corn/Rattan(1)

Synthetic Polypropylene(1)

Straw(1)

Broom Corn/Yucca(1)

Tempico(1)

Palmyra(1)

Poly Fibers(1)

Bristle Length

3"(5)

12"(5)

18"(4)

14"(2)

6 1/2"(2)

6 3/4"(1)

18 1/2"(1)

7 1/2" - 6"(1)

2"(1)

13 5/8"(1)

10"(1)

5 1/4"(1)

7 1/2"(1)

6"(1)

10 1/2"(1)

13'(1)

7"(1)

17"(1)

5 1/2"(1)

16 1/2"(1)

8"(1)

9"(1)

5"(1)

15"(1)

16.5"(1)

16"(1)

4.25"(1)

Brush Length

10"(3)

18"(3)

7"(2)

7 1/2"(2)

10.5"(2)

12"(2)

13"(2)

36"(2)

16"(2)

24"(2)

7.5"(1)

8"(1)

6 7/16"(1)

17.5"(1)

Cleaning Path

13.5"(1)

Handle Material

Wood(26)

Metal(12)

Steel(8)

Hardwood(3)

Lacquered Pine(3)

Vinyl Coated Metal(2)

Clear Lacquered Wood(2)

Vinyl Coated Aluminum(2)

Galvanized Steel;Plastic(1)

Aluminum(1)

Steel/Plastic(1)

Plastic(1)

Lacquered Wood(1)

Vinyl-Coated Steel(1)

Powder Coated Steel(1)

Fiberglass(1)

Overall Length

56"(8)

54"(6)

55"(5)

58 1/8"(4)

46"(4)

53"(4)

51"(3)

60"(3)

39"(2)

44"(2)

38"(2)

48.78"(1)

57"(1)

63 3/4"(1)

46.78"(1)

62"(1)

37 1/2"(1)

35"(1)

30"(1)

44 1/2"(1)

40.5"(1)

55.5"(1)

57"-58.5"(1)

56 "(1)

42"(1)

55 3/8"(1)

37"-38"(1)

10"(1)

63"(1)

55 1/2"(1)

36"(1)

53.5"(1)

16"(1)

Handle Length

42"(5)

58 1/8"(4)

28"(1)

44 1/2"(1)

46"(1)

38"(1)

Handle Diameter

1"(16)

15/16"(8)

0.88"(8)

1.13"(6)

0.94"(3)

3/4"(3)

1 1/8"(2)

1 1/2"(2)

0.75"(2)

2"(1)

7/8"(1)

13/16"(1)

Application

Floors(16)

Concrete; Hard Floor; Indoor; Outdoor(11)

Concrete(8)

Floor(5)

Floors; General Purpose(5)

Spot(3)

Traditional Angled Broom(3)

Traditional Corn/Synthetic Broom(3)

Bare Floors;Low Pile Carpets(2)

General Purpose(2)

Counters; Floors(2)

Push Broom(1)

Carpet Sweeper(1)

Bare Floors;Indoor;Outdoor;Warehouse(1)

Multi Surface Floors(1)

Streets(1)

Carpet;Concrete;Hard Floor;Tiles;Woodwork(1)

Whisk(1)

Hard Floor; Low Pile Carpet(1)

Concrete; Gravel; Packed Dirt; Stone; Streets; Sub Flooring(1)

Brush Type

Flagged(2)

Upright(1)

Unflagged(1)

Street(1)

Special Features

Yucca/Corn Fibers(4)

Corn Fiber(4)

Polypropylene Bristles(2)

PVC Bristles(2)

Warehouse Corn-Fill Broom(1)

Aluminum Handle(1)

Vinyl Coated Metal Handle(1)

Lobby Corn-Fill Broom(1)

18" Wide Broom Head(1)

For Heavy Debris(1)

24" Handle(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved