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 = 'ovens' AND Group2 = 'built in single ovens' AND Group3 = 'electric' ) 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
Electric - Buy Electric 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?