SALT SPREADERS FOR SALE

Heavy Equipment

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='Equipment' AND scweb IN ('salt-spreader') 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()
1 RESULTS
try-auto-sales-corp
BRANDYWINE TRUCKS & EQUIPMENT
www.brandywine-eqp.com
(866) 545-1926 Ask Us
Stock843H
Detailed Description
8', NO SPINNER
bentley-truck-services
1 RESULTS