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_38` 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','out_of_stock') 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(409)

File Cabinets(274)

Desks(227)

Tables(104)

Shelving Units/Bookcases(78)

Credenzas(76)

Returns(76)

Contemporary - Laminate(69)

Storage Cabinets(58)

Hutches(52)

Partition & Panel Systems(23)

Table Bases/Legs(19)

Bridges(16)

File Shelves/Components(15)

Table Tops(15)

Utility Drawers(12)

Furniture Doors(11)

Metal Lateral Files(10)

Reception, Side & Guest Chairs(8)

Utility & Breakroom Tables(6)

Contemporary - Veneer(6)

Keyboard Drawers/Platforms(6)

Peninsulas(6)

Partition & Panel Systems Hardware(6)

Chair Arms(6)

Task Chairs(5)

File Cabinet Accessories(5)

Lamps(4)

Folding/Stacking Chairs & Carts(4)

Table Accessories(4)

Reception Seating & Sofas(4)

Furniture Hardware(4)

Executive/High Back Chairs(3)

Credenza Parts(3)

Printer/Fax Stands(3)

Storage Cabinet Accessories(3)

Reception Area & Accent Tables(3)

Desktop Organizers(3)

Carts(3)

Contemporary - Metal(3)

Desk Center Drawers(2)

Keyboard/Mouse Platforms & Trays(2)

Casters & Glides(2)

Chair Accessories(1)

Big & Tall Chairs(1)

Laminate Bookcases(1)

Power Supplies(1)

Cable Management(1)

Traditional - Laminate(1)

Foot Rests(1)

Management/Mid-Back Chairs(1)

Meeting & Conference Room Tables(1)

 
Brand

HON(1637)

basyx(19)

Sadie(1)

 
Color

Mahogany(158)

Light Gray(119)

Harvest(105)

Black(100)

Putty(85)

Charcoal(69)

Cognac(48)

Shaker Cherry(39)

Gray(29)

Pinnacle(28)

Mahogany/Charcoal(24)

Bourbon Cherry(22)

Silver Mesh/Light Gray(21)

Harvest/Putty(20)

Mocha(11)

Silver Mesh(11)

Henna Cherry(11)

Brilliant White(9)

Mocha/Black(8)

Columbian Walnut(7)

Mahogany; Charcoal(7)

Chestnut(7)

Natural Maple(7)

Gray Patterned/Charcoal(6)

White(6)

Wheat(6)

Platinum Metallic(5)

Harvest; Putty(5)

Silver/Black(3)

Black Leather(2)

Frosted(2)

Ash(2)

Gray Patterned; Charcoal(1)

Columbian Walnut/Black(1)

Silver/Frosted(1)

Mocha; Black(1)

Congnac(1)

Cherry(1)

Polished(1)

Silver(1)

Brushed Nickel(1)

Chrome(1)

Brushed Chrome(1)

Black/Silver(1)

Navy(1)

 
Recycled

Yes(107)

No(14)

 
Height

64.3"(6)

33.5"(5)

38.3"(3)

46.5"(3)

31.5"(2)

19.7"(2)

35.5"(2)

1.13"(2)

52.5"(2)

28"(2)

2.5"(2)

1.1"(2)

33.6"(1)

12"(1)

32.5"(1)

41.8"(1)

47.5"(1)

55"(1)

43.1"(1)

15.8"(1)

14.1"(1)

20"(1)

42"(1)

 
Color(s)

Black(1)

 
Depth

18"(10)

21.8"(5)

22.3"(2)

15"(2)

29.8"(2)

10.9"(2)

10"(2)

34.3"(2)

24"(2)

3.69"(2)

28"(1)

27.5"(1)

38.5"(1)

23"(1)

3"(1)

25.3"(1)

14.1"(1)

5"(1)

22"(1)

25.5"(1)

28.8"(1)

19.9"(1)

29"(1)

 
Quantity

1 each(264)

1 Each(6)

2 each(5)

2 per carton(4)

4 per carton(2)

1 pack of 2 per carton(1)

12 per pack(1)

 
Size

4 1/8w x 1 1/2d x 3/4h(1)

44.5w x 0.13d x 9.63h(1)

 
Overall Width

36"(180)

72"(101)

48"(66)

42"(66)

15"(66)

60"(65)

30"(44)

24"(22)

18.25"(21)

34.5"(20)

18"(15)

54"(9)

15.42"(9)

26"(8)

15.75"(8)

42.25"(6)

16"(6)

47"(6)

22"(4)

15 3/4"(4)

26.18"(4)

32.68"(4)

16 3/8"(3)

21.38"(3)

9.5"(3)

32 3/8"(3)

47.75"(3)

35.78"(3)

32.63"(3)

32.06"(3)

48.25"(3)

90"(2)

51.63"(2)

120"(2)

168"(2)

28"(2)

19"(2)

31.95"(2)

32"(2)

26 3/4"(2)

24.75"(2)

35.75"(2)

71 7/8"(2)

37.5"(2)

56.63"(2)

56 5/8"(2)

68 5/8"(2)

78"(2)

44.5"(1)

1.75"(1)

25"(1)

39.25"(1)

60 1/2"(1)

11 1/2"(1)

49"(1)

144"(1)

4.75"(1)

6 3/4"(1)

3 3/4"(1)

4.25"(1)

13.25"(1)

66"(1)

70"(1)

53.5"(1)

73"(1)

67"(1)

15.63"(1)

15 5/8"(1)

68.63"(1)

4 1/8"(1)

1.25"(1)

18 1/4"(1)

26.82"(1)

32.71"(1)

25.59"(1)

25.592"(1)

5 1/2"; 8"(1)

33 1/2"(1)

4"(1)

 
Overall Depth

18"(119)

24"(55)

20"(42)

19 1/4"(30)

26.5"(24)

13.13"(21)

25"(21)

14.63"(20)

12.63"(20)

30"(20)

11 1/2"(15)

14 5/8"(12)

15"(12)

19.88"(11)

36"(10)

20.41"(9)

11.5"(9)

22.75"(8)

18.13"(8)

16 3/4"(8)

28 1/2"(8)

22.88"(8)

48"(6)

13 3/4"(6)

14"(6)

15.38"(6)

16 7/8"(6)

19 7/8"(6)

22 7/8"(6)

13.5"(5)

13 1/8"(5)

14 1/4"(5)

28.5"(4)

12 3/4"(4)

13 1/2"(4)

24.25"(4)

14.75"(4)

26"(4)

13.81"(3)

23.5"(3)

28"(3)

23.88"(3)

12 1/2"(3)

1 3/8"(2)

26 3/4"(2)

20 11/16"(2)

31.95"(2)

15 7/8"(2)

32"(2)

28.75"(2)

18.88"(2)

5/8"(2)

15 3/8"(2)

35.5"(2)

0.75"(2)

14.31"(2)

20.5"(2)

21"(2)

14.25"(1)

19 3/4"(1)

7/8"(1)

15 1/8"(1)

29 3/4"(1)

12"(1)

13"(1)

34.25"(1)

10.25"(1)

0.13"(1)

12.75"(1)

16.13"(1)

22 3/4"(1)

1.75"(1)

4"(1)

18 7/8"(1)

33 1/2"(1)

1 1/2"(1)

1"(1)

25.59"(1)

6 1/2"(1)

 
Diameter

42"(12)

36"(5)

30"(4)

47"(3)

18"(3)

26"(2)

48"(2)

32"(1)

33"(1)

27"(1)

3"(1)

 
Base Color

Black(349)

Mahogany(35)

Silver(23)

Chrome(23)

Harvest(15)

Platinum(11)

Cognac(10)

Platinum Metallic(5)

Polished Aluminum(5)

Textured Satin Chrome(4)

Light Beige(2)

Shaker Cherry(2)

Pinnacle(2)

Titanium(2)

Steel(2)

Polished Chrome(1)

Nickel(1)

Gray(1)

 
 
 

© 2020-2021 NBJ Form & Function Inc. , All Rights Reserved