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

CafeProfessional Series 30" Smart Built-In Convection Double Wall Oven

Add To Compare

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

Model Color Regular Price Savings After Savings
CTD90DP3ND1 Matte Black $4443.00 $194.00 $4,249.00
CTD90DP2NS1 Stainless Steel $4,221.00
Cafe30" Smart Double Wall Oven with Convection

Add To Compare

Cafe 30" Smart Double Wall Oven with Convection

Model Color Price
CTD90DP4MW2 Matte White $4,049.00
Cafe30" Smart French-Door, Double Wall Oven with Convection

Add To Compare

Cafe 30" Smart French-Door, Double Wall Oven with Convection

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

Add To Compare

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

Model Color Price
CTD90FP2NS1 Stainless Steel $6,332.00
CTD90FP4NW2 Matte White $6554.00 $5.00 $6,549.00
Cafe30" Smart French-Door, Double Wall Oven with Convection

Add To Compare

Cafe 30" Smart French-Door, Double Wall Oven with Convection

Model Color Price
CTD90FP3MD1 Matte Black $6,249.00
Cafe30" Smart French-Door, Double Wall Oven with Convection

Add To Compare

Cafe 30" Smart French-Door, Double Wall Oven with Convection

Model Color Price
CTD90FP4MW2 Matte White $6,349.00
Whirlpool10 cu. ft. Double Wall Oven with extra-large oven window

Add To Compare

Whirlpool 10 cu. ft. Double Wall Oven with extra-large oven window

Model Color Price
WOD51EC0AW White Contact us for best price
Whirlpool10.0 cu. ft. Smart Double Wall Oven with Touchscreen

Add To Compare

Whirlpool 10.0 cu. ft. Smart Double Wall Oven with Touchscreen

Model Color Price
WOD51EC0HB Black $2,099.00
WOD51EC0HS Stainless Steel $2,299.00
Whirlpool8.6 cu. ft. Smart Double Wall Oven with Touchscreen

Add To Compare

Whirlpool 8.6 cu. ft. Smart Double Wall Oven with Touchscreen

Model Color Price
WOD51EC7HS Stainless Steel $2,299.00
WOD51EC7HW White 2299.00*

*See price in cart

Whirlpool6.2 Cu. Ft. Double Wall Oven with High-Heat Self-Cleaning System

Add To Compare

Whirlpool 6.2 Cu. Ft. Double Wall Oven with High-Heat Self-Cleaning System

Model Color Price
WOD51ES4EB Black $1,899.00
WOD51ES4EW White $1,899.00
Whirlpool10.0 cu. ft. Smart Double Wall Oven with True Convection Cooking Black

Add To Compare

Whirlpool 10.0 cu. ft. Smart Double Wall Oven with True Convection Cooking Black

Model Color Price
WOD77EC0HB Black Contact us for best price
WOD77EC0HV Fingerprint Resistant Black Stainless $3,099.00
Whirlpool8.6 cu. ft. Smart Double Wall Oven with True Convection Cooking

Add To Compare

Whirlpool 8.6 cu. ft. Smart Double Wall Oven with True Convection Cooking

Model Color Price
WOD77EC7HS Stainless Steel $2,999.00
LG AppliancesLG STUDIO 1.7/4.7 cu. ft. Smart wi-fi Enabled Combination Double Wall Oven

Add To Compare

LG Appliances LG STUDIO 1.7/4.7 cu. ft. Smart wi-fi Enabled Combination Double Wall Oven

Model Color Regular Price Savings After Savings
LSWC307ST Stainless Steel $4069.00 $1,070.00 $2,999.00
LG AppliancesLG STUDIO 4.7 cu. ft. Smart wi-fi Enabled Double Built-In Wall Oven

Add To Compare

LG Appliances LG STUDIO 4.7 cu. ft. Smart wi-fi Enabled Double Built-In Wall Oven

Model Color Regular Price Savings After Savings
LSWD307ST $3904.00 $1,005.00 $2,899.00
LG AppliancesLG Black Stainless Steel Series 9.4 cu. ft Total Capacity Double Wall Oven

Add To Compare

LG Appliances LG Black Stainless Steel Series 9.4 cu. ft Total Capacity Double Wall Oven

Model Color Regular Price Savings After Savings
LWD3063BD Black Stainless Steel $3299.00 $600.00 $2,699.00

Page 2 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.