SELECT scweb,scseo,pl,iMP_vSClass.class AS class FROM iMP_vShared LEFT JOIN iMP_co ON iMP_co.id=iMP_vShared.cid LEFT JOIN iMP_lotM ON labbr=lot LEFT JOIN iMP_vSClass ON iMP_vSClass.class=iMP_vShared.class AND iMP_vShared.subclass=iMP_vSClass.subclass WHERE scseo IS NOT NULL AND list='Public' AND status='Live' AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') AND status IN('Live','Pend') AND list='Public' AND iMP_co.id=2 GROUP BY scweb ORDER by scseo

Home - Central California Used Trucks & Trailer Sales
CENTRAL CALIFORNIA TRUCK AND TRAILER SALES
800- 366-3263 800- 366-3263
Your Premier Central California Truck & Trailer Dealer
"We speak English, Spanish, Armenian, and Punjabi."
SIX LOCATIONS IN CALIFONIA
BAKERSFIELD, CA
FONTANA, CA
SAN DIEGO, CA
FRESNO, CA
FRENCH CAMP, CA
SACRAMENTO, CA

INVENTORY FOR SALE AT CENTRAL CALIFORNIA TRUCK AND TRAILER SALES IN CA.

TRUCKS FOR SALE IN SMITTY-CA

Show Only In-Stock Units
Trailers for Sale
1 RESULTS
USED 2014 FREIGHTLINER CASCADIA TANDEM AXLE DAYCAB TRUCK #10444
669,353 MILES, DETROIT DD13 ENGINE, 450 HP, ENGINE SERIAL: 471927S0192164, EXHAUST: SINGLE, EATON-FULLER AUTO FO-16E310C-LAS ULTRASHIF TRANSMISSION, CRUISE, POWER STEERING, 4 REAR, AXLES: TANDEM 12...
Call for Price
Smitty, CA   909-822-8447
Stock #:
8808
Mileage:
669,353
Engine:
Detroit DD13450 HP
Trans:
Eaton-Fuller FO-16E310C-LAS ULTRASHIF Auto
Whlbase:
194
1 RESULTS
CENTRAL CALIFORNIA'S PREMIER TRUCK & TRAILER DEALER