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,071 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: Cosmic Blue Metallic
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 25-30
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.4L I4 16V MPFI SOHC
Stock #: KZ047184
VIN: JA4AD2A38KZ047184

Features

Convenience: Heated Seats, Keyless Entry
Entertainment: Bluetooth®, Premium Sound System, USB Port
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Stability Control
Seating: Third Row Seating

Reviews

2019 Mitsubishi Outlander ES review

I bought the car with 90,000 on the odometer.

I bought the car with 90,000 on the odometer. The car, when got on it hard, would start hesitating, and struggle to accelerate. The CVT transmission is defiantly a critter to get used to. The biggest negative thing I found about the car is that it noisy on the interstate. A lot of road noise in the cab to the point I have to turn the radio way up! After repairing the hesitation issue, and ignoring the CVT quirks, the car is very reliable.

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

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!

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: Brilliant Silver Metallic
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 #: NC689557
VIN: 5N1BT3BB4NC689557

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

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.

2022 Nissan Rogue SV review

Comfortable car

This is my favorite car. I wanted to buy this car from a long time ago. I am a big fan of the following. I feel very comfortable driving this car. I feel very safe. I love it. I would prefer people to buy this ca….

Vehicle information

Ext. color: Deep Black Pearl
Int. color: Titan Black
Drivetrain: Front-wheel Drive
MPG: 18-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.6L V-6 gasoline direct injection, DOHC, variable valve control
Stock #: NC548226
VIN: 1V2JR2CA4NC548226

Features

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

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 Volkswagen Atlas 3.6L SE w/Technology review

At Last my ATLAS has come along!

Great car! Overpaid a bit; but, bought top of the line with only 23k miles. Loved it and didn't want to dicker over price. Rudes well. Acceleration is good. Roomy, spacious passenger cabin and cargo bay. Amazing technology. I recommend this vehicle highly. Take a serious look at this one. You wont be disappointed.

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: White Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 21-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: B21042A2
VIN: 5UX53DP04R9V35561

Features

Convenience: Heated Seats, Heated Steering Wheel, 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, 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: 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 BMW X3 xDrive30i review

Only have been driving the car for a week, but it is

Only have been driving the car for a week, but it is clearly the best SUV I have experienced. My wife drives the Mercedes 300 - a fine car as well, but I have always preferred BMY engine performance and handling. The X3 is simply a pleasure to drive.

Vehicle information

Ext. color: Gun Metallic
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 27-37
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 2.5L 4-Cylinder DOHC 16V
Stock #: RN413409
VIN: 1N4BL4EV2RN413409

Features

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

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.

2024 Nissan Altima 2.5 SL review

Great mileage and very nice interior.

Great mileage and very nice interior. Lotsa stuff but sadly only drivers window is auto. Wheels are terrible. They look great but very hard to clean. Good trunk space and nice seats. Having problems with backup camera it looks very foggy. Had it back to dealer twice, no luck. No CD player.. big downgrade.

Vehicle information

Ext. color: Champagne Silver Metallic
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 29-36
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L DOHC
Stock #: RW381427
VIN: JN8BT3DC3RW381427

Features

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

Reviews

Joe Machens Nissan review

Salesman Scott glascow

Scott Glascow has sold me my last 3 nissans. He’s a great salesman. I feel very comfortable with him. He does his best to help you out and I feel if you asked him for something he would try to get it for you. I was looking at Chevy suv but the last 2 nissans have been good cars so I chose to go with it.

2024 Nissan Rogue Platinum review

I'm in the car I always wanted!

I'm in the car I always wanted! It's fast and sleek. The color is perfect! My husband feels I'm safer in my new 🚗. Thanks again Lisa and Prentiss!

Vehicle information

Drivetrain: All-wheel Drive
Fuel type: Electric
Transmission: 1-Speed Automatic
Engine: Electric
Stock #: MF244223
VIN: 5YJYGDEE8MF244223

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Power Liftgate
Entertainment: Bluetooth®, Premium Sound System
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2021 Tesla Model Y Long Range review

The moment I got the demo car onto the highway, I thought

