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 = 'dishwashers' AND p.cgSlug = 'dishwashers' AND p.cSlug = 'built-in-dishwashers' AND p.SKU = 'mdf18a1ast' LIMIT 1
Midea Midea MDF18A1AST Built-in Dishwasher with 8 Place Settings, 6 Washing Programs, Stainless Steel Tub, Heated Dry, Energy Star
Model# MDF18A1AST
Midea Midea MDF18A1AST Built-in Dishwasher with 8 Place Settings, 6 Washing Programs, Stainless Steel Tub, Heated Dry, Energy Star
Model# MDF18A1AST
$549
- Style:
- Built-In
- Energy Star:
- Yes
- Height:
- 32 inches
- Width:
- 18 inches
- Depth:
- 23 inches
- Number Of Cycles:
- 6
- Decibel Level:
- 52.0
- Fully Integrated Controls:
- No
- Stainless Steel Tub:
- Yes
- Tall Tub:
- No
- Wifi Enabled:
- No
Midea slimline dishwasher is perfect for small kitchens or apartments. It has a large capacity of 8 place settings, meaning you can fit all your dishes while taking up minimal space. With 6 programs and 3 functions to choose from, you can customize your wash to get the best results every time. The heated dry function ensures that your dishes come out dry and ready to use, while the HI TEMP function provides a thorough clean by using high temperature water to sanitize your dishes. The sanitize function keeping your dishes clean and safe. Additionally, this build in dishwasher is Energy Star 7.0 certified, meaning it is energy-efficient and helps you save money on your electricity bill. Upgrade your kitchen with this slimline dishwasher today!
| Installation Type | Under Counter |
| Capacity | 8 Place Settings |
| Noise | 52 dB |
| Voltage (V) | 120 Volts |
| Display Type | LED |
| Water Consumption | 15.5 Gallons per Hour |
| Water Consumption | 15.5 Gallons per Hour |
| Download | 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
