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

HON(4)

 
Color

Black Leather(2)

Black(1)

Black/Silver(1)

 
Warranty

Backed by the HON Limited Five-Year Warranty.(4)

 
Series Name

HON VL870 Series(2)

HON VL888 Series(1)

HON VL860 Series(1)

 
Manufacturer Part Number

VL888SB11(1)

VL873SB11(1)

VL872SB11(1)

VL862SB11(1)

 
Country of Origin

CN(4)

 
Seat Width

27.5"(1)

61.5"(1)

42"(1)

25"(1)

 
Seat Depth

21"(2)

19.75"(1)

19"(1)

 
Base Material

Wood(3)

Steel(1)

 
Overall Width

67"(1)

73"(1)

53.5"(1)

25"(1)

 
Overall Depth

28.75"(2)

28"(1)

25"(1)

 
Overall Height

32"(2)

30.5"(1)

18"(1)

 
Seat Height Maximum

18.5"(2)

17"(1)

 
Weight Capacity (text)

Supports up to 250 lbs.(3)

Supports up to 500 lbs.(1)

 
Upholstery Material

Leather(3)

SofThread Leather(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved