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 ('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(64)

HON(19)

Safco(11)

Mayline(5)

Iceberg(3)

MooreCo(1)

 
Color

Black(20)

Navy(4)

Blue(3)

Charcoal(2)

Red(2)

White(2)

Onyx(1)

Platinum(1)

Graphite(1)

Gray(1)

Silver(1)

Charcoal Black(1)

 
Recycled

No(75)

Yes(28)

 
Packaged Quantity

2 / Carton(49)

4 / Carton(33)

1 Each(18)

16 / Pack(1)

1 / Each(1)

 
Assembly Required

No(80)

Yes(23)

 
Limited Warranty

Lifetime(32)

5 Year(24)

15 Year(3)

10 Year(2)

 
Weight (Approximate)

15 lb(2)

12.50 lb(2)

11 lb(2)

12 lb(1)

65 lb(1)

 
Chair/Seat Type

Stacking Chair(75)

Folding Chair(11)

Task Chair(4)

Dining Chair(1)

Guest Chair(1)

 
Maximum Seat Height

18"(15)

19"(5)

17.50"(5)

17.75"(2)

30.25"(2)

16.70"(1)

31.38"(1)

15"(1)

 
Base Shape

Four-legged(51)

Sled(6)

X-Style(1)

Arched(1)

 
Compatibility

Lorell Guest Chair Frames with Padded Arms(6)

 
Back Height

18.50"(3)

16.25"(2)

18"(2)

18.13"(2)

19.50"(2)

12.75"(2)

16"(2)

11.25"(2)

13.75"(1)

 
Number of Casters

4(14)

 
Minimum Seat Height

15"(3)

19"(2)

 
Number of Legs

4(53)

 
Back Color

Black(29)

White(5)

Onyx(2)

Light Gray(2)

Ash(2)

Dark Blue(2)

Orange(2)

Beige(2)

Slate(2)

Gray(2)

Clear(1)

Smoke(1)

Fern(1)

Shadow(1)

Regatta(1)

Beech(1)

Espresso(1)

 
Seat Thickness

3.50"(2)

1.50"(2)

2.50"(1)

 
Arm Material

Polyurethane(17)

Plastic(3)

Nylon(1)

 
Back Type

High Back(2)

Low Back(2)

 
Caster Size

3"(1)

4"(1)

 
Manufacturer Part Number

34554(1)

83113A203(1)

83115(1)

83114A206(1)

83114A205(1)

83114A204(1)

83114A203(1)

83114A202(1)

83114A201(1)

83114A200(1)

83114(1)

83113A204(1)

83113(1)

83115A201(1)

65965(1)

62535(1)

62534(1)

62533(1)

62532(1)

62530(1)

62529(1)

62528(1)

62527(1)

62526(1)

83115A200(1)

83115A202(1)

62515(1)

KTX2SBBLK(1)

4360BL(1)

4359WH(1)

4298ES(1)

4298BH(1)

4292BL(1)

4291BL(1)

4199BL(1)

4188(1)

4185BU(1)

4185BL(1)

KTS2SGBLK(1)

83115A203(1)

KTS1SGBLK(1)

ESC2W(1)

ESC2B(1)

99969(1)

99911(1)

99910(1)

85567(1)

83115A206(1)

83115A205(1)

83115A204(1)

62525(1)

62514(1)

VL303MM10T(1)

MG101ON(1)

30944(1)

64517(1)

64007(1)

64003(1)

MS101SD(1)

MS101RE(1)

MS101ON(1)

MN212ONCU10(1)

MN202ONCU10(1)

MG201CU10(1)

IS110CU98(1)

30946(1)

IS110CU10(1)

IS108IMCU98(1)

IS108IMCU10(1)

4041RE(1)

4041LA(1)

4031RET(1)

4031ONT(1)

4031LAT(1)

VL518ES10(1)

VL508ES10(1)

30945(1)

30947(1)

89265E38G4(1)

42951(1)

62504(1)

62502(1)

62501(1)

62500(1)

59600(1)

59596(1)

59525(1)

42955(1)

42953(1)

42952(1)

42950(1)

30948(1)

42949(1)

42948(1)

42947(1)

42940(1)

42938(1)

41848(1)

41847(1)

41846(1)

41845(1)

30949(1)

4360RD(1)

 
Country of Origin

China(46)

United States(43)

Taiwan(12)

Poland(2)

 
Material

Steel(5)

Polypropylene(4)

Fabric(3)

Plastic(3)

Vinyl(2)

Metal(2)

Polyethylene(1)

 
Height

33"(27)

31"(6)

33.5"(6)

32.1"(6)

29.6"(6)

32.3"(6)

30"(5)

35.4"(4)

35.5"(3)

32"(3)

45"(3)

34"(2)

32.5"(2)

30.5"(2)

35.6"(2)

28.8"(2)

35.8"(2)

30.6"(2)

42.9"(1)

23"(1)

34.5"(1)

33.1"(1)

37"(1)

31.5"(1)

44.1"(1)

4.5"(1)

70.3"(1)

7"(1)

 
Width

25.5"(18)

23"(6)

21.5"(6)

22.9"(6)

18.5"(5)

25"(5)

21"(5)

19.4"(4)

19.5"(4)

22.3"(4)

24.4"(3)

21.3"(3)

20"(3)

22.5"(2)

18.4"(2)

19.8"(2)

19.1"(2)

18"(2)

20.8"(2)

19.3"(2)

19"(2)

23.6"(1)

16"(1)

15"(1)

16.5"(1)

17"(1)

24"(1)

23.5"(1)

20.3"(1)

23.1"(1)

64.5"(1)

26.8"(1)

 
Depth

25"(22)

21"(10)

18.3"(6)

21.5"(5)

21.8"(4)

22"(4)

22.9"(4)

18"(3)

19.3"(3)

19"(3)

17.8"(2)

22.5"(2)

19.5"(2)

24"(2)

21.6"(2)

22.1"(1)

23"(1)

19.4"(1)

20.4"(1)

34"(1)

21.9"(1)

16"(1)

26.8"(1)

26"(1)

23.5"(1)

21.3"(1)

23.1"(1)

33.5"(1)

23.8"(1)

 
Seat Color

Black(34)

Beige(5)

Gray(4)

Ash(4)

Onyx(3)

Regatta(3)

Dark Blue(3)

Orange(3)

Blue(3)

Fern(2)

Slate(2)

Lava(2)

Red(2)

Platinum(2)

Smoke(1)

Clear(1)

Charcoal(1)

Shadow(1)

Navy(1)

White(1)

Beech(1)

Espresso(1)

Blueberry(1)

 
Seat Material

Foam(26)

Fabric(23)

Plastic(20)

Crepe Fabric(12)

Vinyl(9)

Polypropylene(4)

Polyethylene(4)

Polymer(2)

Plywood(2)

Steel(1)

 
Seat Width

18"(6)

18.50"(6)

18.25"(3)

17.75"(2)

21"(2)

15.50"(2)

16.50"(2)

17.50"(1)

 
Seat Depth

19"(4)

17"(3)

17.50"(3)

18.25"(2)

18"(2)

18.13"(2)

15"(2)

16.25"(2)

16.50"(2)

16"(2)

15.90"(1)

 
Back Width

18.25"(4)

20"(3)

18"(3)

17.50"(2)

20.50"(2)

19.50"(2)

21"(2)

 
Frame Color

Black(32)

Powder Coated(27)

Silver(4)

Chrome(3)

Gray(3)

Platinum(2)

Beige(2)

Platinum Metallic(1)

Charcoal(1)

Red(1)

 
Maximum Load Capacity

300 lb(34)

250 lb(26)

225 lb(9)

275 lb(7)

500 lb(2)

350 lb(2)

330 lb(1)

840 lb(1)

 
Length

22.6"(6)

18.3"(1)

 
Back Material

Plastic(21)

Polypropylene(9)

Foam(8)

Fabric(7)

Crepe Fabric(6)

Vinyl(4)

Poly(3)

Polyethylene(2)

Polymer(2)

Plywood(2)

Mesh Fabric(1)

 
Frame Material

Steel(26)

Tubular Steel(22)

Metal(8)

Chrome Plated Steel(2)

Powder Coated Steel(1)

Chrome(1)

 
Base Material

Steel(4)

Chrome(2)

Tubular Steel(2)

Nylon(1)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved