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

Safco(1)

Bush(1)

 
Color

Mahogany(13)

Cognac(7)

Mahogany; Charcoal(5)

Harvest; Putty(5)

Gray Steel(1)

Mocha; Black(1)

Chestnut(1)

Wheat(1)

Hansen Cherry(1)

 
Warranty

Backed by the HON Full Lifetime Warranty.(31)

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

Manufacturer's limited lifetime warranty.(1)

Manufacturer's ten-year 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)

Mayline Medina Series(1)

HON 10700 Series File Pedestals(1)

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

 
Series Name

HON 10700 Series(12)

HON 38000 Series(8)

HON 10500 Series(7)

HON Metro Classic Series(3)

basyx Manage Series(2)

Mayline Medina Series(1)

Bush Series C Collection(1)

HON 94000 Series(1)

 
Manufacturer Part Number

38852NS(1)

38854CL(1)

38854NS(1)

38852CL(1)

107815XCO(1)

10765CO(1)

10765NN(1)

38855LCL(1)

38855LNS(1)

P3231MOP(1)

P3231NS(1)

MNCNZ72LGS(1)

P3231CL(1)

94243NN(1)

38856RCL(1)

38856RNS(1)

10743NN(1)

10743CO(1)

10546LNN(1)

10565NN(1)

105900NN(1)

10545RNN(1)

10543NN(1)

MG30FOC1A1(1)

MG30FOWHA1(1)

105903RNN(1)

105904LNN(1)

10741NN(1)

10742CO(1)

10742NN(1)

10741CO(1)

10708LCO(1)

10707RCO(1)

10707RNN(1)

WC24426(1)

 
Country of Origin

US(31)

CN(3)

UM(1)

 
Base Material

Woodgrain Laminate(20)

Metal(11)

Melamine(2)

MDF; Laminate(1)

Engineered Wood(1)

 
Overall Width

72"(23)

60"(9)

30"(2)

71 1/8"(1)

 
Overall Height

29 1/2"(32)

22"(2)

29 7/8"(1)

 
Edge Detail Profile

Rounded Corner; Waterfall Edge(12)

Square Edge(10)

Radius Edge(8)

Edgeband(2)

Beveled Edge(1)

PVC Protective Edge(1)

Traditional Edge(1)

 
Top Material

High-Pressure Laminate(13)

Steel-Reinforced High-Pressure Laminate(8)

Thermally Fused Woodgrain Laminate(7)

Laminate(5)

MDF; Laminate(1)

Thermally Fused Laminate Over Engineered Wood(1)

 
Top Thickness

1 1/8"(22)

3/4"(2)

1"(2)

 
Depth Maximum

24"(31)

16"(2)

20"(1)

23 3/8"(1)

 
Drawer Quantity

4(19)

2(11)

 
Drawer Configuration

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

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

Right: File/File(3)

Left: Box/File(3)

Right: Box/File(3)

Left: File/File(2)

 
Pedestal Types

3/4-Height(19)

Full-Height(11)

 
Pedestal Count

2(19)

1(11)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved