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

Currently Filtered by


HON

Refine Search

  GO
 
Category Filter

Chairs/Stools(312)

File Cabinets(262)

Desks(237)

Tables(120)

Credenzas(95)

Returns(83)

Shelving Units/Bookcases(79)

Contemporary - Laminate(64)

Hutches(58)

Partition & Panel Systems(34)

Storage Cabinets(32)

Bridges(19)

Utility Drawers(16)

Table Bases/Legs(11)

Metal Lateral Files(10)

Furniture Doors(10)

Table Tops(9)

Partition & Panel Systems Hardware(9)

Peninsulas(8)

Task Chairs(6)

Utility & Breakroom Tables(6)

Reception, Side & Guest Chairs(6)

Contemporary - Veneer(6)

Keyboard Drawers/Platforms(5)

File Cabinet Accessories(5)

Furniture Hardware(4)

Chair Arms(4)

Reception Seating & Sofas(4)

Folding/Stacking Chairs & Carts(4)

Partition & Panel Accessories(4)

Printer/Fax Stands(3)

Desktop Organizers(3)

Lamps(3)

Table Accessories(3)

Meeting & Conference Room Tables(3)

Executive/High Back Chairs(3)

Reception Area & Accent Tables(3)

Carts(3)

Foot Rests(3)

Contemporary - Metal(3)

Keyboard/Mouse Platforms & Trays(2)

Credenza Parts(2)

Casters & Glides(2)

Storage Cabinet Accessories(2)

Desk Center Drawers(2)

Laminate Bookcases(1)

Traditional - Laminate(1)

Management/Mid-Back Chairs(1)

Cable Management(1)

Power Supplies(1)

Big & Tall Chairs(1)

Chair Accessories(1)

 
Brand

HON(1562)

basyx(6)

Sadie(1)

 
Color

Mahogany(151)

Harvest(103)

Light Gray(91)

Black(85)

Putty(76)

Bourbon Cherry(72)

Natural Maple(72)

Charcoal(58)

Cognac(48)

Shaker Cherry(32)

Gray(30)

Mahogany/Charcoal(29)

Pinnacle(28)

Silver Mesh/Light Gray(22)

Harvest/Putty(20)

Chestnut(11)

Wheat(9)

Mocha/Black(8)

Mocha(7)

Mahogany; Charcoal(7)

White(6)

Harvest; Putty(5)

Gray Patterned(4)

Henna Cherry(3)

Brilliant White(3)

Silver/Black(3)

Black Leather(2)

Silver/Frosted(2)

Platinum Metallic(2)

Steel Mesh(2)

Ash(2)

Navy(1)

Brushed Nickel(1)

Polished(1)

Chrome(1)

Cherry(1)

Mocha; Black(1)

Black/Silver(1)

Silver(1)

Silver Mesh(1)

Congnac(1)

Brushed Chrome(1)

 
Recycled

Yes(98)

No(19)

 
Height

64.3"(6)

33.5"(5)

1.1"(2)

19.7"(2)

35.5"(2)

53.3"(2)

1.13"(2)

38.3"(2)

28.4"(2)

46.5"(2)

2.5"(2)

32.5"(1)

9"(1)

42"(1)

50"(1)

31.5"(1)

2"(1)

5"(1)

15.8"(1)

47.8"(1)

41.8"(1)

43.1"(1)

55"(1)

20"(1)

47.5"(1)

14.1"(1)

43.5"(1)

 
Color(s)

Light Gray(4)

Black(1)

 
Depth

18"(10)

21.8"(5)

30.8"(3)

10"(2)

10.9"(2)

24"(2)

3.69"(2)

15"(2)

25.5"(1)

27.5"(1)

22.3"(1)

9 1/2"(1)

1 1/2"(1)

1 1/4"(1)

14.1"(1)

28"(1)

19.9"(1)

28.8"(1)

38.5"(1)

23"(1)

29.8"(1)

25.3"(1)

3"(1)

34.3"(1)

29"(1)

 
Quantity

1 each(25)

2/Carton(13)

4/Carton(10)

2/Pack(2)

2 each(2)

 
Size

39.5w x 0.13d x 27.25h(1)

44.5w x 0.13d x 9.63h(1)

56 1/2w x 1/8d x 9 5/8h(1)

 
Overall Width

36"(177)

72"(124)

48"(74)

42"(69)

60"(67)

15"(43)

30"(38)

18.25"(26)

34 1/2"(20)

24"(15)

15.75"(15)

54"(14)

47"(11)

15.42"(9)

18"(8)

16"(8)

26"(7)

22"(6)

42 1/4"(6)

26.18"(4)

32.68"(4)

28"(4)

56.63"(4)

19"(3)

47.75"(3)

48 1/4"(3)

32.06"(3)

35.78"(3)

24.75"(3)

21.38"(3)

32.63"(3)

68.63"(3)

9.5"(3)

16 3/8"(2)

15.63"(2)

31.95"(2)

51 5/8"(2)

11.5"(1)

2"(1)

4.25"(1)

39.5"(1)

44.5"(1)

13.25"(1)

1 3/4"(1)

56 1/2"(1)

120"(1)

168"(1)

6.75"(1)

1.25"(1)

39 1/4"(1)

53.5"(1)

26.82"(1)

33 1/2"(1)

67"(1)

4"(1)

25"(1)

56 5/8"(1)

68 5/8"(1)

32 3/8"(1)

78"(1)

31"(1)

35.75"(1)

32.71"(1)

4.75"(1)

35 3/4"(1)

70"(1)

37 1/2"(1)

3"(1)

73"(1)

25.592"(1)

25.59"(1)

37.5"(1)

 
Overall Depth

18"(126)

20"(51)

24"(51)

30"(36)

14.63"(34)

13 1/8"(32)

26.5"(24)

12 5/8"(20)

11 1/2"(19)

19 1/4"(18)

25"(13)

22.75"(13)

19.88"(11)

15"(11)

28.5"(10)

22.88"(10)

20.41"(9)

18 1/8"(8)

36"(8)

15.38"(8)

14 5/8"(7)

18.88"(5)

13.5"(5)

60"(5)

14.75"(5)

12.75"(5)

72"(4)

24 1/4"(4)

13.81"(3)

23.88"(3)

14.25"(3)

23 1/2"(3)

14 1/4"(3)

28"(3)

48"(3)

12"(2)

29.5"(2)

5"(2)

14"(2)

31.95"(2)

26"(2)

15 3/8"(2)

0.75"(2)

13"(2)

12 1/2"(2)

21"(2)

0.13"(2)

35.5"(2)

28.75"(2)

22"(1)

0.88"(1)

1 1/16"(1)

14 1/2"(1)

10.25"(1)

1/8"(1)

13 1/2"(1)

34.25"(1)

20 1/2"(1)

1 3/4"(1)

4"(1)

14.31"(1)

20.5"(1)

14 5/16"(1)

1"(1)

14 3/4"(1)

16.13"(1)

25.59"(1)

33 1/2"(1)

 
Diameter

42"(10)

36"(6)

30"(4)

47"(3)

48"(3)

18"(3)

22"(1)

28"(1)

26"(1)

33"(1)

27"(1)

3"(1)

 
Base Color

Black(287)

Chrome(23)

Silver(22)

Mahogany(21)

Platinum(9)

Harvest(9)

Polished Aluminum(5)

Cognac(3)

Shaker Cherry(2)

Pinnacle(2)

Titanium(2)

Steel(2)

Polished Chrome(1)

Nickel(1)

Gray(1)