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
665 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: Ceramic White
Int. color: Ebony
Drivetrain: Four-wheel Drive
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 3.5L V-6 port/direct injection, DOHC, variable valve co
Stock #: M5761A
VIN: 5LMJJ3LTXLEL08429

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

Reviews

Mercedes-Benz of Columbia review

Best place to go if your looking for a used car.

Had a wonderful experience. Key'n was a great help with helping us find the car we wanted. Would recommend him to anyone buying a car.

2020 Lincoln Navigator Reserve review

I have only owned this vehicle for a month and I am still

I have only owned this vehicle for a month and I am still learning all of the mechanical and tech of it, it drives great, has been performing as expected and the look is very appealing, a very high quality car, only problem is price

Vehicle information

Ext. color: Platinum Gray Metallic
Drivetrain: All-wheel Drive
MPG: 19-25
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: RC536455
VIN: 1V2FR2CA9RC536455

Features

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

2024 Volkswagen Atlas 2.0T SEL Premium R-Line 4MOTION review

Only have it six months, bought it spur of the moment!

Only have it six months, bought it spur of the moment! my wife thought i was crazy! I owned Many cars and have a few now this is a good SUV 30 Thousand less than the Audi Q 7 but made the same , only inside and outside different.

Vehicle information

Ext. color: Ice Silver Metallic
Int. color: Black
MPG: 26-33
Fuel type: Gasoline
Transmission: CVT Lineartronic
Engine: 2.5L 4-Cylinder DOHC 16V
Stock #: M3159589
VIN: 4S4BTANC9M3159589

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System, Power Liftgate
Entertainment: Android Auto®, Apple CarPlay®, HomeLink, Premium Sound System
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Stability Control
Seating: Memory Seat

Reviews

2021 Subaru Outback Limited review

So I bought a ‘21 Outback premium with 30k miles and have

So I bought a ‘21 Outback premium with 30k miles and have already put 6K more on it. Here is my honest review: if you want a fast car don’t get the 2.5 non turbo- that being said it is adequate for myself and get great gas mileage. The interior is good- I have the spec with cloth heated seats and they are comfortable and the cabin feels nice- has some cheap parts but I knew what I was buying. The infotainment is frustrating at times- auto start stop is a pain in the butt- but the infotainment itself isn’t bad with good sound and good responsiveness. The apple CarPlay will lag and be finicky at times but nothing terrible. As for drive quality it is a smooth ride and I don’t have any real complaints yet. Like I had mentioned if you want a car that is going to be fast- this engine and transmission will not do that for you. Overall I am happy so far with my purchase and feel as though I made a sensible decision when choosing this over some of its competition (I was looking at the VW Tiguan and and Mazda cx5)

Vehicle information

Ext. color: Super Black
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L I3 Turbocharged DOHC 12V LEV3-ULEV50 201hp
Stock #: PC869316
VIN: 5N1BT3AB0PC869316

Features

Convenience: Heated Seats, 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

Joe Machens Nissan review

Great people

Scott Glasgow was very helpful. He actually listened to our needs and provided solutions. He cares for his customers and we are glad to know him.

2023 Nissan Rogue S 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: Sapphire Metallic
Int. color: Ebony w/Ebony Accents
Drivetrain: All-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: PD021103
VIN: LRBFZMR45PD021103

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
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Reviews

2023 Buick Envision Preferred AWD review

As over many years Buick is in the background, however I

As over many years Buick is in the background, however I have owned both, and the Buick outshine the Cadillac ever year. If you want to impress other 's and spend money go with the Cadillac if you want to enjoy your car buy the Buick. That said start looking at the envision on up

Vehicle information

Ext. color: Sunshine Orange Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.0L I4 16V MPFI DOHC
Stock #: RU001211
VIN: JA4ARUAU1RU001211

Features

Convenience: Keyless Entry
Entertainment: Bluetooth®, USB Port
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Stability Control

Reviews

2024 Mitsubishi Outlander Sport 2.0 S review

traded my 2021 for a 2024 Mitsubishi Outlander Sport

traded my 2021 for a 2024 Mitsubishi Outlander Sport limited edition last month. I'm very happy with it. Mitsubishi has made some improvements. bigger screen, leather steering wheel and shifter. I like that I have heated seats and telescoping steering wheel now! and it's 4 wheel drive. helps when I go fishing. 😂 great gas mileage! just needs a little more power under the hood. but for the price and reliability it's very worth it. plus an amazing warranty!

Vehicle information

Ext. color: Classic Silver Metallic
Int. color: Black/Graphite
Drivetrain: Four-wheel Drive
MPG: 16-19
Fuel type: Gasoline
Transmission: Automatic
Engine: 4L V-6 DOHC, VVT-i variable valve control, regular unleaded, eng
Stock #: R6287562
VIN: JTEMU5JR8R6287562

Features

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

Reviews

Columbia Honda review

Great Experience

I Bought a new car there and didn't even have to come to the dealer. They were very helpful. I Would definitely do business there again.

2024 Toyota 4Runner SR5 review

I have yet to get this 2024 4runner TRD Pro stuck, and I

I have yet to get this 2024 4runner TRD Pro stuck, and I have tried. Love this thing. Its already made it across the country and back. Ive had it since April of 2024 and about to break 20k miles. Had water to the bumper and mud to the frame and this thing keeps on ticking wheels keep turnin.

Vehicle information

Ext. color: Labrador Black Pearl
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 DOHC, MIVEC variable valve control, regular unleaded, eng
Stock #: RU017642
VIN: JA4ARUAU9RU017642

Features

Convenience: Keyless Entry
Entertainment: Bluetooth®
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Stability Control

Reviews

Columbia Honda review

Excellent service and friendly staff

Wonderful service, a very comfortable place to wait with snacks and even doggy treats. We purchased our car from Columbia Honda and will definitely return when we are ready to trade. All staff are very friendly.

2024 Mitsubishi Outlander Sport 2.0 ES review

Before I bought this I was driving a BMW 330i xdrive

Before I bought this I was driving a BMW 330i xdrive great car. But I wanted something which much more room and reliable. I had this car about 10 years ago and loved it. It’s great on gas drive smooth wish the engine would have a little more power. The interior is super comfy but feels a bit outdated. I feel like for a 28k car called sport it should be a little more sporty. Like electric seats fr example. But other than that interior is great heated seat are great ! Driving is alright and overall all I’ll give it a 4 out of 5 !

Vehicle information

Ext. color: Ibis White
Int. color: Okapi Brown
Drivetrain: All-wheel Drive
MPG: 23-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: M5976B
VIN: WA1EAAFY8N2076223

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Power Liftgate
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, USB Port
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, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Mercedes-Benz of Columbia review

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

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

2022 Audi Q5 45 S line Premium Plus review

Luxury Performance

The black 2022 Audi Q5 is great looking and has amazing performance! My only complaint would be I've had a couple of small problems you wouldn't expect from a brand new car! I.e.- Rear hatch doesn't close all the way sometimes & pops up. It stays closed but not tight and the dash light comes on, tire pressure doesn't consistently stay the same?(No idea why but definitely unusual)

Vehicle information

Ext. color: Sting Gray Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.6L V6 24V MPFI DOHC
Stock #: LC378050
VIN: 1C4RJFLG2LC378050

Features

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

Reviews

2020 Jeep Grand Cherokee Trailhawk review

Snow commuter

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

Vehicle information

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

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

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.

2024 Jeep Grand Cherokee Limited review

Have owned Jeeps for 35 years.

Have owned Jeeps for 35 years. This is the most comfortable ever. Altitude 4x2 L, V6, avg. 19-24 MPG. Tow up to 8,000. 6 passenger with 2 fold downs in back. Paid 34k with 18k miles

Vehicle information

Ext. color: Brilliant Silver Metallic
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 1.5L I3 12V GDI DOHC Turbo
Stock #: RC692446
VIN: 5N1BT3BB2RC692446

Features

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

Reviews

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: Crystal Black Silica
Int. color: Black
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 #: PH448699
VIN: JF2SKARC1PH448699

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

2023 Subaru Forester Touring 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: Velvet Red Pearlcoat
Int. color: Wicker Beige/Black
Drivetrain: Four-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.6L V6 24V VVT
Stock #: SC272020
VIN: 1C4RJHBG6SC272020

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, Sunroof/Moonroof, 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

Reviews

Joe Machens Nissan review

Salesman Scott glascow

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

2025 Jeep Grand Cherokee Limited review

