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 = 'SAMSA')) 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 2
12 Last Page >>

Samsung Appliances4.0 cu. ft. Top Load Washer with ActiveWave&trade; Agitator and Soft-Close Lid in White

Add To Compare

Samsung Appliances 4.0 cu. ft. Top Load Washer with ActiveWave™ Agitator and Soft-Close Lid in White

Model Color Price
WA40A3005AW White $599.00
 energy star appliance Samsung AppliancesWA3000 4.0 cu. ft. Top Load Washer with Self Clean

Add To Compare

Samsung Appliances WA3000 4.0 cu. ft. Top Load Washer with Self Clean

Model Color Price
WA40J3000AW White Contact us for best price
Samsung Appliances4.1 cu. ft. Capacity Top Load Washer with Soft-Close Lid and 8 Washing Cycles in White

Add To Compare

Samsung Appliances 4.1 cu. ft. Capacity Top Load Washer with Soft-Close Lid and 8 Washing Cycles in White

Model Color Price
WA41A3000AW White $599.00
Samsung Appliances4.4 cu. ft. Top Load Washer with ActiveWave&trade; Agitator and Soft-Close Lid in White

Add To Compare

Samsung Appliances 4.4 cu. ft. Top Load Washer with ActiveWave™ Agitator and Soft-Close Lid in White

Model Color Price
WA44A3205AW White $699.00
Samsung Appliances4.4 cu. ft. Top Load Washer with ActiveWave&trade; Agitator and Active WaterJet in Platinum

Add To Compare

Samsung Appliances 4.4 cu. ft. Top Load Washer with ActiveWave™ Agitator and Active WaterJet in Platinum

Model Color Price
WA44A3405AP Platinum 764.00*

*See price in cart

WA44A3405AW White 764.00*

*See price in cart

 energy star appliance Samsung Appliances4.5 cu. ft. Top Load Washer in White

Add To Compare

Samsung Appliances 4.5 cu. ft. Top Load Washer in White

Model Color Price
WA45M7050AW White Contact us for best price
Samsung Appliances4.5 cu. ft. Top Load Washer with Self Clean in White

Add To Compare

Samsung Appliances 4.5 cu. ft. Top Load Washer with Self Clean in White

Model Color Price
WA45N3050AW White Contact us for best price
Samsung Appliances4.5 cu. ft. Top Load Washer with Vibration Reduction Technology+ in White

Add To Compare

Samsung Appliances 4.5 cu. ft. Top Load Washer with Vibration Reduction Technology+ in White

Model Color Price
WA45T3200AW White $699.00
Samsung Appliances4.5 cu. ft. Capacity Top Load Washer with Active WaterJet in Brushed Black

Add To Compare

Samsung Appliances 4.5 cu. ft. Capacity Top Load Washer with Active WaterJet in Brushed Black

Model Color Price
WA45T3400AV Brushed Black 764.00*

*See price in cart

WA45T3400AP Platinum 764.00*

*See price in cart

 energy star appliance Samsung Appliances5.0 cu. ft. Top Load Washer in White

Add To Compare

Samsung Appliances 5.0 cu. ft. Top Load Washer in White

Model Color Price
WA50M7450AW White Contact us for best price
Samsung Appliances5.0 cu. ft. Capacity Top Load Washer with Active WaterJet in Brushed Black

Add To Compare

Samsung Appliances 5.0 cu. ft. Capacity Top Load Washer with Active WaterJet in Brushed Black

Model Color Price
WA50R5200AV Brushed Black 809.00*

*See price in cart

 energy star appliance Samsung Appliances5.0 cu. ft. Top Load Washer with Active WaterJet in White

Add To Compare

Samsung Appliances 5.0 cu. ft. Top Load Washer with Active WaterJet in White

Model Color Price
WA50R5200AW White $759.00
 energy star appliance Samsung Appliances5.0 cu. ft. Top Load Washer with Super Speed in Black Stainless Steel

Add To Compare

Samsung Appliances 5.0 cu. ft. Top Load Washer with Super Speed in Black Stainless Steel

Model Color Price
WA50R5400AV Fingerprint Resistant Black Stainless Steel 899.00*

*See price in cart

Samsung Appliances5.0 cu. ft. Top Load Washer with Active WaterJet in Champagne

Add To Compare

Samsung Appliances 5.0 cu. ft. Top Load Washer with Active WaterJet in Champagne

Model Color Price
WA50T5300AC Champagne $949.00

Page 1 of 2
12 Last Page >>

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