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 = 'WHIR')) 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
11
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

Whirlpool7.0 cu.ft Top Load Gas Dryer with AutoDry

Add To Compare

Whirlpool 7.0 cu.ft Top Load Gas Dryer with AutoDry

Model Color Price
WGD4616FW White Contact us for best price
Whirlpool7.0 cu. ft. Top Load Gas Dryer with AutoDry Drying System

Add To Compare

Whirlpool 7.0 cu. ft. Top Load Gas Dryer with AutoDry Drying System

Model Color Price
WGD4850HW White $699.00
Whirlpool7.0 cu. ft. Top Load Gas Dryer with AutoDry Drying System

Add To Compare

Whirlpool 7.0 cu. ft. Top Load Gas Dryer with AutoDry Drying System

Model Color Price
WGD4950HW White $749.00
Whirlpool5.9 cu.ft Top Load Gas Dryer with AutoDry Drying System White

Add To Compare

Whirlpool 5.9 cu.ft Top Load Gas Dryer with AutoDry Drying System White

Model Color Price
WGD4985EW White $799.00
Whirlpool7.0 cu.ft Top Load Gas Dryer with AccuDry , Steam Refresh

Add To Compare

Whirlpool 7.0 cu.ft Top Load Gas Dryer with AccuDry , Steam Refresh

Model Color Regular Price Savings After Savings
WGD49STBW White 899.00*

*See price in cart

Whirlpool7.0 cu.ft Top Load Gas Dryer with Wrinkle Shield Plus White

Add To Compare

Whirlpool 7.0 cu.ft Top Load Gas Dryer with Wrinkle Shield Plus White

Model Color Price
WGD5000DW White $849.00
Whirlpool7.4 cu. ft. Top Load Gas Dryer with Intuitive Controls

Add To Compare

Whirlpool 7.4 cu. ft. Top Load Gas Dryer with Intuitive Controls

Model Color Price
WGD5100HC Chrome Shadow $999.00
Whirlpool7.4 cu. ft. Smart Capable Top Load Gas Dryer

Add To Compare

Whirlpool 7.4 cu. ft. Smart Capable Top Load Gas Dryer

Model Color Price
WGD6120HC Chrome Shadow $1,099.00
Whirlpool7.4 cu. ft. Smart Capable Top Load Gas Dryer

Add To Compare

Whirlpool 7.4 cu. ft. Smart Capable Top Load Gas Dryer

Model Color Price
WGD7120HC Chrome Shadow $1,199.00
Whirlpool8.8 cu. ft. Smart Capable Top Load Gas Dryer

Add To Compare

Whirlpool 8.8 cu. ft. Smart Capable Top Load Gas Dryer

Model Color Price
WGD8120HC Chrome Shadow $1,299.00
Whirlpool7.4 cu. ft. Top Load Gas Dryer with Advanced Moisture Sensing

Add To Compare

Whirlpool 7.4 cu. ft. Top Load Gas Dryer with Advanced Moisture Sensing

Model Color Price
WGD8127LC Chrome Shadow Contact us for best price

Page 1 of 1
1

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