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_36` 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(32)

Safco(21)

HON(20)

Mayline(2)

MooreCo(1)

Hausmann(1)

Iceberg(1)

 
Color

Black(31)

Pewter(3)

Beige(2)

Espresso(2)

Ash(2)

Blue(2)

Chrome(2)

Pepper(1)

Natural(1)

White(1)

Dark Blue(1)

Orange(1)

Gray(1)

Real Red(1)

Malted(1)

Ocean(1)

Periwinkle Blue(1)

Apple Green(1)

Green(1)

Stratus(1)

Brown(1)

Buff(1)

Graphite(1)

Silver(1)

 
Recycled

No(58)

Yes(19)

 
Packaged Quantity

1 Each(66)

2 / Carton(7)

1 / Each(3)

4 / Carton(1)

 
Assembly Required

Yes(45)

No(33)

 
Limited Warranty

Lifetime(36)

5 Year(16)

3 Year(1)

15 Year(1)

 
Weight (Approximate)

23 lb(3)

16 lb(2)

30 lb(2)

11.20 lb(2)

37 lb(1)

19 lb(1)

10 lb(1)

33 lb(1)

1.76 oz(1)

22 lb(1)

13 lb(1)

 
Chair/Seat Type

Utility Stool(31)

Drafting Chair(20)

Bar Stool(4)

Task Chair(3)

Multipurpose Seat(2)

Bar Chair(2)

Cushion Seat(1)

 
Maximum Seat Height

32"(6)

33"(5)

27"(5)

31.87"(3)

33.50"(2)

15"(2)

29"(2)

29.75"(2)

30"(1)

40.16"(1)

32.68"(1)

35.50"(1)

22"(1)

 
Base Shape

5-star(35)

Four-legged(18)

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)

 
Adjustable Seat

Yes(37)

 
Minimum Seat Height

22"(6)

23"(5)

21.75"(3)

23.50"(2)

24.50"(1)

23.75"(1)

24"(1)

32.70"(1)

25.39"(1)

21"(1)

17"(1)

 
Number of Legs

4(20)

5(1)

 
Back Color

Black(15)

Iron(1)

Navy(1)

White(1)

Silver(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(9)

 
Diameter

24"(2)

23"(1)

18"(1)

26"(1)

16"(1)

 
Back Type

Mid Back(10)

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)

84588(1)

ESS2W(1)

ESS2B(1)

99866(1)

99865(1)

99589(1)

99588(1)

83119A206(1)

1205BL(1)

83119A205(1)

83119A204(1)

83119A203(1)

83119A202(1)

83119A201(1)

83119A200(1)

83119(1)

1205BE(1)

3395BL(1)

80010(1)

6660BL(1)

6680(1)

6666SL(1)

6666(1)

6665(1)

6664SL(1)

6664(1)

6661BL(1)

5117(1)

3401BL(1)

4299ES(1)

4299BH(1)

3442BL(1)

3437BL(1)

3434BL(1)

3432BL(1)

3406BL(1)

83101(1)

80009(1)

VL215MM10(1)

MTS01EA11(1)

SCS2NECU98B(1)

SCS2NECU10B(1)

SCS2FEUR10B(1)

SCS2FECU98B(1)

SCS2FECU10B(1)

QTSMY1ACU10(1)

MTS11EA11(1)

IT109CU10(1)

SVSM1ALC10T(1)

IT108CU10(1)

5905CU98T(1)

5905CU19T(1)

5905CU10T(1)

2000(1)

VL528ES10(1)

VL515LH10(1)

SCS2NEUR10B(1)

SVSR1ACLC10T(1)

80008(1)

4310001(1)

69513(1)

69511(1)

59522(1)

4310004(1)

4310003(1)

4310002(1)

43100010(1)

43100009(1)

SVSU1ACLC10T(1)

43100008(1)

43100007(1)

43100(1)

30954(1)

20992(1)

20991(1)

64527(1)

7084BL(1)

 
Country of Origin

United States(27)

Taiwan(26)

China(23)

Poland(2)

 
Material

Bent Plywood(2)

Plywood(2)

Bentwood(2)

Polyurethane(2)

Leather(2)

Steel(1)

Metal(1)

Wood(1)

Vinyl(1)

 
Height

45"(8)

15"(4)

27"(4)

49.8"(4)

35"(4)

53"(3)

34"(3)

50.5"(3)

49"(2)

54"(2)

43.8"(2)

46"(2)

48"(2)

29.5"(2)

22"(2)

31.4"(2)

44.3"(2)

31.3"(2)

44"(1)

41"(1)

19"(1)

52"(1)

21"(1)

25"(1)

33"(1)

9"(1)

49.5"(1)

36"(1)

55"(1)

51"(1)

49.4"(1)

50.3"(1)

52.5"(1)

24"(1)

52.8"(1)

42.9"(1)

49.9"(1)

32"(1)

 
Width

21.5"(10)

25"(8)

27"(8)

23.3"(4)

17.5"(4)

24.3"(4)

29.8"(4)

26"(3)

24"(3)

26.8"(3)

20.5"(3)

27.5"(2)

20.8"(2)

21.8"(2)

16"(2)

15.3"(1)

18.5"(1)

26.6"(1)

23.6"(1)

28.1"(1)

23"(1)

14"(1)

16.5"(1)

 
Depth

25"(17)

20.5"(4)

26"(4)

24"(4)

15"(4)

21.3"(4)

30"(3)

22"(3)

17.5"(2)

27"(2)

29"(2)

24.5"(2)

28.8"(2)

27.3"(2)

27.5"(2)

23"(2)

24.3"(1)

19.3"(1)

12"(1)

16.5"(1)

18.5"(1)

25.8"(1)

16"(1)

22.9"(1)

11"(1)

23.8"(1)

26.4"(1)

 
Seat Color

Black(26)

Navy(3)

Ash(2)

Espresso(1)

Beech(1)

Vinyl Black(1)

White(1)

Dark Blue(1)

Orange(1)

Beige(1)

Fern Green(1)

Iron(1)

Blue(1)

Gray(1)

Pepper(1)

Malted(1)

Real Red(1)

Periwinkle Blue(1)

Silver(1)

 
Seat Material

Fabric(13)

Vinyl(13)

Crepe Fabric(6)

Polyurethane(5)

Olefin(4)

Polyester(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 Width

19"(4)

18"(4)

20"(3)

19.10"(2)

17.75"(2)

17"(1)

20.10"(1)

13"(1)

18.25"(1)

16.25"(1)

20.50"(1)

 
Seat Depth

18"(4)

16"(3)

16.50"(2)

17.50"(2)

20.10"(2)

19.50"(2)

18.50"(1)

13"(1)

17"(1)

16.25"(1)

14"(1)

19"(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(13)

Powder Coated(10)

Textured Black(4)

Silver(4)

Pewter(1)

 
Maximum Load Capacity

250 lb(33)

300 lb(27)

275 lb(3)

 
Back Material

Plastic(10)

Fabric(3)

Polymer(3)

Olefin(3)

Vinyl(3)

Polyester Fabric(2)

Leather(2)

Urethane(1)

Polyethylene(1)

Polyurethane(1)

Nylon(1)

Foam(1)

 
Frame Material

Steel(14)

Tubular Steel(10)

Powder Coated Steel(2)

Plastic(2)

Chrome Plated Steel(2)

Epoxy(2)

Metal(1)

 
Base Material

Nylon(18)

Chrome(7)

Steel(6)

Plastic(4)

Aluminum(2)

 
Seat Height

22"(2)

22.75"(1)

22.25"(1)

21"(1)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved