SELECT DISTINCT(year) AS year FROM (iMP_vShared, iMP_vSpec) LEFT JOIN iMP_co ON iMP_co.id=iMP_vShared.cid LEFT JOIN iMP_lotM ON labbr=lot LEFT JOIN iMP_vSClass ON iMP_vSClass.class=iMP_vShared.class AND iMP_vSClass.subclass=iMP_vShared.subclass WHERE iMP_vShared.id=iMP_vSpec.id AND status ='Order' AND list='Public' AND iMP_co.id=1 AND lot NOT IN('x-MIA','x-POM','x-WPB') AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') ORDER BY year DESC
SELECT iMP_vShared.*,iMP_vShared.id AS vid,iMP_vSpec.*,iMP_co.*,iMP_lotM.*,scseo,pl,scweb,DATEDIFF(CURDATE(),msdate) AS msexp FROM (iMP_vShared, iMP_vSpec) LEFT JOIN iMP_co ON iMP_co.id=iMP_vShared.cid LEFT JOIN iMP_lotM ON labbr=lot LEFT JOIN iMP_vSClass ON iMP_vSClass.class=iMP_vShared.class AND iMP_vSClass.subclass=iMP_vShared.subclass WHERE iMP_vShared.id=iMP_vSpec.id AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') AND status ='Order' AND list='Public' AND iMP_co.id=1 AND UPPER(lcity)=UPPER('newburgh') AND UPPER(lstate)=UPPER('ny') AND lot NOT IN('x-MIA','x-POM','x-WPB') GROUP BY iMP_vShared.id ORDER BY photo DESC, iMP_vShared.id DESC LIMIT 0, 24
TRUCKS FOR SALE IN NEWBURGH-NY
Google Reviews
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302
Google Reviews

TRUCKS FOR SALE IN NEWBURGH-NY

Show Only In-Stock Units
2 RESULTS
USED 2014 VOLVO VNM64T200 DAYCAB TRUCK #10257
2014 VOLVO VNM64T200 DAY CAB TRACTOR HIGHLIGHTS •HP CAN BE BUMPED UP TO 450 •HIGH FUEL ECONOMY •EXPERTLY FLEET MAINTAINED •NATIONWIDE LOCATIONS AVAILABLE LOOKING FOR YO...
$26,500
Newburgh, NY   954-884-8205
Stock #:
NF243047
Mileage:
525,535
Engine:
Volvo D13405 HP
Trans:
AMT I Shift
Whlbase:
174
USED 2014 FREIGHTLINER CASCADIA 113 SLEEPER TRUCK #10026
2014 FREIGHTLINER CASCADIA 113 TANDEM AXLE SLEEPER HIGHLIGHTS •HIGH FUEL ECONOMY •EXPERTLY FLEET MAINTAINED •NATIONWIDE LOCATIONS AVAILABLE LOOKING FOR YOUR NEXT TRACTOR? SAVE...
$31,900
Newburgh, NY   954-884-8205
Stock #:
NF141378
Mileage:
599,610
Engine:
Detroit DD13410 HP
Trans:
10 Spd Spd.
Whlbase:
208
2 RESULTS