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

Currently Filtered by

Category

Hutches

Refine Search

  GO
 
Brand

HON(32)

Alera(26)

Bush(25)

Mayline(2)

 
Color

Mahogany(16)

Espresso(11)

Medium Cherry(9)

Hansen Cherry/Galaxy(5)

Harvest(5)

Natural Cherry/Slate Gray(5)

Natural Cherry/Graphite Gray(4)

Hansen Cherry/Graphite Gray(4)

Putty(3)

Charcoal(3)

Light Gray(3)

Modern Walnut(3)

Mocha Cherry(3)

Harvest Cherry(3)

Wheat(2)

Chestnut(2)

Gray Steel(1)

Raven(1)

Natural Cherry(1)

Cognac(1)

 
Overall Width

60"(16)

72"(11)

71 1/8"(8)

70 5/8"(6)

48"(5)

47 1/4"(4)

70 1/8"(4)

36"(4)

58 7/8"(3)

32 5/8"(3)

34"(3)

47"(3)

64 3/4"(3)

71 5/8"(2)

35 5/8"(2)

47 5/8"(2)

66"(2)

30"(1)

70"(1)

35 3/4"(1)

59 5/8"(1)

 
Overall Depth

15"(25)

14 5/8"(17)

13 1/2"(9)

15 3/8"(8)

13 7/8"(7)

12 3/8"(6)

14 1/2"(4)

47 1/4"(4)

11 3/4"(3)

16 1/8"(1)

14 5/16"(1)

 
Manufacturer Part Number

MG36OVWHA1(1)

MG36OVC1A1(1)

BL2183NN(1)

BL2183ESES(1)

MG60OVC1A1(1)

MG60OVWHA1(1)

105323CC(1)

105292NN(1)

105292CC(1)

BL2183A1A1(1)

BL2180NN(1)

WC94449(1)

WC94437(1)

WC72477A2(1)

WC72477A1(1)

WC94467PA1(1)

WC94467PA2(1)

BL2180ESES(1)

BL2180A1A1(1)

WC94473(1)

105323NN(1)

105324CC(1)

386572NQ(1)

386572NL(1)

386560NS(1)

386560NQ(1)

386572NS(1)

94210NN(1)

MNH72LGS(1)

E5OHSAHB(1)

94234NN(1)

386560NL(1)

386548NS(1)

10534NN(1)

10534CC(1)

105324NN(1)

107292CC(1)

107292CO(1)

386548NQ(1)

386548NL(1)

107292NN(1)

WC72466A2(1)

WC72466A1(1)

VA284815MC(1)

VA284815ES(1)

VA283415MY(1)

VA283415MC(1)

VA284815MY(1)

VA286015ES(1)

VA286615ES(1)

VA286015MY(1)

VA286015MC(1)

VA283415ES(1)

VA26-7212MY(1)

SE266615ES(1)

LSHH60WA(1)

LSHH60MY(1)

LSHH60MC(1)

SE266615WA(1)

SE267215ES(1)

VA26-7212MC(1)

VA267212ES(1)

SE267215WA(1)

VA286615MC(1)

VA286615MY(1)

WC57437(1)

WC24477A2(1)

WC24477A1(1)

WC24466A2(1)

WC57449(1)

WC57461(1)

WC57473(1)

WC57467PA2(1)

WC57467PA1(1)

WC24466A1(1)

2973MCA2-03(1)

VA287215MY(1)

VA287215MC(1)

VA287215ES(1)

2961CS-03(1)

2961MC-03(1)

2973MCA1-03(1)

2973CSA2-03(1)

2973CSA1-03(1)

LSHH60ES(1)

 
Country of Origin

CN(43)

US(42)

 
Material(s)

Woodgrain Laminate(23)

Thermally Fused Laminate Over Engineered Wood(17)

High-Pressure Laminate; Steel(9)

Laminate Over Engineered Wood(8)

Laminated(8)

Textured Woodgrain Laminate(7)

Thermally Fused Laminate(4)

Melamine(4)

High-Pressure Laminate(3)

MDF; Laminate; Glass; Steel(1)

MDF; Laminate(1)

 
For Use With

Alera Valencia Series Credenza Shells, Desk Shells, Tackboards(12)

Bush Enterprise Collection 72W Double Pedestal Desk, 72W L-Desk and Light Kit(4)

Alera Valencia Series Tackboard(4)

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

38000 Series 60" Wide Double Pedestal Desk; 38000 Series 60" Wide Kneespace Credenza; 38000 Series Flipper Doors(3)

