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 ('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(53)

Bush(36)

Alera(27)

Safco Mayline(4)

basyx(4)

Alera Plus(3)

Mayline(3)

DMi Furniture(1)

 
Color

Mahogany(23)

Espresso(12)

Harvest(11)

Medium Cherry(9)

Mocha Cherry(6)

Hansen Cherry/Galaxy(6)

Natural Cherry/Slate Gray(5)

Cherry(5)

Bourbon Cherry(4)

Natural Cherry/Graphite Gray(4)

Hansen Cherry/Graphite Gray(4)

Harvest Cherry(4)

Charcoal(3)

Light Gray(3)

Putty(3)

Cognac(3)

Chestnut(3)

Wheat(3)

Natural Cherry(3)

Modern Walnut(3)

Mocha(2)

Hansen Cherry(2)

Brilliant White(2)

Henna Cherry(1)

Raven(1)

Gray Steel(1)

Shaker Cherry(1)

Silver Mesh(1)

Mocha Cherry/White(1)

Gray(1)

Natural Maple/White(1)

 
Overall Width

72"(28)

60"(18)

36"(9)

71 1/8"(8)

70 5/8"(6)

48"(5)

56 5/8"(4)

64 3/4"(4)

47 1/4"(4)

70 1/8"(4)

58 7/8"(3)

32 5/8"(3)

47"(3)

30"(3)

68 5/8"(3)

58"(3)

16"(3)

78"(2)

31"(2)

47 5/8"(2)

71 5/8"(2)

35 5/8"(2)

65"(2)

66"(2)

59 5/8"(2)

71 7/8"(1)

70"(1)

71"(1)

35 3/4"(1)

 
Overall Depth

14 5/8"(33)

15"(31)

14 1/4"(11)

13 1/2"(9)

15 3/8"(8)

13 7/8"(8)

12 3/8"(6)

13"(4)

47 1/4"(4)

14 1/2"(4)

18"(3)

11 3/4"(3)

14"(2)

12 1/4"(2)

15 7/8"(1)

14 5/16"(1)

16 1/8"(1)

 
Manufacturer Part Number

10534CC(1)

10534NN(1)

105388CC(1)

105324NN(1)

105324CC(1)

105323CC(1)

105323NN(1)

105388NN(1)

107292CC(1)

10732JJ(1)

10732NN(1)

10732CO(1)

10732CC(1)

107292CO(1)

107292NN(1)

105292NN(1)

105292CC(1)

BL2183NN(1)

BW2180HH(1)

BL2183ESES(1)

BL2183A1A1(1)

BL2180ESES(1)

BL2180NN(1)

BW2180NN(1)

MG36OVC1A1(1)

MNGDIVW(1)

7990-62(1)

MNGDIVC(1)

MG60OVWHA1(1)

MG36OVWHA1(1)

MG60OVC1A1(1)

10734CC(1)

10734CO(1)

VHF72B(1)

VHF72C(1)

VHF72W(1)

VHF60W(1)

VHF60C(1)

94234NN(1)

VBH36C(1)

VW707XZ9FF(1)

AHG72LCR(1)

MHUF70ESP(1)

MNH72LGS(1)

E5OHSAHB(1)

AHW72LDC(1)

AHG72LDC(1)

AHW72LCR(1)

94210NN(1)

386572NS(1)

11534AXHH(1)

11534AXNN(1)

115327AXNN(1)

115327AXHH(1)

10734NN(1)

115292AXHH(1)

386548NL(1)

386548NQ(1)

386572NL(1)

386572NQ(1)

386560NS(1)

386560NQ(1)

386548NS(1)

386560NL(1)

BL2180A1A1(1)

WC94473(1)

VA286015MC(1)

VA286015MY(1)

VA286615ES(1)

VA286015ES(1)

VA284815MY(1)

VA284815ES(1)

VA284815MC(1)

VA286615MC(1)

VA286615MY(1)

2955CS-03(1)

2955MC-03(1)

VA296615MC(1)

VA287215MY(1)

VA287215ES(1)

VA287215MC(1)

VA26-7212MY(1)

VA26-7212MC(1)

LSHH60MY(1)

LSHH60WA(1)

LSHH60MC(1)

LSHH60ES(1)

BR191ES(1)

BR191GY(1)

RN26-6615CM(1)

RN26-6615MM(1)

SE267215WA(1)

VA267212ES(1)

SE267215ES(1)

SE266615WA(1)

RN26-7215MM(1)

SE266615ES(1)

2961CS-03(1)

2961MC-03(1)

WC57467PA2(1)

WC57473(1)

WC72466A1(1)

WC57467PA1(1)

WC57461(1)

WC57437(1)

WC57449(1)

WC72466A2(1)

WC72477A1(1)

WC94467PA1(1)

WC94467PA2(1)

WC94461(1)

WC94449(1)

WC72477A2(1)

WC94437(1)

WC24477A2(1)

WC24477A1(1)

34H72AC(1)

34H72MR(1)

2973MCA2-03(1)

2973MCA1-03(1)

2973CSA1-03(1)

2973CSA2-03(1)

PR76305(1)

PR76361(1)

WC24466A1(1)

WC24466A2(1)

PR76861(1)

PR76805(1)

PR76505(1)

PR76561(1)

BR191CY(1)

 
Country of Origin

US(75)

CN(56)

 
Material(s)

Thermally Fused Laminate Over Engineered Wood(25)

Woodgrain Laminate(22)

Laminate Over Engineered Wood(11)

High-Pressure Laminate(10)

Laminated(9)

High-Pressure Laminate; Steel(9)

Textured Woodgrain Laminate(7)

Laminate(6)

Thermally Fused Laminate(6)

Melamine(6)

Thermally Fused Laminate Over 1-1/2" Thick Solid Core High-Density Particleboard(5)

Solid Wood; Veneer(3)

Thermally Fused Laminate/Glass(2)

Veneer(2)

Walnut Veneer(1)

MDF; Laminate; Glass; Steel(1)

Solid Wood; Wood Veneer(1)

Wood Veneer(1)

MDF; Laminate(1)

 
For Use With

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

10700 Series 60" Wide Kneespace Credenza(4)

Alera Valencia Series Tackboard(4)

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

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

Bush Envoy Collection Double Pedestal Desk or Corner Desk Shell with Three-Drawer Pedestal(3)

Bush Envoy Collection Return, Three-Drawer Pedestal and Two-Drawer Lateral File(3)

HON Voi 72" Wide Rectangular Worksurface; HON Voi O-Leg Supports for Overhead Cabinet(3)

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

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

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

Alera Plus Hospitality Base Cabinet(3)

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

10700 Series 72" Wide Credenzas(3)

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

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

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

10500 Series Return; Task Light(2)

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

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

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

10500 Series 72" Wide Credenzas; 10500 Series 72" Wide Desks(2)

11500 Series Valido L Workstation(2)

11500 Series Valido Computer Credenza; 11500 Series Valido Kneespace Credenza(2)

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

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

Mayline Aberdeen Series Credenza Shell; Mayline Task Light(2)

Mayline Aberdeen Series 72" Wide Credenza Shell(2)

Bush Momentum Collection 24H filing and storage units(2)

HON Voi 60" Wide Rectangular Worksurface; HON Voi Low Credenza; HON Voi O-Leg Supports for Overhead Cabinet(2)

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

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

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

Mayline Mira Series Hutch Doors(1)

Mayline Medina Series(1)

Mayline e5 Series(1)

HON Arrive Wood Veneer 72" Wide Kneespace Credenza; HON Arrive Wood Veneer 72" Wide Single Pedestal Credenza(1)

HON Voi Two-Drawer Lateral File(1)

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

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

11500 Series Valido Storage Cabinet with Doors; 11500 Series Valido Two-Drawer Lateral File(1)

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

Must also purchase Box 2 SKU BSHWC24466A2, 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 BSHWC24477A2, 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)

