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 |151 - 180 Displayed

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
20 WESTERN STAR
4700SF
$0
Dump Steel
405
DD13
8LL
1 - PA
Yes / No
20 FREIGHTLINER
CASCADIA
$150,950
T/A Sleeper
804
DD15
12 Spd
1 - PA
Yes / No
18 FREIGHTLINER
BUSINESS CLASS M2 10
$119,000
Van
45255
ISL
9 Spd
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
16 FREIGHTLINER
CASCADIA
$0
T/A Sleeper
524369
DD15
10
1 - PA
Yes / No
16 FREIGHTLINER
CASCADIA
$74,900
T/A Sleeper
448626
DD15
Not Specified
1 - PA
Yes / No
16 FREIGHTLINER
CASCADIA
$79,900
T/A Sleeper
364035
DD15
10
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
16 FREIGHTLINER
CASCADIA
$79,900
T/A Sleeper
Not Specified
DD15
10
1 - PA
Yes / No
16 FREIGHTLINER
CASCADIA
$74,900
T/A Sleeper
490617
DD-15
Not Specified
1 - PA
Yes / No
19 FREIGHTLINER
CASCADIA
$109,000
Day Cab
Not Specified
DD15
12 Spd
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
18 WESTERN STAR
4900
$119,900
Day Cab
55251
Not Specified
10
1 - PA
Yes / No
20 FREIGHTLINER
122SD
$183,000
Dump Steel
84
DD13
Not Specified
1 - PA
Yes / No
20 FREIGHTLINER
122SD
$172,500
Roll-Off
3285
DD15
8LL
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
20 FREIGHTLINER
114SD
$170,225
Roll-Off
979
DD13
8LL
1 - PA
Yes / No
20 FREIGHTLINER
CASCADIA
$151,900
T/A Sleeper
121
DD15
12 Spd
1 - PA
Yes / No
20 FREIGHTLINER
BUSINESS CLASS M2 10
$71,000
Cab & Chassis
5
B6.7
Not Specified
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
20 FREIGHTLINER
BUSINESS CLASS M2 10
$74,575
Cab & Chassis
5
B6.7
Not Specified
1 - PA
Yes / No
20 WESTERN STAR
4900
$193,825
Dump Steel
400
X15
18 Spd
1 - PA
Yes / No
20 FREIGHTLINER
CASCADIA
$129,120
Day Cab
14
DD15
Not Specified
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
19 FREIGHTLINER
122SD
$172,000
Dump Steel
3198
DD15
8LL
1 - PA
Yes / No
19 FREIGHTLINER
CASCADIA
$109,000
Day Cab
101981
DD15
12 Spd
1 - PA
Yes / No
19 FREIGHTLINER
CASCADIA
$109,000
Day Cab
23855
DD15
12 Spd
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
17 WESTERN STAR
4700SB
$135,000
Dump Steel
232099
Not Specified
Not Specified
1 - PA
Yes / No
15 INTERNATIONAL
Prostar
$62,900
T/A Sleeper
296230
ISX
10
1 - PA
Yes / No
12 PETERBILT
367
$89,900
Dump Steel
245029
Not Specified
Not Specified
1 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
12 Mack
GRANITE GU713
$89,900
Dump Steel
344373
Not Specified
Not Specified
1 - PA
Yes / No
00 FREIGHTLINER
Century Class 120
$29,900
T/A Sleeper
523266
Not Specified
10
1 - PA
Yes / No
13 FREIGHTLINER
CASCADIA
$0
Day Cab
300000
Not Specified
10
35 - PA
Yes / No

Yr/Make:
Model:
Retail:
Body:
Miles:
Engine:
Trans:
Qty - State:
Offers/Report:
13 FREIGHTLINER
CASCADIA
$49,900
Day Cab
216905
DD13
10
1 - PA
Yes / No
13 FREIGHTLINER
CASCADIA
$46,900
Day Cab
328715
DD13
10
1 - PA
Yes / No
13 FREIGHTLINER
CASCADIA
$46,900
Day Cab
361000
DD13
10
1 - PA
Yes / No
747 Matches |151 - 180 Displayed