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 = 'home-office-furniture' AND p.cgSlug = 'home-office-furniture' AND p.cSlug = 'desks' AND p.SKU = 'h400110' LIMIT 1
Ashley Furniture Lynxtyn 48" Home Office Desk
Model# H400110
Was $439.00
$399
- Style:
- Desks
Ultra mod. Work smarter-and look cool doing it-with the new-age efficiency of this desk. Its streamlined design is accented with a tech-inspired decorative laminate surface and PVC insert for mouse tracking. This super sleek yet fully loaded home office desk includes a raised monitor stand with LED ambient lighting, a headset hanger conveniently mounted on the side and a mesh modesty panel underneath for managing all your cords. And with an integrated cup holder, wireless Qi charger and 110V power supply with dual USB ports for charging all your devices, this desk really is designed to keep you up and running.
| Product Specifications | |
| Brand Name | Signature Design by Ashley® |
| Color | Black |
| Consumer Assembly | Assembly Required |
| Consumer Description | 48" Home Office Desk |
| Friendly Description | Home Office Desk |
| Import Domestic | Import |
| Item Code | Desk |
| Item Color Key | 1670 |
| Item Name | Lynxtyn 48" Home Office Desk |
| Item Series Name | Lynxtyn |
| Item Type | Item |
| Item Weight Kg | 19.96 |
| Item Weight Lbs | 44 |
| Manufacturer Warranty Days | 365 |
| Retail Type | Desks |
| Seat Count | 0 |
| Series Id | H400 |
| Sku | H400-110 |
| Unit Depth Inches | 26.75 |
| Unit Depth Mm | 679.45 |
| Unit Friendly Dimensions Inches | 50''W x 27''D x 36''H |
| Unit Friendly Dimensions Mm | 0 |
| Unit Height Inches | 36 |
| Unit Height Mm | 914.4 |
| Unit Width Inches | 49.5 |
| Unit Width Mm | 1257.3 |
| Upc | 024052778670 |
| Vendor Name | AFI |
| Assembly Instructions | Click here to download |
|---|
Enter Your Review:
Fields marked with an asterisk (*) are required.
