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 scweb='reefer-truck' AND lot NOT IN('x-MIA','x-POM','x-WPB') ORDER BY photo DESC, iMP_vShared.id DESC LIMIT 0, 24
REEFER TRUCKS FOR SALE
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

REEFER TRUCKS FOR SALE

Show Only In-Stock Units
1 RESULTS
USED 2009 HINO 338 REEFER TRUCK #5567
2009 HINO 338 24' REEFER TRUCK 260HP HINO J08E-TW ENGINE ALLISON 3000RDS AUTOMATIC TRANSMISSION THERMOKING REEFER W/12K HOURS (ELECTRIC STANDBY EQUIPPED) AIR SUSPENSION MORGAN BODY 24'...
$21,900
South Florida, FL   954-278-8727
Stock #:
NH9HNRFP
Mileage:
212,476
Engine:
Hino J08E-TW260 HP
Trans:
Auto
1 RESULTS