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

Currently Filtered by

Category

Stools And Drafting Chairs

Refine Search

  GO
 
Brand

HON(34)

Lorell(34)

Safco(25)

Mayline(2)

MooreCo(1)

Hausmann(1)

Iceberg(1)

 
Color

Black(32)

Green(4)

Pewter(3)

Silver(3)

White(2)

Beige(2)

Espresso(2)

Ash(2)

Blue(2)

Chrome(2)

Natural(1)

Dark Blue(1)

Orange(1)

Gray(1)

Real Red(1)

Pepper(1)

Malted(1)

Graphite(1)

Periwinkle Blue(1)

Apple Green(1)

Stratus(1)

Brown(1)

Buff(1)

Ocean(1)

 
Recycled

No(64)

Yes(33)

 
Packaged Quantity

1 Each(85)

2 / Carton(6)

4 / Carton(3)

1 / Each(2)

1 / Carton(1)

 
Assembly Required

Yes(62)

No(36)

 
Limited Warranty

Lifetime(44)

5 Year(23)

2 Year(3)

3 Year(1)

15 Year(1)

 
Weight (Approximate)

23 lb(3)

30 lb(3)

11.20 lb(3)

16 lb(2)

37 lb(1)

19 lb(1)

10 lb(1)

28 lb(1)

33 lb(1)

1.76 oz(1)

22 lb(1)

13 lb(1)

 
Chair/Seat Type

Utility Stool(48)

Drafting Chair(23)

Task Chair(4)

Bar Stool(4)

Multipurpose Seat(2)

Bar Chair(2)

 
Maximum Seat Height

32.75"(12)

35.40"(9)

33"(7)

27"(6)

32"(5)

31.87"(3)

29"(3)

33.50"(2)

22"(2)

15"(2)

29.75"(2)

31"(1)

30"(1)

32.68"(1)

43.09"(1)

35.50"(1)

 
Base Shape

5-star(40)

Four-legged(18)

Square(1)

 
Back Height

21.50"(12)

22"(3)

17.75"(3)

16"(3)

14"(2)

9"(2)

7"(2)

29"(1)

18.50"(1)

20.50"(1)

15.50"(1)

12"(1)

19"(1)

 
Number of Casters

5(37)

4(1)

 
Adjustable Seat

Yes(53)

 
Minimum Seat Height

22.75"(12)

25.20"(9)

23"(6)

22"(6)

21.75"(3)

17"(2)

23.50"(2)

24.50"(1)

23.75"(1)

24"(1)

25.39"(1)

25.47"(1)

21"(1)

36"(1)

 
Number of Legs

4(20)

5(1)

 
Back Color

Black(20)

Charcoal(8)

Iron(1)

Navy(1)

Frost(1)

White(1)

Silver(1)

 
Adjustable Arm

Yes(32)

 
Seat Thickness

0.63"(1)

3.50"(1)

 
Arm Material

Polyurethane(2)

Fabric(1)

Nylon(1)

 
Arm Height

11"(2)

11.50"(2)

11.36"(1)

11.25"(1)

42.50"(1)

 
Adjustable Back

Yes(10)

 
Diameter

24"(2)

23"(1)

18"(1)

26"(1)

16"(1)

 
Arm Color

Black(1)

 
Back Type

Mid Back(13)

Low Back(2)

 
Caster Size

2"(6)

 
Adjustment

17.50" to 22.75" - Seat(1)

17" to 22.25" - Seat(1)

17" to 25" - Seat(1)

16" to 21" - Seat(1)

16" to 21"(1)

27" to 34" - Seat(1)

22" to 27" - Seat(1)

 
Manufacturer Part Number

34430(1)

83119A203(1)

ESS2B(1)

99866(1)

99865(1)

99589(1)

99588(1)

84588(1)

83119A206(1)

83119A205(1)

83119A204(1)

83119A202(1)

1205BE(1)

83119A201(1)

83119A200(1)

83119(1)

83101(1)

80010(1)

80009(1)

69513(1)

69511(1)

59523(1)

ESS2W(1)

1205BL(1)

59521(1)

5110(1)

6680(1)

6666SL(1)

6666(1)

6665(1)

6664SL(1)

6664(1)

6661BL(1)

6660BL(1)

5117(1)

4299ES(1)

3395BL(1)

4299CY(1)

4299BH(1)

3442GR(1)

3442BV(1)

3442BL(1)

3437BL(1)

3434BL(1)

3432BL(1)

3406BL(1)

3401BL(1)

59522(1)

54856(1)

VL215MM10(1)

MTS11EA11(1)

SVSM1ALC19T(1)

SVSM1ALC10T(1)

SCS2NEUR10B(1)

SCS2NECU98B(1)

SCS2NECU10B(1)

SCS2FEUR10B(1)

SCS2FECU98B(1)

SCS2FECU10B(1)

QTSMY1ACU10(1)

MTS01EA11(1)

SVSM1ALC46T(1)

IT109CU10(1)

IT108CU10(1)

IC108NT10(1)

I2UL2AC22TK(1)

5905CU98T(1)

5905CU19T(1)

5905CU10T(1)

2000(1)

VL528ES10(1)

VL515LH10(1)

SVSM1ALC22T(1)

SVSM1ALC82T(1)

