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)

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)

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)

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 14 of 26
<< First Page [Previous 10 pages] 7 8 9 10 11 12 131415 16 17 18 19 20 21 [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

Dacor 48" Heritage Gas Pro Range, Silver Stainless Steel, Liquid Propane/High Altitude

Three-Part Pure Convection, Infrared Ceramic Broiler, SimmerSear Burners, Interchangable Griddle Accessory, Black and Brass Burner Caps

Request More Info Check for Special Offers

HGPR48SLPH

Reg: $10469.00	On Sale : $9,099.00
More Detail »

Regular Price: $10469.00

Savings: $1,370.00

Sale Price: $9,099.00

HGPR48SNG

Reg: $10469.00	On Sale : $9,099.00
More Detail »

HGPR48SNGH

Reg: $10469.00	On Sale : $9,099.00
More Detail »

HRTP366SLP

Reg: $3849.00	On Sale : $3,349.00
More Detail »

HRTP366SLPH

Reg: $3849.00	On Sale : $3,349.00
More Detail »

HRTP366SNG

Reg: $3849.00	On Sale : $3,349.00
More Detail »

HRTP366SNGH

Reg: $3849.00	On Sale : $3,349.00
More Detail »

HRTP486SLP

Reg: $4719.00	On Sale : $4,099.00
More Detail »

HRTP486SLPH

Reg: $4719.00	On Sale : $4,099.00
More Detail »

HRTP486SNG

Reg: $4719.00	On Sale : $4,099.00
More Detail »

HRTP486SNGH

Reg: $4719.00	On Sale : $4,099.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	6068967127307171
WADbSearch1_categorygroupfilters	[empty string]
WADbSearch2_categorygroupfilters	[empty string]
WADbSearch3_categorygroupfilters	[empty string]
WADbSearch4_categorygroupfilters	[empty string]
WADbSearch5_categorygroupfilters	[empty string]

JGS760BELTS	Black Stainless

Reg: $2100.00	On Sale : $1,599.30
More Detail »
JGS760DELBB	Black

Reg: $2000.00	On Sale : $1,999.00
More Detail »
JGS760DELWW	White

Reg: $2000.00	On Sale : $1,999.00
More Detail »
JGS760EELES	Slate

Reg: $2100.00	On Sale : $1,599.30
More Detail »
JGS760FELDS	Black Slate

Reg: $2100.00	On Sale : $1,599.30
More Detail »
JGS760SELSS	Stainless Steel

Reg: $2000.00	On Sale : $1,498.50
More Detail »

JGSS66EELES	Slate

Reg: $1600.00	On Sale : $1,298.70
More Detail »
JGSS66FELDS	Black Slate

Reg: $1600.00	On Sale : $1,298.70
More Detail »
JGSS66SELSS	Stainless Steel

Reg: $1500.00	On Sale : $1,198.80
More Detail »

JS645DLWW	White

Reg: $1510.00	On Sale : $1,509.00
More Detail »
JS645ELES	Slate

Reg: $1610.00	On Sale : $1,059.30
More Detail »
JS645FLDS	Black Slate

Reg: $1610.00	On Sale : $1,059.30
More Detail »
JS645SLSS	Stainless Steel

Reg: $1510.00	On Sale : $959.40
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.