DOLLY TRAILERS FOR SALE

Trailers

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='Trailer' AND scweb IN ('dolly-trailer') AND (rprice<=300000 OR rprice 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()
3 RESULTS
matthews-paoli-ford
eQUIP ENTERPRISES
www.equipsellsit.com
(407) 259-7775 Ask Us
Stock10173
WheelsSteel
Detailed Description
2004 Fontaine 48X102 in good overall condition.
eQUIP ENTERPRISES
www.equipsellsit.com
(407) 259-7775 Ask Us
Stock10172
WheelsSteel
Detailed Description
2003 Fontaine 48X102 in good overall condition.
HALE TRAILER VOORHEES
www.haletrailer.com
(800) 232-6535 Ask Us
Stock----------
SuspAir Ride
Length42.0'
Width120"
WheelsAll Steel
Detailed Description
60 Ton Capacity, Remote, Load Bunk.
wm-cohen-and-sons-inc
3 RESULTS