Cooking - Ranges - Electric: Freestanding

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 = 'ranges' AND cSlug = 'electric-freestanding-ranges' 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 1 of 8
1234 Last Page >>

Amana30-inch Electric Range with Self-Clean Option - White

Add To Compare

Amana 30-inch Electric Range with Self-Clean Option - White

Model Color Price
ACR4503SFW White ✅ In Stock $592.00
Maytag30-Inch Wide Electric Range With Shatter-Resistant Cooktop - 5.3 Cu. Ft.

Add To Compare

Maytag 30-Inch Wide Electric Range With Shatter-Resistant Cooktop - 5.3 Cu. Ft.

Model Color Price
MER6600FZ Fingerprint Resistant Stainless Steel $849.00
MER6600FB Black 849.00*

*See price in cart

Maytag30-Inch Wide Electric Range With True Convection And Power Preheat - 6.4 Cu. Ft.

Add To Compare

Maytag 30-Inch Wide Electric Range With True Convection And Power Preheat - 6.4 Cu. Ft.

Model Color Price
MER8800FZ Fingerprint Resistant Stainless Steel $1,099.00
Maytag30-Inch Wide Double Oven Electric Range With True Convection - 6.7 Cu. Ft.

Add To Compare

Maytag 30-Inch Wide Double Oven Electric Range With True Convection - 6.7 Cu. Ft.

Model Color Price
MET8800FZ Fingerprint Resistant Stainless Steel $1,899.00
Beko24" Stainless Steel Slide-In Electric Range

Add To Compare

Beko 24" Stainless Steel Slide-In Electric Range

Model Color Price
SLER24410SS Stainless Steel $1,099.00
Whirlpool4.8 Cu. Ft. Freestanding Counter Depth Electric Range

Add To Compare

Whirlpool 4.8 Cu. Ft. Freestanding Counter Depth Electric Range

Model Color Price
WFC150M0EB Black Contact us for best price
Whirlpool4.8 cu. ft. Whirlpool&reg; electric range with Keep Warm setting

Add To Compare

Whirlpool 4.8 cu. ft. Whirlpool® electric range with Keep Warm setting

Model Color Price
WFC150M0JW White ✅ In Stock $569.00
WFC150M0JS Heritage Stainless Steel $599.00
Whirlpool4.8 Cu. Ft. Freestanding Electric Range with AccuBake&reg; System

Add To Compare

Whirlpool 4.8 Cu. Ft. Freestanding Electric Range with AccuBake® System

Model Color Price
WFC310S0EW White Contact us for best price
Whirlpool4.8 cu. ft. Whirlpool&reg; electric range with Keep Warm setting

Add To Compare

Whirlpool 4.8 cu. ft. Whirlpool® electric range with Keep Warm setting

Model Color Price
WFC315S0JS Heritage Stainless Steel ✅ In Stock $699.00
WFC315S0JW Heritage White 699.00*

*See price in cart

Whirlpool4.8 Cu. Ft. Freestanding Electric Range with FlexHeat Dual Radiant Element White

Add To Compare

Whirlpool 4.8 Cu. Ft. Freestanding Electric Range with FlexHeat Dual Radiant Element White

Model Color Price
WFE320M0EW White Contact us for best price
WFE320M0ES Black-on-stainless $699.00
Whirlpool5.3 cu. ft. electric range with Keep Warm Setting.

Add To Compare

Whirlpool 5.3 cu. ft. electric range with Keep Warm Setting.

Model Color Price
WFE320M0JB Heritage Black $649.00
WFE320M0JW White 649.00*

*See price in cart

Whirlpool24-inch Freestanding Electric Range with Upswept SpillGuard Cooktop

Add To Compare

Whirlpool 24-inch Freestanding Electric Range with Upswept SpillGuard Cooktop

Model Color Price
WFE500M4HS Heritage Stainless Steel $1,199.00
Whirlpool5.3 cu. ft. Freestanding Electric Range with 5 Elements

Add To Compare

Whirlpool 5.3 cu. ft. Freestanding Electric Range with 5 Elements

Model Color Regular Price Savings After Savings
WFE505W0HW White 699.00*

*See price in cart

WFE505W0HZ Fingerprint Resistant Stainless Steel Contact us for best price
Whirlpool5.3 cu. ft. Whirlpool&reg; electric range with Frozen Bake technology.

Add To Compare

Whirlpool 5.3 cu. ft. Whirlpool® electric range with Frozen Bake technology.

Model Color Regular Price Savings After Savings
WFE505W0JZ Fingerprint Resistant Stainless Steel 799.00*

*See price in cart

WFE505W0JV Black Stainless $849.00

Page 1 of 8
1234 Last Page >>

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