Laundry - Laundry Accessories - Laundry Accessories

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 = 'laundry-accessories' AND cSlug = 'laundry-accessories' 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
9
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

Samsung Appliances27" Pedestal (2019)

Add To Compare

Samsung Appliances 27" Pedestal (2019)

Model Color Price
WE402NC Champagne ✅ In Stock 251.00*

*See price in cart

WE402NV Brushed Black 251.00*

*See price in cart

WE402NW White 251.00*

*See price in cart

WE402NE Ivory 251.00*

*See price in cart

Samsung AppliancesMulltiControl&trade; Kit

Add To Compare

Samsung Appliances MulltiControl™ Kit

Model Color Price
DVMCK $29.00
Samsung AppliancesSmart Adapter

Add To Compare

Samsung Appliances Smart Adapter

Model Color Price
HD2018GH $24.99
Samsung AppliancesSK-DH - Stacking Kit for Samsung 24 in. wide Front Load Laundry Pairs

Add To Compare

Samsung Appliances SK-DH - Stacking Kit for Samsung 24 in. wide Front Load Laundry Pairs

Model Color Price
SKDH $39.99
Samsung AppliancesSKK-8K Stacking Kit for Samsung's 27" wide Front Load laundry pairs

Add To Compare

Samsung Appliances SKK-8K Stacking Kit for Samsung's 27" wide Front Load laundry pairs

Model Color Price
SKK8K $39.99
Samsung AppliancesSKK-BB - Stacking Kit for 30 in. wide Front Load Laundry Pairs

Add To Compare

Samsung Appliances SKK-BB - Stacking Kit for 30 in. wide Front Load Laundry Pairs

Model Color Price
SKKBB $44.99
Samsung Appliances30" Pedestal

Add To Compare

Samsung Appliances 30" Pedestal

Model Color Price
WE302NG Onyx Contact us for best price
WE302NV Fingerprint Resistant Black Stainless Steel Contact us for best price
Samsung Appliances27" Pedestal (2017)

Add To Compare

Samsung Appliances 27" Pedestal (2017)

Model Color Price
WE357A0W White Contact us for best price
WE357A0C Onyx Contact us for best price
WE357A0F Merlot Contact us for best price
WE357A0V Fingerprint Resistant Black Stainless Steel Contact us for best price
WE357A0Z Azure Blue Contact us for best price
Samsung Appliances27" Pedestal (2018)

Add To Compare

Samsung Appliances 27" Pedestal (2018)

Model Color Price
WE357A8W 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.