CHOOSE BRANCH TEXAS TRUCK CENTER.COM
CHOOSE MFR. A.M. HAIRE BABB CHEVROLET CM DODGE FORD FREIGHTLINER GMC HINO INTERNATIONAL ISUZU J & I KENWORTH MACK MITSUBISHI FUSO MORGAN PETERBILT STERLING SUPREME WESTERN STAR
CHOOSE CATEGORY
FLATBED DUMP TRUCK
FUEL-LUBE
SINGLE AXLE DUMP TRUCK
TOW-RECOVERY
WINCH
BOX VAN
BUCKET BOOM TRUCK
CAB CHASSIS
CRANE TRUCK
FLATBED DUMP
LIGHT DUTY UTILITY TRUCK
TRUCK
VAN BODY
CHOOSE MODEL
11 FT
14 FT
185
24 FT
26 FT
268
330
3500
3500SLT
4300
4900SA
7500
7600
8.5 FT
9 FT
BULLET 5500
BUSINESS CLASS M2
BUSINESS CLASS M2 106
F350
F350 XL
F450
F450 LARIAT
F450 XLT
F550
F550 XL
F550 XL SD
F650
F650 XL
F750
FL50
FL70
FM-SR
FTR
GRANITE GU813
KODIAK C4500
KODIAK C5500
KODIAK C6500
KODIAK C7500
KODIAK C8500
LT9511
NPR HD
NQR
RAM 3500
RAM 3500SLT
RAM 5500
RD
SILVERADO 3500 LT
T370
T7500
TOPKICK C4500
TOPKICK C5500
TOPKICK C6500
TOPKICK C7500
W4500
W5500
WT5500
SORT
S-YEAR
S-MODEL
S-PRICE
ASC
DESC
TEXAS TRUCK CENTER.COM
10555 FM 1960 W HOUSTON, TX 77070 WWW.TEXASTRUCKCENTER.COM
(800) 700-6601
FAX (281) 807-5322
TEXAS TRUCK CENTER.COM TEXASTRUCKCENTER.COM
SELECT UTA_vShared.id AS id,year,make,UTA_vShared.class AS class,UPPER(model) AS model,UTA_vShared.subclass,
description,rprice,shoprice,UPPER(scseo) AS scseo,photo,year(CURDATE()) AS CY,odmiles,fobcity,fobstate,
odmiles,engmake,engdet,enghp,coname,cophone1,utype,owner
FROM UTA_vShared
LEFT JOIN UTA_vSClass ON UTA_vShared.subclass=UTA_vSClass.subclass
LEFT JOIN UTA_vSpec ON UTA_vSpec.id=UTA_vShared.id
LEFT JOIN UTA_br ON UTA_br.id=owner
WHERE owner='13' AND status='Live' AND list='Public'
ORDER BY year DESC, model LIMIT 0,20
CALL
2009
2009 WESTERN STAR 4900SA 10 MILES LIGHT DUTY UTILITY TRUCK
CAT C-12
CALL
2009
2009 MACK GRANITE GU813 12 FUEL-LUBE
MACK MP7
CALL
2009
2009 CM RD FLATBED DUMP
FLATBED BY CM TRAILE..
CALL
2009
2009 KENWORTH T370 LIGHT DUTY UTILITY TRUCK
PACCAR 8.3L ISC PX-8 CU
CALL
2008
2008 J & I 11 FT FLATBED DUMP
SPECS: 11 FT. MODEL ..
CALL
2008
2008 J & I 14 FT FLATBED DUMP
SPECS: 14 FT. MODEL ..
CALL
2008
2008 J & I 8.5 FT FLATBED DUMP
SPECS: 8.5 FT. MODEL..
CALL
2008
2008 J & I 9 FT FLATBED DUMP
SPECS: 9 FT. MODEL O..
CALL
2008
2008 STERLING BULLET 5500 32 MILES CRANE TRUCK
CUMM 6.7L ISB
CALL
2008
2008 STERLING BULLET 5500 19 MILES LIGHT DUTY UTILITY TRUCK
CUMM 6.7L ISB
CALL
2008
2008 FORD F550 9 MILES LIGHT DUTY UTILITY TRUCK
INTL 6.4L TWIN TURBO V8
CALL
2008
2008 FORD F550 11 MILES LIGHT DUTY UTILITY TRUCK
FORD 6.4L TWIN TURBO V8
CALL
2008
2008 FORD F550 59K MILES LIGHT DUTY UTILITY TRUCK
MILES
CALL
2008
2008 DODGE RAM 5500 15 MILES FUEL-LUBE
CUMM 6.7L ISB
CALL
2008
2008 DODGE RAM 5500 22 MILES LIGHT DUTY UTILITY TRUCK
CUMM 6.7L ISB TURBO
CALL
2008
2008 DODGE RAM 5500 12 MILES LIGHT DUTY UTILITY TRUCK
CUMM 6.7L ISB
CALL
2007
2007 HINO 268 21K MILES FLATBED DUMP
HINO 7.7L
CALL
2007
2007 HINO 268 21K MILES FLATBED DUMP
HINO 7.7L
CALL
2007
2007 DODGE 3500 7K MILES LIGHT DUTY UTILITY TRUCK
CUMM 6.7L I6 ISB
CALL
2007
2007 DODGE 3500SLT 31K MILES FLATBED DUMP TRUCK
CUMM 6.7L I6 ISB