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 11 of 40
<< First Page [Previous 10 pages] 9101112 [Next 10 of 40 pages] Last Page >>

GE&reg;30" Free-Standing Electric Range

Add To Compare

GE ®30" Free-Standing Electric Range

Model Color Price
JBS460DMWW White $699.00
GE&reg;30" Free-Standing Electric Range

Add To Compare

GE ®30" Free-Standing Electric Range

Model Color Price
JBS60DKWW White $609.00
JBS60RKSS Stainless Steel/black $709.00
GE&reg;30" Free-Standing Electric Double Oven Convection Range

Add To Compare

GE ®30" Free-Standing Electric Double Oven Convection Range

Model Color Regular Price Savings After Savings
JBS86SPSS Stainless Steel/gray $1309.00 $131.00 $1,178.00
GE ProfileGE Profile&trade; 30" Smart Free-Standing Electric Convection Range with No Preheat Air Fry

Add To Compare

GE Profile GE Profile™ 30" Smart Free-Standing Electric Convection Range with No Preheat Air Fry

Model Color Price
PB935BPTS Fingerprint Resistant Black Stainless $1,209.00
GE ProfileGE Profile&trade; 30" Smart Free-Standing Electric Double Oven Convection Range with No Preheat Air Fry

Add To Compare

GE Profile GE Profile™ 30" Smart Free-Standing Electric Double Oven Convection Range with No Preheat Air Fry

Model Color Price
PB965BPTS Fingerprint Resistant Black Stainless $1,809.00
GE ProfileGE Profile&trade; 30" Smart Slide-In Electric Double Oven Convection Fingerprint Resistant Range

Add To Compare

GE Profile GE Profile™ 30" Smart Slide-In Electric Double Oven Convection Fingerprint Resistant Range

Model Color Price
PS960YPFS Fingerprint Resistant Stainless $2,959.00
Haier Appliance24" 2.9 Cu. Ft. Electric Range

Add To Compare

Haier Appliance 24" 2.9 Cu. Ft. Electric Range

Model Color Price
QAS740RMSS $1,299.00
HotpointHotpoint&reg; 20" Electric Free-Standing Front-Control Electric Range

Add To Compare

Hotpoint Hotpoint® 20" Electric Free-Standing Front-Control Electric Range

Model Color Price
RAS200DMWW White $589.00
HotpointHotpoint&reg; 24" Electric Free-Standing Front-Control Range

Add To Compare

Hotpoint Hotpoint® 24" Electric Free-Standing Front-Control Range

Model Color Price
RAS240DMWW White $589.00
HotpointHotpoint&reg; 24" Free-Standing Front-Control Electric Range

Add To Compare

Hotpoint Hotpoint® 24" Free-Standing Front-Control Electric Range

Model Color Price
RAS300DMWW White $619.00
HotpointHotpoint&reg; 30" Free-Standing Electric Range

Add To Compare

Hotpoint Hotpoint® 30" Free-Standing Electric Range

Model Color Price
RBS160DMBB Black $489.00
HotpointHotpoint&reg; 30" Free-Standing Standard Clean Electric Range

Add To Compare

Hotpoint Hotpoint® 30" Free-Standing Standard Clean Electric Range

Model Color Price
RBS360DMBB Black $519.00
KitchenAid30-Inch 5 Burner Electric Double Oven Convection Range - White

Add To Compare

KitchenAid 30-Inch 5 Burner Electric Double Oven Convection Range - White

Model Color Price
KFED500EWH White $2,099.00
KFED500EBS Black Stainless Steel With Printshield(tm) Finish $2,199.00
KitchenAid30-Inch 5-Element Electric Convection Range - White

Add To Compare

KitchenAid 30-Inch 5-Element Electric Convection Range - White

Model Color Price
KFEG500EWH White $1,299.00
KFEG500EBS Black Stainless Steel With Printshield(tm) Finish $1,399.00
Samsung Appliances5.9 cu. ft. Electric Range with Fan Convection

Add To Compare

Samsung Appliances 5.9 cu. ft. Electric Range with Fan Convection

Model Color Price
NE59J3420SB Black Contact us for best price
NE59J3420SS Stainless Steel Contact us for best price

Page 11 of 40
<< First Page [Previous 10 pages] 9101112 [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.