The moment I got the demo car onto the highway, I thought to myself, “I LOVE this car!” Which rarely happens. I test drove both the Model 3 and Model Y in snowy conditions, and had not a single bout of fear that I may lose control. A few weeks ago, when we were getting a winter blizzard, I was driving my Mother home from Boulder. It was snowing about 2” -3” per hour, people were spinning out all over the place. I was confidently holding the pace car position in the left lane passing 4x4 trucks, with ease. It was incredible. Get upto $1000 off your next Tesla by mentioning me at https://ts.la/jolene547482

Vehicle information

Ext. color: Oxford White
Int. color: Medium Dark Slate
Drivetrain: Rear-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 3.3L V6 24V PDI DOHC
Stock #: PKF59745
VIN: 1FTMF1CB2PKF59745

Features

Convenience: Keyless Entry, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, USB Port
Exterior: Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, Stability Control

Reviews

2023 Ford F-150 XL review

I have 2 F150s.

I have 2 F150s. A 2013 with 286,000 miles and a 2017 with 152,000 miles. They both run perfect and they are very impressive vehicles. I owned a 1500 Z71 prior and that was basically junk.

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: Bright White Clearcoat
Int. color: Red/Black
Drivetrain: Four-wheel Drive
MPG: 17-22
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: HEMI 5.7L V8 Multi Displacement VVT eTorque
Stock #: PN501270
VIN: 1C6SRFLT7PN501270

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, 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

Joe Machens Nissan review

Scotty Glasgow is awesome!

Loved working with Scotty. He doesn't pressure you into making a quick decision; he gives you plenty of information on the positives and negatives of different models; and best of all he is a genuinely nice guy. I definitely recommend him!

2023 RAM 1500 Rebel review

2020 Ram 1500 Limited

Bought a 2020 Ram 1500 Limited new and owned for 4 years. The starter went out twice under !00,000 miles so replaced 2 starters, had spark plug miss fire that had to get fixed, had exhaust manifold crack making the clicking sound upon startup, gas mileage got bad around 80,000 miles. I loved my truck but was stuck 2 where truck wouldn't start because the starter Ram uses is too small and not enough power for the start/stop and this size of engine. Also, heated seats are not hot at all. Coming from a F150 where the heated seats were incredibly hot which felt great, Ram not so much.

Vehicle information

Ext. color: Granite Pearlcoat
Int. color: Black
Drivetrain: Rear-wheel Drive
MPG: 19-30
Fuel type: Gasoline
Transmission: Automatic
Engine: Pentastar 3.6L V-6 DOHC, variable valve control, regular unleade
Stock #: PH564192
VIN: 2C3CDXBG5PH564192

Features

Convenience: Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, 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 Dodge Charger SXT review

I am so glad I decided to get a Charger in 2015.

I am so glad I decided to get a Charger in 2015. I now have a 2023 Daytona and LOVE it. Beautiful and fun to drive. Only problem is there is no spare tire, just basically a fix a flat kit.

Vehicle information

Ext. color: Shadow Black
Int. color: Dark Earth Gray
Drivetrain: Four-wheel Drive
MPG: 17-23
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 DOHC, Ti-VCT variable valve control, regular unleaded,
Stock #: HKD35542
VIN: 1FTMF1E84HKD35542

Features

Convenience: Keyless Entry
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

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.

2017 Ford F-150 XL review

This truck is bulletproof.

This truck is bulletproof. Good ride, good handling more than adequate power, on the noisy side. A great vehicle for work or general driving. Thumbs up

Vehicle information

Ext. color: Dynamic Blue Metallic
Int. color: Jet Black
Drivetrain: Four-wheel Drive
MPG: 20-23
Fuel type: Diesel
Transmission: 10-Speed Automatic
Engine: 3.0L I6 24V DDI DOHC Turbo Diesel
Stock #: NZ631166
VIN: 1GTUUEET8NZ631166

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, 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, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2022 GMC Sierra 1500 AT4 review

2022 GMC Sierra SLT 3.0 Duramax

My 2022 GMC Sierra 3.0 Duramax pickup truck is a good truck. I work on a farm and I also drive an hour to see my girlfriend. For the farm, it has excellent towing capability and for the hour long drive to go see my girlfriend, depending on the weather for traveling, I can get up to 35 miles to the gallon!

Vehicle information

Ext. color: Ivory White
Int. color: Black / Saddle
Drivetrain: Four-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 5.7L V8 16V MPFI OHV
Stock #: PN657334
VIN: 1C6SRFKT6PN657334

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Tow Hitch
Safety: Backup Camera, Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2023 RAM 1500 Longhorn review

