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

Currently Filtered by

Category

Reception Seating And Sofas

Refine Search
  GO
 
Brand

Alera(26)

HON(5)

 
Color

Black(8)

Beige(3)

Almond(3)

Slate(2)

Black Leather(2)

Black/Mahogany(2)

Black/Silver(2)

Chestnut(2)

Caribbean(1)

Cardinal(1)

Mandarin(1)

Saffron(1)

 
Overall Width

18"(8)

26 3/8"(5)

36"(2)

38 3/8"(2)

25 3/4"(2)

53 1/2"(1)

73"(1)

67"(1)

25"(1)

5 7/8"(1)

55 1/2"(1)

44 7/8"(1)

77"(1)

65 3/4"(1)

 
Overall Depth

18"(12)

26 3/8"(4)

21"(2)

28 3/4"(2)

31 1/2"(2)

28"(1)

25"(1)

22 5/8"(1)

21 1/2"(1)

26 1/8"(1)

22 1/4"(1)

 
Base Color

Silver(2)

Black(1)

 
Manufacturer Part Number

WE35SF(1)

WE36CH(1)

WE35MN(1)

WE35BG(1)

WE34CD(1)

WE35AL(1)

WE36ST(1)

WE37CH(1)

VL873SB11(1)

VL888SB11(1)

VL872SB11(1)

VL864SB11(1)

WE37ST(1)

VL862SB11(1)

WE34CB(1)

WE34BG(1)

QB8316(1)

RL21LS10B(1)

QB8216(1)

QB8116P(1)

QB8016(1)

QB8116(1)

RL2219M(1)

RL22LS10B(1)

WE33BG(1)

WE34AL(1)

WE33AL(1)

RL8319CSM(1)

RL2419M(1)

RL8319CS(1)

MR2316(1)

 
Country of Origin

CN(31)

 
Seat Material

Leather(2)

Antimicrobial Polyurethane(1)

 
Seat Width

18"(8)

26 3/8"(4)

38 3/8"(2)

36"(2)

25 3/4"(2)

42"(1)

61 1/2"(1)

27 1/2"(1)

25"(1)

22"(1)

20 1/2"(1)

42 13/100"(1)

41 3/4"(1)

63 3/4"(1)

 
Seat Depth

18"(14)

20 1/2"(3)

21"(2)

20 9/10"(2)

19"(1)

19 3/4"(1)

22 1/4"(1)

21 1/2"(1)

22 7/8"(1)

22 5/8"(1)

 
Base Material

Wood(8)

Steel(8)

Metal(1)

 
Weight Capacity (text)

Supports up to 250 lbs.(14)

Supports up to 500 lbs.(6)

Supports up to 275 lbs.(6)

Supports up to 400 lbs.(2)

 
Seat Height Maximum

18"(14)

17 1/2"(6)

17"(2)

18 1/2"(2)

19 1/4"(1)

17 7/8"(1)

18 1/8"(1)

17 5/16"(1)

 
Seat/Back Color

Black(3)

 
Overall Height Maximum

30 7/8"(1)

30"(1)

34 5/8"(1)

 
Recommended Applications

Guest, Reception, Waiting Room & Lounge(3)

 
Overall Depth Maximum

25"(1)

31 1/8"(1)

26 3/8"(1)

 
Overall Width Maximum

25"(1)

26 3/8"(1)

25 5/8"(1)

 
Seat Depth Maximum

25"(1)

25 1/4"(1)

18 1/2"(1)

 
Seat Width Maximum

25"(1)

26 3/8"(1)

22 7/8"(1)

 
Back Width Maximum

26"(1)

 
Back Height Maximum

16 1/2"(1)

 
Arm Style

Curved(1)

 
Distance Between Arms

25"(1)

 
Arm Height From Seat

7"(1)

 
Upholstery Material

PU(14)

Leather(8)

Polyurethane(5)

SofThread Leather(1)

 
Back Material

Leather(2)

Antimicrobial Polyurethane(1)

 
Overall Height

18"(15)

30 1/2"(5)

32"(4)

17 3/8"(1)

33"(1)

17 1/2"(1)

22 7/8"(1)

 
Arms Included

Yes(1)

 
Armrest Color

Natural Wood(1)

 
Armrest Material

Wood(1)