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
721 Matches |361 - 390 Displayed
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
282712
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
365346
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
331333
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
322635
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$78,900
Not Specified
352230
Not Specified
Not Specified
1 - GA
Yes / No
17 FREIGHTLINER
CASCADIA
$48,900
Not Specified
546824
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$66,900
Not Specified
493535
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$66,900
Not Specified
494524
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$69,900
Day Cab
359888
DD15
Not Specified
1 - GA
Yes / No
24 FREIGHTLINER
CASCADIA
$0
Not Specified
193
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
122SD
$119,900
Day Cab
168477
X15
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$74,900
Not Specified
441755
DD15
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$76,900
Not Specified
428724
DD15
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA 116
$62,900
Not Specified
401494
DD13
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$49,900
Day Cab
435266
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$63,900
Not Specified
425772
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$68,900
Not Specified
439708
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$57,900
Not Specified
593494
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$67,900
Not Specified
402255
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$69,900
Not Specified
470199
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
122SD
$124,900
Day Cab
Not Specified
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$67,900
Not Specified
311769
Not Specified
Not Specified
1 - GA
Yes / No
17 FREIGHTLINER
CASCADIA
$45,900
Not Specified
566336
Not Specified
Not Specified
1 - GA
Yes / No
17 FREIGHTLINER
CASCADIA
$43,900
Not Specified
594903
Not Specified
Not Specified
1 - GA
Yes / No
15 KENWORTH
T680
$49,900
Not Specified
220624
Not Specified
Not Specified
1 - GA
Yes / No
19 PETERBILT
579
$37,900
Not Specified
503313
Not Specified
Not Specified
1 - GA
Yes / No
24 WESTERN STAR
4900
$185,900
Not Specified
518
Not Specified
Not Specified
1 - GA
Yes / No
24 WESTERN STAR
49X
$185,900
Not Specified
440
Not Specified
Not Specified
1 - GA
Yes / No
17 INTERNATIONAL
Prostar
$39,900
T/A Sleeper
556194
ISX15
Automatic
1 - SD
Yes / No
18 FREIGHTLINER
Cascadia
$37,900
T/A Sleeper
558057
X 15
Automatic
1 - SD
Yes / No
721 Matches |361 - 390 Displayed
Copyright © 2000 - 2025 Heavy Truck And Equipment Wholesalers
|
Site maintained by
HTAEW.com
|
Patent Pending
|
.
|