select car.*,pics.img,pics.main,pics.id from car left join pics on car.car_id=pics.car_id and pics.main=1 where type='bmw' order by is_Caroftheweek desc ,is_special desc,title limit 0,5

Available Pre-owned BMW's

All available vehicles are listed here.
Click on the image to see all details of the car

Sort By

2008 BMW 128i Coupe

Miles:40xxx

DescriptionThis sporty coupe was purchased new by Bimmerworks in the first year of production; "Year One of the 1". It is a very well equipped vehicle with only 38,000 miles. The car is white with a black interi ...

Price
$26900