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
705 Matches |331 - 360 Displayed
20 FREIGHTLINER
CASCADIA
$72,900
Not Specified
473348
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$69,900
Not Specified
469929
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$72,900
Not Specified
447523
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$76,900
Not Specified
462878
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Not Specified
433458
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$68,900
Not Specified
470357
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$68,900
Not Specified
467793
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$64,900
Not Specified
439321
DD15
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$69,900
Not Specified
466758
Not Specified
Not Specified
1 - GA
Yes / No
18 FREIGHTLINER
CASCADIA
$54,900
Not Specified
541687
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$67,900
Not Specified
472402
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA 116
$59,900
Not Specified
390742
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$64,900
Not Specified
445004
Not Specified
Not Specified
1 - GA
Yes / No
24 FREIGHTLINER
CASCADIA
$179,900
Not Specified
3
Not Specified
Not Specified
1 - GA
Yes / No
24 FREIGHTLINER
CASCADIA
$179,900
Not Specified
3
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
282712
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
365346
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
331333
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$69,900
Day Cab
322635
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$78,900
Not Specified
352230
Not Specified
Not Specified
1 - GA
Yes / No
17 FREIGHTLINER
CASCADIA
$48,900
Not Specified
546824
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$66,900
Not Specified
493535
Not Specified
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$66,900
Not Specified
494524
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$69,900
Day Cab
359888
DD15
Not Specified
1 - GA
Yes / No
24 FREIGHTLINER
CASCADIA
$0
Not Specified
193
Not Specified
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
122SD
$119,900
Day Cab
168477
X15
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$74,900
Not Specified
441755
DD15
Not Specified
1 - GA
Yes / No
20 FREIGHTLINER
CASCADIA
$76,900
Not Specified
428724
DD15
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA 116
$62,900
Not Specified
401494
DD13
Not Specified
1 - GA
Yes / No
19 FREIGHTLINER
CASCADIA
$49,900
Day Cab
435266
Not Specified
Not Specified
1 - GA
Yes / No
705 Matches |331 - 360 Displayed
Copyright © 2000 - 2025 Heavy Truck And Equipment Wholesalers
|
Site maintained by
HTAEW.com
|
Patent Pending
|
.
|