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

Currently Filtered by

Category

Batteries

Refine Search

  GO
 
Brand

HON(59)

Alera(14)

Bush(2)

Linea Italia(2)

Mayline(1)

 
Color

Mahogany(5)

Gray Steel(1)

 
Dimensions

29.5" Height x 72" Width x 36" Depth(1)

 
Drawer Type

Box(1)

File(1)

 
Total Number of Drawers

2(1)

 
Edge Style

Waterfall(1)

 
For Use With

Alera Valencia Series File Pedestals, Open Storage Hutch, Desk Shells, Reversible Return/Bridge Shells and Center Drawer(11)

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

Alera Valencia Series File Pedestals, Desk Shells, Open Storage Hutch, Reversible Return/Bridge Shells and Center Drawer(2)

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

HON 10500 Series Kingswood Walnut Single Pedestal Desks and Bridges(2)

HON 10500 Series Mahogany Single Pedestal Desks and Bridges(2)

HON 10500 Series Pinnacle Single Pedestal Desks and Bridges(2)

HON 38000 Series Bridge, Desk Shell, Peninsula, Return and File Pedestals(2)

To create a "U" workstation, you must order all three: the desk shell, the bridge and the credenza. To create an "L" configuration, you must order both: the return shell and the credenza.(2)

Linea Italia Urban Desks(2)

HON 10700 Series File Pedestals(1)

Mayline Medina Series(1)

 
Pedestal Position

Left(1)

 
Series Name

HON 38000 Series(18)

HON 10500 Series(15)

HON 10700 Series(15)

Alera Valencia Series(13)

HON Mod Series(4)

HON Metro Classic Series(3)

Bush Series C Collection(2)

HON Valido 11500 Series(2)

Linea Italia Urban Series(2)

HON 94000 Series(1)

Mayline Medina Series(1)

 
Country of Origin

US(60)

CN(14)

MX(2)

UM(1)

 
Color(s)

Mahogany(10)

Mahogany/Charcoal(7)

Cognac(7)

Harvest(7)

Harvest/Putty(5)

Sepia Walnut(4)

Silver Mesh/Light Gray(4)

Modern Walnut(3)

Gray(3)

Pinnacle(3)

Espresso(3)

Medium Cherry(3)

Natural Maple(2)

Gray Patterned(2)

Kingswood Walnut(2)

Ash(1)

Mocha/ Black(1)

Mocha/Black(1)

Hansen Cherry(1)

Mocha Cherry/Graphite Gray(1)

Natural Walnut(1)

 
Base Material

Woodgrain Laminate(38)

Metal(17)

Laminate(6)

Particleboard; Thermal Fused Laminate (TFL)(5)

Textured Woodgrain Laminate(3)

Engineered Wood(2)

Honeycomb; Laminate(2)

Honeycomb; Steel(2)

Steel(1)

MDF; Laminate(1)

 
Overall Width

72"(42)

60"(16)

70.88"(5)

59.13"(4)

65"(4)

71.13"(2)

30"(2)

35.25"(2)

 
Overall Height

29.5"(63)

29 1/2"(6)

29.88"(2)

21"(2)

29"(2)

23.75"(2)

 
Edge Detail Profile

Radius Edge(18)

Square Edge(18)

Rounded Corner; Waterfall Edge(15)

3 mm Protective Edge Banding(13)

Square(5)

PVC Protective Edge(2)

Ribbon Edge(2)

Traditional Edge(1)

Beveled Edge(1)

 
Top Material

High-Pressure Laminate(22)

Steel-Reinforced High-Pressure Laminate(14)

Thermally Fused Woodgrain Laminate(10)

Woodgrain Laminate(9)

Laminate(9)

Particleboard; Thermal Fused Laminate (TFL)(5)

Textured Woodgrain Laminate(3)

Thermally Fused Laminate Over Engineered Wood(2)

MDF; Laminate(1)

 
Top Thickness

1"(31)

1.13"(22)

1 1/8"(5)

1.5"(2)

0.75"(2)

 
Depth Maximum

24"(5)

20"(1)

 
Drawer Quantity

2(3)

4(2)

 
Drawer Configuration

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

Right: Box/File(6)

Left: Box/File(6)

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

Right: File/File(6)

Left: File/File(4)

File(2)

Box/File(1)

 
Pedestal Types

3/4-Height(35)

Full-Height(13)

Hanging: Full-Height(4)

 
Pedestal Count

2(30)

1(22)

0(4)

 
Number of Drawers

4(28)

2(20)

0(3)

1(2)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved