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

Catalytic Combustors

Hechler's in Troy Missouri serving the St. Louis area stocks wood stove catalysts or catalytic combustors for various models of wood stoves including, Vermont Castings, Blaze King, Dutchwest, High Valley, BIS, Lennox and Buck Wood Burning Stoves. WE SHIP CATALYTIC COMBUSTORS TO CANADA VIA US POSTAL

1 Can't create/write to file '/tmp/#sql_84277_0.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 = '8' order by p.products_sort_order, pd.products_name]