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

Currently Filtered by

Category

Credenzas

Refine Search

  GO
 
Brand

HON(31)

basyx(2)

Bush(1)

Safco(1)

 
Color

Mahogany(13)

Cognac(7)

Harvest; Putty(5)

Mahogany; Charcoal(5)

Hansen Cherry(1)

Chestnut(1)

Wheat(1)

Mocha; Black(1)

Gray Steel(1)

 
Warranty

Backed by the HON Full Lifetime Warranty.(31)

Backed by the basyx by HON Limited Five-Year Warranty.(2)

Manufacturer's ten-year warranty.(1)

Manufacturer's limited lifetime warranty.(1)

 
For Use With

HON Metro Classic Series Stack-On Open Shelf Unit and Articulating Keyboard/Mouse Platforms(3)

To create an "L" configuration, you must order basyx Manage Series Open File Center and basyx Manage Series Worksurface, both sold separately.(2)

Bush Series C Collection File Pedestals, Hutch with Doors, Desks, Return Bridge, Pencil Drawer and Keyboard Shelf(1)

HON 10700 Series File Pedestals(1)

Mayline Medina Series(1)

 
Series Name

HON 10700 Series(12)

HON 38000 Series(8)

HON 10500 Series(7)

HON Metro Classic Series(3)

basyx Manage Series(2)

Bush Series C Collection(1)

HON 94000 Series(1)

Mayline Medina Series(1)

 
Manufacturer Part Number

WC24426(1)

38855LCL(1)

10765NN(1)

107815XCO(1)

38852CL(1)

38852NS(1)

38854CL(1)

38854NS(1)

38855LNS(1)

10743NN(1)

38856RCL(1)

38856RNS(1)

94243NN(1)

P3231CL(1)

P3231MOP(1)

P3231NS(1)

10765CO(1)

10743CO(1)

MG30FOC1A1(1)

105903RNN(1)

MG30FOWHA1(1)

10543NN(1)

10545RNN(1)

10546LNN(1)

10565NN(1)

105900NN(1)

105904LNN(1)

10742NN(1)

10707RCO(1)

10707RNN(1)

10708LCO(1)

10741CO(1)

10741NN(1)

10742CO(1)

MNCNZ72LGS(1)

 
Country of Origin

US(31)

CN(3)

UM(1)

 
Base Material

Woodgrain Laminate(20)

Metal(11)

Melamine(2)

Engineered Wood(1)

MDF; Laminate(1)

 
Overall Width

72"(23)

60"(9)

30"(2)

71.13"(1)

 
Overall Height

29.5"(31)

22"(2)

29.88"(1)

29 1/2"(1)

 
Edge Detail Profile

Rounded Corner; Waterfall Edge(12)

Square Edge(10)

Radius Edge(8)

Edgeband(2)

PVC Protective Edge(1)

Traditional Edge(1)

Beveled Edge(1)

 
Top Material

High-Pressure Laminate (HPL)(12)

Steel-Reinforced High-Pressure Laminate(8)

Thermally Fused Woodgrain Laminate(7)

Laminate(5)

Thermally Fused Laminate Over Engineered Wood(1)

High-Pressure Laminate(1)

MDF; Laminate(1)

 
Top Thickness

1.13"(21)

1"(2)

3/4"(2)

1 1/8"(1)

 
Depth Maximum

24"(31)

16"(2)

23.38"(1)

20"(1)

 
Drawer Quantity

4(19)

2(11)

 
Drawer Configuration

Left: Box/File; Right: Box/File(14)

Left: File/File; Right: File/File(5)

Right: Box/File(3)

Left: Box/File(3)

Right: File/File(3)

Left: File/File(2)

 
Pedestal Types

3/4-Height(19)

Full-Height(11)

 
Pedestal Count

2(19)

1(11)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved