facebook
 
 
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

Lorell(29)

Safco(21)

HON(20)

Children's Factory(4)

Boss(2)

Jonti-Craft(2)

Mayline(2)

MooreCo(1)

Hausmann(1)

Iceberg(1)

 
Color

Black(31)

Pewter(3)

Blue(3)

Green(2)

Chrome(2)

Espresso(2)

Real Red(1)

Natural(1)

White(1)

Dark Blue(1)

Orange(1)

Gray(1)

Pepper(1)

Malted(1)

Apple Green(1)

Ocean(1)

Periwinkle Blue(1)

Assorted(1)

Stratus(1)

Brown(1)

Buff(1)

Beige(1)

Maple(1)

Baltic(1)

Graphite(1)

Red(1)

Silver(1)

 
Recycled

No(63)

Yes(19)

 
Height

15"(8)

45"(5)

49.8"(4)

27"(4)

35"(4)

50.5"(3)

34"(3)

53"(3)

29.5"(2)

46"(2)

47"(2)

43.8"(2)

54"(2)

44.3"(2)

31.4"(2)

31.3"(2)

22"(2)

49"(2)

48"(2)

33"(1)

49.5"(1)

25"(1)

21"(1)

19"(1)

41"(1)

50.3"(1)

32"(1)

52.5"(1)

24"(1)

42.9"(1)

51"(1)

22.5"(1)

18"(1)

44"(1)

52.8"(1)

49.4"(1)

36"(1)

55"(1)

9"(1)

52"(1)

49.9"(1)

 
Depth

25"(16)

20.5"(4)

26"(4)

24"(4)

15"(4)

21.3"(4)

22"(3)

30"(3)

18.5"(2)

23"(2)

17.5"(2)

29"(2)

27"(2)

28.8"(2)

27.3"(2)

27.5"(2)

24.5"(2)

16.5"(1)

12"(1)

24.3"(1)

19.3"(1)

11"(1)

23.8"(1)

25.8"(1)

16"(1)

22.9"(1)

13.5"(1)

26.4"(1)

 
Diameter

24"(2)

23"(1)

18"(1)

26"(1)

16"(1)

 
Manufacturer Part Number

34430(1)

83119A204(1)

ESS2B(1)

99866(1)

99865(1)

99589(1)

99588(1)

84588(1)

83119A205(1)

83119A203(1)

1205BE(1)

83119A201(1)

83119(1)

83101(1)

80010(1)

80009(1)

80008(1)

69513(1)

69511(1)

ESS2W(1)

1205BL(1)

4310004(1)

6660BL(1)

6680(1)

6666SL(1)

6666(1)

6665(1)

6664SL(1)

6664(1)

6661BL(1)

5117(1)

3395BL(1)

4299ES(1)

4299BH(1)

3442BL(1)

3437BL(1)

3434BL(1)

3432BL(1)

3406BL(1)

3401BL(1)

59522(1)

4310003(1)

B16245BG(1)

5905CU10T(1)

QTSMY1ACU10(1)

MTS11EA11(1)

MTS01EA11(1)

IT109CU10(1)

IT108CU10(1)

5905CU98T(1)

5905CU19T(1)

2000(1)

SCS2FECU98B(1)

910011(1)

910009(1)

910008(1)

910007(1)

VL528ES10(1)

VL515LH10(1)

VL215MM10(1)

B16245BK(1)

SCS2FECU10B(1)

SCS2FEUR10B(1)

4310002(1)

20992(1)

43100010(1)

4310001(1)

43100009(1)

43100008(1)

43100007(1)

43100(1)

30954(1)

20991(1)

SCS2NECU10B(1)

5910JC2(1)

3769JC(1)

64527(1)

SVSU1ACLC10T(1)

SVSR1ACLC10T(1)

SVSM1ALC10T(1)

SCS2NEUR10B(1)

SCS2NECU98B(1)

7084BL(1)

 
Country of Origin

United States(29)

Taiwan(26)

China(25)

Poland(2)

Vietnam(1)

 
Width

25"(10)

27"(8)

21.5"(7)

24.3"(4)

17.5"(4)

23.3"(4)

29.8"(4)

15"(4)

26.8"(3)

24"(3)

20.5"(3)

16"(3)

26"(3)

27.5"(2)

20.8"(2)

21.8"(2)

15.3"(1)

18.5"(1)

23"(1)

23.6"(1)

28.1"(1)

26.6"(1)

13"(1)

14"(1)

16.5"(1)

 
Material

Polyethylene(4)

Bent Plywood(2)

Plywood(2)

Bentwood(2)

Polyurethane(2)

Leather(2)

Steel(1)

Acrylic(1)

Solid Hardwood(1)

Metal(1)

Wood(1)

Vinyl(1)

 
Limited Warranty

Lifetime(37)

5 Year(17)

6 Year(2)

3 Year(1)

15 Year(1)

 
Weight (Approximate)

23 lb(3)

16 lb(2)

30 lb(2)

11.20 lb(2)

37 lb(1)

29 lb(1)

20 lb(1)

19 lb(1)

10 lb(1)

33 lb(1)

1.76 oz(1)

22 lb(1)

13 lb(1)

 
Seat Material

Fabric(14)

Vinyl(12)

Polyurethane(5)

Olefin(4)

Polyester(4)

Crepe Fabric(4)

Polymer(3)

Foam(3)

Leather(3)

Plastic(2)

Beech Plywood(2)

Urethane(1)

Polyethylene(1)

Medium Density Fiber (MDF)(1)

Acrylic(1)

Steel(1)

 
Seat Color

Black(27)

Navy(3)

Espresso(2)

Beige(1)

Fern Green(1)

Beech(1)

Vinyl Black(1)

White(1)

Dark Blue(1)

Orange(1)

Gray(1)

Blue(1)

Pepper(1)

Malted(1)

Real Red(1)

Periwinkle Blue(1)

Iron(1)

Silver(1)

 
Seat Width

18"(4)

19"(4)

16"(3)

20"(3)

19.10"(2)

17.75"(2)

17"(1)

20.10"(1)

13"(1)

18.25"(1)

16.25"(1)

20.50"(1)

 
Maximum Seat Height

32"(6)

33"(5)

27"(5)

9"(4)

31.87"(3)

15"(2)

29"(2)

29.75"(2)

34"(2)

33.50"(2)

10"(1)

32.70"(1)

32.68"(1)

30"(1)

35.50"(1)

22"(1)

18"(1)

 
Seat Depth

16"(5)

18"(4)

16.50"(2)

17.50"(2)

18.50"(2)

20.10"(2)

19.50"(2)

13"(1)

17"(1)

16.25"(1)

14"(1)

19"(1)

 
Base Shape

5-star(35)

Four-legged(15)

Square(1)

 
Back Height

22"(3)

17.75"(3)

14"(2)

7"(2)

17.30"(1)

18.50"(1)

20.50"(1)

15.50"(1)

16"(1)

9"(1)

12"(1)

19"(1)

 
Number of Casters

5(33)

4(1)

 
Maximum Load Capacity

250 lb(35)

300 lb(24)

275 lb(3)

 
Minimum Seat Height

22"(6)

23"(5)

6"(4)

21.75"(3)

28"(2)

23.50"(2)

24.50"(1)

23.75"(1)

24"(1)

25.40"(1)

25.39"(1)

21"(1)

17"(1)

 
Base Material

Nylon(18)

Chrome(7)

Steel(6)

Plastic(4)

Aluminum(2)

 
Number of Legs

4(17)

5(1)

 
Adjustable Arm

Yes(17)

 
Seat Thickness

0.63"(1)

3.50"(1)

 
Arm Material

Polyurethane(2)

Fabric(1)

Nylon(1)

 
Arm Height

11.50"(2)

11"(1)

11.36"(1)

11.25"(1)

42.50"(1)

 
Adjustable Back

Yes(11)

 
Back Type

Mid Back(10)

Low Back(2)

 
Certifications & Standards

ANSI/BIFMA

(2)

 
Seat Height

22"(2)

22.75"(1)

22.25"(1)

21"(1)

 
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)

 
Seat Diameter

16"(3)

13.50"(1)

14"(1)

 
Product Type

Sitting Stool(45)

Chair(28)

Stool(10)

 
Packaged Quantity

1 Each(66)

2 / Carton(8)

1 / Each(6)

4 / Set(1)

4 / Carton(1)

 
Assembly Required

Yes(47)

No(36)

 
Product Model

H5905(3)

16245(2)

ESS2(2)

HVL215(1)

HVL515(1)

HVL528(1)

2000(1)

3437BL(1)

4299BH(1)

4299ES(1)

6664SL(1)

6666SL(1)

 
Product Line

Accommodate(6)

Hospitality(4)

Diesel(4)

ComforTask(3)

Solve(3)

Ignition(2)

Bosk(2)

Precision(2)

Escalate(2)

Vue(1)

Soft Tough(1)

Sit-Star(1)

TaskMaster(1)

Metro(1)

ValuTask(1)

AlphaBetter(1)

Torch(1)

USA Seating(1)

KYDZ(1)

SideKick(1)

CaféWorks(1)

Quotient(1)

Instigate(1)

Apprentice II(1)

 
Chair/Seat Type

Utility Stool(28)

Drafting Chair(22)

Toddler/Kid Chair(4)

Bar Stool(4)

Task Chair(3)

Multipurpose Seat(2)

Bar Chair(2)

Storage Stool(1)

Ladderback Chair(1)

Cushion Seat(1)

 
Back Width

16"(3)

18"(2)

17"(2)

16.25"(2)

12"(2)

19"(1)

18.90"(1)

17.13"(1)

19.30"(1)

17.25"(1)

14.50"(1)

18.50"(1)

 
Frame Color

Black(10)

Powder Coated(7)

Textured Black(4)

Silver(4)

Pewter(1)

 
Back Material

Plastic(7)

Fabric(3)

Polymer(3)

Olefin(3)

Vinyl(3)

Polyester Fabric(2)

Leather(2)

Urethane(1)

Polyethylene(1)

Polyurethane(1)

Nylon(1)

Foam(1)

 
Adjustable Seat

Yes(39)

 
Frame Material

Steel(14)

Tubular Steel(7)

Powder Coated Steel(2)

Plastic(2)

Chrome Plated Steel(2)

Epoxy(2)

Metal(1)

 
Back Color

Black(13)

Beige(1)

Iron(1)

Navy(1)

White(1)

Silver(1)

 
Caster Size

2"(6)