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','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 '%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)

Alera(28)

Bush(26)

DMi Furniture(1)

Mayline(1)

 
Color

Mahogany(18)

Natural Maple(10)

Bourbon Cherry(9)

Espresso(7)

Harvest(7)

Modern Walnut(7)

Medium Cherry(7)

Mocha Cherry(6)

Harvest Cherry(4)

Hansen Cherry/Graphite Gray(4)

Natural Cherry/Graphite Gray(4)

Cognac(3)

Pinnacle(3)

Shaker Cherry(3)

Charcoal(3)

Hansen Cherry/Galaxy(3)

Natural Cherry(3)

Cherry(2)

Hansen Cherry(2)

Wheat(1)

Putty(1)

Light Gray(1)

Chestnut(1)

 
Overall Width

72"(17)

60"(9)

70.63"(8)

71.13"(8)

48"(7)

36"(6)

32.63"(5)

56.63"(4)

59"(4)

70 1/8"(4)

64.75"(4)

58.88"(4)

47.13"(4)

34.13"(4)

68.63"(3)

58"(3)

16"(2)

30"(2)

78"(2)

31"(2)

35.75"(1)

71.63"(1)

47.25"(1)

59.63"(1)

47.63"(1)

31.5"(1)

70"(1)

 
Overall Depth

14.63"(40)

15"(26)

15.38"(8)

13.5"(5)

12 3/8"(4)

11.75"(4)

14.25"(4)

13.88"(3)

14 1/4"(3)

13"(2)

12.38"(2)

12 1/4"(2)

13.62"(1)

47.25"(1)

14 5/8"(1)

14.31"(1)

16.13"(1)

14"(1)

 
Manufacturer Part Number

LSHH60ES(1)

10534DD(1)

107292HH(1)

107292DD(1)

107292CO(1)

107292CC(1)

105388HH(1)

105388DD(1)

10534PINC(1)

10534NN(1)

10534HH(1)

10534FF(1)

10534CC(1)

10732CC(1)

105324NN(1)

105324HH(1)

105324CC(1)

105323NN(1)

105323HH(1)

105323DD(1)

105323CC(1)

105292NN(1)

105292HH(1)

105292DD(1)

105292CC(1)

107292NN(1)

10732CO(1)

MNGDIVW(1)

386572NS(1)

VHBF72N(1)

VHBF72C(1)

VBH36N(1)

LM72HUTPNC(1)

LM72HUTN(1)

LM72HUTF(1)

LM60HUTPNC(1)

LM60HUTN(1)

LM60HUTF(1)

94234NN(1)

94210NN(1)

386560NS(1)

10732DD(1)

386548NS(1)

386548NQ(1)

386548NL(1)

11534AXDD(1)

115327AXHH(1)

115327AXDD(1)

115292AXDD(1)

10734HH(1)

10734DD(1)

10734CO(1)

10732HH(1)

7990-62(1)

MNGDIVC(1)

LSHH60MC(1)

VA284815MY(1)

VA287215ES(1)

VA286615WA(1)

VA286615MY(1)

VA286615MC(1)

VA286615ES(1)

VA286015WA(1)

VA286015MY(1)

VA286015MC(1)

VA286015ES(1)

VA284815WA(1)

VA284815MC(1)

VA287215MY(1)

VA284815ES(1)

VA283415WA(1)

VA283415MY(1)

VA283415MC(1)

VA283415ES(1)

VA267212WA(1)

VA26-7212MY(1)

VA26-7212MC(1)

VA267212ES(1)

LSHH60WA(1)

LSHH60MY(1)

VA287215MC(1)

VA287215WA(1)

WC94467PA2(1)

WC24466A1(1)

WC94461(1)

WC94449(1)

WC72477A2(1)

WC72477A1(1)

WC72466A2(1)

WC72466A1(1)

WC57473(1)

WC3649703(1)

WC24477A2(1)

WC24477A1(1)

WC24466A2(1)

PR76861(1)

2955CS-03(1)