23 Ram 1500

My first truck after doing lots of research. Love the ride and room in it. My wife likes the ride and how high you ride to see ahead. More affordable then the other brands out there. Palmer Dodge was great to deal with.

Vehicle information

Ext. color: Majestic Black Pearl
Int. color: Espresso
Drivetrain: All-wheel Drive
MPG: 19-25
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 gasoline direct injection, i-VTEC variable valve contro
Stock #: B21053A
VIN: 5J8YE1H80SL002385

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, 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, Third Row Seating

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?

2025 Acura MDX Advance Package review

After enjoying a 2006 Honda Pilot for over 200K miles it

After enjoying a 2006 Honda Pilot for over 200K miles it came time to try something different although the Pilot was still performing flawlessly. Competition was fierce with Lexus, KIA, Volvo, and others offering compelling alternatives. But in the end customer loyalty won out. The ACURA MDX has proven to be an outstanding choice offering comfort, reliability, and an absolute pleasure to drive. Also of importance the technology interface feels intuitive with a very shallow learning curve. Highly recommend.

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: Walnut Brown Metallic Clearcoat
Int. color: Light Frost/Brown
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 #: HC842543
VIN: 1C4RJFCG2HC842543

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof, Tow Hitch, Tow Hooks
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

Columbia Honda review

Columbia Hondas Service Department

I have been using Columbia Honda for all of my services and repairs on my 2018 Nissan Frontier for the past several years and have NEVER had any issues whatsoever. I have always used Andrew to arrange my services and have been extremely pleased with the way I have been treated, the professionalism is second to none and the mechanics and the entire service department go above and beyond to make each and every service the best experience possible.. I highly recommend Andrew and the service department at Columbia Honda for all your service needs.

2017 Jeep Grand Cherokee Overland review

2017 GC Limited 4WD.

2017 GC Limited 4WD. Bought it 3 years ago with 53k miles and now approaching 108k miles. When we bought it, we went to fill the tank for the first time and the gas pump kept shutting off. Turns out there was a known issue with the fuel filler neck assembly. The selling dealer replaced it under warranty and we literally didn't have another issue until 100k miles. At 100k miles took it in for new spark plugs, which is normal maintenance, and found the radiator leaking. The new radiator was not cheap. Have not had any other issues, just replaced the factory original brakes, they made it almost to 108k! We live in Minnesota and this vehicle is an absolute beast in the snow. Put it in snow mode and it is very stable and feels unstoppable. It is a comfortable long distance cruiser and gets decent mileage on the highway, between 24-27mpg. The UConnect system is very easy to use, and the nav is pretty good, but the whole system operates quite slowly. That's a minor complaint I think. Overall we are pretty happy with our WK2.

Vehicle information

Ext. color: White Frost Tricoat
Int. color: Alpine Umber
Drivetrain: Four-wheel Drive
MPG: 22-26
Fuel type: Diesel
Transmission: Automatic
Engine: Duramax 3L I-6 diesel direct injection, DOHC, variable valve con
Stock #: B21005A
VIN: 1GTUUHET4NZ630498

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, Tow Hooks
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

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

2022 GMC Sierra 1500 Denali Ultimate review

Pleased that I made this purchase

Waiting for the Refreshed 2022 AT4 was well worth it! With all the manufacturing issues today, building and shipping was slow, but understandable. Love the truck and the features! Fit is perfect and quality is #1. Pricing was too high but all vehicles are running this way. You get what you pay for and this truck is perfect! I have owned many trucks and this by far is the best. The latest features are beyond most other makes and GM has thought this truck through from front to rear.

