Skip to main content

Contact seller

Contact seller

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

We value your privacy. Cars.com Privacy Notice

Customize your budget

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

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

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

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

Used cars for sale near New Bloomfield, MO under $199,993

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

Save your search and get notified when new inventory arrives.

Prequalify now

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

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

Certified

2025 Chevrolet Trax FWD ACTIV

7,244 mi.
$23,800
Joe Machens Capital City Ford
(7,799 reviews)
Jefferson City, MO
Sponsored

Used

2017 Toyota Yaris iA Base

91,773 mi.
$10,800
Joe Machens Capital City Ford
(7,799 reviews)
Jefferson City, MO

Vehicle information

Ext. color: Matador Red Mica
Int. color: Parchment
Drivetrain: All-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.5L V6 24V PDI DOHC
Stock #: KC190472
VIN: 2T2BZMCA3KC190472

Features

Convenience: Adaptive Cruise Control, Keyless Entry, Keyless Start, Power Liftgate
Entertainment: Bluetooth®, CD Player, HomeLink, Satellite Radio, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Lane Departure Warning, Rain Sensing Wipers, Stability Control

Reviews

2019 Lexus RX 350 350 review

A great car for the money

This is my second RX and I’m so happy with the first, I need to get one again. The size is right for a woman, not to high nor low. Perfect for young and the old. I would have opted for the 2021 model if I’m not retired. The salesperson gave us a great deal we can’t refuse. This car will definitely take me to many places in style, comfort and value.

Vehicle information

Ext. color: Galaxy Silver Metallic
Int. color: Light Neutral/Ebony Accents
Drivetrain: Front-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: JD083546
VIN: LRBFX1SA3JD083546

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
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

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.

2018 Buick Envision Essence review

Bought the Envision new and paid I THOUGHT, TO MUCH AT

Bought the Envision new and paid I THOUGHT, TO MUCH AT $48,000. BUT TO DATE OTHER THAN TIRES & OIL CHANGES IT HAS BEEN FLAWLESS AND HAS COST ME ZERO IN MAINTENANCE at 48,000 miles. Great acceleration & comfort. Down side would be no off button for battery stop.

Vehicle information

Ext. color: Shadow Black
Int. color: Ebony
Drivetrain: Rear-wheel Drive
MPG: 21-30
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 2.3L I4 16V GDI DOHC Turbo
Stock #: L5170079
VIN: 1FA6P8TH5L5170079

Features

Convenience: Keyless Entry, Keyless Start
Entertainment: Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Stability Control

Reviews

2020 Ford Mustang EcoBoost review

It's a hot rod!

I love this car. So many mods can be done to make it your own and unique to you. Move currently produces more hp than a stock GT 350. The looks and performance are outstanding for a car in this price range. My only gripes are that occasionally one of the mirrors (actually happens on both sides just not at the same time) will go all the way in one direction until it can't go anymore then click constantly until you press that mirror and touch the manual adjust button. Then you can hit your pre set of you have one and everything will be fine. It's always when I unlock the car to get in that this happens and it's totally random. If course the dealer can never find anything wrong with it. My other gripe was that on occasion it wouldn't recognize my fob. The only way I could start the car was to lift up the cup holder mat and stick the fob in the slot. But then if I went somewhere and turned the car off, it would be fine. Again totally weird and random. Overall though, I wouldn't give this car up for anything. So much fun to drive, and the sound of that V8 exhaust just gets the blood flowing. Not to mention the all the looks you'll get from people.

Vehicle information

Ext. color: Magnetic Gray Metallic
Int. color: Cement
Drivetrain: Four-wheel Drive
MPG: 17-20
Fuel type: Gasoline
Transmission: Manual
Engine: 3.5L V-6 port/direct injection, DOHC, variable valve control, re
Stock #: MU8240
VIN: 5TFCZ5AN8LX236529

Features

Convenience: Adaptive Cruise Control, Keyless Entry
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, Lane Departure Warning, Rear Cross Traffic Alert, 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.

2020 Toyota Tacoma TRD Off Road review

I love my Tacoma.

I love my Tacoma. I've always been a GMC person, but wasn't happy with their smaller pickup options. I made the jump to a Tacoma and I've already driven it across the country. I was very comfortable, extremely happy with performance.

Vehicle information

Ext. color: Machine Gray Metallic
Int. color: Red
Drivetrain: Front-wheel Drive
MPG: 26-35
Fuel type: Gasoline
Transmission: Automatic
Engine: SKYACTIV-G 2.5L I-4 gasoline direct injection, DOHC, variable va
Stock #: L1161710
VIN: JM1BPANM5L1161710

Features

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

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.

2020 Mazda Mazda3 FWD w/Premium Package review

This is no luxury car but if you are looking for a

This is no luxury car but if you are looking for a smaller car with great reliabilty and lower maintenance costs this is a great option. I am a petite female and the car is quite comfortable for me. I drive 18 miles one way into Minneapolis and the ride is enjoyable enough. This is my 2nd Mazda 3, ironically same color as my previous only because of availabilty. This model year all wheel drive was available and served me well in our Minnesota winters. Standard safety features are appreciated. I don't need all the bells and whistles but I do like connecting my phone to my car.

Vehicle information

Ext. color: Summit White
Int. color: Black
Drivetrain: Rear-wheel Drive
MPG: 18-21
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.7L I4 16V GDI DOHC Turbo
Stock #: SG339731
VIN: 3GCNAAEK9SG339731

Features

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

Reviews

2025 Chevrolet Silverado 1500 WT review

Love this car.

Love this car. I wish there was more to the interior though, as it is pretty plain and nothing extraordinary. If they had the bigger infotainment screen for the front bench seat it would have a gotten that one. This car over all is great bang for the buck.

Vehicle information

Ext. color: Steel Graphite
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: Automatic
Engine: Lambda II 3.8L V-6 gasoline direct injection, DOHC, D-CVVT varia
Stock #: SU845981
VIN: KM8R2DGE9SU845981

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

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.

2025 Hyundai PALISADE SEL review

We love our new vehicle!

We love our new vehicle!! Very comfortable and it drives great!! Tons of room. Safety features are perfect. We are extremely happy with our purchase

Vehicle information

Ext. color: Shimmering Silver Pearl
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 25-28
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.5L I4 16V PDI DOHC
Stock #: PH570617
VIN: 5NMS24AJ1PH570617

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control

Reviews

2023 Hyundai SANTA FE SEL 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: Pearl White Tri-Coat
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L I4 16V GDI DOHC
Stock #: MC784197
VIN: 5N1AT3BB1MC784197

Features

Convenience: Adaptive Cruise Control, Keyless Entry, Keyless Start, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Stability Control

Reviews

2021 Nissan Rogue SV review

This 2021 Nissan Rogue SL is a great car.

This 2021 Nissan Rogue SL is a great car. It is very comfortable and loaded with features. I am very pleased with fuel efficiency. There has been no problems to report since I bought this car.

Vehicle information

Ext. color: Ceramic Metallic
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 27-37
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.5L I4 16V GDI DOHC
Stock #: SM470155
VIN: 3MZBPABMXSM470155

Features

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

Reviews

Mazda of Columbia review

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!

Vehicle information

Ext. color: Brass
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: 8-Speed Automatic with Auto-Shift
Engine: 2.5L I4 16V PDI DOHC Turbo
Stock #: 143191A
VIN: 5NMP3DGL9RH023965

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

Jim Butler Linn Chevrolet review

rleeperrjl@yahoo.com

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

2024 Hyundai SANTA FE XRT review

Performance is not what I expected though.

Performance is not what I expected though. But everything else is very nice and smooth ride. I would buy again until the day I die.

Vehicle information

Ext. color: Red Candy Metallic Tinted Clearcoat
Int. color: Tan/Camel
Drivetrain: Four-wheel Drive
MPG: 14-18
Fuel type: E85 Flex Fuel
Transmission: Automatic
Engine: Triton 5.4L V-8 variable valve control, engine with 310HP
Stock #: AFC78270
VIN: 1FTFW1EV0AFC78270

Features

Convenience: Keyless Entry
Entertainment: CD Player
Exterior: Alloy Wheels, Tow Hooks
Safety: Stability Control

Reviews

Joe Machens Capital City Ford review

Great!

Great! Couldn’t be happier. Very Easy transaction. Extremely knowledgeable and no car dealer up selling just perfect

2010 Ford F-150 XLT review

I use to own a 2003 f150 for 18 years it was great except

I use to own a 2003 f150 for 18 years it was great except for fuel milage, when I purchased this truck in 2024 , the rear window leaks but only when it rains hard, overall I refuse to drive any other truck.

Vehicle information

Ext. color: Billet Silver Metallic Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.6L V6 24V VVT
Stock #: JC151678
VIN: 1C4RJFCG2JC151678

Features

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

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.

2018 Jeep Grand Cherokee High Altitude review

Because it a great car because the car has 118k miles on

Because it a great car because the car has 118k miles on it and its only 15,371 dollars and its used and works very well

Vehicle information

Ext. color: Flame Red Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 15-21
Fuel type: Gasoline
Transmission: Automatic
Engine: HEMI 5.7L V-8 variable valve control, regular unleaded, engine w
Stock #: MU8189B
VIN: 1C6SRFJT8NN145136

Features

Convenience: 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, Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Mercedes-Benz of Columbia review

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

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

2022 RAM 1500 Laramie review

Purchased in 2023, new.

Purchased in 2023, new. Had to go back one year to find one without e-torque. Test drove & didn't like it. Right now I have 30,000 trouble free miles on it. I just hope my luck with that last. I have been a GM owner all my life, with two Fords threw in which didn't impress mr at all. I was dissatisfied with my 2010 GMC so I decided to try Ram. I bought a 2017 Bighorn with the 3.6 V6 & was totally happy. 70,000 trouble free miles. I planned on keeping that truck much longer, but, at my age, decided to give it one more shot, so i bought the 2022 with the 5.7 V8. Didn't need the xtra power but decided I'd go for broke. I'm 82, so I'm planning this to be my last truck. I have owned pickups only since 1967, never had any use for a car.

Vehicle information

Ext. color: Patriot Blue Pearlcoat
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 #: KS658607
VIN: 1C6RR7FG4KS658607

Features

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

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.

2019 RAM 1500 Tradesman review

I'm original owner sence 2018 when I purchased tge 2019

I'm original owner sence 2018 when I purchased tge 2019 rebel, crew cab, 4wd 5.7 hemi. I now have 35k miles and have to say this truck has been the best truck I've ever owned. I've owned several in 45 years but this is my retirement best truck. The ride is phenomenal on road and off road. Plenty of HP, pulls well and most reliable. The stock tires duratrac by goodyear make a good ride but not as good in wet roads. Leather interior, heated auto seats, large GPS screen are a good touch by dodge. I've been tough on the factory coated bed liner and no ware showing. It's a tough fun to drive truck.

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 #: RC698659
VIN: 5N1BT3BB5RC698659

Features

Convenience: Adaptive Cruise Control, Keyless Entry, Keyless Start, Power Liftgate, 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.

2024 Nissan Rogue SV review

I've owed the rogue SV for some 9 months and I'm very

I've owed the rogue SV for some 9 months and I'm very pleased with the ride, performance and reliability . Prior to me purchased this car I rented a bunch of competitors to narrow down my choice. The Rogue has alot of features that really come in handy. It's a very thought out vehicle. On long highway trips it holds the road very steadily at 90 MPH and my gas consumption was in the low 40's. For the money to me it's the best value out there

Vehicle information

Ext. color: Crimson Red Pearl
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L H4 16V GDI DOHC
Stock #: NH486640
VIN: JF2SKAEC0NH486640

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry
Entertainment: Apple CarPlay®, Bluetooth®, CD Player, Satellite Radio, USB Port
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Lane Departure Warning, Stability Control

Reviews

Mazda of Columbia review

Joe Machens Mazda

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

2022 Subaru Forester Premium review

Beyond Satisfied!

This is my third Subaru Forrester. I like the newer safety features and ease of handling. The size is perfect for me, not too small or too big! I would recommend if you’re looking for a midsize vehicle.

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

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.

2023 Hyundai SANTA FE SEL 2.4 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 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

lartiquefreeman2206@yahoo.com

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

2023 Hyundai SANTA FE Limited review

Cannot reach under the console, Blindspot on the

Cannot reach under the console, Blindspot on the passenger side and seats are not very comfortable. Otherwise, the car is a very nice car and has decent pick up power for just the four-cylinder.

Vehicle information

Ext. color: Billet Silver Metallic Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.6L V6 24V MPFI DOHC
Stock #: 156709A
VIN: 1C4RJFBG1LC207761

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Jim Butler Linn Chevrolet review

We were very happy with the sales and the whole

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

2020 Jeep Grand Cherokee Limited review

Snow commuter

