SELECT A.Status, A.Class, A.AskPrice, A.Retail_Price, A.SellPrice, A.State, A.Qty, A.Year, ItemNumber = A.StockNumber, A.Make, A.Model, AcceptOffers = A.A_Offers, ItemType = A.BodyType, A.Mileage, A.Engine_Model, A.Trans_Type, HasInspection = ISNULL(B.ObjectType_Key,0), A.Date_Avail, A.Date_Needed, A.PhotoURL1, C.ShowOnHotspot, HotspotExpired = ISNULL(C.HotspotExpired,'y'), PriceRating = ISNULL(C.PriceRating, 0), D.IconFilename_Search, Suspension='', Length=0, Outside_Width=0 FROM vw_Equipment_Main_With_Main_Photo_URL A LEFT OUTER JOIN Inspection_Report_V2 B On A.StockNumber = B.Truck_Key LEFT OUTER JOIN vw_Hotspot_Status C ON A.StockNumber = C.StockNumber LEFT OUTER JOIN tblCharityData D ON C.CharityName = D.CharityName WHERE Class='heavy' and Status='current' and (Inc_On_Retail='y')
Now showing Available Heavy Trucks
762 Matches |631 - 660 Displayed
94 KENWORTH
T800
$27,500
T/A Cab & Chassis
280132
S60 12.7
Manual
1 - ID
Yes / No
92 WHITE/GMC
ACL64FR
$29,500
Dump Steel
247933
Not Specified
Manual
1 - ID
Yes / No
23 FREIGHTLINER
Business Class M2 10
$85,500
Day Cab
30232
DD13
Automatic
1 - ID
Yes / No
23 FREIGHTLINER
Business Class M2 10
$85,500
Day Cab
16759
DD13
Automatic
1 - ID
Yes / No
23 FREIGHTLINER
Business Class M2 10
$85,500
Day Cab
13053.6
DD13
Automatic
1 - ID
Yes / No
23 FREIGHTLINER
Business Class M2 10
$85,500
Day Cab
60301
DD13
Automatic
1 - ID
Yes / No
26 FREIGHTLINER
CASCADIA
$0
Not Specified
400
DD15
AMT
1 - GA
Yes / No
23 FREIGHTLINER
CASCADIA
$76,900
Not Specified
502198
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
378
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
0
DD15
AMT
1 - GA
Yes / No
26 FREIGHTLINER
CASCADIA
$179,286
Not Specified
313
DD15
AMT
1 - GA
Yes / No
21 FREIGHTLINER
CASCADIA
$54,900
Not Specified
608296
DD15
AMT
1 - GA
Yes / No
21 FREIGHTLINER
CASCADIA
$58,900
Day Cab
416136
DD13
AMT
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$49,900
Day Cab
400920
DD13
AMT
1 - GA
Yes / No
22 FREIGHTLINER
CASCADIA 116
$59,900
Not Specified
499306
DD13
AMT
1 - GA
Yes / No
21 FREIGHTLINER
CASCADIA
$63,900
Not Specified
462853
DD15
Manual
1 - GA
Yes / No
22 FREIGHTLINER
CASCADIA
$69,900
Day Cab
328400
DD15
AMT
1 - GA
Yes / No
21 FREIGHTLINER
CASCADIA
$59,900
Day Cab
247731
DD13
AMT
1 - GA
Yes / No
21 FREIGHTLINER
CASCADIA
$59,900
Day Cab
246826
DD13
AMT
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$69,900
Not Specified
336759
DD15
Manual
1 - GA
Yes / No
21 FREIGHTLINER
CASCADIA
$75,900
Not Specified
434118
DD15
AMT
1 - GA
Yes / No
22 FREIGHTLINER
CASCADIA
$76,900
Not Specified
482940
DD15
AMT
1 - GA
Yes / No
762 Matches |631 - 660 Displayed
Copyright © 2000 - 2025 Heavy Truck And Equipment Wholesalers
|
Site maintained by
HTAEW.com
|
Patent Pending
|
.
|