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 AND ((CommonBrandID = 'GECAFE')) 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 >>

CafeSeries 27" Built-In Single Convection Wall Oven

Add To Compare

Cafe Series 27" Built-In Single Convection Wall Oven

Model Color Price
CK7000SHSS Stainless Steel Contact us for best price
Cafe27" Smart Single Wall Oven with Convection in Platinum Glass

Add To Compare

Rebates Available!

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

Rebates Available!

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
CafeSeries 30" Built-In Single Convection Wall Oven

Add To Compare

Cafe Series 30" Built-In Single Convection Wall Oven

Model Color Price
CT9050EKDS Black Slate Contact us for best price
CafeSeries 30" Built-In Single Convection Wall Oven

Add To Compare

Cafe Series 30" Built-In Single Convection Wall Oven

Model Color Price
CT9050SHSS Stainless Steel Contact us for best price
CafeSeries 30" Built-In French-Door Single Convection Wall Oven

Add To Compare

Cafe Series 30" Built-In French-Door Single Convection Wall Oven

Model Color Price
CT9070SHSS Stainless Steel Contact us for best price
CafeSeries 30" Built-In Single Convection Wall Oven

Add To Compare

Cafe Series 30" Built-In Single Convection Wall Oven

Model Color Price
CT918STSS Stainless Steel Contact us for best price
Cafe30" Smart Single Wall Oven with Convection in Platinum Glass

Add To Compare

Rebates Available!

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
Cafe30" Smart Single Wall Oven with Convection

Add To Compare

Rebates Available!

Cafe 30" Smart Single Wall Oven with Convection

Model Color Price
CTS70DP2NS1 Stainless Steel $2,888.00
Cafe30" Smart Single Wall Oven with Convection

Add To Compare

Cafe 30" Smart Single Wall Oven with Convection

Model Color Price
CTS90DP3MD1 Matte Black $2,949.00
CafeProfessional Series 30" Smart Built-In Convection Single Wall Oven

Add To Compare

Rebates Available!

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

Model Color Price
CTS90DP3ND1 Matte Black $3,443.00
CTS90DP2NS1 Stainless Steel $3,221.00
Cafe30" Smart Single Wall Oven with Convection

Add To Compare

Cafe 30" Smart Single Wall Oven with Convection

Model Color Price
CTS90DP4MW2 Matte White $3,049.00
Cafe30" Smart French-Door Single Wall Oven with Convection

Add To Compare

Cafe 30" Smart French-Door Single Wall Oven with Convection

Model Color Price
CTS90FP2MS1 Stainless Steel Contact us for best price
CafeProfessional Series 30" Smart Built-In Convection French-Door Single Wall Oven

Add To Compare

Rebates Available!

Cafe Professional Series 30" Smart Built-In Convection French-Door Single Wall Oven

Model Color Price
CTS90FP2NS1 Stainless Steel $4,332.00
CTS90FP4NW2 Matte White $4554.00 $5.00 $4,549.00
Cafe30" Smart French-Door Single Wall Oven with Convection

Add To Compare

Cafe 30" Smart French-Door Single Wall Oven with Convection

Model Color Price
CTS90FP3MD1 Matte Black $4,249.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.