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-cabinets' AND p.cSlug = 'cabinets' AND p.SKU = 'd64776' LIMIT 1
Ashley Furniture Bolanburg Display Cabinet
Model# D64776
Was $979.00
$779
- Style:
- Cabinets
- Height:
- 75 inches
- Width:
- 25 inches
- Depth:
- 14 inches
Need a stylish space to showcase dinnerware, pictures, decorations and more? This tall three-shelf display cabinet is a dream come true. The textured antiqued white finish provides a perfect backdrop for presentation. For the items you want to hide, there are two deep drawers. Embellished with the casual appeal of lattice sides, attractive crown moulding, clean lines and lightly distressed finish, this cottage-style shelf provides ample storage in such an artful way.
| Product Specifications | |
| Brand Name | Signature Design by Ashley® |
| Color | Antique White |
| Consumer Assembly | Assembly Required |
| Consumer Description | Display Cabinet |
| Friendly Description | Display Cabinet |
| Import Domestic | Import |
| Item Code | Server |
| Item Color Key | 1634 |
| Item Name | Bolanburg Display Cabinet |
| Item Series Name | Bolanburg |
| Item Type | Item |
| Item Weight Kg | 49.9 |
| Item Weight Lbs | 110 |
| Manufacturer Warranty Days | 365 |
| Number of Drawers | 2 Drawer |
| Number of Shelves | 3 Shelves |
| Retail Type | Formal Dining Cases |
| Seat Count | 0 |
| Series Id | D647 |
| Sku | D647-76 |
| Unit Depth Inches | 14.38 |
| Unit Depth Mm | 365.25 |
| Unit Friendly Dimensions Inches | 25''W x 15''D x 75''H |
| Unit Friendly Dimensions Mm | 0 |
| Unit Height Inches | 75 |
| Unit Height Mm | 1905 |
| Unit Width Inches | 25.38 |
| Unit Width Mm | 644.65 |
| Upc | 024052362558 |
| Vendor Name | AFI |
| Assembly Instructions | Click here to download |
|---|
Enter Your Review:
Fields marked with an asterisk (*) are required.
