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 = 'recliners' AND p.cSlug = 'recliners' AND p.SKU = '016777' LIMIT 1
La-Z-Boy Randell Wall Recliner
Model# 016777
- Style:
- Recliners
- Arm Type:
- PILLOW
- Back Style:
- TUFTED
- Back Type:
- ATTACHED
- Exposed Material:
- LIGHT STAIN
- Skirted:
- Yes
Big on comfort, big on style. That s the word on our new Randell Wall Recliner. Designed especially for taller users, this casual family favorite features deep cushions, an extra-tall back and generous proportions that invite you to kick back and relax. What s more, Randell comes standard with many of our popular tall enhancements, including a tall base, elongated handle, deep chaise seat, higher-density foam and a newly updated design that features an extra-long legrest. Simply use the convenient handle on the outside arm to raise the legrest for reading, relaxing or watching TV. Best of all, you can place this recliner mere inches from a wall.
| Handcrafted in North America | Yes |
| Adjustable Lumbar | No |
| Adjustable Headrest | No |
| Limited Lifetime Warranty | Yes |
| Number of Cushions | 1 |
| Lift Function | No |
| Power | No |
| Heat & Massage | No |
| USB Charging Port | No |
| Overall Dimensions (in.) | 45.5W x 41.5D x 46.5H |
| Arm Height | 207 in. |
| Fully Reclined Dimension | 75 in. |
| Weight | 108 lb. |
| Body Width | 45.5 in. |
| Body Depth | 41.5 in. |
| Body Height | 46.5 in. |
| Seat Width | 24 in. |
| Seat Depth | 22 in. |
| Seat Height | 21.5 in. |
| Download Product Manual | Click here to download |
|---|
Enter Your Review:
Fields marked with an asterisk (*) are required.
