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 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 12
<< First Page 1234 Last Page >>

Whirlpool3.1 Cu. Ft. Single Wall Oven with High-Heat Self-Cleaning System

Add To Compare

Whirlpool 3.1 Cu. Ft. Single Wall Oven with High-Heat Self-Cleaning System

Model Color Price
WOS51ES4EB Black $1,499.00
WOS51ES4EW White $1,499.00
Whirlpool5.0 cu. ft. Smart Single Wall Oven with True Convection Cooking Black

Add To Compare

Whirlpool 5.0 cu. ft. Smart Single Wall Oven with True Convection Cooking Black

Model Color Price
WOS72EC0HB Black Contact us for best price
WOS72EC0HV Fingerprint Resistant Black Stainless $2,199.00
Whirlpool4.3 cu. ft. Smart Single Wall Oven with True Convection Cooking Black

Add To Compare

Whirlpool 4.3 cu. ft. Smart Single Wall Oven with True Convection Cooking Black

Model Color Price
WOS72EC7HB Black Contact us for best price
WOS72EC7HV Fingerprint Resistant Black Stainless $2,199.00
LG AppliancesSTUDIOLG STUDIO 4.7 cu. ft. Single Built-In Wall Oven

Add To Compare

LG Appliances STUDIO LG STUDIO 4.7 cu. ft. Single Built-In Wall Oven

Model Color Price
LSWS306ST Stainless Steel Contact us for best price
LG AppliancesLG STUDIO 4.7 cu. ft. Smart wi-fi Enabled Single Built-In Wall Oven

Add To Compare

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

Model Color Regular Price Savings After Savings
LSWS307ST Stainless Steel $2584.00 $685.00 $1,899.00
LG AppliancesSTUDIOLG STUDIO 4.7 cu. ft. Single Built-In Wall Oven

Add To Compare

LG Appliances STUDIO LG STUDIO 4.7 cu. ft. Single Built-In Wall Oven

Model Color Price
LSWS309BD Black Stainless Steel Contact us for best price
LG Appliances4.7 cu. ft. Single Built-In Wall Oven

Add To Compare

LG Appliances 4.7 cu. ft. Single Built-In Wall Oven

Model Color Regular Price Savings After Savings
LWS3063BD Black Stainless Steel $2199.00 $400.00 $1,799.00
Blomberg24" Built in Wall Oven Single, stainless, full glass door moon design

Add To Compare

Blomberg 24" Built in Wall Oven Single, stainless, full glass door moon design

Model Color Price
BWOS24110SS Stainless Steel Contact us for best price
Blomberg30" Single Wall Oven, self clean, cool touch glass, stainless

Add To Compare

Blomberg 30" Single Wall Oven, self clean, cool touch glass, stainless

Model Color Price
BWOS30200SS Stainless Steel Contact us for best price
Bluestar30" Electric Wall Oven with Drop Down Door

Add To Compare

Bluestar 30" Electric Wall Oven with Drop Down Door

Model Color Regular Price Savings After Savings
BSEWO30DDV2 $6090.00 $795.00 $5,295.00
Bluestar30" Electric Wall Oven with French Doors

Add To Compare

Bluestar 30" Electric Wall Oven with French Doors

Model Color Regular Price Savings After Savings
BSEWO30SDV2 $6665.00 $870.00 $5,795.00
Bosch800 Series Single Wall Oven 30'' Black Stainless Steel HBL8443UC

Add To Compare

Bosch 800 Series Single Wall Oven 30'' Black Stainless Steel HBL8443UC

Model Color Regular Price Savings After Savings
HBL8443UC Black Stainless Steel $3149.00 $300.00 $2,849.00
Bosch800 Series Single Wall Oven 30'' Stainless Steel HBL8453UC

Add To Compare

Bosch 800 Series Single Wall Oven 30'' Stainless Steel HBL8453UC

Model Color Regular Price Savings After Savings
HBL8453UC Stainless Steel $2949.00 $300.00 $2,649.00
Bosch800 Series Single Wall Oven 30'' Black HBL8463UC

Add To Compare

Bosch 800 Series Single Wall Oven 30'' Black HBL8463UC

Model Color Regular Price Savings After Savings
HBL8463UC Black $2949.00 $300.00 $2,649.00

Page 3 of 12
<< First Page 1234 Last Page >>

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