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

Currently Filtered by

Category

Scouring Pads And Sticks

Refine Search
  GO
 
Brand

Scotch-Brite(23)

Scotch-Brite PROFESSIONAL(18)

GMT(11)

Mr. Clean(11)

Boardwalk(10)

3M(8)

AbilityOne(8)

S.O.S.(5)

Continental(2)

Dawn(2)

Brillo(2)

AmerCareRoyal(2)

Disco(1)

Coastwide Professional(1)

Big Boss II(1)

Pumie(1)

 
Size

4.63" x 10"(3)

6" x 1" x 12"(1)

 
Recycled

No(1)

 
Packaged Quantity

16 / Pack(1)

 
Assembly Required

No(1)

 
For Use With

3M 6472(5)

Threaded-Tip Mop Handles; 3M Doodlebug Pads(2)

3M MCO 05241(1)

3M MCO 08004(1)

Threaded U.S. Broom Handle(1)

Household cleaning(1)

Scotch-Brite MCO 223(1)

Scotch-Brite Multi-Purpose Pad Holder 405-R; 3M Twist Lok Pad Holder 961(1)

Scotch-Brite 481-7-RSC(1)

Scotch-Brite Dishwands(1)

Scotch-Brite 65012(1)

Acme Threaded Handles(1)

 
Country of Origin

US(51)

CA(23)

MX(22)

CN(7)

KR(1)

DE(1)

United States(1)

 
Height

4.5"(6)

6.1"(5)

2.4"(5)

6.25"(3)

2.6"(3)

2.3"(3)

6"(2)

2.7"(2)

3.3"(2)

4.6"(2)

3.5"(1)

4.7"(1)

3.7"(1)

 
Width

4.6"(8)

3.6"(6)

2.5"(3)

2.8"(3)

4.4"(3)

3.5"(2)

4.5"(2)

2.6"(2)

2.3"(2)

3.38"(1)

3.13"(1)

3.2"(1)

3.25"(1)

2.75"(1)

 
Color(s)

White(19)

Yellow/Green(14)

Green(13)

Blue(12)

Steel Gray(11)

Orange(3)

Gray(3)

Blue/Teal(2)

Black(2)

Maroon(2)

Yellow/White(2)

Dark Blue/Light Blue(2)

Steel(2)

Silver(2)

Brown(2)

Dark Blue(2)

Charcoal/Pink(2)

Copper(1)

Blue/White(1)

Purple(1)

Red/Black(1)

Green/Yellow(1)

Light Blue/Purple(1)

Gray/White(1)

Stainless Steel(1)

Gray/Silver(1)

Yellow(1)

 
Material(s)

Steel Wool(15)

Fiber; Mineral; Resin(10)

Foam(10)

Synthetic Fiber(7)

Cellulose; Fiber; Mineral; Resin(6)

Cellulose(5)

Nylon(4)

Cellulose; Laminate(4)

Fiber(3)

Plastic(3)

Cellulose; Scrim(3)

Stainless Steel(3)

Nylon/Polyester Blend(3)

Cellulose; Scouring Pad(2)

Cellulose; Synthetic Fiber(2)

Recycled Polyethylene Terephthalate; Cellulose(2)

Steel Mesh(1)

Poly Mesh(1)

Abrasives; Resin; Synthetic Fiber(1)

Plastic; Polyester(1)

Rayon(1)

Nylon; Synthetic(1)

Cellouse(1)

Recycled Polyethylene Terephthalate; Cotton Cloth(1)

Polymeric Foam/Urethane(1)

Celluose(1)

Plastic; Synthetic Fiber; Urethane(1)

Cellulose; Plastic(1)

Fiber; Mineral; Plastic; Resin(1)

Coiled Synthetic Fiber(1)

Resin; Mineral; Fiber(1)

Polypropylene(1)

Copper Coated Metal(1)

Non-Woven Nylon/Polyester Fiber(1)

Nylon; Polyester(1)

Nylon Fibers; Polyester Fibers(1)

Pumice(1)

 
Shape

Rectangular(12)

Rectangle(6)

Wavy Rectangle(6)

Round(3)

Wave(3)

Parallelogram(2)

Bow Tie(2)

Bowtie(2)

Hexagonal(1)

 
Thickness

0.7"(15)

1"(5)

0.6"(4)

0.9"(3)

0.8"(3)

0.75"(2)

0.88"(2)

0.85"(1)

 
Scouring Pads/Sticks Type

Pad(59)

Dishwand(2)

Dishwand Refill Pad(1)

Stick(1)

 
Size (W x L)

6" x 9"(11)

4.63" x 10"(4)

10" x 4.63"(3)

3.5" x 5"(3)

3.8" x 6"(2)

4" x 4"(2)

2.5" x 9.5"(2)

2.8" x 4.5" x 1.2"(2)

4" x 5.25"(2)

2 1/2" x 2 3/4"(1)

5" x 5.75"(1)

3.93" x 1.96"(1)

3.5" x 5.5"(1)

4" dia x 1.75"h(1)

4" x 6"(1)

6" x 9.25"(1)

4" x 5.5"(1)

2.4 x 3(1)

2.5" x 2.75"(1)

3" x 6"(1)

4" x 6" x 3"(1)

3" x 4.5"(1)

2.9" x 2.2"(1)

4.45" x 3.85"(1)

5.75" x 5"(1)

1.25" x 5"(1)

 
Sponge Type

Scrub Sponge(22)

Scrub Pad(14)

Cleaning(2)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander