anke SELECT DISTINCT p.ProductId, p.Make, p.ModelNo, p.SellingPrice, p.WebFlags, p.ShortDesc, p.EnergyRating, p.StrapLine, p.OldPrice, p.Itemtype, p.Producttype, p.DeliverySurcharge, p.Group1, p.Group2, p.Group3, p.Colour, p.MainImageName, p.ActualStock, p.ManufactureGuarantee, p.LongDesc, p.CashbackValue, p.QtyDueIn, p.DateDueIn, p.QtySold, p.GrossMargin,p.TopSellerInclude, p.TopSellerExclude FROM productgroups p WHERE p.ProductId IS NOT NULL AND NOT (p.ProductId = 19977 OR p.ProductId = 19978) AND ( p.Make = 'samsung' AND Group1 = 'fridges & freezers' AND Group2 = 'freestanding wine coolers' AND (Mid(`WebFlags`,7,1) = '1' OR ActualStock > 0) ) GROUP BY p.ModelNo ORDER BY (p.TopSellerInclude) DESC,(p.QtySold AND p.ActualStock>0 AND NOT p.TopSellerExclude) DESC,p.QtySold DESC, (Mid(`WebFlags`,1,1) = '1' AND ActualStock > 0) DESC,(Mid(`WebFlags`,7,1) = '1' OR ActualStock > 0) DESC,p.SellingPrice ASC
Samsung Freestanding Wine Coolers - Buy Samsung Freestanding Wine Coolers Online | Appliance City
Skip Navigation Appliance City
Multibuy(0)
Basket(0)

If you're looking for multiple appliances we can offer you a great package deal.

Simply create a multi-buy list and submit it to our sales team.

How your multi-buy works...

Your basket is empty


Feefo logo Search 0115 965 1937

Why choose Appliance City?