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 Franklin, MO under $574,976

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
1,077 matches 30 miles from 65274
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: Crystal White Tricoat
Int. color: Maple Sugar w/Jet Black Accents
Drivetrain: All-wheel Drive
MPG: 18-26
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.6L V-6 gasoline direct injection, DOHC, variable valve control
Stock #: MU8149
VIN: 1GYKNHRS6MZ209381

Features

Convenience: Adaptive Cruise Control, Automatic Parking, 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, 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

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.

2021 Cadillac XT5 Sport review

The XT5 was well maintained, inside and out.

The XT5 was well maintained, inside and out. The ride is smooth. Up-to-date technology. I rode 324 mile road trip was with no problems. My family was impressed with the ride, interior and technology.

Vehicle information

Ext. color: Summit White
Int. color: Cocoa / Shale
Drivetrain: Four-wheel Drive
MPG: 15-21
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 6.2L V8 16V GDI OHV
Stock #: FR502850
VIN: 1GKS2CKJ9FR502850

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, CD Player, Premium Sound System, Rear Seat Entertainment, Satellite Radio
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof, Tow Hitch
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

2015 GMC Yukon Denali review

Great family suv.

Just trade in my 2015 GMC Denali with 140000 miles on it and still holding strong at trade in best SUV I ever had upgraded to the new 2021 Denali and boy do I love this SUV from comfort to outside design just an amazing new well designed SUV.

Vehicle information

Ext. color: Diamond Black Crystal Pearlcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.6L V6 24V VVT
Stock #: MC506579
VIN: 1C4RJFBG4MC506579

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Joe Machens Nissan review

Great people

Scott Glasgow was very helpful. He actually listened to our needs and provided solutions. He cares for his customers and we are glad to know him.

2021 Jeep Grand Cherokee Limited X review

I just love everything about my 2021 80th anniversary

I just love everything about my 2021 80th anniversary edition G/C! I purchased new but now has 81000km. So much enjoy all the style comfort with no issues. So much more reliable and better looking than the new body style that was released later in 2021.

Vehicle information

Ext. color: Diamond Black Crystal Pearlcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 18-21
Fuel type: Gasoline
Transmission: Automatic
Engine: HEMI 5.7L V-8 variable valve control, regular unleaded, engine w
Stock #: NN255559
VIN: 1C6SRFJT5NN255559

Features

Convenience: Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Stability Control
Seating: Leather Seats, Memory Seat

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.

2022 RAM 1500 Laramie review

Purchased a 2022 Laramie, RWD, Hemi 5.

Purchased a 2022 Laramie, RWD, Hemi 5.7L, Crew Cab with 21,000 miles. Other than no nav system, the truck is pristine. I am the 3rd owner; the other two maintained it beautifully. This V8 gets better city/hwy mileage than my for V6, 4x4, Crew Cab Nissan Frontier. I am most please with this vehicle!

Vehicle information

Ext. color: Diamond Black Crystal Pearlcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: Automatic
Engine: Pentastar 3.6L V-6 DOHC, variable valve control, regular unleade
Stock #: MC612660
VIN: 1C4RJFAG0MC612660

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof, Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Rear Cross Traffic Alert, 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.

2021 Jeep Grand Cherokee Laredo review

Perfect New England Vehicle !

My Grand Cherokee Laredo E just turned 50,000 miles a few days ago. Other than routine maintenance, the only money that I have invested in it was for 4 tires last month. Extremely comfortable, capable and reliable. While not delivering Prius-like gas mileage, given the performance it provides in all types of weather.............NO COMPLAINTS !

Vehicle information

Ext. color: Volcanic Red Tintcoat
Int. color: Obsidian Rush
Drivetrain: Four-wheel Drive
MPG: 14-16
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoTec3 6.2L V-8 gasoline direct injection, variable valve contr
Stock #: BU2640A
VIN: 3GTUUFEL3RG108987

Features

Convenience: Adaptive Cruise Control, Cooled Seats, 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, 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

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 GMC Sierra 1500 AT4X review

I love it the look the interior mine is a red one and it

I love it the look the interior mine is a red one and it looks so good and it’s my baby and it runs so good and the technology is off the chain

Vehicle information

Ext. color: Shadow Gray Metallic
Int. color: Jet Black
Drivetrain: Four-wheel Drive
MPG: 15-20
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoTec3 4.3L V-6 gasoline direct injection, variable valve contr
Stock #: KZ421569
VIN: 1GCPYBEH0KZ421569

Features

Convenience: Keyless Entry, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, 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.

2019 Chevrolet Silverado 1500 Custom review

Thumbs up

Since I've owned it, so far so good. I like my truck and I appreciate it everyday. A little bit of shaking in the steering at high speeds but I'm not concerned with it. Overall, pretty great.

Vehicle information

Ext. color: Black
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 #: BU2678
VIN: 5UXCR6C01P9P36970

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: 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?

2023 BMW X5 xDrive40i review

Very comfortable

Very comfortable, with massaging seats plus heated and cooled seats. I’m not sure that it’s a great value because it is expensive. The adaptive cruise control and the lane keeping work very well and almost make it self-driving.

Vehicle information

Ext. color: Super Black
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: Automatic
Engine: VC-Turbo 1.5L I-3 gasoline direct injection, DOHC, CVTCS variabl
Stock #: PC849163
VIN: 5N1BT3BB2PC849163

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, Rear Cross Traffic Alert, Stability Control

Reviews

Columbia Honda review

Excellent service and friendly staff

Wonderful service, a very comfortable place to wait with snacks and even doggy treats. We purchased our car from Columbia Honda and will definitely return when we are ready to trade. All staff are very friendly.

2023 Nissan Rogue SV review

So far I have been pleased with the performance of my

So far I have been pleased with the performance of my Rogue. It just turned 20,000 miles. I'm reading some of the negative reviews and wondering if they take proper care of their vehicles. Time will tell if the 3 cylinder turbo is a winner.

Vehicle information

Ext. color: Pearl White Multi-Coat
Int. color: Black
Drivetrain: All-wheel Drive
Fuel type: Electric
Transmission: Automatic
Engine: Electric Motor
Stock #: M5353A
VIN: 7SAYGDEF8NF452079

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate
Entertainment: 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: 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!

2022 Tesla Model Y Performance Dual Motor All-Wheel Drive review

This is the best car I have ever owned.

This is the best car I have ever owned. Over the years I have owned many luxury cars and by far my Tesla Model Y is better than all of them. I have had the car for 2 years now and I never had any issues with the car. Very reliable, fast, and love the auto pilot. The handling is amazing and very quiet. Love the minimalistic interior. I don’t understand why other car maker put 100s of buttons in the dashboard. Love the screen and it’s user friendly.

Vehicle information

Ext. color: Brilliant Black Crystal Pearlcoat
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 19-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.6L V-6 DOHC, VVT variable valve control, regular unleaded, eng
Stock #: BU2747A
VIN: 2C4RC1FG8JR305990

Features

Convenience: Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, Rear Cross Traffic Alert, Stability Control
Seating: Third Row Seating

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

2018 Chrysler Pacifica Touring Plus review

I leased a new Pacifica Limited S in 2018 and when the

I leased a new Pacifica Limited S in 2018 and when the lease expired after three years I bought it and drove it for three more years. I liked it so much that I just leased a new 2025 that is very similar to the 2018. The 2018 was extremely dependable and served us well for transporting my boys (grandsons), other family and friends, kayaks, bikes, skis, and numerous trips to Goodwill Industries. It never needed any significant mechanical repairs and it never left us at the side of the road in the nearly 90,000 miles we had it.

Vehicle information

Ext. color: Bright White Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 5.7L V8 16V MPFI OHV
Stock #: NN235741
VIN: 1C6SRFJT4NN235741

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Backup Camera, Brake Assist, 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!

2022 RAM 1500 Laramie review

I bought mine used.

I bought mine used. It had about 40k miles on it. I got a steal of a deal price wise. That being said. It drives smooth. Has all the power i need to haul and tow for work and life. Also plenty of room for hauling around family. I have had no complaints. It’s everything i was looking for in a vehicle. Ironically it is not the color I normally would buy. But even my particular wife loves the color and looks combination. She drives it as much as I do. I can’t say the same about her car. But, i am not a huge car person. One final thing. I am thoroughly impressed with the fuel consumption. Would recommend this vehicle (the big horn edition) to anyone.

Vehicle information

Ext. color: Black
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 17-27
Fuel type: Gasoline
Transmission: Automatic
Engine: 4L V-8 gasoline direct injection, DOHC, variable valve control,
Stock #: M5366A
VIN: WDDUG8GB2LA526928

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, HomeLink, 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, Stability Control
Seating: Leather Seats, Memory Seat

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.

2020 Mercedes-Benz S-Class 4MATIC review

Great car

S450 is a great value. Plenty of power. Very comfortable. Quiet and smooth ride. Don't need the big engine. Would definitely buy again. Very dependable.

Vehicle information

Ext. color: Redfire Clearcoat Metallic
Int. color: Black / Dove
Drivetrain: Rear-wheel Drive
MPG: 17-25
Fuel type: Gasoline
Transmission: 5-Speed
Engine: 4.6L V8 24V MPFI SOHC
Stock #: 75197744
VIN: 1ZVHT82H275197744

Features

Convenience: Keyless Entry
Entertainment: CD Player, Premium Sound System
Exterior: Alloy Wheels
Seating: Leather Seats

Reviews

2007 Ford Mustang GT Premium review

beat car I ever drove in 20 years of owning mustangs I

beat car I ever drove in 20 years of owning mustangs I own over 30 mustangs and this one is the best one in all ways.

Vehicle information

Ext. color: Black Raven
Int. color: Jet Black
Drivetrain: Four-wheel Drive
MPG: 14-19
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoTec3 6.2L V-8 gasoline direct injection, variable valve contr
Stock #: MU8047
VIN: 1GYS4FKL3MR354971

Features

Convenience: Adaptive Cruise Control, Automatic Parking, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Rear Seat Entertainment, 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

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.

2021 Cadillac Escalade Sport review

Nice vehicle very good family truck 68,000 miles very

Nice vehicle very good family truck 68,000 miles very solid have not had any major issues comfortable and ample power like the options great power pulling boat

Vehicle information

Ext. color: Satin Steel Metallic
Int. color: Jet Black
Drivetrain: Four-wheel Drive
MPG: 17-20
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.7L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: MU7985
VIN: 1GCPYJEKXNZ144553

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Stability Control

Reviews

Mercedes-Benz of Columbia review

I recently purchased a Mercedes-Benz S580 from

I recently purchased a Mercedes-Benz S580 from Mercedes-Benz of Columbia, and I couldn't be more pleased with my experience. Despite the 16-hour drive from Northern Virginia, it was absolutely worth it. The pricing was unbeatable, and more importantly, the service and communication were exceptional. I had the pleasure of working with Zac Nichols, the Sales Agent, and Danh Do, the Finance Manager, and they truly made the entire process a breeze. From start to finish, they understood exactly what I was looking for and provided the best service. There were no last-minute surprises, no haggle pricing—just a straightforward and smooth experience. Their dedication to customer satisfaction was clear, and I know moving forward, I will always check their inventory first before considering any other dealerships. Thank you, Zac and Danh, for making this purchase a delightful and stress-free experience. I highly recommend Mercedes-Benz of Columbia to anyone in the market for a new car!

2022 Chevrolet Silverado 1500 LT review

very good truck it is the best car i jave bought since my

very good truck it is the best car i jave bought since my opd one was broken this help me alot and thanks for seeing this

Vehicle information

Ext. color: Predawn Gray Mica
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 44-47
Fuel type: Hybrid
Transmission: Automatic
Engine: 2.5L I-4 port/direct injection, DOHC, VVT-iE/VVT-i variable valv
Stock #: NU595344
VIN: 4T1S31AKXNU595344

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, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control

Reviews

Columbia Honda review

UPDATE

UPDATE! PLEASE IGNORE MY PREVIOUS REVIEW!! This dealership is awesome! I had some problems with a vehicle there and they ended up fixing Everything!! Everyone there went out of their way to make sure I was a satisfied customer! I left there a very happy customer! See them for all your vehicle shopping.

2022 Toyota Camry SE review

Exceptional value car

One of the best cars I've had actually got more than what I was expecting, great car reliable nice looking one of the safest cars

Vehicle information

Ext. color: Dark Cherry Pearl
Int. color: Parchment
Drivetrain: All-wheel Drive
MPG: 18-27
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 gasoline direct injection, i-VTEC variable valve contro
Stock #: BU2808A
VIN: 5FRYD4H44FB018094

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate
Entertainment: Bluetooth®, CD Player, HomeLink, Premium Sound System, WiFi Hotspot
Exterior: Alloy Wheels, Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

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!

2015 Acura MDX 3.5L Technology Package review

2015 Acura MDX review

I recently had the pleasure of test-driving a 2015 Acura MDX from the CarLoft dealership, and I must say, I was thoroughly impressed with this premium SUV. The Acura MDX has long been known for its blend of luxury, performance, and reliability, and the 2015 model certainly lives up to that reputation. In summary, the 2015 Acura MDX from the CarLoft dealership is a fantastic choice for those seeking a luxury SUV with a proven reliability and performance track record. While it may lack some of the latest tech found in newer models, it makes up for its timeless design, comfortable interior, and a driving experience that combines power and refinement. If you're in the market for a pre-owned luxury SUV, the 2015 Acura MDX is worth considering.

Vehicle information

Ext. color: Ebony Twilight Metallic
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 22-28
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 2.0L I4 16V GDI DOHC Turbo
Stock #: RD075634
VIN: LRBFZSE42RD075634

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Brake Assist, 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!

2024 Buick Envision Avenir review

This is my 3rd Buick.

This is my 3rd Buick. Loved my LaCrosse and just now upgraded to the Invision Avenir. Very satisfied with the look and upgraded options. Performance is a bit less than my LaCrosse with the V6 but adequate.

Vehicle information

Ext. color: Titanium Silver
Int. color: Satin Black
Drivetrain: Front-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: Automatic
Engine: Lambda II 3.3L V-6 gasoline direct injection, DOHC, CVVT variabl
Stock #: JG388483
VIN: 5XYPG4A50JG388483

Features

Convenience: Keyless Entry
Entertainment: Bluetooth®, CD Player, USB Port
Exterior: Alloy Wheels, Roof Rack
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control
Seating: Third Row Seating

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.

2018 Kia Sorento LX review

What a car! Would recommend this vehicle to anyone

Excellent driving through snow. I have an 81 km one way to work. Never missed a shift. Also very economical with the 2.4 litre inline 4 cylinder. Average on the highway is between 7 - 8 litres per 100 km.

*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,077 matches Clear
Clear
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 $574,976 in New Franklin, MO by make

Find great prices by city

Find great prices on used cars in New Franklin, MO

Used cars by body style and price

