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(346)

Metal Lateral Files(147)

Task Chairs(129)

Reception, Side & Guest Chairs(89)

Contemporary - Metal(75)

Contemporary - Veneer(56)

Metal Vertical Files(52)

Folding/Stacking Chairs & Carts(44)

Laminate Bookcases(43)

Utility & Breakroom Tables(41)

Stools & Drafting Chairs(40)

Storage Cabinets(40)

Meeting & Conference Room Tables(36)

Executive/High Back Chairs(36)

Management/Mid-Back Chairs(30)

Mobile Pedestals(29)

Metal Bookcases(20)

Training Room Tables(14)

Desks(11)

File Cabinets(11)

Traditional - Laminate(11)

Returns(9)

Reception Area & Accent Tables(9)

Chairs/Stools(9)

Workstations/Computer Desks(7)

Keyboard/Mouse Platforms & Trays(7)

Work Surfaces(6)

Credenzas(5)

Big & Tall Chairs(5)

Legs(5)

Lamps(4)

Wood Lateral Files(4)

Panels/Partitions(4)

Desktop Organizers(4)

Desk Center Drawers(4)

Arm Sets(4)

Utility Drawers(3)

Desktop Risers(3)

Printer/Fax Stands(3)

Hanging Folder Frames(3)

Shelf(2)

Laminate Tops(2)

Base(2)

Warning Lights(2)

Open Shelf Files(2)

Furniture Doors(2)

Single Strut(2)

File Cabinet Accessories(2)

Panel System Hardware(2)

Headrest(1)

Mobile File Carts & Cabinets(1)

Cubicle / Partition Organizers & Accessories(1)

Dividers(1)

File Lock Kits(1)

Compact & Student Desks(1)

Shelving Units/Bookcases(1)

Insulated File Cabinets(1)

Cable Management(1)

Extension Cords(1)

Storage Cabinet Accessories(1)

Monitor Stands/Risers(1)

Casters(1)

Adjustable Worksurfaces(1)

Power Supplies(1)

Brand

HON(1422)

TRILITE INC(2)

TRILITE(1)

Color

Black(157)

Light Gray(93)

Putty(83)

Charcoal(62)

Mahogany(35)

Harvest(22)

Mariner(15)

Crimson Red(11)

Gray(9)

Laminate(9)

Mocha(9)

Navy(8)

Natural Maple(7)

Blue(7)

Platinum Metallic(6)

Natural(6)

Poppy(5)

Cognac(5)

Silver(5)

Walnut(5)

Cerulean(4)

White(4)

Wine(4)

Mahogany/Charcoal(4)

Burgundy(3)

Henna Cherry(3)

Columbian Walnut(2)

Bourbon Cherry(2)

Red(2)

Bittersweet(2)

Light Beige(2)

Morel(2)

Green(2)

Onyx(1)

Cherry(1)

Lucy Mist(1)

Oxblood(1)

Silver Metal(1)

Brushed Nickel(1)

Iron(1)

Olive Green(1)

Dark Gray(1)

Raven(1)

Charcoal Black(1)

Brushed Chrome(1)

Chrome(1)

Polished Aluminum(1)

Cranberry(1)

Mahogany; Charcoal(1)

Size

16" Width x 30" Depth x 28.50" Height(2)

36" Width x 2" Depth x 68" Height(1)

Size Supported

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

42" Lateral Drawer Letter/Legal Size(1)

Lateral File(1)

Recycled

Yes(1036)

No(142)

NO(1)

Price Range

$0-$499.99(983)

$500-$999.99(405)

$1000-$1499.99(44)

To  GO

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

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