New Products

We are continually adding new items to our line. Here are some of the great new products which we have recently added. There are also additional new products throughout our website. If you would like to see us carry something else, that we do not currently offer, please feel free to let us know. We would love to hear your suggestions. Also, be sure to check out this New Products section periodically so you wont miss out on the latest product releases. Enjoy shopping!

Displaying 1 to 17 (of 17 products)

Result Pages:  1

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 'limit 0, 40' at line 1

select p.products_image, p.products_model, pd.products_description, pd.products_name, pd.products_description, pd.products_description, p.products_quantity, p.products_piece_price, p.products_id, p.manufacturers_id, p.products_price, p.products_master, p.products_master_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c left join categories c on c.categories_id = p2c.categories_id where c.categories_status = '1' and p.products_status = '1' and p.products_listing_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 = '427' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', c.categories_hide_from_groups) = 0 order by limit 0, 40

[TEP STOP]