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 |61 - 90 Displayed

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
11 KENWORTH
W900L
$65,000
T/A Sleeper
443997
ISX
18 Spd
1 - IL
Yes / No
07 Freightliner
COLUMBIA
$32,950
T/A Sleeper
713455
14l
10
1 - IL
Yes / No
14 PETERBILT
579
$45,500
T/A Sleeper
494096
ISX
Ultrashift Plus
10 - IL
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
08 INTERNATIONAL
Prostar
$27,500
Not Specified
640998
ISX
10
1 - IL
Yes / No
13 Freightliner
CASCADIA
$67,000
Not Specified
340669
dd13
Not Specified
1 - IL
Yes / No
05 WESTERN STAR
4900EX LOWMAX
$41,000
T/A Sleeper
1604499
14.l
13 Spd
1 - IL
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 PETERBILT
379 Ext Hood
$49,500
T/A Sleeper
983789
ISX
13 Spd
1 - IL
Yes / No
14 PETERBILT
384
$44,500
Not Specified
523204
MX13
10
1 - IL
Yes / No
14 Freightliner
CASCADIA
$51,900
T/A Sleeper
462000
DD13
10
4 - IL
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
16 Freightliner
CASCADIA
$76,500
T/A Sleeper
423125
DD15
DT12
4 - IL
Yes / No
11 PETERBILT
388
$125,000
Not Specified
648300
1sx
18 Spd
1 - IL
Yes / No
07 INTERNATIONAL
Other
$26,500
Not Specified
198995
dt466
Automatic
1 - IL
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
12 Freightliner
CASCADIA
$39,500
Not Specified
404125
DD13
10
3 - IL
Yes / No
12 Freightliner
CASCADIA
$42,500
Not Specified
343500
DD13
10
3 - IL
Yes / No
15 Freightliner
CASCADIA
$64,500
T/A Sleeper
386477
DD15
10
3 - IL
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
15 Freightliner
CASCADIA
$61,500
T/A Sleeper
485800
DD15
10
3 - IL
Yes / No
04 Freightliner
CENTURY CLASS 120
$9,500
T/A Sleeper
801322
14l
Autoshift
1 - IL
Yes / No
03 Freightliner
COLUMBIA
$23,500
T/A Sleeper
1352759
S60
Autoshift
2 - IL
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
15 Freightliner
CASCADIA
$61,750
T/A Sleeper
474350
DD15
10
3 - IL
Yes / No
14 Freightliner
CASCADIA
$53,900
T/A Sleeper
379000
DD13
10
3 - IL
Yes / No
14 Freightliner
BUSINESS CLASS M2 10
$22,000
Flatbed
305678
1sb
Automatic
1 - IL
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
04 Freightliner
FL 70
$31,250
Dump Steel
209845
c7
Automatic
1 - IL
Yes / No
19 INTERNATIONAL
HX
$199,900
Roll-Off
Not Specified
X15
Automatic
1 - LA
Yes / No
15 INTERNATIONAL
WORKSTAR 7600
$99,900
Dump Steel
69855
Not Specified
Automatic
1 - LA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
13 INTERNATIONAL
4300
$29,900
Van
140741
DT
Automatic
1 - LA
Yes / No
13 INTERNATIONAL
4300
$22,000
Van
235000
Not Specified
Automatic
1 - LA
Yes / No
19 INTERNATIONAL
HX
$146,990
T/A Sleeper
Not Specified
X15
10
1 - LA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
14 INTERNATIONAL
4300
$39,900
Van
226987
DT
6 Spd
1 - LA
Yes / No
13 INTERNATIONAL
4300
$36,900
Cab & Chassis
129471
Not Specified
Not Specified
1 - LA
Yes / No
13 INTERNATIONAL
4300
$22,000
Cab & Chassis
Not Specified
Not Specified
Automatic
1 - LA
Yes / No
747 Matches |61 - 90 Displayed