Cooking - Ovens

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 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 3 of 25
<< First Page 1234 [Next 10 of 25 pages] Last Page >>

Bluestar30" Double Electric Wall Oven with Drop Down Doors

Add To Compare

Bluestar 30" Double Electric Wall Oven with Drop Down Doors

Model Color Regular Price Savings After Savings
BSDEWO30DDV2 $9540.00 $1,245.00 $8,295.00
Bluestar30" Double Electric Wall Oven with French & Drop Down Doors

Add To Compare

Bluestar 30" Double Electric Wall Oven with French & Drop Down Doors

Model Color Regular Price Savings After Savings
BSDEWO30SDV2 $10115.00 $1,320.00 $8,795.00
Fisher & PaykelDouble Oven, 30", 17 Function, Self-cleaning

Add To Compare

Fisher & Paykel Double Oven, 30", 17 Function, Self-cleaning

Model Color Regular Price Savings After Savings
OB30DDPTDX1 Stainless Steel $7034.00 $335.00 $6,699.00
Fisher & PaykelDouble Oven, 30", 8.2 cu ft, 17 Function, Self-cleaning

Add To Compare

Fisher & Paykel Double Oven, 30", 8.2 cu ft, 17 Function, Self-cleaning

Model Color Regular Price Savings After Savings
OB30DPPTX1 Stainless Steel $7034.00 $335.00 $6,699.00
Frigidaire 27'' Double Electric Wall Oven

Add To Compare

Frigidaire 27'' Double Electric Wall Oven

Model Color Regular Price Savings After Savings
FFET2726TW White $2149.00 $250.00 $1,899.00
FFET2726TS Stainless Steel $2249.00 $250.00 $1,999.00
Frigidaire 30'' Double Electric Wall Oven

Add To Compare

Frigidaire 30'' Double Electric Wall Oven

Model Color Regular Price Savings After Savings
FFET3026TW White $2149.00 $250.00 $1,899.00
FFET3026TD Black Stainless Steel $2499.00 $300.00 $2,199.00
FFET3026TS Stainless Steel $2249.00 $250.00 $1,999.00
Frigidaire Gallery 27'' Double Electric Wall Oven

Add To Compare

Frigidaire Gallery 27'' Double Electric Wall Oven

Model Color Regular Price Savings After Savings
FGET2766UF Stainless Steel $3049.00 $350.00 $2,699.00
Frigidaire Gallery 30'' Double Electric Wall Oven

Add To Compare

Frigidaire Gallery 30'' Double Electric Wall Oven

Model Color Regular Price Savings After Savings
FGET3066UD Black Stainless Steel $3249.00 $350.00 $2,899.00
Frigidaire Gallery 30'' Double Electric Wall Oven with Air Fry

Add To Compare

Frigidaire Gallery 30'' Double Electric Wall Oven with Air Fry

Model Color Regular Price Savings After Savings
FGET3069UF Stainless Steel $3249.00 $350.00 $2,899.00
Frigidaire Professional Professional 30'' Double Electric Wall Oven

Add To Compare

Frigidaire Professional Professional 30'' Double Electric Wall Oven

Model Color Regular Price Savings After Savings
FPET3077RF Stainless Steel $3349.00 $350.00 $2,999.00
GE&reg;27" Smart Built-In Double Wall Oven

Add To Compare

GE ®27" Smart Built-In Double Wall Oven

Model Color Price
JKD3000DNBB Black $2,332.00
JKD3000SNSS Stainless Steel $2,443.00
GE&reg;27" Smart Built-In Convection Double Wall Oven

Add To Compare

GE ®27" Smart Built-In Convection Double Wall Oven

Model Color Price
JKD5000DNBB Black $2,999.00
JKD5000ENES Fingerprint Resistant Slate $3,221.00
JKD5000SNSS Stainless Steel $3,110.00
GE&reg;24" Double Wall Oven

Add To Compare

GE ®24" Double Wall Oven

Model Color Price
JRP28BJBB Black On Black $1,832.00
GE&reg;30" Smart Built-In Self-Clean Double Wall Oven with Never-Scrub Racks

Add To Compare

GE ®30" Smart Built-In Self-Clean Double Wall Oven with Never-Scrub Racks

Model Color Price
JTD3000DNBB Black $2,332.00
JTD3000ENES Fingerprint Resistant Slate $2554.00 $5.00 $2,549.00
JTD3000SNSS Stainless Steel $2,443.00
GE&reg;30" Smart Built-In Self-Clean Convection Double Wall Oven with Never Scrub Racks

Add To Compare

GE ®30" Smart Built-In Self-Clean Convection Double Wall Oven with Never Scrub Racks

Model Color Price
JTD5000DNBB Black $2,999.00
JTD5000ENES Fingerprint Resistant Slate $3,221.00
JTD5000FNDS Fingerprint Resistant Black Slate $3,221.00
JTD5000SNSS Stainless Steel $3,110.00

Page 3 of 25
<< First Page 1234 [Next 10 of 25 pages] Last Page >>

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