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 |331 - 360 Displayed

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
18 INTERNATIONAL
LT
$37,900
Day Cab
432763
X15
Not Specified
1 - IA
Yes / No
17 FREIGHTLINER
BUSINESS CLASS M2 10
$39,900
Day Cab
187338
ISL
Not Specified
1 - IA
Yes / No
18 INTERNATIONAL
LT
$0
Day Cab
522646
X15
Automatic
1 - IA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
19 INTERNATIONAL
LT
$22,900
Not Specified
469198
A26
Automatic
1 - IA
Yes / No
20 FREIGHTLINER
CASCADIA
$66,900
Not Specified
498975
DD15
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$57,900
Not Specified
543957
Not Specified
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
20 FREIGHTLINER
CASCADIA
$72,900
Day Cab
359916
DD15
Not Specified
1 - GA
Yes / No
17 FREIGHTLINER
CASCADIA
$39,900
Not Specified
669393
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$63,900
Not Specified
493722
DD15
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
17 FREIGHTLINER
CASCADIA
$19,900
Not Specified
910730
Not Specified
Not Specified
1 - GA
Yes / No
16 FREIGHTLINER
CASCADIA
$35,900
Day Cab
547205
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$67,900
Not Specified
404556
DD15
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
20 FREIGHTLINER
CASCADIA
$74,900
Not Specified
417569
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$74,900
Not Specified
454576
DD15
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$74,900
Not Specified
423614
Not Specified
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
21 FREIGHTLINER
CASCADIA
$79,900
Not Specified
385163
DD15
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$72,900
Not Specified
475311
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$78,900
Not Specified
386031
DD15
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
19 FREIGHTLINER
CASCADIA
$59,900
Day Cab
548523
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA 116
$59,900
Not Specified
360646
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$72,900
Not Specified
436375
Not Specified
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
24 FREIGHTLINER
CASCADIA
$0
Not Specified
1381
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Not Specified
420242
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$65,900
Not Specified
460041
Not Specified
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
19 FREIGHTLINER
CASCADIA
$65,900
Day Cab
455224
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$74,900
Not Specified
430424
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$65,900
Not Specified
468580
Not Specified
Not Specified
1 - GA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
19 FREIGHTLINER
CASCADIA
$72,900
Not Specified
409864
Not Specified
Not Specified
1 - GA
Yes / No
18 FREIGHTLINER
CASCADIA
$59,900
Not Specified
385998
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$69,900
Not Specified
468849
Not Specified
Not Specified
1 - GA
Yes / No
747 Matches |331 - 360 Displayed