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

Currently Filtered by

Category

Stack Chairs

Refine Search

  GO
Brand

MAHAR MANUFACTURING,INC.(1563)

OFM(228)

SCHOLAR CRAFT PRODUCTS(160)

Angeles(71)

Balt(8)

Safco(8)

Childrens Factory(4)

NATIONAL PUBLIC SEATING CORP.(2)

MooreCo(1)

Color

BLACK|000000(42)

NAVY|000080(41)

WINE|722F37(40)

Blue|0000FF(34)

Green|008000(34)

Red|FF0000(34)

GRAY|808080(26)

Navy|000080(26)

Yellow|FFFF00(24)

Purple|800080(18)

Brown|A52A2A(16)

Teal|008080(15)

Burgundy|800020(15)

TEAL|008080(12)

Black|000000(11)

SILVER/BLUE|C0C0C0(11)

SILVER/RED|C0C0C0(11)

SILVER/GREEN|C0C0C0(10)

Sand|C2B280(10)

SILVER/YELLOW|C0C0C0(10)

SILVER/BURGUNDY|C0C0C0(10)

Orange|FFA500(10)

SILVER/BLACK|C0C0C0(9)

burgundy|800020(8)

green|008000(8)

blue|0000FF(8)

black|000000(8)

navy|000080(7)

red|FF0000(7)

CHARCOAL|36454F(7)

Plum|DDA0DD(5)

beige|F5F5DC(5)

Tan|D2B48C(5)

Camel|C19A6B(5)

gray|808080(5)

brown|A52A2A(5)

(4)

Royal Blue|4169E1(4)

Slate Gray|708090(4)

Forest Green|228B22(4)

Charcoal|36454F(4)

Putty|efead7(4)

Khaki|C3B091(4)

Lavender|E6E6FA(4)

Shamrock Green|009E60(4)

Coral Pink|F88379(4)

Colonial Blue|0000FF(4)

Golden Flax|EEDC82(4)

Sage Green|BCB88A(4)

Cornflower Blue|6495ED(4)

purple|800080(3)

IVORY|FFFFF0(3)

OLIVE|808000(3)

BURGUNDY PIN|800020(2)

SILVER/BLK|C0C0C0(2)

Natural|FFFFFF(2)

GREEN|008000(2)

Grey|808080(2)

NAVY PIN|000080(2)

Wine Silvr|722F37(1)

Nvy on Silvr|000080(1)

Black on Black|000000(1)

Navy Blue|000080(1)

Pearl Whit|EAE0C8(1)

Latte|c8ad90(1)

Blk on Silvr|000000(1)

Wine on Blk|722F37(1)

SILVER/GRN|C0C0C0(1)

TAUPE|483C32(1)

Blk on Black|000000(1)

Nvy on Black|000080(1)

SILVER/YEL|C0C0C0(1)

Grass Green(1)

Navy on Black|000080(1)

LINEN|FAF0E6(1)

LIME|BFFF00(1)

Mink|d4c6c0(1)

SILVER/BUR|C0C0C0(1)

Sprout|bdc239(1)

BURGUNDY|800020(1)

Wine on Silver|722F37(1)

BITTERSWEET|FE6F5E(1)

Wine on Black|722F37(1)

Laurel Green|A9BA9D(1)

Black on Silvr|000000(1)

Navy on Silver|000080(1)

Marble White|fffcf0(1)

Recycled

No(1)

Height

32.25(41)

31.50(36)

33.00(31)

33.25(26)

31.25(12)

31.75(12)

26"(8)

35.25(8)

34.25(7)

22.5"(7)

31"(7)

35.00(6)

30.00(6)

29.75(6)

35.50(6)

22.75(6)

28.8"(6)

24.75(6)

20.5"(5)

24.50(1)

21.50(1)

15.50(1)

12.25(1)

50.5"(1)

Width

21.75(150)

23.75(46)

25.00(36)

18.00(26)

21.00(24)

22.25(24)

14.8"(22)

21.25(20)

29.25(18)

22.00(16)

17"(14)

25.50(14)

20.8"(14)

20.25(12)

17.3"(12)

25.25(12)

22.75(8)

25.75(8)

21.50(8)

15.5"(2)

24.75(2)

16.5"(2)

24.8"(2)

23.00(2)

Depth

19"(7)

16.5"(7)

17.3"(6)

15.5"(6)

15.3"(5)

14.8"(1)

17"(1)

23.5"(1)

Country of Origin

United States(1668)

Taiwan(221)

Mexico(95)

China(79)

Material

Plastic(19)

Steel(10)

Limited Warranty

10 Year(33)

1 Year(1)

Weight (Approximate)

5.90 lb(5)

5.65 lb(5)

Seat Material

Plastic(14)

Polypropylene(1)

