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

Currently Filtered by

Category

Storage Cabinets

Refine Search

  GO
 
Brand

Tennsco(28)

HON(18)

Alera(16)

Iceberg(6)

Mayline(5)

basyx(4)

Bush(2)

FireKing(2)

ZOLL(1)

 
Color

Putty(21)

Black(19)

Light Gray(17)

Mahogany(4)

Gray Steel(4)

Charcoal(3)

Platinum(3)

Parchment(2)

Harvest(2)

Espresso(1)

Medium Cherry(1)

Graphite Gray; Hansen Cherry(1)

Natural Cherry; Graphite Gray(1)

Cognac(1)

Raven(1)

White(1)

 
Quantity

1 each(11)

 
Overall Width

36"(55)

48"(14)

34"(3)

30"(2)

29 1/2"(2)

33"(2)

72"(2)

37 1/2"(1)

17"(1)

 
Overall Depth

18"(26)

24"(21)

20"(9)

18 1/4"(8)

24 1/4"(4)

22"(4)

22 3/4"(3)

23 3/8"(2)

19 1/4"(2)

15"(1)

20 1/2"(1)

9 1/2"(1)

 
Manufacturer Part Number

CM4218BK(1)

MVLCDLGS(1)

1870BK(1)

1480PY(1)

1480LGY(1)

1480BK(1)

1470PY(1)

1470LGY(1)

1470BK(1)

MVLCCLGS(1)

1870PY(1)

MSCLGS(1)

MGDCLGS(1)

E5OPENSAHB(1)

92573(1)

92571(1)

92563(1)

92561(1)

1870LGY(1)

2470BK(1)

92551(1)

J2478SUPY(1)

JAN6618DHPY(1)

JAN6618DHBK(1)

J478NLGY(1)

J478NBK(1)

J24SNPY(1)

J24SNLGY(1)

J24SNBK(1)

J2478SULGY(1)

2470LGY(1)

J2478SUCPY(1)

J2478SUCLGY(1)

J2478SUCBK(1)

J2478SUBK(1)

J1878SUPY(1)

J1878SULGY(1)

J1878SUBK(1)

2470PY(1)

92553(1)

SC2472S(1)

CM4218LG(1)

CME4218PY(1)

C184236L(1)

WC72496A(1)

WC24496A(1)

VA61-3622MY(1)

VA61-3622MC(1)

VA613622ES(1)

CME7218PY(1)

CM7824PY(1)

C187236L(1)

CM7824LG(1)

CM7824BK(1)

CM7218PY(1)

CM7218LG(1)

CM7218BK(1)

CM6624PY(1)

CM6615PY(1)

CM4218PY(1)

C184236Q(1)

C187236Q(1)

SC2472Q(1)

SC1842Q(1)

SC2472P(1)

SC2472L(1)

SC1872S(1)

SC1872Q(1)

SC1872P(1)

SC1872L(1)

SC1842S(1)

SC1842P(1)

CF4436-D(1)

SC1842L(1)

94291NN(1)

107291NN(1)

107291CO(1)

107291CC(1)

105291NN(1)

105291CC(1)

CF7236-D(1)

80000855(1)

 
Country of Origin

US(75)

CN(7)

 
Material(s)

Industrial Grade Steel(29)

Heavy Gauge Steel(17)

Heavy Gauge Welded Steel(9)

Blow-Molded High-Density Polyethylene(6)

Steel(4)

Laminate(3)

MDF; Laminate(3)

Melamine(2)

100% Thermally Fused Laminate(2)

Laminate Wood(2)

MDF; Laminate; Glass; Steel(2)

Textured Woodgrain Laminate(1)

High-Pressure Laminate(1)

Metal(1)

 
For Use With

78" High Jumbo Cabinets, Box 2 of 2(2)

Medina Laminate Series(2)

MVLCDLGS(1)

MVLCCLGS(1)

When creating a high jumbo cabinet, use TNN-J478BK(1)

When creating a high jumbo cabinet, use Tennsco 78" High Jumbo Cabinets(1)

When creating a high jumbo cabinet, use TNN-J478PU(1)

ZOLL AED Plus(1)

 
Capacity (Volume)

18 2/5 cu. Ft.(2)

17 3/10 cu. Ft.(2)

27 1/2 cu. Ft.(2)

 
Capacity (Weight)

100 lbs.(2)

150 lbs.(2)

225 lbs.(2)

300 lbs.(1)

200 lbs.(1)

20 lbs.(1)

 
Caster/Glide/Wheel

Integrated Levelers(9)

Leveling Glides(3)

Glides(3)

Four 5" Casters (2 Locking)(1)

1 1/2" Adjustable Glides(1)

Four 1" Glides(1)

Six 1" Glides(1)

 
Edge Detail Profile

Beveled Edge(4)

3mm Protective Edge Banding(3)

Rounded Corner; Waterfall Edge(3)

PVC Protective Edgebanding(2)

Straight Edge(2)

Square Edge(2)

Traditional Edge Detail(1)

Square Corner(1)

Square(1)

 
Top Thickness

1"(7)

1 1/8"(5)

1 11/16"(2)

1/8"(1)

 
Shelf Count

4(34)

2(16)

5(11)

1(10)

3(5)

4, 3 Adjustable(1)

 
Door Quantity

2(75)

4(1)

1(1)

 
Shelf Capacity (Weight)

250 lbs.(12)

150 lbs.(9)

200 lbs.(4)

180 lbs.(4)

75 lbs.(4)

125 lbs.(4)

65 lbs.(3)

Top Shelf, 400 lbs.; Side Shelves, 50 lbs.(3)

50 lbs.(2)

 
Compartment Quantity

1(3)

2(2)

4(2)

 
Overall Height

78"(23)

72"(15)

29 1/2"(12)

71 3/4"(8)

42"(4)

66"(4)

41 3/4"(4)

29 7/8"(2)

42 3/4"(2)

46"(2)

64"(2)

44"(1)

21 3/4"(1)

39 1/4"(1)

17"(1)

 
 
 

© 2019-2020 gemlaser, Inc., All Rights Reserved