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

Currently Filtered by

Category

Reception Side And Guest Chairs

Refine Search

  GO
 
Brand

Lorell(115)

HON(38)

Safco(7)

Boss(2)

Jonti-Craft(1)

 
Color

Black(41)

Brown(7)

Mahogany(4)

Charcoal(4)

Beige(3)

Oxblood(3)

White(3)

Blue(2)

Espresso(2)

Gray(2)

Tan(2)

Ocean(2)

Apple Green(2)

Green(2)

Stratus(2)

Buff(2)

Navy(2)

Real Red(1)

Malted(1)

Pepper(1)

Black Cherry(1)

Black Mahogany(1)

Midnight Blue(1)

Taupe(1)

Walnut(1)

Baltic(1)

Natural(1)

 
Recycled

No(135)

Yes(28)

 
Height

35.5"(13)

32"(13)

33.5"(11)

37"(11)

32.8"(9)

41"(9)

36.5"(8)

29.5"(7)

31.5"(7)

32.5"(5)

30.8"(5)

33.3"(4)

31.3"(4)

35"(4)

18"(3)

34.5"(3)

18.1"(3)

32.1"(3)

34"(3)

36"(3)

28"(3)

35.9"(3)

35.4"(2)

30"(2)

45"(2)

46.5"(2)

39.5"(2)

17.5"(2)

33.6"(2)

33"(1)

29"(1)

23"(1)

35.8"(1)

37.5"(1)

26.5"(1)

31"(1)

36.3"(1)

38"(1)

30.5"(1)

 
Depth

24"(14)

25"(11)

21"(9)

23.5"(8)

33"(8)

27.8"(7)

25.5"(6)

28.3"(5)

20"(5)

28.8"(4)

27"(4)

24.5"(4)

22.3"(4)

23.8"(3)

27.3"(3)

23"(3)

24.4"(3)

22.6"(3)

36"(3)

25.6"(3)

24.8"(3)

29"(2)

23.9"(2)

19"(2)

28"(2)

26.8"(2)

34.5"(2)

20.5"(2)

9"(2)

26"(2)

21.8"(2)

34"(1)

29.5"(1)

25.3"(1)

22"(1)

32.5"(1)

31.5"(1)

17.2"(1)

21.3"(1)

19.5"(1)

20.8"(1)

27.5"(1)

30"(1)

26.1"(1)

24.7"(1)

26.6"(1)

26.5"(1)

 
Manufacturer Part Number

B619(1)

83120A205(1)

83112(1)

83120(1)

83120A200(1)

83120A201(1)

83120A202(1)

83120A203(1)

83120A204(1)

83120A206(1)

82097(1)

84374(1)

84374007(1)

84374008(1)

84374009(1)

8437401(1)

84374010(1)

8437402(1)

82098(1)

82096(1)

8437404(1)

68574(1)

777QAJOX(1)

68252(1)

68551(1)

68553(1)

68554(1)

68555(1)

68556(1)

68948(1)

82094(1)

68949(1)

68952(1)

68953(1)

68958(1)

68961(1)

69506(1)

69507(1)

82093(1)

8437403(1)

8437405(1)

60600(1)

89061(1)

86916(1)

86917(1)

86918(1)

86919(1)

86920(1)

86921(1)

89060(1)

99863(1)

86913(1)

99864(1)

4368BL(1)

4368WH(1)

4369BL(1)

4369WH(1)

6804BL(1)

6810MH(1)

86914(1)

86912(1)

8437406(1)

86202(1)

84549(1)

84572(1)

84576(1)

84577(1)

84586(1)

84587(1)

85566(1)

86202007(1)

86911(1)

86202008(1)

86202009(1)

8620201(1)

86202010(1)

8620202(1)

8620203(1)

8620204(1)

86910(1)

60601(1)

60511(1)

B709(1)

IC108IMCU98(1)

4003CU98T(1)

4008CU10T(1)

4008CU19T(1)

4008CU98T(1)

IB108IMCU10(1)

IB108IMCU98(1)

IC108IMCU10(1)

IG107CU10(1)

4003CU10T(1)

IG107CU98(1)

SGS6FBCU10B(1)

SGS6FBCU98B(1)

SGS6FBUR10B(1)

SGS6NBCU10B(1)

SGS6NBCU98B(1)

SGS6NBUR10B(1)

4003CU19T(1)

2285VA10(1)

3771JC(1)

VL616VA19(1)

VL605SB11(1)

VL606SB11(1)

VL606VA10(1)

VL606VA19(1)

VL606VA90(1)

VL616SB11(1)

VL616VA10(1)