[{"applied_filter_criteria":"{\"cpo_indicator\":false,\"max_price_range\":574976,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","vehicle_array":[{"interior_color":"Maple Sugar w/Jet Black Accents","vertical_position":1,"year":"2021","trim":"Sport","stock_type":"Used","price":"36975","mileage":"21019","drivetrain":"All-wheel Drive","msrp":"0","cat":"luxurysuv_crossover","certified_preowned":false,"bodystyle":"SUV","photo_count":37,"customer_id":"5243424","cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"Cadillac:XT5:Sport:2021","listing_id":"c6026733-b23a-41e8-b7ff-08e877ccdba6","model":"XT5","cpo_package":null,"dealer_name":"Mercedes-Benz of Columbia","vin":"1GYKNHRS6MZ209381","make":"Cadillac","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Crystal White Tricoat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Cadillac:XT5:Sport","fuel_type":"Gasoline"},{"interior_color":"Cocoa / Shale","vertical_position":2,"year":"2015","trim":"Denali","stock_type":"Used","price":"23922","mileage":"113267","drivetrain":"Four-wheel Drive","msrp":null,"cat":"suv_fullsize","certified_preowned":false,"bodystyle":"SUV","photo_count":30,"customer_id":"6039707","cpo_indicator":false,"badges":["great_deal"],"canonical_mmty":"GMC:Yukon:Denali:2015","listing_id":"aad04047-0727-4f32-aa93-564b6f49e249","model":"Yukon","cpo_package":null,"dealer_name":"Joe Machens Ford","vin":"1GKS2CKJ9FR502850","make":"GMC","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Summit White","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"GMC:Yukon:Denali","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":3,"year":"2021","trim":"Limited X","stock_type":"Used","price":"27999","mileage":"29427","drivetrain":"Four-wheel Drive","msrp":"0","cat":"suv_midsize","certified_preowned":false,"bodystyle":"SUV","photo_count":28,"customer_id":"5363960","cpo_indicator":false,"badges":["great_deal"],"canonical_mmty":"Jeep:Grand Cherokee:Limited X:2021","listing_id":"a0123b5b-1e78-4e8a-9327-5facde417f9d","model":"Grand Cherokee","cpo_package":null,"dealer_name":"Joe Machens Nissan","vin":"1C4RJFBG4MC506579","make":"Jeep","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Diamond Black Crystal Pearlcoat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Jeep:Grand Cherokee:Limited X","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":4,"year":"2022","trim":"Laramie","stock_type":"Used","price":"37437","mileage":"80438","drivetrain":"Four-wheel Drive","msrp":"0","cat":"truck_fullsize","certified_preowned":false,"bodystyle":"Truck","photo_count":6,"customer_id":"5364038","cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"RAM:1500:Laramie:2022","listing_id":"a4fa4c86-26ab-4686-b15e-d37f5e34f6fa","model":"1500","cpo_package":null,"dealer_name":"Joe Machens Volkswagen","vin":"1C6SRFJT5NN255559","make":"RAM","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Diamond Black Crystal Pearlcoat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"RAM:1500:Laramie","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":5,"year":"2021","trim":"Laredo","stock_type":"Used","price":"23950","mileage":"76523","drivetrain":"Four-wheel Drive","msrp":"0","cat":"suv_midsize","certified_preowned":false,"bodystyle":"SUV","photo_count":48,"customer_id":"5364038","cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"Jeep:Grand Cherokee:Laredo:2021","listing_id":"64618de8-9463-4a84-b9ab-906b69089eaf","model":"Grand Cherokee","cpo_package":null,"dealer_name":"Joe Machens Volkswagen","vin":"1C4RJFAG0MC612660","make":"Jeep","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Diamond Black Crystal Pearlcoat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Jeep:Grand Cherokee:Laredo","fuel_type":"Gasoline"},{"interior_color":"Obsidian Rush","vertical_position":6,"year":"2024","trim":"AT4X","stock_type":"Used","price":"59062","mileage":"35682","drivetrain":"Four-wheel Drive","msrp":"0","cat":"truck_fullsize","certified_preowned":false,"bodystyle":"Truck","photo_count":39,"customer_id":"152419","cpo_indicator":false,"badges":["good_deal","american_made_index_ranking"],"canonical_mmty":"GMC:Sierra 1500:AT4X:2024","listing_id":"af44e32e-9bf2-481c-9800-a08d7abe31c2","model":"Sierra 1500","cpo_package":null,"dealer_name":"BMW of Columbia - MO","vin":"3GTUUFEL3RG108987","make":"GMC","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Volcanic Red Tintcoat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"GMC:Sierra 1500:AT4X","fuel_type":"Gasoline"},{"interior_color":"Jet Black","vertical_position":7,"year":"2019","trim":"Custom","stock_type":"Used","price":"27500","mileage":"76335","drivetrain":"Four-wheel Drive","msrp":"0","cat":"truck_fullsize","certified_preowned":false,"bodystyle":"Truck","photo_count":6,"customer_id":"5354599","cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"Chevrolet:Silverado 1500:Custom:2019","listing_id":"092f8720-5991-4982-9b77-a9cc78725157","model":"Silverado 1500","cpo_package":null,"dealer_name":"Columbia Honda","vin":"1GCPYBEH0KZ421569","make":"Chevrolet","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Shadow Gray Metallic","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Chevrolet:Silverado 1500:Custom","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":8,"year":"2023","trim":"xDrive40i","stock_type":"Used","price":"41120","mileage":"43497","drivetrain":"All-wheel Drive","msrp":"0","cat":"luxurysuv_crossover","certified_preowned":false,"bodystyle":"SUV","photo_count":35,"customer_id":"152419","cpo_indicator":false,"badges":["price_drop_in_cents","great_deal"],"canonical_mmty":"BMW:X5:xDrive40i:2023","listing_id":"50c4e9ac-f88f-4ce1-8f82-8468d036dceb","model":"X5","cpo_package":null,"dealer_name":"BMW of Columbia - MO","vin":"5UXCR6C01P9P36970","make":"BMW","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Black","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"BMW:X5:xDrive40i","fuel_type":"Gasoline"},{"interior_color":"Charcoal","vertical_position":9,"year":"2023","trim":"SV","stock_type":"Used","price":"23000","mileage":"47073","drivetrain":"All-wheel Drive","msrp":"0","cat":"crossover_compact","certified_preowned":false,"bodystyle":"SUV","photo_count":6,"customer_id":"5354599","cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"Nissan:Rogue:SV:2023","listing_id":"46a18024-4c2d-4440-a098-a0917c102569","model":"Rogue","cpo_package":null,"dealer_name":"Columbia Honda","vin":"5N1BT3BB2PC849163","make":"Nissan","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Super Black","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Nissan:Rogue:SV","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":10,"year":"2022","trim":"Performance Dual Motor All-Wheel Drive","stock_type":"Used","price":"26589","mileage":"74758","drivetrain":"All-wheel Drive","msrp":"0","cat":"ev_suv_midsize","certified_preowned":false,"bodystyle":"SUV","photo_count":35,"customer_id":"5243424","cpo_indicator":false,"badges":["great_deal","american_made_index_ranking",{"battery_badge_score":"Excellent","battery_badge_text":"The expected range is similar to normal when new."},"2022_award_winner"],"canonical_mmty":"Tesla:Model Y:Performance Dual Motor All-Wheel Drive:2022","listing_id":"6e82aedf-67ff-4de3-a60b-105108b1733a","model":"Model Y","cpo_package":null,"dealer_name":"Mercedes-Benz of Columbia","vin":"7SAYGDEF8NF452079","make":"Tesla","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Pearl White Multi-Coat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Tesla:Model Y:Performance Dual Motor All-Wheel Drive","fuel_type":"Electric"},{"interior_color":"Black","vertical_position":11,"year":"2018","trim":"Touring Plus","stock_type":"Used","price":"10814","mileage":"152163","drivetrain":"Front-wheel Drive","msrp":"0","cat":"van_mini","certified_preowned":false,"bodystyle":"Minivan","photo_count":35,"customer_id":"152419","cpo_indicator":false,"badges":["price_drop_in_cents","great_deal"],"canonical_mmty":"Chrysler:Pacifica:Touring Plus:2018","listing_id":"7e040c36-0221-4fc9-893a-1fdbc4b5497a","model":"Pacifica","cpo_package":null,"dealer_name":"BMW of Columbia - MO","vin":"2C4RC1FG8JR305990","make":"Chrysler","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Brilliant Black Crystal Pearlcoat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Chrysler:Pacifica:Touring Plus","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":12,"year":"2022","trim":"Laramie","stock_type":"Used","price":"32300","mileage":"100379","drivetrain":"Four-wheel Drive","msrp":null,"cat":"truck_fullsize","certified_preowned":false,"bodystyle":"Truck","photo_count":27,"customer_id":"5364156","cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"RAM:1500:Laramie:2022","listing_id":"522336b6-a672-402b-abee-7d3ca3f2d761","model":"1500","cpo_package":null,"dealer_name":"Mazda of Columbia","vin":"1C6SRFJT4NN235741","make":"RAM","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Bright White Clearcoat","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"RAM:1500:Laramie","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":13,"year":"2020","trim":"4MATIC","stock_type":"Used","price":"44989","mileage":"71010","drivetrain":"All-wheel Drive","msrp":"0","cat":"luxurypassenger_plus","certified_preowned":true,"bodystyle":"Sedan","photo_count":35,"customer_id":"5243424","cpo_indicator":true,"badges":["good_deal","cpo"],"canonical_mmty":"Mercedes-Benz:S-Class:4MATIC:2020","listing_id":"edc8f7fa-c22e-4a5f-bae8-ef78245f0ae0","model":"S-Class","cpo_package":"Mercedes-Benz","dealer_name":"Mercedes-Benz of Columbia","vin":"WDDUG8GB2LA526928","make":"Mercedes-Benz","seller_type":"dealership","sponsored":true,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Black","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Mercedes-Benz:S-Class:4MATIC","fuel_type":"Gasoline"},{"interior_color":"Black / Dove","vertical_position":14,"year":"2007","trim":"GT Premium","stock_type":"Used","price":"25995","mileage":"31091","drivetrain":"Rear-wheel Drive","msrp":null,"cat":"coupeconvertible_coupe","certified_preowned":false,"bodystyle":"Coupe","photo_count":27,"customer_id":"6039707","cpo_indicator":false,"badges":["fair_deal"],"canonical_mmty":"Ford:Mustang:GT Premium:2007","listing_id":"a8b23671-2d5e-407a-8556-f07c8576fd8b","model":"Mustang","cpo_package":null,"dealer_name":"Joe Machens Ford","vin":"1ZVHT82H275197744","make":"Ford","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Redfire Clearcoat Metallic","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Ford:Mustang:GT Premium","fuel_type":"Gasoline"},{"interior_color":"Jet Black","vertical_position":15,"year":"2021","trim":"Sport","stock_type":"Used","price":"63458","mileage":"63123","drivetrain":"Four-wheel Drive","msrp":"0","cat":"luxurysuv_suv","certified_preowned":false,"bodystyle":"SUV","photo_count":39,"customer_id":"5243424","cpo_indicator":false,"badges":[],"canonical_mmty":"Cadillac:Escalade:Sport:2021","listing_id":"ff17cd06-188c-4fd3-9f3e-81672edc6b18","model":"Escalade","cpo_package":null,"dealer_name":"Mercedes-Benz of Columbia","vin":"1GYS4FKL3MR354971","make":"Cadillac","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Black Raven","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Cadillac:Escalade:Sport","fuel_type":"Gasoline"},{"interior_color":"Jet Black","vertical_position":16,"year":"2022","trim":"LT","stock_type":"Used","price":"31990","mileage":"54963","drivetrain":"Four-wheel Drive","msrp":"0","cat":"truck_fullsize","certified_preowned":false,"bodystyle":"Truck","photo_count":33,"customer_id":"5243424","cpo_indicator":false,"badges":["great_deal"],"canonical_mmty":"Chevrolet:Silverado 1500:LT:2022","listing_id":"bc04325c-1caa-41e2-958c-248ec9c6e1d8","model":"Silverado 1500","cpo_package":null,"dealer_name":"Mercedes-Benz of Columbia","vin":"1GCPYJEKXNZ144553","make":"Chevrolet","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Satin Steel Metallic","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Chevrolet:Silverado 1500:LT","fuel_type":"Gasoline"},{"interior_color":"Black","vertical_position":17,"year":"2022","trim":"SE","stock_type":"Used","price":"20500","mileage":"100174","drivetrain":"Front-wheel Drive","msrp":"0","cat":"sedan_midsize","certified_preowned":false,"bodystyle":"Sedan","photo_count":33,"customer_id":"5354599","cpo_indicator":false,"badges":["price_drop_in_cents","good_deal"],"canonical_mmty":"Toyota:Camry:SE:2022","listing_id":"871681dd-8058-4d35-bfce-624257536515","model":"Camry","cpo_package":null,"dealer_name":"Columbia Honda","vin":"4T1S31AKXNU595344","make":"Toyota","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Predawn Gray Mica","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Toyota:Camry:SE","fuel_type":"Hybrid"},{"interior_color":"Parchment","vertical_position":18,"year":"2015","trim":"3.5L Technology Package","stock_type":"Used","price":"16232","mileage":"108825","drivetrain":"All-wheel Drive","msrp":"0","cat":"luxurysuv_crossover","certified_preowned":false,"bodystyle":"SUV","photo_count":37,"customer_id":"152419","cpo_indicator":false,"badges":["price_drop_in_cents","fair_deal"],"canonical_mmty":"Acura:MDX:3.5L Technology Package:2015","listing_id":"8ebba22b-5881-475e-85f3-1c2ef0914c90","model":"MDX","cpo_package":null,"dealer_name":"BMW of Columbia - MO","vin":"5FRYD4H44FB018094","make":"Acura","seller_type":"dealership","sponsored":false,"dealer_zip":"65203","sponsored_type":"standard","exterior_color":"Dark Cherry Pearl","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Acura:MDX:3.5L Technology Package","fuel_type":"Gasoline"},{"interior_color":"Gray","vertical_position":19,"year":"2024","trim":"Avenir","stock_type":"Used","price":"37800","mileage":"11710","drivetrain":"All-wheel Drive","msrp":null,"cat":"luxurysuv_crossover","certified_preowned":false,"bodystyle":"SUV","photo_count":28,"customer_id":"5364156","cpo_indicator":false,"badges":["price_drop_in_cents","great_deal"],"canonical_mmty":"Buick:Envision:Avenir:2024","listing_id":"6cd50ffd-aa6b-4a32-80a5-cdf9f6b2854e","model":"Envision","cpo_package":null,"dealer_name":"Mazda of Columbia","vin":"LRBFZSE42RD075634","make":"Buick","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Ebony Twilight Metallic","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Buick:Envision:Avenir","fuel_type":"Gasoline"},{"interior_color":"Satin Black","vertical_position":20,"year":"2018","trim":"LX","stock_type":"Used","price":"15990","mileage":"51474","drivetrain":"Front-wheel Drive","msrp":"0","cat":"crossover_midsize","certified_preowned":false,"bodystyle":"SUV","photo_count":49,"customer_id":"5364038","cpo_indicator":false,"badges":["great_deal"],"canonical_mmty":"Kia:Sorento:LX:2018","listing_id":"e208e32a-034d-4ddf-84f3-5b1b403b82bb","model":"Sorento","cpo_package":null,"dealer_name":"Joe Machens Volkswagen","vin":"5XYPG4A50JG388483","make":"Kia","seller_type":"dealership","sponsored":false,"dealer_zip":"65202","sponsored_type":"standard","exterior_color":"Titanium Silver","relevancy_score":null,"nvi_program":false,"stock_sub":"","canonical_mmt":"Kia:Sorento:LX","fuel_type":"Gasoline"}],"sponsored_type_eligible":["inventory_ad"]}]