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

Currently Filtered by

Category

Utility Cube Trucks

Refine Search

  GO
 
Brand

Rubbermaid Commercial(8)

 
Color

Black/Red(1)

 
Warranty

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

 
Special Features

Without Casters(1)

Door Kit(1)

For 8-Cubic Feet Trucks(1)

For 20-Cubic Feet Truck(1)

 
Application

Laundry Transport; Materials Handling; Waste Collection(3)

General Waste(1)

 
For Use With

Rubbermaid Commercial Xtra Carts(1)

Rubbermaid Commercial Utility Trucks(1)

Rubbermaid Commercial 4619, 4720(1)

 
Manufacturer Part Number

1064 BLA(1)

4094-L1 BLA(1)

4463BLA(1)

4608 BLA(1)

4609 BLA(1)

4614 BLA(1)

4617 BLA(1)

4619 BLA(1)

 
Country of Origin

US(8)

 
Height

49 1/8"(1)

28.13"(1)

20"(1)

32.5"(1)

8.5"(1)

36.5"(1)

 
Width

42 7/8"(1)

26"(1)

17 1/2"(1)

31"(1)

34"(1)

34.13"(1)

 
Depth

83 5/8"(1)

38"(1)

27 1/4"(1)

44.13"(1)

48.5"(1)

48"(1)

 
Color(s)

Black(6)

Black/Red(1)

 
Material(s)

Plastic(5)

Plastic; Steel Frame(1)

High Density Polyethylene(1)

Duramold Resin/Metal Composite(1)

 
Shape

Rectangular(3)

Rectangular Prism(3)

 
Capacity (Volume)

1 1/2 cu yd(1)

59 gal(1)

105 gal(1)

149 gal(1)

 
Capacity (Weight)

1,000 lbs.(1)

2,000 lbs.(1)

300 lbs(1)

500 lbs(1)

600 lbs(1)

 
Overall Width

24 1/4"(1)

 
Overall Depth

48"(1)

 
Caster/Glide/Wheel

Two 8" TPR Fixed-Position Casters; Two 8" TPR Swivel Casters(1)

 
Accessory Type

Door Kit with Lock(1)

 
Height Maximum

45"(1)

 
Opening Type

Top Door(3)

Open Top(1)

 
Shelf Count

1(1)

 
Waste Receptacle Type

Cube Truck(3)

Hopper(1)

 
Lid Type

Clamshell(3)

Hinged(1)

Clamshell Truck Lid(1)

 
Shelf Type

Fixed(1)

 
Handle Quantity

2(1)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved