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 |211 - 240 Displayed

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
11 INTERNATIONAL
TranStar
$26,500
Day Cab
420842
ISM
Automatic
1 - OH
Yes / No
06 INTERNATIONAL
9400i
$38,000
Not Specified
754474
Not Specified
Manual
1 - ND
Yes / No
07 INTERNATIONAL
WORKSTAR 7400
$34,900
Not Specified
70162
Not Specified
Automatic
1 - ND
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
08 PETERBILT
367
$56,900
Cab & Chassis
386683
ISX
Manual
1 - ND
Yes / No
07 KENWORTH
T800
$74,900
Not Specified
207000
3406
Manual
1 - ND
Yes / No
07 Sterling
L9500
$89,900
Fuel & Lube
252544
C13
Manual
1 - ND
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
99 KENWORTH
T800
$19,900
Day Cab
520000
N14
Manual
1 - ND
No / No
15 FREIGHTLINER
CASCADIA
$62,900
Day Cab
675589
DD15
AMT
1 - ND
Yes / No
18 FREIGHTLINER
Cascadia
$36,900
Day Cab
832000
DD13
Manual
1 - ND
No / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
15 FREIGHTLINER
CASCADIA
$56,900
Day Cab
587552
DD15
AMT
1 - ND
Yes / No
12 FREIGHTLINER
M2-106
$59,900
Cab & Chassis
130104
8.3 Diesel
Automatic
1 - ND
No / No
08 KENWORTH
T800
$36,500
Day Cab
425960
C-15
Manual
1 - ND
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 KENWORTH
T800
$37,500
Day Cab
846453
C13
Manual
1 - ND
Yes / No
15 KENWORTH
T800
$64,900
Day Cab
Not Specified
ISX
Automatic
1 - ND
Yes / No
07 KENWORTH
T800
$85,000
Day Cab
47097
C-15
Manual
1 - ND
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 INTERNATIONAL
DURASTAR 4400
$0
Not Specified
137000
DT466
Automatic
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
455000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
491000
ISX
Manual
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 INTERNATIONAL
9400i
$0
Day Cab
399000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
469000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
495000
ISX
Manual
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 INTERNATIONAL
9400i
$0
Day Cab
450000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
450000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
492000
ISX
Manual
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 INTERNATIONAL
9400i
$0
Day Cab
533000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
450000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
497000
ISX
Manual
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 INTERNATIONAL
9400i
$0
Day Cab
486000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
439000
ISX
Manual
1 - TX
Yes / No
07 INTERNATIONAL
9400i
$0
Day Cab
534000
ISX
Manual
1 - TX
Yes / No
747 Matches |211 - 240 Displayed