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','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 '%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(18)

 
Color

Black(1)

 
Recycled

No(1)

 
Packaged Quantity

1(1)

 
Warranty

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

 
Special Features

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

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

Side Opening Style(1)

Four Openings(1)

Two Hinged Doors(1)

Nonmagnetic Stainless Steel Receptacle(1)

 
Application

General Waste(5)

Indoor All-Purpose Waste Disposal(3)

Outdoor All-Purpose Waste Disposal(1)

 
For Use With

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

Rubbermaid Commercial 3970, 3970-01, 3970-88, 3971, 3972(2)

Rubbermaid Commercial H55, H55C, H55E, MT32, SBR52(1)

Rubbermaid Commercial Glutton Containers(1)

Rubbermaid Commercial Landmark Series Containers FG3970/FG3975(1)

Rubbermaid Commercial 4004 Aggregate Panel(1)

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

 
Diameter

24.5"(1)

15"(1)

 
Opening Size

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

 
Manufacturer Part Number

1855 BLA(1)

4004 RIV(1)

T1424SSRB(1)

R32EGLBK(1)

9175BEI(1)

9173-88 BEI(1)

917188BLA(1)

8430-88 BRO(1)

4004 COR(1)

256B BRO(1)

4003 RIV(1)

4003 COR(1)

4003 BRO(1)

3975 SAB(1)

3975-L1 SAB(1)

3964 DGR(1)

256V BRO(1)

T1940SSRB(1)

 
Country of Origin

US(11)

CN(6)

United States(1)

 
Height

41"(2)

27 9/10"(2)

12.25"(1)

31.13"(1)

13"(1)

42 1/8"(1)

11 1/4"(1)

46.5"(1)

27.9"(1)

20 7/10"(1)

20.7"(1)

41.5"(1)

49 1/4"(1)

32"(1)

35 1/2 in(1)

38 in(1)

 
Width

26"(2)

15 7/10"(2)

25.5"(1)

23"(1)

24 3/4"(1)

15.7"(1)

34 3/10"(1)

34.3"(1)

21 1/2"(1)

21.5"(1)

24.88"(1)

24 7/8"(1)

14"(1)

19"(1)

 
Depth

26"(2)

22.75"(1)

26.63"(1)

25 1/4"(1)

21 1/2"(1)

21.5"(1)

24.88"(1)

39 3/4"(1)

14"(1)

19"(1)

 
Color(s)

Brown(3)

Black(2)

Sable(2)

Coral(2)

River Rock(2)

Beige(2)

Stainless Steel(2)

Dark Green(1)

Brown Stone(1)

 
Material(s)

Stone(5)

Plastic(4)

Steel(3)

Structural Foam(3)

Polycarbonate(1)

Nonmagnetic Steel(1)

 
Shape

Square(4)

Rectangular Prism(3)

Rectangular(2)

Round(1)

Domed Square(1)

Round Cylinder(1)

 
Capacity (Volume)

50 gal(2)

56 gal(1)

35.000 gal(1)

45 gal(1)

65 gal(1)

15 gal(1)

24.000 gal(1)

40.000 gal(1)

 
Thickness

0.38"(5)

 
Finish

Textured Sable(1)

Black(1)

Powder Coated(1)

 
Capacity

45 gal(1)

 
Opening Type

Open Side(2)

Open Top(1)

Two Side Push Doors(1)

Top Hole(1)

 
Mounting

Slip-in(5)

 
Waste Receptacle Type

Indoor All-Purpose Waste Bin(3)

Side Opening(2)

Swing Top(2)

Outdoor All-Purpose Waste Bin(1)

Push Door(1)

 
Lid Type

Hinged(2)

Swing(2)

Dome Top w/Push Door(1)

Hood Top(1)

Dome(1)

Hood w/Open Side(1)

Clamshell Hood w/Open Side(1)

Dome w/Top Hole(1)

 
Opening Size (w x h)

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

15.5" x 7.5"(1)

 
Liner Material

Leakproof Rigid Plastic(2)

Galvanized Metal(1)

 
Design

Natural Rock Aggregate(5)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved