Laundry - Dryers - Electric: Match Front 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 = 'electric-match-front-load-dryers' 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
12
Compare Products:
  • Product List View
  • Product Grid View

Page 6 of 6
<< First Page 3456

Samsung Appliances7.5 cu. ft. Electric Dryer with Steam Sanitize+ in White

Add To Compare

Samsung Appliances 7.5 cu. ft. Electric Dryer with Steam Sanitize+ in White

Model Color Price
DVG45T6200W White ✅ In Stock 944.00*

*See price in cart

Samsung Appliances7.5 cu. ft. Smart Dial Electric Dryer with Super Speed Dry in Ivory

Add To Compare

Samsung Appliances 7.5 cu. ft. Smart Dial Electric Dryer with Super Speed Dry in Ivory

Model Color Price
DVE50A8600E Ivory 1169.00*

*See price in cart

Samsung Appliances7.5 cu. ft. Smart Dial Electric Dryer with Super Speed Dry in Brushed Black

Add To Compare

Samsung Appliances 7.5 cu. ft. Smart Dial Electric Dryer with Super Speed Dry in Brushed Black

Model Color Price
DVE50A8800V Brushed Black 1349.00*

*See price in cart

Samsung Appliances7.4 cu. ft. Capacity Electric Dryer with Sensor Dry in Brushed Black

Add To Compare

Samsung Appliances 7.4 cu. ft. Capacity Electric Dryer with Sensor Dry in Brushed Black

Model Color Price
DVE50R5200V Brushed Black 809.00*

*See price in cart

Samsung Appliances7.5 cu. ft. Smart Electric Dryer with FlexDry&trade; in Black Stainless Steel

Add To Compare

Samsung Appliances 7.5 cu. ft. Smart Electric Dryer with FlexDry™ in Black Stainless Steel

Model Color Price
DVE55M9600V Fingerprint Resistant Black Stainless Steel Contact us for best price
Samsung Appliances7.5 cu. ft. Smart Electric Dryer with FlexDry&trade; in Black Stainless Steel

Add To Compare

Samsung Appliances 7.5 cu. ft. Smart Electric Dryer with FlexDry™ in Black Stainless Steel

Model Color Price
DVE60M9900V Fingerprint Resistant Black Stainless Steel $1,999.00
Samsung Appliances7.4 cu. ft. Gas Dryer with Sensor Dry in Brushed Black

Add To Compare

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

Model Color Price
DVG45T3400V Brushed Black 854.00*

*See price in cart

Speed QueenDC5 Sanitizing Electric Dryer with Extended Tumble  Reversible Door  5-Year Warranty

Add To Compare

Speed Queen DC5 Sanitizing Electric Dryer with Extended Tumble Reversible Door 5-Year Warranty

Model Color Regular Price Savings After Savings
DC5003WE White $1249.00 $150.00 $1,099.00
Speed QueenDF7 Stainless Steel Electric Dryer with Front Control  5-Year Warranty

Add To Compare

Speed Queen DF7 Stainless Steel Electric Dryer with Front Control 5-Year Warranty

Model Color Regular Price Savings After Savings
DF7000SE Stainless Steel $2099.00 $200.00 $1,899.00
Speed QueenDR3 Sanitizing Electric Dryer with 3-Year Warranty

Add To Compare

Speed Queen DR3 Sanitizing Electric Dryer with 3-Year Warranty

Model Color Regular Price Savings After Savings
DR3003WE White $999.00 $100.00 $899.00
Speed QueenDR5 Sanitizing Electric Dryer with Steam  Over-dry Protection Technology  ENERGY STAR&reg; Certified  5-Year Warranty

Add To Compare

Speed Queen DR5 Sanitizing Electric Dryer with Steam Over-dry Protection Technology ENERGY STAR® Certified 5-Year Warranty

Model Color Regular Price Savings After Savings
DR5003WE White $1099.00 $100.00 $999.00
Speed QueenDR7 Sanitizing Electric Dryer with Pet Plus&trade;  Steam  Over-dry Protection Technology  ENERGY STAR&reg; Certified  7-Year Warranty

Add To Compare

Speed Queen DR7 Sanitizing Electric Dryer with Pet Plus™ Steam Over-dry Protection Technology ENERGY STAR® Certified 7-Year Warranty

Model Color Regular Price Savings After Savings
DR7003WE White $1349.00 $150.00 $1,199.00

Page 6 of 6
<< First Page 3456

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