Laundry - Dryers - Gas: Match Top Load

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 = 'laundry' AND cgSlug = 'dryers' AND cSlug = 'gas-match-top-load-dryers' 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
7
Compare Products:
  • Product List View
  • Product Grid View

Page 2 of 2
<< First Page 12

Samsung Appliances7.4 cu. ft. Gas Dryer with Sensor Dry in Champagne

Add To Compare

Samsung Appliances 7.4 cu. ft. Gas Dryer with Sensor Dry in Champagne

Model Color Price
DVG50T5300C Champagne $1,049.00
 energy star appliance Samsung Appliances7.4 cu. ft. Gas Dryer in Black Stainless Steel

Add To Compare

Samsung Appliances 7.4 cu. ft. Gas Dryer in Black Stainless Steel

Model Color Price
DVG52M7750V Fingerprint Resistant Black Stainless Steel Contact us for best price
 energy star appliance Samsung Appliances7.4 cu. ft. Gas Dryer with Integrated Controls in Black Stainless Steel

Add To Compare

Samsung Appliances 7.4 cu. ft. Gas Dryer with Integrated Controls in Black Stainless Steel

Model Color Price
DVG52M8650V Fingerprint Resistant Black Stainless Steel Contact us for best price
 energy star appliance Samsung Appliances7.4 cu. ft. Smart Gas Dryer with Integrated Touch Controls in Black Stainless Steel

Add To Compare

Samsung Appliances 7.4 cu. ft. Smart Gas Dryer with Integrated Touch Controls in Black Stainless Steel

Model Color Price
DVG54M8750V Fingerprint Resistant Black Stainless Steel Contact us for best price
 energy star appliance Samsung Appliances7.4 cu. ft. Gas Dryer with Integrated Touch Controls in White

Add To Compare

Samsung Appliances 7.4 cu. ft. Gas Dryer with Integrated Touch Controls in White

Model Color Price
DVG54M8750W White Contact us for best price
Samsung Appliances7.4 cu. ft. Gas Dryer with Steam Sanitize+ in Black Stainless Steel

Add To Compare

Samsung Appliances 7.4 cu. ft. Gas Dryer with Steam Sanitize+ in Black Stainless Steel

Model Color Price
DVG54R7200V Fingerprint Resistant Black Stainless Steel 1079.00*

*See price in cart

Samsung Appliances7.4 cu. ft. Gas Dryer with Steam Sanitize+ in Black Stainless Steel

Add To Compare

Samsung Appliances 7.4 cu. ft. Gas Dryer with Steam Sanitize+ in Black Stainless Steel

Model Color Price
DVG54R7600V Fingerprint Resistant Black Stainless Steel Contact us for best price
DVG54R7600C Champagne $1,059.00

Page 2 of 2
<< First Page 12

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