Seat Color

Blue|0000FF(3)

Navy|000080(3)

Sand|C2B280(2)

Black|000000(2)

Red|FF0000(1)

Burgundy|800020(1)

Green|008000(1)

Seat Width

14.50"(4)

12.50"(2)

11"(2)

17.75"(1)

Maximum Seat Height

12"(11)

14"(8)

18"(7)

16"(6)

10"(1)

29"(1)

Seat Depth

14.50"(4)

12"(2)

11"(2)

18"(1)

Base Shape

Four-legged(34)

Back Height

13"(4)

12"(2)

10.50"(2)

21.50"(1)

Base Material

Steel(33)

Number of Legs

4(34)

Seat Size

18.25" W x 17.75" D(38)

18.25 W x 17.75 D(28)

20" W x 22" D(21)

18.50" W x 17.50" D(13)

18.5" x 17.5"(13)

18.25" W x 16.50" D(12)

14.25" W x 13" D(12)

18.25" W x 18" D(12)

19.75" W x 19.50" D(10)

20.75" W x 17" D(9)

19.25" W x 17.50" D(8)

20.75" W x 18.25" D(7)

18" W x 19.50" D(6)

18.25" W x 16.5" D(6)

18.25" W x 17.75" D(5)

18" W x 19" D(5)

19" W x 17.25" D(3)

18.25" x 17.75"(1)

Product Type

Chair(34)

Packaged Quantity

5 / Carton(7)

6 / Carton(7)

1 Each(1)

Assembly Required

No(24)

Yes(1)

Product Line

Circulation(1)

Chair/Seat Type

Stacking Chair(34)

Back Width

15.50"(1)

Back Material

Plastic(15)

Steel(10)

Polypropylene(1)

Frame Material

Steel(6)

Powder Coated Steel(1)

Back Color

Blue|0000FF(3)

Navy|000080(3)

Sand|C2B280(2)

Black|000000(2)

Red|FF0000(1)

Burgundy|800020(1)

Green|008000(1)

Application/Usage

School(28)

Classroom(5)

Assembled Dimension

22" D x 21.75" W x 32.25" H(36)

23" D x 23.75" W x 33.25" H(18)

23" D x 21.75" W x 31.50" H(16)

23 D x 21.75 W x 31.50 H(14)

21" D x 21" W x 31.25" H(12)

29" D x 25" - 36" W x 33" H(12)

23.25" D x 21.25" W x 33" H(10)

25.75" D x 25.50" W x 34.25" - 39" H(7)

24.50" D x 22.25" W x 31.75" H(6)

23.50" D x 22.25" W x 29.75" H(6)

24.50" D x 25.25" W x 31.75" H(6)

19.25" D x 18" W x 24.75" H(6)

29" D x 25" W x 33" H(6)

18.25" D x 18" W x 22.75" H(6)

20.25" D x 20.25" W x 30" H(6)

25.25" D x 29.25" W x 35.50" H(6)

23" D x 21.75" W x 31.50" H(5)

22" D x 22" W x 32.25" H(5)

23" D x 21.50" W x 33.25" H(4)

23.50" D x 22.75" W x 35.25" H(4)

23.50" D x 25.75" W x 35.25" H(4)

23" D x 23.75" W x 33.25" H(4)

29" D x 22" W x 33" H(3)

25.25" D x 29.25" W x 35" H(3)

24" D x 21.75" W x 35" H(3)

24.5 D x 23" W x 21.5" H(1)

24.75" D x 23.75" W x 15.50" H(1)

23" D x 21.75" W x 31.5" H(1)

23.25" D x 24.75" W x 12.25" H(1)

30" D x 18" W x 24.5" H(1)

Environmental Certification

GREENGUARD(14)

GREENGUARD Gold(11)

Environmentally Friendly

Yes(25)

Features

Ventilation(34)

Heavy Duty(24)

Durable(23)

Reinforced Back(19)

Reinforced Seat(19)

Reinforced(14)

Stackable(11)

Swivel Glide(11)

Glide(9)

Comfortable(5)

Ball Bearing Glider(2)

Breathable(1)

Perforated(1)

Contoured(1)

Footrest(1)

Product Name

18" Stack Chair, Chrome Legs with Swivel Glide(7)

14" Stack Chair, Chrome Legs(7)

12" Stack Chair, Chrome Legs(6)

16" Stack Chair, Chrome Legs(6)

10" Stack Chair, Chrome Legs(5)

14" Stack Chair with Chrome Legs, 6 Piece - AS(1)

12" Stack Chair with Chrome Legs, 6 Piece - AS(1)

Circulation Stacking Stool(1)

Glide Style

Swivel(32)

Matching color ball glide(32)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor

© 2019-2020 United Supply Corp, All Rights Reserved