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

Currently Filtered by

Category

Hooded Top Metal

Refine Search

  GO
 
Brand

Rubbermaid Commercial(21)

 
Warranty

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

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

 
Special Features

For Rubbermaid Commercial Landmark Series 35-Gallon Classic Containers(3)

For Rubbermaid Commercial Landmark Series 50-Gallon Classic Containers(2)

Two Hinged Doors(1)

Nonmagnetic Stainless Steel Receptacle(1)

Four Openings(1)

Side Opening Style(1)

Hinged Push Door(1)

Two Swinging Doors(1)

 
Application

General Waste(4)

Outdoor All-Purpose Waste Disposal(3)

Indoor All-Purpose Waste Disposal(3)

Tobacco Product Waste Collection; Outdoor All-Purpose Waste Disposal(1)

Indoor/Outdoor All-Purpose Waste Disposal(1)

 
For Use With

Rubbermaid Commercial Landmark Series 35-Gallon Classic Containers(3)

Rubbermaid Commercial Waste Drums(2)

Rubbermaid Commercial Landmark Series 50-Gallon Classic Containers(2)

Rubbermaid Commercial Landmark Series Containers FG3970/FG3975(1)

Rubbermaid Commercial Glutton Containers(1)

 
Diameter

15"(2)

13"(1)

20 in(1)

24.5"(1)

 
Opening Size

5 1/2" dia.(1)

13" dia.(1)

18 5/8" x 6 1/8"(1)

 
Manufacturer Part Number

9175BEI(1)

9173-88 BEI(1)

9171-88 BLA(1)

8430-88 BRO(1)

H1NBLK(1)

R32EGLBK(1)

T1940SSRB(1)

T1424SSRB(1)

SO16SUEGL(1)

4004 RIV(1)

4004 COR(1)

3964 DGR(1)

256V BRO(1)

256B BRO(1)

2030BLK(1)

3975-L1 SAB(1)

3975 SAB(1)

4003 RIV(1)

4003 COR(1)

4003 BRO(1)

1855 BLA(1)

 
Country of Origin

US(14)

CN(7)

 
Height

27 9/10"(2)

41.5"(2)

49 1/4"(1)

41"(1)

25"(1)

32"(1)

38 in(1)

35 1/2 in(1)

28"(1)

20.7"(1)

20 7/10"(1)

13"(1)

31.13"(1)

10"(1)

42.13"(1)

11 1/4"(1)

27.9"(1)

46.5"(1)

12.25"(1)

 
Width

24.88"(2)

15 7/10"(2)

26"(2)

19"(1)

24 7/8"(1)

13"(1)

14"(1)

21 1/2"(1)

34 3/10"(1)

23"(1)

24.75"(1)

15.7"(1)

25.5"(1)

34.3"(1)

 
Depth

26"(2)

24.88"(2)

13"(1)

14"(1)

19"(1)

39 3/4"(1)

21 1/2"(1)

26.63"(1)

25.25"(1)

22.75"(1)

 
Color(s)

Black(5)

Brown(3)

River Rock(2)

Beige(2)

Coral(2)

Sable(2)

Stainless Steel(2)

Almond(1)

Brown Stone(1)

Dark Green(1)

 
Material(s)

Steel(6)

Stone(5)

Plastic(4)

Structural Foam(4)

Nonmagnetic Steel(1)

Polycarbonate(1)

 
Shape

Rectangular Prism(5)

Square(4)

Round Cylinder(3)

Round(2)

Rectangular(1)

Domed Square(1)

 
Capacity (Volume)

45 gal(2)

50 gal(2)

24.000 gal(1)

12 gal(1)

40.000 gal(1)

15 gal(1)

65 gal(1)

35.000 gal(1)

56 gal(1)

10 gal(1)

 
Thickness

0.38"(5)

 
Finish

Black(2)

Powder Coated(1)

Textured Sable(1)

Baked Enamel(1)

 
Opening Type

Open Top(2)

Open Side(2)

Side Door(2)

Ashtray Top w/Open Side(1)

Two Side Push Doors(1)

Top Hole(1)

 
Mounting

Slip-in(5)

 
Waste Receptacle Type

Indoor All-Purpose Waste Bin(3)

Outdoor All-Purpose Waste Bin(3)

Swing Top(2)

Ashtray Waste Bin(1)

Push Door(1)

Indoor/Outdoor All-Purpose Waste Bin(1)

Side Opening(1)

 
Lid Type

Hinged(2)

Dome Top w/Push Door(2)

Integrated Top(2)

Swing(2)

Clamshell Hood w/Open Side(1)

Dome w/Top Hole(1)

Hood w/Open Side(1)

Hood Top(1)

Dome(1)

Clamshell Hood w/Side Door(1)

 
Opening Size (w x h)

15.5" x 7.5"(1)

18 5/8" x 6 1/8"(1)

 
Liner Material

Leakproof Rigid Plastic(2)

Galvanized Steel(1)

Galvanized Metal(1)

Metal(1)

 
Design

Natural Rock Aggregate(5)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved