WordPress database error: [Incorrect parameter count in the call to native function 'LOWER']
SELECT iMP_vSClass.scweb, iMP_vSClass.scseo, iMP_vSClass.pl, iMP_vShared.*, iMP_vSpec.*, iMP_lotM.* FROM (iMP_vShared, iMP_vSpec) LEFT JOIN iMP_vSClass ON iMP_vSClass.class = iMP_vShared.class AND iMP_vSClass.subclass = iMP_vShared.subclass LEFT JOIN iMP_lotM ON labbr = lot WHERE iMP_vShared.status IN('Live','Pend','Psuedo') AND iMP_vShared.list = 'Public' AND iMP_vSpec.id = iMP_vShared.id AND iMP_vShared.id >= 1 AND LOWER() = 'commercialtrucktrader' GROUP BY iMP_vShared.id ORDER BY iMP_vShared.rprice DESC

Home Page - Tri State Truck Sales
Tri-State Truck & Equipment Sales LLC
1b Merit Drive
New Castle, DE 19720

2 Miles from the DE Memorial Bridge
 
(302) 276-1253
Fax: (302) 276-1257
 
Deleware State Chamber of Commerce
We're Moving the Economy One Truck at a Time!

Welcome to Tri-State Truck & Equipment Sales

Selling Quality Used Trucks, Daycabs and Sleepers

Tri-State Truck & Equipments Sales mission is to deliver quality vehicles to the customer at a good price and in a fair and reasonable manner. We believe that integrity and value do not have to be sacrificed in order to be successful in business, and at the same time we excel in getting the customer great pricing for the vehicles and equipment they purchase.

Featured Inventory

There are no results to display. Clear all filters.