38000 Series 72" Wide Double Pedestal Desk; 38000 Series 72" Wide Kneespace Credenza; 38000 Series Flipper Doors(3)

BL Series 60" Wide Credenza Shell; BL Series 60" Wide Desk Shell(3)

38000 Series 48" Wide "L" Workstation Return; 38000 Series 48" Wide Single Pedestal Desk; 38000 Series Flipper Doors(3)

BL Series 72" Wide Credenza Shell; BL Series 72" Wide Desk Shell(3)

Alera Valencia Series Corner Credenza Shell; Valencia Series Credenza Shell(3)

Alera Lateral File; Alera Storage Cabinet(3)

10700 Series Storage Cabinet; 10700 Series Lateral File(3)

10500 Series Storage Cabinet with Doors; 10500 Series Two-Drawer Lateral File(2)

10500 Series Return; Task Light(2)

10500 Series 60" Wide Kneespace Credenza; 10500 Series 60" Wide Rectangular Top Desk; Task Light(2)

10500 Series 72" Wide Kneespace Credenza; 10500 Series 72" Wide Rectangular Top Desk; 10500 Series Computer Credenza; Task Light(2)

Light Pack; Series A 36W Workstation Desk(2)

Light Pack; Series A 72W Workstation Desk(2)

Bush Enterprise Collection 60W Double Pedestal Desk, 60W L-Desk and Light Kit(2)

Light Pack; Series A 48W Workstation Desk(2)

Mayline Medina Series(1)

HON 94000 Series Kneespace Credenza: HON-94243NN(1)

HON 94000 Series Lateral File: HON-94223NN; HON 94000 Series Locking Storage Cabinet: HON-94291NN(1)

Mayline e5 Series(1)

Must also purchase Box 1 SKU BSHWC72466A1, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must also purchase Box 1 SKU BSHWC24477A1, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Light Pack; Series A 60W Workstation Desk(1)

Must also purchase Box 2 SKU BSHWC24477A2, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must also purchase Box 2 SKU BSHWC24466A1, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must also purchase Box 2 SKU BSHWC24466A2, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must be purchased with Box 2 SKU BSHWC57467PA2, Light Pack; Series A Corner Desk(1)

Must be purchased with Box 1 SKU BSHWC57467PA1, Light Pack; Series A Corner Desk(1)

Must be purchase with Box 2 SKU BSHWC94467PA2; Light Pack; Series A Corner Desk(1)

Must also purchase Box 1 SKU BSHWC72477A1, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must also purchase Box 2 SKU BSHWC72477A2, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must also purchase Box 2 SKU BSHWC72466A2, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must be purchase with Box 2 SKU BSHWC57467PA2, Light Pack; Series A Corner Desk(1)

 
Edge Detail Profile

3mm Protective Edge Banding(26)

Straight Edge(14)

Edgeband(4)

Rounded Corner; Waterfall Edge(3)

Traditional Molded Edge(2)

Edgeband Paper(2)

 
Shelf Count

1(13)

2(9)

4(5)

6(4)

3(2)

 
Door Quantity

2(29)

4(24)

3(6)

1(4)

 
Shelf Type

Adjustable(15)

Open Center(8)

Open(5)

1 Enclosed; 3 Open(2)

Fixed(1)

1 Enclosed; 2 Open(1)

1 Fixed; 2 Adjustable(1)

 
Compartment Quantity

3(19)

4(15)

2(7)

5(5)

9(4)

6(4)

7(4)

1(1)

 
Overall Height

37 1/8"(17)

35 1/2"(15)

36 5/8"(11)

34 3/4"(9)

43 1/8"(8)

42 1/2"(4)

41 3/4"(4)

17 3/4"(4)

36 1/2"(4)

23 5/8"(3)

27 3/4"(2)

37"(2)

18 1/4"(1)

15"(1)

 
Compartment Depth

12 3/4"(4)

11 7/8"(4)

2 at 12 1/2", 1 at 13 1/2"(4)

12 1/5"(4)

13 5/8"(1)

12 7/8"(1)

15"(1)

 
Compartment Width

13 1/2"(4)

13"(4)

14 1/5"(4)

2 at 28 3/4", 1 at 58 1/2"(2)

2 at 16 3/4", 1 at 34 1/2"(2)

17 1/4"(1)

28 1/2"(1)

31 3/4"(1)

 
Compartment Height

13 2/5"(4)

13 3/8"(4)

2 at 12 1/2", 1 at 3"(4)

20 4/5"(4)

17 3/8"(1)

12"(1)

13"(1)