Laundry - Dryers - Gas: 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 = 'gas-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
15
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 4
1234 Last Page >>

 energy star appliance ElectroluxFront Load Perfect Steam&trade; Gas Dryer with LuxCare&reg; Dry and Instant Refresh - 8.0 Cu. Ft.

Add To Compare

Electrolux Front Load Perfect Steam™ Gas Dryer with LuxCare® Dry and Instant Refresh - 8.0 Cu. Ft.

Model Color Regular Price Savings After Savings
EFMG527UIW White ✅ In Stock $1249.00 $150.00 $1,099.00
LG Appliances7.4 cu. ft. Ultra Large Capacity Smart wi-fi Enabled Front Load Gas Dryer with TurboSteam&trade; and Built-In Intelligence

Add To Compare

LG Appliances 7.4 cu. ft. Ultra Large Capacity Smart wi-fi Enabled Front Load Gas Dryer with TurboSteam™ and Built-In Intelligence

Model Color Regular Price Savings After Savings
DLGX4201B Black Steel ✅ In Stock $1539.00 $540.00 $999.00
 energy star appliance ElectroluxFront Load Gas Dryer with 5 cycles - 8.0 Cu. Ft.

Add To Compare

Electrolux Front Load Gas Dryer with 5 cycles - 8.0 Cu. Ft.

Model Color Regular Price Savings After Savings
EFDG317TIW White $1099.00 $150.00 $949.00
 energy star appliance ElectroluxFront Load Perfect Steam&trade; Gas Dryer with 7 cycles - 8.0 Cu. Ft.

Add To Compare

Electrolux Front Load Perfect Steam™ Gas Dryer with 7 cycles - 8.0 Cu. Ft.

Model Color Regular Price Savings After Savings
EFMG427UIW White $1149.00 $150.00 $999.00
 energy star appliance ElectroluxFront Load Perfect Steam&trade; Gas Dryer with PredictiveDry&trade; and Instant Refresh - 8.0. Cu. Ft.

Add To Compare

Electrolux Front Load Perfect Steam™ Gas Dryer with PredictiveDry™ and Instant Refresh - 8.0. Cu. Ft.

Model Color Regular Price Savings After Savings
EFMG627UTT Titanium ✅ In Stock $1499.00 $200.00 $1,299.00
 energy star appliance MaytagFront Load Gas Dryer with Extra Power and Quick Dry cycle - 7.3 cu. ft.

Add To Compare

Maytag Front Load Gas Dryer with Extra Power and Quick Dry cycle - 7.3 cu. ft.

Model Color Price
MGD5630HW White $999.00
MaytagSmart Capable Top Load Gas Dryer with Extra Power Button - 7.4 cu. ft.

Add To Compare

Maytag Smart Capable Top Load Gas Dryer with Extra Power Button - 7.4 cu. ft.

Model Color Price
MGD6230HC Metallic Slate $1,099.00
MaytagSmart Capable Top Load Gas Dryer with Extra Power Button - 7.4 cu. ft.

Add To Compare

Maytag Smart Capable Top Load Gas Dryer with Extra Power Button - 7.4 cu. ft.

Model Color Price
MGD6230RHW White $1,099.00
 energy star appliance MaytagFront Load Gas Dryer with Extra Power and Quick Dry Cycle - 7.3 cu. ft.

Add To Compare

Maytag Front Load Gas Dryer with Extra Power and Quick Dry Cycle - 7.3 cu. ft.

Model Color Price
MGD6630HC Metallic Slate $1,199.00
MaytagSmart Capable Top Load Gas Dryer with Extra Power Button - 7.4 cu. ft.

Add To Compare

Maytag Smart Capable Top Load Gas Dryer with Extra Power Button - 7.4 cu. ft.

Model Color Price
MGD7230HC Metallic Slate $1,199.00
 energy star appliance MaytagSmart Front Load Gas Dryer with Extra Power and Advanced Moisture Sensing with industry-exclusive extra moisture sensor - 7.3 cu. ft.

Add To Compare

Maytag Smart Front Load Gas Dryer with Extra Power and Advanced Moisture Sensing with industry-exclusive extra moisture sensor - 7.3 cu. ft.

Model Color Price
MGD8630HW White $1,349.00
Whirlpool7.4 cu.ft Front Load Long Vent Gas Dryer with Intuitive Controls

Add To Compare

Whirlpool 7.4 cu.ft Front Load Long Vent Gas Dryer with Intuitive Controls

Model Color Price
WGD560LHW White $1,049.00
 energy star appliance Whirlpool7.4 cu. ft. Front Load Gas Dryer with Intuitive Touch Controls

Add To Compare

Whirlpool 7.4 cu. ft. Front Load Gas Dryer with Intuitive Touch Controls

Model Color Price
WGD5620HW White $999.00
 energy star appliance Whirlpool7.4 cu. ft. Front Load Gas Dryer with Steam Cycles

Add To Compare

Whirlpool 7.4 cu. ft. Front Load Gas Dryer with Steam Cycles

Model Color Price
WGD6620HC Chrome Shadow $1,199.00
 energy star appliance Whirlpool7.4 cu. ft. Front Load Gas Dryer with Steam Cycles

Add To Compare

Whirlpool 7.4 cu. ft. Front Load Gas Dryer with Steam Cycles

Model Color Price
WGD8620HC Chrome Shadow $1,399.00

Page 1 of 4
1234 Last Page >>

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