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 SUVs for sale near New Franklin, MO under $899,990

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
662 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: White
Drivetrain: Four-wheel Drive
MPG: 20-27
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 2.3L I4 16V GDI DOHC Turbo
Stock #: 1859A
VIN: 1FMSK8FH4NGB31859

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

Hainen Ford, Inc. review

Great Friendly Service

Our family has purchased new and used cars here over the years. They are honest and fair and an great part of our community. I will continue to have my cars serviced here.

2022 Ford Explorer Limited review

I purchased the 2022 Timberline preowned about 1 month

I purchased the 2022 Timberline preowned about 1 month ago with appx 50k miles on it. I was disappointed that it does not have memory seats or a garage door remote button. (I didn't even notice this when test driving it). Who makes a car today with all the tech this car has and leaves off these 2 things! The interior is comfortable & well laid out. The ride is smooth & quiet. 2.3L turbo 4 cylinder is quiet & has amazing power. At idle it’s hard to tell that the engine is even running. The prior owner put on Michelin tires which contribute to the smooth, quiet ride. The seats are ActiveX (Ford’s name for vinyl) with cloth inserts. I’m 5’ 10” and 175lbs. My son who rode with me is 6’ 3” and 250lbs. Both of us found the seats comfortable & supportive on our 1st road trip. I’ve driven a Kia Telluride, which is a direct competitor. The Kia has a little more tech but I found the ride to be on the harsh side, especially in the second row. This may be attributable to the low profile 21” tires. The Timberline has 18” balloon tires which I much prefer. 2 weeks after purchasing it I made a 2,200-mile road trip from Dallas TX to Orgon. Fuel mileage ranged from 21 to 28 with an overall average of 24 mpg. *if I don’t drive over 70 mph on the highway the fuel economy goes up to about 32! *these numbers are from the actual miles & gallons of fuel used, not from the dash numbers, which I found are a little optimistic. It has a few bugs that I’ll have to deal with, but it’s a used Ford & not a Lexus. Overall, I'd say I'm very happy with this car & would recommend it.

Vehicle information

Ext. color: Diamond Black Crystal Pearlcoat
Int. color: Global Black
Drivetrain: Four-wheel Drive
MPG: 16-23
Fuel type: Gasoline
Transmission: Automatic
Engine: Hurricane 3L I-6 gasoline direct injection, DOHC, variable valve
Stock #: BU2971
VIN: 1C4SJSBP4RS106982

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, Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

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.

Vehicle information

Ext. color: Silver Metallic
Int. color: Sandstone
Drivetrain: Four-wheel Drive
MPG: 16-22
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 3.5L V-6 port/direct injection, DOHC, variable valve co
Stock #: BU2964
VIN: 1FMJK2A87REA42806

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®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof, Tow Hitch
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

BMW of Columbia - MO review

Two kids - two cars

I've worked with Josh Reichlin and Rusty Drewing a couple times already for my personal vehicle purchases, but with my 15-year old twins getting their permits, we needed something for them as well. Josh was great to work with as usual - helping us sort through the options until we found what worked best for us. Negotiations with him and Rusty went quickly and smoothly with us reaching a fair deal on each vehicle. I highly recommend BMW of Columbia for both new and used vehicles. I should also mention Brad Davis in the finance department was great as well. Their customer service can't be beat and with a fair deal on the purchase what else can you ask for?

2024 Ford Expedition Max Limited review

Previous minivan owner we didn’t realize we had out grown

Previous minivan owner we didn’t realize we had out grown our minivan till we realized the amount of space in our new truck. We have 4 active kids from 5-15 that are in multiple sports. We travel a fair amount both to the airport and on road trips. So our new vehicle needed to get all of us and luggage wherever we’re going. So far this is doing it.

Vehicle information

Ext. color: Obsidian Black Metallic
Int. color: AMG Neva Gray
Drivetrain: All-wheel Drive
MPG: 24-30
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: B20147B
VIN: W1NKJ4HB3RF090816

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, Satellite Radio, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, 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

2024 Mercedes-Benz GLC 300 4MATIC Coupe review

hshshshs jdododod kdooao kwpwp pqpa00s ks ks0-s,k

nice car and no to expensive, comfortable, I can't explain how I like my new Mercedes Benz GLC 300 . My last car was very good , ut my new OMG......

Vehicle information

Ext. color: Polymetal Gray Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 23-28
Transmission: 8-Speed A
Engine: 3.3 IC6 G
Stock #: S1109026
VIN: JM3KJEHC5S1109026

Features

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

Reviews

Mazda of Columbia review

Angel Garrett

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

2025 Mazda CX-70 CX-70 review

I've owned our CX 70 for 9 1/2 months, I like the car

I've owned our CX 70 for 9 1/2 months, I like the car very much! So far the car has no problems! I like the 6 cylinder engine in our CX 70, it has adequate power and runs very smoothly. I like the styling both inside and outside. My only suggestions to Mazda to improve the vehicle is to allow the AC vents on the dash to be able to swivel up higher to blow cool air higher in the front of the car. And, the auto off and auto on feature should be smoother, but the system is not so bothersome to turn it off. My fuel mileage has averaged 17.5 miles per gallon, my driving has only been in stop and go traffic. I have not driven the car enough on highways to determine the fuel consumption over the road.

Vehicle information

Ext. color: Crystal Black Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 gasoline direct injection, i-VTEC VCM variable valve co
Stock #: BU2953A
VIN: 5FNYF8H59NB007134

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, 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
Seating: Leather Seats, Memory Seat

Reviews

BMW of Columbia - MO review

They were very attentive and quick to respond.

They were very attentive and quick to respond. The vehicle I was interested in sold before I had opportunity to purchase, but that was because I live out of state and couldn’t get there to test drive soon enough!

2022 Honda Passport AWD EX-L review

Perfect family of 4 SUV with a bunch of space.

Perfect family of 4 SUV with a bunch of space. AVG 23.5 mph. The 9 speed transmission is not as smooth as the older 6 speeds. I wish you could permanently turn of the stop/Start. So far so good.

Vehicle information

Ext. color: Gray Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 31-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 port/direct injection, DOHC, VVT-i variable valve contr
Stock #: B21027A
VIN: 2T2JGMDA9NC075914

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®, CD Player, HomeLink, 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

Reviews

BMW of Columbia - MO review

Nick, my salesperson was great Answered all my

Nick, my salesperson was great Answered all my questions and even arranged transportation for my purchase. Also help negotiate my buy price.

Vehicle information

Ext. color: Granite Crystal Clearcoat Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 19-27
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 3.2L V6 24V MPFI DOHC
Stock #: ND552958
VIN: 1C4PJMCX3ND552958

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels, Roof Rack, Tow Hooks
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, 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 Jeep Cherokee X review

Still A Jeep Girl...BUT

I love my Cherokee overall. This is my 3rd one. Sadly I've noticed the quality slipping. Jeep no longer provides a spare tire - WHAT? The floor mats are now of lesser quality and no longer have the Jeep emblem embroidered on them. The transmission is still a little iffy but not as bad as my '15. The tail lights fill with condensation but the dealership tells me it is normal to do so - WHAT? Additionally you're never gonna be able to find a V6 anymore. I had to go down a year to a '22 in order to get one. They are pushing EVs and Hybrids. All this being said I'm still Jeep girl and still love my Cherokee.

Vehicle information

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

Features

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

Reviews

Mazda of Columbia review

lartiquefreeman2206@yahoo.com

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

2025 Mercedes-Benz GLA 250 Base 4MATIC review

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

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

Vehicle information

Ext. color: Deep Black Pearl
Int. color: Titan Black
Drivetrain: All-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: BU2920
VIN: 1V2HE2CA8SC209894

Features

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

Reviews

2025 Volkswagen Atlas Cross Sport 2.0T SE w/Technology 4MOTION review

I love this SUV very nice very comfortable and very

I love this SUV very nice very comfortable and very smooth it has all the features in it that I love everything is perfect I have no complained about it

Vehicle information

Ext. color: Aurora Black
Int. color: Gray
Drivetrain: All-wheel Drive
Fuel type: Hybrid
Transmission: 6-Speed Automatic
Engine: 1.6L I4 16V GDI DOHC Turbo Hybrid
Stock #: P5137919
VIN: KNDRMDLH3P5137919

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, Roof Rack
Safety: Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

Mazda of Columbia review

Upgraded review from 10/10

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

Vehicle information

Ext. color: Firecracker Red Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, intercooled turbo, premi
Stock #: BU2967
VIN: 1C4RJXP61RW225609

Features

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

Reviews

2024 Jeep Wrangler 4xe Sahara review

Bought my 2024 used with 13k miles on it.

Bought my 2024 used with 13k miles on it. Maybe I'm old school due to prior life with a 97 TJ and and 01 XJ but this car is fantastic to drive and very luxurious. Perhaps not as tech heavy as other SUVs, but it does everything I could hope for, and has been fun for road driving and light off roading.

Vehicle information

Ext. color: Polymetal Gray Metallic
Int. color: Black W/ Gray
Drivetrain: All-wheel Drive
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.5L I4 16V
Stock #: SN300358
VIN: 7MMVABDM5SN300358

Features

Convenience: Heated Seats, Keyless Entry, Power Liftgate
Entertainment: Apple CarPlay®, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats

Reviews

Mazda of Columbia review

2023 Mitsubishi PHEV ?Outstanding Vehicles?!

2023 Mitsubishi PHEV - ?Best Vehicle We have ever owned?!!

2025 Mazda CX-50 2.5 S Premium Package review

I am very happy with my purchase.

I am very happy with my purchase. I already owned a 2018 CX-5 and it never gave me any problems so I had no qualms about purchasing another Mazda. I went with the CX-50 Turbo Premium Plus for the horsepower and the extra perks (i.e. automatic folding mirrors, and I like that the side mirrors also turn down to see the curb when parking, front AND rear cameras, panoramic sun/moonroof, speed display in windshield, heated and ventilated cooling seats, and a 12-speaker Bose Stereo system). I love the extra power of the Turbocharged engine that my CX-5 doesn't have. The things I don't care for: 1) the retractable cargo cover (a $250 addl charge) doesn't attack to the lift (like my CX-5 does. It's much more convenient if it's attached so there's no pulling it out each time you need to put something in the trunk; 2) I don't like that I have to turn off the automatic shut off of the engine at stops and that I have to turn it off every time I get in the car. I'd like there to be an option to turn it off indefinitely unless and until I want to turn it on; 3) I would also love it if the driver and front passenger seats raised a bit higher. I'm not short but I would feel more comfortable if the seat height lifted another couple of inches. Overall, I really love my car. The steering is tight and the ride is more comfortable than I expected, and the inside of the cab is quiet and the stereo is premium. The seats are attractive with the light colored stitching to accent the seats. Because of all the features in my model, I got a lot of bang for my buck as opposed to a more expensive car costing $20K more for all the same features with Mazda reliability as well as more reasonable/affordable maintenance costs. I had a BMW several years ago and, once out of warranty, the maintenance is ridiculously costly. Additionally, the service department at the dealership where I purchased my car is top notch and the transparency for maintenance is appreciated! In the last 7 years of owning a Mazda, I have never had a bad experience.

