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

Currently Filtered by

Category

Mop Heads

Refine Search

  GO
 
Brand

Rubbermaid Commercial(27)

Rubbermaid Commercial HYGEN(5)

Swiffer(5)

Scotch-Brite(1)

 
Warranty

Manufacturer's limited one-year warranty.(14)

Manufacturer's limited lifetime warranty.(1)

 
Special Features

5" Headband(3)

Extra Power-With the scrubbing power of Mr. Clean Magic Eraser.(2)

Large Shrinkless Mop Head(2)

Medium Shrinkless Mop Head(2)

Large Microfiber Mop Head(2)

Medium Microfiber Mop Head(2)

1" Headband(2)

 
Application

Floor Maintenance(24)

Floors(11)

Floors; Walls(1)

Window Cleaning(1)

Walls(1)

 
For Use With

Swiffer WetJet System(4)

Rubbermaid Commercial Invader Wet Mop Handles(4)

Maximizer 3-in-1 Floor Prep Tool(2)

Rubbermaid Commercial Pad Holders(2)

Scotch-Brite Microfiber Hardwood Floor Mop(1)

Swiffer Bissell SteamBoost Mop(1)

Rubbermaid Commercial HYGEN Clean Water System(1)

Rubbermaid Commercial HYGEN Quick-Connect Wet/Dry Frame(1)

Rubbermaid Commercial 2017161 Spill Mop Handle(1)

Maximizer Overhead Cleaning Tool(1)

Rubbermaid Commercial Gripper Wet Mop Handles(1)

Rubbermaid Steel Roller Sponge Mop(1)

Rubbermaid Commercial Microfiber Mopping System(1)

Rubbermaid Commercial Wall Washer Kits(1)

 
Manufacturer Part Number

M-005-R(1)

E238(1)

6436 YEL(1)

A21206WHICT(1)

A25206WHI(1)

A25206WHICT(1)

A413(1)

D253 BLU(1)

F21800(1)

2025502(1)

J15300YEL(1)

Q410 RED(1)

Q42600GR00(1)

Q438(1)

Q449(1)

Q820 BLU(1)

S299(1)

2025506(1)

2018825(1)

08443(1)

1924783(1)

08443CT(1)

81790(1)

81790CT(1)

85824(1)

1791678CT(1)

1822352(1)

1924782(1)

1924784(1)

2018786(1)

1924785(1)

1924812(1)

1924813(1)

1924814(1)

1924815(1)

2017059(1)

2018784(1)

V118(1)

 
Country of Origin

US(22)

CN(8)

ID(5)

CA(2)

KR(1)

 
Head Type

Wet Mop(12)

Microfiber(7)

Dust Mop(4)

Wet/Dry Pad(4)

Wet Mop Pad(3)

Looped-End(2)

Wet Pad(1)

Sponge(1)

Cut-End(1)

Dust(1)

 
Washable

Yes(24)

No(10)

 
Mop Head Size

Medium(7)

Large(6)

11.3" x 5.4"(4)

24 oz(3)

#20(2)

13 3/4w x 5 1/2d x 1/2h(1)

48" x 9"(1)

36"(1)

24w x 9d(1)

18 1/2" x 5 1/2" x 1/2"(1)

24 x 5(1)

17" Wide(1)

12" Wide(1)

11" x 5.25" x 0.188"(1)

2.625" x 1.375" x 0.5"(1)

2.63" x 1.38" x 0.25"(1)

18 in(1)

17 1/2"l x 12"w x 1/2"h(1)

10" x 9"(1)

9w x 5d(1)

 
Mop Head Material

Microfiber(13)

Cotton(5)

Blended(4)

Nonwoven Fiber(3)

Cotton/Synthetic(3)

Cotton/Synthetic Blend(3)

Cloth(2)

Polyester Fibers(2)

Cellulose Sponge(1)

Four-Ply Blended Yarn(1)

 
Mop Head Color

White(14)

Green(8)

Blue(8)

Yellow(3)

Gray(2)

White/Blue(1)

Orange/White(1)

Red(1)

 
Mop Head Style

Looped End(8)

Pad Refill(5)

Pad(4)

Cut End(3)

Microfiber Wet Room Pad(2)

Microfiber(1)

Cotton Mop(1)

Flat Wet Mop(1)

 
Headband Color

Green(5)

Black(4)

White(4)

Blue(3)

Red(1)

Yellow(1)

 
Headband Size

Large(4)

Medium(4)

1 in(4)

5"(2)

5 in(2)

1"(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved