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

Currently Filtered by

Category

Utility Drawers

Refine Search

  GO
 
Brand

HON(14)

Alera(3)

Bush(2)

Mayline(1)

 
Color

Black(3)

Mahogany(3)

Putty(2)

Light Gray(2)

Charcoal(2)

Bourbon Cherry(2)

Harvest(2)

Cognac(2)

Medium Cherry(1)

Espresso(1)

 
Overall Width

26"(4)

22"(4)

19"(3)

24 1/2"(3)

24 3/4"(3)

25"(1)

26 19/50"(1)

27 1/8"(1)

 
Overall Depth

15 3/8"(8)

14 3/4"(6)

15"(3)

18"(1)

17 3/8"(1)

15 7/8"(1)

 
Manufacturer Part Number

D2Q(1)

D2L(1)

1526N(1)

1526H(1)

D2S(1)

D8L(1)

ACDBLK(1)

D8S(1)

D8Q(1)

1526CO(1)

1526C(1)

AC99850(1)

VA312414MY(1)

VA312414MC(1)

AC99855-03(1)

1522C(1)

1522N(1)

1522H(1)

1522CO(1)

VA312414ES(1)

 
Country of Origin

US(15)

CN(5)

 
Material(s)

Laminate(8)

Metal(7)

Woodgrain Laminate(2)

Thermally Fused Laminate(1)

Metal; Wood(1)

Textured Woodgrain Laminate(1)

 
For Use With

HON Laminate Series Double Pedestal Desk and/or Desk Shell; HON Laminate Series Kneespace Credenza; HON Laminate Series Return(4)

Credenza; Desk; Single Pedestal Credenza; Single Pedestal Desk(3)

Double Pedestal Desk(3)

HON Laminate Series Double Pedestal Desk and/or Desk Shell; HON Laminate Series Single Pedestal Desk; HON Laminate Series Kneespace Credenza; HON Laminate Series Single Pedestal Credenza; HON Laminate Series Return(2)

HON Laminate Series Double Pedestal Desks and/or Desk Shell; HON Laminate Series Single Pedestal Desk; HON Laminate Series Kneespace Credenza; HON Laminate Series Single Pedestal Credenza; HON Laminate Series Return(2)

Alera Valencia Series Desks, Credenzas, Bridges and Returns.(2)

Mayline Aberdeen Series Bow Front Desk Shell; Mayline Aberdeen Series Credenza Shell; Mayline Brighton Series Bow Front Desk; Mayline Brighton Series Credenza(1)

Bush Series A Collection Worksurfaces; Bush Series C Collection Worksurfaces; Bush Quantum Collection Worksurfaces(1)

Bush Enterprise Collection Desks(1)

Alera Valencia Series Desks, Credenzas, Return/Bridges.(1)

 
Edge Detail Profile

Angled Front(8)

3mm Protective Edge Banding(3)

Radius Edge(3)

Sloped(1)

 
Overall Height

2 1/2"(8)

3"(6)

2"(4)

3 5/8"(1)

2 3/4"(1)

 
 
 

© 2017-2018 Gateway Business Products, All Rights Reserved