Refine Your Results

SELECT p.CatDescription, p.cSlug, COUNT(DISTINCT(p.SKU)) AS prodCount 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 Categories AS c ON (p.pkCategory = c.pkID) WHERE p.mhSlug = 'cooking' AND cgSlug = 'ranges' AND mp.Available = 1 GROUP BY p.cSlug ORDER BY c.seq, p.cSlug

≡

Sort results:

by Type

Electric Induction Range (16)
Electric: Freestanding (107)
Electric: Slide-in (38)
Electric: Drop-in (40)
Professional Gas Range (377)
Gas: Freestanding (87)
Gas: Slide-in (37)
Dual Fuel Ranges (196)
Dual Fuel: Downdraft (3)

by Brand

Aga (84)
Amana (23)
Bertazzoni (82)
Bosch (4)
Cafe Appliances (21)
Dacor (104)
Ge (21)
Ge Cafe (6)
Ge Profile (41)
Jennair (40)
Kitchenaid (38)
Lg Appliances (49)
Maytag (16)
Monogram (8)
Samsung (54)
Viking (310)

by Color

Bisque (7)
Black (117)
Black On Stainless Steel Look (1)
Black Stainless Steel (51)
Blue (64)
Gray (44)
Green (7)
Other (25)
Pewter (7)
Red (105)
Slate (25)
Stainless Steel (206)
White (109)

by Price

Call for price (143)
$300 - $599 (18)
$600 - $899 (38)
$900 - $1199 (32)
$1200 - $1499 (37)
$1500 - $1799 (27)
$1800 - $2099 (23)
$2100 - $2399 (25)
$2400 - $2699 (11)
$2700 - $2999 (15)
Over $3000 (532)

Self Clean

Yes (287)
No (297)

Sabbath Mode

Yes (38)
No (87)

Continuous Grate

Yes (233)
No (205)

Warming Drawer

Yes (38)
No (506)

Down Draft

Yes (6)
No (585)

Burner Type

Sealed (351)
Open (62)

Proof Mode

Yes (113)
No (471)

Induction

Yes (30)
No (139)

Ignition Type

Electronic (226)

Dual Fuel

Yes (199)
No (247)

Storage Drawer

Yes (175)
No (369)

Convection Oven

Yes (503)
No (76)

Number Of Elements

1 (20)
2 (20)
4 (29)
5 (78)

Number Of Burners

4 (158)
5 (114)
6 (146)
8 (4)

Depth

12 - 12.9 Inches(11)
14 - 14.9 Inches(9)
19 - 19.9 Inches(6)
21 - 21.9 Inches(6)
22 - 22.9 Inches(1)
24 - 24.9 Inches(22)
25 - 25.9 Inches(105)
26 - 26.9 Inches(147)
27 - 27.9 Inches(73)
28 - 28.9 Inches(133)
29 - 29.9 Inches(148)
30 - 30.9 Inches(63)
31 - 31.9 Inches(6)
37 - 37.9 Inches(6)

+ more

Width

19 Inches(19)
20 Inches(2)
24 Inches(32)
25 Inches(11)
28 Inches(1)
29 Inches(9)
30 Inches(316)
31 Inches(4)
32 Inches(6)
33 Inches(1)
36 Inches(130)
39 Inches(20)
48 Inches(133)
60 Inches(28)
66 Inches(12)
78 Inches(20)

+ more

Height

14 - 14.9 Inches(9)
19 - 19.9 Inches(6)
21 - 21.9 Inches(2)
22 - 22.9 Inches(1)
25 - 25.9 Inches(6)
27 - 27.9 Inches(2)
34 - 34.9 Inches(2)
35 - 35.9 Inches(8)
36 - 36.9 Inches(303)
37 - 37.9 Inches(231)
38 - 38.9 Inches(23)
40 - 40.9 Inches(1)
42 - 42.9 Inches(2)
44 - 44.9 Inches(2)
46 - 46.9 Inches(11)
47 - 47.9 Inches(108)
48 - 48.9 Inches(12)
51 - 51.9 Inches(3)
8 - 8.9 Inches(8)

