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

Currently Filtered by

Category

Folding Stacking Chairs And Carts

Refine Search

  GO
 
Brand

Lorell(74)

HON(27)

Safco(17)

Mayline(7)

Iceberg(3)

Samsonite(2)

Virco(2)

MooreCo(1)

 
Color

Black(22)

Blue(5)

Navy(4)

White(3)

Charcoal(2)

Red(2)

Silver(1)

Grass(1)

Grass Green(1)

Charcoal Black(1)

Chrome(1)

Gray(1)

Walnut(1)

Graphite(1)

Platinum(1)

Poppy(1)

Onyx(1)

Wine(1)

 
Recycled

No(89)

Yes(44)

 
Packaged Quantity

2 / Carton(62)

4 / Carton(41)

1 Each(26)

16 / Pack(1)

1 / Each(1)

10 / Carton(1)

 
Assembly Required

No(104)

Yes(29)

 
Limited Warranty

Lifetime(53)

5 Year(45)

10 Year(4)

15 Year(3)

1 Year(1)

 
Weight (Approximate)

15 lb(5)

12.50 lb(2)

11 lb(2)

12 lb(1)

65 lb(1)

6.10 lb(1)

12.20 lb(1)

 
Chair/Seat Type

Stacking Chair(102)

Folding Chair(13)

Task Chair(4)

Dining Chair(2)

Guest Chair(1)

 
Maximum Seat Height

18"(25)

19"(6)

17.50"(6)

17.25"(3)

17.75"(2)

30.25"(2)

16.70"(1)

31.38"(1)

15"(1)

18.50"(1)

 
Base Shape

Four-legged(72)

Sled(6)

X-Style(1)

Arched(1)

 
Compatibility

Lorell Guest Chair Frames with Padded Arms(6)

 
Back Height

18"(9)

19.50"(8)

11.25"(5)

18.50"(3)

16.25"(2)

18.13"(2)

13.75"(2)

12.75"(2)

16"(2)

 
Number of Casters

4(19)

 
Minimum Seat Height

15"(5)

19"(2)

 
Number of Legs

4(73)

 
Back Color

Black(34)

White(6)

Navy(5)

Orange(2)

Slate(2)

Espresso(2)

Onyx(2)

Light Gray(2)

Ash(2)

Gray(2)

Dark Blue(2)

Beige(2)

Cherry(1)

Beech(1)

Fern(1)

Smoke(1)

Clear(1)

Iron Ore(1)

Shadow(1)

Regatta(1)

Pear(1)

Apricot(1)

Frost(1)

Neutral(1)

 
Seat Thickness

3.50"(8)

1.50"(2)

2.50"(1)

 
Arm Material

Polyurethane(17)

Nylon(4)

Plastic(3)

 
Back Type

High Back(2)

Low Back(2)

 
Caster Size

3"(1)

4"(1)

 
Manufacturer Part Number

34554(1)

83113A204(1)

83115A203(1)

83115A202(1)

83115A201(1)

83115A200(1)

83115(1)

83114A206(1)

83114A205(1)

83114A204(1)

83114A203(1)

83114A202(1)

83114A201(1)

83114A200(1)

83114(1)

83113A203(1)

83115A205(1)

83113(1)

65965(1)

62535(1)

62534(1)

62533(1)

62532(1)

62530(1)

62529(1)

62528(1)

62527(1)

62526(1)

62525(1)

62515(1)

62514(1)

83115A204(1)

83115A206(1)

892559C1DD3(1)

4286BL(1)

901850(1)

516602900(1)

497542901(1)

4360RD(1)

4360BL(1)

4359WH(1)

4359GS(1)

4298ES(1)

4298CY(1)

4298BH(1)

4292BL(1)

4291BL(1)

4286GS(1)

4286BU(1)

4199BL(1)

85567(1)

4188(1)

4185BU(1)

4185BL(1)

4184BL(1)

KTX3SBBLK(1)

KTX2SBBLK(1)

KTX1SBBLK(1)

KTS2SGBLK(1)

KTS1SGBLK(1)

ESC2W(1)

ESC2B(1)

99969(1)

99911(1)

99910(1)

89265E38G4(1)

62504(1)

VL303MM10T(1)

IS110CU84(1)

64517(1)

64007(1)

64003(1)

N606CU98(1)

N606CU42(1)

MS101SD(1)

MS101RE(1)

MS101ON(1)

MN212ONCU10(1)

MN202ONCU10(1)

MG201CU10(1)

MG101ON(1)

IS110CU98(1)

IS110CU49(1)

30945(1)

IS110CU47(1)

IS110CU22(1)

IS110CU19(1)

IS110CU10(1)

IS108IMCU98(1)

IS108IMCU22(1)

IS108IMCU10(1)

4041RE(1)

4041LA(1)

4031RET(1)

4031ONT(1)

4031LAT(1)

VL518ES10(1)

VL508ES10(1)

30944(1)

30946(1)

62502(1)

42955(1)

62501(1)

62500(1)

59602(1)

59601(1)

59600(1)

59599(1)

59598(1)

59597(1)

59596(1)

59595(1)

