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 = 'cookers' AND Group2 = 'standard cookers' AND Group3 = 'freestanding dual fuel' ) 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
Freestanding Dual Fuel - Buy Freestanding Dual Fuel 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?