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 11 of 25
<< First Page [Previous 10 pages] 9101112 [Next 10 of 25 pages] Last Page >>

Fisher & PaykelOven, 30", 17 Function, Self-cleaning

Add To Compare

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

Model Color Regular Price Savings After Savings
OB30SDPTDX1 Stainless Steel $4934.00 $235.00 $4,699.00
Fisher & PaykelOven, 30", 17 Function, Self-cleaning

Add To Compare

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

Model Color Regular Price Savings After Savings
OB30SDPTX1 Stainless Steel $4934.00 $235.00 $4,699.00
Fisher & PaykelOven, 30", 4.1 cu ft, 17 Function, Self-cleaning

Add To Compare

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

Model Color Regular Price Savings After Savings
OB30SPPTX1 Stainless Steel $4934.00 $235.00 $4,699.00
Fisher & PaykelConvection Speed Oven 24"

Add To Compare

Fisher & Paykel Convection Speed Oven 24"

Model Color Regular Price Savings After Savings
OM24NDB1 Stainless Steel $2624.00 $125.00 $2,499.00
Fisher & PaykelConvection Speed Oven 24"

Add To Compare

Fisher & Paykel Convection Speed Oven 24"

Model Color Regular Price Savings After Savings
OM24NDBB1 Black $2624.00 $125.00 $2,499.00
Fisher & PaykelCombination Steam Oven, 24", 9 Function

Add To Compare

Fisher & Paykel Combination Steam Oven, 24", 9 Function

Model Color Regular Price Savings After Savings
OS24NDBB1 Black $3674.00 $175.00 $3,499.00
Frigidaire 24'' Single Electric Wall Oven

Add To Compare

Frigidaire 24'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FFEW2426US Stainless Steel $1799.00 $200.00 $1,599.00
FFEW2426UW White $1599.00 $200.00 $1,399.00
Frigidaire 27'' Single Electric Wall Oven

Add To Compare

Frigidaire 27'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FFEW2726TS Stainless Steel $1499.00 $200.00 $1,299.00
FFEW2726TW White $1399.00 $200.00 $1,199.00
Frigidaire 30'' Single Electric Wall Oven

Add To Compare

Frigidaire 30'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FFEW3026TS Stainless Steel $1499.00 $200.00 $1,299.00
FFEW3026TB Black $1399.00 $200.00 $1,199.00
FFEW3026TD Black Stainless Steel $1599.00 $200.00 $1,399.00
Frigidaire Gallery 27'' Single Electric Wall Oven

Add To Compare

Frigidaire Gallery 27'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FGEW2766UD Black Stainless Steel $2249.00 $250.00 $1,999.00
Frigidaire Gallery 27'' Single Electric Wall Oven

Add To Compare

Frigidaire Gallery 27'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FGEW276SPF Stainless Steel $2249.00 $250.00 $1,999.00
Frigidaire Gallery 30'' Single Electric Wall Oven

Add To Compare

Frigidaire Gallery 30'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FGEW3046UF Stainless Steel $1949.00 $250.00 $1,699.00
Frigidaire Gallery 30'' Single Electric Wall Oven

Add To Compare

Frigidaire Gallery 30'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FGEW3066UD Black Stainless Steel $2249.00 $250.00 $1,999.00
Frigidaire Gallery 30'' Single Electric Wall Oven with Air Fry

Add To Compare

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

Model Color Regular Price Savings After Savings
FGEW3069UF Stainless Steel $2349.00 $250.00 $2,099.00
Frigidaire Professional Professional 30'' Single Electric Wall Oven

Add To Compare

Frigidaire Professional Professional 30'' Single Electric Wall Oven

Model Color Regular Price Savings After Savings
FPEW3077RF Stainless Steel $2299.00 $250.00 $2,049.00

Page 11 of 25
<< First Page [Previous 10 pages] 9101112 [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.