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

MonogramMonogram 30" Smart Electric Convection Double Wall Oven Minimalist Collection

Add To Compare

Monogram Monogram 30" Smart Electric Convection Double Wall Oven Minimalist Collection

Model Color Price
ZTDX1DSSNSS Stainless Steel
Available as soon as:04/29/2024
Contact us for best price
GE ProfileGE PROFILEGE Profile&trade; 27" Smart Built-In Convection Double Wall Oven

Add To Compare

GE Profile GE PROFILE GE Profile™ 27" Smart Built-In Convection Double Wall Oven

Model Color Regular Price Savings After Savings
PKD7000BNTS Black Stainless $3888.00 $39.00 $3,849.00
GE ProfileGE PROFILEGE Profile&trade; 30" Smart Built-In Convection Double Wall Oven with No Preheat Air Fry and Precision Cooking

Add To Compare

GE Profile GE PROFILE GE Profile™ 30" Smart Built-In Convection Double Wall Oven with No Preheat Air Fry and Precision Cooking

Model Color Regular Price Savings After Savings
PTD7000BNTS Black Stainless $3888.00 $39.00 $3,849.00
GE ProfileGE Profile&trade; 30" Smart Built-In Convection Double Wall Oven with Left-Hand Side-Swing Doors

Add To Compare

GE Profile GE Profile™ 30" Smart Built-In Convection Double Wall Oven with Left-Hand Side-Swing Doors

Model Color Regular Price Savings After Savings
PTD700LSNSS Stainless Steel $4221.00 $72.00 $4,149.00
GE ProfileGE Profile&trade; 30" Smart Built-In Convection Double Wall Oven with Right-Hand Side-Swing Doors

Add To Compare

GE Profile GE Profile™ 30" Smart Built-In Convection Double Wall Oven with Right-Hand Side-Swing Doors

Model Color Regular Price Savings After Savings
PTD700RSNSS Stainless Steel $4221.00 $72.00 $4,149.00
GE ProfileGE Profile&trade; 30" Smart Built-In Convection Double Wall Oven with In-Oven Camera and No Preheat Air Fry

Add To Compare

GE Profile GE Profile™ 30" Smart Built-In Convection Double Wall Oven with In-Oven Camera and No Preheat Air Fry

Model Color Regular Price Savings After Savings
PTD9000BNTS Black Stainless $4221.00 $72.00 $4,149.00
GE ProfileGE Profile&trade; 30" Smart Built-In Twin Flex Convection Wall Oven

Add To Compare

GE Profile GE Profile™ 30" Smart Built-In Twin Flex Convection Wall Oven

Model Color Price
PTS9200SNSS Stainless Steel $3,443.00
JennAirEuro-Style 27" Double Wall Oven with Upper MultiMode&reg; Convection System Stainless Steel

Add To Compare

JennAir Euro-Style 27" Double Wall Oven with Upper MultiMode® Convection System Stainless Steel

Model Color Price
JJW2727DS Stainless Steel Contact us for best price

Page 4 of 25
<< First Page 2345 [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.