VL616VA90(1)

2093SR11T(1)

VL643SB11(1)

VL653SB11(1)

VL693SB11(1)

VL852NSB11(1)

VL853NSB11(1)

VL871SB11(1)

VL887SB11(1)

2093CU10T(1)

VL102SB11(1)

20014(1)

60510(1)

49874(1)

42687(1)

42688(1)

42689(1)

42690(1)

42691(1)

48160(1)

48842(1)

59504(1)

40202(1)

59539(1)

60122(1)

60462(1)

60469(1)

60470(1)

60471(1)

60504(1)

42685(1)

40201(1)

20015(1)

23100008(1)

20019(1)

20020(1)

20025(1)

20026(1)

20027(1)

23100(1)

23100007(1)

23100009(1)

40200(1)

2310001(1)

23100010(1)

2310002(1)

2310003(1)

2310004(1)

30943(1)

30953(1)

30956(1)

6810NA(1)

 
Country of Origin

China(99)

United States(36)

Taiwan(28)

 
Width

25"(14)

24"(13)

23.3"(11)

23.5"(11)

23"(9)

24.4"(8)

27.5"(5)

27"(5)

22"(5)

60"(4)

26"(4)

22.3"(4)

32.5"(4)

29"(4)

25.8"(4)

22.9"(3)

26.5"(3)

31.5"(3)

24.2"(3)

21.5"(3)

25.5"(2)

23.8"(2)

32.6"(2)

36"(2)

21"(2)

34.5"(2)

19"(2)

24.6"(2)

18.1"(2)

18.5"(2)

24.5"(2)

17.5"(2)

28.3"(1)

19.8"(1)

21.3"(1)

57.5"(1)

24.8"(1)

26.3"(1)

22.5"(1)

33"(1)

35.5"(1)

50.7"(1)

72"(1)

20"(1)

35.4"(1)

30.5"(1)

 
Material

Leather(7)

Mesh(7)

Steel(5)

Bonded Leather(3)

Wood(2)

Linen(2)

Aluminum(2)

Plywood(2)

Bentwood(2)

Acrylic(1)

Vinyl(1)

Mahogany(1)

 
Limited Warranty

5 Year(80)

Lifetime(30)

6 Year(2)

 
Weight (Approximate)

12.50 lb(4)

14.30 lb(4)

29 lb(3)

33 lb(3)

40 lb(2)

28 lb(2)

41 lb(1)

50 lb(1)

55 lb(1)

43 lb(1)

 
Seat Material

Fabric(60)

Leather(19)

Bonded Leather(13)

Vinyl(10)

Crepe Fabric(6)

Steel(6)

Faux Wood(6)

Faux Leather(4)

SofThread Leather(4)

Plastic(4)

Foam(4)

Polyester(4)

Plywood(4)

Wood(2)

Polystyrene(1)

Polyurethane(1)

Memory Foam(1)

 
Seat Color

Black(64)

Navy(7)

Charcoal(3)

Burgundy(3)

Teak(3)

Gray(2)

Ash(2)

Brown(2)

Beige(2)

Charcoal Gray(2)

Iron(2)

Navy Blue(2)

Periwinkle Blue(1)

Espresso(1)

Fern(1)

Orange(1)

Dark Blue(1)

Green(1)

Periwinkle(1)

Blue(1)

Real Red(1)

Malted(1)

Pepper(1)

Mahogany(1)

Natural(1)

 
Seat Width

19"(10)

20"(8)

30"(6)

20.13"(4)

18.75"(4)

20.88"(3)

25.50"(2)

20.25"(2)

61"(2)

17.50"(2)

16.75"(2)

19.50"(1)

25"(1)

19.75"(1)

24.75"(1)

18.25"(1)

20.87"(1)

21.25"(1)

19.13"(1)

19.69"(1)

18.88"(1)

20.75"(1)

21"(1)

22"(1)

20.38"(1)

18.50"(1)

 
Maximum Seat Height

19"(13)

18"(7)

19.25"(6)

17.75"(5)

20"(3)

18.13"(3)

31"(2)

29"(2)

19.50"(1)

18.91"(1)

18.10"(1)

20.25"(1)

18.75"(1)

30.75"(1)

32.75"(1)

16.25"(1)

 
Seat Depth

17.50"(9)

17"(7)

18"(6)

17.38"(6)

19.75"(4)

19"(3)

21"(2)

18.25"(2)

17.75"(2)

16.75"(2)

17.37"(2)

18.38"(2)

20"(1)

18.11"(1)

19.25"(1)

20.75"(1)

26"(1)

 
Base Shape