Bush Enterprise Collection Lateral File BSH2954MC03; Light Kit BSHWC8065A03(1)

Bush Enterprise Collection Lateral File BSH2954CS03; Light Kit BSHWC8065A03(1)

Verona Veneer Series 66" Wide Credenza Shell: ALE-RN25-6624CM(1)

Verona Veneer Series 66" Wide Credenza Shell: ALE-RN25-6624MM(1)

Verona Veneer Series 72" Wide Credenza Shell: ALE-RN25-7224MM(1)

Alera Valencia Series Credenza Shell; Alera Valencia Series Desk Shell; Alera Valencia Series Door Set; Alera Valencia Series Tackboard(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)

BW Veneer Series 72" Wide Credenza Shell: BSX-BW2121HH(1)

BW Veneer Series 72" Wide Credenza Shell: BSX-BW2121NN(1)

HON Manage Series Desk(1)

basyx Manage Series 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 BSHWC72466A2, Light Pack; Series C 72W Desk; Series C Lateral Files(1)

Must also purchase Box 1 SKU BSHWC72466A1, 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)

Keswick Collection Kneehole Credenza DMI799021(1)

 
Edge Detail Profile

3mm Protective Edge Banding(24)

Straight Edge(16)

Rounded Corner; Waterfall Edge(10)

Edgeband(6)

Grooved Edgeband; Bullnose Edges(6)

Square Edge(6)

Ribbon Edge(5)

Edgeband Paper(4)

4mm Fluted PVC Edge Detailing(4)

Solid Wood Reeded Edge(3)

Solid Hardwood Beaded Edge(2)

Traditional Molded Edge(2)

Edgeband PVC(2)

Cove Edge(1)

 
Shelf Count

2(15)

1(13)

4(8)

6(5)

3(5)

 
Door Quantity

4(53)

2(36)

3(6)

1(6)

 
Shelf Type

Adjustable(12)

Open Center(8)

Open(5)

1 Fixed; 2 Adjustable(4)

Fixed(3)

1 Fixed; 1 Adjustable(3)

1 Enclosed; 1 Open(2)

1 Enclosed; 3 Open(2)

4 Adjustable(2)

2 Removable(1)

2 Storage(1)

2 Adjustable(1)

1 Enclosed; 2 Open(1)

2 Adjustable; 2 Fixed(1)

2 Open; 4 Enclosed; 1 Fixed; 5 Adjustable(1)

 
Compartment Quantity

2(24)

3(19)

4(19)

6(6)

5(5)

7(4)

9(4)

1(1)

 
Overall Height

37 1/8"(26)

35 1/2"(13)

36 5/8"(12)

34 3/4"(9)

43 1/8"(8)

36 1/2"(7)

36 1/4"(6)

41 3/4"(6)

14"(5)

37 1/2"(5)

17 3/4"(4)

42 1/2"(4)

40 1/4"(3)

23 5/8"(3)

39 1/8"(2)

37"(2)

39 1/4"(2)

12"(2)

27 3/4"(2)

22"(2)

38 1/8"(2)

39"(1)

18 1/4"(1)

15"(1)

35"(1)

50"(1)

42"(1)

 
Compartment Depth

12 3/4"(5)

12 1/5"(4)

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

11 7/8"(4)

14"(3)

17 1/8"(3)

11"(2)

15"(1)

13 5/8"(1)

12 7/8"(1)

13"(1)

13 1/5"(1)

14 1/4"(1)

 
Compartment Width

13 1/2"(5)

14 1/5"(5)

13"(4)

22 3/4"(3)

33 3/4"(2)

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

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

34 3/8"(2)

17 1/4"(1)

17 1/2"(1)

28 1/2"(1)

31 3/4"(1)

34 1/2"(1)

 
Compartment Height

13 2/5"(5)

13 3/8"(5)

20 4/5"(5)

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

26"(3)

15"(2)

12 5/8"(2)

17 3/8"(1)

18 1/2"(1)

14"(1)

12"(1)

13"(1)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved