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 ( Group1 = 'fridges & freezers' AND Group2 = 'freestanding fridges' AND Group3 = 'upright fridges' 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
3 - Freestanding Fridges Fridges & Freezers | 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?