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

Currently Filtered by

Category

Storage Cabinets

Refine Search

  GO
Brand

HON(44)

Tennsco(34)

Alera(23)

Alera Plus(18)

Mayline(12)

basyx(7)

Safco(6)

Iceberg(6)

JUSTRITE(4)

Bush(2)

FireKing(2)

Rubbermaid(2)

ZOLL(1)

Linea Italia(1)

Color

Putty(25)

Light Gray(24)

Black(21)

Mahogany(11)

Mocha(9)

Cherry(7)

Natural Maple(6)

Espresso(6)

Yellow(4)

Cherry/Granite Nebula(4)

Columbian Walnut(4)

Espresso/White(4)

Brilliant White(4)

Gray/Granite Nebula(4)

Gray Steel(4)

Medium Cherry(3)

Charcoal(3)

Platinum(3)

Gray/Black(2)

Parchment(2)

Gray(2)

Harvest(2)

Sierra Cherry(1)

White(1)

Modern Walnut(1)

Graphite Gray; Hansen Cherry(1)

Cognac(1)

Natural Cherry; Graphite Gray(1)

Bourbon Cherry(1)

Raven(1)

Quantity

1 each(35)

Overall Width

36"(85)

48"(15)

18"(15)

29 3/4"(6)

72"(6)

29 1/2"(6)

34"(4)

24"(4)

30"(3)

14 3/4"(3)

19"(3)

43"(2)

17"(2)

54"(2)

33"(2)

90"(2)

37 1/2"(1)

34 1/2"(1)

Overall Depth

24"(48)

18"(34)

20"(11)

24 3/4"(9)

25"(8)

18 1/4"(8)

11 3/4"(6)

14"(5)

22"(4)

24 1/4"(4)

19 1/8"(4)

22 3/4"(3)

14 3/16"(3)

19 5/8"(3)

19"(2)

19 1/4"(2)

23 3/8"(2)

9 1/2"(1)

18 7/8"(1)

20 1/2"(1)

15"(1)

17"(1)

34"(1)

Manufacturer Part Number

APST1LCR(1)

APST1LDC(1)

APST2LCR(1)

APST2LDC(1)

TR757MOC(1)

896000(1)

890400(1)

893000(1)

894500(1)

E5OPENSAHB(1)

MGDCLGS(1)

VLCCMAH(1)

7083(1)

7085(1)

VLCCCRY(1)

MWD3624ESP(1)

MSCLGS(1)

MVLCCLGS(1)

MVLCDLGS(1)

92573(1)

92571(1)

SC1842S(1)

SC1872L(1)

SC1872P(1)

SC1842Q(1)

SC1842P(1)

HPHC2D36D(1)

HPHC2D36MO(1)

SC1842L(1)

SC1872Q(1)

SC1872S(1)

92553(1)

92561(1)

92563(1)

92551(1)

SC2472S(1)

SC2472L(1)

SC2472P(1)

SC2472Q(1)

9442CY(1)

9442MH(1)

J2478SUCLGY(1)

J2478SUCPY(1)

J2478SULGY(1)

J2478SUPY(1)

J2478SUCBK(1)

J2478SUBK(1)

J1878SUBK(1)

J1878SULGY(1)

J1878SUPY(1)

J24SNBK(1)

J24SNLGY(1)

JAN6618DHLGY(1)

JAN6618DHPY(1)

80000855(1)

JAN6618DHBK(1)

J478NPY(1)

J24SNPY(1)

J478NBK(1)

J478NLGY(1)

7824PY(1)

2470PY(1)

1470LGY(1)

1470PY(1)

1480BK(1)

1470BK(1)

9444MH(1)

9443CY(1)

9443MH(1)

9444CY(1)

1480LGY(1)

1480PY(1)

1870PY(1)

2470BK(1)

2470LGY(1)

1870LGY(1)

1870BK(1)

1824BK(1)

1824LGY(1)

1824PY(1)

HPHC1D18Z(1)

HPHC1D18MO(1)

CM7818BK(1)

CM7818LG(1)

CM7818PY(1)

CM7824BK(1)

CM7218PY(1)

CM7218LG(1)

CM6615PY(1)

CM6624PY(1)

CM7218BK(1)

CM7824LG(1)

CM7824PY(1)

LS593020WA(1)

VA613622ES(1)

VA61-3622MC(1)

LS593020MY(1)

LS593020MC(1)

CME4218PY(1)

CME7218PY(1)

LS593020ES(1)

CM4218PY(1)

CM4218LG(1)

BR104CY(1)

BR104ES(1)

BR104GY(1)

BR103GY(1)

BR103ES(1)

BR102ES(1)

BR102GY(1)

BR103CY(1)

BR105CY(1)

BR105ES(1)

BR202ES(1)

BR202GY(1)

CM4218BK(1)

BR202CY(1)

BR181GY(1)

BR105GY(1)

BR181CY(1)

BR181ES(1)

VA61-3622MY(1)

WC24496A(1)

HPBC2D2D36MO(1)

HPBC4D18D(1)

HPBC4D18MO(1)

HPBC2D2D36D(1)

HPBC1F1D18Z(1)

HPBC1D1D18Z(1)

HPBC1F1D18D(1)

HPBC1F1D18MO(1)

HPBC4D18Z(1)

HPCT36Q(1)

HPCT90Q(1)

HPCT90W(1)

HPHC1D18D(1)

HPCT72W(1)

HPCT72Q(1)

HPCT36W(1)

HPCT54Q(1)

HPCT54W(1)

HPBC1D1D18MO(1)

HPBC1D1D18D(1)

