Skip to main content

Contact seller

Contact seller

By clicking here, you authorize Cars.com and its sellers/partners to contact you by text/calls which may include marketing and be by autodialer. Calls may be prerecorded. You also agree to our Privacy Notice. Consent is not required to purchase goods/services.

We value your privacy. Cars.com Privacy Notice

Customize your budget

Est. max vehicle price based on your desired monthly budget (...% APR*. and ...% sales tax)
$...*
See matching cars

*Estimated payments are calculated by Cars.com and are for informational purposes only. We’ve estimated your taxes based on your provided ZIP code. These estimates do not include title, registration fees, lien fees, or any other fees that may be imposed by a governmental agency in connection with the sale and financing of the vehicle. Other taxes may apply. They do not represent a financing offer or a guarantee of credit from the seller. Actual terms vary by lender.

**Your Saved Vehicles list will be shared along with your contact information when you submit a vehicle request to a dealership. To opt out of this sharing, please view your options on Cars.com Privacy Notice.

About your privacy: Cars.com is asking for your ZIP and credit rating because it helps us to make an educated guess at your sales tax and loan interest. These two factors can greatly change your monthly payment.

Used cars for sale near New Bloomfield, MO under $249,972

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
1,915 matches 30 miles from 65063
Be the first to know!

Save your search and get notified when new inventory arrives.

Prequalify now

It only takes a few minutes and won't affect your credit.

Get Prequalified
Est. $400 /mo*
Down Payment
$0
Net trade-in value
$0
Months
72
APR
7.0%
Sales tax
0.0%

Vehicle information

Ext. color: Gray
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 21-25
Fuel type: Gasoline
Transmission: Automatic
Engine: 3L I-6 gasoline direct injection, DOHC, Double VANOS variable va
Stock #: BU2708
VIN: 5UX23EM02R9U59108

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

BMW of Columbia - MO review

New BMW purchase

Went shopping for a new car for my wife. Dave Johnson was the salesman and was wonderful. Went back at closing time with my wife to look at the model she wanted. Dave had already went home for the day so we decided to come back the next day. Well Mr. Johnson heard we had come back in and drove from his house back to the dealership to help us after it had closed. We bought the car. My wife had found a Mercedez that she liked but bought the BMW just because of the customer service we received from Dave Johnson and the crew. We will definitely got back for another car.

2024 BMW X7 xDrive40i review

The best handled large SUV I ‘ve ever drive.

The best handled large SUV I ‘ve ever drive. Much better than my previous large Mercedes SUV. Or my previous Land Rover Some of the plastic adornments outside looks cheap.

Vehicle information

Ext. color: Jet Black
Int. color: Beige
Drivetrain: Rear-wheel Drive
MPG: 18-27
Fuel type: Gasoline
Transmission: Automatic
Engine: 3L I-6 DOHC, Double VANOS variable valve control, premium unlead
Stock #: BU2873
VIN: WBAUL7C56BVJ78765

Features

Convenience: Heated Seats, Keyless Entry
Entertainment: Bluetooth®, CD Player, HomeLink, Satellite Radio, USB Port
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

BMW of Columbia - MO review

Two kids - two cars

I've worked with Josh Reichlin and Rusty Drewing a couple times already for my personal vehicle purchases, but with my 15-year old twins getting their permits, we needed something for them as well. Josh was great to work with as usual - helping us sort through the options until we found what worked best for us. Negotiations with him and Rusty went quickly and smoothly with us reaching a fair deal on each vehicle. I highly recommend BMW of Columbia for both new and used vehicles. I should also mention Brad Davis in the finance department was great as well. Their customer service can't be beat and with a fair deal on the purchase what else can you ask for?

2011 BMW 128 128i review

2011 128i Bmw reliability.

Bought my 128i with 50,000 miles 3 years ago and it has needed very little attention. Basic maintenance and not any major problems. Had a z3 and this is every bit as fun to drive. For a 13 year old vehicle I get many people commenting on the looks and they think it is much newer. I think BMW is going to regret doing away with the inline 6 engine eventually. Super reliable engine that is only used in their upper end vehicles and the high performance M models now days. The turbocharger engines are impressive performing but you just don't get the reliability of them that are non turbo. Unless you are looking for more horsepower don't go turbocharger. They are expensive to maintain and turbos wear out premature opposed to non turbo engines. The 128i is the perfect amount of horsepower to size and weight for the majority of people. It is a shame that it was discontinued. If you find a well maintained one you can't go wrong. Ask any mechanic about turbo engine reliability and they will side with any car without a turbo!!

Vehicle information

Ext. color: Steel Gray
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 29-35
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.0L I4 16V MPFI DOHC
Stock #: N7833907
VIN: KNDJ23AU5N7833907

Features

Convenience: Keyless Entry
Entertainment: Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control

Reviews

Mazda of Columbia review

Angel Garrett

We found ourselves between a rock and a hard place and didn't think there was anything we could do, but we stopped at Machens to look at their "tent sale" vehicles. It was then that I ran into the greatest guy, Mr. MC Dampier, while I was certain there was nothing they could do to help us, MC was sure he could help us out. It took him less time than I thought and he had us preapproved for a reliable used car with low mileage and affordable payments. Along with MC, Mr. Dedrick Shelby was also very helpful and actually closed the deal. So, if you are need of a reliable car and a trustworthy dealer that can REALLY help you out instead of supplying empty promises, go see MC and Decrick, you will not regret it! I know I will be going back to see these gentlemen! MC and Dedrick, thank you for all you did for us and I hope you understand how important your actions were! Because of the two of you, my daughter now has a dependable car to get to work in that we don't have to take to get repaired once a month. You are both awesome!

2022 Kia Soul LX review

Great driver.

Great driver. Good gas mileage. Problem free. Second soul I have owned and just as good. My first was a 2013 and I had it for 6 years. I've had this one for over 3 years,

Vehicle information

Ext. color: Platinum
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: SKYACTIV-G 2.5L I-4 gasoline direct injection, DOHC, variable va
Stock #: BU2923
VIN: 3MVDMBBM1RM639773

Features

Convenience: Adaptive Cruise Control, Keyless Entry, Keyless Start, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Reviews

BMW of Columbia - MO review

Great experience with wonderful staff

Looking for a work car I found a 2017 Ford Focus, I drove 2 hours to look at it and ended up driving it home. Quality cars and Dave Watson was a super salesperson who makes you feel at home with no pressure to purchase. I wouldn’t hesitate to purchase from them again A on the experience

Vehicle information

Ext. color: Black
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 24-31
Fuel type: Gasoline
Transmission: Automatic
Engine: 3L I-6 gasoline direct injection, DOHC, VANOS variable valve con
Stock #: BU2894
VIN: WBA33EH04SCU52666

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

BMW of Columbia - MO review

They were very attentive and quick to respond.

They were very attentive and quick to respond. The vehicle I was interested in sold before I had opportunity to purchase, but that was because I live out of state and couldn’t get there to test drive soon enough!

Vehicle information

Ext. color: Dark Moon Blue Metallic
Int. color: Maple Sugar
Drivetrain: Rear-wheel Drive
MPG: 23-32
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 2.0L I4 16V GDI DOHC Turbo
Stock #: M0131118
VIN: 1G6DN5RK0M0131118

Features

Convenience: Keyless Entry, Navigation System, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Mazda of Columbia review

Joe Machens Mazda

Very good service, Tim Simon was knowledgeable and helpful! My overall experience was Excellent! Offer me refreshments and we’re very polite! I would recommend Tim to my friends and family!

2021 Cadillac CT5 Premium Luxury RWD review

this car is truly amazing

Got my CT5 about 5 months ago...it is everything I expect from Cadillac. Love the interior and the exterior style reeks of class and performance! The police have flagged me down only to compliment the car! I'm a GM girl and they continue to make me proud. LOVE my CT5! :+)

Vehicle information

Ext. color: Granite Crystal Metallic Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 17-22
Fuel type: Gasoline
Transmission: Automatic
Engine: Pentastar 3.6L V-6 DOHC, variable valve control, regular unleade
Stock #: BU2874
VIN: 1C6HJTFG9PL520736

Features

Convenience: Keyless Entry, Keyless Start, Navigation System
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

Reviews

BMW of Columbia - MO review

Nick, my salesperson was great Answered all my

Nick, my salesperson was great Answered all my questions and even arranged transportation for my purchase. Also help negotiate my buy price.

2023 Jeep Gladiator Overland review

MOST importantly it is a JEEP.

MOST importantly it is a JEEP. If you want a luxury vehicle, buy one, if you want a full-size truck, buy one, if you want a sports car, buy one, the Jeep Gladiator is none of these. It is designed to be a mid-sized pick-up yet still be a Jeep, it does this PERFECTLY. I have owned 9 Jeeps over the years, as early as 1978 up through 2006; the Jeeps today are full of more amenities and comfort than they ever have been in history. I have 2 Gladiators; a '23 Mojave, and a '23 Diesel Overland, both of them are INCREDIBLE vehicles on and off road, and MORE than fit the bill for a light duty pick-up, superseding most others on the market, and I am even comparing to any of the 5 Tacoma's I have owned. If you are in the market for a light duty pick-up, you can't beat it; whether it is a loaded up graded model, or even the base model, it is still a truck with 4WD, straight axles, and still available with a manual transmission. VERY happy with both of mine!

Vehicle information

Ext. color: Gray Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 31-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 port/direct injection, DOHC, VVT-i variable valve contr
Stock #: B21027A
VIN: 2T2JGMDA9NC075914

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, HomeLink, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Vehicle information

Ext. color: Silver Zynith
Int. color: Global Black
Drivetrain: Four-wheel Drive
MPG: 14-20
Fuel type: Gasoline
Transmission: Automatic
Engine: Hurricane 3L I-6 gasoline direct injection, DOHC, variable valve
Stock #: BU2943
VIN: 1C4SJSFP2RS131065

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof, Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Vehicle information

Ext. color: Black Sapphire Metallic
Int. color: Black
Drivetrain: Rear-wheel Drive
MPG: 22-32
Fuel type: Gasoline
Transmission: Automatic
Engine: 3L I-6 gasoline direct injection, DOHC, Double VANOS variable va
Stock #: BU2958
VIN: 3MW43CM04R8E57897

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2024 BMW M240 i review

My gift to myself

I did careful reviews of this model as well as the 4 Series. I was really looking at the 2023 4 Series 2Dr Coupe. I decided to go with the 2024 M240I because ... 1. it's a two door. I liked what I was seeing with the professional/owner reviews for the 2023 model year. And 2. I bought this as the last new car I will buy and as a reward to myself for a life well lived and jobs well done. I got the Portimao Blue Metallic Cognac Interior. I didn't pay for the add-on's that dealers like to charge. I only paid for what I had too. Do your homework on this. Will save thousand if you do. Some emails, couple of phone calls and the deal was done. Now, down to my opinions of this car.... I didn't really think I would like the run flats ... but, not bad at all. Like any tire, depending on the road surface, they can either be loud or quite. For the most part, quite. Add to that the build quality of BMW and I have a quite riding car. When the door closes, it does it with a solid "this door is closed" sound. Only other thing I will add about the tires ... I will get a donut spare. Don't like not being without it, run flats not withstanding. The interior is very well done I think. Everything is right there for you to get to without having to stretch for it. The IDrive 8 is very easy to work once you get it sorted the way you want it. Seats are very comfortable. Heated seats warm up nicely in cold weather ... so does the steering wheel. Sound system is great. I really like the fact that BMW kept the control wheel for the IDrive 8 system and didn't go full on touch screen. Same with buttons on the steering wheel. Real buttons. Another thing that I thought I wouldn't like was the toggle for the gear selector. Not a issue at all. Given the small interior for the 2Dr Coupe, the toggle works out well. A stalk selector would have been like a black eye. Engine response when you put your foot on it is right there. I've not noticed any turbo lag at all. Maybe due to the M240I being a 6 and not a 4. Power is there when you need it. My MPG so far has been about 26.5 in town. Was over 30 mpg on the highway/interstate. Having to use premium is not a factor for me. Knew that going in before I bought the car. For the cost of this car, spend the money and use the premium grade. Visibility hasn't been an issue at all. The tech is great. Works very well and is easy to set up the way you want it. The back up sensors were at first a bit annoying, but I got used to them fairly quickly. Loving the heads up display. So far, I've got no complaints.

Vehicle information

Ext. color: Midnight Black Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 41-38
Fuel type: Hybrid
Transmission: Automatic
Engine: Dynamic Force 2.5L I-4 port/direct injection, DOHC, VVT-i variab
Stock #: BU2936
VIN: 4T3RWRFV9RU122040

Features

Convenience: Adaptive Cruise Control, Keyless Entry, Keyless Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control

Reviews

2024 Toyota RAV4 Hybrid XLE review

I traded in a Corolla hatchback for this RAV4.

I traded in a Corolla hatchback for this RAV4. I love the size inside. I love the screen and it’s pretty comfortable though. I haven’t taken it on a very long trip. My gas mileage has decline since winter has come, but so far the all-wheel-drive is handling the snow

Vehicle information

Ext. color: Sterling Gray Metallic
Int. color: Jet Black w/Blue Accents
Drivetrain: Front-wheel Drive
MPG: 28-32
Fuel type: Gasoline
Transmission: Automatic
Engine: Ecotec 1.2L I-3 gasoline direct injection, DOHC, VVT variable va
Stock #: BU2935
VIN: KL77LHE20RC228300

Features

Convenience: Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control
Seating: Leather Seats

Reviews

2024 Chevrolet Trax LT review

Had this LT for a year now and it has been very nice.

Had this LT for a year now and it has been very nice. Great gas mileage and seems to get just a touch better on the HWY than reported. Overall a great value and good overall car in the entry level. I would recommend the LT trim as it has the nicer interior but keeps the price point down. It packs a ton of features that you don’t expect from market segment. Also gives you a lot more room than you expect, very comfortable for 4 people with no problems.

Vehicle information

Ext. color: Alpine White
Int. color: Black
Drivetrain: Rear-wheel Drive
MPG: 25-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, Double VANOS variable va
Stock #: BU2867
VIN: WBAHF3C01SWY41868

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2025 BMW Z4 sDrive30i review

Great car for every day commute + sports days .

Great car for every day commute + sports days . I live in Florida love dropping the top and zipping in the am + during busy times of day. Sexy car elegant in and out. had a 2015 model and now upgraded to 2025 and still loving it although soft top

Vehicle information

Ext. color: Crystal Black Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 gasoline direct injection, i-VTEC VCM variable valve co
Stock #: BU2953A
VIN: 5FNYF8H59NB007134

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, USB Port
Exterior: Alloy Wheels, Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2022 Honda Passport AWD EX-L review

Perfect family of 4 SUV with a bunch of space.

Perfect family of 4 SUV with a bunch of space. AVG 23.5 mph. The 9 speed transmission is not as smooth as the older 6 speeds. I wish you could permanently turn of the stop/Start. So far so good.

Vehicle information

Ext. color: Green
Drivetrain: Front-wheel Drive
MPG: 24-29
Fuel type: Gasoline
Transmission: 5-Speed M/T
Engine: 153.0HP 2.3L 4 Cylinder Engine Gasoline Fuel
VIN: 1FMYU02Z17KA51150

Features

Convenience: Keyless Entry
Entertainment: CD Player, USB Port
Exterior: Alloy Wheels, Tow Hitch
Safety: Blind Spot Monitor

Reviews

2007 Ford Escape XLS review

I bought my 2007 Escape inOctober of 2014.

I bought my 2007 Escape inOctober of 2014. It was a V6 when I got it it had 85,000 miles and I paid $9,000 for it. I drove it for 10& years until June 10, 2025 when someone ran a stop sign and totalled it. It had 275,000 miles and was still a great car and drove wonderful with lots of power. It was a great vehicle!

Vehicle information

Ext. color: Black Metallic
Int. color: Sandstne Trim Sea
Drivetrain: Four-wheel Drive
MPG: 20-27
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 2.3L I-4 gasoline direct injection, DOHC, variable valv
Stock #: BU2891
VIN: 1FMSK8FH1RGA30509

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

2024 Ford Explorer Limited review

great comfortable car.

great comfortable car. Beautiful color, excellent trim options and reasonable fuel economy. Third row seating is there if you need it otherwise plenty of room for shopping groceries

Vehicle information

Ext. color: Arctic Silver Metallic
Int. color: Black
Drivetrain: Rear-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: Manual
Engine: 3.2L I-6 DOHC, variable valve control, premium unleaded, engine
Stock #: BU2831
VIN: WBSCK9337XLC89559

Features

Convenience: Heated Seats
Exterior: Alloy Wheels
Seating: Leather Seats

Reviews

1999 BMW M Base review

1999 Z3 M Roadster Love this car!

I've owned the BMW for 6 years, and the M Roadster is the most enjoyable car I have ever driven. The 3.2L engine is BMW M rock solid, and is just a beast in such a light weight car. You take the car out for an afternoon drive and you just don't want to stop driving. The Nappa leather seats hug you like a race car, and with the top down on a sunny day all you want to do is find the next set of curves and hills, shifting through all 5 gears, a true driver's car. I would never admit to driving my M over 140 mph on an open stretch of road ;-)

Vehicle information

Ext. color: Deep Black Pearl
Int. color: Titan Black
Drivetrain: All-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: BU2920
VIN: 1V2HE2CA8SC209894

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Reviews

2025 Volkswagen Atlas Cross Sport 2.0T SE w/Technology 4MOTION review

I love this SUV very nice very comfortable and very

I love this SUV very nice very comfortable and very smooth it has all the features in it that I love everything is perfect I have no complained about it

Vehicle information

Ext. color: Alpine White
Int. color: Mocha
Drivetrain: All-wheel Drive
MPG: 26-38
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 port/direct injection, DOHC, variable valve control, inte
Stock #: BU2896
VIN: WBA23GG0XS7S55034

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Vehicle information

Ext. color: Carrara White Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 18-23
Fuel type: Gasoline
Transmission: Automatic
Engine: 3L V-6 gasoline direct injection, DOHC, variable valve control,
Stock #: B20350A
VIN: WP1AB2A57LLB35515

Features

Convenience: Heated Seats, Keyless Entry, Navigation System, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2020 Porsche Macan S review

Dr. Jeckyl - Mr. Hyde

Recently purchased the 2020 Macan GTS, so still in 'honeymoon' phase. That said, no issues to report. Pretty amazing how the vehicle can change personalities. Can be Dr. Jeckyl - smooth, quiet, refined touring car. Click a few buttons and its Mr. Hyde - growling, fast, quick steering tall hatchback that is ready for twisting roads or highway blast. Not encountered a vehicle that does this touring/sport change as well. Another standout for the 2020 is ability to go 'old school' buttons/analog - or modern digital interfaces. Like all the buttons, once you get to know them. Quick and less distraction from road. Rear seat is snug for anyone over 6 foot. Chose this over the Audi SQ5 - but it was a close contest. GTS wins on driving dynamics, but SQ5 is a wonderful luxury experience. Hard to resist the Porsche once you drive it. Does the luxury part pretty darn well too. Wow.

*Estimated payments are calculated by Cars.com and are for informational purposes only. We’ve estimated your taxes based on your provided ZIP code. These estimates do not include title, registration fees, lien fees, or any other fees that may be imposed by a governmental agency in connection with the sale and financing of the vehicle. Other taxes may apply. They do not represent a financing offer or a guarantee of credit from the seller. Actual terms vary by lender.

**Your Saved Vehicles list will be shared along with your contact information when you submit a vehicle request to a dealership. To opt out of this sharing, please view your options on Cars.com Privacy Notice.

1,915 matches Clear
Reset
Basics
Price & payment Full Price Monthly
Monthly budget search results are estimated based on a 72-month loan term with $0 down payment, $0 trade-in value, 0.0% sales tax and 7.0% APR. Inputs can be personalized using the calculator.
Financing
Deal rating
Vehicle history
Awards
Style
Body style
Vehicle size
Cab type
Exterior color
Interior color
Performance
Transmission
Drivetrain
Cylinders
Fuel type
EV range
EV charge time
Features
Convenience
Entertainment
Exterior
Safety
Seating
Door count
Seller info
Seller type
Keyword
Update
Show only

Cars under $249,972 in New Bloomfield, MO by make

Find great prices by city

Find great prices on used cars in New Bloomfield, MO

Used cars by body style and price

[{"applied_filter_criteria":"{\"cpo_indicator\":false,\"max_price_range\":249972,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"canonical_mmty":"BMW:X7:xDrive40i:2024","listing_id":"2ece784c-8e36-41bf-b69f-43932a5da538","dealer_name":"BMW of Columbia - MO","certified_preowned":true,"cat":"luxurysuv_crossover","stock_sub":"","price":"66515","trim":"xDrive40i","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":true,"sponsored_type":"standard","nvi_program":false,"model":"X7","badges":["good_deal","american_made_index_ranking","cpo"],"exterior_color":"Gray","interior_color":"Black","vin":"5UX23EM02R9U59108","year":"2024","customer_id":"152419","fuel_type":"Gasoline","photo_count":37,"stock_type":"Used","dealer_zip":"65203","cpo_package":"BMW","sponsored":true,"canonical_mmt":"BMW:X7:xDrive40i","relevancy_score":null,"make":"BMW","bodystyle":"SUV","mileage":"24831","vertical_position":1,"seller_type":"dealership"},{"canonical_mmty":"BMW:128:128i:2011","listing_id":"3559788e-2f50-43a7-b005-913925a4b93e","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"coupeconvertible_coupe","stock_sub":"","price":"7995","trim":"128i","msrp":"0","drivetrain":"Rear-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"128","badges":["great_deal"],"exterior_color":"Jet Black","interior_color":"Beige","vin":"WBAUL7C56BVJ78765","year":"2011","customer_id":"152419","fuel_type":"Gasoline","photo_count":33,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"BMW:128:128i","relevancy_score":null,"make":"BMW","bodystyle":"Convertible","mileage":"107407","vertical_position":2,"seller_type":"dealership"},{"canonical_mmty":"Kia:Soul:LX:2022","listing_id":"e48e2346-6f76-4421-947c-fcbc4790c7f0","dealer_name":"Mazda of Columbia","certified_preowned":false,"cat":"wagonhatchback_wagon","stock_sub":"","price":"13600","trim":"LX","msrp":null,"drivetrain":"Front-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Soul","badges":["good_deal","hot_car"],"exterior_color":"Steel Gray","interior_color":"Black","vin":"KNDJ23AU5N7833907","year":"2022","customer_id":"5364156","fuel_type":"Gasoline","photo_count":30,"stock_type":"Used","dealer_zip":"65202","cpo_package":null,"sponsored":false,"canonical_mmt":"Kia:Soul:LX","relevancy_score":null,"make":"Kia","bodystyle":"Hatchback","mileage":"85913","vertical_position":3,"seller_type":"dealership"},{"canonical_mmty":"Mazda:CX-30:2.5 S Select Sport:2024","listing_id":"947fcfca-3d7b-4e0f-be2f-2e875c4aef13","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"crossover_compact","stock_sub":"","price":"21997","trim":"2.5 S Select Sport","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"CX-30","badges":["good_deal"],"exterior_color":"Platinum","interior_color":"Black","vin":"3MVDMBBM1RM639773","year":"2024","customer_id":"152419","fuel_type":"Gasoline","photo_count":34,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Mazda:CX-30:2.5 S Select Sport","relevancy_score":null,"make":"Mazda","bodystyle":"SUV","mileage":"47686","vertical_position":4,"seller_type":"dealership"},{"canonical_mmty":"BMW:740:i xDrive:2025","listing_id":"aeca1377-edd1-4447-878b-de7dad255e7c","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"luxurypassenger_plus","stock_sub":"","price":"80455","trim":"i xDrive","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"740","badges":[],"exterior_color":"Black","interior_color":"Black","vin":"WBA33EH04SCU52666","year":"2025","customer_id":"152419","fuel_type":"Gasoline","photo_count":38,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"BMW:740:i xDrive","relevancy_score":null,"make":"BMW","bodystyle":"Sedan","mileage":"19608","vertical_position":5,"seller_type":"dealership"},{"canonical_mmty":"Cadillac:CT5:Premium Luxury RWD:2021","listing_id":"edff3a52-9a4f-46ce-b490-13f297f2cb69","dealer_name":"Mazda of Columbia","certified_preowned":false,"cat":"luxurypassenger_standard","stock_sub":"","price":"24700","trim":"Premium Luxury RWD","msrp":null,"drivetrain":"Rear-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"CT5","badges":["great_deal"],"exterior_color":"Dark Moon Blue Metallic","interior_color":"Maple Sugar","vin":"1G6DN5RK0M0131118","year":"2021","customer_id":"5364156","fuel_type":"Gasoline","photo_count":28,"stock_type":"Used","dealer_zip":"65202","cpo_package":null,"sponsored":false,"canonical_mmt":"Cadillac:CT5:Premium Luxury RWD","relevancy_score":null,"make":"Cadillac","bodystyle":"Sedan","mileage":"62836","vertical_position":6,"seller_type":"dealership"},{"canonical_mmty":"Jeep:Gladiator:Overland:2023","listing_id":"182612ad-2048-46a6-8477-a7048eb5b36f","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"truck_compact","stock_sub":"","price":"29175","trim":"Overland","msrp":"0","drivetrain":"Four-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Gladiator","badges":["good_deal"],"exterior_color":"Granite Crystal Metallic Clearcoat","interior_color":"Black","vin":"1C6HJTFG9PL520736","year":"2023","customer_id":"152419","fuel_type":"Gasoline","photo_count":35,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Jeep:Gladiator:Overland","relevancy_score":null,"make":"Jeep","bodystyle":"Truck","mileage":"62444","vertical_position":7,"seller_type":"dealership"},{"canonical_mmty":"Lexus:RX 450h:Base:2022","listing_id":"507e4934-50d0-4484-b56e-43ef3f7d7b6f","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"hybrid_suv","stock_sub":"","price":"38633","trim":"Base","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"RX 450h","badges":["fair_deal"],"exterior_color":"Gray Pearl","interior_color":"Black","vin":"2T2JGMDA9NC075914","year":"2022","customer_id":"152419","fuel_type":"Gasoline","photo_count":37,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Lexus:RX 450h:Base","relevancy_score":null,"make":"Lexus","bodystyle":"SUV","mileage":"78627","vertical_position":8,"seller_type":"dealership"},{"canonical_mmty":"Jeep:Grand Wagoneer L:Series II 4x4:2024","listing_id":"46477c23-d66f-4f0c-91f5-3265f0989597","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"suv_fullsize","stock_sub":"","price":"58749","trim":"Series II 4x4","msrp":"0","drivetrain":"Four-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Grand Wagoneer L","badges":["fair_deal","american_made_index_ranking","hot_car"],"exterior_color":"Silver Zynith","interior_color":"Global Black","vin":"1C4SJSFP2RS131065","year":"2024","customer_id":"152419","fuel_type":"Gasoline","photo_count":38,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Jeep:Grand Wagoneer L:Series II 4x4","relevancy_score":null,"make":"Jeep","bodystyle":"SUV","mileage":"74378","vertical_position":9,"seller_type":"dealership"},{"canonical_mmty":"BMW:M240:i:2024","listing_id":"8428db5d-2295-440a-8af7-80e9baf5e83f","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"coupeconvertible_coupesport","stock_sub":"","price":"48712","trim":"i","msrp":"0","drivetrain":"Rear-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"M240","badges":["good_deal"],"exterior_color":"Black Sapphire Metallic","interior_color":"Black","vin":"3MW43CM04R8E57897","year":"2024","customer_id":"152419","fuel_type":"Gasoline","photo_count":35,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"BMW:M240:i","relevancy_score":null,"make":"BMW","bodystyle":"Convertible","mileage":"16041","vertical_position":10,"seller_type":"dealership"},{"canonical_mmty":"Toyota:RAV4 Hybrid:XLE:2024","listing_id":"f6222a18-d0aa-49f6-b4dd-f5ae011f0712","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"hybrid_suv","stock_sub":"","price":"33199","trim":"XLE","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"RAV4 Hybrid","badges":["good_deal","hot_car"],"exterior_color":"Midnight Black Metallic","interior_color":"Black","vin":"4T3RWRFV9RU122040","year":"2024","customer_id":"152419","fuel_type":"Hybrid","photo_count":34,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Toyota:RAV4 Hybrid:XLE","relevancy_score":null,"make":"Toyota","bodystyle":"SUV","mileage":"39256","vertical_position":11,"seller_type":"dealership"},{"canonical_mmty":"Chevrolet:Trax:LT:2024","listing_id":"147b8c2f-1897-4642-b41f-7f3e60d0ff4f","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"crossover_compact","stock_sub":"","price":"21342","trim":"LT","msrp":"0","drivetrain":"Front-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Trax","badges":["good_deal","hot_car","2024_award_winner"],"exterior_color":"Sterling Gray Metallic","interior_color":"Jet Black w/Blue Accents","vin":"KL77LHE20RC228300","year":"2024","customer_id":"152419","fuel_type":"Gasoline","photo_count":32,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Chevrolet:Trax:LT","relevancy_score":null,"make":"Chevrolet","bodystyle":"SUV","mileage":"31304","vertical_position":12,"seller_type":"dealership"},{"canonical_mmty":"BMW:Z4:sDrive30i:2025","listing_id":"d7337dc0-e97e-4e8a-8d92-475b0f075364","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"coupeconvertible_convertible","stock_sub":"","price":"46758","trim":"sDrive30i","msrp":"0","drivetrain":"Rear-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Z4","badges":["good_deal"],"exterior_color":"Alpine White","interior_color":"Black","vin":"WBAHF3C01SWY41868","year":"2025","customer_id":"152419","fuel_type":"Gasoline","photo_count":32,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"BMW:Z4:sDrive30i","relevancy_score":null,"make":"BMW","bodystyle":"Convertible","mileage":"20062","vertical_position":13,"seller_type":"dealership"},{"canonical_mmty":"Honda:Passport:AWD EX-L:2022","listing_id":"d99aca2d-719a-4ea8-b7b8-4b873c104634","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"suv_midsize","stock_sub":"","price":"29062","trim":"AWD EX-L","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Passport","badges":["good_deal","american_made_index_ranking"],"exterior_color":"Crystal Black Pearl","interior_color":"Black","vin":"5FNYF8H59NB007134","year":"2022","customer_id":"152419","fuel_type":"Gasoline","photo_count":35,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Honda:Passport:AWD EX-L","relevancy_score":null,"make":"Honda","bodystyle":"SUV","mileage":"53796","vertical_position":14,"seller_type":"dealership"},{"canonical_mmty":"Ford:Escape:XLS:2007","listing_id":"4089e6fd-33ae-49e5-8692-4ee1ceec68b1","certified_preowned":false,"cat":"crossover_compact","stock_sub":"","price":"3850","trim":"XLS","msrp":null,"drivetrain":"Front-wheel Drive","cpo_indicator":false,"page_features":[],"sponsored_type":"standard","nvi_program":false,"model":"Escape","badges":[],"exterior_color":"Green","interior_color":null,"vin":"1FMYU02Z17KA51150","year":"2007","customer_id":null,"fuel_type":"Gasoline","photo_count":6,"stock_type":"Used","seller_id":"ccedf3cd-f9e4-4b80-a482-e0dd2459e925","cpo_package":null,"sponsored":false,"canonical_mmt":"Ford:Escape:XLS","relevancy_score":null,"make":"Ford","bodystyle":"SUV","mileage":"167500","vertical_position":15,"seller_type":"private"},{"canonical_mmty":"Ford:Explorer:Limited:2024","listing_id":"72720099-2640-4812-aaeb-eac3577faef9","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"suv_midsize","stock_sub":"","price":"32947","trim":"Limited","msrp":"0","drivetrain":"Four-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Explorer","badges":["great_deal","american_made_index_ranking"],"exterior_color":"Black Metallic","interior_color":"Sandstne Trim Sea","vin":"1FMSK8FH1RGA30509","year":"2024","customer_id":"152419","fuel_type":"Gasoline","photo_count":36,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Ford:Explorer:Limited","relevancy_score":null,"make":"Ford","bodystyle":"SUV","mileage":"46083","vertical_position":16,"seller_type":"dealership"},{"canonical_mmty":"BMW:M:Base:1999","listing_id":"9b4185e5-049e-4eeb-ae5f-4a22cc98abb4","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"coupeconvertible_coupesport","stock_sub":"","price":"16163","trim":"Base","msrp":"0","drivetrain":"Rear-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"M","badges":["fair_deal"],"exterior_color":"Arctic Silver Metallic","interior_color":"Black","vin":"WBSCK9337XLC89559","year":"1999","customer_id":"152419","fuel_type":"Gasoline","photo_count":34,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"BMW:M:Base","relevancy_score":null,"make":"BMW","bodystyle":"Coupe","mileage":"123151","vertical_position":17,"seller_type":"dealership"},{"canonical_mmty":"Volkswagen:Atlas Cross Sport:2.0T SE w/Technology 4MOTION:2025","listing_id":"64174dba-264b-4e55-b7a7-9032ac334ca9","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"suv_midsize","stock_sub":"","price":"37560","trim":"2.0T SE w/Technology 4MOTION","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Atlas Cross Sport","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"exterior_color":"Deep Black Pearl","interior_color":"Titan Black","vin":"1V2HE2CA8SC209894","year":"2025","customer_id":"152419","fuel_type":"Gasoline","photo_count":35,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Volkswagen:Atlas Cross Sport:2.0T SE w/Technology 4MOTION","relevancy_score":null,"make":"Volkswagen","bodystyle":"SUV","mileage":"18026","vertical_position":18,"seller_type":"dealership"},{"canonical_mmty":"BMW:228 Gran Coupe:xDrive:2025","listing_id":"41479b72-5f5b-41e5-a3f6-f2502ca37e74","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"luxurypassenger_standard","stock_sub":"","price":"39358","trim":"xDrive","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"228 Gran Coupe","badges":["good_deal"],"exterior_color":"Alpine White","interior_color":"Mocha","vin":"WBA23GG0XS7S55034","year":"2025","customer_id":"152419","fuel_type":"Gasoline","photo_count":36,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"BMW:228 Gran Coupe:xDrive","relevancy_score":null,"make":"BMW","bodystyle":"Sedan","mileage":"13808","vertical_position":19,"seller_type":"dealership"},{"canonical_mmty":"Porsche:Macan:S:2020","listing_id":"868a1120-5dd3-48db-ab17-a837a9d5c88c","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"cat":"luxurysuv_crossover","stock_sub":"","price":"37676","trim":"S","msrp":"0","drivetrain":"All-wheel Drive","cpo_indicator":false,"sponsored_type":"standard","nvi_program":false,"model":"Macan","badges":["good_deal"],"exterior_color":"Carrara White Metallic","interior_color":"Black","vin":"WP1AB2A57LLB35515","year":"2020","customer_id":"152419","fuel_type":"Gasoline","photo_count":37,"stock_type":"Used","dealer_zip":"65203","cpo_package":null,"sponsored":false,"canonical_mmt":"Porsche:Macan:S","relevancy_score":null,"make":"Porsche","bodystyle":"SUV","mileage":"46280","vertical_position":20,"seller_type":"dealership"}]}]