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

Currently Filtered by

Manufacturer

The HON Company

Refine Search

  GO
Category

Contemporary - Laminate(351)

Metal Lateral Files(145)

Task Chairs(126)

Reception, Side & Guest Chairs(87)

Contemporary - Metal(71)

Contemporary - Veneer(53)

Metal Vertical Files(51)

Folding/Stacking Chairs & Carts(43)

Stools & Drafting Chairs(40)

Utility & Breakroom Tables(40)

Laminate Bookcases(35)

Executive/High Back Chairs(35)

Meeting & Conference Room Tables(35)

Storage Cabinets(34)

Management/Mid-Back Chairs(31)

Mobile Pedestals(27)

Metal Bookcases(20)

Training Room Tables(14)

Traditional - Laminate(11)

Reception Area & Accent Tables(9)

Workstations/Computer Desks(7)

Keyboard/Mouse Platforms & Trays(7)

Work Surfaces(6)

Big & Tall Chairs(5)

Legs(5)

Desktop Organizers(4)

Arm Sets(4)

Desk Center Drawers(4)

Printer/Fax Stands(4)

Desks(4)

Wood Lateral Files(4)

Warning Lights(3)

File Cabinets(3)

Hanging Folder Frames(3)

Desktop Risers(3)

Chairs/Stools(3)

Panels/Partitions(3)

Lamps(3)

Shelf(2)

Open Shelf Files(2)

Panel System Hardware(2)

Laminate Tops(2)

Single Strut(2)

Headrest(1)

Cubicle / Partition Organizers & Accessories(1)

Mobile File Carts & Cabinets(1)

Monitor Stands/Risers(1)

File Lock Kits(1)

Utility Drawers(1)

Base(1)

Returns(1)

File Cabinet Accessories(1)

Extension Cords(1)

Storage Cabinet Accessories(1)

Dividers(1)

Casters(1)

Adjustable Worksurfaces(1)

Power Supplies(1)

Brand

HON(1286)

Color

Black(135)

Putty(80)

Light Gray(75)

Charcoal(53)

Mahogany(30)

Mariner(14)

Harvest(13)

Crimson Red(10)

Mocha(9)

Laminate(9)

Gray(8)

Navy(8)

Natural Maple(7)

Blue(6)

Natural(6)

Walnut(5)

Poppy(5)

Cognac(5)

Burgundy(4)

Cerulean(4)

White(4)

Platinum Metallic(4)

Silver(3)

Wine(3)

Bourbon Cherry(2)

Red(2)

Light Beige(2)

Chrome(2)

Morel(2)

Bittersweet(2)

Silver Metal(1)

Onyx(1)

Lucy Mist(1)

Cherry(1)

Iron(1)

Oxblood(1)

Dark Gray(1)

Garnet(1)

Charcoal Black(1)

Green(1)

Olive Green(1)

Polished Aluminum(1)

Cranberry(1)

Brushed Nickel(1)

Size Supported

8.50" to 11" Lateral File Letter Size(1)

42" Lateral Drawer Letter/Legal Size(1)

Lateral File(1)

Recycled

Yes(966)

No(151)

Price Range

$0-$499.99(938)

$500-$999.99(393)

$1000-$1499.99(45)

$1500-$1999.99(8)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2018-2019 Shop Our Solutions is a Division of American Office Solutions,Inc., All Rights Reserved