Four-legged(77)

Sled(16)

Cantilever(11)

Square(5)

Pedestal(1)

Cantilever Sled(1)

 
Back Height

13.50"(11)

14.75"(9)

15"(6)

13"(5)

15.33"(4)

15.75"(4)

12"(3)

14"(2)

16.50"(2)

18"(2)

20"(2)

26"(1)

20.50"(1)

30"(1)

24.60"(1)

22.25"(1)

17.75"(1)

15.25"(1)

13.75"(1)

 
Shape

Barrel(1)

 
Number of Casters

4(6)

 
Maximum Load Capacity

250 lb(60)

275 lb(32)

300 lb(15)

600 lb(8)

225 lb(4)

500 lb(2)

350 lb(1)

 
Minimum Seat Height

19"(3)

20"(2)

19.50"(2)

18"(1)

 
Base Material

Steel(16)

Wood(15)

Aluminum(6)

Metal(2)

Chrome(1)

Chrome Metal(1)

 
Number of Legs

4(81)

 
Adjustable Arm

Yes(4)

 
Seat Thickness

3.94"(4)

3.33"(4)

2"(1)

 
Arm Material

Plastic(11)

Polyurethane(9)

Polypropylene(6)

Wood(6)

Fabric(5)

Leather(3)

Nylon(2)

Metal(2)

Steel(1)

Poly(1)

 
Arm Height

25.50"(1)

23"(1)

23.50"(1)

 
Arm Color

Black(6)

Chrome(3)

Gray(1)

 
Back Type

High Back(10)

Mid Back(4)

Low Back(2)

 
Product Type

Chair(147)

Sitting Bench(11)

Sitting Stool(4)

Chair Frame(1)

 
Packaged Quantity

1 Each(121)

2 / Carton(23)

1 / Each(13)

1 Carton(4)

4 / Carton(2)

 
Assembly Required

Yes(105)

No(58)

 
Product Model

HVL606(4)

HVL616(4)

H4008(3)

H4003(3)

B619(1)

H2093(1)

6810MH(1)

6804BL(1)

777 QA(1)

2093(1)

HVL871(1)

HVL887(1)

HVL605(1)

HVL853(1)

HVL852(1)

HVL693(1)

HVL653(1)

HVL643(1)

6810NA(1)

 
Product Line

Ergomesh(12)

Scatter(8)

Deluxe(7)

Solutions Seating(6)

Accommodate(6)

Ignition(6)

CoGo(4)

Hospitality(4)

Reve(3)

Topflight(2)

Pillow-Soft(2)

Lota(1)

Corral(1)

Traction(1)

Komfy(1)

Circulate(1)

Client(1)

Charge(1)

Validate(1)

 
Chair/Seat Type

Guest Chair(121)

Bench(11)

Club Chair(7)

Lounger Chair(6)

Reception Chair(4)

Reception Seating(3)

Outdoor Chair(2)

Task Chair(2)

Accent Chair(2)

Bar Stool(2)

 
Back Width

18.50"(19)

21"(7)

18"(5)

21.63"(4)

20.88"(3)

31"(2)

17.38"(2)

61"(2)

19.50"(2)

18.91"(1)

20"(1)

20.87"(1)

17.88"(1)

21.50"(1)

29.25"(1)

19.25"(1)

22"(1)

24.75"(1)

26.75"(1)

20.07"(1)

 
Frame Color

Black(36)

Powder Coated(24)

Mahogany(7)

Espresso(5)

Textured Black(4)

Cherry(4)

Walnut(3)

 
Back Material

Bonded Leather(12)

Fabric(11)

Mesh(10)

Leather(9)

Plywood(7)

Steel(6)

SofThread Leather(6)

Wood(4)

Faux Wood(4)

Vinyl(3)

Plastic(3)

Polyester(2)

Polyurethane(2)

Foam(2)

Polystyrene(1)

Fiber(1)

Polyester Fiberfill(1)

Nylon(1)

 
Adjustable Seat

Yes(1)

 
Frame Material

Steel(31)

Metal(18)

Wood(11)

Tubular Steel(9)

Solid Wood(6)

Powder Coated Steel(4)

Rubberwood(3)

Hardwood(3)

Brushed Aluminum(3)

Aluminum(2)

Plastic(2)

 
Back Color

Black(51)

Navy(3)

Iron(2)

Teak(2)

Gray(2)

Ash(2)

Mahogany(2)

Charcoal Gray(1)

Charcoal(1)

Brown(1)

Beige(1)

Fern(1)

Orange(1)

Dark Blue(1)

Espresso(1)

Natural(1)