osCommerce
  Products » Specials My Account  |  Cart Contents  |  Checkout   
  Fireplace Tool Sets  |  Fire Rings  |  Cast Iron Doors and Registers  |  Fireplace Accessories  |  Log Holders  |  NEW PRODUCTS
Products
 Garden Accessories

 Sur-Flame Firestarters

 Stove and Hearth

 Cast Iron Products

 Fireplace Accessories

 Outdoor Products

 Composters

 Emergency/Survival Products
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Shopping Cart more
0 items
Information
Shipping & Returns
Privacy & Security
Contact Us

VIEW ALL PRODUCTS


buy online

find us on facebook!

Wholesale
For Wholesale Opportunities,
CLICK HERE
FAQ
For answers to frequently asked questions about some our products,
CLICK HERE
Get Them While They're Hot! Get Them While They're Hot!
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-9, 9' at line 1

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

[TEP STOP]