I've been driving for 43 years now and have owned an array of different vehicles, however I've never been financially fortunate to purchase a luxury model - until now! I was looking for a mid size vehicle that would check many boxes for my snowy Michigan commutes, along with distant travel comfort to and from my cabin and some towing capacity. I have only had this for roughly 1500 miles and wow.. My first impression was luxury. So many base options included in a mid sized and mid priced SUV that pleasantly surprised me. Secondly was the ride quality. Both smooth and quiet and handling. I've read other reviews discussing power inadequacy, but not at all. Plenty of passing and get tup to speed power. Next was the snow. I have Michelin defender tires and wow - what have I been missing? The snow 4x4 duaratac features combined with these tires make this a beast in the snow, slush and rain. It definitely gives me a much more safety reassurance while driving in these conditions. I have not tried the towing yet and have not had any "reliable" issues to report, but we are very fortunate with our pick and one very capable snow commuter.

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

Cars under $199,993 in New Bloomfield, MO by make

Find great prices by city

Find great prices on used cars in New Bloomfield, MO

Used cars by body style and price

[{"applied_filter_criteria":"{\"cpo_indicator\":false,\"max_price_range\":199993,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"interior_color":"Jet Black w/Artemis Accents","photo_count":23,"cpo_package":"Ford Blue Advantage Blue","bodystyle":"SUV","trim":"FWD ACTIV","vin":"KL77LKEP6SC268914","fuel_type":"Gasoline","model":"Trax","price":"23800","stock_type":"Used","stock_sub":"","canonical_mmt":"Chevrolet:Trax:FWD ACTIV","msrp":"0","dealer_name":"Joe Machens Capital City Ford","year":"2025","sponsored_type":"inventory_ad","relevancy_score":null,"mileage":"7244","cpo_indicator":true,"dealer_zip":"65109","listing_id":"be201f79-c945-4edf-838b-9bae635d696a","cat":"crossover_compact","make":"Chevrolet","badges":["good_deal","cpo"],"drivetrain":"Front-wheel Drive","customer_id":"5363977","nvi_program":false,"seller_type":"dealership","sponsored":true,"vertical_position":1,"certified_preowned":true,"exterior_color":"Summit White","canonical_mmty":"Chevrolet:Trax:FWD ACTIV:2025"},{"interior_color":"Mid Blue Black","photo_count":9,"cpo_package":null,"bodystyle":"Sedan","trim":"Base","vin":"3MYDLBYV3HY182199","fuel_type":"Gasoline","model":"Yaris iA","price":"10800","stock_type":"Used","stock_sub":"","canonical_mmt":"Toyota:Yaris iA:Base","msrp":"0","dealer_name":"Joe Machens Capital City Ford","year":"2017","sponsored_type":"inventory_ad","relevancy_score":null,"mileage":"91773","cpo_indicator":false,"dealer_zip":"65109","listing_id":"934d13ef-96ea-4188-b1ae-6d49bca3dbfd","cat":"sedan_compact","make":"Toyota","badges":["great_deal","hot_car"],"drivetrain":"Front-wheel Drive","customer_id":"5363977","nvi_program":false,"seller_type":"dealership","sponsored":true,"vertical_position":2,"certified_preowned":false,"exterior_color":"Sapphire","canonical_mmty":"Toyota:Yaris iA:Base:2017"},{"interior_color":"Parchment","photo_count":25,"cpo_package":null,"bodystyle":"SUV","trim":"350","vin":"2T2BZMCA3KC190472","fuel_type":"Gasoline","model":"RX 350","price":"31955","stock_type":"Used","stock_sub":"","canonical_mmt":"Lexus:RX 350:350","msrp":null,"dealer_name":"Joe Machens Ford","year":"2019","sponsored_type":"standard","relevancy_score":null,"mileage":"49598","cpo_indicator":false,"dealer_zip":"65203","listing_id":"1a81b9db-c9bf-4358-8019-5dfa66e316c2","cat":"luxurysuv_crossover","make":"Lexus","badges":["good_deal"],"drivetrain":"All-wheel Drive","customer_id":"6039707","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":3,"certified_preowned":false,"exterior_color":"Matador Red Mica","canonical_mmty":"Lexus:RX 350:350:2019"},{"interior_color":"Light Neutral/Ebony Accents","photo_count":11,"cpo_package":null,"bodystyle":"SUV","trim":"Essence","vin":"LRBFX1SA3JD083546","fuel_type":"Gasoline","model":"Envision","price":"14500","stock_type":"Used","stock_sub":"","canonical_mmt":"Buick:Envision:Essence","msrp":"0","dealer_name":"Columbia Honda","year":"2018","sponsored_type":"standard","relevancy_score":null,"mileage":"89985","cpo_indicator":false,"dealer_zip":"65202","listing_id":"be67df70-1bf2-4e6e-90c8-c1464df31887","cat":"luxurysuv_crossover","make":"Buick","badges":["good_deal"],"drivetrain":"Front-wheel Drive","customer_id":"5354599","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":4,"certified_preowned":false,"exterior_color":"Galaxy Silver Metallic","canonical_mmty":"Buick:Envision:Essence:2018"},{"interior_color":"Ebony","photo_count":17,"cpo_package":null,"bodystyle":"Coupe","trim":"EcoBoost","vin":"1FA6P8TH5L5170079","fuel_type":"Gasoline","model":"Mustang","price":"19109","stock_type":"Used","stock_sub":"","canonical_mmt":"Ford:Mustang:EcoBoost","msrp":null,"dealer_name":"Joe Machens Ford","year":"2020","sponsored_type":"standard","relevancy_score":null,"mileage":"69739","cpo_indicator":false,"dealer_zip":"65203","listing_id":"c01b5e03-d1dc-4080-a64b-5267be111b0a","cat":"coupeconvertible_coupe","make":"Ford","badges":["good_deal"],"drivetrain":"Rear-wheel Drive","customer_id":"6039707","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":5,"certified_preowned":false,"exterior_color":"Shadow Black","canonical_mmty":"Ford:Mustang:EcoBoost:2020"},{"interior_color":"Cement","photo_count":33,"cpo_package":null,"bodystyle":"Truck","trim":"TRD Off Road","vin":"5TFCZ5AN8LX236529","fuel_type":"Gasoline","model":"Tacoma","price":"31899","stock_type":"Used","stock_sub":"","canonical_mmt":"Toyota:Tacoma:TRD Off Road","msrp":"0","dealer_name":"Mercedes-Benz of Columbia","year":"2020","sponsored_type":"standard","relevancy_score":null,"mileage":"91589","cpo_indicator":false,"dealer_zip":"65203","listing_id":"33834534-fcce-433c-a833-1503bee2c696","cat":"truck_compact","make":"Toyota","badges":["good_deal"],"drivetrain":"Four-wheel Drive","customer_id":"5243424","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":6,"certified_preowned":false,"exterior_color":"Magnetic Gray Metallic","canonical_mmty":"Toyota:Tacoma:TRD Off Road:2020"},{"interior_color":"Red","photo_count":6,"cpo_package":null,"bodystyle":"Hatchback","trim":"FWD w/Premium Package","vin":"JM1BPANM5L1161710","fuel_type":"Gasoline","model":"Mazda3","price":"18273","stock_type":"Used","stock_sub":"","canonical_mmt":"Mazda:Mazda3:FWD w/Premium Package","msrp":"0","dealer_name":"Joe Machens Volkswagen","year":"2020","sponsored_type":"standard","relevancy_score":null,"mileage":"76651","cpo_indicator":false,"dealer_zip":"65202","listing_id":"321e7005-97ff-4992-9bfd-9b9674db3dfa","cat":"sedan_compact","make":"Mazda","badges":["good_deal"],"drivetrain":"Front-wheel Drive","customer_id":"5364038","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":7,"certified_preowned":false,"exterior_color":"Machine Gray Metallic","canonical_mmty":"Mazda:Mazda3:FWD w/Premium Package:2020"},{"interior_color":"Black","photo_count":30,"cpo_package":null,"bodystyle":"Truck","trim":"WT","vin":"3GCNAAEK9SG339731","fuel_type":"Gasoline","model":"Silverado 1500","price":"31367","stock_type":"Used","stock_sub":"","canonical_mmt":"Chevrolet:Silverado 1500:WT","msrp":null,"dealer_name":"Joe Machens Ford","year":"2025","sponsored_type":"standard","relevancy_score":null,"mileage":"2919","cpo_indicator":false,"dealer_zip":"65203","listing_id":"3b38d32d-93f0-4522-85e3-13a410de6860","cat":"truck_fullsize","make":"Chevrolet","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"drivetrain":"Rear-wheel Drive","customer_id":"6039707","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":8,"certified_preowned":false,"exterior_color":"Summit White","canonical_mmty":"Chevrolet:Silverado 1500:WT:2025"},{"interior_color":"Black","photo_count":50,"cpo_package":null,"bodystyle":"SUV","trim":"SEL","vin":"KM8R2DGE9SU845981","fuel_type":"Gasoline","model":"PALISADE","price":"33085","stock_type":"Used","stock_sub":"","canonical_mmt":"Hyundai:PALISADE:SEL","msrp":"0","dealer_name":"Joe Machens Volkswagen","year":"2025","sponsored_type":"standard","relevancy_score":null,"mileage":"40390","cpo_indicator":false,"dealer_zip":"65202","listing_id":"450115b1-c958-4777-8428-601dd5c7dd0b","cat":"crossover_midsize","make":"Hyundai","badges":["price_drop_in_cents","good_deal","2025_award_winner"],"drivetrain":"All-wheel Drive","customer_id":"5364038","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":9,"certified_preowned":false,"exterior_color":"Steel Graphite","canonical_mmty":"Hyundai:PALISADE:SEL:2025"},{"interior_color":"Black","photo_count":29,"cpo_package":null,"bodystyle":"SUV","trim":"SEL","vin":"5NMS24AJ1PH570617","fuel_type":"Gasoline","model":"SANTA FE","price":"21221","stock_type":"Used","stock_sub":"","canonical_mmt":"Hyundai:SANTA FE:SEL","msrp":null,"dealer_name":"Joe Machens Ford","year":"2023","sponsored_type":"standard","relevancy_score":null,"mileage":"53802","cpo_indicator":false,"dealer_zip":"65203","listing_id":"7bcb0321-aab9-403b-b111-4cb4ff95b39d","cat":"crossover_midsize","make":"Hyundai","badges":["good_deal"],"drivetrain":"Front-wheel Drive","customer_id":"6039707","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":10,"certified_preowned":false,"exterior_color":"Shimmering Silver Pearl","canonical_mmty":"Hyundai:SANTA FE:SEL:2023"},{"interior_color":"Charcoal","photo_count":21,"cpo_package":null,"bodystyle":"SUV","trim":"SV","vin":"5N1AT3BB1MC784197","fuel_type":"Gasoline","model":"Rogue","price":"16767","stock_type":"Used","stock_sub":"","canonical_mmt":"Nissan:Rogue:SV","msrp":null,"dealer_name":"Joe Machens Ford","year":"2021","sponsored_type":"standard","relevancy_score":null,"mileage":"131493","cpo_indicator":false,"dealer_zip":"65203","listing_id":"b6e44d25-579f-444e-a1b4-ac449f97457d","cat":"crossover_compact","make":"Nissan","badges":["good_deal"],"drivetrain":"All-wheel Drive","customer_id":"6039707","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":11,"certified_preowned":false,"exterior_color":"Pearl White Tri-Coat","canonical_mmty":"Nissan:Rogue:SV:2021"},{"interior_color":"Black","photo_count":27,"cpo_package":null,"bodystyle":"Sedan","trim":"FWD w/Select Package","vin":"3MZBPABMXSM470155","fuel_type":"Gasoline","model":"Mazda3","price":"23700","stock_type":"Used","stock_sub":"","canonical_mmt":"Mazda:Mazda3:FWD w/Select Package","msrp":null,"dealer_name":"Mazda of Columbia","year":"2025","sponsored_type":"standard","relevancy_score":null,"mileage":"450","cpo_indicator":false,"dealer_zip":"65202","listing_id":"6c86cf72-31e4-4555-bb95-b3429383f23f","cat":"sedan_compact","make":"Mazda","badges":["great_deal"],"drivetrain":"Front-wheel Drive","customer_id":"5364156","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":12,"certified_preowned":false,"exterior_color":"Ceramic Metallic","canonical_mmty":"Mazda:Mazda3:FWD w/Select Package:2025"},{"interior_color":"Black","photo_count":33,"cpo_package":null,"bodystyle":"SUV","trim":"XRT","vin":"5NMP3DGL9RH023965","fuel_type":"Gasoline","model":"SANTA FE","price":"33558","stock_type":"Used","stock_sub":"","canonical_mmt":"Hyundai:SANTA FE:XRT","msrp":null,"dealer_name":"Jim Butler Linn Chevrolet","year":"2024","sponsored_type":"standard","relevancy_score":null,"mileage":"25000","cpo_indicator":false,"dealer_zip":"65051","listing_id":"1ba29282-09c0-4be2-8ed6-7082401a477f","cat":"crossover_midsize","make":"Hyundai","badges":["good_deal","american_made_index_ranking"],"drivetrain":"All-wheel Drive","customer_id":"5363686","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":13,"certified_preowned":false,"exterior_color":"Brass","canonical_mmty":"Hyundai:SANTA FE:XRT:2024"},{"interior_color":"Tan/Camel","photo_count":9,"cpo_package":null,"bodystyle":"Truck","trim":"XLT","vin":"1FTFW1EV0AFC78270","fuel_type":"E85 Flex Fuel","model":"F-150","price":"9995","stock_type":"Used","stock_sub":"","canonical_mmt":"Ford:F-150:XLT","msrp":"0","dealer_name":"Joe Machens Capital City Ford","year":"2010","sponsored_type":"standard","relevancy_score":null,"mileage":"139970","cpo_indicator":false,"dealer_zip":"65109","listing_id":"92a1bc15-5be0-4105-94e2-e13ec04319af","cat":"truck_fullsize","make":"Ford","badges":["great_deal","hot_car"],"drivetrain":"Four-wheel Drive","customer_id":"5363977","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":14,"certified_preowned":false,"exterior_color":"Red Candy Metallic Tinted Clearcoat","canonical_mmty":"Ford:F-150:XLT:2010"},{"interior_color":"Black","photo_count":34,"cpo_package":null,"bodystyle":"SUV","trim":"High Altitude","vin":"1C4RJFCG2JC151678","fuel_type":"Gasoline","model":"Grand Cherokee","price":"15715","stock_type":"Used","stock_sub":"","canonical_mmt":"Jeep:Grand Cherokee:High Altitude","msrp":"0","dealer_name":"Joe Machens Nissan","year":"2018","sponsored_type":"standard","relevancy_score":null,"mileage":"139342","cpo_indicator":false,"dealer_zip":"65203","listing_id":"d069f6bd-5fea-472b-b7d6-d75682335e1e","cat":"suv_midsize","make":"Jeep","badges":["good_deal"],"drivetrain":"Four-wheel Drive","customer_id":"5363960","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":15,"certified_preowned":false,"exterior_color":"Billet Silver Metallic Clearcoat","canonical_mmty":"Jeep:Grand Cherokee:High Altitude:2018"},{"interior_color":"Black","photo_count":35,"cpo_package":null,"bodystyle":"Truck","trim":"Laramie","vin":"1C6SRFJT8NN145136","fuel_type":"Gasoline","model":"1500","price":"36555","stock_type":"Used","stock_sub":"","canonical_mmt":"RAM:1500:Laramie","msrp":"0","dealer_name":"Mercedes-Benz of Columbia","year":"2022","sponsored_type":"standard","relevancy_score":null,"mileage":"79029","cpo_indicator":false,"dealer_zip":"65203","listing_id":"08071dd3-ff0b-4186-99e1-28ab1c9c26dd","cat":"truck_fullsize","make":"RAM","badges":["good_deal"],"drivetrain":"Four-wheel Drive","customer_id":"5243424","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":16,"certified_preowned":false,"exterior_color":"Flame Red Clearcoat","canonical_mmty":"RAM:1500:Laramie:2022"},{"interior_color":"Black","photo_count":49,"cpo_package":null,"bodystyle":"Truck","trim":"Tradesman","vin":"1C6RR7FG4KS658607","fuel_type":"Gasoline","model":"1500","price":"19090","stock_type":"Used","stock_sub":"","canonical_mmt":"RAM:1500:Tradesman","msrp":"0","dealer_name":"Joe Machens Volkswagen","year":"2019","sponsored_type":"standard","relevancy_score":null,"mileage":"88328","cpo_indicator":false,"dealer_zip":"65202","listing_id":"225a9a34-c0f2-4fee-9ce1-98ee2dfc444c","cat":"truck_fullsize","make":"RAM","badges":["price_drop_in_cents","great_deal"],"drivetrain":"Four-wheel Drive","customer_id":"5364038","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":17,"certified_preowned":false,"exterior_color":"Patriot Blue Pearlcoat","canonical_mmty":"RAM:1500:Tradesman:2019"},{"interior_color":"Charcoal","photo_count":32,"cpo_package":null,"bodystyle":"SUV","trim":"SV","vin":"5N1BT3BB5RC698659","fuel_type":"Gasoline","model":"Rogue","price":"21400","stock_type":"Used","stock_sub":"","canonical_mmt":"Nissan:Rogue:SV","msrp":"0","dealer_name":"Columbia Honda","year":"2024","sponsored_type":"standard","relevancy_score":null,"mileage":"41795","cpo_indicator":false,"dealer_zip":"65202","listing_id":"6e05e8c0-84e8-4cf9-8370-41335cbb40b7","cat":"crossover_compact","make":"Nissan","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"drivetrain":"All-wheel Drive","customer_id":"5354599","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":18,"certified_preowned":false,"exterior_color":"Super Black","canonical_mmty":"Nissan:Rogue:SV:2024"},{"interior_color":"Gray","photo_count":30,"cpo_package":null,"bodystyle":"SUV","trim":"Premium","vin":"JF2SKAEC0NH486640","fuel_type":"Gasoline","model":"Forester","price":"21300","stock_type":"Used","stock_sub":"","canonical_mmt":"Subaru:Forester:Premium","msrp":null,"dealer_name":"Mazda of Columbia","year":"2022","sponsored_type":"standard","relevancy_score":null,"mileage":"91170","cpo_indicator":false,"dealer_zip":"65202","listing_id":"242bb0d8-8d29-47c0-8c94-62b14fb9ab8a","cat":"crossover_compact","make":"Subaru","badges":["price_drop_in_cents","good_deal"],"drivetrain":"All-wheel Drive","customer_id":"5364156","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":19,"certified_preowned":false,"exterior_color":"Crimson Red Pearl","canonical_mmty":"Subaru:Forester:Premium:2022"},{"interior_color":"Black","photo_count":35,"cpo_package":null,"bodystyle":"SUV","trim":"SEL 2.4","vin":"5NMS2DAJ2PH526884","fuel_type":"Gasoline","model":"SANTA FE","price":"18800","stock_type":"Used","stock_sub":"","canonical_mmt":"Hyundai:SANTA FE:SEL 2.4","msrp":"0","dealer_name":"Columbia Honda","year":"2023","sponsored_type":"standard","relevancy_score":null,"mileage":"69650","cpo_indicator":false,"dealer_zip":"65202","listing_id":"9bf7d872-fbea-445b-ad7d-c858f2eb9b07","cat":"crossover_midsize","make":"Hyundai","badges":["price_drop_in_cents","fair_deal"],"drivetrain":"All-wheel Drive","customer_id":"5354599","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":20,"certified_preowned":false,"exterior_color":"Twilight Black","canonical_mmty":"Hyundai:SANTA FE:SEL 2.4:2023"},{"interior_color":"Black","photo_count":28,"cpo_package":null,"bodystyle":"SUV","trim":"Limited","vin":"5NMS44ALXPH526367","fuel_type":"Gasoline","model":"SANTA FE","price":"22300","stock_type":"Used","stock_sub":"","canonical_mmt":"Hyundai:SANTA FE:Limited","msrp":null,"dealer_name":"Mazda of Columbia","year":"2023","sponsored_type":"standard","relevancy_score":null,"mileage":"70257","cpo_indicator":false,"dealer_zip":"65202","listing_id":"910f8bd7-87bf-4ef1-9c4a-2ac6df95eda5","cat":"crossover_midsize","make":"Hyundai","badges":["price_drop_in_cents","good_deal"],"drivetrain":"Front-wheel Drive","customer_id":"5364156","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":21,"certified_preowned":false,"exterior_color":"White Pearl","canonical_mmty":"Hyundai:SANTA FE:Limited:2023"},{"interior_color":"Black","photo_count":34,"cpo_package":null,"bodystyle":"SUV","trim":"Limited","vin":"1C4RJFBG1LC207761","fuel_type":"Gasoline","model":"Grand Cherokee","price":"21885","stock_type":"Used","stock_sub":"","canonical_mmt":"Jeep:Grand Cherokee:Limited","msrp":null,"dealer_name":"Jim Butler Linn Chevrolet","year":"2020","sponsored_type":"standard","relevancy_score":null,"mileage":"84664","cpo_indicator":false,"dealer_zip":"65051","listing_id":"271b3ae6-61cf-4d48-aed5-6f53b05280ad","cat":"suv_midsize","make":"Jeep","badges":["good_deal"],"drivetrain":"Four-wheel Drive","customer_id":"5363686","nvi_program":false,"seller_type":"dealership","sponsored":false,"vertical_position":22,"certified_preowned":false,"exterior_color":"Billet Silver Metallic Clearcoat","canonical_mmty":"Jeep:Grand Cherokee:Limited:2020"}]}]