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

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
KitchenAid36'' 4-Burner with Griddle, Dual Fuel Freestanding Range, Commercial-Style Stainless Steel

Add To Compare

KitchenAid 36'' 4-Burner with Griddle, Dual Fuel Freestanding Range, Commercial-Style Stainless Steel

Model Color Price
KDRS463VSS Stainless Steel Contact us for best price
KDRS463VBU Cobalt Blue Contact us for best price
KitchenAidKitchenAid&reg; 30'' Smart Commercial-Style Dual Fuel Range with 4 Burners - Stainless Steel

Add To Compare

KitchenAid KitchenAid® 30'' Smart Commercial-Style Dual Fuel Range with 4 Burners - Stainless Steel

Model Color Price
KFDC500JSS Stainless Steel $4,999.00
KitchenAidKitchenAid&reg; 36'' Smart Commercial-Style Dual Fuel Range with 6 Burners - Avocado Cream

Add To Compare

KitchenAid KitchenAid® 36'' Smart Commercial-Style Dual Fuel Range with 6 Burners - Avocado Cream

Model Color Price
KFDC506JAV Avocado Cream $7,499.00
KFDC506JIB Ink Blue $7,499.00
KFDC506JMB Misty Blue $7,499.00
KFDC506JMH Milkshake $7,499.00
KFDC506JPA Passion Red $7,499.00
KFDC506JSC Scorched Orange $7,499.00
KFDC506JYP Yellow Pepper $7,499.00
KFDC506JSS Stainless Steel 7499.00*

*See price at checkout

KitchenAidKitchenAid&reg; 48'' Smart Commercial-Style Dual Fuel Range with Griddle - Stainless Steel

Add To Compare

KitchenAid KitchenAid® 48'' Smart Commercial-Style Dual Fuel Range with Griddle - Stainless Steel

Model Color Price
KFDC558JSS Stainless Steel $10,999.00
KFDC558JBK Imperial Black $11,299.00
KFDC558JIB Ink Blue $11,299.00
KFDC558JMB Misty Blue $11,299.00
KFDC558JMH Milkshake $11,299.00
KFDC558JPA Passion Red $11,299.00
KFDC558JSC Scorched Orange $11,299.00
KitchenAid30-Inch 5 Burner Dual Fuel Double Oven Convection Range - Stainless Steel

Add To Compare

KitchenAid 30-Inch 5 Burner Dual Fuel Double Oven Convection Range - Stainless Steel

Model Color Price
KFDD500ESS Stainless Steel $2,699.00
KitchenAid30-Inch 5-Burner Dual Fuel Convection Slide-In Range with Baking Drawer - Stainless Steel

Add To Compare

KitchenAid 30-Inch 5-Burner Dual Fuel Convection Slide-In Range with Baking Drawer - Stainless Steel

Model Color Price
KSDB900ESS Stainless Steel $3,099.00
Samsung Appliances6.3 cu. ft. 36" Chef Collection Professional Dual Fuel Range in Black Stainless Steel

Add To Compare

Samsung Appliances 6.3 cu. ft. 36" Chef Collection Professional Dual Fuel Range in Black Stainless Steel

Model Color Price
NY36R9966PM Matte Black Stainless Steel Contact us for best price
Samsung Appliances5.8 cu. ft. Slide-in Dual Fuel Range with Flex Duo&trade; & Dual Door in Stainless Steel

Add To Compare

Samsung Appliances 5.8 cu. ft. Slide-in Dual Fuel Range with Flex Duo™ & Dual Door in Stainless Steel

Model Color Price
NY58J9850WS Stainless Steel Contact us for best price

Page 3 of 40
<< First Page 1234 [Next 10 of 40 pages] Last Page >>

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