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.SellOnWeb FROM productgroups p WHERE p.ProductId IS NOT NULL AND NOT (p.ProductId = 1719 OR p.ProductId = 5595) AND ( (InStr(p.ModelNo,'blomberg') > 0 OR InStr(p.Make,'blomberg') > 0 OR InStr(Group1,'blomberg') > 0 OR InStr(Group2,'blomberg') > 0 OR InStr(ShortDesc,'blomberg') > 0 OR InStr(LongDesc,'blomberg') > 0 OR InStr(MetaKeywords,'blomberg') > 0 OR InStr(Colour,'blomberg') > 0)) GROUP BY p.ModelNo ORDER BY SellingPrice ASC, p.Make ASC, p.ModelNo ASC
Appliances - Buy Kitchen Appliances | E.B. Marsh

Free Delivery & Installation

In some cases we are able to offer free local delivery and installation.

Please see our 'Delivery & Installation' page for more information.