Cooking - Microwaves - Drawers

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.StandardColor, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,if(p.CustomDescription IS NOT NULL AND p.CustomDescription <> '', p.CustomDescription, p.ModelDescription) AS ModelDescription,if(p.thumb LIKE 'http%',p.thumb, concat('/uploads/products/',p.thumb)) AS thumb ,if(p.large LIKE 'http%',p.large, concat('/uploads/products/',p.large)) AS large , mp.PowerBuy, mp.quick_ship, bd.preferred ,IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS SortPrice, bd.CommonBrandID,mh.super_category, mp.ge_inv FROM tbl_store_brands AS sb INNER JOIN Brand_Data AS bd ON bd.pkID = sb.brandID+0 INNER JOIN tbl_products AS p ON sb.categoryID = p.pkCategory AND sb.brandID = p.pkBrand INNER JOIN ModelPrice AS mp ON (p.SKU = mp.SKU AND p.pkSKU = mp.pkSKU) INNER JOIN menu_heading AS mh ON mh.slug = p.mhSlug WHERE p.mhSlug = 'cooking' AND cgSlug = 'microwaves' AND cSlug = 'microwave-drawers' AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY IF(quick_ship =1,quick_ship,999999) ASC, FIELD(p.cSlug, 'grill-accessories') ASC, p.cSlug, display_sequence ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU
15
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 2
12 Last Page >>

Bosch800 Series, 30" Drawer Microwave

Add To Compare

Bosch 800 Series, 30" Drawer Microwave

Model Color Regular Price Savings After Savings
HMD8053UC Stainless Steel $1799.00 $200.00 $1,599.00
Bosch800 Series, 24" Drawer Microwave

Add To Compare

Bosch 800 Series, 24" Drawer Microwave

Model Color Regular Price Savings After Savings
HMD8451UC Stainless Steel $1649.00 $150.00 $1,499.00
MonogramMonogram 1.2 Cu. Ft. Drawer Microwave

Add To Compare

Monogram Monogram 1.2 Cu. Ft. Drawer Microwave

Model Color Price
ZWL1126SJSS Stainless Steel Contact us for best price
JennAirStainless Steel 24" Under Counter Microwave Oven with Drawer Design

Add To Compare

JennAir Stainless Steel 24" Under Counter Microwave Oven with Drawer Design

Model Color Price
JMDFS24GS Stainless Steel Contact us for best price
JennAirNOIR 24" Under Counter Microwave Oven with Drawer Design

Add To Compare

JennAir NOIR 24" Under Counter Microwave Oven with Drawer Design

Model Color Price
JMDFS24HM Floating Glass Black Contact us for best price
JennAirRISE 30" Under Counter Microwave Oven with Drawer Design

Add To Compare

JennAir RISE 30" Under Counter Microwave Oven with Drawer Design

Model Color Price
JMDFS30HL Stainless Steel Contact us for best price
JennAirNOIR 30" Under Counter Microwave Oven with Drawer Design

Add To Compare

JennAir NOIR 30" Under Counter Microwave Oven with Drawer Design

Model Color Price
JMDFS30HM Floating Glass Black Contact us for best price
KitchenAid24" Under-Counter Microwave Oven Drawer - Stainless Steel

Add To Compare

KitchenAid 24" Under-Counter Microwave Oven Drawer - Stainless Steel

Model Color Price
KMBD104GSS Stainless Steel $1,599.00
Sharp Appliances24 in. 1.2 cu. ft. 950W Sharp Easy Open Stainless Steel Microwave Drawer

Add To Compare

Sharp Appliances 24 in. 1.2 cu. ft. 950W Sharp Easy Open Stainless Steel Microwave Drawer

Model Color Regular Price Savings After Savings
KB6524PSY $1349.99 $302.99 $1,047.00
Sharp Appliances24 in. Under the Counter Microwave Drawer Oven Pedestal

Add To Compare

Sharp Appliances 24 in. Under the Counter Microwave Drawer Oven Pedestal

Model Color Regular Price Savings After Savings
SKMD24U0ES $899.99 $202.99 $697.00
Sharp Appliances30 in. Extension Kit for Sharp SMD2480CS Microwave Drawer Oven

Add To Compare

Sharp Appliances 30 in. Extension Kit for Sharp SMD2480CS Microwave Drawer Oven

Model Color Price
SKMD30E3DS $249.99
Sharp Appliances24 in. 1.2 cu. ft. 950W Sharp Black Stainless Steel Microwave Drawer Oven

Add To Compare

Sharp Appliances 24 in. 1.2 cu. ft. 950W Sharp Black Stainless Steel Microwave Drawer Oven

Model Color Regular Price Savings After Savings
SMD2470AH $1749.99 $402.99 $1,347.00
Sharp Appliances24 in. 1.2 cu. ft. 950W Sharp Stainless Steel Microwave Drawer Oven

Add To Compare

Sharp Appliances 24 in. 1.2 cu. ft. 950W Sharp Stainless Steel Microwave Drawer Oven

Model Color Regular Price Savings After Savings
SMD2470ASY $1599.99 $352.99 $1,247.00
Sharp Appliances24 in. 1.2 cu. ft. 950W Sharp Stainless Steel IoT Easy Wave Open Microwave Drawer Oven

Add To Compare

Sharp Appliances 24 in. 1.2 cu. ft. 950W Sharp Stainless Steel IoT Easy Wave Open Microwave Drawer Oven

Model Color Regular Price Savings After Savings
SMD2489ES $1849.99 $402.99 $1,447.00

Page 1 of 2
12 Last Page >>

Added to Cart
Model#
Enter Zip Code*For delivery options
Final discounts, tax, and shipping costs at checkout.