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

Filters 2 Year Price & payment Make Mileage Body style Ext. color All filters
1,234 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: Pure White
Int. color: Shetland Beige
Drivetrain: Front-wheel Drive
MPG: 18-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic with Tiptronic
Engine: 3.6L VR6
Stock #: PC530162
VIN: 1V2WR2CA1PC530162

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, 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 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.

2023 Volkswagen Atlas 3.6L SE w/Technology review

I have a 2019 Atlas.

I have a 2019 Atlas. This car is amazing and mind you I can't kill it. My car has 188,000 miles on it. The drive is smooth and very reliable. It has the room to fit all 5 of my kiddos perfectly and enough room in the trunk to even fit a wonderfold wagon with all the seats up. I highly recommend if you want a good SUV with a lot of room in it

Vehicle information

Ext. color: Race Red
Int. color: Black
Drivetrain: Rear-wheel Drive
MPG: 15-26
Fuel type: Gasoline
Transmission: Manual
Engine: 5L V-8 DOHC, Ti-VCT variable valve control, premium unleaded, en
Stock #: BU2549B
VIN: 1ZVBP8CU0D5236199

Features

Convenience: Keyless Entry
Entertainment: Bluetooth®, CD Player
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Brake Assist, Stability Control

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.

2013 Ford Mustang Boss 302 review

One of the best looking Mustang GT Models

I absolutely love my beautiful Deep Impact Blue 6 Speed Manual 2013 Mustang GT. I've had her going on 10 years now. She's very fast, more so with my Brenspeed 97 Race Tune delivered by my Bama Tuner, 1 7/8 Kooks Long Tube Headers, X-Pipe, fed back to my Flowmaster 40 Outlaw Mufflers, an Airaid Cold Air Intake and in the very near future a Ported 2nd Gen Cobra Jet Intake with N/A Detroit Rocker. So fun to drive. Insane throttle Response with smooth handling, pure beast

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

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 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: 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

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!

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: Black Metallic
Int. color: Black W/Medium Dark Slate
Drivetrain: Four-wheel Drive
MPG: 22-24
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 3.5L V-6 port/direct injection, DOHC, Ti-VCT variable v
Stock #: RFA40913
VIN: 1FTFW3LD8RFA40913

Features

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

Reviews

Joe Machens Volkswagen review

Better than EXCELLENT -- Not just a VW Dealer!

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

2024 Ford F-150 XLT review

Overall, I love my 2024 STX 4x4 Supercrew.

Overall, I love my 2024 STX 4x4 Supercrew. It's comfortable, reliable, and gets great gas mileage with the 2.7 ecoboost. I had one small repair done under warranty that took less than 3 hours and I have over 13k miles on it. My only mild complaints are that the ride could be more forgiving over bumpy pavement and that the turning radius was better.

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

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.

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: Sterling Gray Metallic
Int. color: Jet Black
Drivetrain: Four-wheel Drive
MPG: 18-21
Fuel type: Gasoline
Transmission: Automatic
Engine: TurboMax 2.7L I-4 gasoline direct injection, DOHC, variable valv
Stock #: B21042A1
VIN: 1GCPDBEKXRZ250301

Features

Convenience: Keyless Entry, Keyless Start, Remote Start
Entertainment: Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control

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?

2024 Chevrolet Silverado 1500 Custom review

My 2024 Chevy Silverado LTZ provides a deluxe large SUV

My 2024 Chevy Silverado LTZ provides a deluxe large SUV interior and a standard (short) tuck bed all in one vehicle. It is loaded with features to make it look and operate very well, and it provides mid 20's regular unleaded fuel mileage. The dynamic fuel management system combined with the 10 speed automatic transmission work together flawlessly to deliver smooth power without being able to realize what gear or how many cylinders the powertrain is using at any given time.

Vehicle information

Ext. color: Brilliant Silver Metallic
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 27-37
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 gasoline direct injection, DOHC, CVTCS variable valve c
Stock #: PN415382
VIN: 1N4BL4EV0PN415382

Features

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

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.

2023 Nissan Altima 2.5 SL review

Aesthetically pleasing.

Aesthetically pleasing. Awesome fuel economy!!! Handles well. I used to drive a 2018 Altima SV until a deer decided that i needed to purchase a new vehicle, otherwise, I'd still be driving that one which was totaled at 227k+ miles...190k+ miles by me (personally) in 4 and a half yrs. The front seats feel slightly smaller though....maybe it's just me.

Vehicle information

Ext. color: Northsky Blue Metallic
Int. color: 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 #: MZ257407
VIN: 1GCRYAEH0MZ257407

Features

Convenience: Keyless Entry
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port
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.

2021 Chevrolet Silverado 1500 WT review

2021 LT Trail Boss has great styling, powerful engines,

2021 LT Trail Boss has great styling, powerful engines, and tons of technology in a great package. A commanding view of the road, a nice comfortable interior, amazing Bose Stereo system, tons of storage and tons of space for adults in the crew cab. But there are issues, side mirrors are too small, harsher ride (which I expected), and DFM, GDI engines, and questions on the 10 speed transmissions. I recommend disabling DFM ASAP or using the L9 trick to overide the system, to help prolong the life of the engines from lifter failure. Mine is under warranty for another 18K miles, if it acts up at all its into the dealership for warranty service.

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: Smokey Quartz Metallic
Int. color: Jet Black
Drivetrain: Four-wheel Drive
MPG: 15-20
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 6.2L V8 16V GDI OHV
Stock #: KZ142188
VIN: 1GTP9EEL2KZ142188

Features

Convenience: Cooled Seats, 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, Sunroof/Moonroof, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2019 GMC Sierra 1500 AT4 review

2019 Sierra SLT X31

I purchased a new 2019 SLT with the X1 package. It has the Red Quartz Tintcoat paint. I usually never leave reviews, but honestly this is the most comfortable, nicest loking truck I've owned , and I've ownwd alot of them. The only issues I've had was the brake software was flawed, took it to the dealer on recall and they installed a new software patch, Other then that I love the styling, performance and the interior is very nice. No regrets

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: Radiant Red Metallic
Int. color: Ivory
Drivetrain: Front-wheel Drive
MPG: 30-38
Fuel type: Gasoline
Transmission: Automatic
Engine: 1.5L I-4 gasoline direct injection, DOHC, VTEC variable valve co
Stock #: KA168499
VIN: 1HGCV1F43KA168499

Features

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

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.

2019 Honda Accord EX review

What amazing car that doesn't give any problem what's so

What amazing car that doesn't give any problem what's so ever. I bought mine at westshore honda in tampa. Great amazing people there they treat you like family. My family already bought two more cars from them. In the service department Mr. Kalef Torres my service advisor what a amazing guy he is the knowledge that he knows is beyond this world. I would recommend my family members and friends to him anytime. Keep up the good work.

Vehicle information

Ext. color: Twilight Black
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 22-25
Fuel type: Gasoline
Transmission: Automatic
Engine: Smartstream 2.5L I-4 port/direct injection, DOHC, CVVT variable
Stock #: PH526884
VIN: 5NMS2DAJ2PH526884

Features

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

Reviews

Columbia Honda review

top notch service

After dealing with jeff city, where we bought the Honda, this was a nice surprise. Andrew told me they would work us in and Michelle was very efficient and helpful. All in all, everyone we met was a good ambassador for the business. I was very stressed about this situation and Michelle gave us special treatment and made sure we were taken care of. Jeff city Honda dealearship -- see you in the rear view mirror!

2023 Hyundai SANTA FE SEL 2.4 review

I have owned or leased about 12 new Hyundais and about 40

I have owned or leased about 12 new Hyundais and about 40 new cars in my lifetime. As I am getting on in years and don’t drive that much I think this will be the last car I will own. That said, I am more satisfied with this car than I have ever owned. The only thing that I am not happy with is the push button transmission. I much prefer the conventional shift lever. If something should happen to this car, I would replace it with another exactly like this one. A niggling point is the placement of the charging pad. It is easy to lose something down there but can be retrieved with a shop vac. No big deal.

Vehicle information

Ext. color: Brilliant Black Crystal Pearlcoat
Int. color: Black
Drivetrain: Rear-wheel Drive
MPG: 17-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 5.7L V8 16V MPFI OHV
Stock #: HG745801
VIN: 3C6JR6AT3HG745801

Features

Convenience: Keyless Entry, Navigation System
Entertainment: Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels, Tow Hitch
Safety: Brake Assist, Stability Control

Reviews

2017 RAM 1500 Express review

Outstanding truck Ride quality is best in class as is

Outstanding truck Ride quality is best in class as is fit and finish. Drive a Chevy/gmc/ford and then drive a Ram. Just make sure you get a hemi.

Vehicle information

Ext. color: Quartz White
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 21-27
Fuel type: Gasoline
Transmission: Automatic
Engine: Theta II 2.4L I-4 gasoline direct injection, DOHC, D-CVVT variab
Stock #: LH280230
VIN: 5NMS5CAD9LH280230

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, USB Port
Exterior: Alloy Wheels, Sunroof/Moonroof, Tow Hitch
Safety: 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

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.

2020 Hyundai SANTA FE Limited 2.4 review

Great vehicle

Great SUV ! Worth the price! Very comfortable and smooth riding with excellent fuel mileage on the front wheel drive model ! Will look forward to buying another one !

Vehicle information

Ext. color: White Pearl
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 22-28
Fuel type: Gasoline
Transmission: 8-Speed Automatic with Auto-Shift
Engine: 2.5L I4 16V PDI DOHC Turbo
Stock #: PH526367
VIN: 5NMS44ALXPH526367

Features

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

Reviews

Mazda of Columbia review

Angel Garrett

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

2023 Hyundai SANTA FE Limited review

I have a 2023 Hyundai Santa Fe 2.

I have a 2023 Hyundai Santa Fe 2.5 turbo. I have driven this vehicle for 22500 miles with absolutely no problems rides great and gets 30 plus miles per gallon highway

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

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: Caspian Blue 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 #: NC671863
VIN: 5N1BT3BB9NC671863

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

Joe Machens Volkswagen review

Great to work with!

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

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: Granite Crystal Metallic Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 16-23
Fuel type: Gasoline
Transmission: Automatic
Engine: Pentastar 3.6L V-6 DOHC, variable valve control, regular unleade
Stock #: HS544268
VIN: 1C6RR7FG7HS544268

Features

Convenience: Keyless Entry, Navigation System
Entertainment: Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Brake Assist, Stability Control

Reviews

Joe Machens Volkswagen review

Simply the Best

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

2017 RAM 1500 Tradesman review

My only problem is changing a headlight bulb you need to

My only problem is changing a headlight bulb you need to be a mechanic. Probably one of the hardest to replace on any vehicle. Half to take apart a lot just to get to it. Completely ridiculous.

*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,234 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

Used cars by city

Cars in New Franklin, MO by make

Find great prices on used cars in New Franklin, MO

Fuel types in New Franklin, MO

Dealer inventory in New Franklin, MO

Body styles in New Franklin, MO

[{"applied_filter_criteria":"{\"cpo_indicator\":false,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","vehicle_array":[{"drivetrain":"Front-wheel Drive","nvi_program":false,"interior_color":"Shetland Beige","vin":"1V2WR2CA1PC530162","dealer_zip":"65203","trim":"3.6L SE w/Technology","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Volkswagen:Atlas:3.6L SE w/Technology","vertical_position":1,"dealer_name":"Joe Machens Nissan","exterior_color":"Pure White","cat":"crossover_midsize","year":"2023","relevancy_score":null,"stock_type":"Used","price":"26850","photo_count":28,"model":"Atlas","sponsored":false,"bodystyle":"SUV","certified_preowned":false,"make":"Volkswagen","customer_id":"5363960","cpo_indicator":false,"listing_id":"1cc065bc-7d3d-457f-b195-52d47f08e717","mileage":"70719","cpo_package":null,"msrp":"0","canonical_mmty":"Volkswagen:Atlas:3.6L SE w/Technology:2023","badges":["good_deal"]},{"drivetrain":"Rear-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"1ZVBP8CU0D5236199","dealer_zip":"65203","trim":"Boss 302","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Ford:Mustang:Boss 302","vertical_position":2,"dealer_name":"BMW of Columbia - MO","exterior_color":"Race Red","cat":"coupeconvertible_coupe","year":"2013","relevancy_score":null,"stock_type":"Used","price":"32894","photo_count":32,"model":"Mustang","sponsored":false,"bodystyle":"Coupe","certified_preowned":false,"make":"Ford","customer_id":"152419","cpo_indicator":false,"listing_id":"a04ae507-4d5b-44b5-b862-58bb7e889801","mileage":"42904","cpo_package":null,"msrp":"0","canonical_mmty":"Ford:Mustang:Boss 302:2013","badges":["price_drop_in_cents","good_deal"]},{"drivetrain":"Front-wheel Drive","nvi_program":false,"interior_color":"Charcoal","vin":"1N4BL4EV2RN413409","dealer_zip":"65203","trim":"2.5 SL","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Nissan:Altima:2.5 SL","vertical_position":3,"dealer_name":"Joe Machens Nissan","exterior_color":"Gun Metallic","cat":"sedan_midsize","year":"2024","relevancy_score":null,"stock_type":"Used","price":"26050","photo_count":28,"model":"Altima","sponsored":true,"bodystyle":"Sedan","certified_preowned":true,"make":"Nissan","customer_id":"5363960","cpo_indicator":true,"listing_id":"99f2f102-3fbe-4345-bdce-e4634f476900","mileage":"20347","cpo_package":"Nissan","msrp":"0","canonical_mmty":"Nissan:Altima:2.5 SL:2024","badges":["good_deal","american_made_index_ranking","cpo"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"1C4RJFBG4MC506579","dealer_zip":"65203","trim":"Limited X","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Jeep:Grand Cherokee:Limited X","vertical_position":4,"dealer_name":"Joe Machens Nissan","exterior_color":"Diamond Black Crystal Pearlcoat","cat":"suv_midsize","year":"2021","relevancy_score":null,"stock_type":"Used","price":"27999","photo_count":28,"model":"Grand Cherokee","sponsored":false,"bodystyle":"SUV","certified_preowned":false,"make":"Jeep","customer_id":"5363960","cpo_indicator":false,"listing_id":"a0123b5b-1e78-4e8a-9327-5facde417f9d","mileage":"29433","cpo_package":null,"msrp":"0","canonical_mmty":"Jeep:Grand Cherokee:Limited X:2021","badges":["good_deal"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Black W/Medium Dark Slate","vin":"1FTFW3LD8RFA40913","dealer_zip":"65202","trim":"XLT","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Ford:F-150:XLT","vertical_position":5,"dealer_name":"Joe Machens Volkswagen","exterior_color":"Black Metallic","cat":"truck_fullsize","year":"2024","relevancy_score":null,"stock_type":"Used","price":"40245","photo_count":50,"model":"F-150","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"Ford","customer_id":"5364038","cpo_indicator":false,"listing_id":"5eb66b52-087d-425f-aaf9-5f0d9d16a5af","mileage":"41338","cpo_package":null,"msrp":"0","canonical_mmty":"Ford:F-150:XLT:2024","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Jet Black","vin":"1GCPYJEKXNZ144553","dealer_zip":"65203","trim":"LT","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Chevrolet:Silverado 1500:LT","vertical_position":6,"dealer_name":"Mercedes-Benz of Columbia","exterior_color":"Satin Steel Metallic","cat":"truck_fullsize","year":"2022","relevancy_score":null,"stock_type":"Used","price":"31990","photo_count":33,"model":"Silverado 1500","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"Chevrolet","customer_id":"5243424","cpo_indicator":false,"listing_id":"bc04325c-1caa-41e2-958c-248ec9c6e1d8","mileage":"54963","cpo_package":null,"msrp":"0","canonical_mmty":"Chevrolet:Silverado 1500:LT:2022","badges":["good_deal"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Jet Black","vin":"1GCPDBEKXRZ250301","dealer_zip":"65203","trim":"Custom","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Chevrolet:Silverado 1500:Custom","vertical_position":7,"dealer_name":"BMW of Columbia - MO","exterior_color":"Sterling Gray Metallic","cat":"truck_fullsize","year":"2024","relevancy_score":null,"stock_type":"Used","price":"39997","photo_count":34,"model":"Silverado 1500","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"Chevrolet","customer_id":"152419","cpo_indicator":false,"listing_id":"6f79eca3-94e7-4727-aac5-b1cf1264ac15","mileage":"12766","cpo_package":null,"msrp":"0","canonical_mmty":"Chevrolet:Silverado 1500:Custom:2024","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"]},{"drivetrain":"Front-wheel Drive","nvi_program":false,"interior_color":"Charcoal","vin":"1N4BL4EV0PN415382","dealer_zip":"65202","trim":"2.5 SL","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Nissan:Altima:2.5 SL","vertical_position":8,"dealer_name":"Columbia Honda","exterior_color":"Brilliant Silver Metallic","cat":"sedan_midsize","year":"2023","relevancy_score":null,"stock_type":"Used","price":"20700","photo_count":6,"model":"Altima","sponsored":false,"bodystyle":"Sedan","certified_preowned":false,"make":"Nissan","customer_id":"5354599","cpo_indicator":false,"listing_id":"1d82a13c-c355-4fea-a5b4-61db2e8088ac","mileage":"69373","cpo_package":null,"msrp":"0","canonical_mmty":"Nissan:Altima:2.5 SL:2023","badges":["great_deal"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"1GCRYAEH0MZ257407","dealer_zip":"65202","trim":"WT","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Chevrolet:Silverado 1500:WT","vertical_position":9,"dealer_name":"Joe Machens Volkswagen","exterior_color":"Northsky Blue Metallic","cat":"truck_fullsize","year":"2021","relevancy_score":null,"stock_type":"Used","price":"23713","photo_count":17,"model":"Silverado 1500","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"Chevrolet","customer_id":"5364038","cpo_indicator":false,"listing_id":"9e053be1-3b88-41ff-9733-e0dfdba1b0e0","mileage":"93487","cpo_package":null,"msrp":"0","canonical_mmty":"Chevrolet:Silverado 1500:WT:2021","badges":["good_deal"]},{"drivetrain":"All-wheel Drive","nvi_program":false,"interior_color":"Charcoal","vin":"5N1BT3BB2PC849163","dealer_zip":"65202","trim":"SV","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Nissan:Rogue:SV","vertical_position":10,"dealer_name":"Columbia Honda","exterior_color":"Super Black","cat":"crossover_compact","year":"2023","relevancy_score":null,"stock_type":"Used","price":"22700","photo_count":34,"model":"Rogue","sponsored":false,"bodystyle":"SUV","certified_preowned":false,"make":"Nissan","customer_id":"5354599","cpo_indicator":false,"listing_id":"46a18024-4c2d-4440-a098-a0917c102569","mileage":"47028","cpo_package":null,"msrp":"0","canonical_mmty":"Nissan:Rogue:SV:2023","badges":["price_drop_in_cents","good_deal"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Jet Black","vin":"1GTP9EEL2KZ142188","dealer_zip":"65203","trim":"AT4","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"GMC:Sierra 1500:AT4","vertical_position":11,"dealer_name":"Joe Machens Ford","exterior_color":"Smokey Quartz Metallic","cat":"truck_fullsize","year":"2019","relevancy_score":null,"stock_type":"Used","price":"35922","photo_count":30,"model":"Sierra 1500","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"GMC","customer_id":"6039707","cpo_indicator":false,"listing_id":"128d85e4-acb1-4a31-9b3c-126932c5b446","mileage":"91250","cpo_package":null,"msrp":null,"canonical_mmty":"GMC:Sierra 1500:AT4:2019","badges":["price_drop_in_cents","good_deal"]},{"drivetrain":"Front-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"4T1S31AKXNU595344","dealer_zip":"65202","trim":"SE","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Hybrid","stock_sub":"","canonical_mmt":"Toyota:Camry:SE","vertical_position":12,"dealer_name":"Columbia Honda","exterior_color":"Predawn Gray Mica","cat":"sedan_midsize","year":"2022","relevancy_score":null,"stock_type":"Used","price":"20000","photo_count":33,"model":"Camry","sponsored":false,"bodystyle":"Sedan","certified_preowned":false,"make":"Toyota","customer_id":"5354599","cpo_indicator":false,"listing_id":"871681dd-8058-4d35-bfce-624257536515","mileage":"100174","cpo_package":null,"msrp":"0","canonical_mmty":"Toyota:Camry:SE:2022","badges":["price_drop_in_cents","good_deal","hot_car"]},{"drivetrain":"Front-wheel Drive","nvi_program":false,"interior_color":"Ivory","vin":"1HGCV1F43KA168499","dealer_zip":"65202","trim":"EX","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Honda:Accord:EX","vertical_position":13,"dealer_name":"Columbia Honda","exterior_color":"Radiant Red Metallic","cat":"sedan_midsize","year":"2019","relevancy_score":null,"stock_type":"Used","price":"24000","photo_count":6,"model":"Accord","sponsored":false,"bodystyle":"Sedan","certified_preowned":false,"make":"Honda","customer_id":"5354599","cpo_indicator":false,"listing_id":"9cdd5664-1654-4e04-be90-743a9bbfe6e9","mileage":"12773","cpo_package":null,"msrp":"0","canonical_mmty":"Honda:Accord:EX:2019","badges":["good_deal","hot_car"]},{"drivetrain":"All-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"5NMS2DAJ2PH526884","dealer_zip":"65202","trim":"SEL 2.4","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Hyundai:SANTA FE:SEL 2.4","vertical_position":14,"dealer_name":"Columbia Honda","exterior_color":"Twilight Black","cat":"crossover_midsize","year":"2023","relevancy_score":null,"stock_type":"Used","price":"21200","photo_count":6,"model":"SANTA FE","sponsored":false,"bodystyle":"SUV","certified_preowned":false,"make":"Hyundai","customer_id":"5354599","cpo_indicator":false,"listing_id":"9bf7d872-fbea-445b-ad7d-c858f2eb9b07","mileage":"69646","cpo_package":null,"msrp":"0","canonical_mmty":"Hyundai:SANTA FE:SEL 2.4:2023","badges":["great_deal"]},{"drivetrain":"Rear-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"3C6JR6AT3HG745801","dealer_zip":"65203","trim":"Express","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"RAM:1500:Express","vertical_position":15,"dealer_name":"Joe Machens Ford","exterior_color":"Brilliant Black Crystal Pearlcoat","cat":"truck_fullsize","year":"2017","relevancy_score":null,"stock_type":"Used","price":"24895","photo_count":30,"model":"1500","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"RAM","customer_id":"6039707","cpo_indicator":false,"listing_id":"9ded1fa6-b630-4ff6-ad27-c15ec4066236","mileage":"74002","cpo_package":null,"msrp":null,"canonical_mmty":"RAM:1500:Express:2017","badges":["price_drop_in_cents","fair_deal","hot_car"]},{"drivetrain":"All-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"5NMS5CAD9LH280230","dealer_zip":"65202","trim":"Limited 2.4","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Hyundai:SANTA FE:Limited 2.4","vertical_position":16,"dealer_name":"Joe Machens Volkswagen","exterior_color":"Quartz White","cat":"crossover_midsize","year":"2020","relevancy_score":null,"stock_type":"Used","price":"17377","photo_count":6,"model":"SANTA FE","sponsored":false,"bodystyle":"SUV","certified_preowned":false,"make":"Hyundai","customer_id":"5364038","cpo_indicator":false,"listing_id":"e31e5d41-3335-4e67-819b-a67bb2dd3f7a","mileage":"112150","cpo_package":null,"msrp":"0","canonical_mmty":"Hyundai:SANTA FE:Limited 2.4:2020","badges":["price_drop_in_cents","great_deal"]},{"drivetrain":"Front-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"5NMS44ALXPH526367","dealer_zip":"65202","trim":"Limited","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Hyundai:SANTA FE:Limited","vertical_position":17,"dealer_name":"Mazda of Columbia","exterior_color":"White Pearl","cat":"crossover_midsize","year":"2023","relevancy_score":null,"stock_type":"Used","price":"24400","photo_count":29,"model":"SANTA FE","sponsored":false,"bodystyle":"SUV","certified_preowned":false,"make":"Hyundai","customer_id":"5364156","cpo_indicator":false,"listing_id":"910f8bd7-87bf-4ef1-9c4a-2ac6df95eda5","mileage":"70257","cpo_package":null,"msrp":null,"canonical_mmty":"Hyundai:SANTA FE:Limited:2023","badges":["great_deal"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Alpine Umber","vin":"1GTUUHET4NZ630498","dealer_zip":"65203","trim":"Denali Ultimate","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Diesel","stock_sub":"","canonical_mmt":"GMC:Sierra 1500:Denali Ultimate","vertical_position":18,"dealer_name":"BMW of Columbia - MO","exterior_color":"White Frost Tricoat","cat":"truck_fullsize","year":"2022","relevancy_score":null,"stock_type":"Used","price":"56372","photo_count":36,"model":"Sierra 1500","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"GMC","customer_id":"152419","cpo_indicator":false,"listing_id":"f6b8241e-e7fd-4c98-9cc2-ad2c98fe362f","mileage":"46369","cpo_package":null,"msrp":"0","canonical_mmty":"GMC:Sierra 1500:Denali Ultimate:2022","badges":["fair_deal"]},{"drivetrain":"All-wheel Drive","nvi_program":false,"interior_color":"Charcoal","vin":"5N1BT3BB9NC671863","dealer_zip":"65202","trim":"SV","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"Nissan:Rogue:SV","vertical_position":19,"dealer_name":"Joe Machens Volkswagen","exterior_color":"Caspian Blue Metallic","cat":"crossover_compact","year":"2022","relevancy_score":null,"stock_type":"Used","price":"21581","photo_count":6,"model":"Rogue","sponsored":false,"bodystyle":"SUV","certified_preowned":false,"make":"Nissan","customer_id":"5364038","cpo_indicator":false,"listing_id":"1fb061cb-19e2-4868-90f2-995ec4c79e53","mileage":"63580","cpo_package":null,"msrp":"0","canonical_mmty":"Nissan:Rogue:SV:2022","badges":["good_deal"]},{"drivetrain":"Four-wheel Drive","nvi_program":false,"interior_color":"Black","vin":"1C6RR7FG7HS544268","dealer_zip":"65202","trim":"Tradesman","seller_type":"dealership","sponsored_type":"standard","fuel_type":"Gasoline","stock_sub":"","canonical_mmt":"RAM:1500:Tradesman","vertical_position":20,"dealer_name":"Joe Machens Volkswagen","exterior_color":"Granite Crystal Metallic Clearcoat","cat":"truck_fullsize","year":"2017","relevancy_score":null,"stock_type":"Used","price":"20039","photo_count":9,"model":"1500","sponsored":false,"bodystyle":"Truck","certified_preowned":false,"make":"RAM","customer_id":"5364038","cpo_indicator":false,"listing_id":"26e87a05-b2fb-4f1b-9431-5ec32c98dc82","mileage":"75526","cpo_package":null,"msrp":"0","canonical_mmty":"RAM:1500:Tradesman:2017","badges":["great_deal"]}],"sponsored_type_eligible":["inventory_ad"]}]