Free White Glove Delivery!
SELECT (SELECT GROUP_CONCAT(DISTINCT StandardColor,',',SKU,',',SUBSTRING(large,35),',',CONCAT(UCASE(SUBSTRING(ColorDescription, 1, 1)),LCASE(SUBSTRING(ColorDescription, 2))) SEPARATOR '|') FROM tbl_products WHERE tbl_products.RootModelNumber = p.RootModelNumber) AS AvailableColors, p.mhDescription, p.mhSlug, p.cgDescription, p.cgSlug, p.CatDescription, p.cSlug, IF(p.thumb LIKE 'http%%',p.thumb,concat( 'https://www.shopwesco.com/uploads/products/', p.thumb )) AS thumbImage, IF(p.large LIKE 'http%%',p.large, concat( 'https://www.shopwesco.com/uploads/products/', p.large )) AS largeImage, p.SKU, p.ModelStatus, p.ModelDescription, p.pkID, p.pkSKU, p.pkCategory, p.id, IF(p.CommonBrandName = 'LG Appliances','LG',p.CommonBrandName) AS RevisedBrandName, p.CommonBrandName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5, bd.CommonBrandID, IF(p.StandardColor = 'Other',CONCAT(UCASE(SUBSTRING(p.ColorDescription, 1, 1)),LCASE(SUBSTRING(p.ColorDescription, 2))),p.StandardColor) AS ModelColor, mp.MSRP, mp.Sale, mp.Available, mp.Featured, IF((mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '0.00') AS RegPrice, mp.OutletPrice, mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message, (mp.MSRP - mp.Sale) AS Discount, IF(bd.MAP = 1 OR p.is_package = 1, 1, .90) AS MapDiscount, mp.in_stock, mp.free_shipping, p.Sale AS MinTargetPrice, p.RootModelNumber, mp.FreeShip, mp.specials, mp.closeout, bd.UMRP, (SELECT COUNT(pbm.pkID) FROM PromotionsByModel AS pbm INNER JOIN Rebates ON (Rebates.PromotionName = pbm.PromotionName AND Rebates.FileName <> '') WHERE pbm.pkProduct = p.pkID AND pbm.EffectiveDate <= CURDATE() AND pbm.ExpirationDate > CURDATE() GROUP BY pbm.pkProduct) AS rwsPromotion, p.ExpandedDescription, p.specifications, (SELECT COUNT(rbm.pkID) FROM rebatesbymodel AS rbm INNER JOIN Rebates AS r ON r.pkID = rbm.pkRebates WHERE rbm.pkProduct = p.pkID AND r.ExpirationDate > NOW() AND r.EffectiveDate < NOW() GROUP BY rbm.PromotionName) AS rwsRebates, (p.Sale * (IF(bd.MAP = 1 OR p.is_package = 1, 1,.90))) AS MAP, mh.super_category, IF(bd.no_cart =1 OR mp.on_line = 0,1,0) AS no_cart, mp.in_store, IF((mp.Sale = 0), mp.MSRP, IF ((mp.MSRP = 0 ), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS calcPrice, c.ConsumerDescription AS cDescription FROM tbl_products AS p INNER JOIN Brand_Data AS bd ON (p.pkBrand = bd.pkID) INNER JOIN ModelPrice AS mp ON (mp.pkProduct = p.pkID AND mp.SKU = p.SKU AND mp.Available = 1) INNER JOIN menu_heading AS mh ON (mh.slug = p.mhSlug) INNER JOIN Categories AS c ON (p.cSlug = c.slug) WHERE p.mhSlug = 'living-room-furniture' AND p.cgSlug = 'living-room-groups' AND p.cSlug = 'living-room-groupsets' AND p.SKU = '7005cguphsolorec' LIMIT 1
Liberty Furniture Industries Sofa w/ Loveseat & Recliner
Model# 7005CGUPHSOLOREC
- Style:
- Living Room Groupsets
Kick off your shoes and sink into the majestic Blair sofa, loveseat, and recliner set. Crafted with Solid Hardwood, Plywood and Laminated Veneer Lumber, this set features Semi-Aniline Top Grain Leather with Match in a Cognac finish. PVC Vinyl is matched to the leather and is located on the outside backs and sides, meaning everywhere your body touches is real genuine leather! The Blair sofa, loveseat and recliner offers dual zero gravity power recline with a power articulating headrest. The zero gravity reclining mechanism has shown to have immense health benefits including better blood flow and helping those struggling with posture issues. In zero gravity, the neutral spine position can strengthen back muscles, decompress the spine, and reduce tension or discomfort in the neck and shoulders, resulting in enormous benefits on posture. The bucket seats add for enhanced comfort, and the full pad-over chase gives head-to-toe support. As comfortable as the Blair sofa, loveseat and recliner are, one cannot overlook the single and cross contrast stitching and the modified bustle back with a French seam that is sure to catch the eye. The loveseat features a console with a flip open top that offers deep interior storage and an AC outlet and USB-A charging port. An additional USB-A and USB-C charging port is located on each end of the sofa, loveseat and recliner. The console has two removable stainless steel cupholders for easy cleaning. With the recliners swivel glide base, you can stay engaged in conversations around the room, without having to strain your neck or leave your seat. A built in stop mechanism is used to protect the wiring during swivel. The Blair sofa, loveseat with console, and recliner is the definition of when design meets comfort.
Dimensions: W0 x D0 x H0
Weight: 700 lbs.
Dimensions: W0 x D0 x H0
Weight: 700 lbs.
Enter Your Review:
Fields marked with an asterisk (*) are required.
