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 = 'dining-room-furniture' AND p.cgSlug = 'dining-tables' AND p.cSlug = 'tables' AND p.SKU = 'd40252' LIMIT 1
Ashley Furniture Wilinruck Counter Height Dining Table
Model# D40252
Ashley Furniture Wilinruck Counter Height Dining Table
Model# D40252
Was $339.00
$299
- Style:
- Tables
- Table Type:
- DINING TABLE
This stunningly simple solid mango wood dining table works effortlessly with contemporary decor. This narrow counter height table is perfect for smaller dining spaces. Or for added function, place it behind a sofa or sectional to make the most of your family room. The tabletop's gorgeous, natural-looking color contrasts nicely with the matte black metal legs, providing an instant upgrade to your space.
| Product Specifications | |
| Brand Name | Signature Design by Ashley® |
| Color | Brown/Black |
| Consumer Assembly | No Assembly Required |
| Consumer Description | Counter Height Dining Table |
| Dining Table Height | Counter Height |
| Friendly Description | Long Counter Table |
| Import Domestic | Import |
| Item Code | Counter Height Table |
| Item Color Key | 1756 |
| Item Name | Wilinruck Counter Height Dining Table |
| Item Series Name | Wilinruck |
| Item Type | Item |
| Item Weight Kg | 34.47 |
| Item Weight Lbs | 76 |
| Manufacturer Warranty Days | 365 |
| Outdoor Seating Capacity | 3 |
| Retail Type | Casual Tables |
| Seat Count | 0 |
| Seating Capacity | 3 |
| Series Id | D402 |
| Sku | D402-52 |
| Table Base | Leg |
| Unit Depth Inches | 17.25 |
| Unit Depth Mm | 438.15 |
| Unit Friendly Dimensions Inches | 70''W x 17''D x 36''H |
| Unit Friendly Dimensions Mm | 0 |
| Unit Height Inches | 35.75 |
| Unit Height Mm | 908.05 |
| Unit Width Inches | 70.13 |
| Unit Width Mm | 1781.3 |
| Upc | 024052814835 |
| Vendor Name | AFI |
| Assembly Instructions | Click here to download |
|---|
Enter Your Review:
Fields marked with an asterisk (*) are required.
