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 compact SUVs for sale near New Franklin, MO

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
214 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: Summit White
Int. color: Ebony Seats
Drivetrain: All-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 2.0L Turbocharged
Stock #: PD066373
VIN: LRBFZPR44PD066373

Features

Convenience: 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
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Joe Machens Nissan review

Scotty Glasgow is awesome!

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

2023 Buick Envision Essence review

Purchased pre owned with 56k miles.

Purchased pre owned with 56k miles. Everything seems to be great thus far. The only thing is I’m not sure the AC actually works as I normally keep it set to the “Auto” function. And when the temperature got up a little warmer than normal it didn’t seem to make the adjustment.

Vehicle information

Ext. color: Kings Red
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.0L I4 16V GDI DOHC Turbo
Stock #: NM027707
VIN: 3VV2B7AX3NM027707

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Power Liftgate, Remote Start
Entertainment: Bluetooth®, Satellite Radio
Exterior: Alloy Wheels, Roof Rack
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats

Reviews

2022 Volkswagen Tiguan 2.0T SE review

I have owned this 2023 Tiguan SEL R line for almost a

I have owned this 2023 Tiguan SEL R line for almost a year. I have been absolutely satisfied with the quality, the ride, the fuel mileage and everything else about it. IMO it’s the best bang for the buck on the market. It is loaded with options and is still very affordable. I love this VW and , of course, I highly recommend it.

Vehicle information

Ext. color: Crimson Red Pearl
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: NH486640
VIN: JF2SKAEC0NH486640

Features

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

Reviews

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: Brilliant Silver Metallic
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-34
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L I3 Turbocharged DOHC 12V LEV3-ULEV50 201hp
Stock #: PC758898
VIN: 5N1BT3CB1PC758898

Features

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

Reviews

Joe Machens Nissan review

JM Nissan Rocks

Adam was super friendly and helpful. Shawn and Mike were also helpful. Thank you so much!! I love my car. Thank for giving us several great vehicles to choose from. I am sure we'll be back for a next vehicle down the road.

2023 Nissan Rogue SL review

So far I have been pleased with the performance of my

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

Vehicle information

Ext. color: Gray
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: P1353998
VIN: YV4L12RN3P1353998

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, 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, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

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 Volvo XC60 B5 Plus Bright Theme review

This is 100% one of the best cars I’ve owned.

This is 100% one of the best cars I’ve owned. Comparing it to my previously owned Acuras, Audis, BMWs, Buicks, Cadillacs, GMCs, Land Rover Range Rovers, Mercedes-Benzs, Porsches, Volkswagens, this is one of my top favorite vehicles for comfort, performance, technology, driving, etcetera. I 10/10 recommend.

Vehicle information

Ext. color: Pure White
Int. color: Titan Black
Drivetrain: Front-wheel Drive
MPG: 23-30
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: NM026577
VIN: 3VV3B7AX5NM026577

Features

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

Reviews

Kia of Columbia review

A great experience!

This is our 1st Kia and we absolutely love it. Had a great salesman, Derek, who went above and beyond with his customer service abilities. Knowledgeable about Kia and was able to answer our questions. Keith and Mike, asst. Managers, were quite helpful. Mike really came through in solving an issue we were having. Thank you all and we are looking forward to our new relationship with Kia and its employees.

2022 Volkswagen Tiguan 2.0T SE review

A Satisfied User Who Got His Moneys Worth

It's a medium-sized SUV. It's not a Porsche, Audi or MB. It is comfortable, reliable, the size and capacity I sought. In two years I've put on ~24K miles and absolutely no problems. My wife is handicapped and uses a walker. She thought the car was comfortable and we made two round trips from Hartford, CT to Key West. In the last 60 years We've had a Beetle, Passat, and a VW Bus that carried our family of four and 2 Dachshunds aacross the country and back to Connecticut - Twice!

Vehicle information

Ext. color: Deep Black Pearl
Int. color: Titan Black
Drivetrain: Front-wheel Drive
MPG: 23-30
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: RM200281
VIN: 3VVNB7AX2RM200281

Features

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

Reviews

Columbia Honda review

Columbia Hondas Service Department

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

2024 Volkswagen Tiguan 2.0T SE review

30mpg avg with the longest and widest roof rail base for

30mpg avg with the longest and widest roof rail base for outdoor gear at a price that made sense. 2nd row middle seat folds down individually for skis and paddles. Remote start on the vw app is great for cooling the interior down on a 100 degree day from a distance. Rear seat door opening and leg room is huge great for elders to enter easily and for parents loading car seats.

Vehicle information

Ext. color: Super Black
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 30-37
Fuel type: Gasoline
Transmission: Automatic
Engine: VC-Turbo 1.5L I-3 gasoline direct injection, DOHC, CVTCS variabl
Stock #: PC895219
VIN: 5N1BT3AA1PC895219

Features

Convenience: Keyless Entry, Keyless 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

top notch service

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

2023 Nissan Rogue S review

I’m very happy with my 2023 Nissan Rogue.

I’m very happy with my 2023 Nissan Rogue. It’s smooth, efficient, and has a sleek design. The cabin is spacious and packed with helpful features. It feels safe and reliable every time I’m behind the wheel. It’s a great all-around SUV.

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 #: RC694388
VIN: 5N1BT3BB2RC694388

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

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.

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: Caspian Blue Metallic
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 2.5L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: MW308420
VIN: JN8AT3DD2MW308420

Features

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

Reviews

Joe Machens Toyota review

So happy with our purchase.

So happy with our purchase. Josh Benson went above and beyond to make our experience a great one.

2021 Nissan Rogue Platinum 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: Ibis White
Int. color: Atlas Beige
Drivetrain: All-wheel Drive
MPG: 23-27
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: J2012206
VIN: WA1BNAFY5J2012206

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, DVD Player, HomeLink, Premium Sound System, USB Port
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Joe Machens Hyundai review

Purchased a new 2025 Santa Fe Hybrid from Joe Machen’s

Purchased a new 2025 Santa Fe Hybrid from Joe Machen’s Hyundai in Columbia, MO. a few months ago and needed to take it to service to get mud flaps installed they ordered for me and I must say their service department is very good. Great to work with, got us in and out quickly, gave us a free car wash certificate to Country Club carwash. Their facilities are spotless, and their waiting area gives every other Hyundai Dealership something to aspire towards. Excellent dealership and everyone is so welcoming, friendly, helpful, and polite

2018 Audi Q5 2.0T Tech Premium review

Q5 2018 satisfaction review

Very smooth comfortable ride. I have a Q5 2018 and so far no problem. Never thought I will get used to driving a SUV since my last car was an A6 which I kept for 13 years.

Vehicle information

Ext. color: Platinum Gray Metallic
Int. color: Titan Black
Drivetrain: All-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: PM053583
VIN: 3VV2B7AX5PM053583

Features

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

Joe Machens Hyundai review

Joe Machens Hyundai and our sales person, Ashton, went

Joe Machens Hyundai and our sales person, Ashton, went above & beyond when purchasing my daughter’s first car! Ashton was patient, knowledgeable & genuine throughout the process. The final detailing & inspection left the car immaculate! Thanks for a great experience!

2023 Volkswagen Tiguan 2.0T SE 4MOTION review

I absolutely love this car and all it’s features even

I absolutely love this car and all it’s features even though it doesn’t open and close trunk via keyphobe. Kids love the car especially the panoramic sunroof.

Vehicle information

Ext. color: Pure White
Int. color: Titan Black
Drivetrain: Front-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: MM003586
VIN: 3VV3B7AX3MM003586

Features

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

Reviews

CDJR of Columbia review

I had a great experience at CDJR.

I had a great experience at CDJR. Everyone involved in helping me purchase my car was friendly, and helpful throughout the process. I would recommend them to my family and friends.

2021 Volkswagen Tiguan 2.0T SE R-Line Black review

Great car and I shopped several

Great car, quiet ride mostly for an SUV, glad I bought it, tested Honda CRV, Mazda CX-5, Hyundai Tucson, Kia Sorrento, Chevrolet Equinox, Terrain, and many others, at that time I could not make a comparison with Toyota since there were none to be tested, the Tiguan stood above the others

Vehicle information

Ext. color: BROWN
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 33-33
Fuel type: Gasoline
Transmission: CVT
Engine: 2.5L H4
Stock #: 11644
VIN: JF2SKASC2KH400910

Features

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

Reviews

Top Quality Motors review

Bill was so incredibly kind!

Bill was so incredibly kind!!! He helped me buy my first car!! Very pleasant experience.

2019 Subaru Forester Limited review

I had to make a 5 1/2 hour drive recently and loved how

I had to make a 5 1/2 hour drive recently and loved how smoothly my car drove, especially using cruise control with “eyesight” so it slowed when I was too close to the car in front of me. I couldn’t even feel it; I watched the speedometer. Love the safety features and extras like seat warmers and large sunroof.

Vehicle information

Ext. color: Crystal White Pearl
Int. color: Blond/Off-Black
Drivetrain: All-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-5 DOHC, variable valve control, intercooled turbo, regula
Stock #: G2782963
VIN: YV4612RK7G2782963

Features

Convenience: Keyless Entry, Navigation System, Remote Start
Entertainment: Bluetooth®, CD Player, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

CDJR of Columbia review

Carson was my salesman and he was very friendly and

Carson was my salesman and he was very friendly and helpful. I appreciate his kindness and hard work

2016 Volvo XC60 T5 Premier review

Absolutely perfect

This car has blown me away. It has all the bells and whistles I wanted and drive like butter! The color is perfect and the rims are bomb! The interior is clean, and very well taken care of.

Vehicle information

Ext. color: Alpine White
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 21-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: B21185A2
VIN: 5UX53DP01N9J98454

Features

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

Reviews

BMW of Columbia - MO review

Great experience with wonderful staff

Looking for a work car I found a 2017 Ford Focus, I drove 2 hours to look at it and ended up driving it home. Quality cars and Dave Watson was a super salesperson who makes you feel at home with no pressure to purchase. I wouldn’t hesitate to purchase from them again A on the experience

2022 BMW X3 xDrive30i review

It's all about the B58 in the M40i.

It's all about the B58 in the M40i. I dinged it one star on comfort because this little SUV rides quite "sporty" even in Comfort mode. I absolutely love this about the car, but I could see how some would feel this is too harsh as it is not a luxurious, cushy ride. But tuck this little beast into a fast corner and it's just...wow! This little German SUV is a sleeper. While the X3M is very nice, the M40i is the perfect balance in my opinion. BMW has really stepped up their game in the X3.

Vehicle information

Ext. color: Brilliant Silver
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 DOHC, variable valve control, regular unleaded, engine
Stock #: BU3077
VIN: JN8AT2MT9GW025955

Features

Convenience: Keyless Entry
Entertainment: Bluetooth®, CD Player, USB Port, WiFi Hotspot
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

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!

2016 Nissan Rogue S review

I bought my 2016 Rogue SL in 2019 with 32,000 miles on

I bought my 2016 Rogue SL in 2019 with 32,000 miles on it. It is now 2025 and it has 223,000 miles on it, and I still drive her daily with no issues. I have had to replace the car battery once and the fob battery twice. I also had to replace the front wheel bearings about 2 years ago. That is it! No check engine lights no engine or transmission issues, no sun roof leaks. Everything she started with still functions as well as the day i got her. This has been the best, most reliable incredible car i could have every asked for. I can not speak highly enough of the Rogue and am currently looking at getting another one and saving what is left of this one for my daughter.

Vehicle information

Ext. color: Horizon Blue 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 #: PH412545
VIN: JF2SKAPCXPH412545

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, CD Player, Satellite Radio
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Stability Control
Seating: Leather Seats

Reviews

Mazda of Columbia review

lartiquefreeman2206@yahoo.com

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

2023 Subaru Forester Limited review

LOVE this car, maybe a little biased since this is my 5th

LOVE this car, maybe a little biased since this is my 5th Forester, my 2nd Wilderness. My first Wilderness was totaled in a head-on collision when a young driver spilled coffee and veered into my lane and struck me head-on. That was my 1st Subaru Forester Wilderness and IT SAVED MY LIFE. Full curtain all-around airbag deployment with a roll, the Wilderness coming to rest on it's right side, me still strapped into seatbelt, and the Subaru automatic crash notification with a live person on the speakers asking me if I was ok and needed 911! Smoke still coming from the airbag deployments, and there is a live person coming over the speakers asking me if I'm ok. It was surreal. SUBARU FORESTER WILDERNESS SAVED MY LIFE! TYVM Subaru! LOVE this car! Gets 25+ MPG with conservative driving, a great ride and suspension, superior traction in mud and snow, load-out practically anything/rack bikes (or whatever on the roof racks), sleep in the back with ample room, superior rear-gate lift mechanism with memory, seats super-comfortable and easily adjustable, solid rear-seat leg-room, easy rear-seat fold-downs for massive cargo area that takes my full HVAC tool load-out for servicing ice baths all over the NorthEast US. A great value, especially CPO with +10K mileage (vs. new) MONEY WELL SPENT! SUBARU FOR LIFE

Vehicle information

Ext. color: Bright White Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 21-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, intercooled turbo, premi
Stock #: B21185A1
VIN: 1C4HJXDN4PW562599

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, USB Port
Exterior: Alloy Wheels, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, 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.

2023 Jeep Wrangler Sport S review

It is a great car, my uncle drove it in the west hamptons

It is a great car, my uncle drove it in the west hamptons in New York to the beach. Very fun when the roof is not there.

Vehicle information

Ext. color: White
Int. color: Jet Black
Drivetrain: All-wheel Drive
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.0L 4 Cyl. Turbo DOHC
Stock #: LL276182
VIN: 3GKALTEX8LL276182

Features

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

Reviews

2020 GMC Terrain SLE review

I have had this car 5 years 90000 km.

I have had this car 5 years 90000 km. No problems so far, it has been exceptionally good. The only money I have spent is gas and oil changes. I. Would buy another one

About SUVs

FAQs

What is the cheapest SUV available?

The Buick Encore is the cheapest available SUV by average Cars.com listing price, with an average listing price of $12,758.

Which SUV has the best MPG?

The Nissan Rogue has the best MPG among traditional internal combustion SUVs and offers up to 30 MPG city and 37 MPG highway for a combined rating of 33 MPG. The Kia Niro has the best MPG amongst SUVs with hybrid powertrains, reaching 53 MPG city and 54 MPG highway for a combined rating of 53 MPG.

These figures are based on EPA mileage ratings and are for comparison purposes only. The actual mileage will vary depending on the selected vehicle model year, trim, driving conditions, driving habits, vehicle maintenance, and other factors.

Which SUV has the longest range?

The Cadillac Escalade IQL has the longest range among SUVs and can travel up to 450 miles on a single charge depending on electric motor and battery options.

EPA-estimated range is the distance, or predicted distance, a new plug-in vehicle will travel on electric power before its battery charge is exhausted. Actual range will vary depending on model year, driving conditions, driving habits, elevation changes, weather, accessory usage (lights, climate control), vehicle condition and other factors.

Which automaker has the most SUV deals?

Jeep has the most available SUV deals on Cars.com with 20162 great deals out of 65500 listings starting at $800.

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

214 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
[{"applied_filter_criteria":"{\"bodystyle\":[\"suv\"],\"cpo_indicator\":false,\"search_range\":\"30\",\"shippable\":true,\"size_slugs\":[\"compact\"],\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"dealer_name":"Joe Machens Nissan","msrp":"0","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","sponsored":false,"photo_count":30,"drivetrain":"All-wheel Drive","trim":"Essence","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Summit White","interior_color":"Ebony Seats","certified_preowned":false,"listing_id":"8fb225bf-8587-4263-8469-4ccf4576ca05","vin":"LRBFZPR44PD066373","nvi_program":false,"customer_id":"5363960","cat":"luxurysuv_crossover","canonical_mmt":"Buick:Envision:Essence","mileage":"42275","fuel_type":"Gasoline","make":"Buick","vertical_position":1,"bodystyle":"SUV","relevancy_score":null,"price":"26436","canonical_mmty":"Buick:Envision:Essence:2023","model":"Envision","sponsored_type":"standard","year":"2023"},{"dealer_name":"Joe Machens Ford","msrp":null,"badges":["great_deal"],"stock_sub":"","sponsored":false,"photo_count":30,"drivetrain":"All-wheel Drive","trim":"2.0T SE","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Kings Red","interior_color":"Black","certified_preowned":false,"listing_id":"2eb5dd4f-c1f9-48ac-b208-dced97e20d9e","vin":"3VV2B7AX3NM027707","nvi_program":false,"customer_id":"6039707","cat":"crossover_compact","canonical_mmt":"Volkswagen:Tiguan:2.0T SE","mileage":"44223","fuel_type":"Gasoline","make":"Volkswagen","vertical_position":2,"bodystyle":"SUV","relevancy_score":null,"price":"21649","canonical_mmty":"Volkswagen:Tiguan:2.0T SE:2022","model":"Tiguan","sponsored_type":"standard","year":"2022"},{"dealer_name":"Subaru of Columbia","msrp":"0","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","sponsored":false,"photo_count":18,"drivetrain":"All-wheel Drive","trim":"Premium","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Crimson Red Pearl","interior_color":"Gray","certified_preowned":false,"listing_id":"7582afff-5c5d-4345-b615-f78243e78f8e","vin":"JF2SKAEC0NH486640","nvi_program":false,"customer_id":"6066303","cat":"crossover_compact","canonical_mmt":"Subaru:Forester:Premium","mileage":"91200","fuel_type":"Gasoline","make":"Subaru","vertical_position":3,"bodystyle":"SUV","relevancy_score":null,"price":"19400","canonical_mmty":"Subaru:Forester:Premium:2022","model":"Forester","sponsored_type":"standard","year":"2022"},{"dealer_name":"Joe Machens Nissan","msrp":"0","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","sponsored":false,"photo_count":28,"drivetrain":"All-wheel Drive","trim":"SL","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Brilliant Silver Metallic","interior_color":"Charcoal","certified_preowned":false,"listing_id":"582e899f-e7b7-4aa1-a47f-a4df5a43e568","vin":"5N1BT3CB1PC758898","nvi_program":false,"customer_id":"5363960","cat":"crossover_compact","canonical_mmt":"Nissan:Rogue:SL","mileage":"28514","fuel_type":"Gasoline","make":"Nissan","vertical_position":4,"bodystyle":"SUV","relevancy_score":null,"price":"25845","canonical_mmty":"Nissan:Rogue:SL:2023","model":"Rogue","sponsored_type":"standard","year":"2023"},{"dealer_name":"Columbia Honda","msrp":"0","badges":["great_deal"],"stock_sub":"","sponsored":false,"photo_count":33,"drivetrain":"All-wheel Drive","trim":"B5 Plus Bright Theme","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Gray","interior_color":"Charcoal","certified_preowned":false,"listing_id":"d015cefe-b2ae-420c-95ab-d1c63c993101","vin":"YV4L12RN3P1353998","nvi_program":false,"customer_id":"5354599","cat":"luxurysuv_crossover","canonical_mmt":"Volvo:XC60:B5 Plus Bright Theme","mileage":"69708","fuel_type":"Gasoline","make":"Volvo","vertical_position":5,"bodystyle":"SUV","relevancy_score":null,"price":"26300","canonical_mmty":"Volvo:XC60:B5 Plus Bright Theme:2023","model":"XC60","sponsored_type":"standard","year":"2023"},{"dealer_name":"Kia of Columbia","msrp":"0","badges":["price_drop_in_cents","great_deal"],"stock_sub":"","sponsored":false,"photo_count":32,"drivetrain":"Front-wheel Drive","trim":"2.0T SE","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Pure White","interior_color":"Titan Black","certified_preowned":false,"listing_id":"6be1885f-31ff-4677-842b-de9fba2bb3c1","vin":"3VV3B7AX5NM026577","nvi_program":false,"customer_id":"5395269","cat":"crossover_compact","canonical_mmt":"Volkswagen:Tiguan:2.0T SE","mileage":"55444","fuel_type":"Gasoline","make":"Volkswagen","vertical_position":6,"bodystyle":"SUV","relevancy_score":null,"price":"18699","canonical_mmty":"Volkswagen:Tiguan:2.0T SE:2022","model":"Tiguan","sponsored_type":"standard","year":"2022"},{"dealer_name":"Columbia Honda","msrp":"0","badges":["fair_deal"],"stock_sub":"","sponsored":false,"photo_count":37,"drivetrain":"Front-wheel Drive","trim":"2.0T SE","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Deep Black Pearl","interior_color":"Titan Black","certified_preowned":false,"listing_id":"c6fae7b3-ae0e-4e94-b25b-b8a6c2a713ac","vin":"3VVNB7AX2RM200281","nvi_program":false,"customer_id":"5354599","cat":"crossover_compact","canonical_mmt":"Volkswagen:Tiguan:2.0T SE","mileage":"34043","fuel_type":"Gasoline","make":"Volkswagen","vertical_position":7,"bodystyle":"SUV","relevancy_score":null,"price":"21700","canonical_mmty":"Volkswagen:Tiguan:2.0T SE:2024","model":"Tiguan","sponsored_type":"standard","year":"2024"},{"dealer_name":"Columbia Honda","msrp":"0","badges":["price_drop_in_cents","fair_deal"],"stock_sub":"","sponsored":false,"photo_count":38,"drivetrain":"Front-wheel Drive","trim":"S","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Super Black","interior_color":"Charcoal","certified_preowned":false,"listing_id":"daeecf51-87c2-42bb-ac5a-658350a45e60","vin":"5N1BT3AA1PC895219","nvi_program":false,"customer_id":"5354599","cat":"crossover_compact","canonical_mmt":"Nissan:Rogue:S","mileage":"60378","fuel_type":"Gasoline","make":"Nissan","vertical_position":8,"bodystyle":"SUV","relevancy_score":null,"price":"17000","canonical_mmty":"Nissan:Rogue:S:2023","model":"Rogue","sponsored_type":"standard","year":"2023"},{"dealer_name":"Joe Machens Volkswagen","msrp":"0","badges":["price_drop_in_cents","great_deal","american_made_index_ranking","hot_car"],"stock_sub":"","sponsored":false,"photo_count":44,"drivetrain":"All-wheel Drive","trim":"SV","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Super Black","interior_color":"Charcoal","certified_preowned":false,"listing_id":"56e205b9-bc6e-4656-a25c-1d61e4eb27cf","vin":"5N1BT3BB2RC694388","nvi_program":false,"customer_id":"5364038","cat":"crossover_compact","canonical_mmt":"Nissan:Rogue:SV","mileage":"52803","fuel_type":"Gasoline","make":"Nissan","vertical_position":9,"bodystyle":"SUV","relevancy_score":null,"price":"19839","canonical_mmty":"Nissan:Rogue:SV:2024","model":"Rogue","sponsored_type":"standard","year":"2024"},{"dealer_name":"Joe Machens Toyota","msrp":"0","badges":["price_drop_in_cents","good_deal","hot_car"],"stock_sub":"","sponsored":false,"photo_count":42,"drivetrain":"All-wheel Drive","trim":"Platinum","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Caspian Blue Metallic","interior_color":"Charcoal","certified_preowned":false,"listing_id":"d658b85c-8e58-464a-845d-3372f94d6d9b","vin":"JN8AT3DD2MW308420","nvi_program":false,"customer_id":"5363961","cat":"crossover_compact","canonical_mmt":"Nissan:Rogue:Platinum","mileage":"77635","fuel_type":"Gasoline","make":"Nissan","vertical_position":10,"bodystyle":"SUV","relevancy_score":null,"price":"20491","canonical_mmty":"Nissan:Rogue:Platinum:2021","model":"Rogue","sponsored_type":"standard","year":"2021"},{"dealer_name":"Joe Machens Hyundai","msrp":"0","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","sponsored":false,"photo_count":37,"drivetrain":"All-wheel Drive","trim":"2.0T Tech Premium","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Ibis White","interior_color":"Atlas Beige","certified_preowned":false,"listing_id":"84aaea28-d503-45dd-bd33-6a16618ded2b","vin":"WA1BNAFY5J2012206","nvi_program":false,"customer_id":"5363959","cat":"luxurysuv_crossover","canonical_mmt":"Audi:Q5:2.0T Tech Premium","mileage":"106451","fuel_type":"Gasoline","make":"Audi","vertical_position":11,"bodystyle":"SUV","relevancy_score":null,"price":"13800","canonical_mmty":"Audi:Q5:2.0T Tech Premium:2018","model":"Q5","sponsored_type":"standard","year":"2018"},{"dealer_name":"Joe Machens Hyundai","msrp":"0","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","sponsored":false,"photo_count":32,"drivetrain":"All-wheel Drive","trim":"2.0T SE 4MOTION","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Platinum Gray Metallic","interior_color":"Titan Black","certified_preowned":false,"listing_id":"522e49f3-42eb-4f6c-a8ce-823fe696290d","vin":"3VV2B7AX5PM053583","nvi_program":false,"customer_id":"5363959","cat":"crossover_compact","canonical_mmt":"Volkswagen:Tiguan:2.0T SE 4MOTION","mileage":"74202","fuel_type":"Gasoline","make":"Volkswagen","vertical_position":12,"bodystyle":"SUV","relevancy_score":null,"price":"18949","canonical_mmty":"Volkswagen:Tiguan:2.0T SE 4MOTION:2023","model":"Tiguan","sponsored_type":"standard","year":"2023"},{"dealer_name":"CDJR of Columbia","msrp":"0","badges":["great_deal"],"stock_sub":"","sponsored":false,"photo_count":41,"drivetrain":"Front-wheel Drive","trim":"2.0T SE R-Line Black","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Pure White","interior_color":"Titan Black","certified_preowned":false,"listing_id":"61e8e2d4-edf2-4455-b6b3-1821308871a2","vin":"3VV3B7AX3MM003586","nvi_program":false,"customer_id":"5363962","cat":"crossover_compact","canonical_mmt":"Volkswagen:Tiguan:2.0T SE R-Line Black","mileage":"131098","fuel_type":"Gasoline","make":"Volkswagen","vertical_position":13,"bodystyle":"SUV","relevancy_score":null,"price":"14000","canonical_mmty":"Volkswagen:Tiguan:2.0T SE R-Line Black:2021","model":"Tiguan","sponsored_type":"standard","year":"2021"},{"dealer_name":"Top Quality Motors","msrp":"0","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","sponsored":false,"photo_count":30,"drivetrain":"All-wheel Drive","trim":"Limited","dealer_zip":"65010","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"BROWN","interior_color":"Black","certified_preowned":false,"listing_id":"416b567d-0598-41f1-831e-16c4ebd2e747","vin":"JF2SKASC2KH400910","nvi_program":false,"customer_id":"113689","cat":"crossover_compact","canonical_mmt":"Subaru:Forester:Limited","mileage":"93167","fuel_type":"Gasoline","make":"Subaru","vertical_position":14,"bodystyle":"SUV","relevancy_score":null,"price":"16999","canonical_mmty":"Subaru:Forester:Limited:2019","model":"Forester","sponsored_type":"standard","year":"2019"},{"dealer_name":"CDJR of Columbia","msrp":"0","badges":["good_deal"],"stock_sub":"","sponsored":false,"photo_count":41,"drivetrain":"All-wheel Drive","trim":"T5 Premier","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Crystal White Pearl","interior_color":"Blond/Off-Black","certified_preowned":false,"listing_id":"069d06a3-8c65-49d1-ba57-eac4a9fa39de","vin":"YV4612RK7G2782963","nvi_program":false,"customer_id":"5363962","cat":"luxurysuv_crossover","canonical_mmt":"Volvo:XC60:T5 Premier","mileage":"110095","fuel_type":"Gasoline","make":"Volvo","vertical_position":15,"bodystyle":"SUV","relevancy_score":null,"price":"9999","canonical_mmty":"Volvo:XC60:T5 Premier:2016","model":"XC60","sponsored_type":"standard","year":"2016"},{"dealer_name":"BMW of Columbia - MO","msrp":"0","badges":["price_drop_in_cents","fair_deal"],"stock_sub":"","sponsored":false,"photo_count":37,"drivetrain":"All-wheel Drive","trim":"xDrive30i","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Alpine White","interior_color":"Black","certified_preowned":false,"listing_id":"0853c18c-f329-4437-b4b1-6d1320e06d5c","vin":"5UX53DP01N9J98454","nvi_program":false,"customer_id":"152419","cat":"luxurysuv_crossover","canonical_mmt":"BMW:X3:xDrive30i","mileage":"29338","fuel_type":"Gasoline","make":"BMW","vertical_position":16,"bodystyle":"SUV","relevancy_score":null,"price":"33289","canonical_mmty":"BMW:X3:xDrive30i:2022","model":"X3","sponsored_type":"standard","year":"2022"},{"dealer_name":"BMW of Columbia - MO","msrp":"0","badges":["good_deal"],"stock_sub":"","sponsored":false,"photo_count":33,"drivetrain":"Front-wheel Drive","trim":"S","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Brilliant Silver","interior_color":"Charcoal","certified_preowned":false,"listing_id":"c8c37d43-994d-4ef0-be5b-a9a5ffe3ac94","vin":"JN8AT2MT9GW025955","nvi_program":false,"customer_id":"152419","cat":"crossover_compact","canonical_mmt":"Nissan:Rogue:S","mileage":"79358","fuel_type":"Gasoline","make":"Nissan","vertical_position":17,"bodystyle":"SUV","relevancy_score":null,"price":"11995","canonical_mmty":"Nissan:Rogue:S:2016","model":"Rogue","sponsored_type":"standard","year":"2016"},{"dealer_name":"Mazda of Columbia","msrp":null,"badges":["price_drop_in_cents","great_deal"],"stock_sub":"","sponsored":false,"photo_count":28,"drivetrain":"All-wheel Drive","trim":"Limited","dealer_zip":"65202","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Horizon Blue Pearl","interior_color":"Gray","certified_preowned":false,"listing_id":"06c284f4-d632-423a-a7e8-ae16df067379","vin":"JF2SKAPCXPH412545","nvi_program":false,"customer_id":"5364156","cat":"crossover_compact","canonical_mmt":"Subaru:Forester:Limited","mileage":"100290","fuel_type":"Gasoline","make":"Subaru","vertical_position":18,"bodystyle":"SUV","relevancy_score":null,"price":"19800","canonical_mmty":"Subaru:Forester:Limited:2023","model":"Forester","sponsored_type":"standard","year":"2023"},{"dealer_name":"BMW of Columbia - MO","msrp":"0","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","sponsored":false,"photo_count":35,"drivetrain":"Four-wheel Drive","trim":"Sport S","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"Bright White Clearcoat","interior_color":"Black","certified_preowned":false,"listing_id":"53418fe2-1767-47da-8d73-6413c4aef229","vin":"1C4HJXDN4PW562599","nvi_program":false,"customer_id":"152419","cat":"suv_midsize","canonical_mmt":"Jeep:Wrangler:Sport S","mileage":"22000","fuel_type":"Gasoline","make":"Jeep","vertical_position":19,"bodystyle":"SUV","relevancy_score":null,"price":"28989","canonical_mmty":"Jeep:Wrangler:Sport S:2023","model":"Wrangler","sponsored_type":"standard","year":"2023"},{"dealer_name":"Joe Machens Ford","msrp":null,"badges":["price_drop_in_cents","fair_deal"],"stock_sub":"","sponsored":false,"photo_count":30,"drivetrain":"All-wheel Drive","trim":"SLE","dealer_zip":"65203","cpo_package":null,"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"exterior_color":"White","interior_color":"Jet Black","certified_preowned":false,"listing_id":"5626b81d-3b0c-42ab-be0f-b666d6944433","vin":"3GKALTEX8LL276182","nvi_program":false,"customer_id":"6039707","cat":"crossover_midsize","canonical_mmt":"GMC:Terrain:SLE","mileage":"83668","fuel_type":"Gasoline","make":"GMC","vertical_position":20,"bodystyle":"SUV","relevancy_score":null,"price":"19854","canonical_mmty":"GMC:Terrain:SLE:2020","model":"Terrain","sponsored_type":"standard","year":"2020"}]}]