Phone; 636-528-9443, Toll Free: 1-888-338-8584, Fax: 636-528-9447, Email Us: info@hechlers.com Hechler's Mainstreet Hearth & Home
HECHLER'S ON FACEBOOK

 
Home About Us Contact Us Your Fireplace Design Center Location Follow Us
Email Us: info@hechlers.com Hechler's On Facebook Hechler's on Twitter Hechler's YouTube Channel
Products | Specials & Closeouts | Online Store | Manufacturers | Showroom | Before & After | What's New | Product Videos | BBQs | Blog

Electric Fireplace Inserts

Why choose an electric insert? Quickest, most cost-effective retrofit option for an existing masonry fireplace opening.Perfect for faux fireplace mantels and can easily be taken out when desired.Expandable trim kit finishes masonry edges nicely, plus an ornate cast trim is available.

1 Can't create/write to file '/tmp/#sql_e0eb4_2.MYI' (Errcode: 28)
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '38' order by p.products_sort_order, pd.products_name]