What a great look.

What a great look. I have bought several cars and trucks over the past few years, from 2 trucks for me and helped the family with other cars. I wanted to get something for looks and the 2025 Grand Cherokee fit the bill. Style and looks, 10 out of 10 in my opinion. Good on the mileage and performance. Great dealership and people at Ray's CDJR in Fox Lake. They treat you like you should be, with respect through the entire process.

Vehicle information

Ext. color: Wolf Gray
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: Automatic
Engine: LAMBDA II 3.8L V-6 gasoline direct injection, DOHC, D-CVVT varia
Stock #: MG170055
VIN: 5XYP3DHC1MG170055

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

Reviews

2021 Kia Telluride EX review

Excellent Telluride

Bought this car as a retired couple to travel in. Lots of room for anything you need to carry while traveling or shopping. Also used to do day road trips with two more couples. Easy for us oldies to get in the second and third row seats, or go on outings with up to 7 people. Love the charging ports for everyone in the car. It has been a very dependable vehicle.

Vehicle information

Ext. color: Super Black
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: Automatic
Engine: VC-Turbo 1.5L I-3 gasoline direct injection, DOHC, CVTCS variabl
Stock #: RC698659
VIN: 5N1BT3BB5RC698659

Features

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

Reviews

Columbia Honda review

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 Nissan Rogue SV review

I'm in the car I always wanted!

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

Vehicle information

Ext. color: Bright White Clearcoat
Int. color: 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 #: GC381735
VIN: 1C4RJFBG6GC381735

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Bluetooth®, Satellite Radio, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Joe Machens Volkswagen review

Better than EXCELLENT -- Not just a VW Dealer!

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

2016 Jeep Grand Cherokee Limited review

My dream car since a teenager was a grand Cherokee and

My dream car since a teenager was a grand Cherokee and when I finally got one in 2021, I’ve loved it the same ever since. They are bold in appearance and look like a strong vehicle. It has always run beautifully and I have had no issues thus far since 2021 and now it’s 2024. Very comfortable interior and attractive to the eye. Love love love my car.

Vehicle information

Ext. color: Pure White
Int. color: Titan Black
Drivetrain: All-wheel Drive
MPG: 17-23
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.6L V-6 gasoline direct injection, DOHC, variable valve control
Stock #: JC568810
VIN: 1V2RR2CA7JC568810

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

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!

2018 Volkswagen Atlas 3.6L SEL review

Black beauty

I have had my Altas for over 4 years and I keep on falling in love with it each and very day. Extremely comfortable space and overall a perfect size SUV for a family of 5. We have had and continue to have amazing long road trips with this beauty and we will carry the memories we continue to make in our heart for the rest of our lives.

Vehicle information

Ext. color: Silver Mist Metallic
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 #: RC526160
VIN: 1V2HR2CA5RC526160

Features

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

Reviews

Joe Machens Volkswagen review

Great Service Center

Excellent facilities and staff who treat you like you're the most important customer, regardless of how much you're spending in the service department. Quick, efficient check-in and check-out, and they make it clear that they want you to leave satisfied. Nice waiting area as well.

2024 Volkswagen Atlas 2.0T SE w/Technology 4MOTION review

Best SUV you can buy

I have owned the Atlas SE 2024 for 6 months and loved it 100% the digital controls is like a smart phone, you will get used to it once you know where everything is at. The best car I have purchased in 30 years

Vehicle information

Ext. color: Shimmering Silver
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 25-28
Fuel type: Gasoline
Transmission: Automatic
Engine: Smartstream 2.5L I-4 port/direct injection, DOHC, D-CVVT variabl
Stock #: MH368125
VIN: 5NMS24AJ6MH368125

Features

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

Reviews

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.

2021 Hyundai SANTA FE SEL 2.4 review

Amazing SUV