Vehicle information

Ext. color: Omaha Orange
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 24-31
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 2.4L I4 16V MPFI SOHC
Stock #: JPJ03170
VIN: ZACCJBBB5JPJ03170

Features

Convenience: Keyless Entry, Keyless Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels, Roof Rack
Safety: Backup Camera, Brake Assist, Stability Control

Reviews

2018 Jeep Renegade Latitude review

My love affair with my Jeep

This is my second renagade, I wanted a 2021 limited and that’s what I have now. I have a long history with many models of jeeps, but I have to say this one is my all time favorite . I love everything about it. It’s a tank in the snow and mud . We have climbed to the top of a mountain with it. I feel safe and secure that I will never get stranded in the snow. It’s comfortable, and just the right size . I love the Easter eggs they hid in the car ! We were able to fit all our camping gear in it and bikes and kayaks too. I love the look of it and it’s fun ! I will never get rid of this car , it’s a keeper.

Vehicle information

Ext. color: Sterling Gray Metallic
Int. color: Jet Black w/Blue Accents
Drivetrain: Front-wheel Drive
MPG: 28-32
Fuel type: Gasoline
Transmission: Automatic
Engine: Ecotec 1.2L I-3 gasoline direct injection, DOHC, VVT variable va
Stock #: BU2935
VIN: KL77LHE20RC228300

Features

Convenience: Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control
Seating: Leather Seats

Reviews

2024 Chevrolet Trax LT review

I love my Chevy Trax I bought it in 2023 its a 2024 it

I love my Chevy Trax I bought it in 2023 its a 2024 it drives good get awesome gas mileage drove from Oregon to Oklahoma and back and one more time to Oklahoma no brake dows yes its lower to the crowd but for me its perfect to get in and out It has a lot of room in back seat and back of car for shopping It only hat one problem the Moniterscreen whent out but the Recall fixt it

Vehicle information

Ext. color: Modern Steel Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 18-26
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 gasoline direct injection, i-VTEC VCM variable valve co
Stock #: B21134A
VIN: 5FNYF6H76HB008171

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, USB Port
Exterior: Alloy Wheels, Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

2017 Honda Pilot EX-L review

Spacious interior

This car is a big step up from a Nissan Altima. Lots of space and the ride is smooth. The engine is a bit noisy when idle(clicking noise from the direct injection), and there's also a drone sound when acceleratinf beyond 60mph(not sure if this could be cause of the new tires or not), but other than those noises, it's a smooth machine!

Vehicle information

Ext. color: Lightning Blue
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 25-26
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 1.5L I4 16V GDI DOHC Turbo
Stock #: RZ044518
VIN: JA4ATWAA3RZ044518

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Navigation System, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Reviews

2024 Mitsubishi Eclipse Cross SE review

Gas mileage could use some work.

Gas mileage could use some work. Tech is somewhat outdated but works fine for what I need. Overall a decent buy for those on a budget.

Vehicle information

Ext. color: Bright White Clearcoat
Int. color: Global Black
Drivetrain: Four-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: Automatic
Engine: Pentastar 3.6L V-6 DOHC, variable valve control, regular unleade
Stock #: BU2882
VIN: 1C4RJKBG2P8806539

Features

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

Reviews

2023 Jeep Grand Cherokee L Limited review

i recently had a 2023 for explorer it was a good truck

i recently had a 2023 for explorer it was a good truck never a problem but not a comfortable as the jeep grand Cherokee l front seating is amazing no issues at all i did my research and made sure i bought one with the German transmission its a good idea to check that only thing i can say on the down side seam to be a little under powered but i can live with it decent milage 20 around town.

Vehicle information

Ext. color: Celestial Silver Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 21-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.4L I-4 port/direct injection, DOHC, variable valve control, in
Stock #: BU2922
VIN: 5TDKDRBH5RS530138

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

Vehicle information

Ext. color: Crystal Black
Int. color: Slate Black
Drivetrain: All-wheel Drive
MPG: 19-25
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.4L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: BU3000
VIN: 4S4WMAUD3P3434208

Features

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

Reviews

2023 Subaru Ascent Limited 7-Passenger review

Recently acquired Touring model

I recently traded in my 2022 Ascent for a similar 2023 model. The 2022 model had brakes issues/noises right from the beginning of ownership. Subaru gave me a great deal on the 2023 model. A number of improvement were found on the 2023 model. Obvious one is the exterior styling with new front grille, headlights and taillights. Interior improvements include updated Eyesight, quieter ride, better steering and brakes, larger multimedia screen including front and backup camera screens, driver profile system. A few other tweaks here and there, making the 2023 Ascent Touring a decent and very safe SUV. Not necessarily sporty or thrilling but perfect vehicle for commuting in town and long road trips.

*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.

662 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

Find great prices by city

Find great prices on used SUVs in New Franklin, MO

[{"applied_filter_criteria":"{\"bodystyle\":[\"suv\"],\"cpo_indicator\":false,\"max_price_range\":899990,\"min_price_range\":0,\"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":[{"year":"2022","msrp":null,"model":"Explorer","badges":["good_deal"],"trim":"Limited","stock_sub":"","exterior_color":"White","nvi_program":false,"interior_color":null,"sponsored":false,"cpo_indicator":false,"canonical_mmty":"Ford:Explorer:Limited:2022","fuel_type":"Gasoline","dealer_name":"Hainen Ford, Inc.","customer_id":"152179","listing_id":"9e7f4cfc-00d9-4cc5-a9e1-459145f5c849","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_midsize","price":"34980","vin":"1FMSK8FH4NGB31859","drivetrain":"Four-wheel Drive","make":"Ford","vertical_position":1,"photo_count":18,"relevancy_score":null,"mileage":"44988","sponsored_type":"standard","canonical_mmt":"Ford:Explorer:Limited","stock_type":"Used","dealer_zip":"65081"},{"year":"2024","msrp":"0","model":"Wagoneer L","badges":["price_drop_in_cents","great_deal","american_made_index_ranking","hot_car"],"trim":"Series II 4x4","stock_sub":"","exterior_color":"Diamond Black Crystal Pearlcoat","nvi_program":false,"interior_color":"Global Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Jeep:Wagoneer L:Series II 4x4:2024","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"7b4071fe-10f8-4e23-ac5b-a8e78f8aeb1b","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_fullsize","price":"43465","vin":"1C4SJSBP4RS106982","drivetrain":"Four-wheel Drive","make":"Jeep","vertical_position":2,"photo_count":37,"relevancy_score":null,"mileage":"68009","sponsored_type":"standard","canonical_mmt":"Jeep:Wagoneer L:Series II 4x4","stock_type":"Used","dealer_zip":"65203"},{"year":"2024","msrp":"0","model":"Expedition Max","badges":["great_deal","american_made_index_ranking","hot_car"],"trim":"Limited","stock_sub":"","exterior_color":"Silver Metallic","nvi_program":false,"interior_color":"Sandstone","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Ford:Expedition Max:Limited:2024","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"80c75125-2b88-4dcb-bc90-823e0bbfb0e3","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_fullsize","price":"48995","vin":"1FMJK2A87REA42806","drivetrain":"Four-wheel Drive","make":"Ford","vertical_position":3,"photo_count":38,"relevancy_score":null,"mileage":"66267","sponsored_type":"standard","canonical_mmt":"Ford:Expedition Max:Limited","stock_type":"Used","dealer_zip":"65203"},{"year":"2024","msrp":"0","model":"GLC 300","badges":["fair_deal","hot_car"],"trim":"4MATIC Coupe","stock_sub":"","exterior_color":"Obsidian Black Metallic","nvi_program":false,"interior_color":"AMG Neva Gray","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Mercedes-Benz:GLC 300:4MATIC Coupe:2024","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"4bb0a8e5-9b86-4d92-8bf1-4b62660f4cb6","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"luxurysuv_crossover","price":"56305","vin":"W1NKJ4HB3RF090816","drivetrain":"All-wheel Drive","make":"Mercedes-Benz","vertical_position":4,"photo_count":37,"relevancy_score":null,"mileage":"16449","sponsored_type":"standard","canonical_mmt":"Mercedes-Benz:GLC 300:4MATIC Coupe","stock_type":"Used","dealer_zip":"65203"},{"year":"2025","msrp":null,"model":"CX-70","badges":["price_drop_in_cents","hot_car"],"trim":"CX-70","stock_sub":"","exterior_color":"Polymetal Gray Metallic","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Mazda:CX-70:CX-70:2025","fuel_type":null,"dealer_name":"Mazda of Columbia","customer_id":"5364156","listing_id":"12a410e6-ab26-4d4e-a3f8-8e824559afa5","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_midsize","price":"43100","vin":"JM3KJEHC5S1109026","drivetrain":"All-wheel Drive","make":"Mazda","vertical_position":5,"photo_count":27,"relevancy_score":null,"mileage":"15309","sponsored_type":"standard","canonical_mmt":"Mazda:CX-70:CX-70","stock_type":"Used","dealer_zip":"65202"},{"year":"2022","msrp":"0","model":"Passport","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"trim":"AWD EX-L","stock_sub":"","exterior_color":"Crystal Black Pearl","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Honda:Passport:AWD EX-L:2022","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"d99aca2d-719a-4ea8-b7b8-4b873c104634","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_midsize","price":"28313","vin":"5FNYF8H59NB007134","drivetrain":"All-wheel Drive","make":"Honda","vertical_position":6,"photo_count":35,"relevancy_score":null,"mileage":"53796","sponsored_type":"standard","canonical_mmt":"Honda:Passport:AWD EX-L","stock_type":"Used","dealer_zip":"65203"},{"year":"2022","msrp":"0","model":"RX 450h","badges":["price_drop_in_cents","fair_deal"],"trim":"Base","stock_sub":"","exterior_color":"Gray Pearl","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Lexus:RX 450h:Base:2022","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"507e4934-50d0-4484-b56e-43ef3f7d7b6f","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"hybrid_suv","price":"37417","vin":"2T2JGMDA9NC075914","drivetrain":"All-wheel Drive","make":"Lexus","vertical_position":7,"photo_count":37,"relevancy_score":null,"mileage":"78627","sponsored_type":"standard","canonical_mmt":"Lexus:RX 450h:Base","stock_type":"Used","dealer_zip":"65203"},{"year":"2022","msrp":null,"model":"Cherokee","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"trim":"X","stock_sub":"","exterior_color":"Granite Crystal Clearcoat Metallic","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Jeep:Cherokee:X:2022","fuel_type":"Gasoline","dealer_name":"Mazda of Columbia","customer_id":"5364156","listing_id":"10a4c313-bb91-4d4d-9008-4ec3a10dc5a1","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"crossover_compact","price":"21200","vin":"1C4PJMCX3ND552958","drivetrain":"Four-wheel Drive","make":"Jeep","vertical_position":8,"photo_count":27,"relevancy_score":null,"mileage":"56712","sponsored_type":"standard","canonical_mmt":"Jeep:Cherokee:X","stock_type":"Used","dealer_zip":"65202"},{"year":"2025","msrp":null,"model":"GLA 250","badges":["price_drop_in_cents","good_deal"],"trim":"Base 4MATIC","stock_sub":"","exterior_color":"Cosmos Black Metallic","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Mercedes-Benz:GLA 250:Base 4MATIC:2025","fuel_type":"Gasoline","dealer_name":"Mazda of Columbia","customer_id":"5364156","listing_id":"402f3945-d9a4-45cc-ba0f-c91f557a98d1","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"luxurysuv_crossover","price":"32900","vin":"W1N4N4HB1SJ638652","drivetrain":"All-wheel Drive","make":"Mercedes-Benz","vertical_position":9,"photo_count":27,"relevancy_score":null,"mileage":"38129","sponsored_type":"standard","canonical_mmt":"Mercedes-Benz:GLA 250:Base 4MATIC","stock_type":"Used","dealer_zip":"65202"},{"year":"2025","msrp":"0","model":"Atlas Cross Sport","badges":["good_deal","american_made_index_ranking"],"trim":"2.0T SE w/Technology 4MOTION","stock_sub":"","exterior_color":"Deep Black Pearl","nvi_program":false,"interior_color":"Titan Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Volkswagen:Atlas Cross Sport:2.0T SE w/Technology 4MOTION:2025","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"64174dba-264b-4e55-b7a7-9032ac334ca9","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_midsize","price":"36401","vin":"1V2HE2CA8SC209894","drivetrain":"All-wheel Drive","make":"Volkswagen","vertical_position":10,"photo_count":35,"relevancy_score":null,"mileage":"18026","sponsored_type":"standard","canonical_mmt":"Volkswagen:Atlas Cross Sport:2.0T SE w/Technology 4MOTION","stock_type":"Used","dealer_zip":"65203"},{"year":"2023","msrp":null,"model":"Sorento Plug-In Hybrid","badges":["price_drop_in_cents","great_deal"],"trim":"SX Prestige","stock_sub":"","exterior_color":"Aurora Black","nvi_program":false,"interior_color":"Gray","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Kia:Sorento Plug-In Hybrid:SX Prestige:2023","fuel_type":"Hybrid","dealer_name":"Mazda of Columbia","customer_id":"5364156","listing_id":"b6363a07-d6f8-4728-827f-1bedbc6df4a9","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"hybrid_suv","price":"29900","vin":"KNDRMDLH3P5137919","drivetrain":"All-wheel Drive","make":"Kia","vertical_position":11,"photo_count":37,"relevancy_score":null,"mileage":"75284","sponsored_type":"standard","canonical_mmt":"Kia:Sorento Plug-In Hybrid:SX Prestige","stock_type":"Used","dealer_zip":"65202"},{"year":"2024","msrp":"0","model":"Wrangler 4xe","badges":["price_drop_in_cents","good_deal","american_made_index_ranking","hot_car","2024_award_winner"],"trim":"Sahara","stock_sub":"","exterior_color":"Firecracker Red Clearcoat","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Jeep:Wrangler 4xe:Sahara:2024","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"2c893166-6cfa-4b01-ae25-ae4240b5f33e","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"hybrid_suv","price":"34116","vin":"1C4RJXP61RW225609","drivetrain":"Four-wheel Drive","make":"Jeep","vertical_position":12,"photo_count":35,"relevancy_score":null,"mileage":"41651","sponsored_type":"standard","canonical_mmt":"Jeep:Wrangler 4xe:Sahara","stock_type":"Used","dealer_zip":"65203"},{"year":"2025","msrp":null,"model":"CX-50","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"trim":"2.5 S Premium Package","stock_sub":"","exterior_color":"Polymetal Gray Metallic","nvi_program":false,"interior_color":"Black W/ Gray","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Mazda:CX-50:2.5 S Premium Package:2025","fuel_type":"Gasoline","dealer_name":"Mazda of Columbia","customer_id":"5364156","listing_id":"d76192ae-634a-4a31-99ac-b9df941316ad","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"crossover_compact","price":"29900","vin":"7MMVABDM5SN300358","drivetrain":"All-wheel Drive","make":"Mazda","vertical_position":13,"photo_count":32,"relevancy_score":null,"mileage":"6418","sponsored_type":"standard","canonical_mmt":"Mazda:CX-50:2.5 S Premium Package","stock_type":"Used","dealer_zip":"65202"},{"year":"2018","msrp":null,"model":"Renegade","badges":["price_drop_in_cents","great_deal","hot_car"],"trim":"Latitude","stock_sub":"","exterior_color":"Omaha Orange","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Jeep:Renegade:Latitude:2018","fuel_type":"Gasoline","dealer_name":"Mazda of Columbia","customer_id":"5364156","listing_id":"18807854-3732-4af2-9957-5aaea2920c3f","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"crossover_compact","price":"10500","vin":"ZACCJBBB5JPJ03170","drivetrain":"Four-wheel Drive","make":"Jeep","vertical_position":14,"photo_count":27,"relevancy_score":null,"mileage":"123750","sponsored_type":"standard","canonical_mmt":"Jeep:Renegade:Latitude","stock_type":"Used","dealer_zip":"65202"},{"year":"2024","msrp":"0","model":"Trax","badges":["price_drop_in_cents","great_deal","2024_award_winner"],"trim":"LT","stock_sub":"","exterior_color":"Sterling Gray Metallic","nvi_program":false,"interior_color":"Jet Black w/Blue Accents","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Chevrolet:Trax:LT:2024","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"147b8c2f-1897-4642-b41f-7f3e60d0ff4f","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"crossover_compact","price":"20429","vin":"KL77LHE20RC228300","drivetrain":"Front-wheel Drive","make":"Chevrolet","vertical_position":15,"photo_count":32,"relevancy_score":null,"mileage":"31304","sponsored_type":"standard","canonical_mmt":"Chevrolet:Trax:LT","stock_type":"Used","dealer_zip":"65203"},{"year":"2017","msrp":"0","model":"Pilot","badges":["good_deal"],"trim":"EX-L","stock_sub":"","exterior_color":"Modern Steel Metallic","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Honda:Pilot:EX-L:2017","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"a92585e6-f0e9-4ce2-aefb-01c6772d4f5e","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"crossover_midsize","price":"16209","vin":"5FNYF6H76HB008171","drivetrain":"All-wheel Drive","make":"Honda","vertical_position":16,"photo_count":37,"relevancy_score":null,"mileage":"129652","sponsored_type":"standard","canonical_mmt":"Honda:Pilot:EX-L","stock_type":"Used","dealer_zip":"65203"},{"year":"2024","msrp":null,"model":"Eclipse Cross","badges":["price_drop_in_cents","good_deal"],"trim":"SE","stock_sub":"","exterior_color":"Lightning Blue","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Mitsubishi:Eclipse Cross:SE:2024","fuel_type":"Gasoline","dealer_name":"Mazda of Columbia","customer_id":"5364156","listing_id":"a1a4f7e2-1233-4e4b-8ddd-7285008aaba3","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"crossover_compact","price":"21500","vin":"JA4ATWAA3RZ044518","drivetrain":"Four-wheel Drive","make":"Mitsubishi","vertical_position":17,"photo_count":27,"relevancy_score":null,"mileage":"35126","sponsored_type":"standard","canonical_mmt":"Mitsubishi:Eclipse Cross:SE","stock_type":"Used","dealer_zip":"65202"},{"year":"2023","msrp":"0","model":"Grand Cherokee L","badges":["price_drop_in_cents","fair_deal"],"trim":"Limited","stock_sub":"","exterior_color":"Bright White Clearcoat","nvi_program":false,"interior_color":"Global Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Jeep:Grand Cherokee L:Limited:2023","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"f0aa6086-06d8-443f-b123-29034bb53b0d","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_midsize","price":"28493","vin":"1C4RJKBG2P8806539","drivetrain":"Four-wheel Drive","make":"Jeep","vertical_position":18,"photo_count":36,"relevancy_score":null,"mileage":"55712","sponsored_type":"standard","canonical_mmt":"Jeep:Grand Cherokee L:Limited","stock_type":"Used","dealer_zip":"65203"},{"year":"2024","msrp":"0","model":"Highlander","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"trim":"LE","stock_sub":"","exterior_color":"Celestial Silver Metallic","nvi_program":false,"interior_color":"Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Toyota:Highlander:LE:2024","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"58520c4d-a39c-449a-98e1-ad1eca11af74","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"crossover_midsize","price":"31352","vin":"5TDKDRBH5RS530138","drivetrain":"All-wheel Drive","make":"Toyota","vertical_position":19,"photo_count":34,"relevancy_score":null,"mileage":"51569","sponsored_type":"standard","canonical_mmt":"Toyota:Highlander:LE","stock_type":"Used","dealer_zip":"65203"},{"year":"2023","msrp":"0","model":"Ascent","badges":["good_deal"],"trim":"Limited 7-Passenger","stock_sub":"","exterior_color":"Crystal Black","nvi_program":false,"interior_color":"Slate Black","sponsored":false,"cpo_indicator":false,"canonical_mmty":"Subaru:Ascent:Limited 7-Passenger:2023","fuel_type":"Gasoline","dealer_name":"BMW of Columbia - MO","customer_id":"152419","listing_id":"8fb3ecd3-17c5-4761-b5ba-66768384b587","cpo_package":null,"bodystyle":"SUV","seller_type":"dealership","certified_preowned":false,"cat":"suv_midsize","price":"29360","vin":"4S4WMAUD3P3434208","drivetrain":"All-wheel Drive","make":"Subaru","vertical_position":20,"photo_count":38,"relevancy_score":null,"mileage":"63413","sponsored_type":"standard","canonical_mmt":"Subaru:Ascent:Limited 7-Passenger","stock_type":"Used","dealer_zip":"65203"}]}]