Cooking - Ovens - Electric: Single

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-single-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 12
1234 [Next 10 of 12 pages] Last Page >>

Bosch500 Series, 30", Single Wall Oven, SS, Thermal, Knob Control

Add To Compare

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

Model Color Regular Price Savings After Savings
HBL5351UC Stainless Steel $2099.00 $200.00 $1,899.00
Bosch500 Series, 30", Single Wall Oven, SS, EU Convection, Knob Control

Add To Compare

Bosch 500 Series, 30", Single Wall Oven, SS, EU Convection, Knob Control

Model Color Regular Price Savings After Savings
HBL5451UC Stainless Steel $2449.00 $250.00 $2,199.00
Bosch500 Series, 27", Single Wall Oven, SS, EU Convection, Knob Control

Add To Compare

Bosch 500 Series, 27", Single Wall Oven, SS, EU Convection, Knob Control

Model Color Regular Price Savings After Savings
HBN5451UC Stainless Steel $2449.00 $250.00 $2,199.00
Bosch800 Series, 27", Single Wall Oven, SS, EU Convection, Touch Control

Add To Compare

Bosch 800 Series, 27", Single Wall Oven, SS, EU Convection, Touch Control

Model Color Regular Price Savings After Savings
HBN8451UC Stainless Steel $2749.00 $250.00 $2,499.00
Bosch500 Series, 24", Singe Wall Oven, Wifi Connectivity, Touch Control

Add To Compare

Bosch 500 Series, 24", Singe Wall Oven, Wifi Connectivity, Touch Control

Model Color Regular Price Savings After Savings
HBE5452UC Stainless Steel $2349.00 $250.00 $2,099.00
Bosch800 Series Combination Oven 30'' Stainless Steel HBL8753UC

Add To Compare

Bosch 800 Series Combination Oven 30'' Stainless Steel HBL8753UC

Model Color Regular Price Savings After Savings
HBL8753UC Stainless Steel $5099.00 $500.00 $4,599.00
Bosch500 Series Single Wall Oven 24'' Stainless Steel HBE5453UC

Add To Compare

Bosch 500 Series Single Wall Oven 24'' Stainless Steel HBE5453UC

Model Color Regular Price Savings After Savings
HBE5453UC Stainless Steel $2099.00 $200.00 $1,899.00
Maytag27-Inch Wide Single Wall Oven With True Convection - 4.3 Cu. Ft.

Add To Compare

Maytag 27-Inch Wide Single Wall Oven With True Convection - 4.3 Cu. Ft.

Model Color Price
MEW9527FZ Fingerprint Resistant Stainless Steel $1,899.00
Maytag30-Inch Wide Single Wall Oven with True Convection - 5.0 cu. ft.

Add To Compare

Maytag 30-Inch Wide Single Wall Oven with True Convection - 5.0 cu. ft.

Model Color Price
MEW9530FZ Fingerprint Resistant Stainless Steel $1,899.00
Beko24" Fingerprint-Free Stainless Steel Wall Oven

Add To Compare

Beko 24" Fingerprint-Free Stainless Steel Wall Oven

Model Color Price
WOS24102SS Fingerprint Free Stainless Steel $999.00
Beko30" Stainless Steel Single Wall Oven

Add To Compare

Beko 30" Stainless Steel Single Wall Oven

Model Color Price
WOS30100SS Stainless Steel $1,749.00
Beko30" Carbon Fiber Single Wall Oven

Add To Compare

Beko 30" Carbon Fiber Single Wall Oven

Model Color Price
WOS30200CF Carbon Fiber $1,949.00
Cafe27" Smart Single Wall Oven with Convection in Platinum Glass

Add To Compare

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

Model Color Regular Price Savings After Savings
CKS70DM2NS5 Platinum Glass $3110.00 $61.00 $3,049.00
Cafe27" Smart Single Wall Oven with Convection

Add To Compare

Cafe 27" Smart Single Wall Oven with Convection

Model Color Regular Price Savings After Savings
CKS70DP2NS1 Stainless Steel $2888.00 $39.00 $2,849.00
Cafe30" Smart Single Wall Oven with Convection in Platinum Glass

Add To Compare

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

Model Color Regular Price Savings After Savings
CTS70DM2NS5 Platinum Glass $3110.00 $61.00 $3,049.00

Page 1 of 12
1234 [Next 10 of 12 pages] Last Page >>

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