Cooking - Ranges - Gas: 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 = 'gas-freestanding-ranges' AND mp.Available = 1 AND ((CommonBrandID = 'WHIR')) 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 2
12 Last Page >>

Whirlpool5.1 cu. ft. Freestanding Gas Range with Under-Oven Broiler

Add To Compare

Whirlpool 5.1 cu. ft. Freestanding Gas Range with Under-Oven Broiler

Model Color Regular Price Savings After Savings
WFG320M0BW White 649.00*

*See price in cart

WFG320M0BS Black-on-stainless $699.00
Whirlpool24-inch Freestanding Gas Range with Sealed Burners

Add To Compare

Whirlpool 24-inch Freestanding Gas Range with Sealed Burners

Model Color Price
WFG500M4HS Heritage Stainless Steel $1,299.00
Whirlpool5.1 cu. ft. Freestanding Gas Range with Five Burners

Add To Compare

Whirlpool 5.1 cu. ft. Freestanding Gas Range with Five Burners

Model Color Regular Price Savings After Savings
WFG505M0BW White 699.00*

*See price in cart

WFG505M0BS Black-on-stainless $749.00 $50.00 699.00*

*See price in cart

Whirlpool5.0 cu. ft. Capacity Gas Range with AccuBake&reg; Temperature Management System

Add To Compare

Whirlpool 5.0 cu. ft. Capacity Gas Range with AccuBake® Temperature Management System

Model Color Price
WFG510S0AS Stainless Steel Contact us for best price
Whirlpool5.0 cu. ft. Freestanding Gas Range with Adjustable Self-Cleaning

Add To Compare

Whirlpool 5.0 cu. ft. Freestanding Gas Range with Adjustable Self-Cleaning

Model Color Price
WFG510S0HW White Contact us for best price
WFG510S0HS Stainless Steel Contact us for best price
Whirlpool5.0 cu. ft. Whirlpool&reg; gas range with SpeedHeat burner

Add To Compare

Whirlpool 5.0 cu. ft. Whirlpool® gas range with SpeedHeat burner

Model Color Price
WFG515S0JB Heritage Black $799.00
WFG515S0JW White $799.00
Whirlpool5.0 cu. ft. Front Control Gas Range with Fan Convection Cooking

Add To Compare

Whirlpool 5.0 cu. ft. Front Control Gas Range with Fan Convection Cooking

Model Color Price
WFG520S0FS Black-on-stainless Contact us for best price
Whirlpool5.0 cu. ft. Freestanding Gas Range with Center Oval Burner

Add To Compare

Whirlpool 5.0 cu. ft. Freestanding Gas Range with Center Oval Burner

Model Color Price
WFG525S0HW White Contact us for best price
WFG525S0HV Black Stainless Contact us for best price
WFG525S0HZ Fingerprint Resistant Stainless Steel Contact us for best price
WFG525S0HB Black Contact us for best price
WFG525S0HS Black-on-stainless Contact us for best price
Whirlpool5.0 cu. ft. Whirlpool&reg; gas range with center oval burner

Add To Compare

Whirlpool 5.0 cu. ft. Whirlpool® gas range with center oval burner

Model Color Price
WFG525S0JS Heritage Stainless Steel ✅ In Stock $899.00
WFG525S0JB Heritage Black 899.00*

*See price in cart

WFG525S0JV Black Stainless $999.00
WFG525S0JW Heritage White 899.00*

*See price in cart

WFG525S0JT Biscuit 899.00*

*See price in cart

Whirlpool5.0 cu. ft. gas convection oven with fan convection cooking

Add To Compare

Whirlpool 5.0 cu. ft. gas convection oven with fan convection cooking

Model Color Price
WFG535S0JS Heritage Stainless Steel $999.00
Whirlpool5.0 cu. ft. Whirlpool&reg; gas convection oven with Frozen Bake technology

Add To Compare

Whirlpool 5.0 cu. ft. Whirlpool® gas convection oven with Frozen Bake technology

Model Color Price
WFG550S0HW White $1,049.00
WFG550S0HV Fingerprint Resistant Black Stainless $1,199.00
WFG550S0HZ Fingerprint Resistant Stainless Steel $1099.00 $50.00 1049.00*

*See price in cart

WhirlpoolGold&reg; 5.8 cu. ft. Capacity Gas Range with Rapid Preheat option

Add To Compare

Whirlpool Gold® 5.8 cu. ft. Capacity Gas Range with Rapid Preheat option

Model Color Price
WFG710H0AE Black Ice Contact us for best price
Whirlpool5.8 Cu. Ft. Freestanding Gas Range with EZ-2-Lift Hinged Grates

Add To Compare

Whirlpool 5.8 Cu. Ft. Freestanding Gas Range with EZ-2-Lift Hinged Grates

Model Color Price
WFG745H0FE Black Ice Contact us for best price
Whirlpool5.8 cu. ft. Freestanding Gas Range with Frozen Bake Technology

Add To Compare

Whirlpool 5.8 cu. ft. Freestanding Gas Range with Frozen Bake Technology

Model Color Price
WFG775H0HW White $1,199.00
WFG775H0HV Fingerprint Resistant Black Stainless $1,349.00
WFG775H0HZ Fingerprint Resistant Stainless Steel $1,249.00
Whirlpool5.8 cu. ft. Smart Freestanding Gas Range with EZ-2-Lift Grates

Add To Compare

Whirlpool 5.8 cu. ft. Smart Freestanding Gas Range with EZ-2-Lift Grates

Model Color Price
WFG975H0HV Fingerprint Resistant Black Stainless $1,499.00

Page 1 of 2
12 Last Page >>

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