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_36` 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

Alera(32)

HON(29)

Bush(10)

 
Color

Mahogany(16)

Espresso(9)

Modern Walnut(9)

Harvest(8)

Medium Cherry(7)

Hansen Cherry/Graphite Gray(4)

Natural Cherry/Graphite Gray(4)

Charcoal(3)

Cognac(2)

Shaker Cherry(2)

Pinnacle(2)

Harvest Cherry(1)

Mocha Cherry(1)

Wheat(1)

Putty(1)

Light Gray(1)

 
Overall Width

60"(9)

72"(9)

70.63"(8)

71.13"(8)

48"(5)

64.75"(4)

59"(4)

58.88"(4)

47.13"(4)

34.13"(4)

32.63"(3)

66"(2)

36"(2)

56.63"(2)

31"(1)

35.75"(1)

70"(1)

 
Overall Depth

15"(28)

14.63"(19)

15.38"(8)

13.5"(5)

11.75"(4)

12.38"(2)

13"(1)

14.31"(1)

16.13"(1)

14 1/4"(1)

14.25"(1)

 
Manufacturer Part Number

LSHH60ES(1)

105323CC(1)

107292CC(1)

10534NN(1)

10534CC(1)

105324NN(1)

105324CC(1)

105323NN(1)

105292NN(1)

107292NN(1)

105292CC(1)

MNGDIVW(1)

WC72477A2(1)

WC72477A1(1)

WC72466A2(1)

WC72466A1(1)

107292CO(1)

10732CC(1)

WC24477A1(1)

LM60HUTF(1)

VHF60C(1)

LM72HUTPNC(1)

LM72HUTN(1)

LM72HUTF(1)

LM60HUTPNC(1)

LM60HUTN(1)

94234NN(1)

10732CO(1)

94210NN(1)

386572NS(1)

386560NS(1)

386548NS(1)

386548NQ(1)

386548NL(1)

WC24477A2(1)

WC24466A2(1)

LSHH60MC(1)

VA26-7212MC(1)

VA283415WA(1)

VA283415MY(1)

VA283415MC(1)

VA283415ES(1)

VA267212WA(1)

VA26-7212MY(1)

VA267212ES(1)

VA284815MC(1)

SE267215WA(1)

SE267215ES(1)

SE266615WA(1)

SE266615ES(1)

LSHH60WA(1)

LSHH60MY(1)

VA284815ES(1)

VA284815MY(1)

WC24466A1(1)

VA286615WA(1)

2961MC-03(1)

2961CS-03(1)

VA287215WA(1)

VA287215MY(1)

VA287215MC(1)

VA287215ES(1)

VA286615MY(1)

VA284815WA(1)

VA286615MC(1)

VA286615ES(1)

VA286015WA(1)

VA286015MY(1)

VA286015MC(1)

VA286015ES(1)

VHF72C(1)

 
Country of Origin

CN(41)

US(30)

 
Material(s)

Woodgrain Laminate(28)

Textured Woodgrain Laminate(8)

Laminate Over Engineered Wood(8)

Particleboard(6)

High-Pressure Laminate(5)

High-Pressure Laminate; Steel(5)

Thermally Fused Laminate(4)

Laminated(2)

Thermally Fused Laminate Over Engineered Wood(2)

Laminate(2)

Melamine(1)

 
For Use With

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

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

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

Alera Lateral File; Alera Storage Cabinet(4)

Alera Valencia Series Tackboard(4)

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 Storage Cabinet; 10700 Series Lateral File(3)

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)

10700 Series 60" Wide Kneespace Credenza(2)

10500 Series Return; Task Light(2)

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

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

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

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

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

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

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

WC72477A1(1)

HON Manage Series Desk(1)

WC72477A2(1)

WC72466A1(1)

WC72466A2(1)

WC24477A1(1)

WC24477A2(1)

WC24466A1(1)

WC24466A2(1)

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

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

 
Edge Detail Profile

3mm Protective Edge Banding(31)

Straight Edge(8)

Square Edge(8)

Rounded Corner; Waterfall Edge(5)

Edgeband Paper(2)

Traditional Molded Edge(2)

Edgeband(1)

 
Shelf Count

2(11)

1(8)

4(6)

6(4)

3(1)

 
Door Quantity

4(27)

2(22)

3(2)

 
Shelf Type

Adjustable(17)

Open Center(8)

1 Enclosed; 3 Open(2)

1 Fixed; 2 Adjustable(1)

 
Compartment Quantity

4(18)

3(12)

2(7)

9(4)

6(4)

 
Overall Height

35.38"(20)

37.13"(19)

43.13"(8)

34.75"(5)

36.38"(4)

42.5"(4)

23.63"(4)

27.75"(2)

37"(2)

14"(2)

12"(1)

 
Compartment Depth

12.75"(4)

12.2"(4)

12.88"(1)

 
Compartment Width

13.5"(4)

14.2"(4)

31.75"(1)

 
Compartment Height

13.4"(4)

20.8"(4)

12"(1)

 
 
 

© 2020-2021 Horizon Business Products, All Rights Reserved