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 |31 - 60 Displayed
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 International
8600
$34,000
Non-Sleeper
367486
ISM
Ultrashift
1 - IN
Yes / No
07 International
9400i
$34,500
Non-Sleeper
548748
ISX435ST
10
1 - IN
Yes / No
07 International
8600
$25,000
Non-Sleeper
417741
ISM
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 International
8600
$23,500
Non-Sleeper
499832
ISM
10
1 - IN
Yes / No
06 International
8600
$32,000
Non-Sleeper
377507
ISM
10
1 - IN
Yes / No
06 Volvo
VNL64T630
$15,500
Sleeper
991509
VED 465
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
13 International
Prostar
$22,500
Sleeper
459778
Not Specified
10
1 - IN
Yes / No
90 International
4700
$11,500
Dump Steel
255865
DT360
5+2 Spd
1 - IN
Yes / No
08 International
9200i
$37,500
Non-Sleeper
370505
ISM410
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
16 International
Prostar
$117,500
Non-Sleeper
Not Specified
ISX
10
4 - IN
Yes / No
09 International
Prostar
$35,000
Non-Sleeper
312774
ISX
10
1 - IN
Yes / No
10 International
Prostar
$22,000
Sleeper
592510
MF13
10
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
10 International
Prostar
$19,000
Sleeper
662939
MF13
10
1 - IN
Yes / No
10 International
Prostar
$19,000
Sleeper
682746
MF13
10
1 - IN
Yes / No
07 Volvo
VNL64T670
$16,500
Sleeper
10042785
ISX
9 Spd
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 Volvo
VNL64T670
$17,500
Sleeper
910569
ISX
9 Spd
1 - IN
Yes / No
07 Volvo
VNL64T670
$18,000
Sleeper
868826
ISX
9 Spd
1 - IN
Yes / No
16 International
Prostar
$116,500
Non-Sleeper
Not Specified
ISX
10
3 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 International
9400i
$36,000
Non-Sleeper
591434
C-15
10
1 - IN
Yes / No
07 International
9400i
$36,000
Non-Sleeper
537820
C-15
10
1 - IN
Yes / No
05 International
8600
$28,500
Non-Sleeper
406421
ISM
Not Specified
1 - IN
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
05 International
9400i
$32,000
Non-Sleeper
314340
C-15
10
1 - IN
Yes / No
03 International
9100i
$21,500
Non-Sleeper
431464
C-12
10
1 - IN
Yes / No
14 Mack
PINNACLE CXU613
$45,900
T/A Sleeper
433903
MP8
M Drive
1 - ND
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
04 INTERNATIONAL
8500
$58,900
Other
73000
8.7
Automatic
1 - ND
Yes / No
89 KENWORTH
T400
$7,500
T/A Non-Sleeper
Not Specified
3306
9 Spd
1 - ND
Yes / No
03 KENWORTH
W900
$48,900
T/A Non-Sleeper
1033464
C-15
10
1 - ND
Yes / No
Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
85 KENWORTH
LW900
$19,500
Not Specified
Not Specified
3406
13 Spd
1 - ND
Yes / No
14 Freightliner
CASCADIA
$54,900
T/A Sleeper
373887
DD13
10
5 - IL
Yes / No
14 PETERBILT
579
$46,500
T/A Sleeper
450400
ISX
Ultrashift Plus
9 - IL
Yes / No
747 Matches |31 - 60 Displayed