Cooking - Ranges - Dual Fuel Ranges

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 = 'dual-fuel-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
30
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 3
123 Last Page >>

Beko30" Carbon Fiber Pro-Style Dual Fuel Range

Add To Compare

Beko 30" Carbon Fiber Pro-Style Dual Fuel Range

Model Color Price
PRDF34550CF Carbon Fiber $3,599.00
Beko30" Stainless Steel Pro-Style Dual Fuel Range

Add To Compare

Beko 30" Stainless Steel Pro-Style Dual Fuel Range

Model Color Price
PRDF34550SS Stainless Steel $3,299.00
Cafe30" Smart Slide-In, Front-Control, Dual-Fuel Range in Platinum Glass

Add To Compare

Cafe 30" Smart Slide-In, Front-Control, Dual-Fuel Range in Platinum Glass

Model Color Price
C2S900M2NS5 Platinum Glass Contact us for best price
Cafe30" Smart Slide-In, Front-Control, Dual-Fuel Range with Warming Drawer

Add To Compare

Cafe 30" Smart Slide-In, Front-Control, Dual-Fuel Range with Warming Drawer

Model Color Price
C2S900P3MD1 Matte Black $3,399.00
C2S900P4MW2 Matte White Contact us for best price
Cafe30" Smart Slide-In, Front-Control, Dual-Fuel, Double-Oven Range with Convection in Platinum Glass

Add To Compare

Cafe 30" Smart Slide-In, Front-Control, Dual-Fuel, Double-Oven Range with Convection in Platinum Glass

Model Color Price
C2S950M2NS5 Platinum Glass $3,899.00
Cafe30" Smart Slide-In, Front-Control, Dual-Fuel, Double-Oven Range with Convection

Add To Compare

Cafe 30" Smart Slide-In, Front-Control, Dual-Fuel, Double-Oven Range with Convection

Model Color Price
C2S950P3MD1 Matte Black $3,799.00
C2S950P2MS1 Stainless Steel $3,599.00
Cafe36" Dual-Fuel Commercial-Style Range with 6 Burners (Natural Gas)

Add To Compare

Cafe 36" Dual-Fuel Commercial-Style Range with 6 Burners (Natural Gas)

Model Color Price
C2Y366P2MS1 Stainless Steel Contact us for best price
Cafe36" Dual-Fuel Professional Range with 6 Burners (Natural Gas)

Add To Compare

Cafe 36" Dual-Fuel Professional Range with 6 Burners (Natural Gas)

Model Color Price
C2Y366P3MD1 Matte Black Contact us for best price
LG Appliances6.3 cu. ft. Smart wi-fi Enabled Dual Fuel Slide-in Range with ProBake Convection&reg; and EasyClean&reg;

Add To Compare

LG Appliances 6.3 cu. ft. Smart wi-fi Enabled Dual Fuel Slide-in Range with ProBake Convection® and EasyClean®

Model Color Regular Price Savings After Savings
LSD4913ST $2639.00 $540.00 $2,099.00
LG AppliancesLG SIGNATURE 7.3 cu.ft. Smart wi-fi Enabled Dual Fuel Double Oven Range with ProBake Convection&reg;

Add To Compare

LG Appliances LG SIGNATURE 7.3 cu.ft. Smart wi-fi Enabled Dual Fuel Double Oven Range with ProBake Convection®

Model Color Regular Price Savings After Savings
LUTD4919SN Textured Steel $3959.00 $720.00 $3,239.00
Blomberg30" Pro-Style Dual Fuel Range

Add To Compare

Blomberg 30" Pro-Style Dual Fuel Range

Model Color Price
BDFP34550SS Stainless Steel Contact us for best price
Bosch800 Series Dual Fuel Slide-in Range 30'' Stainless Steel HDI8056U

Add To Compare

Bosch 800 Series Dual Fuel Slide-in Range 30'' Stainless Steel HDI8056U

Model Color Regular Price Savings After Savings
HDI8056U Stainless Steel $2999.00 $300.00 $2,699.00
Fisher & PaykelDual Fuel Range 30", Self-Cleaning

Add To Compare

Fisher & Paykel Dual Fuel Range 30", Self-Cleaning

Model Color Regular Price Savings After Savings
OR30SDG6X1 Stainless Steel $5039.00 $240.00 $4,799.00
Fisher & PaykelDual Fuel Range, 30", 4 Burners, Self-cleaning, LPG

Add To Compare

Fisher & Paykel Dual Fuel Range, 30", 4 Burners, Self-cleaning, LPG

Model Color Regular Price Savings After Savings
RDV3304L Stainless Steel $6509.00 $310.00 $6,199.00
Fisher & PaykelDual Fuel Range, 30", 4 Burners, Self-cleaning

Add To Compare

Fisher & Paykel Dual Fuel Range, 30", 4 Burners, Self-cleaning

Model Color Regular Price Savings After Savings
RDV3304N Stainless Steel $6509.00 $310.00 $6,199.00
Fisher & PaykelDual Fuel Range, 36", 6 Burners, Self-cleaning, LPG

Add To Compare

Fisher & Paykel Dual Fuel Range, 36", 6 Burners, Self-cleaning, LPG

Model Color Regular Price Savings After Savings
RDV3366L Stainless Steel $9239.00 $440.00 $8,799.00
Fisher & PaykelDual Fuel Range, 36", 6 Burners, Self-cleaning

Add To Compare

Fisher & Paykel Dual Fuel Range, 36", 6 Burners, Self-cleaning

Model Color Regular Price Savings After Savings
RDV3366N Stainless Steel $9239.00 $440.00 $8,799.00
Fisher & PaykelDual Fuel Range, 48", 5 Burners with Griddle, Self-cleaning, LPG

Add To Compare

Fisher & Paykel Dual Fuel Range, 48", 5 Burners with Griddle, Self-cleaning, LPG

Model Color Regular Price Savings After Savings
RDV3485GDL Stainless Steel $13649.00 $650.00 $12,999.00
Fisher & PaykelDual Fuel Range, 48", 5 Burners with Griddle, Self-cleaning

Add To Compare

Fisher & Paykel Dual Fuel Range, 48", 5 Burners with Griddle, Self-cleaning

Model Color Regular Price Savings After Savings
RDV3485GDN Stainless Steel $13649.00 $650.00 $12,999.00
Fisher & PaykelDual Fuel Range, 48", 8 Burners, Self-cleaning, LPG

Add To Compare

Fisher & Paykel Dual Fuel Range, 48", 8 Burners, Self-cleaning, LPG

Model Color Regular Price Savings After Savings
RDV3488L Stainless Steel $12599.00 $600.00 $11,999.00
Fisher & PaykelDual Fuel Range, 48", 8 Burners, Self-cleaning

Add To Compare

Fisher & Paykel Dual Fuel Range, 48", 8 Burners, Self-cleaning

Model Color Regular Price Savings After Savings
RDV3488N Stainless Steel $12599.00 $600.00 $11,999.00
GE ProfileGE PROFILEGE Profile&trade; 30" Smart Dual-Fuel Free-Standing Convection Range with Warming Drawer

Add To Compare

GE Profile GE PROFILE GE Profile™ 30" Smart Dual-Fuel Free-Standing Convection Range with Warming Drawer

Model Color Price
P2B940SEJSS Stainless Steel $2,299.00
JennAirPro-Style&reg; 30" Dual -Fuel Range Pro Style Stainless

Add To Compare

JennAir Pro-Style® 30" Dual -Fuel Range Pro Style Stainless

Model Color Price
JDS1450FP Pro Style Stainless Contact us for best price
KitchenAid30'' 4-Burner Dual Fuel Freestanding Range, Commercial-Style Stainless Steel

Add To Compare

KitchenAid 30'' 4-Burner Dual Fuel Freestanding Range, Commercial-Style Stainless Steel

Model Color Price
KDRS407VSS Stainless Steel Contact us for best price
KDRS407VMW Imperial White Contact us for best price
KDRS407VSD Signature Red Contact us for best price

Page 1 of 3
123 Last Page >>

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