Cooking - Ranges - Gas: Slide-In

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 cSlug = 'gas-slide-in-ranges' 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
12
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

Samsung Appliances5.8 cu. ft. Slide-In Gas Range with True Convection in Stainless Steel

Add To Compare

Samsung Appliances 5.8 cu. ft. Slide-In Gas Range with True Convection in Stainless Steel

Model Color Price
NX58H9500WS Stainless Steel Contact us for best price
Samsung Appliances5.8 cu. ft. Chef Collection Slide-in Gas Range with True Convection in Stainless Steel

Add To Compare

Samsung Appliances 5.8 cu. ft. Chef Collection Slide-in Gas Range with True Convection in Stainless Steel

Model Color Price
NX58H9950WS Stainless Steel Contact us for best price
Samsung Appliances5.8 cu. ft. Slide-In Gas Range with Flex Duo&trade; & Dual Door in Black Stainless Steel

Add To Compare

Samsung Appliances 5.8 cu. ft. Slide-In Gas Range with Flex Duo™ & Dual Door in Black Stainless Steel

Model Color Price
NX58K9850SG Fingerprint Resistant Black Stainless Steel Contact us for best price
Samsung Appliances5.8 cu. ft. Slide-in Gas Range with Convection in Stainless Steel

Add To Compare

Samsung Appliances 5.8 cu. ft. Slide-in Gas Range with Convection in Stainless Steel

Model Color Price
NX58M9420SS Stainless Steel Contact us for best price
Samsung Appliances5.8 cu. ft. 5 Burner Slide-in Gas Range in Stainless Steel

Add To Compare

Samsung Appliances 5.8 cu. ft. 5 Burner Slide-in Gas Range in Stainless Steel

Model Color Price
NX58R9311SS Stainless Steel Contact us for best price
Samsung Appliances5.8 cu. ft. Slide-in Gas Range with Convection in Tuscan Stainless Steel

Add To Compare

Samsung Appliances 5.8 cu. ft. Slide-in Gas Range with Convection in Tuscan Stainless Steel

Model Color Price
NX58R9421ST Fingerprint Resistant Tuscan Stainless Steel Contact us for best price
NX58R9421SS Stainless Steel Contact us for best price
Samsung Appliances6.0 cu ft. Smart Slide-in Gas Range in Black Stainless Steel

Add To Compare

Samsung Appliances 6.0 cu ft. Smart Slide-in Gas Range in Black Stainless Steel

Model Color Price
NX60T8111SG Fingerprint Resistant Black Stainless Steel $1,199.00
Samsung Appliances6.0 cu. ft. Smart Slide-in Gas Range with Convection in Black Stainless Steel

Add To Compare

Samsung Appliances 6.0 cu. ft. Smart Slide-in Gas Range with Convection in Black Stainless Steel

Model Color Price
NX60T8311SG Fingerprint Resistant Black Stainless Steel $1,443.00
Samsung Appliances6.0 cu ft. Smart Slide-in Gas Range with Air Fry in Black Stainless Steel

Add To Compare

Samsung Appliances 6.0 cu ft. Smart Slide-in Gas Range with Air Fry in Black Stainless Steel

Model Color Price
NX60T8511SG Fingerprint Resistant Black Stainless Steel $1,888.00
NX60T8511ST Fingerprint Resistant Tuscan Stainless Steel $1,888.00
Samsung Appliances6.0 cu ft. Smart Slide-in Gas Range with Smart Dial & Air Fry in Black Stainless Steel

Add To Compare

Samsung Appliances 6.0 cu ft. Smart Slide-in Gas Range with Smart Dial & Air Fry in Black Stainless Steel

Model Color Price
NX60T8711SG Fingerprint Resistant Black Stainless Steel $2,221.00
NX60T8711ST Fingerprint Resistant Tuscan Stainless Steel $2,221.00
Samsung Appliances6.0 cu ft. Smart Slide-in Gas Range with Flex Duo&trade;, Smart Dial & Air Fry in Black Stainless Steel

Add To Compare

Samsung Appliances 6.0 cu ft. Smart Slide-in Gas Range with Flex Duo™, Smart Dial & Air Fry in Black Stainless Steel

Model Color Price
NX60T8751SG Fingerprint Resistant Black Stainless Steel $3,099.00
Samsung Appliances6.3 cu ft. Smart Slide-in Gas Range with Flex Duo&trade;, Smart Dial & Air Fry in Black Stainless Steel

Add To Compare

Samsung Appliances 6.3 cu ft. Smart Slide-in Gas Range with Flex Duo™, Smart Dial & Air Fry in Black Stainless Steel

Model Color Price
NY63T8751SG Fingerprint Resistant Black Stainless Steel $3,699.00

Page 1 of 1
1

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