Cooking - Ovens - Electric: Double

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 = 'ovens' AND cSlug = 'electric-double-ovens' 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 7
1234 Last Page >>

Bosch500 Series, 30", Double Wall Oven, SS, Thermal/Thermal, Knob Control

Add To Compare

Bosch 500 Series, 30", Double Wall Oven, SS, Thermal/Thermal, Knob Control

Model Color Regular Price Savings After Savings
HBL5551UC Stainless Steel $3199.00 $300.00 $2,899.00
Bosch500 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Add To Compare

Bosch 500 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Model Color Regular Price Savings After Savings
HBL5651UC Stainless Steel $3549.00 $350.00 $3,199.00
Bosch800 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Add To Compare

Bosch 800 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Model Color Regular Price Savings After Savings
HBL8651UC Stainless Steel $3999.00 $400.00 $3,599.00
Bosch500 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Add To Compare

Bosch 500 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Model Color Regular Price Savings After Savings
HBN5651UC Stainless Steel $3549.00 $350.00 $3,199.00
Bosch800 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Add To Compare

Bosch 800 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Model Color Regular Price Savings After Savings
HBN8651UC Stainless Steel $3999.00 $400.00 $3,599.00
Bosch800 Series Double Wall Oven 30'' Black Stainless Steel HBL8642UC

Add To Compare

Bosch 800 Series Double Wall Oven 30'' Black Stainless Steel HBL8642UC

Model Color Regular Price Savings After Savings
HBL8642UC Black Stainless Steel $4199.00 $400.00 $3,799.00
Maytag27-Inch Wide Double Wall Oven With True Convection - 8.6 Cu. Ft.

Add To Compare

Maytag 27-Inch Wide Double Wall Oven With True Convection - 8.6 Cu. Ft.

Model Color Price
MEW9627FZ Fingerprint Resistant Stainless Steel $2,799.00
Maytag30-Inch Wide Double Wall Oven With True Convection - 10.0 Cu. Ft.

Add To Compare

Maytag 30-Inch Wide Double Wall Oven With True Convection - 10.0 Cu. Ft.

Model Color Price
MEW9630FZ Fingerprint Resistant Stainless Steel $2,799.00
Cafe27" Smart Double Wall Oven with Convection in Platinum Glass

Add To Compare

Cafe 27" Smart Double Wall Oven with Convection in Platinum Glass

Model Color Price
CKD70DM2NS5 Platinum Glass $4,110.00
Cafe27" Smart Double Wall Oven with Convection

Add To Compare

Cafe 27" Smart Double Wall Oven with Convection

Model Color Regular Price Savings After Savings
CKD70DP2NS1 Stainless Steel $3888.00 $39.00 $3,849.00
Cafe30 in. Combination Double Wall Oven with Convection and Advantium&reg; Technology

Add To Compare

Cafe 30 in. Combination Double Wall Oven with Convection and Advantium® Technology

Model Color Regular Price Savings After Savings
CTC912P2NS1 Stainless Steel $4443.00 $94.00 $4,349.00
Cafe30" Smart Double Wall Oven with Convection in Platinum Glass

Add To Compare

Cafe 30" Smart Double Wall Oven with Convection in Platinum Glass

Model Color Regular Price Savings After Savings
CTD70DM2NS5 Platinum Glass $4221.00 $72.00 $4,149.00
Cafe30" Smart Double Wall Oven with Convection

Add To Compare

Cafe 30" Smart Double Wall Oven with Convection

Model Color Regular Price Savings After Savings
CTD70DP2NS1 Stainless Steel $3888.00 $39.00 $3,849.00
Cafe30" Smart Double Wall Oven with Convection

Add To Compare

Cafe 30" Smart Double Wall Oven with Convection

Model Color Price
CTD90DP3MD1 Matte Black $3,949.00
CafeProfessional Series 30" Smart Built-In Convection Double Wall Oven

Add To Compare

Cafe Professional Series 30" Smart Built-In Convection Double Wall Oven

Model Color Regular Price Savings After Savings
CTD90DP3ND1 Matte Black $4443.00 $194.00 $4,249.00
CTD90DP2NS1 Stainless Steel $4,221.00

Page 1 of 7
1234 Last Page >>

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