MED & HEAVY TRUCKS FOR SALE

Med & Heavy Trucks

SET
SELECT COUNT(iid) FROM TNT_vShared LEFT JOIN TNT_sclass ON TNT_sclass.class=TNT_vShared.class AND TNT_sclass.subclass=TNT_vShared.subclass LEFT JOIN TNT_dealers ON TNT_dealers.did=TNT_vShared.did LEFT JOIN TNT_vSpec ON TNT_vSpec.id=iid LEFT JOIN TNT_privateSale ON TNT_privateSale.psid=TNT_vShared.psid WHERE status='Live' AND TNT_vShared.class='Truck' AND scweb IN ('construction-truck') AND (rprice<=300000 OR rprice IS NULL) AND (odmiles<=1750000 OR odmiles IS NULL) AND TNT_vShared.class!='Parts' AND ulock!='On' AND dstatus!='Off' AND dplock!='On' AND list!='Private' AND TNT_vShared.did>0 AND endate>=CURDATE()
1 RESULTS
matthews-paoli-ford
CALL Dealer for $$
USED
TRY AUTO SALES CORP.
www.tryautosales.net
(216) 267-2646 Ask Us
Stock5485
Miles102,046
EngineCaterpillar C-12 265 HP
Detailed Description
ALLISON AUTOMATIC, VOLUMETRIC MIXER, STRONG BODY 6 CUBIC YARD, A/C, AXLE LOCK, PTO, DUEL TANKS, FLOOD 425/65R 22.5, 11,584 HOURS
american-trucks-equipment
1 RESULTS