*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,071 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":[{"dealer_name":"Joe Machens Ford","vin":"JA4AD2A38KZ047184","stock_sub":"","listing_id":"d0959f57-5bbc-42ca-8ccf-baaa49e7783d","vertical_position":1,"trim":"ES","seller_type":"dealership","cat":"crossover_compact","bodystyle":"SUV","stock_type":"Used","mileage":"52304","canonical_mmt":"Mitsubishi:Outlander:ES","customer_id":"6039707","year":"2019","interior_color":"Black","price":"15495","sponsored_type":"standard","model":"Outlander","dealer_zip":"65203","msrp":null,"cpo_package":null,"relevancy_score":null,"photo_count":30,"make":"Mitsubishi","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","good_deal"],"canonical_mmty":"Mitsubishi:Outlander:ES:2019","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Front-wheel Drive","exterior_color":"Cosmic Blue Metallic","sponsored":false},{"dealer_name":"Mazda of Columbia","vin":"LRBFZSE42RD075634","stock_sub":"","listing_id":"6cd50ffd-aa6b-4a32-80a5-cdf9f6b2854e","vertical_position":2,"trim":"Avenir","seller_type":"dealership","cat":"luxurysuv_crossover","bodystyle":"SUV","stock_type":"Used","mileage":"11710","canonical_mmt":"Buick:Envision:Avenir","customer_id":"5364156","year":"2024","interior_color":"Gray","price":"38000","sponsored_type":"standard","model":"Envision","dealer_zip":"65202","msrp":null,"cpo_package":null,"relevancy_score":null,"photo_count":28,"make":"Buick","certified_preowned":false,"cpo_indicator":false,"badges":["great_deal"],"canonical_mmty":"Buick:Envision:Avenir:2024","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"All-wheel Drive","exterior_color":"Ebony Twilight Metallic","sponsored":false},{"dealer_name":"Columbia Honda","vin":"5N1BT3BB4NC689557","stock_sub":"","listing_id":"a37d2251-e51e-4b04-a367-1b6244387e69","vertical_position":3,"trim":"SV","seller_type":"dealership","cat":"crossover_compact","bodystyle":"SUV","stock_type":"Used","mileage":"37412","canonical_mmt":"Nissan:Rogue:SV","customer_id":"5354599","year":"2022","interior_color":"Charcoal","price":"22600","sponsored_type":"standard","model":"Rogue","dealer_zip":"65202","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":35,"make":"Nissan","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","good_deal"],"canonical_mmty":"Nissan:Rogue:SV:2022","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"All-wheel Drive","exterior_color":"Brilliant Silver Metallic","sponsored":false},{"dealer_name":"Joe Machens Volkswagen","vin":"1V2JR2CA4NC548226","stock_sub":"","listing_id":"18d98cc0-70ea-4a23-b192-caaf9574dd47","vertical_position":4,"trim":"3.6L SE w/Technology","seller_type":"dealership","cat":"crossover_midsize","bodystyle":"SUV","stock_type":"Used","mileage":"18468","canonical_mmt":"Volkswagen:Atlas:3.6L SE w/Technology","customer_id":"5364038","year":"2022","interior_color":"Titan Black","price":"30942","sponsored_type":"standard","model":"Atlas","dealer_zip":"65202","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":50,"make":"Volkswagen","certified_preowned":false,"cpo_indicator":false,"badges":["good_deal","hot_car"],"canonical_mmty":"Volkswagen:Atlas:3.6L SE w/Technology:2022","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Front-wheel Drive","exterior_color":"Deep Black Pearl","sponsored":false},{"dealer_name":"Joe Machens Ford","vin":"1GKS2CKJ9FR502850","stock_sub":"","listing_id":"aad04047-0727-4f32-aa93-564b6f49e249","vertical_position":5,"trim":"Denali","seller_type":"dealership","cat":"suv_fullsize","bodystyle":"SUV","stock_type":"Used","mileage":"113267","canonical_mmt":"GMC:Yukon:Denali","customer_id":"6039707","year":"2015","interior_color":"Cocoa / Shale","price":"23922","sponsored_type":"standard","model":"Yukon","dealer_zip":"65203","msrp":null,"cpo_package":null,"relevancy_score":null,"photo_count":30,"make":"GMC","certified_preowned":false,"cpo_indicator":false,"badges":["great_deal"],"canonical_mmty":"GMC:Yukon:Denali:2015","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Four-wheel Drive","exterior_color":"Summit White","sponsored":false},{"dealer_name":"BMW of Columbia - MO","vin":"5UX53DP04R9V35561","stock_sub":"","listing_id":"4e63eb62-a1b7-44e3-9866-0e2bae199e78","vertical_position":6,"trim":"xDrive30i","seller_type":"dealership","cat":"luxurysuv_crossover","bodystyle":"SUV","stock_type":"Used","mileage":"16513","canonical_mmt":"BMW:X3:xDrive30i","customer_id":"152419","year":"2024","interior_color":"Black","price":"44987","sponsored_type":"standard","model":"X3","dealer_zip":"65203","msrp":"0","cpo_package":"BMW","relevancy_score":null,"photo_count":36,"make":"BMW","certified_preowned":true,"cpo_indicator":true,"badges":["good_deal","american_made_index_ranking","cpo"],"canonical_mmty":"BMW:X3:xDrive30i:2024","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"All-wheel Drive","exterior_color":"White Metallic","sponsored":true},{"dealer_name":"Joe Machens Nissan","vin":"1N4BL4EV2RN413409","stock_sub":"","listing_id":"99f2f102-3fbe-4345-bdce-e4634f476900","vertical_position":7,"trim":"2.5 SL","seller_type":"dealership","cat":"sedan_midsize","bodystyle":"Sedan","stock_type":"Used","mileage":"20327","canonical_mmt":"Nissan:Altima:2.5 SL","customer_id":"5363960","year":"2024","interior_color":"Charcoal","price":"26050","sponsored_type":"standard","model":"Altima","dealer_zip":"65203","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":28,"make":"Nissan","certified_preowned":false,"cpo_indicator":false,"badges":["good_deal","american_made_index_ranking"],"canonical_mmty":"Nissan:Altima:2.5 SL:2024","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Front-wheel Drive","exterior_color":"Gun Metallic","sponsored":false},{"dealer_name":"Joe Machens Nissan","vin":"JN8BT3DC3RW381427","stock_sub":"","listing_id":"462d6ea4-9244-4fd7-acd7-ebfe75629eab","vertical_position":8,"trim":"Platinum","seller_type":"dealership","cat":"crossover_compact","bodystyle":"SUV","stock_type":"Used","mileage":"35441","canonical_mmt":"Nissan:Rogue:Platinum","customer_id":"5363960","year":"2024","interior_color":"Charcoal","price":"32035","sponsored_type":"standard","model":"Rogue","dealer_zip":"65203","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":28,"make":"Nissan","certified_preowned":false,"cpo_indicator":false,"badges":["fair_deal","american_made_index_ranking"],"canonical_mmty":"Nissan:Rogue:Platinum:2024","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Front-wheel Drive","exterior_color":"Champagne Silver Metallic","sponsored":false},{"dealer_name":"Joe Machens Ford","vin":"5YJYGDEE8MF244223","stock_sub":"","listing_id":"13818902-a317-4742-8987-660e1a1c99d4","vertical_position":9,"trim":"Long Range","seller_type":"dealership","cat":"ev_suv_midsize","bodystyle":"SUV","stock_type":"Used","mileage":"55456","canonical_mmt":"Tesla:Model Y:Long Range","customer_id":"6039707","year":"2021","interior_color":null,"price":"26995","sponsored_type":"standard","model":"Model Y","dealer_zip":"65203","msrp":null,"cpo_package":null,"relevancy_score":null,"photo_count":30,"make":"Tesla","certified_preowned":false,"cpo_indicator":false,"badges":["good_deal","american_made_index_ranking",{"battery_badge_score":"Good","battery_badge_text":"The expected range is a little lower than normal when new."}],"canonical_mmty":"Tesla:Model Y:Long Range:2021","nvi_program":false,"fuel_type":"Electric","drivetrain":"All-wheel Drive","exterior_color":null,"sponsored":false},{"dealer_name":"Joe Machens Ford","vin":"1FTMF1CB2PKF59745","stock_sub":"","listing_id":"b842bb19-cdbd-44d8-ac46-5e654c52effe","vertical_position":10,"trim":"XL","seller_type":"dealership","cat":"truck_fullsize","bodystyle":"Truck","stock_type":"Used","mileage":"12736","canonical_mmt":"Ford:F-150:XL","customer_id":"6039707","year":"2023","interior_color":"Medium Dark Slate","price":"27995","sponsored_type":"standard","model":"F-150","dealer_zip":"65203","msrp":null,"cpo_package":null,"relevancy_score":null,"photo_count":30,"make":"Ford","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","good_deal","hot_car"],"canonical_mmty":"Ford:F-150:XL:2023","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Rear-wheel Drive","exterior_color":"Oxford White","sponsored":false},{"dealer_name":"Mercedes-Benz of Columbia","vin":"1GYKNHRS6MZ209381","stock_sub":"","listing_id":"c6026733-b23a-41e8-b7ff-08e877ccdba6","vertical_position":11,"trim":"Sport","seller_type":"dealership","cat":"luxurysuv_crossover","bodystyle":"SUV","stock_type":"Used","mileage":"21019","canonical_mmt":"Cadillac:XT5:Sport","customer_id":"5243424","year":"2021","interior_color":"Maple Sugar w/Jet Black Accents","price":"36975","sponsored_type":"standard","model":"XT5","dealer_zip":"65203","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":37,"make":"Cadillac","certified_preowned":false,"cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"Cadillac:XT5:Sport:2021","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"All-wheel Drive","exterior_color":"Crystal White Tricoat","sponsored":false},{"dealer_name":"Joe Machens Nissan","vin":"1C6SRFLT7PN501270","stock_sub":"","listing_id":"6df228ca-c8ca-4656-ad00-67b81ba6662f","vertical_position":12,"trim":"Rebel","seller_type":"dealership","cat":"truck_fullsize","bodystyle":"Truck","stock_type":"Used","mileage":"32247","canonical_mmt":"RAM:1500:Rebel","customer_id":"5363960","year":"2023","interior_color":"Red/Black","price":"43724","sponsored_type":"standard","model":"1500","dealer_zip":"65203","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":27,"make":"RAM","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","good_deal"],"canonical_mmty":"RAM:1500:Rebel:2023","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Four-wheel Drive","exterior_color":"Bright White Clearcoat","sponsored":false},{"dealer_name":"Columbia Honda","vin":"2C3CDXBG5PH564192","stock_sub":"","listing_id":"ef6d7aa1-891c-42aa-a4b9-4f7cdb01d077","vertical_position":13,"trim":"SXT","seller_type":"dealership","cat":"sedan_midsize","bodystyle":"Sedan","stock_type":"Used","mileage":"64369","canonical_mmt":"Dodge:Charger:SXT","customer_id":"5354599","year":"2023","interior_color":"Black","price":"18800","sponsored_type":"standard","model":"Charger","dealer_zip":"65202","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":32,"make":"Dodge","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","great_deal"],"canonical_mmty":"Dodge:Charger:SXT:2023","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Rear-wheel Drive","exterior_color":"Granite Pearlcoat","sponsored":false},{"dealer_name":"Joe Machens Volkswagen","vin":"1FTMF1E84HKD35542","stock_sub":"","listing_id":"722052c3-9089-4a91-8d32-15ddacb02b02","vertical_position":14,"trim":"XL","seller_type":"dealership","cat":"truck_fullsize","bodystyle":"Truck","stock_type":"Used","mileage":"48415","canonical_mmt":"Ford:F-150:XL","customer_id":"5364038","year":"2017","interior_color":"Dark Earth Gray","price":"22999","sponsored_type":"standard","model":"F-150","dealer_zip":"65202","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":43,"make":"Ford","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","fair_deal"],"canonical_mmty":"Ford:F-150:XL:2017","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Four-wheel Drive","exterior_color":"Shadow Black","sponsored":false},{"dealer_name":"Joe Machens Ford","vin":"1GTUUEET8NZ631166","stock_sub":"","listing_id":"0b35d18c-cd67-4ef0-a3b9-5622f6ff1b85","vertical_position":15,"trim":"AT4","seller_type":"dealership","cat":"truck_fullsize","bodystyle":"Truck","stock_type":"Used","mileage":"130804","canonical_mmt":"GMC:Sierra 1500:AT4","customer_id":"6039707","year":"2022","interior_color":"Jet Black","price":"36995","sponsored_type":"standard","model":"Sierra 1500","dealer_zip":"65203","msrp":null,"cpo_package":null,"relevancy_score":null,"photo_count":27,"make":"GMC","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","good_deal"],"canonical_mmty":"GMC:Sierra 1500:AT4:2022","nvi_program":false,"fuel_type":"Diesel","drivetrain":"Four-wheel Drive","exterior_color":"Dynamic Blue Metallic","sponsored":false},{"dealer_name":"Joe Machens Ford","vin":"1C6SRFKT6PN657334","stock_sub":"","listing_id":"56ba4202-4a02-443f-b6cb-f21a32c03a31","vertical_position":16,"trim":"Longhorn","seller_type":"dealership","cat":"truck_fullsize","bodystyle":"Truck","stock_type":"Used","mileage":"92798","canonical_mmt":"RAM:1500:Longhorn","customer_id":"6039707","year":"2023","interior_color":"Black / Saddle","price":"40399","sponsored_type":"standard","model":"1500","dealer_zip":"65203","msrp":null,"cpo_package":null,"relevancy_score":null,"photo_count":25,"make":"RAM","certified_preowned":false,"cpo_indicator":false,"badges":["good_deal"],"canonical_mmty":"RAM:1500:Longhorn:2023","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Four-wheel Drive","exterior_color":"Ivory White","sponsored":false},{"dealer_name":"BMW of Columbia - MO","vin":"5J8YE1H80SL002385","stock_sub":"","listing_id":"843be14d-30ae-44fe-8abb-79a8ff408f7e","vertical_position":17,"trim":"Advance Package","seller_type":"dealership","cat":"luxurysuv_crossover","bodystyle":"SUV","stock_type":"Used","mileage":"6353","canonical_mmt":"Acura:MDX:Advance Package","customer_id":"152419","year":"2025","interior_color":"Espresso","price":"61285","sponsored_type":"standard","model":"MDX","dealer_zip":"65203","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":36,"make":"Acura","certified_preowned":false,"cpo_indicator":false,"badges":["good_deal","american_made_index_ranking"],"canonical_mmty":"Acura:MDX:Advance Package:2025","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"All-wheel Drive","exterior_color":"Majestic Black Pearl","sponsored":false},{"dealer_name":"Columbia Honda","vin":"4T1S31AKXNU595344","stock_sub":"","listing_id":"871681dd-8058-4d35-bfce-624257536515","vertical_position":18,"trim":"SE","seller_type":"dealership","cat":"sedan_midsize","bodystyle":"Sedan","stock_type":"Used","mileage":"100174","canonical_mmt":"Toyota:Camry:SE","customer_id":"5354599","year":"2022","interior_color":"Black","price":"20500","sponsored_type":"standard","model":"Camry","dealer_zip":"65202","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":33,"make":"Toyota","certified_preowned":false,"cpo_indicator":false,"badges":["price_drop_in_cents","good_deal"],"canonical_mmty":"Toyota:Camry:SE:2022","nvi_program":false,"fuel_type":"Hybrid","drivetrain":"Front-wheel Drive","exterior_color":"Predawn Gray Mica","sponsored":false},{"dealer_name":"Columbia Honda","vin":"1C4RJFCG2HC842543","stock_sub":"","listing_id":"4505ca3e-137d-4792-aefc-c6e5c42d53d9","vertical_position":19,"trim":"Overland","seller_type":"dealership","cat":"suv_midsize","bodystyle":"SUV","stock_type":"Used","mileage":"97286","canonical_mmt":"Jeep:Grand Cherokee:Overland","customer_id":"5354599","year":"2017","interior_color":"Light Frost/Brown","price":"18000","sponsored_type":"standard","model":"Grand Cherokee","dealer_zip":"65202","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":6,"make":"Jeep","certified_preowned":false,"cpo_indicator":false,"badges":["great_deal"],"canonical_mmty":"Jeep:Grand Cherokee:Overland:2017","nvi_program":false,"fuel_type":"Gasoline","drivetrain":"Four-wheel Drive","exterior_color":"Walnut Brown Metallic Clearcoat","sponsored":false},{"dealer_name":"BMW of Columbia - MO","vin":"1GTUUHET4NZ630498","stock_sub":"","listing_id":"f6b8241e-e7fd-4c98-9cc2-ad2c98fe362f","vertical_position":20,"trim":"Denali Ultimate","seller_type":"dealership","cat":"truck_fullsize","bodystyle":"Truck","stock_type":"Used","mileage":"46369","canonical_mmt":"GMC:Sierra 1500:Denali Ultimate","customer_id":"152419","year":"2022","interior_color":"Alpine Umber","price":"56412","sponsored_type":"standard","model":"Sierra 1500","dealer_zip":"65203","msrp":"0","cpo_package":null,"relevancy_score":null,"photo_count":36,"make":"GMC","certified_preowned":false,"cpo_indicator":false,"badges":["fair_deal"],"canonical_mmty":"GMC:Sierra 1500:Denali Ultimate:2022","nvi_program":false,"fuel_type":"Diesel","drivetrain":"Four-wheel Drive","exterior_color":"White Frost Tricoat","sponsored":false}],"sponsored_type_eligible":["inventory_ad"]}]