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 $599,963

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
594 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: Stormy Sea
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 22-25
Fuel type: Gasoline
Transmission: Automatic
Engine: Smartstream 2.5L I-4 port/direct injection, DOHC, CVVT variable
Stock #: PH591628
VIN: 5NMS1DAJ8PH591628

Features

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

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.

2023 Hyundai SANTA FE SE review

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

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

Vehicle information

Ext. color: Ice Silver Metallic
Int. color: Slate 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 #: M3159589
VIN: 4S4BTANC9M3159589

Features

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

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: Moonlight Blue Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 18-22
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.9L V-6 gasoline direct injection, DOHC, VarioCam Plus variable
Stock #: M6042A
VIN: WP1AB2AY2MDA28264

Features

Convenience: Keyless Entry, Keyless Start, Navigation System, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Rain Sensing Wipers, Stability Control
Seating: Leather Seats

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.

2021 Porsche Cayenne S review

Beautiful and very fast!!!

I owed a 2010 Cayenne GTS and thought that SUV was awesome. Porsche has really stepped up their game. The 2021 Cayenne GTS is very stunning and drives like a 911. Extremely happy so far!!

Vehicle information

Ext. color: Pearl White Tricoat
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 30-37
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L I3 Turbocharged DOHC 12V LEV3-ULEV50 201hp
Stock #: PC914350
VIN: 5N1BT3BAXPC914350

Features

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

Reviews

Joe Machens Nissan review

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

So far I have been pleased with the performance of my

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

Vehicle information

Ext. color: 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 #: NM009118
VIN: 3VV2B7AX4NM009118

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

2022 Volkswagen Tiguan 2.0T SE 4MOTION 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: 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 #: L3160770
VIN: 4S4BTANC3L3160770

Features

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

Reviews

Joe Machens Volkswagen review

GREAT SERVICE!

Mike Stock, the parts manager is top notch. He goes out of his way to go above and beyond for the customer. A real professional.

2020 Subaru Outback Limited review

Dependable and problem free

Best vehicle I have ever owned. Dependable, safe, comfortable ride, great fit & finish and responsive and overall excellent quality. No problems in 48,000 miles.

Vehicle information

Ext. color: Snow White Pearl
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: Automatic
Engine: Lambda II 3.3L V-6 gasoline direct injection, DOHC, CVVT variabl
Stock #: MU7843C
VIN: 5XYPK4A54JG382815

Features

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

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!

2018 Kia Sorento SX review

What a car! Would recommend this vehicle to anyone

Excellent driving through snow. I have an 81 km one way to work. Never missed a shift. Also very economical with the 2.4 litre inline 4 cylinder. Average on the highway is between 7 - 8 litres per 100 km.

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 to work with!

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

2024 Volkswagen Atlas 2.0T SE w/Technology 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: Atomic Silver
Int. color: Sepia
Drivetrain: Four-wheel Drive
MPG: 15-19
Fuel type: Gasoline
Transmission: Automatic
Engine: 4.6L V-8 DOHC, VVT-i variable valve control, premium unleaded, e
Stock #: MU8255A1
VIN: JTJAM7BX5N5335189

Features

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

Reviews

Mercedes-Benz of Columbia review

I highly recommend Mercedes-Benz of Columbia

I usually do not do reviews, but these guys at Mercedes-Benz of Columbia absolutely deserves more than a 5 star review. Danh Do Finance Manage, and Kofi's Adadey who happened to be my sales person were amazing. Their customer service and lever of customer engagement is "Bar None"!!!!. The environment and atmosphere is very inviting and relaxing. From the Car lot, to the Sales floor, everyone is very helpful and polite. They make you feel like family. Mercedes-Benz of Columbia is the best dealership in the Mid-West they surpasses my expectation. Therefore I will be a repeat customer, because I am a satisfied customer.

2022 Lexus GX 460 Premium review

Rock Solid

I love the truck capability combined with first class comfort. My GX has everything I need, and nothing I don’t. Long term value, combined with old school charm is hard to beat. Where else can you find a school bus mirror combined with sun glass holder? My third Lexus and will not be my last.

Vehicle information

Ext. color: Calypso Red
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 22-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.5L I4 16V PDI DOHC
Stock #: PH494554
VIN: 5NMS2DAJ6PH494554

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Navigation System, 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

2023 Hyundai SANTA FE SEL review

I have a 2023 Hyundai Santa Fe 2.

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

Vehicle information

Ext. color: 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 #: PC892453
VIN: 5N1BT3AB4PC892453

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

Great Experience

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

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

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 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: 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: Pearl White Tricoat
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 #: NW337300
VIN: JN8BT3BB6NW337300

Features

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

Reviews

Joe Machens Volkswagen review

Simply the Best

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

2022 Nissan Rogue SV review

Comfortable car

This is my favorite car. I wanted to buy this car from a long time ago. I am a big fan of the following. I feel very comfortable driving this car. I feel very safe. I love it. I would prefer people to buy this ca….

Vehicle information

Ext. color: Pearl White Tri-Coat
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L I4 16V GDI DOHC
Stock #: MC784197
VIN: 5N1AT3BB1MC784197

Features

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

Reviews

2021 Nissan Rogue SV review

This 2021 Nissan Rogue SL is a great car.

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

Vehicle information

Ext. color: Crystal White Tri-Coat
Int. color: Cirrus
Drivetrain: All-wheel Drive
MPG: 18-26
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 3.6L V6 24V GDI DOHC
Stock #: MZ163030
VIN: 1GYKNGRS6MZ163030

Features

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

Reviews

2021 Cadillac XT5 Sport review

Road noise is loud, Water leak in front passenger side

Road noise is loud, Water leak in front passenger side during heavy rain or car wash. Engine noise that the tech can’t locate. The XT 5 is a very nice size SUV. For a high end vehicle the warranty should be better in length and milage..

Vehicle information

Ext. color: Platinum Quartz Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: Automatic
Engine: SKYACTIV-G 2.5L I-4 gasoline direct injection, DOHC, variable va
Stock #: S0583993
VIN: JM3KFBBL5S0583993

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Navigation System, 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, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

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.

2025 Mazda CX-5 2.5 S Select Package review

We were loyal Subaru owners previously but were forced to

We were loyal Subaru owners previously but were forced to look at other car makers when the 2025 forester had problems and recalls. The 2025 Mazda cx-5 was the most similar car, with no recalls or issues. We were pleased with the price and ready availability, made the jump from Subaru and haven't looked back. We owned several Subaru's previously and never had any issues with them - our most recent was fifteen years old. As retirees, the new safety features like the backup screen and warnings for blind spots are terrific. I just hope the Mazda proves to be as problem-free. Also, the Mazda CX-5 was highly rated by our insurance co. and lowered the cost of our insuring our new car.

Vehicle information

Ext. color: Cosmic Blue Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 24-30
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: RZ088938
VIN: JA4J4VA88RZ088938

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: 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 Mitsubishi Outlander SE 2.5 S-AWC review

Great first brand new car.

Great first brand new car. I have seen these with 300k+ miles 2022 and 2023 miles. I got max loaded 2024 SEL or GT Premium Model. All wheel control is awesome in snow, I have seen people saying its better or even up to par with Subaru's symmetric AWD.

Vehicle information

Ext. color: Glacial White Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 18-24
Fuel type: Gasoline
Transmission: Automatic
Engine: LAMBDA II 3.8L V-6 gasoline direct injection, DOHC, D-CVVT varia
Stock #: PG410449
VIN: 5XYP5DGC7PG410449

Features

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

Reviews

Kia of Columbia review

2018 Kia Soul

Was able to get a 2018 Kia Soul. Love the car and was very pleased to be able to pick out the color I wanted. Only thing was that they were supposed have detailed the vehicle before I took possession and while it was cleaned they missed a half gallon container of pineapple juice on the floor of the back seat.

2023 Kia Telluride SX Prestige X-Pro review

2023 Telluride

I was very disappointed to discover that after paying the exorbitant markup of almost $10,000.00, that there is no power button in the car or on the key fob to open the rear hatch. I was also shocked that the front passenger seat does not have power controls, you have to reach under the seat to manually pull it forward or back. While I understand the safety feature to not accidentally lock a child in the car, I was unable to lock my car while trying to sleep in the back while camping. I'm hoping this won't be an issue in the future, but I had to have an alignment after only 12,000 miles and since I'm the only driver, I can assure you that I've never hit a pot hole or anything else that should have caused this. I do find the car comfortable to ride in and I like the safety features that alert you when trying to change lanes or if an object is behind you.

Vehicle information

Ext. color: Vik Black
Int. color: Beige/Black
Drivetrain: All-wheel Drive
MPG: 18-23
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 port/direct injection, DOHC, D-CVVT variable valve cont
Stock #: MU053094
VIN: KMUHCESC9MU053094

Features

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

Reviews

Joe Machens Hyundai review

Worked with Jason Wolverton at Machens Hyundai.

Worked with Jason Wolverton at Machens Hyundai. He worked hard at getting us a great deal on a Palisade. All the staff we encountered were friendly and professional. I would definitely recommend to anyone looking to buy a car!

2021 Genesis GV80 3.5T review

Lux car, tech in the dark ages

Luxurious car but the tech interface is a disaster (especially voice recognition, but also latency and general UI), and I bought the car only for the tech so I am disappointed.

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,160.

Which SUV has the best MPG?

The Nissan Kicks has the best MPG among traditional internal combustion SUVs and offers up to 31 MPG city and 36 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 24737 great deals out of 69633 listings starting at $1.

Where can I find the most SUV deals?

The most SUV deals can be found near Columbia, MO with 357 great deals out of 1012 listings starting at $4,999.

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

594 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\":599963,\"min_price_range\":0,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"year":"2023","vin":"5NMS1DAJ8PH591628","dealer_name":"Joe Machens Volkswagen","trim":"SE","bodystyle":"SUV","badges":[],"price":"20859","canonical_mmty":"Hyundai:SANTA FE:SE:2023","cpo_package":null,"interior_color":"Gray","model":"SANTA FE","mileage":"55216","stock_type":"Used","canonical_mmt":"Hyundai:SANTA FE:SE","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"40e28649-150c-4d2d-9cbb-86e6b7ac3990","photo_count":6,"certified_preowned":false,"exterior_color":"Stormy Sea","customer_id":"5364038","sponsored":false,"vertical_position":1,"make":"Hyundai","cat":"crossover_midsize","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2021","vin":"4S4BTANC9M3159589","dealer_name":"Subaru of Columbia","trim":"Limited","bodystyle":"SUV","badges":["price_drop_in_cents","good_deal"],"price":"20800","canonical_mmty":"Subaru:Outback:Limited:2021","cpo_package":null,"interior_color":"Slate Black","model":"Outback","mileage":"77005","stock_type":"Used","canonical_mmt":"Subaru:Outback:Limited","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"934de025-092c-4d16-a9f9-740ffe1375b5","photo_count":18,"certified_preowned":false,"exterior_color":"Ice Silver Metallic","customer_id":"6066303","sponsored":false,"vertical_position":2,"make":"Subaru","cat":"wagonhatchback_wagon","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2021","vin":"WP1AB2AY2MDA28264","dealer_name":"Mercedes-Benz of Columbia","trim":"S","bodystyle":"SUV","badges":["good_deal"],"price":"52643","canonical_mmty":"Porsche:Cayenne:S:2021","cpo_package":null,"interior_color":"Black","model":"Cayenne","mileage":"31303","stock_type":"Used","canonical_mmt":"Porsche:Cayenne:S","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"00e9c6de-779e-4127-a5ae-defa0302dfc9","photo_count":37,"certified_preowned":false,"exterior_color":"Moonlight Blue Metallic","customer_id":"5243424","sponsored":false,"vertical_position":3,"make":"Porsche","cat":"luxurysuv_crossover","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2023","vin":"5N1BT3BAXPC914350","dealer_name":"Joe Machens Nissan","trim":"SV","bodystyle":"SUV","badges":["good_deal"],"price":"19687","canonical_mmty":"Nissan:Rogue:SV:2023","cpo_package":null,"interior_color":"Charcoal","model":"Rogue","mileage":"52136","stock_type":"Used","canonical_mmt":"Nissan:Rogue:SV","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"224cd334-6e70-43de-bc61-fd468ab2ac45","photo_count":28,"certified_preowned":false,"exterior_color":"Pearl White Tricoat","customer_id":"5363960","sponsored":false,"vertical_position":4,"make":"Nissan","cat":"crossover_compact","cpo_indicator":false,"drivetrain":"Front-wheel Drive","seller_type":"dealership"},{"year":"2022","vin":"3VV2B7AX4NM009118","dealer_name":"Joe Machens Volkswagen","trim":"2.0T SE 4MOTION","bodystyle":"SUV","badges":["good_deal"],"price":"19189","canonical_mmty":"Volkswagen:Tiguan:2.0T SE 4MOTION:2022","cpo_package":null,"interior_color":"Titan Black","model":"Tiguan","mileage":"83899","stock_type":"Used","canonical_mmt":"Volkswagen:Tiguan:2.0T SE 4MOTION","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"66d2a142-5af1-435d-874d-34370a581b3f","photo_count":6,"certified_preowned":false,"exterior_color":"Platinum Gray Metallic","customer_id":"5364038","sponsored":false,"vertical_position":5,"make":"Volkswagen","cat":"crossover_compact","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2020","vin":"4S4BTANC3L3160770","dealer_name":"Joe Machens Volkswagen","trim":"Limited","bodystyle":"SUV","badges":["price_drop_in_cents","good_deal"],"price":"20401","canonical_mmty":"Subaru:Outback:Limited:2020","cpo_package":null,"interior_color":"Black","model":"Outback","mileage":"77468","stock_type":"Used","canonical_mmt":"Subaru:Outback:Limited","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"46d3eebd-aed4-488c-a943-e0d4577ed0aa","photo_count":49,"certified_preowned":false,"exterior_color":"Crimson Red Pearl","customer_id":"5364038","sponsored":false,"vertical_position":6,"make":"Subaru","cat":"wagonhatchback_wagon","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2018","vin":"5XYPK4A54JG382815","dealer_name":"Mercedes-Benz of Columbia","trim":"SX","bodystyle":"SUV","badges":["fair_deal"],"price":"11588","canonical_mmty":"Kia:Sorento:SX:2018","cpo_package":null,"interior_color":"Black","model":"Sorento","mileage":"146818","stock_type":"Used","canonical_mmt":"Kia:Sorento:SX","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"1a883344-bdbf-4a10-9f6b-06432729c73e","photo_count":37,"certified_preowned":false,"exterior_color":"Snow White Pearl","customer_id":"5243424","sponsored":false,"vertical_position":7,"make":"Kia","cat":"crossover_midsize","cpo_indicator":false,"drivetrain":"Front-wheel Drive","seller_type":"dealership"},{"year":"2024","vin":"1V2HR2CA5RC526160","dealer_name":"Joe Machens Volkswagen","trim":"2.0T SE w/Technology 4MOTION","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"price":"28900","canonical_mmty":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION:2024","cpo_package":null,"interior_color":"Titan Black","model":"Atlas","mileage":"47685","stock_type":"Used","canonical_mmt":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"cd29c564-dbbc-471f-aa10-d248e1dc5371","photo_count":45,"certified_preowned":false,"exterior_color":"Silver Mist Metallic","customer_id":"5364038","sponsored":false,"vertical_position":8,"make":"Volkswagen","cat":"crossover_midsize","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2022","vin":"JTJAM7BX5N5335189","dealer_name":"Mercedes-Benz of Columbia","trim":"Premium","bodystyle":"SUV","badges":["fair_deal"],"price":"51989","canonical_mmty":"Lexus:GX 460:Premium:2022","cpo_package":null,"interior_color":"Sepia","model":"GX 460","mileage":"35563","stock_type":"Used","canonical_mmt":"Lexus:GX 460:Premium","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"3cc76399-1fa8-42f3-ad55-be87c9c0e738","photo_count":37,"certified_preowned":false,"exterior_color":"Atomic Silver","customer_id":"5243424","sponsored":false,"vertical_position":9,"make":"Lexus","cat":"luxurysuv_suv","cpo_indicator":false,"drivetrain":"Four-wheel Drive","seller_type":"dealership"},{"year":"2023","vin":"5NMS2DAJ6PH494554","dealer_name":"Joe Machens Ford","trim":"SEL","bodystyle":"SUV","badges":["price_drop_in_cents","fair_deal"],"price":"21171","canonical_mmty":"Hyundai:SANTA FE:SEL:2023","cpo_package":null,"interior_color":"Black","model":"SANTA FE","mileage":"56926","stock_type":"Used","canonical_mmt":"Hyundai:SANTA FE:SEL","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":null,"dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"62572506-8eeb-4764-b135-47b73420085d","photo_count":30,"certified_preowned":false,"exterior_color":"Calypso Red","customer_id":"6039707","sponsored":false,"vertical_position":10,"make":"Hyundai","cat":"crossover_midsize","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2023","vin":"5N1BT3AB4PC892453","dealer_name":"Columbia Honda","trim":"S","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal"],"price":"19600","canonical_mmty":"Nissan:Rogue:S:2023","cpo_package":null,"interior_color":"Charcoal","model":"Rogue","mileage":"50532","stock_type":"Used","canonical_mmt":"Nissan:Rogue:S","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"ea7de677-6f82-4c4e-8b66-bf64612ffb93","photo_count":36,"certified_preowned":false,"exterior_color":"Super Black","customer_id":"5354599","sponsored":false,"vertical_position":11,"make":"Nissan","cat":"crossover_compact","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2024","vin":"1C4RJHBG6RC150994","dealer_name":"Columbia Honda","trim":"Limited","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"price":"34500","canonical_mmty":"Jeep:Grand Cherokee:Limited:2024","cpo_package":null,"interior_color":"Global Black","model":"Grand Cherokee","mileage":"20062","stock_type":"Used","canonical_mmt":"Jeep:Grand Cherokee:Limited","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"90f0b084-8562-41bd-9ede-cea513156e00","photo_count":36,"certified_preowned":false,"exterior_color":"Bright White Clearcoat","customer_id":"5354599","sponsored":false,"vertical_position":12,"make":"Jeep","cat":"suv_midsize","cpo_indicator":false,"drivetrain":"Four-wheel Drive","seller_type":"dealership"},{"year":"2025","vin":"1C4RJHBG6SC272020","dealer_name":"Joe Machens Nissan","trim":"Limited","bodystyle":"SUV","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"price":"36333","canonical_mmty":"Jeep:Grand Cherokee:Limited:2025","cpo_package":null,"interior_color":"Wicker Beige/Black","model":"Grand Cherokee","mileage":"18141","stock_type":"Used","canonical_mmt":"Jeep:Grand Cherokee:Limited","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"fc16758a-a412-485a-a5bf-f414e1f73ad4","photo_count":28,"certified_preowned":false,"exterior_color":"Velvet Red Pearlcoat","customer_id":"5363960","sponsored":false,"vertical_position":13,"make":"Jeep","cat":"suv_midsize","cpo_indicator":false,"drivetrain":"Four-wheel Drive","seller_type":"dealership"},{"year":"2022","vin":"JN8BT3BB6NW337300","dealer_name":"Joe Machens Volkswagen","trim":"SV","bodystyle":"SUV","badges":["price_drop_in_cents","good_deal"],"price":"23615","canonical_mmty":"Nissan:Rogue:SV:2022","cpo_package":null,"interior_color":"Charcoal","model":"Rogue","mileage":"24090","stock_type":"Used","canonical_mmt":"Nissan:Rogue:SV","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"6cb3cdde-25a1-4be4-b05c-77dd4a656cf9","photo_count":43,"certified_preowned":false,"exterior_color":"Pearl White Tricoat","customer_id":"5364038","sponsored":false,"vertical_position":14,"make":"Nissan","cat":"crossover_compact","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2021","vin":"5N1AT3BB1MC784197","dealer_name":"Joe Machens Ford","trim":"SV","bodystyle":"SUV","badges":["fair_deal"],"price":"15909","canonical_mmty":"Nissan:Rogue:SV:2021","cpo_package":null,"interior_color":"Charcoal","model":"Rogue","mileage":"131493","stock_type":"Used","canonical_mmt":"Nissan:Rogue:SV","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":null,"dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"b6e44d25-579f-444e-a1b4-ac449f97457d","photo_count":26,"certified_preowned":false,"exterior_color":"Pearl White Tri-Coat","customer_id":"6039707","sponsored":false,"vertical_position":15,"make":"Nissan","cat":"crossover_compact","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2021","vin":"1GYKNGRS6MZ163030","dealer_name":"Joe Machens Ford","trim":"Sport","bodystyle":"SUV","badges":["fair_deal"],"price":"26862","canonical_mmty":"Cadillac:XT5:Sport:2021","cpo_package":null,"interior_color":"Cirrus","model":"XT5","mileage":"54111","stock_type":"Used","canonical_mmt":"Cadillac:XT5:Sport","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":null,"dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"735a9955-f9a9-4b01-8ec4-505db27eb18d","photo_count":28,"certified_preowned":false,"exterior_color":"Crystal White Tri-Coat","customer_id":"6039707","sponsored":false,"vertical_position":16,"make":"Cadillac","cat":"luxurysuv_crossover","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2025","vin":"JM3KFBBL5S0583993","dealer_name":"Columbia Honda","trim":"2.5 S Select Package","bodystyle":"SUV","badges":["great_deal"],"price":"23800","canonical_mmty":"Mazda:CX-5:2.5 S Select Package:2025","cpo_package":null,"interior_color":"Black","model":"CX-5","mileage":"23412","stock_type":"Used","canonical_mmt":"Mazda:CX-5:2.5 S Select Package","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"45889741-7f66-4890-8bed-62ca68610d15","photo_count":6,"certified_preowned":false,"exterior_color":"Platinum Quartz Metallic","customer_id":"5354599","sponsored":false,"vertical_position":17,"make":"Mazda","cat":"crossover_compact","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2024","vin":"JA4J4VA88RZ088938","dealer_name":"Columbia Honda","trim":"SE 2.5 S-AWC","bodystyle":"SUV","badges":["great_deal"],"price":"23800","canonical_mmty":"Mitsubishi:Outlander:SE 2.5 S-AWC:2024","cpo_package":null,"interior_color":"Black","model":"Outlander","mileage":"32229","stock_type":"Used","canonical_mmt":"Mitsubishi:Outlander:SE 2.5 S-AWC","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"969d1c8c-d0de-46e4-92ae-3cf3502516b1","photo_count":37,"certified_preowned":false,"exterior_color":"Cosmic Blue Metallic","customer_id":"5354599","sponsored":false,"vertical_position":18,"make":"Mitsubishi","cat":"crossover_compact","cpo_indicator":false,"drivetrain":"Four-wheel Drive","seller_type":"dealership"},{"year":"2023","vin":"5XYP5DGC7PG410449","dealer_name":"Kia of Columbia","trim":"SX Prestige X-Pro","bodystyle":"SUV","badges":["good_deal"],"price":"36458","canonical_mmty":"Kia:Telluride:SX Prestige X-Pro:2023","cpo_package":null,"interior_color":"Black","model":"Telluride","mileage":"50464","stock_type":"Used","canonical_mmt":"Kia:Telluride:SX Prestige X-Pro","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65203","nvi_program":false,"stock_sub":"","listing_id":"fd9202d8-663b-41e5-bca1-c66dd184fc54","photo_count":34,"certified_preowned":false,"exterior_color":"Glacial White Pearl","customer_id":"5395269","sponsored":false,"vertical_position":19,"make":"Kia","cat":"suv_midsize","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"},{"year":"2021","vin":"KMUHCESC9MU053094","dealer_name":"Joe Machens Hyundai","trim":"3.5T","bodystyle":"SUV","badges":["fair_deal"],"price":"31558","canonical_mmty":"Genesis:GV80:3.5T:2021","cpo_package":null,"interior_color":"Beige/Black","model":"GV80","mileage":"81996","stock_type":"Used","canonical_mmt":"Genesis:GV80:3.5T","fuel_type":"Gasoline","sponsored_type":"standard","relevancy_score":null,"msrp":"0","dealer_zip":"65202","nvi_program":false,"stock_sub":"","listing_id":"0ee9a30a-2cc6-4d22-bb2e-3e5bddc5a40c","photo_count":19,"certified_preowned":false,"exterior_color":"Vik Black","customer_id":"5363959","sponsored":false,"vertical_position":20,"make":"Genesis","cat":"luxurysuv_crossover","cpo_indicator":false,"drivetrain":"All-wheel Drive","seller_type":"dealership"}]}]