4310004(1)

25981(1)

4310003(1)

4310002(1)

43100010(1)

4310001(1)

43100009(1)

43100008(1)

43100007(1)

43100(1)

30954(1)

20992(1)

SVSR1ACLC10T(1)

64527(1)

SVSU1ACLC82T(1)

SVSU1ACLC46T(1)

SVSU1ACLC22T(1)

SVSU1ACLC19T(1)

SVSU1ACLC10T(1)

SVSR1ACLC82T(1)

SVSR1ACLC46T(1)

SVSR1ACLC22T(1)

SVSR1ACLC19(1)

7084BL(1)

 
Country of Origin

United States(42)

Taiwan(27)

China(25)

Poland(3)

Canada(1)

 
Material

Metal(3)

Bent Plywood(2)

Plywood(2)

Bentwood(2)

Polyurethane(2)

Leather(2)

Steel(1)

Wood(1)

Vinyl(1)

 
Height

52.8"(13)

45"(8)

35"(5)

27"(4)

49"(4)

49.8"(4)

15"(4)

53"(3)

34"(3)

24"(3)

54"(2)

43.8"(2)

46"(2)

50.5"(2)

48"(2)

29.5"(2)

44"(2)

44.3"(2)

31.3"(2)

22"(2)

31.4"(2)

44.5"(1)

41"(1)

19"(1)

52"(1)

21"(1)

25"(1)

33"(1)

9"(1)

49.5"(1)

47"(1)

42.9"(1)

55"(1)

49.9"(1)

50.3"(1)

36"(1)

52.5"(1)

49.4"(1)

30"(1)

26.1"(1)

32"(1)

 
Width

29.5"(12)

21.5"(10)

27"(9)

25"(8)

26"(5)

23.3"(4)

24.3"(4)

29.8"(4)

16"(4)

17.5"(4)

20.5"(3)

20.8"(3)

26.8"(3)

24"(2)

21.8"(2)

27.5"(2)

15.3"(1)

18.5"(1)

28.1"(1)

56"(1)

23.6"(1)

18"(1)

23"(1)

25.5"(1)

14"(1)

16.5"(1)

 
Depth

25"(16)

29.5"(12)

26"(6)

20.5"(5)

15"(4)

21.3"(4)

24"(3)

16"(3)

30"(3)

22"(3)

29"(3)

23"(2)

27"(2)

17.5"(2)

28.8"(2)

27.3"(2)

27.5"(2)

24.5"(2)

19.3"(1)

24.3"(1)

12"(1)

16.5"(1)

18.5"(1)

25.8"(1)

28"(1)

22.9"(1)

25.5"(1)

28.5"(1)

11"(1)

23.8"(1)

26.4"(1)

 
Seat Color

Black(29)

Navy(3)

Sterling(3)

Putty(3)

Bittersweet(3)

Meadow(3)

Gray(2)

Ash(2)

Silver(2)

Real Red(1)

Malted(1)

Pepper(1)

Iron(1)

Periwinkle Blue(1)

Blue(1)

Beige(1)

Fern Green(1)

Frost(1)

Orange(1)

Dark Blue(1)

White(1)

Vinyl Black(1)

Beech(1)

Cherry(1)

Espresso(1)

 
Seat Material

Fabric(28)

Vinyl(14)

Crepe Fabric(6)

Polyurethane(6)

Olefin(4)

Polyester(4)

Beech Plywood(3)

Polymer(3)

Foam(3)

Leather(3)

Plastic(2)

Acrylic(2)

Urethane(1)

Wood(1)

Medium Density Fiber (MDF)(1)

Polyethylene(1)

Steel(1)

 
Seat Width

19"(16)

20"(4)

18"(4)

18.25"(3)

17.75"(2)

16.25"(2)

17"(1)

19.10"(1)

20.10"(1)

13"(1)

20.50"(1)

 
Seat Depth

19.25"(12)

18"(4)

16"(3)

17"(3)

16.50"(2)

17.50"(2)

19"(2)

19.50"(2)

16.25"(2)

20.10"(1)

18.50"(1)

13"(1)

14"(1)

 
Back Width

18.25"(12)

16"(3)

19"(2)

18"(2)

17"(2)

16.25"(2)

17.25"(2)

14.50"(2)

12"(2)

17.13"(1)

19.30"(1)

17.50"(1)

18.50"(1)

 
Frame Color

Black(25)

Powder Coated(12)

Textured Black(4)

Silver(4)

Pewter(1)

 
Maximum Load Capacity

300 lb(42)

250 lb(35)

275 lb(3)

 
Back Material

Plastic(10)

Fabric(4)

Vinyl(4)

Polymer(3)

Olefin(3)

Polyester Fabric(2)

Leather(2)

Urethane(1)

Polyethylene(1)

Polyurethane(1)

Nylon(1)

Foam(1)

 
Frame Material

Steel(15)

Tubular Steel(10)

Chrome Plated Steel(3)

Epoxy(3)

Powder Coated Steel(2)

Plastic(1)

Metal(1)

 
Base Material

Nylon(20)

Chrome(7)

Steel(6)

Plastic(5)

Aluminum(4)

 
Seat Height

22"(2)

22.75"(1)

22.25"(1)

21"(1)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved