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 = 'refrigeration' AND p.cgSlug = 'specialty' AND p.cSlug = 'beverage-coolers' AND p.SKU = 'dbc121a1blp' LIMIT 1
- Style:
- Beverage Coolers
- Energy Star:
- No
- Height:
- 33 inches
- Width:
- 18 inches
- Depth:
- 20 inches
- Capacity:
- 3 cu ft
- Number Of Shelves:
- 3
- Counter Depth:
- No
- Includes Dispenser:
- No
- Includes Icemaker:
- No
- Sabbath Mode:
- No
- Wifi Enabled:
- No
Whether you find yourself entertaining guests or needing more convenient refrigeration for your family, this supreme beverage center delivers style and practicality. This beverage center is perfect for kitchen organization and hosting in small spaces such as an apartment, condo, or cottage! Save fridge space for food or leftovers with this spacious unit offering 3.5 cubic feet (93 L) of cooling and storage space. Cool up to 120 (355 ml) beverage cans under energy-efficient LED lights on three wired shelves. Designed with an adjustable temperature range, this beer chiller can be set anywhere between 39F 64F (4C 18C). This small refrigerator also features a clever, reversible door hinge that enables you to adjust it for a left or right-handed opening.
| Product Dimensions | ||
| Product Width | 17.5" | 44.45 cm |
| Product Depth | 20.1" | 51.05 cm |
| Product Height | 32.8" | 83.31 cm |
| Interior Width | 15.4" | 39.12 cm |
| Interior Depth | 14.9" | 37.85 cm |
| Interior Height | 29.3" | 74.42 cm |
| Package Dimensions | ||
| Package Width | 19.3" | 49.02 cm |
| Package Depth | 22.3" | 56.64 cm |
| Package Height | 36" | 91.44 cm |
| Weight | ||
| Product Weight | 58.6 lbs | 26.58 kg |
| Package Weight | 72.8 lbs | 33.02 kg |
| Owners Manual (PDF) | Click here to download |
|---|---|
| Energy Guide (PDF) | Click here to download |
| Product Specifications (PDF) | Click here to download |
| Owners Manual (PDF) | Click here to download |
| Energy Guide (PDF) | Click here to download |
| Product Specifications (PDF) | Click here to download |
Enter Your Review:
Fields marked with an asterisk (*) are required.
CALIFORNIA RESIDENTS ONLY - WARNING: Cancer and Reproductive Harm - www.P65Warnings.ca.gov
