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 = '7006dbuphsolorec' LIMIT 1
Liberty Furniture Industries Sofa w/ Loveseat & Recliner
Model# 7006DBUPHSOLOREC
- Style:
- Living Room Groupsets
Kick up your feet and relax with the Carrington sofa, loveseat and recliner set. Crafted with Solid Hardwood, Plywood, and Laminated Veneer Lumber, this set features a Semi-Aniline Top Grain Leather with Match in a Dark Brown finish. PVC Vinyl is matched to the leather and used on the outside backs and sides, meaning everywhere your body touches is real genuine leather! The Carrington sofa, loveseat and recliner offers triple zero gravity power recline with an articulating headrest and powered lumbar support for optimal comfort. 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. An added layer of memory foam is added to the bucket seats, meaning this sofa, loveseat and recliner is not only a dream to lounge in, but is built to last. The full pad-over chaise ensures head-to-toe support. The contrast single stitching, attractive welt trim, and tufted pub back with a French seam works in any d(eback)cor and is sure to delight the eye. The loveseat features a console with a flip-open top with deep interior storage and an AC and USB-A charging port located within. A wireless charging pad adorns the top of the console for extreme convenience. Wow your friends by pushing the power button on top of the console and watch the bottom section open like magic to reveal two hidden, stainless steel, removable and washable cupholders! With today s technology in mind, each end of the sofa, loveseat and recliner offers a USB-A and USB-C charging ports. The swivel glide base on the recliner allows you to 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. Lounging has never looked so good with the Carrington sofa, loveseat and recliner set.
Dimensions: W0 x D0 x H0
Weight: 747 lbs.
Dimensions: W0 x D0 x H0
Weight: 747 lbs.
Enter Your Review:
Fields marked with an asterisk (*) are required.
