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 ('20043')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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(31)

Alera(20)

Bush(3)

 
Color

Hansen Cherry/Graphite Gray(2)

Hansen Cherry(1)

 
For Use With

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

HON Mod Series Desk and Credenzas(7)

10500 Series Return; Task Light(3)

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

10700 Series Storage Cabinet, Lateral File(3)

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

Alera Valencia Series Tackboard(3)

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

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

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

HON Voi 72" Wide Rectangular Worksurface(2)

Bush WC36492-03SC(1)

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

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

10700 Series 60" Wide Kneespace Credenza(1)

38000 Series 48" Wide "L" Workstation Return, 48" Wide Single Pedestal Desk, Flipper Doors(1)

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

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

HON 94000 Series Lateral File 94223NN, Locking Storage Cabinet 94291NN(1)

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

Alera Valencia Series Corner Credenza Shell, Credenza Shell(1)

HON Voi Two-Drawer Lateral File(1)

 
Series Name

Alera Valencia Series(12)

HON 10500 Series(10)

HON Mod Series(7)

HON 10700 Series(4)

Alera Sedina Series(3)

Alera Valencia Series Bookcase(3)

HON 38000 Series(3)

HON Voi(3)

Alera Open Office Desk Series(2)

Bush Series C Collection(2)

HON 94000 Series(2)

HON Foundation Series(2)

Bush Office in an Hour(1)

 
Country of Origin

US(31)

CN(23)

 
Color(s)

Mahogany(12)

Modern Walnut(8)

Harvest(6)

Medium Cherry(4)

Espresso(4)

Pinnacle(3)

Charcoal(3)

Slate Teak(3)

Traditional Mahogany(3)

Cognac(2)

Gray(1)

Sepia Walnut(1)

Shaker Cherry(1)

 
Material(s)

Woodgrain Laminate(23)

Laminate(10)

Textured Woodgrain Laminate(6)

Thermally Fused Laminate(4)

High-Pressure Laminate(4)

High-Pressure Laminate; Steel(3)

Laminate Over Engineered Wood(2)

Particleboard(2)

 
Compartment Depth

12 1/5"(2)

13.63"(1)

12.88"(1)

 
Compartment Width

14 1/5"(2)

31.5"(1)

31.75"(1)

 
Overall Width

72"(11)

60"(7)

70.63"(6)

58.88"(4)

64.75"(4)

48"(4)

66"(3)

36"(3)

32.63"(3)

59"(2)

71 1/8"(2)

47.13"(1)

31.5"(1)

56.63"(1)

35.75"(1)

70"(1)

 
Overall Depth

15"(19)

14.63"(16)

14"(8)

13.5"(3)

15 3/8"(2)

14.25"(2)

11.75"(1)

13.62"(1)

14.31"(1)

16.13"(1)

 
Overall Height

37.13"(16)

35.38"(14)

39.75"(7)

42.5"(3)

34.75"(3)

35"(3)

36.38"(2)

43 1/8"(2)

37"(2)

23.63"(1)

13.5"(1)

 
Edge Detail Profile

3 mm Protective Edge Banding(19)

Square Edge(13)

Straight Edge(10)

Rounded Corner; Waterfall Edge(4)

Squared Edge(3)

Traditional Molded Edge(2)

 
Number of Compartments

4(15)

3(11)

2(8)

 
Shelf Count

1(2)

 
Compartment Height

20 4/5"(2)

13.5"(1)

12"(1)

 
Door Quantity

4(22)

2(11)

3(3)

 
Shelf Type

Open Center(2)

 
Compartment Quantity

6(2)

1(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved