Cooking - Microwaves

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 mp.Available = 1 AND ((CommonBrandID = 'BOSC')) 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
13
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

Bosch500 Series, 30", Microwave, SS, Drop Down Door

Add To Compare

Bosch 500 Series, 30", Microwave, SS, Drop Down Door

Model Color Regular Price Savings After Savings
HMB50152UC Stainless Steel $1399.00 $150.00 $1,249.00
Bosch500 Series, 27", Microwave, SS, Drop Down Door

Add To Compare

Bosch 500 Series, 27", Microwave, SS, Drop Down Door

Model Color Regular Price Savings After Savings
HMB57152UC Stainless Steel $1399.00 $150.00 $1,249.00
Bosch500 Series, 24" Speed / Convection Microwave, 120Volt, SS

Add To Compare

Bosch 500 Series, 24" Speed / Convection Microwave, 120Volt, SS

Model Color Regular Price Savings After Savings
HMC54151UC Stainless Steel $1899.00 $200.00 $1,699.00
Bosch800 Series, 30", Speed Oven, SS, 120v

Add To Compare

Bosch 800 Series, 30", Speed Oven, SS, 120v

Model Color Regular Price Savings After Savings
HMC80152UC Stainless Steel $1949.00 $200.00 $1,749.00
Bosch800 Series Speed Oven 30'' Black Stainless Steel HMC80242UC

Add To Compare

Bosch 800 Series Speed Oven 30'' Black Stainless Steel HMC80242UC

Model Color Regular Price Savings After Savings
HMC80242UC Black Stainless Steel $2199.00 $200.00 $1,999.00
Bosch800 Series, 30", Speed Oven, SS, 240v

Add To Compare

Bosch 800 Series, 30", Speed Oven, SS, 240v

Model Color Regular Price Savings After Savings
HMC80252UC Stainless Steel $2149.00 $200.00 $1,949.00
Bosch800 Series, 27", Speed Oven, SS, 120v

Add To Compare

Bosch 800 Series, 27", Speed Oven, SS, 120v

Model Color Regular Price Savings After Savings
HMC87152UC Stainless Steel $1949.00 $200.00 $1,749.00
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
Bosch300 Series OTR

Add To Compare

Bosch 300 Series OTR

Model Color Regular Price Savings After Savings
HMV3053U Stainless Steel $499.00 $50.00 $449.00
Bosch500 Series OTR

Add To Compare

Bosch 500 Series OTR

Model Color Regular Price Savings After Savings
HMV5053U Stainless Steel $649.00 $100.00 $549.00
Bosch800 Series Over-The-Range Microwave 30'' Door Hinge: Left, Black Stainless Steel HMV8044U

Add To Compare

Bosch 800 Series Over-The-Range Microwave 30'' Door Hinge: Left, Black Stainless Steel HMV8044U

Model Color Regular Price Savings After Savings
HMV8044U Black Stainless Steel $899.00 $100.00 $799.00
Bosch800 Series OTR

Add To Compare

Bosch 800 Series OTR

Model Color Regular Price Savings After Savings
HMV8053U Stainless Steel $849.00 $100.00 $749.00

Page 1 of 1
1

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