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

Currently Filtered by

Category

Broom Heads

Refine Search

  GO
Brand

Boardwalk(21)

Rubbermaid Commercial(3)

Weiler(2)

Carlisle(1)

Country of Origin

LK(23)

CN(2)

US(1)

MX(1)

For Use With

Rubbermaid Commercial 6351, 6355(1)

Bristle Material

Polypropylene(11)

Palmyra Fiber(5)

Tampico Fiber(4)

Stiff Polypropylene(2)

Polystyrene(1)

Palmyra(1)

PET Plastic(1)

Tampico(1)

Polypropylene Fill(1)

Bristle Color

Black(8)

Gray(4)

Brown(3)

Maroon(3)

Natural(2)

Brown|A52A2A(1)

Green|008000(1)

Blue(1)

Green(1)

Red(1)

White(1)

Cream(1)

Bristle Length

3"(11)

3.25"(5)

2"(4)

2.5"(3)

6.25"(2)

4"(1)

8 1/2"(1)

Brush Length

24"(9)

36"(6)

18"(5)

10"(4)

16"(2)

10 1/2"(1)

Special Features

Hardwood Block-Stiff Polypropylene Bristles(4)

Black Tampico Floor Brush Head-For fine/medium sweep. Tampico fibers resist heat and chemicals.(3)

Hardwood Block-Palmyra Fiber Bristles(3)

Palmyra Fiber Floor Brush Head-Natural fiber for sweeping coarse/heavy debris.(2)

Gray Flagged Polypropylene Floor Brush Head-For fine sweep on smooth surfaces.(2)

Stiff Polypropylene Floor Brush Head-Maroon bristles for coarse/heavy sweep on rough surfaces.(2)

Fits 1-inch Diameter Handles(1)

Green Polystyrene Fine-Grade(1)

Hardwood Block-Tampico Fiber Bristles(1)

Maroon, Heavy Duty Brush, Hardwood Block-Stiff Polypropylene Bristles(1)

Black, Medium Weight, Hardwood Block-Stiff Polypropylene Bristles(1)

Hardwood Block-Flagged Polypropylene Bristles(1)

Green Flagged Recycled PET Plastic Floor Brush Heads-Superior rebound bristle memory allows broom to hold its shape. Wood block is made from reclaimed hardwood pieces finger-jointed together.(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved