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 = 'laundry' AND p.cgSlug = 'washers' AND p.cSlug = 'front-load-washers' AND p.SKU = 'mlh25n7bww' LIMIT 1
Midea 24" Front Load Washer
Model# MLH25N7BWW
Midea 24" Front Load Washer
Model# MLH25N7BWW
$1,099
- Style:
- Front Load
- Energy Star:
- Yes
- Height:
- 33 inches
- Width:
- 23 inches
- Depth:
- 27 inches
- Internal Water Heater:
- No
- Steam Option:
- Yes
- Wash Mechanism:
- HIGH EFFICIENCY
- Wifi Enabled:
- No
This compact front load washer is 24" wide and can easily fit under a countertop, side by side or stacked; for the most efficient use of your space. The Steam cycle, helps to penetrate deep into your fabrics to loosen stains while still being gentle on your clothing. With an internal heater to raise water temperatures, the Sanitize Cycle is tough on stains, allergens and bacteria. The boosted cleaning power of this washer makes doing laundry easier.
| Model Number | MLH25N7BWW |
| Color | White |
| Number of Cycles | 16 (My cycle,Mixed load,Heavy duty,Bulky,Towels,Active wear,Delicates,Sanitize,Normal,Jeans,Perm press,Quick Dry,Wool,Air Fluff,Time Dry,Refresh) |
| Number of Options | 8 (Wrinkle prevent,Delay,Dryness,Time Adjust,Child Lock ,My cycle,Damp alert,Signal) |
| Child Lock | |
| Sensor Dry | |
| End-of-Cycle Signal | |
| Time Remaining Display | |
| Safety Certification | UL |
| Energy Star | |
| Voltage | 120 |
| Power Cord Included | N/A |
| Amperage (A) | 4 |
| Door | Glass |
| Drum Material | Aluminium zinc coated plate |
| Cabinet Finish | Galvanized steel sheet |
| Product Dimensions (W*D*H) inches | 23in x 25in x 33in |
| Product Dimensions (W*D*H) millimeters | 595mm x 653mm x 850mm |
| Net Weight (lbs) | 121 lbs / 55kg |
| 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
