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 |241 - 270 Displayed

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
20 INTERNATIONAL
LT
$0
T/A Sleeper
442000
A-26
Automatic
1 - TX
Yes / No
19 Volvo
VNL64T760
$0
T/A Sleeper
353000
Not Specified
Automatic
1 - TX
Yes / No
09 PETERBILT
387
$0
T/A Sleeper
784000
ISX
Manual
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
09 PETERBILT
387
$0
T/A Sleeper
680000
ISX
Manual
1 - TX
Yes / No
09 PETERBILT
387
$0
T/A Sleeper
713000
ISX
Manual
1 - TX
Yes / No
06 INTERNATIONAL
WORKSTAR 7400
$0
Dump Steel
289000
DT466
Not Specified
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 PETERBILT
378 SBA
$0
Dump Steel
371000
ISX
Manual
1 - TX
Yes / No
11 Mack
GRANITE GU713
$0
Dump Steel
335000
MP8
Manual
1 - TX
Yes / No
16 INTERNATIONAL
DURASTAR 4300
$0
Van
165000
B6.7
Automatic
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
13 INTERNATIONAL
DURASTAR 4300
$0
Van
162000
MAXXFORCE DT
Automatic
1 - TX
Yes / No
13 INTERNATIONAL
DURASTAR 4300
$0
Van
164000
MAXXFORCE DT
Automatic
1 - TX
Yes / No
15 INTERNATIONAL
DURASTAR 4300
$0
Van
198000
MAXXFORCE DT
Automatic
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
15 FREIGHTLINER
CASCADIA
$0
Day Cab
504000
DD13
Automatic
1 - TX
Yes / No
15 FREIGHTLINER
CASCADIA
$0
Day Cab
514000
DD13
Automatic
1 - TX
Yes / No
15 FREIGHTLINER
CASCADIA
$0
Day Cab
505000
DD13
Automatic
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
11 Mack
GRANITE GU713
$0
Day Cab
448000
MP8
Manual
1 - TX
Yes / No
11 INTERNATIONAL
Prostar
$19,950
Sleeper
355716
Maxxforce 13
10
1 - MO
Yes / No
07 FREIGHTLINER
Columbia
$45,500
Day Cab
538160
S60 14.0L
Manual
1 - MO
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
06 INTERNATIONAL
TranStar
$29,900
Day Cab
117952
ISM
Manual
1 - MO
Yes / No
15 Volvo
VNL64T300
$49,900
Day Cab
350896
VED13
Manual
1 - MO
Yes / No
16 Volvo
VNL64T300
$43,500
Day Cab
589000
ISX
Manual
1 - MO
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
16 INTERNATIONAL
Prostar
$37,500
Sleeper
642979
ISX
Automatic
1 - MO
Yes / No
17 INTERNATIONAL
Prostar
$54,500
Day Cab
430459
ISX
Manual
1 - MO
Yes / No
16 INTERNATIONAL
Prostar
$42,500
Sleeper
608749
ISX15
Automatic
1 - MO
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
17 INTERNATIONAL
Prostar
$51,500
Day Cab
482487
ISX
Manual
1 - MO
Yes / No
11 INTERNATIONAL
Prostar
$19,950
Sleeper
320236
Maxxforce 13
Manual
1 - MO
Yes / No
18 Freightliner
114SD
$269,950
Tri-Axle Boom.
14950
DD13
Allison 4500 RDS
1 - TX
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
19 Volvo
VNL64T860
$79,900
Not Specified
520887
VED13
Automatic
1 - SD
Yes / No
21 FREIGHTLINER
CASCADIA
$99,900
Not Specified
407857
DD15
Automatic
1 - SD
Yes / No
04 Ford
F-650
$31,300
Utility Body
88785
Not Specified
Automatic
1 - SD
Yes / No
747 Matches |241 - 270 Displayed