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='LightDuty' AND (status IN('Live','Pseudo','Prep') OR (status='Sold' AND chkdate IS NULL)) AND list='Public' AND iMP_co.id=1 GROUP BY scweb ORDER by scseo

PICK-UPS FOR SALE
ALA Equipment Sales Logo
WHOLESALE EQUIPMENT SALES, INC.
Birmingham, AL.
HOURS OF OPERATION
Mon – Fri: 8am – 5pm
Saturday: by appointment

PICK-UPS FOR SALE

Show Only In-Stock Units
2 RESULTS
USED 2016 CHEVROLET 2500 4WD 3/4 TON PICKUP TRUCK PICK-UP #1762
124,567 MILES...
$19,950
Birmingham, AL   (214) 918-6134
Stock #:
F100156
Mileage:
124,567
USED 2014 CHEVROLET 2500 2WD 3/4 TON PICKUP TRUCK PICK-UP #1681
CREW CAB 4WD LEATHER , POWER SEAT Z71 PKG 151,102 MILES, DURAMAXX V8 ENGINE, EXTERIOR COLOR: RED...
$24,500
Birmingham, AL   (205) 563-4559
Stock #:
122361
Mileage:
151,102
Engine:
Duramaxx
2 RESULTS