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
747 Matches |1 - 30 Displayed
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
00 International
8100
$13,500
Cab & Chassis
457418
ISM
9 Spd
1 - IN
Yes / No
07 Freightliner
CENTURY 120
$16,000
Sleeper
911841
DD15
10
1 - IN
Yes / No
14 International
8600
$29,500
Non-Sleeper
493847
MF13
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
09 International
Prostar
$34,500
Non-Sleeper
502649
ISX435ST
10
1 - IN
Yes / No
07 International
8600
$33,500
Non-Sleeper
452760
ISM
10
1 - IN
Yes / No
05 International
8600
$29,500
Non-Sleeper
433123
ISM
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
97 Volvo
WG64T
$9,950
Non-Sleeper
464500
M11
9 Spd
1 - IN
Yes / No
09 International
8600
$32,500
Non-Sleeper
486606
ISM
10
1 - IN
Yes / No
06 International
4300
$19,500
Not Specified
263500
DT466
7 Spd
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
11 International
Prostar
$41,000
Sleeper
498144
ISX435ST
10
1 - IN
Yes / No
09 Freightliner
CASCADIA 125
$29,500
Sleeper
518747
DD15
10
1 - IN
Yes / No
11 International
9900i
$63,500
Non-Sleeper
298233
ISX485
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
11 International
Prostar
$41,500
Sleeper
381000
ISX435ST
10
1 - IN
Yes / No
12 International
Prostar
$25,000
Sleeper
336396
MF13
10
1 - IN
Yes / No
13 International
Other
$39,500
Cab & Chassis
162897
DT466
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
12 International
Prostar
$22,500
Sleeper
581856
MF13
10
1 - IN
Yes / No
10 International
Prostar
$35,000
Sleeper
503860
ISX435ST
10
1 - IN
Yes / No
09 International
Prostar
$19,500
Sleeper
367457
MF13
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
10 International
Prostar
$33,500
Non-Sleeper
571761
ISX435ST
10
1 - IN
Yes / No
10 International
TRANSTAR 8600
$37,500
Non-Sleeper
308952
ISM
Ultrashift
1 - IN
Yes / No
07 International
9400i
$36,000
Non-Sleeper
536063
ISX435ST
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
08 Volvo
VNL64T630
$15,500
Sleeper
903333
VED
10
1 - IN
Yes / No
07 International
9400i
$19,500
Sleeper
1032060
C-15
10
1 - IN
Yes / No
09 International
4300
$32,500
Cab & Chassis
119000
dt
6 Spd
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
11 International
Prostar
$41,000
Sleeper
484500
ISX435ST
10
2 - IN
Yes / No
10 International
Prostar
$37,500
Sleeper
486707
ISX435ST
10
1 - IN
Yes / No
09 International
Prostar
$35,000
Non-Sleeper
561565
ISX450
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
13 International
Prostar
$23,500
Non-Sleeper
402962
MF13
10
1 - IN
Yes / No
12 International
5900i
$39,500
Non-Sleeper
156000
MF13
18 Spd
1 - IN
Yes / No
91 International
9400i
$6,500
Non-Sleeper
309000
3176
9 Spd
1 - IN
Yes / No
747 Matches |1 - 30 Displayed