Cooking - Cooktops - Electric Induction 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 cSlug = 'electric-induction-cooktops' AND mp.Available = 1 AND ((CommonBrandID = 'SAMSA')) 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
4
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

Samsung Appliances30" Smart Induction Cooktop in Black Stainless Steel

Add To Compare

Samsung Appliances 30" Smart Induction Cooktop in Black Stainless Steel

Model Color Price
NZ30K7880UG Fingerprint Resistant Matte Black Stainless Steel $2,199.00
Samsung Appliances36" Smart Induction Cooktop in Stainless Steel

Add To Compare

Samsung Appliances 36" Smart Induction Cooktop in Stainless Steel

Model Color Price
NZ36K7880US Stainless Steel $2,399.00
Samsung Appliances36" Induction Chef Collection Cooktop

Add To Compare

Samsung Appliances 36" Induction Chef Collection Cooktop

Model Color Price
NZ36M9880UB Contact us for best price

Page 1 of 1
1

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