Laundry - Washers - 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 = 'washers' AND cSlug = 'top-load-washers' 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
14
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

 energy star appliance LG Appliances4.5 cu. ft. Top Load Washer

Add To Compare

LG Appliances 4.5 cu. ft. Top Load Washer

Model Color Regular Price Savings After Savings
WT7100CW White (w) ✅ In Stock $879.00 $230.00 $649.00
LG Appliances4.8 cu. ft. Mega Capacity Smart wi-fi Enabled Top Load Washer with Agitator and TurboWash3D&trade; Technology

Add To Compare

LG Appliances 4.8 cu. ft. Mega Capacity Smart wi-fi Enabled Top Load Washer with Agitator and TurboWash3D™ Technology

Model Color Regular Price Savings After Savings
WT7305CV Graphite Steel ✅ In Stock $1099.00 $350.00 $749.00
 energy star appliance LG Appliances4.5 cu. ft. Ultra Large Capacity Top Load Washer with Front Control Design

Add To Compare

LG Appliances 4.5 cu. ft. Ultra Large Capacity Top Load Washer with Front Control Design

Model Color Price
WT1501CW White (w) Contact us for best price
LG Appliances5.0 cu.ft. MEGA Capacity TurboWash&trade; Washer with Steam

Add To Compare

LG Appliances 5.0 cu.ft. MEGA Capacity TurboWash™ Washer with Steam

Model Color Price
WT5680HVA Graphite Steel Contact us for best price
LG Appliances4.3 cu. ft. Mega Capacity Top Load Washer with 4-Way&trade; Agitator & TurboDrum&trade; Technology

Add To Compare

LG Appliances 4.3 cu. ft. Mega Capacity Top Load Washer with 4-Way™ Agitator & TurboDrum™ Technology

Model Color Regular Price Savings After Savings
WT7005CW White $769.00 $103.00 $666.00
 energy star appliance LG Appliances5.0 cu. ft. Large Capacity Smart wi-fi Enabled Top Load Washer

Add To Compare

LG Appliances 5.0 cu. ft. Large Capacity Smart wi-fi Enabled Top Load Washer

Model Color Price
WT7200CW White Contact us for best price
LG Appliances5.0 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D&trade; Technology

Add To Compare

LG Appliances 5.0 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D™ Technology

Model Color Regular Price Savings After Savings
WT7300CV Graphite Steel $1099.00 $350.00 $749.00
 energy star appliance LG Appliances5.0 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D&trade; Technology

Add To Compare

LG Appliances 5.0 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D™ Technology

Model Color Regular Price Savings After Savings
WT7300CW White (w) $989.00 $290.00 $699.00
 energy star appliance LG Appliances5.2 cu. ft. Mega Capacity Top Load Washer with TurboWash&reg; Technology

Add To Compare

LG Appliances 5.2 cu. ft. Mega Capacity Top Load Washer with TurboWash® Technology

Model Color Price
WT7500CW White Contact us for best price
 energy star appliance LG Appliances5.2 cu. ft. Mega Capacity Top Load Washer with TurboWash&reg; Technology

Add To Compare

LG Appliances 5.2 cu. ft. Mega Capacity Top Load Washer with TurboWash® Technology

Model Color Price
WT7600HWA White Contact us for best price
 energy star appliance LG Appliances5.7 Cu.Ft. Mega Capacity Top Load Washer With TurboWash&reg; Technology

Add To Compare

LG Appliances 5.7 Cu.Ft. Mega Capacity Top Load Washer With TurboWash® Technology

Model Color Price
WT7700HVA Graphite Steel Contact us for best price
 energy star appliance LG Appliances5.5 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D&trade; Technology

Add To Compare

LG Appliances 5.5 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D™ Technology

Model Color Regular Price Savings After Savings
WT7800CW White ✅ In Stock $1209.00 $410.00 $799.00
LG Appliances5.5 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D&trade; Technology

Add To Compare

LG Appliances 5.5 cu.ft. Smart wi-fi Enabled Top Load Washer with TurboWash3D™ Technology

Model Color Regular Price Savings After Savings
WT7900HBA Black Steel (b) $1429.00 $480.00 $949.00

Page 1 of 1
1

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