Cooking - Cooktops

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 = 'cooktops' 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 30
<< First Page 1234 [Next 10 of 30 pages] Last Page >>

Amana30-inch Electric Cooktop with Multiple Settings - Black

Add To Compare

Amana 30-inch Electric Cooktop with Multiple Settings - Black

Model Color Price
AEC6540KFB Black $599.00
Blomberg24in electric cooktop, 4 burner, knob controls

Add To Compare

Blomberg 24in electric cooktop, 4 burner, knob controls

Model Color Price
CTE24402 Black Contact us for best price
Blomberg24in electric cooktop, 4 burner, touch controls

Add To Compare

Blomberg 24in electric cooktop, 4 burner, touch controls

Model Color Price
CTE24410 Black Contact us for best price
Blomberg30" Smooth Top Electric Cooktop

Add To Compare

Blomberg 30" Smooth Top Electric Cooktop

Model Color Price
CTE30400 Black Contact us for best price
Blomberg30in electric cooktop, 4 burner, touch controls

Add To Compare

Blomberg 30in electric cooktop, 4 burner, touch controls

Model Color Price
CTE30410 Black Contact us for best price
Bosch500 Series, 30" KNOB CNT, 4 ELEMENT, ELEC. C-TOP BLACK

Add To Compare

Bosch 500 Series, 30" KNOB CNT, 4 ELEMENT, ELEC. C-TOP BLACK

Model Color Regular Price Savings After Savings
NEM5066UC Black $1099.00 $100.00 $999.00
Bosch500 Series 24" 4 BRNR Knob Control Electric Cktp, Black

Add To Compare

Bosch 500 Series 24" 4 BRNR Knob Control Electric Cktp, Black

Model Color Regular Price Savings After Savings
NEM5466UC Black $949.00 $100.00 $849.00
Bosch500 Series, 36" KNOB CNT, 5 ELEMENT, ELEC. C-TOP BLACK

Add To Compare

Bosch 500 Series, 36" KNOB CNT, 5 ELEMENT, ELEC. C-TOP BLACK

Model Color Regular Price Savings After Savings
NEM5666UC Black $1199.00 $150.00 $1,049.00
Bosch800 Series 30" Electric Cooktop

Add To Compare

Bosch 800 Series 30" Electric Cooktop

Model Color Regular Price Savings After Savings
NET8068SUC Stainless Steel $1299.00 $150.00 $1,149.00
Bosch800 Series 36" Electric Cooktop

Add To Compare

Bosch 800 Series 36" Electric Cooktop

Model Color Regular Price Savings After Savings
NET8668SUC Stainless Steel $1399.00 $150.00 $1,249.00
Bosch500 Series Induction Cooktop 24'' Black NIT5469UC

Add To Compare

Bosch 500 Series Induction Cooktop 24'' Black NIT5469UC

Model Color Regular Price Savings After Savings
NIT5469UC Black $1649.00 $150.00 $1,499.00
Bosch800 Series Induction Cooktop 30'' Black NIT8069SUC

Add To Compare

Bosch 800 Series Induction Cooktop 30'' Black NIT8069SUC

Model Color Regular Price Savings After Savings
NIT8069SUC Black $2299.00 $250.00 $2,049.00
Bosch800 Series Induction Cooktop 30'' Black NIT8069UC

Add To Compare

Bosch 800 Series Induction Cooktop 30'' Black NIT8069UC

Model Color Regular Price Savings After Savings
NIT8069UC Black $2299.00 $250.00 $2,049.00
Bosch800 Series Induction Cooktop 36'' Black NIT8669SUC

Add To Compare

Bosch 800 Series Induction Cooktop 36'' Black NIT8669SUC

Model Color Regular Price Savings After Savings
NIT8669SUC Black $2699.00 $250.00 $2,449.00
Bosch800 Series Induction Cooktop 36'' Black NIT8669UC

Add To Compare

Bosch 800 Series Induction Cooktop 36'' Black NIT8669UC

Model Color Regular Price Savings After Savings
NIT8669UC Black $2699.00 $250.00 $2,449.00

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

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