+ more

Home /
Cooking /
Ranges

Cooking - Ranges

Compare Products:

Items per page:
15
30
60
90

Page 7 of 26
<< First Page 1 2 3 4 5 678 9 10 11 12 13 14 15 [Next 10 of 26 pages] Last Page >>

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, 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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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) WHERE p.mhSlug = 'cooking' AND cgSlug = 'ranges' AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Add To Compare

Cafe Appliances Caf(eback) 30" Slide-In Front Control Dual-Fuel Convection Range with Warming Drawer

Request More Info Check for Special Offers

C2S900P3MD1	Matte Black

Reg: $3400.00	On Sale : $3,399.00
More Detail »

Regular Price: $3400.00

Savings: $1.00

Sale Price: $3,399.00

C2S950P3MD1	Matte Black

Reg: $3700.00	On Sale : $3,699.00
More Detail »
C2S950P4MW2	Matte White

Reg: $3800.00	On Sale : $3,799.00
More Detail »

C2Y366P2MS1	Stainless Steel

Reg: $7100.00	On Sale : $7,099.00
More Detail »
C2Y366P3MD1	Matte Black

Reg: $7200.00	On Sale : $7,199.00
More Detail »
C2Y366P4MW2	Matte White

Reg: $7300.00	On Sale : $7,299.00
More Detail »

C2Y486P2MS1	Stainless Steel

Reg: $9700.00	On Sale : $9,699.00
More Detail »

CES700P3MD1	Matte Black

Reg: $2400.00	On Sale : $2,399.00
More Detail »

CES750P3MD1	Matte Black

Reg: $3000.00	On Sale : $2,999.00
More Detail »
CES750P4MW2	Matte White

Reg: $3100.00	On Sale : $3,099.00
More Detail »

CGB500P3MD1	Matte Black

Reg: $1700.00	On Sale : $1,699.00
More Detail »

CGB550P3MD1	Matte Black

Reg: $2200.00	On Sale : $2,199.00
More Detail »

CGS700P3MD1	Matte Black

Reg: $3200.00	On Sale : $3,199.00
More Detail »

CGS750P3MD1	Matte Black

Reg: $3500.00	On Sale : $3,499.00
More Detail »
CGS750P4MW2	Matte White

Reg: $3600.00	On Sale : $3,599.00
More Detail »

CGY366P2MS1	Stainless Steel

Reg: $5800.00	On Sale : $5,799.00
More Detail »
CGY366P3MD1	Matte Black

Reg: $5900.00	On Sale : $5,899.00
More Detail »
CGY366P4MW2	Matte White

Reg: $6000.00	On Sale : $5,999.00
More Detail »

Product		Qty	Price
		Total: $0.00
		View Cart →

$_SESSION (array)
orderTaxable	0
i8_ShoppingCart	1
i8_State	Georgia
i8_GatewayURL	https://secure.authorize.net/gateway/transact.dll
i8_TaxRate	0
i8_FlatRate	0.00
i8_FreeShipping	0
i8_UniqueKey	9671896585504055
WADbSearch1_categorygroupfilters	[empty string]
WADbSearch2_categorygroupfilters	[empty string]
WADbSearch3_categorygroupfilters	[empty string]
WADbSearch4_categorygroupfilters	[empty string]
WADbSearch5_categorygroupfilters	[empty string]

CHS900P3MD1	Matte Black

Reg: $3900.00	On Sale : $3,899.00
More Detail »

CHS950P3MD1	Matte Black

Reg: $4200.00	On Sale : $4,199.00
More Detail »
CHS950P4MW2	Matte White

Reg: $4300.00	On Sale : $4,299.00
More Detail »

DOP36M94DAM

Reg: $11499.00	On Sale : $9,999.00
More Detail »

DOP36M94DAS

Reg: $10919.00	On Sale : $9,499.00
More Detail »

Packages

Cooking

Refrigeration

Laundry

Dishwashers

Food Disposal

Grills

Vacuums

Dining Room

Refine Your Results

Cooking - Ranges

Tell us a little about yourself so we know where to send your special offer.