PR76805(1)

PR76561(1)

PR76361(1)

PR76305(1)

2973MCA2-03(1)

2973MCA1-03(1)

2973CSA2-03(1)

2973CSA1-03(1)

2961MC-03(1)

2961CS-03(1)

2955MC-03(1)

AHW72LCR(1)

 
Country of Origin

US(62)

CN(47)

 
Material(s)

Woodgrain Laminate(37)

Thermally Fused Laminate Over Engineered Wood(14)

High-Pressure Laminate(12)

Laminate Over Engineered Wood(11)

Thermally Fused Laminate(6)

Textured Woodgrain Laminate(6)

Particleboard(6)

High-Pressure Laminate; Steel(5)

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

Laminate(3)

Laminated(2)

Melamine(2)

Solid Wood; Wood Veneer(1)

 
For Use With

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

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

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

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

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

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

10700 Series 60" Wide Kneespace Credenza(4)

10500 Series Return; Task Light(4)

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

Alera Lateral File; Alera Storage Cabinet(4)

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

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

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

Alera Valencia Series Credenza Shells; Alera Valencia Series Desk Shells; Alera Tackboards(3)

10700 Series 72" Wide Credenzas(3)

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

HON Voi 72" Wide Rectangular Worksurface(2)

HON Manage Series Desk(2)

11500 Series Valido L Workstation(2)

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

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

Valido Storage Cabinet; Valido Two-Drawer Lateral File(1)

HON Voi Two-Drawer Lateral File(1)

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

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

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

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

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

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

Keswick Collection Kneehole Credenza DMI799021(1)

WC24477A1(1)

Alera Valencia Series Credenza Shells, Desk Shells, and Tackboards.(1)

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

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

WC24466A2(1)

WC24466A1(1)

WC24477A2(1)

Bush WC36492-03SC(1)

WC94467PA1(1)

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

WC72466A2(1)

WC72466A1(1)

WC72477A2(1)

WC72477A1(1)

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

Mayline Aberdeen Series 72" Wide Credenza Shell(1)

 
Edge Detail Profile

3mm Protective Edge Banding(27)

Straight Edge(19)

Rounded Corner; Waterfall Edge(12)

Square Edge(10)

Edgeband Paper(4)

Ribbon Edge(4)

Grooved Edgeband; Bullnose Edges(3)

Grooved Edgeband; Bullnose Edge(2)

Edgeband(2)

Traditional Molded Edge(2)

4mm Fluted PVC Edge Detailing(1)

 
Shelf Count

2(21)

1(9)

4(8)

3(5)

6(1)

 
Door Quantity

4(43)

2(28)

3(5)

1(2)

 
Shelf Type

Adjustable(17)

Open Center(8)

1 Fixed; 2 Adjustable(4)

1 Enclosed; 1 Open(2)

1 Enclosed; 3 Open(2)

1 Fixed; 1 Adjustable(2)

Open(2)

4 Adjustable(2)

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

2 Adjustable(1)

2 Removable(1)

 
Compartment Quantity

4(21)

2(21)

3(9)

7(4)

9(4)

6(4)

5(2)

1(1)

 
Overall Height

37.13"(35)

35.38"(20)

43.13"(8)

41 3/4"(6)

34.75"(5)

36.38"(4)

36.63"(4)

23.63"(4)

35"(3)

36 1/4"(3)

37.5"(3)

37"(2)

12"(2)

22"(2)

36.25"(2)

27.75"(2)

50"(1)

37 1/2"(1)

13.5"(1)

39 1/8"(1)

 
Compartment Depth

12.75"(5)

12.2"(4)

13.2"(1)

13.63"(1)

11.88"(1)

12.88"(1)

 
Compartment Width

14.2"(5)

13.5"(5)

31.5"(1)

13"(1)

31.75"(1)

 
Compartment Height

20.8"(5)

13.4"(5)

13.5"(1)

13.38"(1)

12"(1)

 
 
 

© 2020-2021 Desert West Office Supply, All Rights Reserved