Dimplex ASN20 Ashington Electric Fire

FREE DELIVERY! Dimplex ASN20 Ashington Electric Fire

An inset fire with Optiflame® plus effect. Fits standard 16" and 18" fireplace openings and all conventional flues. Chassis allows the fire to be full inset where flue allows. Real coals. 2kW fan heater with choice of 2 heat setting plus thermostat control. Brass effect with black.

Large ViewLarge View
Inset depth of only 55mm using spacer provided. 
Flame effect can be used independently of heat source.
Our Price £248.59

An error occurred executing the following query, and page execution has been terminated.

SELECT AlsoProducts.P_ID, AlsoProducts.P_Name1, Count(AlsoProducts.P_ID) AS TotalMatches FROM ((((tblCactuShop1Versions INNER JOIN tblCactuShop1InvoiceRows ON tblCactuShop1Versions.V_CodeNumber = tblCactuShop1InvoiceRows.IR_VersionCode) INNER JOIN tblCactuShop1Orders ON tblCactuShop1InvoiceRows.IR_OrderNumberID = tblCactuShop1Orders.O_ID) INNER JOIN tblCactuShop1InvoiceRows AS AlsoInvoiceRows ON tblCactuShop1Orders.O_ID = AlsoInvoiceRows.IR_OrderNumberID) INNER JOIN (tblCactuShop1Versions AS AlsoVersions INNER JOIN tblCactuShop1Products AS AlsoProducts ON AlsoVersions.V_ProductID = AlsoProducts.P_ID) ON AlsoInvoiceRows.IR_VersionCode = AlsoVersions.V_CodeNumber) LEFT OUTER JOIN tblCactuShop1Suppliers ON AlsoProducts.P_SupplierID = tblCactuShop1Suppliers.SUP_ID WHERE tblCactuShop1Versions.V_ProductID = 2329 AND AlsoVersions.V_ProductID NOT IN (0) AND AlsoVersions.V_ProductID <> 2329 AND P_Live = 'y' AND P_CustomerGroupID IN (0,0) AND AlsoProducts.P_Name1 <> '' AND (SUP_Live <> 'n' OR SUP_Live IS NULL) GROUP BY AlsoProducts.P_ID, AlsoProducts.P_Name1 ORDER BY Count(AlsoProducts.P_ID) DESC

Error Description : Record is deleted.

Page of error : /404.asp

Query String :

404;http://www.hurst-iw.co.uk:80/2.-Electrical-Appliances/Heating/Fires/Dimplex-ASN20-Ashington-Electric-Fire/p-128-137-341-2329/