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 AND ((CommonBrandID = 'LG')) 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 1
1

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
LG Appliances7.4 cu. ft. Ultra Large Capacity Dryer w/ NFC Tag On Technology

Add To Compare

LG Appliances 7.4 cu. ft. Ultra Large Capacity Dryer w/ NFC Tag On Technology

Model Color Price
DLG3171W White Contact us for best price
LG Appliances7.4 cu. ft. Ultra Large Capacity Gas Dryer

Add To Compare

LG Appliances 7.4 cu. ft. Ultra Large Capacity Gas Dryer

Model Color Regular Price Savings After Savings
DLG3401W White $989.00 $240.00 $749.00
LG Appliances7.4 cu. ft. Ultra Large Capacity Smart wi-fi Enabled Front Load Gas Dryer with Built-In Intelligence

Add To Compare

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

Model Color Regular Price Savings After Savings
DLG3601V Graphite Steel $1209.00 $360.00 $849.00
LG Appliances7.4 cu. ft. Ultra Large Capacity SteamDryer&trade; w/ NFC Tag On

Add To Compare

LG Appliances 7.4 cu. ft. Ultra Large Capacity SteamDryer™ w/ NFC Tag On

Model Color Price
DLGX3571W White Contact us for best price
 energy star appliance LG Appliances7.4 cu. ft. Ultra Large Capacity Smart wi-fi Enabled SteamDryer&trade;

Add To Compare

LG Appliances 7.4 cu. ft. Ultra Large Capacity Smart wi-fi Enabled SteamDryer™

Model Color Price
DLGX3701V Graphite Steel Contact us for best price
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
DLGX4001W White ✅ In Stock $1209.00 $110.00 $1,099.00
 energy star appliance LG Appliances7.4 cu.ft. Ultra Large Capacity TurboSteam&trade; Gas Dryer

Add To Compare

LG Appliances 7.4 cu.ft. Ultra Large Capacity TurboSteam™ Gas Dryer

Model Color Price
DLGX4371K Black Stainless Steel Contact us for best price
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
DLGX4501B Black Steel $1759.00 $510.00 $1,249.00
LG AppliancesLG SIGNATURE 9.0 cu. ft. Large Smart wi-fi Enabled Gas Dryer w/ TurboSteam&trade;

Add To Compare

LG Appliances LG SIGNATURE 9.0 cu. ft. Large Smart wi-fi Enabled Gas Dryer w/ TurboSteam™

Model Color Regular Price Savings After Savings
DLGX9501K Black Stainless Steel $2309.00 $420.00 $1,889.00
LG Appliances4.2 cu.ft. Smart wi-fi Enabled Compact Front Load Dryer with Dual Inverter HeatPump&trade; Technology

Add To Compare

LG Appliances 4.2 cu.ft. Smart wi-fi Enabled Compact Front Load Dryer with Dual Inverter HeatPump™ Technology

Model Color Regular Price Savings After Savings
DLHC1455V Graphite Steel $1319.00 $320.00 $999.00

Page 1 of 1
1

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