When shopping for our Santa Fe, we looked at many different models brands and sizes some smaller some larger and felt very comfortable with the size of this vehicle. The interior is beautiful and lacks the big TV screen that many of the SUVs have that I didn’t care for. After driving it, I was impressed with its cornering handling breaking an overall driving position. I now have 15,000 miles on it and I’m totally impressed with its comfort and all of the safety features. Some of the smaller SUVs we drove were noisy, and I felt every bump on the road, some of the larger SUVs were just too big. I was impressed with how quiet this car was and how it smoothed out lot of the rough roads that we have here in California. We have the SEL model with a 2.5 L turbo charged engine that has plenty of power and decent fuel economy. I get over 30 miles per gallon on the highway and 25 miles per gallon in town. This is an amazing vehicle that drove nicer both in town and freeway than many other SUVs costing thousand more.

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 $13,364.

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 IQ 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 21922 great deals out of 66539 listings starting at $1,192.

Where can I find the most SUV deals?

The most SUV deals can be found near Columbia, MO with 352 great deals out of 1074 listings starting at $3,950.

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

665 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":[{"sponsored_type":"standard","year":"2020","stock_type":"Used","cat":"luxurysuv_suv","interior_color":"Ebony","photo_count":39,"trim":"Reserve","vin":"5LMJJ3LTXLEL08429","bodystyle":"SUV","badges":["good_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Lincoln:Navigator:Reserve","mileage":"93715","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Mercedes-Benz of Columbia","certified_preowned":false,"relevancy_score":null,"exterior_color":"Ceramic White","msrp":"0","listing_id":"040544af-665d-42d7-b0ca-61a4cc8ee0e2","seller_type":"dealership","vertical_position":1,"make":"Lincoln","canonical_mmty":"Lincoln:Navigator:Reserve:2020","dealer_zip":"65203","price":"35588","drivetrain":"Four-wheel Drive","model":"Navigator","nvi_program":false,"customer_id":"5243424"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"crossover_midsize","interior_color":null,"photo_count":18,"trim":"2.0T SEL Premium R-Line 4MOTION","vin":"1V2FR2CA9RC536455","bodystyle":"SUV","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Volkswagen:Atlas:2.0T SEL Premium R-Line 4MOTION","mileage":"37150","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Subaru of Columbia","certified_preowned":false,"relevancy_score":null,"exterior_color":"Platinum Gray Metallic","msrp":"0","listing_id":"fee608b0-6440-4418-b1f1-ef755dbb6c78","seller_type":"dealership","vertical_position":2,"make":"Volkswagen","canonical_mmty":"Volkswagen:Atlas:2.0T SEL Premium R-Line 4MOTION:2024","dealer_zip":"65203","price":"34500","drivetrain":"All-wheel Drive","model":"Atlas","nvi_program":false,"customer_id":"6066303"},{"sponsored_type":"standard","year":"2021","stock_type":"Used","cat":"wagonhatchback_wagon","interior_color":"Black","photo_count":18,"trim":"Limited","vin":"4S4BTANC9M3159589","bodystyle":"SUV","badges":["great_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Subaru:Outback:Limited","mileage":"76840","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Subaru of Columbia","certified_preowned":false,"relevancy_score":null,"exterior_color":"Ice Silver Metallic","msrp":"0","listing_id":"934de025-092c-4d16-a9f9-740ffe1375b5","seller_type":"dealership","vertical_position":3,"make":"Subaru","canonical_mmty":"Subaru:Outback:Limited:2021","dealer_zip":"65203","price":"21500","drivetrain":null,"model":"Outback","nvi_program":false,"customer_id":"6066303"},{"sponsored_type":"standard","year":"2023","stock_type":"Used","cat":"crossover_compact","interior_color":"Charcoal","photo_count":32,"trim":"S","vin":"5N1BT3AB0PC869316","bodystyle":"SUV","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Nissan:Rogue:S","mileage":"102755","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Nissan","certified_preowned":false,"relevancy_score":null,"exterior_color":"Super Black","msrp":"0","listing_id":"d834c7c4-b199-4a05-9290-f2b4729024a2","seller_type":"dealership","vertical_position":4,"make":"Nissan","canonical_mmty":"Nissan:Rogue:S:2023","dealer_zip":"65203","price":"17700","drivetrain":"All-wheel Drive","model":"Rogue","nvi_program":false,"customer_id":"5363960"},{"sponsored_type":"standard","year":"2023","stock_type":"Used","cat":"luxurysuv_crossover","interior_color":"Ebony w/Ebony Accents","photo_count":16,"trim":"Preferred AWD","vin":"LRBFZMR45PD021103","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Buick:Envision:Preferred AWD","mileage":"47770","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Subaru of Columbia","certified_preowned":false,"relevancy_score":null,"exterior_color":"Sapphire Metallic","msrp":"0","listing_id":"c73d66ef-92a1-48e9-a604-8a342b85b1a7","seller_type":"dealership","vertical_position":5,"make":"Buick","canonical_mmty":"Buick:Envision:Preferred AWD:2023","dealer_zip":"65203","price":"23500","drivetrain":"All-wheel Drive","model":"Envision","nvi_program":false,"customer_id":"6066303"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"crossover_compact","interior_color":"Black","photo_count":29,"trim":"2.0 S","vin":"JA4ARUAU1RU001211","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Mitsubishi:Outlander Sport:2.0 S","mileage":"53599","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Ford","certified_preowned":false,"relevancy_score":null,"exterior_color":"Sunshine Orange Metallic","msrp":null,"listing_id":"089b35ff-f086-47a6-a590-23509621a03c","seller_type":"dealership","vertical_position":6,"make":"Mitsubishi","canonical_mmty":"Mitsubishi:Outlander Sport:2.0 S:2024","dealer_zip":"65203","price":"16995","drivetrain":"Four-wheel Drive","model":"Outlander Sport","nvi_program":false,"customer_id":"6039707"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"suv_midsize","interior_color":"Black/Graphite","photo_count":32,"trim":"SR5","vin":"JTEMU5JR8R6287562","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Toyota:4Runner:SR5","mileage":"33116","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Columbia Honda","certified_preowned":false,"relevancy_score":null,"exterior_color":"Classic Silver Metallic","msrp":"0","listing_id":"b9636f83-dde0-42c4-9944-7fa5e370784e","seller_type":"dealership","vertical_position":7,"make":"Toyota","canonical_mmty":"Toyota:4Runner:SR5:2024","dealer_zip":"65202","price":"34200","drivetrain":"Four-wheel Drive","model":"4Runner","nvi_program":false,"customer_id":"5354599"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"crossover_compact","interior_color":"Black","photo_count":32,"trim":"2.0 ES","vin":"JA4ARUAU9RU017642","bodystyle":"SUV","badges":["price_drop_in_cents","good_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Mitsubishi:Outlander Sport:2.0 ES","mileage":"26271","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Columbia Honda","certified_preowned":false,"relevancy_score":null,"exterior_color":"Labrador Black Pearl","msrp":"0","listing_id":"70b41d2c-d8d8-43a5-9993-96a09fcb09bb","seller_type":"dealership","vertical_position":8,"make":"Mitsubishi","canonical_mmty":"Mitsubishi:Outlander Sport:2.0 ES:2024","dealer_zip":"65202","price":"19000","drivetrain":"Four-wheel Drive","model":"Outlander Sport","nvi_program":false,"customer_id":"5354599"},{"sponsored_type":"standard","year":"2022","stock_type":"Used","cat":"luxurysuv_crossover","interior_color":"Okapi Brown","photo_count":35,"trim":"45 S line Premium Plus","vin":"WA1EAAFY8N2076223","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Audi:Q5:45 S line Premium Plus","mileage":"74625","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Mercedes-Benz of Columbia","certified_preowned":false,"relevancy_score":null,"exterior_color":"Ibis White","msrp":"0","listing_id":"301f3aff-0231-4a06-9fb5-68eff0b62bc5","seller_type":"dealership","vertical_position":9,"make":"Audi","canonical_mmty":"Audi:Q5:45 S line Premium Plus:2022","dealer_zip":"65203","price":"23859","drivetrain":"All-wheel Drive","model":"Q5","nvi_program":false,"customer_id":"5243424"},{"sponsored_type":"standard","year":"2020","stock_type":"Used","cat":"suv_midsize","interior_color":"Black","photo_count":30,"trim":"Trailhawk","vin":"1C4RJFLG2LC378050","bodystyle":"SUV","badges":["price_drop_in_cents","good_deal","hot_car"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Jeep:Grand Cherokee:Trailhawk","mileage":"76134","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Ford","certified_preowned":false,"relevancy_score":null,"exterior_color":"Sting Gray Clearcoat","msrp":null,"listing_id":"532a14e6-f528-43d7-963f-7c2d071bf570","seller_type":"dealership","vertical_position":10,"make":"Jeep","canonical_mmty":"Jeep:Grand Cherokee:Trailhawk:2020","dealer_zip":"65203","price":"23195","drivetrain":"Four-wheel Drive","model":"Grand Cherokee","nvi_program":false,"customer_id":"6039707"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"suv_midsize","interior_color":"Global Black","photo_count":37,"trim":"Limited","vin":"1C4RJHBG6RC150994","bodystyle":"SUV","badges":["great_deal","american_made_index_ranking"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Jeep:Grand Cherokee:Limited","mileage":"18785","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Columbia Honda","certified_preowned":false,"relevancy_score":null,"exterior_color":"Bright White Clearcoat","msrp":"0","listing_id":"90f0b084-8562-41bd-9ede-cea513156e00","seller_type":"dealership","vertical_position":11,"make":"Jeep","canonical_mmty":"Jeep:Grand Cherokee:Limited:2024","dealer_zip":"65202","price":"36000","drivetrain":"Four-wheel Drive","model":"Grand Cherokee","nvi_program":false,"customer_id":"5354599"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"crossover_compact","interior_color":"Charcoal","photo_count":30,"trim":"SV","vin":"5N1BT3BB2RC692446","bodystyle":"SUV","badges":["price_drop_in_cents","fair_deal","american_made_index_ranking","hot_car"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Nissan:Rogue:SV","mileage":"43820","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Ford","certified_preowned":false,"relevancy_score":null,"exterior_color":"Brilliant Silver Metallic","msrp":null,"listing_id":"62054291-f775-43d0-92c0-b9f70bf448aa","seller_type":"dealership","vertical_position":12,"make":"Nissan","canonical_mmty":"Nissan:Rogue:SV:2024","dealer_zip":"65203","price":"19995","drivetrain":"All-wheel Drive","model":"Rogue","nvi_program":false,"customer_id":"6039707"},{"sponsored_type":"standard","year":"2023","stock_type":"Used","cat":"crossover_compact","interior_color":"Black","photo_count":17,"trim":"Touring","vin":"JF2SKARC1PH448699","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal","hot_car"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Subaru:Forester:Touring","mileage":"39832","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Subaru of Columbia","certified_preowned":false,"relevancy_score":null,"exterior_color":"Crystal Black Silica","msrp":"0","listing_id":"e3227d5b-9382-4e34-81d6-982eb8067075","seller_type":"dealership","vertical_position":13,"make":"Subaru","canonical_mmty":"Subaru:Forester:Touring:2023","dealer_zip":"65203","price":"26500","drivetrain":"All-wheel Drive","model":"Forester","nvi_program":false,"customer_id":"6066303"},{"sponsored_type":"standard","year":"2025","stock_type":"Used","cat":"suv_midsize","interior_color":"Wicker Beige/Black","photo_count":28,"trim":"Limited","vin":"1C4RJHBG6SC272020","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Jeep:Grand Cherokee:Limited","mileage":"18141","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Nissan","certified_preowned":false,"relevancy_score":null,"exterior_color":"Velvet Red Pearlcoat","msrp":"0","listing_id":"fc16758a-a412-485a-a5bf-f414e1f73ad4","seller_type":"dealership","vertical_position":14,"make":"Jeep","canonical_mmty":"Jeep:Grand Cherokee:Limited:2025","dealer_zip":"65203","price":"37493","drivetrain":"Four-wheel Drive","model":"Grand Cherokee","nvi_program":false,"customer_id":"5363960"},{"sponsored_type":"standard","year":"2021","stock_type":"Used","cat":"suv_midsize","interior_color":"Black","photo_count":15,"trim":"EX","vin":"5XYP3DHC1MG170055","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Kia:Telluride:EX","mileage":"90230","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Subaru of Columbia","certified_preowned":false,"relevancy_score":null,"exterior_color":"Wolf Gray","msrp":"0","listing_id":"d9b64955-834e-4bd1-9238-80690cccd92a","seller_type":"dealership","vertical_position":15,"make":"Kia","canonical_mmty":"Kia:Telluride:EX:2021","dealer_zip":"65203","price":"23200","drivetrain":"All-wheel Drive","model":"Telluride","nvi_program":false,"customer_id":"6066303"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"crossover_compact","interior_color":"Charcoal","photo_count":32,"trim":"SV","vin":"5N1BT3BB5RC698659","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Nissan:Rogue:SV","mileage":"41831","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Columbia Honda","certified_preowned":false,"relevancy_score":null,"exterior_color":"Super Black","msrp":"0","listing_id":"6e05e8c0-84e8-4cf9-8370-41335cbb40b7","seller_type":"dealership","vertical_position":16,"make":"Nissan","canonical_mmty":"Nissan:Rogue:SV:2024","dealer_zip":"65202","price":"20800","drivetrain":"All-wheel Drive","model":"Rogue","nvi_program":false,"customer_id":"5354599"},{"sponsored_type":"standard","year":"2016","stock_type":"Used","cat":"suv_midsize","interior_color":"Black","photo_count":6,"trim":"Limited","vin":"1C4RJFBG6GC381735","bodystyle":"SUV","badges":["fair_deal","hot_car"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Jeep:Grand Cherokee:Limited","mileage":"111480","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Volkswagen","certified_preowned":false,"relevancy_score":null,"exterior_color":"Bright White Clearcoat","msrp":"0","listing_id":"d4651a47-ec0c-466e-b5ae-a93d070c2d05","seller_type":"dealership","vertical_position":17,"make":"Jeep","canonical_mmty":"Jeep:Grand Cherokee:Limited:2016","dealer_zip":"65202","price":"13204","drivetrain":"Four-wheel Drive","model":"Grand Cherokee","nvi_program":false,"customer_id":"5364038"},{"sponsored_type":"standard","year":"2018","stock_type":"Used","cat":"crossover_midsize","interior_color":"Titan Black","photo_count":35,"trim":"3.6L SEL","vin":"1V2RR2CA7JC568810","bodystyle":"SUV","badges":["fair_deal","hot_car"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Volkswagen:Atlas:3.6L SEL","mileage":"141326","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Columbia Honda","certified_preowned":false,"relevancy_score":null,"exterior_color":"Pure White","msrp":"0","listing_id":"18fdc1c8-6a52-491f-aa85-437e15ad3fe0","seller_type":"dealership","vertical_position":18,"make":"Volkswagen","canonical_mmty":"Volkswagen:Atlas:3.6L SEL:2018","dealer_zip":"65202","price":"12700","drivetrain":"All-wheel Drive","model":"Atlas","nvi_program":false,"customer_id":"5354599"},{"sponsored_type":"standard","year":"2024","stock_type":"Used","cat":"crossover_midsize","interior_color":"Titan Black","photo_count":45,"trim":"2.0T SE w/Technology 4MOTION","vin":"1V2HR2CA5RC526160","bodystyle":"SUV","badges":["price_drop_in_cents","fair_deal","american_made_index_ranking","hot_car"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION","mileage":"47685","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Volkswagen","certified_preowned":false,"relevancy_score":null,"exterior_color":"Silver Mist Metallic","msrp":"0","listing_id":"cd29c564-dbbc-471f-aa10-d248e1dc5371","seller_type":"dealership","vertical_position":19,"make":"Volkswagen","canonical_mmty":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION:2024","dealer_zip":"65202","price":"29272","drivetrain":"All-wheel Drive","model":"Atlas","nvi_program":false,"customer_id":"5364038"},{"sponsored_type":"standard","year":"2021","stock_type":"Used","cat":"crossover_midsize","interior_color":"Black","photo_count":6,"trim":"SEL 2.4","vin":"5NMS24AJ6MH368125","bodystyle":"SUV","badges":["great_deal"],"stock_sub":"","fuel_type":"Gasoline","canonical_mmt":"Hyundai:SANTA FE:SEL 2.4","mileage":"84230","cpo_indicator":false,"sponsored":false,"cpo_package":null,"dealer_name":"Joe Machens Volkswagen","certified_preowned":false,"relevancy_score":null,"exterior_color":"Shimmering Silver","msrp":"0","listing_id":"acefffdd-657f-4bda-9252-7938ada3cd39","seller_type":"dealership","vertical_position":20,"make":"Hyundai","canonical_mmty":"Hyundai:SANTA FE:SEL 2.4:2021","dealer_zip":"65202","price":"17971","drivetrain":"Front-wheel Drive","model":"SANTA FE","nvi_program":false,"customer_id":"5364038"}]}]