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 |91 - 120 Displayed

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
12 INTERNATIONAL
7400 SBA
$46,900
Cab & Chassis
82200
MF 9
Automatic
1 - LA
Yes / No
08 INTERNATIONAL
4300
$18,999
Cab & Chassis
Not Specified
DT 466
Ultrashift
1 - LA
Yes / No
13 INTERNATIONAL
Paystar 5000
$28,000
Not Specified
231000
MaxxForce13
10
1 - LA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
17 INTERNATIONAL
7400 SBA
$99,995
Cab & Chassis
750
Not Specified
Automatic
1 - LA
Yes / No
17 INTERNATIONAL
HX
$159,949
Not Specified
Not Specified
N 13
Automatic
1 - LA
Yes / No
13 INTERNATIONAL
Prostar
$16,000
Not Specified
326080
Not Specified
10
1 - LA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
19 INTERNATIONAL
HX
$146,990
T/A Sleeper
1000
X15
10
1 - LA
Yes / No
19 INTERNATIONAL
MV
$99,995
Cab & Chassis
750
L9
Automatic
1 - LA
Yes / No
14 INTERNATIONAL
4300
$33,900
Cab & Chassis
267872
DT
Not Specified
1 - LA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
18 INTERNATIONAL
LT
$119,000
T/A Sleeper
166000
X15
18 Spd
1 - LA
Yes / No
14 INTERNATIONAL
4300
$39,900
Cab & Chassis
226949
Not Specified
Not Specified
1 - LA
Yes / No
13 INTERNATIONAL
Paystar 5000
$28,000
Not Specified
246000
MaxxForce13
10
1 - LA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
15 INTERNATIONAL
WORKSTAR 7600
$99,900
Dump Steel
27924
Not Specified
Automatic
1 - LA
Yes / No
05 Mack
CH Series
$29,900
Dump Steel
354018
E7
13 Spd
1 - LA
Yes / No
12 WESTERN STAR
4900SB
$44,900
Not Specified
383313
DD13
10
1 - WI
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
07 FREIGHTLINER
BUSINESS CLASS M2 10
$39,900
Utility Body
198547
MBE900
9 Spd
1 - WI
Yes / No
10 Sterling
Any Model
$54,900
Other
181487
ISC
8LL
1 - WI
Yes / No
06 FREIGHTLINER
BUSINESS CLASS M2 10
$28,900
Cab & Chassis
240445
7.2
10
1 - WI
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
13 FREIGHTLINER
BUSINESS CLASS M2 10
$42,900
Van
189751
ISB
Automatic
1 - WI
Yes / No
12 FREIGHTLINER
BUSINESS CLASS M2 10
$34,900
Van
213700
ISB
6 Spd
1 - WI
Yes / No
10 Sterling
A 9500
$25,900
Not Specified
374443
MBE4000
10
1 - WI
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
10 FREIGHTLINER
Business Class M2 10
$49,900
Cab & Chassis
172346
MBE4000
8LL
1 - WI
Yes / No
10 FREIGHTLINER
Business Class M2 10
$44,900
Cab & Chassis
246756
MBE4000
Automatic
1 - WI
Yes / No
09 Sterling
LT9501
$49,900
Cab & Chassis
39638
MBE4000
Automatic
1 - WI
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
10 FREIGHTLINER
Business Class M2 10
$43,900
Cab & Chassis
289133
MBE4000
Automatic
1 - WI
Yes / No
05 Sterling
LT9501
$43,900
Cab & Chassis
Not Specified
MBE4000
Automatic
1 - WI
Yes / No
12 FREIGHTLINER
Business Class M2 10
$44,900
Not Specified
84650
DD13
10
1 - WI
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
12 FREIGHTLINER
Business Class M2 10
$49,900
Dump Steel
318586
DD13
10
1 - WI
Yes / No
11 INTERNATIONAL
TRANSTAR
$64,900
Other
265628
Maxxforce 11
Automatic
1 - WI
Yes / No
12 FREIGHTLINER
M2-112
$43,900
Cab & Chassis
274976
DD13
10
1 - IN
Yes / No
747 Matches |91 - 120 Displayed