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

Currently Filtered by

Category

Recycling Containers And Lids

Refine Search

  GO
 
Brand

Rubbermaid Commercial(25)

 
Color

Blue(3)

Silver Metallic(2)

Green(1)

Yellow(1)

 
Recycled

No(7)

 
Packaged Quantity

1(7)

 
Limited Warranty

1 Year(2)

 
Weight (Approximate)

9.88 lb(1)

 
Warranty

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

 
Special Features

Universal Recycling Symbol(2)

Slot Opening For Paper(1)

Two-Stream Glutton Recycling Station-One Glutton container, two Slim Jim receptacles, one lid frame, three restrictive-opening tops (circle, slot and square) and one label pack.(1)

For 20-Gallon Containers(1)

Recycling Unit with Plastic Liner(1)

 
Application

Indoor Recycling(4)

Recycling(3)

Indoor All-Purpose Waste Disposal; Recycling Paper(1)

Outdoor All-Purpose Waste Disposal(1)

Indoor All-Purpose Waste Disposal(1)

 
For Use With

Rubbermaid Commercial 32-Gallon Round Brute Containers(1)

Rubbermaid Commercial 20 Gallon Round Brute Containers(1)

Rubbermaid Commercial 2643 Containers(1)

Rubbermaid Commercial Wastebaskets(1)

 
Diameter

19.88"(1)

24"(1)

24.81"(1)

20.156"(1)

20.16"(1)

 
Opening Size

5 1/2" Diameter(1)

8.5" dia.(1)

 
Manufacturer Part Number

1788378(1)

571473GRE(1)

RSW4(1)

RSW3(1)

RSW1(1)

DRR24TSM(1)

DRR24CSS(1)

DCR24TSM(1)

DCR24CSM(1)

9W27YEL(1)

9W27 BLU(1)

9W27-73 BLU(1)

3959-73 BLU(1)

1792340(1)

395873BLU(1)

3540-74 BLU(1)

3536-73 BLU(1)

2950-73 BLA(1)

2647-88 GRA(1)

264307BLU(1)

2620-73 BLU(1)

2619-60 GRA(1)

2570-88 BRO(1)

256B-73 BLU(1)

RSW5(1)

 
Country of Origin

US(18)

United States(7)

 
Material

Polyethylene(2)

Plastic(2)

Steel(2)

Metal(1)

 
Height

32.2"(2)

36.5"(2)

22 3/10"(1)

30"(1)

31 1/4"(1)

14.8"(1)

34.25"(1)

6.3"(1)

28 3/4 in(1)

35.5"(1)

11.5"(1)

12.63"(1)

31.5"(1)

1"(1)

39.75"(1)

31.13"(1)

30.88"(1)

 
Width

18.4"(2)

9 4/5"(1)

26.8"(1)

25.5"(1)

12.25"(1)

7.25"(1)

23 1/2"(1)

11"(1)

20.1"(1)

19.5"(1)

21"(1)

28.5"(1)

23.38"(1)

20.16"(1)

 
Depth

18.4"(2)

22 9/10"(1)

23.6"(1)

22.75"(1)

12.25"(1)

10.6"(1)

23 1/2"(1)

20"(1)

19.5"(1)

16"(1)

23"(1)

28.5"(1)

20.16"(1)

 
Color(s)

Blue(7)

Gray(2)

Silver Metallic(2)

Green(1)

Brown(1)

Black(1)

 
Material(s)

Plastic(10)

Paper(4)

Steel(2)

Plastic; Steel(1)

Molded Plastic(1)

 
Shape

Rectangular Prism(6)

Rectangular(5)

Round(4)

Square(4)

Pyramid(1)

Circle(1)

Round Cylinder(1)

 
Capacity (Volume)

50 gal(3)

26 gal(2)

46 gal(1)

56 gal(1)

1 gal(1)

40.000 gal(1)

23 gal(1)

 
Finish

Matte(4)

Smooth Molded Plastic(1)

Stainless Steel(1)

Powder Coated(1)

 
Capacity

29 gal(2)

20 gal(1)

44 gal(1)

35 gal(1)

14 gal(1)

50 gal(1)

 
Sheets Per Unit

1(4)

 
Opening Type

Open Top(5)

Top Door(2)

Top Paper Slot; Top Landfill Hole(1)

Top Hole(1)

 
Waste Receptacle Type

Indoor Recycling Bin(4)

Recycling Container(1)

Recycling Rectangle, Open Top(1)

Outdoor Recycling Bin(1)

Outdoor All-Purpose Waste Bin(1)

Open Top(1)

Indoor All-Purpose Waste Bin(1)

 
Label Size - text

12 x 1(3)

14 x 1(1)

 
Adhesive

Permanent(4)

 
Label Color(s)

Clear(4)

 
Lid Type

Clamshell(2)

Slotted(1)

Clamshell w/Top Slot & Hole(1)

Flat-Top Lid(1)

Dome Top w/Push Door(1)

Hinged(1)

Funnel w/Top Hole(1)

 
Labels Per Unit

1(4)

 
Handle

Side(1)

Full-Width Molded(1)

 
Printed Text Color(s)

White(4)

 
Labels Per Sheet

1(4)

 
Printed Text

Glass Only(1)

Plastic Only(1)

Trash Only(1)

Paper Only(1)

 
Liner Material

Plastic(2)

Galvanized Steel(1)

 
Sheet (W x L)

14 x 2(3)

16 x 2(1)

 
Design

Block-Letter(4)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved