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 = 'gas range cookers' AND Colour = 'anthracite' AND (Mid(`WebFlags`,1,1) = '1') AND 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
Gas Range Cookers - Buy Gas Range Cookers 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?

Width

Price range:

Minimum Price£
Maximum Price£

Showing of 1 items

This is the first page  This is the first page  Prev  [ Page 1 of 1 ]  Next  This is the last page  This is the last page

Sort by:

Showing of 1 items

This is the first page  This is the first page  Prev  [ Page 1 of 1 ]  Next  This is the last page  This is the last page