The Vette Store Has Moved

We are excited to announce the launch of the new Vette Store! You can browse and purchase our catalog of Corvette products at http://thevettestore.com. Returning customers can still log in to the old store to access your order history and outstanding shipments.

Take Me to the New Store!
The Vette Store The Vette Store Corvette
  Top » Catalog » Specials My Account  |  Cart Contents  |  Checkout   
Categories
All Things Chevrolet
Clearance Corvette Apparel->
Corvette Apparel 3X - 4X
Corvette Apparel for Women
Corvette Artwork
Corvette Calendars
Corvette Car Care Accessories
Corvette Carpets/Floor Mats
Corvette Casual Shirts
Corvette Children's Clothing
Corvette Christmas Cards
Corvette Coin Banks
Corvette Diecast Cars
Corvette Gifts
Corvette Golf Shirts
Corvette Hats
Corvette Jackets
Corvette Jewelry
Corvette Products Under $10
Corvette Sweatshirts
Corvette T-shirts
Corvette Travel Mugs
Gift Certificates
NCOA Accessories
Pens
What's New? more
Corvette Kid Contigo Gizmo Bottle
Corvette Kid Contigo Gizmo Bottle
$17.00
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Privacy Notice
Contact Us
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]