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 = 'top-mount' AND p.cSlug = 'top-freezer-refrigerators' AND p.SKU = 'mrt18s2aww' LIMIT 1
Midea 18 Cu. Ft. Top Mount Freezer Refrigerator
Model# MRT18S2AWW
- Style:
- Top Freezer
- Energy Star:
- Yes
- Height:
- 67 inches
- Width:
- 30 inches
- Depth:
- 31 inches
- Capacity:
- 18 cu ft
- Number Of Shelves:
- 4
- Counter Depth:
- No
- Includes Dispenser:
- No
- Includes Icemaker:
- No
- Sabbath Mode:
- No
- Wifi Enabled:
- No
Electronic Control
Adjusting the temperature is quick and easy with electonic controls.
Keep produce fresher, longer.
Dual Crisper drawers hold in moisture to keep fruits and vegetables fresh for longer.
Top-Mount Freezer
Convenient, energy-efficient top-mount freezer for easy retrieval of frozen foods.
| Model Number | MRT18S2AWW |
| UPC | 810004817845 |
| Color | White |
| Total Capacity (Cubic Ft) | 18 |
| Refrigerator Capacity (Cubic Ft) | 14 |
| Freezer Capacity (Cubic Ft) | 4 |
| Child Safety Locks | No |
| Interior LED Light | |
| Control Type | Electronic |
| Water Filter | No |
| Water Dispenser | No |
| Ice Maker | No (sold separately) |
| Compatible Ice Maker Accessory | Model Number IM1800MD |
| Utility Deli Drawer | No |
| Frost Free | |
| Energy Star Certified | |
| CEE Tier Qualified | N/A |
| Certifications | UL |
| Product Dimensions (in) W*D*H | 29.53" x 30.94" x 66.6" |
| Reversible Door | |
| Leveling Legs | |
| Rolling Casters | 4 |
| Door Handle Design | Recessed |
| Door Finish | Textured |
| Crisper Drawers | 2 |
| No. of Shelves | 3 (2, wired. 1, glass) |
| Adjustable Shelves | |
| 2-Liter Bottle Storage | No |
| Gallon Storage | |
| Door Shelves | 5 |
| Removable Bin Basket | No |
| Temperature Controlled Drawer | No |
| Freezer Type | Top Mount |
| Freezer Shelves | 1 |
| Door Shelves | 2 |
| Warranty | 1-year limited |
| Download | Click here to download |
|---|---|
| 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
