Query1 is SELECT products.productID,productName,products.description,freeShipping,freeShippingApplies,warranty,rebate,utqg,tireDataID,sizeLong,loadRange,speedRating,od,loadRating,sideWallStyle,tireData.listPrice,tireData.ourPrice,tireData.salePrice,tireData.saleEndDate,manufacturer,CASE WHEN tireData.saleEndDate>NOW() THEN tireData.salePrice ELSE tireData.ourPrice END as price FROM tireData JOIN products USING (productID) JOIN pProductsManufacturers USING (productID) JOIN manufacturers USING (manufacturerID) WHERE sizeShort IN ('LT295/65-18','LT295x65-18') AND display='Y' ORDER BY price, productName
Search Results for your:
GOODYEAR TIRES WRANGLER DURATRAC
PRO COMP TIRES XTREME MT2
Buy LT295/65-18 Tires Online - Buy Tires Online and other custom tires from PerformancePlusTire.com. PerformancePlusTire.com is one of the leading tires sites around. Unlike other sites offering cheap tires, we offer brand name tires at discount prices. We have a retail facility in Long Beach, California and are family owned and operated for over 44 years.
Free Shipping on all Tire & Wheel Packages, includes Free Mount, Balance & Nitrogen Airfill
Performance Plus Tire offers FREE with every purchase: 100% Fitment Guarantee*, FREE Shipping on Tire & Wheel Packages*, FREE Nitrogen Tire Inflation & much much more.
© 2004 - 2015 Performance Plus Tires. All rights reserved. Performance Plus Tire is proud to offer the industry's finest brands of custom tires, custom wheels, tires and wheels packages, and hot rod parts and accessories for the car and truck enthusiast. Discount tires for car, light truck, SUV, and custom trucks.
How are we doing?