59525(1)

59524(1)

42962(1)

42961(1)

42953(1)

30947(1)

42952(1)

42951(1)

42950(1)

42949(1)

42948(1)

42947(1)

42940(1)

42938(1)

41848(1)

41847(1)

41846(1)

41845(1)

30949(1)

30948(1)

901851(1)

 
Country of Origin

United States(59)

China(53)

Taiwan(15)

South Korea(3)

Poland(3)

 
Material

Plastic(6)

Polypropylene(5)

Steel(5)

Fabric(3)

Vinyl(2)

Metal(2)

Polyethylene(1)

 
Height

33"(29)

33.5"(13)

35.5"(9)

32.3"(6)

31"(6)

29.6"(6)

32.1"(6)

30"(6)

32.5"(5)

30.6"(4)

32"(4)

35.4"(4)

45"(3)

34"(2)

34.5"(2)

35.6"(2)

28.8"(2)

23"(2)

35.8"(2)

30.5"(2)

33.3"(1)

17.5"(1)

70.3"(1)

4.5"(1)

31.3"(1)

44.1"(1)

31.5"(1)

37"(1)

33.1"(1)

7"(1)

42.9"(1)

37.1"(1)

36.3"(1)

 
Width

25.5"(21)

25"(11)

21"(8)

21.3"(6)

23"(6)

19.5"(6)

22.9"(6)

21.5"(6)

22.3"(5)

18.5"(5)

19.3"(4)

19.4"(4)

24.4"(3)

20"(3)

18"(3)

19"(2)

18.4"(2)

22.5"(2)

19.1"(2)

23.5"(2)

24"(2)

19.8"(2)

27"(2)

20.8"(2)

16"(2)

18.6"(2)

15"(1)

20.3"(1)

17"(1)

23.6"(1)

26.8"(1)

23.1"(1)

64.5"(1)

16.5"(1)

31.5"(1)

 
Depth

25"(28)

21"(11)

21.8"(10)

21.5"(8)

22"(8)

18.3"(6)

18"(5)

22.9"(4)

19.3"(4)

19"(3)

21.3"(2)

17.8"(2)

25.3"(2)

23.5"(2)

19.5"(2)

21.6"(2)

24"(2)

22.5"(2)

23.1"(1)

33.5"(1)

26"(1)

23.8"(1)

16"(1)

21.9"(1)

20.4"(1)

19.4"(1)

23"(1)

22.1"(1)

26.3"(1)

34"(1)

26.8"(1)

23.3"(1)

 
Seat Color

Black(41)

Navy(7)

Blue(5)

Beige(5)

Ash(4)

Gray(4)

Onyx(3)

Regatta(3)

Dark Blue(3)

Orange(3)

Slate(2)

White(2)

Fern(2)

Lava(2)

Red(2)

Espresso(2)

Platinum(2)

Frost(2)

Charcoal(1)

Blueberry(1)

Smoke(1)

Clear(1)

Shadow(1)

Pear(1)

Apricot(1)

Iron Ore(1)

Grass Green(1)

Beech(1)

Cherry(1)

Neutral(1)

 
Seat Material

Fabric(35)

Foam(27)

Plastic(20)

Vinyl(12)

Crepe Fabric(12)

Polypropylene(5)

Polyethylene(4)

Plywood(4)

Polyester(2)

Polymer(2)

Steel(2)

 
Seat Width

18"(12)

21"(8)

18.50"(6)

17.75"(5)

18.25"(5)

15.50"(3)

19"(2)

17.50"(2)

16.50"(2)

16.93"(1)

 
Seat Depth

18"(8)

15"(8)

19"(6)

17.50"(5)

17"(4)

17.75"(3)

16.50"(3)

18.25"(2)

18.13"(2)

16.25"(2)

16"(2)

15.90"(1)

16.93"(1)

 
Back Width

18"(11)

20.50"(8)

17.50"(4)

18.25"(4)

20"(3)

19.50"(2)

21"(2)

18.50"(1)

 
Frame Color

Black(33)

Powder Coated(28)

Chrome(6)

Gray(5)

Silver(4)

Platinum(2)

Beige(2)

Platinum Metallic(1)

Charcoal(1)

Red(1)

White(1)

Neutral(1)

 
Maximum Load Capacity

300 lb(43)

250 lb(33)

275 lb(9)

225 lb(9)

500 lb(8)

330 lb(2)

350 lb(2)

840 lb(1)

400 lb(1)

 
Length

22.6"(6)

18.3"(1)

 
Back Material

Plastic(21)

Fabric(16)

Polypropylene(11)

Foam(8)

Vinyl(6)

Crepe Fabric(6)

Poly(5)

Plywood(4)

Polyethylene(2)

Polymer(2)

Mesh Fabric(1)

Mesh(1)

 
Frame Material

Steel(42)

Tubular Steel(22)

Metal(10)

Chrome Plated Steel(3)

Powder Coated Steel(2)

Chrome(1)

Tempered Steel(1)

 
Base Material

Steel(5)

Nylon(3)

Chrome(2)

Tubular Steel(2)

 
 
 
 
 

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