Cooking - Microwaves - Built-In

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 = 'built-in-microwaves' AND mp.Available = 1 AND ((CommonBrandID = 'JENN')) 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
8
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

JennAirStainless Steel 22" Built-In/Countertop Microwave Oven

Add To Compare

JennAir Stainless Steel 22" Built-In/Countertop Microwave Oven

Model Color Price
JMC1116AS Stainless Steel Contact us for best price
JennAir27 INCH ELEC CONV BUILT-IN MWO Stainless Steel

Add To Compare

JennAir 27 INCH ELEC CONV BUILT-IN MWO Stainless Steel

Model Color Price
JMC2427DS Stainless Steel Contact us for best price
JennAirEuro-Style 30" Built-In Microwave Oven with Speed-Cook Stainless Steel

Add To Compare

JennAir Euro-Style 30" Built-In Microwave Oven with Speed-Cook Stainless Steel

Model Color Price
JMC2430DS Stainless Steel Contact us for best price
JennAirStainless Steel 25"Countertop Microwave Oven with Convection

Add To Compare

JennAir Stainless Steel 25"Countertop Microwave Oven with Convection

Model Color Price
JMC3415ES Stainless Steel Contact us for best price

Page 1 of 1
1

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