C184236Q(1)

C187236L(1)

C187236Q(1)

C184236L(1)

BLPWCNN(1)

WC72496A(1)

BLPWCA1A1(1)

BLPWCESES(1)

CF4436-D(1)

CF7236-D(1)

115291ACHH(1)

115291AFNN(1)

94291NN(1)

107291NN(1)

107291CO(1)

105291CC(1)

105291NN(1)

107291CC(1)

BR102CY(1)

Country of Origin

US(139)

CN(18)

TH(4)

MX(1)

Material(s)

Industrial Grade Steel(32)

Heavy Gauge Steel(19)

Melamine(18)

Thermofused Melamine/Laminate(9)

Heavy Gauge Welded Steel(9)

High-Pressure Laminate(9)

Steel(8)

Laminated Compressed Wood(6)

Blow-Molded High-Density Polyethylene(6)

18-Gauge Steel(4)

Woodgrain Laminate(4)

Thermally Fused Laminate(4)

Laminate Wood(4)

Laminate(4)

Thermofused Melamine(3)

Thermal Fused Laminate(3)

MDF; Laminate(3)

Plastic(2)

MDF; Laminate; Glass; Steel(2)

Hardwood Veneer(2)

100% Thermally Fused Laminate(2)

Metal(1)

Walnut Veneer(1)

Textured Woodgrain Laminate(1)

For Use With

Alera Plus Hospitality Wall Cabinet(15)

HON Hospitality Cabinet Modular Countertop(11)

HON Modular Hospitality Single Base Cabinets; HON Modular Hospitality Double Base Cabinets(8)

Alera Open Office Desk Series; Alera Valencia Series; Alera Sedina Series; Alera Cushions(4)

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

basyx BL Laminate Series(3)

HON Modular Hospitality Single Base Cabinets(3)

Alera Plus Hospitality Base Cabinet(3)

Medina Laminate Series(2)

Mayline Glass Doors for Low Wall Cabinet; Mayline Wood Doors for Low Wall Cabinet.; To complete the wall cabinet, you must order the cabinet and the doors.(2)

Mayline Aberdeen Personal Storage Tower (Box 1 of 2) Both pieces MUST be ordered to make this unit complete.(2)

Mayline Aberdeen Personal Storage Tower (Box 2 of 2) Both pieces MUST be ordered to make this unit complete.(2)

HON Modular Hospitality Double Base Cabinets(2)

ZOLL AED Plus(1)

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

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

Linea Italia Trento Line(1)

MVLCDLGS(1)

MVLCCLGS(1)

Mayline Mira Series Lateral File(1)

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

Capacity (Volume)

18 2/5 cu. Ft.(2)

27 1/2 cu. Ft.(2)

17 3/10 cu. Ft.(2)

202 gal(1)

101 gal(1)

60 gal(1)

30 gal(1)

4 gal(1)

45 gal(1)

Capacity (Weight)

300 lbs.(4)

Supports up to 250 lbs.(4)

130 lbs.(3)

225 lbs.(3)

135 lbs.(3)

150 lbs.(2)

100 lbs.(2)

20 lbs.(1)

336 lbs.(1)

690 lbs.(1)

200 lbs.(1)

Caster/Glide/Wheel

Leveling Glides(42)

Integrated Levelers(9)

Glides(5)

Six 1" Glides(1)

1 1/2" Adjustable Glides(1)

Four 5" Casters (2 Locking)(1)

Four 1" Glides(1)

Edge Detail Profile

Square Edgeband(27)

Square Edge(12)

Radius Edge(9)

3mm Protective Edge Banding(7)

4mm Fluted PVC Edge Detailing(4)

Square Cabinet Corners; Rounded Door Corners(4)

Beveled Edge(4)

Rounded Corner; Waterfall Edge(3)

Rounded Corner(2)

Ribbon Edge(2)

PVC Protective Edgebanding(2)

Straight Edge(2)

Square(1)

Square Corner(1)

Traditional Edge Detail(1)

Top Thickness

1"(29)

3/4"(17)

1 1/8"(13)

1 11/16"(6)

5/8"(6)

1 1/2"(2)

1/8"(1)

Drawer Quantity

1(9)

2(6)

4(6)

Shelf Count

1(43)

4(38)

2(25)

5(11)

3(9)

6(9)

7(2)

4, 3 Adjustable(1)

Door Quantity

2(110)

1(29)

4(4)

Shelf Capacity (Weight)

75 lbs.(24)

150 lbs.(15)

250 lbs.(12)

125 lbs.(4)

180 lbs.(4)

200 lbs.(4)

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

65 lbs.(3)

50 lbs.(2)

35 lbs.(2)

Compartment Quantity

2(9)

1(8)

4(3)

Overall Height

78"(28)

29 1/2"(16)

72"(16)

36"(15)

40"(9)

30"(8)

71 3/4"(8)

4 3/4"(8)

29 3/4"(7)

66"(7)

41 3/4"(4)

22 7/8"(4)

42"(4)

68 3/4"(4)

76 1/4"(3)

64"(3)

65"(2)

59 1/2"(2)

46"(2)

42 3/4"(2)

29 7/8"(2)

44"(2)

17"(1)

38"(1)

39 1/4"(1)

36 1/8"(1)

21 3/4"(1)

22"(1)

Drawer Configuration

File; Storage(4)

Box/Box/Box/Box(3)

Box(3)

Box/Box(2)

Price Range

$0-$499.99(86)

$500-$999.99(61)

$1000-$1499.99(8)

$2500-$2999.99(1)

$3000-$3499.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved