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,971 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: Lightning Blue
Int. color: Medium Light Stone
Drivetrain: Front-wheel Drive
MPG: 43-41
Fuel type: Hybrid
Transmission: Automatic
Engine: 2L I-4 DOHC, variable valve control, regular unleaded, engine wi
Stock #: JR122175
VIN: 3FA6P0UU4JR122175

Features

Convenience: Keyless Entry, Keyless Start, Navigation System
Entertainment: Bluetooth®, CD Player, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

Reviews

Joe Machens Volkswagen review

Better than EXCELLENT -- Not just a VW Dealer!

Mr Anthony Heaper was--is my salesman. We were doing wonderfully with a 2015 Silky Blue VW GOLF, and the car "sold" before I started to finalized my offer, and transportation situations. I live in Tulsa, and I have confidence we will buy our VW from Joe Machens via Mr. Anthony Heaper. Anthony is not pushy, very polite, and helpful. Only down side to buy from Joe, is I live in Tulsa. No way to take advantage of the LOCAL Dealership "FREEBIES." Believe the end price will make it all worth while. ~`~`~` PS: I have visited the local VW dealer, and they were not too friendly.

2018 Ford Fusion Hybrid S review

The Ford Fusion was a modest priced sedan, low

The Ford Fusion was a modest priced sedan, low maintenance, great mileage and the hybrids are so smooth compared to all the other brands. I've own 6 of them since 2010. When Ford stopped making the Fusion after 2020 and decided to give away their sedan line, the copy cat models of Hyundai and Toyota both increased sales in the 20% range. Gas, oil and little electricity for the plug-in and these near maintenance free cars just go and go. I've put as much as 165,000 on them without issue.

Vehicle information

Ext. color: Gray Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 18-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 gasoline direct injection, i-VTEC variable valve contro
Stock #: SB010520
VIN: 5FPYK3F89SB010520

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Bluetooth®, HomeLink, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Moonroof, Tow Hitch
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

Joe Machens Capital City Ford review

Happy,happy customers

Christian was our salesman and is a great one he above and beyond to help us with our special needs a great guy sold us a great Suv, our next vehicle will be sold to us be Christian. THANK YOU SIR.

2025 Honda Ridgeline Black review

I started my truck search looking at full-size trucks,

I started my truck search looking at full-size trucks, but honestly didn’t want the exterior size to be that big. Just on a side, have you noticed how a lot of the worst drivers on the road are driving the big full-size trucks? I didn’t know the purpose of having a Hemi to actually run people off the road. You know what I mean? That dude is barreling down the interstate doing about 87mph pulling a big @$$ box trailer and he’s like fish tailing all over the place? Anywho, back to the review... I drove a Jeep Gladiator, a Tacoma, a Colorado and the Nissan Frontier. The Gladiator was almost scary on the highway. Lots of wind noise and blowing me all over the place even at the lower highway speeds around 55-60mpg. For that reason, it didn’t make sense to me as a daily driver on paved roads. While the new Colorado and Tacoma have that brawny stance, neither of them have a V6. What’s the deal with the 4 banger turbo thing? It’s like Arnold Schwarzenegger in that old Christmas movie, “Jingle All The Way.” “I have to get the “Turbo Man!!” What they are not telling you about the 4 cylinder turbo stuff is that even if a 4 cylinder engine has the power of Ivan Drago in Rocky 4, it is working harder to produce that power compared to the naturally aspirated V6. Multiple mechanics I know personally have said the same thing. Inside, both Tac and Colorado were small and cramped. At first glance, you think they are going to be bigger inside than they are. This was disappointing and strange given how the outside is larger than the prior generations of those two trucks. An odd tech. thing about the Colorado was that you actually turn the headlights on using the touch screen. I also thought that the inside materials in the Colorado felt cheap. That glossy plastic stuff if you know what I mean. I liked the tow rating, but decided to keep shopping. The Frontier was actually my second favorite truck behind the Ridgeline. The naturally aspirated V6 instead of the turbo was already setting it above the other trucks. Then, I drove the Ridgeline and it was like Wow!! This thing rocks!! Honda’s proven reliable V6, smooth driving, yet flexible enough on the dirt or gravel roads, I can fit a 4x8 sheet of plywood flat in the bed because there’s no stupid wheel well hump. I absolutely love the tailgate swing out! It gets my body closer to whatever goods I am lifting out of the back instead of having to lean forward. Honda nailed it with this feature! Plus, let me just say that Ridgeline’s interior almost feels like a full size truck. I have tall teenage boys and the first thing they said when they got in the Ridgeline was “Wow dad!! This is nice and big inside!” Plus, as roomy as it is, I like that Ridgeline fits in a standard garage space too! If you get heavy rains, or it happens to snow, it’s nice to be covered when you want to be. You’ve got drive settings for different terrain and that suits my needs. Another reviewer said the Ridgeline meets the needs of 80% of people driving trucks and he nailed it with that statement. it’s absolutely true. A lot of people are driving big trucks and Jeeps and they never actually use them for the purpose they are intended for. You have those folks that don’t actually need 4 wheel drive. If you’re like me, you want a truck that gives you the utility you need, want to grab some landcape supplies, sheet goods, farm or garden stuff, and rides awesome on both paved and gravel or dirt roads, this is the truck for you. Don’t you love these guys with Jeep fantasies that make stupid videos criticizing Honda trying to create skepticism like…. “Can it do any serious off roading?” You can’t criticize it for something it’s not designed for. If you want a rock crawler you get a Jeep or something similar (locking differential, higher ground clearance, a lift, bigger rubber etc,).

Vehicle information

Ext. color: Polar White
Int. color: Bahia Brown/Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 3L I-6 gasoline direct injection, DOHC, variable valve control,
Stock #: MU8128
VIN: 4JGFF5KE0RB184397

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®, HomeLink, Premium Sound System, 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

Reviews

Mercedes-Benz of Columbia review

Best place to go if your looking for a used car.

Had a wonderful experience. Key'n was a great help with helping us find the car we wanted. Would recommend him to anyone buying a car.

2024 Mercedes-Benz GLS 450 4MATIC review

Great SUV

My 2 honest cents. Just bought the 2024 GLS 450 and it has a huge presence on road and it looks stunning! I went with the AMG exterior package and it looks way better than the base model. Ride quality is good, very smooth ride on freeways but you do feel small bumps on occasional city roads. The engine is good but I wish it had a bit more power, feels little laggy at low speeds but when you floor it it moves fast and steering is very responsive. On the other hand, cabin very silent tho and you barely get to hear road noise (without acoustic package). The Mileage is incredible on this, wasn't expecting to write about it but the GLS gives better mileage than my GLC. Interiors are amazing and is something no other manufacturer in this segment can match (especially at night with ambient lights), seats are super comfy and the infotainment screens are also crisp. Overall, love this SUV and i'm gonna keep it for a while.

Vehicle information

Ext. color: Cosmos Black Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 25-33
Fuel type: Gasoline
Transmission: 8-Speed Automatic with Auto-Shift
Engine: 2.0L I4 16V GDI DOHC Turbo
Stock #: SJ638652
VIN: W1N4N4HB1SJ638652

Features

Convenience: Keyless Entry, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

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!

2025 Mercedes-Benz GLA 250 Base 4MATIC review

I am supper excited to enjoy the drive, I love it so

I am supper excited to enjoy the drive, I love it so much! I want to thank the best sale person Albert in Massapequa, NY for showing me my newest 2025 GLA 25, AMG Package Sport Drive. I would recommend everyone. Great Support !!!

Vehicle information

Ext. color: Red
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 30-38
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 1.4L I4 16V MPFI DOHC
Stock #: KC765553
VIN: KL8CB6SA3KC765553

Features

Entertainment: Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port
Safety: Backup Camera, Brake Assist, Stability Control

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!

2019 Chevrolet Spark LS review

I purchased my Spark new, June 2019.

I purchased my Spark new, June 2019. I love this car! It is now, one month before 6 yrs of owning my Spark. It has less than 10,900 miles on it. This car has great maneuverability, gets great gas mileage, and I love the Hot Red body color. The only thing I've had to replace, in almost 6 yrs, is the battery. And that was just a few months ago during freezing weather. It gets regular oil changes and maintenance checks. The 2019 Chevy Spark is one great little car for the money.

Vehicle information

Ext. color: White Frost Tricoat
Int. color: Ebony With Ebony Interior Accents
Drivetrain: Front-wheel Drive
MPG: 29-32
Fuel type: Gasoline
Transmission: Automatic
Engine: ECOTEC 1.3L I-3 gasoline direct injection, DOHC, variable valve
Stock #: PB086841
VIN: KL4MMDSL5PB086841

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, Stability Control
Seating: Leather Seats

Reviews

Joe Machens Volkswagen review

Great Service Center

Excellent facilities and staff who treat you like you're the most important customer, regardless of how much you're spending in the service department. Quick, efficient check-in and check-out, and they make it clear that they want you to leave satisfied. Nice waiting area as well.

2023 Buick Encore GX Select review

The hidden gem Buick Encore GX

I know that here in Northern California, Buick isn't a very popular brand, but that means I was able to get a stunningly good deal on my new '23. I traded up from a low mileage '18 Buick Encore (not GX), and at the time of the transaction, it had a remarkable trade value. My dealer did a outstanding job on pre-sale prep and delivery. My sales rep answered my every question. I enjoyed the prior vehicle, and feel this new one will give me the same kind of driving experience. My added safety feature is the front accident/pedestrian avoidance and lane keep assist. I haven't had to use either yet, but feel good about having them aboard. This Buick strikes me as a hidden gem, full featured but still available at a price point that blows the other comparable Asian built imports out of the water.

Vehicle information

Ext. color: Jet Black Mica
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 23-28
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.3L I6 24V GDI DOHC Turbo
Stock #: S1218035
VIN: JM3KKDHC4S1218035

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Power Liftgate
Entertainment: Bluetooth®, HomeLink, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

Mazda of Columbia review

lartiquefreeman2206@yahoo.com

it was good yall always make sure my call is services.

2025 Mazda CX-90 3.3 Turbo S Premium Package review

5 Stars ⭐⭐⭐⭐⭐ – Outstanding Service & Amazing CX-90 from

5 Stars ⭐⭐⭐⭐⭐ – Outstanding Service & Amazing CX-90 from Mazda of Orland Park! We recently purchased the 2025 Mazda CX-90 AWD from Mazda of Orland Park, and We couldn’t be more pleased with the entire experience. From start to finish, the service was exceptional — professional, smooth, and stress-free. A special thank you to Chris Duer, who went above and beyond throughout the process. Chris was knowledgeable, transparent, and genuinely committed to helping us find the right vehicle. He made sure every detail was covered, took the time to answer all our questions, and made us feel confident in our purchase from the moment we walked in. The CX-90 AWD is a phenomenal SUV — powerful, luxurious, and equipped with all the latest tech and safety features. It drives like a dream and checks every box I had for comfort, performance, and design. The entire team at Mazda of Orland Park made the buying process seamless, from financing to delivery. Chris ensured we were fully comfortable with every step and that we left knowing how to get the most out of my new Mazda. If you're in the market for a vehicle and want a dealership that values honesty, quality service, and customer care — ask for Chris Duer at Mazda of Orland Park. You won’t be disappointed!

Vehicle information

Ext. color: Performance Red Pearl
Int. color: Ebony
Drivetrain: Front-wheel Drive
MPG: 29-36
Fuel type: Gasoline
Transmission: Automatic
Engine: 1.5L I-4 gasoline direct injection, DOHC, VTEC variable valve co
Stock #: MU8134A
VIN: 19UDE4H69PA014570

Features

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

Reviews

Mercedes-Benz of Columbia review

Great, affordable dealership! Key'n is the best!

Great experience here! I highly recommend requesting to work with Key'n Brosdahl. He works hard to find you the best deal and is so fun to be around! He was patient and very knowledgeable about the different vehicles on the lot. He works hard for you to find exactly what you're looking for. Love my new car! Scott in finances was great as well. He went above and beyond to help us! Thanks Preowned!

2023 Acura Integra A-SPEC Technology review

This car is amazing but if you like music you are going

This car is amazing but if you like music you are going to have a lot of problems with its audio system. Who ever Acura let do the audio system needs to never do it again. Audio system doesn’t even last for more than a year

Vehicle information

Ext. color: Satin Steel Metallic
Int. color: Jet Black/Kalahari
Drivetrain: Four-wheel Drive
MPG: 17-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.6L V-6 gasoline direct injection, DOHC, variable valve control
Stock #: N1313150
VIN: 1GTG6FEN7N1313150

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Backup Camera, Stability Control
Seating: Leather Seats

Reviews

Joe Machens Volkswagen review

GREAT SERVICE!

Mike Stock, the parts manager is top notch. He goes out of his way to go above and beyond for the customer. A real professional.

2022 GMC Canyon AT4 review

Diesel AT4 it!

GMC Diesel Canyon AT4. I've had this truck for a year-11,000 miles. I love it. The Denali and Elevation trim looked like junk. The AT4 can't compete with the Tacoma off road but, It holds it's own off road. The Diesel pulls like a beast and the exhuast brake, on all the moutain passes I drive, is worth it's wieght in Gold. I trailer the max. capacity regularly and it's smooth sailing. I traded in my 2500HD Silverado with the vortec 6.0 for this big, little truck. Best decision I've made in a while. I had this truck on order for 8 months and Gm never accepted the order. I finally found exactly what I ordered, just off the truck that morning that I called. 1300 miles away, I jumped on a plane to go get it. Crying shame GMC discontinued the diesel. The extra $ per gallon right now is easily washed by the increase in mileage, 32+ higway, 19 trallering almost 8000 #'s. I wouldn't want the truck without it. Wouldn't want the Elevation or Denali. Diesel AT4 is the truck. I'll keep it the rest of my life barring accident. I'm sure I can get 40 years out of this truck doing 10-12k a year. The regeneration of the exhaust has never come up but, I only do a little round town driving. Most of my miles are highway and hauling a load. I've heard horror stories about regen. from city folk, commuters... You get what you aim for. If you've given it a lot of thought and the diesel AT4 seems right for you, you won't be disappointed. Good luck finding one. GM - You've a winner here. don't let it get away. Ps. Cars.com doesn't have a choice of how I use this truck for WORK. And wouldn't let me submit this review without selecting one of thier 3 inadequate choices. So, I selected having fun cause I believe everything should be but, this is my WORK TRUCK!

Vehicle information

Ext. color: Granite Crystal Clearcoat Metallic
Int. color: Black / Red
Drivetrain: Front-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: 4-Speed Automatic
Engine: 2.4L I4 16V MPFI DOHC
Stock #: 186640A
VIN: 3C4PDCAB5GT246236

Features

Convenience: Keyless Entry, Keyless Start
Entertainment: CD Player, USB Port
Exterior: Roof Rack
Safety: Brake Assist, Stability Control

Reviews

Jim Butler Linn Chevrolet review

rleeperrjl@yahoo.com

Great customer service Always clean facilities I purchased my car there in 2018 and have been having it serviced there ever since

2016 Dodge Journey SE review

Extra reliable & roomy.

I've owned the 2016 Dodge Journey SXT 3.6L V6 AWD SUV, since April 2017. Purchased with approximately 10k miles, this vehicle has been nothing but a pleasure to drive & own. I've had zero mechanical issues beyond regular maintenance (new tires, oil changes/scheduled manufacturer service, basic upkeep). I worked between Charlotte & NYC for more than 4 years, driving each way every 6-8 weeks and the car has had no problems at all. Super reliable with extra seating & massive cargo space. I now have 74k miles & still no major issues.

Vehicle information

Ext. color: Selenite Gray Metallic
Int. color: Bahia Brown/Black
Drivetrain: All-wheel Drive
MPG: 14-20
Fuel type: Gasoline
Transmission: Automatic
Engine: 4L V-8 gasoline direct injection, DOHC, variable valve control,
Stock #: MU8129
VIN: 4JGFF8FE9RB144816

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®, HomeLink, Premium Sound System, 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

Reviews

Mercedes-Benz of Columbia review

I highly recommend Mercedes-Benz of Columbia

I usually do not do reviews, but these guys at Mercedes-Benz of Columbia absolutely deserves more than a 5 star review. Danh Do Finance Manage, and Kofi's Adadey who happened to be my sales person were amazing. Their customer service and lever of customer engagement is "Bar None"!!!!. The environment and atmosphere is very inviting and relaxing. From the Car lot, to the Sales floor, everyone is very helpful and polite. They make you feel like family. Mercedes-Benz of Columbia is the best dealership in the Mid-West they surpasses my expectation. Therefore I will be a repeat customer, because I am a satisfied customer.

Vehicle information

Ext. color: White Platinum Clearcoat Metallic
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 23-30
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.0L I4 16V GDI DOHC Turbo
Stock #: HUB40648
VIN: 1FMCU0J96HUB40648

Features

Convenience: Heated Seats, Keyless Entry, Power Liftgate, Remote Start
Entertainment: Bluetooth®, CD Player, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Roof Rack
Safety: Backup Camera, Brake Assist, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2017 Ford Escape Titanium review

Great vehicle!!

This vehicle has been awesome from the day I first started driving it. Great on gas, engine is very responsive and reliable. A/C is very cold and the starts so nicely every time. The engine has all the power you would ever need. This one is a 2.0 Turbo. I have kept this car serviced regularly and it has performed flawlessly.

Vehicle information

Ext. color: Snowflake White Pearl Mica
Int. color: Tan
Drivetrain: Rear-wheel Drive
MPG: 26-35
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.0L I4 16V GDI DOHC
Stock #: S0650252
VIN: JM1NDAM76S0650252

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Navigation System
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, Satellite Radio, USB Port
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Reviews

Mazda of Columbia review

Upgraded review from 10/10

Quoting review I am retracting first, as the dealership solved the issues pleasantly and professionally,”My wife and I purchased a 2019 Ford Edge from this dealership on 10/10/22. Our salesman was Glenn Gannaway. After coming to an agreement on the purchase of the vehicle, we had filled out a form for requests to be completed as part of the deal. One request was to repair or replace the damaged headliner. Secondly, Glenn told us he would get us the second of the pair of key fobs. Thirdly, we requested a bottle of touch up paint to take care of small nicks in the exterior paint. Now three weeks later, we are still waiting for these requests to be taken care of by this dealership.” The updated review is a five star review “We purchased a 2019 Ford Edge Titanium from this dealership on 11/10/22. We traded in our Ford Escape and our F-150 on this vehicle to have lower payment and more comforts. The deal went well with Glenn Gannaway as our salesman and Josh Woodruff taking care of the finances. Josh did an excellent job with our financing and made sure that we were able to get a refund on our unused Ford warranty balance. They gave us a fair trade on both of our vehicles and a reasonable price on our Ford Edge. There were a couple of items that had to be taken care of after the sale on the we owe sheet. The headliner had some damage and there was a few small paint chips and only one key fob with the Edge. The dealership has provided touch up paint for the chips and purchased a second key fob for us. They had repairs made to the headliner, and although it doesn’t look brand new, it is acceptable and hardly noticeable. The experience, although time consuming has ended on a good note and I would recommend buying a new or used vehicle from the Machens Auto Group.”

Vehicle information

Ext. color: Magnetic
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 19-27
Fuel type: Gasoline
Transmission: Automatic
Engine: Duratec 2.5L I-4 DOHC, iVCT variable valve control, regular unle
Stock #: H1295134
VIN: NM0GE9E76H1295134

Features

Convenience: Keyless Entry
Entertainment: CD Player
Safety: Automatic Emergency Braking, Brake Assist, Stability Control
Seating: Third Row Seating

Reviews

Joe Machens Volkswagen review

Great to work with!

Jeremy Bealmer and Machens Volkswagen was great to work with and extremely responsive as I purchased my vehicle out of town. Second purchase from Machens did not disappoint!

2017 Ford Transit Connect XL w/Rear Liftgate review

Very comfortable and practical van

This car exceeds all expectations. It gets amazing gas mileage and provides ample power considering its 4 cylinder engine. I would recommend this vehicle to anyone who is operating a small business.

Vehicle information

Ext. color: Cirrus Silver Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 15-19
Fuel type: Gasoline
Transmission: Automatic
Engine: AMG 4L V-8 gasoline direct injection, DOHC, variable valve contr
Stock #: MU8080A
VIN: 4JGFB8KB1RB247901

Features

Convenience: Cooled Seats, Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, 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

Mercedes-Benz of Columbia review

Absolutely amazing experience for a first time New

Absolutely amazing experience for a first time New Mercedes owner. Impressive and impeccable service by the team of Mercedes-Benz of Columbia, MO. Thank you all.

Vehicle information

Ext. color: Satin Steel Metallic
Int. color: Jet Black
Drivetrain: All-wheel Drive
MPG: 21-27
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 3.6L V6 24V GDI DOHC
Stock #: 718630A
VIN: 1GKKNRLS7LZ148291

Features

Convenience: Keyless Entry, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Rear Cross Traffic Alert, Stability Control
Seating: Third Row Seating

Reviews

Jim Butler Linn Chevrolet review

We were very happy with the sales and the whole

We were very happy with the sales and the whole experience. It did not take long and we were on our way with the truck. Shane Backues called to make sure we got home safely. How nice of him to think of us. Thanks Russ

2020 GMC Acadia SLE review

GMC Acadia good family or commuter car

Bought a demo car . The Acadia has been great . Wife’s car . She likes it . Roomy and good gas mileage . Would also make a great road trip vehicle if I didn’t have a full size Ram .

Vehicle information

Ext. color: Northsky Blue Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 16-18
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.7L I4 16V GDI DOHC Turbo
Stock #: NG147373
VIN: 3GCPYCEK7NG147373

Features

Convenience: Keyless Entry, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio, USB Port
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

Vehicle information

Ext. color: Oxford White
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 42-38
Fuel type: Hybrid
Transmission: Automatic
Engine: 2L I-4 DOHC, Ti-VCT variable valve control, regular unleaded, en
Stock #: HL114767
VIN: 1FADP5AU9HL114767

Features

Convenience: Keyless Entry
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

Reviews

Joe Machens Volkswagen review

Simply the Best

I had looked everywhere for a 2021 Cross Sport with Black/Burgundy interior. They had 2 even though I'm in Colorado, they made it so easy, they are bringing the vehicle 700 miles to me and picking up my trade Bruce is Awesome!

2017 Ford C-Max Hybrid SE review

Great for work and family.

This is my first hybrid and is also my first Ford. In the past I've had many cars including an indestructible Honda Civic. This review will "compare" with the Civic because the Civic left the biggest impression on us for great reliability and cheap parts. The reason I gave the review 4 stars for reliability is because I had a minor coolant leak (a rusted hose clamp) and Ford charged me $250 to fix the hose clamp. I never had any problems with the Civic we used to have and if we did it was ultra cheap to fix it. Besides the minor problem the Ford C-Max has been great!!! I absolutely Love the high ceiling in the C-max. My head has plenty of room and I'm 6 feet tall. Much more room than the Civic. The Civic had 140hp and this Ford has 188hp, so its much faster than the civic! Also, The C-max costs me $35 in gas every TWO weeks!!! The last two cars I had I was spending $25-40 in gas in one week! So its faster, better gas mileage and more spacious and roomy than pretty much any car I've had lately. So far my experience with my first ford is very good. I like the style, the space inside and the comfort. I got the SE model instead of the Titanium so it doesn't have some bells and whistles. Overall I really enjoy the C-Max. I'm one of the very few people who thinks it looks cool. As for my future purchases... Ford is now on my radar!

Vehicle information

Ext. color: Matador Red Metallic
Int. color: Atlas Beige
Drivetrain: All-wheel Drive
MPG: 24-34
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: JN003487
VIN: WAUYNGF5XJN003487

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, DVD Player, HomeLink, Premium Sound System, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2018 Audi A5 2.0T Premium Plus review

7th Audi

2021 a5 PREM Plus; B&O 7th audi I've owned & they just keep getting better. Not a fan of the tap every time screen I want to do something feature which is fairly new. This one could be a keeper! The stereo is very high quality & handling rocks, quick & nimble. Sport suspension is a personal choice, always order it. Stiffer but smooth. Car is quite. Sport seats heated, heated mirrors, heated steering wheel. Need I say more?

Vehicle information

Ext. color: Gravity Gray
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 23-26
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 port/direct injection, DOHC, CVVT variable valve contro
Stock #: R7293629
VIN: KNDPUCDF9R7293629

Features

Convenience: Heated Seats, Keyless Entry
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control

Reviews

Columbia Honda review

Great Experience

I Bought a new car there and didn't even have to come to the dealer. They were very helpful. I Would definitely do business there again.

2024 Kia Sportage LX review

Great customer service.

Great customer service. My Kia Sportage drives very comfortably. Love the heated seats. Great for carrying large items cause you can put the back seats down.

*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,971 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":[{"listing_id":"79120f35-1554-4f2a-8151-8792f0728174","bodystyle":"Sedan","certified_preowned":false,"mileage":"49911","stock_type":"Used","trim":"S","exterior_color":"Lightning Blue","drivetrain":"Front-wheel Drive","cat":"hybrid_passenger","seller_type":"dealership","relevancy_score":null,"price":"15126","nvi_program":false,"msrp":"0","sponsored":false,"year":"2018","customer_id":"5364038","interior_color":"Medium Light Stone","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Ford:Fusion Hybrid:S","vertical_position":1,"vin":"3FA6P0UU4JR122175","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","good_deal"],"make":"Ford","fuel_type":"Hybrid","canonical_mmty":"Ford:Fusion Hybrid:S:2018","dealer_name":"Joe Machens Volkswagen","photo_count":45,"model":"Fusion Hybrid"},{"listing_id":"c48ed35d-3d21-44ca-8e5b-be2bf26534aa","bodystyle":"Truck","certified_preowned":true,"mileage":"29134","stock_type":"Used","trim":"Black","exterior_color":"Gray Pearl","drivetrain":"All-wheel Drive","cat":"truck_compact","seller_type":"dealership","relevancy_score":null,"price":"37500","nvi_program":false,"msrp":"0","sponsored":true,"year":"2025","customer_id":"5363977","interior_color":"Black","stock_sub":"","dealer_zip":"65109","canonical_mmt":"Honda:Ridgeline:Black","vertical_position":2,"vin":"5FPYK3F89SB010520","cpo_indicator":true,"sponsored_type":"standard","cpo_package":"Ford Blue Advantage Blue","badges":["great_deal","american_made_index_ranking","cpo"],"make":"Honda","fuel_type":"Gasoline","canonical_mmty":"Honda:Ridgeline:Black:2025","dealer_name":"Joe Machens Capital City Ford","photo_count":26,"model":"Ridgeline"},{"listing_id":"4713e30d-0a1e-4109-8095-0410b4fe2df6","bodystyle":"SUV","certified_preowned":true,"mileage":"6543","stock_type":"Used","trim":"4MATIC","exterior_color":"Polar White","drivetrain":"All-wheel Drive","cat":"luxurysuv_crossover","seller_type":"dealership","relevancy_score":null,"price":"79738","nvi_program":false,"msrp":"0","sponsored":true,"year":"2024","customer_id":"5243424","interior_color":"Bahia Brown/Black","stock_sub":"","dealer_zip":"65203","canonical_mmt":"Mercedes-Benz:GLS 450:4MATIC","vertical_position":3,"vin":"4JGFF5KE0RB184397","cpo_indicator":true,"sponsored_type":"standard","cpo_package":"Mercedes-Benz","badges":["price_drop_in_cents","good_deal","american_made_index_ranking","cpo"],"make":"Mercedes-Benz","fuel_type":"Gasoline","canonical_mmty":"Mercedes-Benz:GLS 450:4MATIC:2024","dealer_name":"Mercedes-Benz of Columbia","photo_count":37,"model":"GLS 450"},{"listing_id":"402f3945-d9a4-45cc-ba0f-c91f557a98d1","bodystyle":"SUV","certified_preowned":false,"mileage":"38248","stock_type":"Used","trim":"Base 4MATIC","exterior_color":"Cosmos Black Metallic","drivetrain":"All-wheel Drive","cat":"luxurysuv_crossover","seller_type":"dealership","relevancy_score":null,"price":"33900","nvi_program":false,"msrp":null,"sponsored":false,"year":"2025","customer_id":"5364156","interior_color":"Black","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Mercedes-Benz:GLA 250:Base 4MATIC","vertical_position":4,"vin":"W1N4N4HB1SJ638652","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","great_deal"],"make":"Mercedes-Benz","fuel_type":"Gasoline","canonical_mmty":"Mercedes-Benz:GLA 250:Base 4MATIC:2025","dealer_name":"Mazda of Columbia","photo_count":27,"model":"GLA 250"},{"listing_id":"e575d058-502b-4c91-8382-d34f8b0e80e6","bodystyle":"Hatchback","certified_preowned":false,"mileage":"72781","stock_type":"Used","trim":"LS","exterior_color":"Red","drivetrain":"Front-wheel Drive","cat":"wagonhatchback_hatchback","seller_type":"dealership","relevancy_score":null,"price":"9700","nvi_program":false,"msrp":null,"sponsored":false,"year":"2019","customer_id":"5364156","interior_color":"Black","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Chevrolet:Spark:LS","vertical_position":5,"vin":"KL8CB6SA3KC765553","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","good_deal","hot_car"],"make":"Chevrolet","fuel_type":"Gasoline","canonical_mmty":"Chevrolet:Spark:LS:2019","dealer_name":"Mazda of Columbia","photo_count":27,"model":"Spark"},{"listing_id":"93fe2858-b6a6-440f-be85-535a360f4dbc","bodystyle":"SUV","certified_preowned":false,"mileage":"14290","stock_type":"Used","trim":"Select","exterior_color":"White Frost Tricoat","drivetrain":"Front-wheel Drive","cat":"luxurysuv_crossover","seller_type":"dealership","relevancy_score":null,"price":"22817","nvi_program":false,"msrp":"0","sponsored":false,"year":"2023","customer_id":"5364038","interior_color":"Ebony With Ebony Interior Accents","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Buick:Encore GX:Select","vertical_position":6,"vin":"KL4MMDSL5PB086841","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","good_deal"],"make":"Buick","fuel_type":"Gasoline","canonical_mmty":"Buick:Encore GX:Select:2023","dealer_name":"Joe Machens Volkswagen","photo_count":49,"model":"Encore GX"},{"listing_id":"8e0ed8b8-4cdf-49d2-a222-30cd4f54d463","bodystyle":"SUV","certified_preowned":false,"mileage":"4197","stock_type":"Used","trim":"3.3 Turbo S Premium Package","exterior_color":"Jet Black Mica","drivetrain":"All-wheel Drive","cat":"suv_fullsize","seller_type":"dealership","relevancy_score":null,"price":"44800","nvi_program":false,"msrp":null,"sponsored":false,"year":"2025","customer_id":"5364156","interior_color":"Black","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Mazda:CX-90:3.3 Turbo S Premium Package","vertical_position":7,"vin":"JM3KKDHC4S1218035","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","great_deal","hot_car"],"make":"Mazda","fuel_type":"Gasoline","canonical_mmty":"Mazda:CX-90:3.3 Turbo S Premium Package:2025","dealer_name":"Mazda of Columbia","photo_count":30,"model":"CX-90"},{"listing_id":"328f7a52-7745-4ad8-a2f4-686f76eb0e3f","bodystyle":"Hatchback","certified_preowned":false,"mileage":"52797","stock_type":"Used","trim":"A-SPEC Technology","exterior_color":"Performance Red Pearl","drivetrain":"Front-wheel Drive","cat":"sedan_compact","seller_type":"dealership","relevancy_score":null,"price":"26613","nvi_program":false,"msrp":"0","sponsored":false,"year":"2023","customer_id":"5243424","interior_color":"Ebony","stock_sub":"","dealer_zip":"65203","canonical_mmt":"Acura:Integra:A-SPEC Technology","vertical_position":8,"vin":"19UDE4H69PA014570","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["good_deal"],"make":"Acura","fuel_type":"Gasoline","canonical_mmty":"Acura:Integra:A-SPEC Technology:2023","dealer_name":"Mercedes-Benz of Columbia","photo_count":36,"model":"Integra"},{"listing_id":"d3330095-e159-44c6-9a28-f5be626b0398","bodystyle":"Truck","certified_preowned":false,"mileage":"42716","stock_type":"Used","trim":"AT4","exterior_color":"Satin Steel Metallic","drivetrain":"Four-wheel Drive","cat":"truck_compact","seller_type":"dealership","relevancy_score":null,"price":"33900","nvi_program":false,"msrp":"0","sponsored":false,"year":"2022","customer_id":"5364038","interior_color":"Jet Black/Kalahari","stock_sub":"","dealer_zip":"65202","canonical_mmt":"GMC:Canyon:AT4","vertical_position":9,"vin":"1GTG6FEN7N1313150","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["good_deal"],"make":"GMC","fuel_type":"Gasoline","canonical_mmty":"GMC:Canyon:AT4:2022","dealer_name":"Joe Machens Volkswagen","photo_count":6,"model":"Canyon"},{"listing_id":"00a85209-4fef-430d-98bf-1de52e60b990","bodystyle":"SUV","certified_preowned":false,"mileage":"91038","stock_type":"Used","trim":"SE","exterior_color":"Granite Crystal Clearcoat Metallic","drivetrain":"Front-wheel Drive","cat":"crossover_compact","seller_type":"dealership","relevancy_score":null,"price":"9943","nvi_program":false,"msrp":null,"sponsored":false,"year":"2016","customer_id":"5363686","interior_color":"Black / Red","stock_sub":"","dealer_zip":"65051","canonical_mmt":"Dodge:Journey:SE","vertical_position":10,"vin":"3C4PDCAB5GT246236","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["good_deal","hot_car"],"make":"Dodge","fuel_type":"Gasoline","canonical_mmty":"Dodge:Journey:SE:2016","dealer_name":"Jim Butler Linn Chevrolet","photo_count":29,"model":"Journey"},{"listing_id":"4a1ed298-f991-460a-8009-e1ebc20b77a9","bodystyle":"SUV","certified_preowned":false,"mileage":"5961","stock_type":"Used","trim":"4MATIC","exterior_color":"Selenite Gray Metallic","drivetrain":"All-wheel Drive","cat":"luxurysuv_crossover","seller_type":"dealership","relevancy_score":null,"price":"90588","nvi_program":false,"msrp":"0","sponsored":false,"year":"2024","customer_id":"5243424","interior_color":"Bahia Brown/Black","stock_sub":"","dealer_zip":"65203","canonical_mmt":"Mercedes-Benz:GLS 580:4MATIC","vertical_position":11,"vin":"4JGFF8FE9RB144816","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","good_deal"],"make":"Mercedes-Benz","fuel_type":"Gasoline","canonical_mmty":"Mercedes-Benz:GLS 580:4MATIC:2024","dealer_name":"Mercedes-Benz of Columbia","photo_count":38,"model":"GLS 580"},{"listing_id":"ec980164-a53e-4240-a0cb-56e8a1027a14","bodystyle":"SUV","certified_preowned":false,"mileage":"94494","stock_type":"Used","trim":"Titanium","exterior_color":"White Platinum Clearcoat Metallic","drivetrain":"Front-wheel Drive","cat":"crossover_compact","seller_type":"dealership","relevancy_score":null,"price":"12821","nvi_program":false,"msrp":null,"sponsored":false,"year":"2017","customer_id":"6039707","interior_color":"Black","stock_sub":"","dealer_zip":"65203","canonical_mmt":"Ford:Escape:Titanium","vertical_position":12,"vin":"1FMCU0J96HUB40648","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["great_deal"],"make":"Ford","fuel_type":"Gasoline","canonical_mmty":"Ford:Escape:Titanium:2017","dealer_name":"Joe Machens Ford","photo_count":29,"model":"Escape"},{"listing_id":"678e23c4-d524-4de8-a4af-bc6a6dd3d6fe","bodystyle":"Convertible","certified_preowned":false,"mileage":"6504","stock_type":"Used","trim":"Grand Touring","exterior_color":"Snowflake White Pearl Mica","drivetrain":"Rear-wheel Drive","cat":"coupeconvertible_coupe","seller_type":"dealership","relevancy_score":null,"price":"33500","nvi_program":false,"msrp":null,"sponsored":false,"year":"2025","customer_id":"5364156","interior_color":"Tan","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Mazda:MX-5 Miata RF:Grand Touring","vertical_position":13,"vin":"JM1NDAM76S0650252","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["good_deal"],"make":"Mazda","fuel_type":"Gasoline","canonical_mmty":"Mazda:MX-5 Miata RF:Grand Touring:2025","dealer_name":"Mazda of Columbia","photo_count":28,"model":"MX-5 Miata RF"},{"listing_id":"c8d05c2e-5650-4815-9c28-0a4814c562c3","bodystyle":"SUV","certified_preowned":false,"mileage":"37655","stock_type":"Used","trim":"XL w/Rear Liftgate","exterior_color":"Magnetic","drivetrain":"Front-wheel Drive","cat":"van_fullsize","seller_type":"dealership","relevancy_score":null,"price":"17521","nvi_program":false,"msrp":"0","sponsored":false,"year":"2017","customer_id":"5364038","interior_color":"Black","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Ford:Transit Connect:XL w/Rear Liftgate","vertical_position":14,"vin":"NM0GE9E76H1295134","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","good_deal"],"make":"Ford","fuel_type":"Gasoline","canonical_mmty":"Ford:Transit Connect:XL w/Rear Liftgate:2017","dealer_name":"Joe Machens Volkswagen","photo_count":48,"model":"Transit Connect"},{"listing_id":"aaeef3f4-b0be-4e62-849c-7ca308f9fe06","bodystyle":"SUV","certified_preowned":false,"mileage":"5966","stock_type":"Used","trim":"S 4MATIC+","exterior_color":"Cirrus Silver Metallic","drivetrain":"All-wheel Drive","cat":"luxurysuv_crossover","seller_type":"dealership","relevancy_score":null,"price":"101457","nvi_program":false,"msrp":"0","sponsored":false,"year":"2024","customer_id":"5243424","interior_color":"Black","stock_sub":"","dealer_zip":"65203","canonical_mmt":"Mercedes-Benz:AMG GLE 63:S 4MATIC+","vertical_position":15,"vin":"4JGFB8KB1RB247901","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["great_deal"],"make":"Mercedes-Benz","fuel_type":"Gasoline","canonical_mmty":"Mercedes-Benz:AMG GLE 63:S 4MATIC+:2024","dealer_name":"Mercedes-Benz of Columbia","photo_count":36,"model":"AMG GLE 63"},{"listing_id":"41205606-d26d-4e60-b29b-96ef7a0aa35c","bodystyle":"SUV","certified_preowned":false,"mileage":"66668","stock_type":"Used","trim":"SLE","exterior_color":"Satin Steel Metallic","drivetrain":"All-wheel Drive","cat":"crossover_midsize","seller_type":"dealership","relevancy_score":null,"price":"22828","nvi_program":false,"msrp":null,"sponsored":false,"year":"2020","customer_id":"5363686","interior_color":"Jet Black","stock_sub":"","dealer_zip":"65051","canonical_mmt":"GMC:Acadia:SLE","vertical_position":16,"vin":"1GKKNRLS7LZ148291","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["great_deal"],"make":"GMC","fuel_type":"Gasoline","canonical_mmty":"GMC:Acadia:SLE:2020","dealer_name":"Jim Butler Linn Chevrolet","photo_count":6,"model":"Acadia"},{"listing_id":"5f996461-876d-44de-9c92-99451a5f978d","bodystyle":"Truck","certified_preowned":false,"mileage":"39748","stock_type":"Used","trim":"Custom Trail Boss","exterior_color":"Northsky Blue Metallic","drivetrain":"Four-wheel Drive","cat":"truck_fullsize","seller_type":"dealership","relevancy_score":null,"price":"34321","nvi_program":false,"msrp":null,"sponsored":false,"year":"2022","customer_id":"6039707","interior_color":"Black","stock_sub":"","dealer_zip":"65203","canonical_mmt":"Chevrolet:Silverado 1500 Limited:Custom Trail Boss","vertical_position":17,"vin":"3GCPYCEK7NG147373","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["good_deal","hot_car"],"make":"Chevrolet","fuel_type":"Gasoline","canonical_mmty":"Chevrolet:Silverado 1500 Limited:Custom Trail Boss:2022","dealer_name":"Joe Machens Ford","photo_count":29,"model":"Silverado 1500 Limited"},{"listing_id":"6d409a62-a31b-485a-85e9-6ad7d51e5bb3","bodystyle":"Hatchback","certified_preowned":false,"mileage":"42930","stock_type":"Used","trim":"SE","exterior_color":"Oxford White","drivetrain":"Front-wheel Drive","cat":"hybrid_passenger","seller_type":"dealership","relevancy_score":null,"price":"13360","nvi_program":false,"msrp":"0","sponsored":false,"year":"2017","customer_id":"5364038","interior_color":"Black","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Ford:C-Max Hybrid:SE","vertical_position":18,"vin":"1FADP5AU9HL114767","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["great_deal"],"make":"Ford","fuel_type":"Hybrid","canonical_mmty":"Ford:C-Max Hybrid:SE:2017","dealer_name":"Joe Machens Volkswagen","photo_count":50,"model":"C-Max Hybrid"},{"listing_id":"b316d120-cbb7-4453-8fcb-b51b682b3a54","bodystyle":"Convertible","certified_preowned":false,"mileage":"93605","stock_type":"Used","trim":"2.0T Premium Plus","exterior_color":"Matador Red Metallic","drivetrain":"All-wheel Drive","cat":"luxurypassenger_standard","seller_type":"dealership","relevancy_score":null,"price":"19067","nvi_program":false,"msrp":"0","sponsored":false,"year":"2018","customer_id":"5364038","interior_color":"Atlas Beige","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Audi:A5:2.0T Premium Plus","vertical_position":19,"vin":"WAUYNGF5XJN003487","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","great_deal"],"make":"Audi","fuel_type":"Gasoline","canonical_mmty":"Audi:A5:2.0T Premium Plus:2018","dealer_name":"Joe Machens Volkswagen","photo_count":49,"model":"A5"},{"listing_id":"835b1c5f-350c-4d62-946a-e38ace91afa3","bodystyle":"SUV","certified_preowned":false,"mileage":"46297","stock_type":"Used","trim":"LX","exterior_color":"Gravity Gray","drivetrain":"All-wheel Drive","cat":"crossover_compact","seller_type":"dealership","relevancy_score":null,"price":"20800","nvi_program":false,"msrp":"0","sponsored":false,"year":"2024","customer_id":"5354599","interior_color":"Black","stock_sub":"","dealer_zip":"65202","canonical_mmt":"Kia:Sportage:LX","vertical_position":20,"vin":"KNDPUCDF9R7293629","cpo_indicator":false,"sponsored_type":"standard","cpo_package":null,"badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"make":"Kia","fuel_type":"Gasoline","canonical_mmty":"Kia:Sportage:LX:2024","dealer_name":"Columbia Honda","photo_count":34,"model":"Sportage"}]}]