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
663 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: Crimson Red Pearl
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L H4 16V GDI DOHC
Stock #: NH486640
VIN: JF2SKAEC0NH486640

Features

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

Reviews

Mazda of Columbia review

Angel Garrett

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

2022 Subaru Forester Premium review

Beyond Satisfied!

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

Vehicle information

Ext. color: Quartz White
Int. color: Black/Black
Drivetrain: All-wheel Drive
MPG: 20-26
Fuel type: Gasoline
Transmission: Automatic
Engine: Theta II 2L I-4 gasoline direct injection, DOHC, D-CVVT variable
Stock #: BU2861C1
VIN: 5NMS3CAA1LH141950

Features

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

Reviews

BMW of Columbia - MO review

New BMW purchase

Went shopping for a new car for my wife. Dave Johnson was the salesman and was wonderful. Went back at closing time with my wife to look at the model she wanted. Dave had already went home for the day so we decided to come back the next day. Well Mr. Johnson heard we had come back in and drove from his house back to the dealership to help us after it had closed. We bought the car. My wife had found a Mercedez that she liked but bought the BMW just because of the customer service we received from Dave Johnson and the crew. We will definitely got back for another car.

2020 Hyundai SANTA FE SEL 2.4 review

We are in our 70's and wanted a car that had blind spot

We are in our 70's and wanted a car that had blind spot protection with great window visability, a good sized GPS map, keyless entry, and good fuel economy. Also, it has good space in trunk with fold down rear seats. At 51,000 miles we have had no issues.

Vehicle information

Ext. color: Brilliant Bronze Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 26-32
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L H4 16V GDI DOHC
Stock #: R3146594
VIN: 4S4BTADC2R3146594

Features

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

Reviews

Mazda of Columbia review

Joe Machens Mazda

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

2024 Subaru Outback Premium review

The Subaru Outback is one of the best cars on the road.

The Subaru Outback is one of the best cars on the road. This car is definitely worth every penny that it costs. Performance at reliability cannot be underestimated. The company stands behind its warranty in every way. It’s like having a more expensive car without the hassle and expense!

Vehicle information

Ext. color: Twilight Black
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 21-27
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.4L I4 16V GDI DOHC
Stock #: KH131044
VIN: 5NMS3CAD7KH131044

Features

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

Mazda of Columbia review

lartiquefreeman2206@yahoo.com

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

2019 Hyundai SANTA FE 2.4 SEL review

We’ve put 85,000 miles on our Santa Fe, including a trip

We’ve put 85,000 miles on our Santa Fe, including a trip from Maryland to Idaho and Utah, and have consistently been happy happy with it. It’s needed no work/repairs, other than routine maintenance.

Vehicle information

Ext. color: White Diamond
Int. color: Light Gray
Drivetrain: Front-wheel Drive
MPG: 24-31
Fuel type: Gasoline
Transmission: CVT
Engine: 2.5L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: RZ087927
VIN: JA4J3WA88RZ087927

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

Reviews

Joe Machens Toyota review

Great First Experience!

Aurelio Barrios was an excellent sales representative. Very comfortable and easy to work with. Sam Warfel was a great financial manager as well. Had a great first car buying experience because of them and the rest of the team at Machens Toyota!

2024 Mitsubishi Outlander SEL 2.5 2WD 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: White
Int. color: Cappuccino
Drivetrain: Four-wheel Drive
MPG: 16-21
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: EcoBoost 3.5L V-6 port/direct injection, DOHC, variable valve co
Stock #: LEL00816
VIN: 5LMJJ2LT7LEL00816

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

Joe Machens Toyota review

Good experience working with Thad, they failed to point

Good experience working with Thad, they failed to point out all the rust on the under side of the bed of the pickup. Money I'm going to have to come up with to try to fix. If you can help let me know. Thanks.

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: Super Black
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: VC-Turbo 1.5L I-3 gasoline direct injection, DOHC, CVTCS variabl
Stock #: RC694388
VIN: 5N1BT3BB2RC694388

Features

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

Reviews

Joe Machens Toyota review

So happy with our purchase.

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

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: Mineral White Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 21-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic Sport
Engine: 3L I-6 gasoline direct injection, DOHC, Double VANOS variable va
Stock #: N9K37452
VIN: 5UXCR6C08N9K37452

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

Reviews

Joe Machens Toyota review

Service and a salesman helped today figure out the

Service and a salesman helped today figure out the subscription for the GPS system. I don’t like the idea of having to pay for the gps after 1 year of ownership on Toyota but I guess either you pay for the connect drive gps or use your cell phone car play (which is what I decided to do). They were very knowledgeable and helpful. Thank you for everything you do

2022 BMW X5 xDrive40i review

Mixed bag for us

Our 2022 X5 was a beautiful car to us. Unfortunately it didn't work for us as my wife is handicapped and found it difficult to get in and out of - it's higher than one would expect and came to realize the seats are more inboard than other cars that are direct competitors. The 3 inch door sill was almost like a running board and contributed to her struggles. Even though we had the multi-contour seats, we found the lower cushion seat side bolsters too firm for any drive more than an hour. The seat back was fine. While driving around town and 2 lanes was great, it didn't track as well on the highway as one would expect, even after an alignment (it was off at delivery). Our old Volvos were much better in that regard. The positives include the exterior and interior design/layout, the quality, ride, handling and power. It also still has a few buttons, albeit a bit small when driving. The headlights were awesome and the gas mileage was better than expected, 21 around town and 28+ on the highway. Our situation is unique, and after 7 months we sold the car to a tall, able bodied couple.

Vehicle information

Ext. color: Opal White
Int. color: As
Drivetrain: All-wheel Drive
MPG: 22-30
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: SM029854
VIN: 3VVLR7RM7SM029854

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

Reviews

Joe Machens Toyota review

Dean was ready the second we got there to answer all our

Dean was ready the second we got there to answer all our questions. The entire process, including a test drive to closing documents was expeditious and efficient. Highly recommended.

2025 Volkswagen Tiguan 2.0T SEL R-Line 4MOTION review

I choose the S model that doesn't come with all the

I choose the S model that doesn't come with all the extras but for me the interior is roomy well appointed cloth seats that I don't have to maintain,also a large infotainment screen that is very functional shift on the collome leaving more room on the console .The exterior is sporty and clean lined making it easy to ceramic coating it. I find the 2 liter turbo charged engine provides plenty of power for the model that has less curb weight than the Atlas and the front wheel drive results in getting 35 mpg at 70 on the hwy. The overall results in a very comfortable ride and experience that I was looking for.

Vehicle information

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

Features

Convenience: Adaptive Cruise Control, Keyless Entry
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control

Reviews

2021 Toyota 4Runner SR5 review

My wife drives this vehicle and she is a small gal.

My wife drives this vehicle and she is a small gal. She said it fits her great and rides very smooth. Gas mileage isnt the best but she doesnt drive it everyday so its not a big deal for us .

Vehicle information

Ext. color: Typhoon Silver
Int. color: Gray/Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic with SHIFTRONIC
Engine: Lambda II 3.8L V-6 gasoline direct injection, DOHC, D-CVVT varia
Stock #: RU726230
VIN: KM8R2DGE2RU726230

Features

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

Reviews

2024 Hyundai PALISADE SEL review

I have had the car for almost three months.

I have had the car for almost three months. I used it when my son’s family and others visited so I often used every seat. I have a Limited Trim with a tow hitch. I got the car for visiting family and also to be able to tow a small to medium sized camper. I have owned many Mercedes, BMW’s, Mini’s and other brands and this is the most luxurious. It is as good or better than the German cars on equipment and comfort, just not as fast. Ventilated seats, three rows of power and heated seats and all the tech you can want, which I love. My favorite is the amazing lane keep assist which practically drives the car by itself and the 360 camera for parking and not hitting things. Try to price a Mercedes or BMW 3-row with the same features and you will be at least $85-90k if not more. You could buy his and hers Palisades for the same money, the Calligraphy even has the massage seats. The car is quiet, smooth and absolutely gorgeous interior. I can afford most any car I want and I personally love the value proposition of this car and the low maintenance costs. The car plays a musical tune every time you close the door like a welcome. All my camping gear fits into the back with room to spare (and third row down). The only quirk is the rain sensing wipers do not seem too sensitive. I don’t mind no wireless Car Play as a plugged in phone stays charged. Once I tow with it I will write another review but if you want this feature know it comes with a hitch, ball, prewired with the wire kit for trailer brakes and a tow mode! That’s pretty cool. Full sized spare, too. If you want luxury, space, lots of seats and good towing capacity run and get one. You don’t need to shop the competition unless it’s the Telluride. I got a great year end deal on mine, too. Hyundai is improving its vehicles every single year. I have had three now (Kona, Tucson and Palisade) and they have all been great. Oh, I have gotten up to 26mpg on the highway but most the time my mileage is exactly like the ratings. As low as teens in the city doing errands. Not bad for a two ton car.

Vehicle information

Ext. color: Satin White Pearl
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 24-32
Fuel type: Gasoline
Transmission: Lineartronic CVT
Engine: 2.5L H-4 DOHC, variable valve control, regular unleaded, engine
Stock #: FH419351
VIN: JF2SJADC2FH419351

Features

Convenience: Keyless Entry
Entertainment: Bluetooth®, CD Player, HomeLink
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

Reviews

2015 Subaru Forester 2.5i Premium review

Bought my 2015 Subaru 2.

Bought my 2015 Subaru 2.0XT Touring brand spanking new off the Subaru dealership's lot. Have owned it all this time about 9 years straight. Take care of your car with regular oil changes, servicing at recommended intervals, and your car will take care of you. Performed the required recalls during service periods. Not 1 single regret on owning this car, ever. It rides smooth and true. Had a clicking issue in the ball joints 2 years ago which Subaru fixed free of charge. Other than that, this car has been my dream machine.

Vehicle information

Ext. color: Black Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 22-29
Fuel type: Diesel
Transmission: 8-Speed Automatic
Engine: EcoDiesel 3L V-6 diesel direct injection, DOHC, intercooled turb
Stock #: PW517793
VIN: 1C4HJXEM9PW517793

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, 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, Brake Assist, Stability Control
Seating: Leather Seats

Reviews

2023 Jeep Wrangler 4-Door Sahara 4x4 review

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

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

Vehicle information

Ext. color: Satin Steel Metallic
Int. color: Jet Black With Jet Black Accents
Drivetrain: Four-wheel Drive
MPG: 14-21
Fuel type: Gasoline
Transmission: 10-Speed Automatic with Overdrive
Engine: EcoTec3 6.2L V-8 gasoline direct injection, variable valve contr
Stock #: KR178655
VIN: 1GYS4DKJ0KR178655

Features

Convenience: Adaptive Cruise Control, Automatic Parking, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, DVD Player, Premium Sound System, Rear Seat Entertainment, 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

2019 Cadillac Escalade Platinum review

A vehicle to last you years!

Bought the ‘19 in ‘18 off the lot at 90K- have never held onto a vehicle this long. I can not upgrade this model- better then the ‘23 thanks to world issues that affect vehicle manufacturing. Excellent ride, comfort, and superior durability. My vehicle is pristine and l love it. 40 years old, over 25 brand new purchases and this one is still a daily driver!!!

Vehicle information

Ext. color: Silver Zynith
Int. color: Global Black
Drivetrain: Four-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: Pentastar 3.6L V-6 DOHC, variable valve control, regular unleade
Stock #: RC108575
VIN: 1C4RJHAG5RC108575

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

Reviews

2024 Jeep Grand Cherokee Altitude 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: Harbor Blue Metallic
Int. color: Cirrus
Drivetrain: All-wheel Drive
MPG: 18-25
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.6L V-6 gasoline direct injection, DOHC, VVT variable valve con
Stock #: KZ253957
VIN: 1GYKNDRS3KZ253957

Features

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

Reviews

2019 Cadillac XT5 Luxury review

We love our XT5, it drives great and looks great.

We love our XT5, it drives great and looks great. The only thing is the navigation. You have to plug in your cell phone to get it.

Vehicle information

Ext. color: Champagne Silver Metallic
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 29-36
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L DOHC
Stock #: RW381427
VIN: JN8BT3DC3RW381427

Features

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

Reviews

Joe Machens Nissan review

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.

2024 Nissan Rogue Platinum 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: Abyss Black Pearl
Int. color: Beige/Navy
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 #: SU871381
VIN: KM8R7DGE3SU871381

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, 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!

2025 Hyundai PALISADE Calligraphy review

We love our new vehicle!

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

Vehicle information

Ext. color: Summit White
Int. color: Jet Black
Drivetrain: Front-wheel Drive
MPG: 30-31
Fuel type: Gasoline
Transmission: Automatic
Engine: ECOTEC 1.2L I-3 gasoline direct injection, DOHC, variable valve
Stock #: SB023191
VIN: KL79MPSPXSB023191

Features

Convenience: 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, Brake Assist, LED Headlights, Lane Departure Warning, 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.

2025 Chevrolet Trailblazer LT review

Loving my new Trailblazer.

Loving my new Trailblazer. Handles great, gas mileage is terrific. Highly recommend. Very good value. It has all the features I wanted and more. Very pleased.

Vehicle information

Ext. color: Super Black
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 20-27
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 3.5L V6 DOHC
Stock #: SC238907
VIN: 5N1DR3DH2SC238907

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

Reviews

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 Nissan Pathfinder Platinum review

The 2025 Nissan Pathfinder feels like the kind of SUV

The 2025 Nissan Pathfinder feels like the kind of SUV that’s built for everyday life with the family. It’s spacious, comfortable, and gives you peace of mind with all the safety tech it comes standard with. The V6 has enough power to confidently get up to speed. If what you want is a dependable, family-focused midsize SUV that balances comfort, capability, and value, the Pathfinder is a solid choice.

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

663 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":[{"stock_sub":"","vin":"JF2SKAEC0NH486640","dealer_name":"Mazda of Columbia","certified_preowned":false,"canonical_mmty":"Subaru:Forester:Premium:2022","trim":"Premium","listing_id":"242bb0d8-8d29-47c0-8c94-62b14fb9ab8a","canonical_mmt":"Subaru:Forester:Premium","drivetrain":"All-wheel Drive","msrp":null,"year":"2022","price":"20900","exterior_color":"Crimson Red Pearl","mileage":"91170","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal"],"cat":"crossover_compact","bodystyle":"SUV","interior_color":"Gray","cpo_package":null,"stock_type":"Used","vertical_position":1,"photo_count":30,"customer_id":"5364156","seller_type":"dealership","nvi_program":false,"model":"Forester","fuel_type":"Gasoline","make":"Subaru","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"5NMS3CAA1LH141950","dealer_name":"BMW of Columbia - MO","certified_preowned":false,"canonical_mmty":"Hyundai:SANTA FE:SEL 2.4:2020","trim":"SEL 2.4","listing_id":"a09d70d9-60ab-4ab6-aa0f-3cc9c8f8e1fc","canonical_mmt":"Hyundai:SANTA FE:SEL 2.4","drivetrain":"All-wheel Drive","msrp":"0","year":"2020","price":"20746","exterior_color":"Quartz White","mileage":"55693","dealer_zip":"65203","badges":["price_drop_in_cents","good_deal"],"cat":"crossover_midsize","bodystyle":"SUV","interior_color":"Black/Black","cpo_package":null,"stock_type":"Used","vertical_position":2,"photo_count":36,"customer_id":"152419","seller_type":"dealership","nvi_program":false,"model":"SANTA FE","fuel_type":"Gasoline","make":"Hyundai","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"4S4BTADC2R3146594","dealer_name":"Mazda of Columbia","certified_preowned":false,"canonical_mmty":"Subaru:Outback:Premium:2024","trim":"Premium","listing_id":"4f533e1a-66b4-4956-ab48-719e9826e6cb","canonical_mmt":"Subaru:Outback:Premium","drivetrain":"All-wheel Drive","msrp":null,"year":"2024","price":"21100","exterior_color":"Brilliant Bronze Metallic","mileage":"90719","dealer_zip":"65202","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"cat":"wagonhatchback_wagon","bodystyle":"SUV","interior_color":"Black","cpo_package":null,"stock_type":"Used","vertical_position":3,"photo_count":27,"customer_id":"5364156","seller_type":"dealership","nvi_program":false,"model":"Outback","fuel_type":"Gasoline","make":"Subaru","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"5NMS3CAD7KH131044","dealer_name":"Mazda of Columbia","certified_preowned":false,"canonical_mmty":"Hyundai:SANTA FE:2.4 SEL:2019","trim":"2.4 SEL","listing_id":"09e6ad34-1cf1-4043-8170-99ef769d8f48","canonical_mmt":"Hyundai:SANTA FE:2.4 SEL","drivetrain":"All-wheel Drive","msrp":null,"year":"2019","price":"13600","exterior_color":"Twilight Black","mileage":"109623","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal"],"cat":"crossover_midsize","bodystyle":"SUV","interior_color":"Black","cpo_package":null,"stock_type":"Used","vertical_position":4,"photo_count":27,"customer_id":"5364156","seller_type":"dealership","nvi_program":false,"model":"SANTA FE","fuel_type":"Gasoline","make":"Hyundai","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"JA4J3WA88RZ087927","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Mitsubishi:Outlander:SEL 2.5 2WD:2024","trim":"SEL 2.5 2WD","listing_id":"576a405e-5fae-4352-b497-21fff8559e93","canonical_mmt":"Mitsubishi:Outlander:SEL 2.5 2WD","drivetrain":"Front-wheel Drive","msrp":"0","year":"2024","price":"27491","exterior_color":"White Diamond","mileage":"25791","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal"],"cat":"crossover_compact","bodystyle":"SUV","interior_color":"Light Gray","cpo_package":null,"stock_type":"Used","vertical_position":5,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Outlander","fuel_type":"Gasoline","make":"Mitsubishi","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"5LMJJ2LT7LEL00816","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Lincoln:Navigator:Reserve:2020","trim":"Reserve","listing_id":"b0f4311c-dd35-4c5d-9363-86d40b073374","canonical_mmt":"Lincoln:Navigator:Reserve","drivetrain":"Four-wheel Drive","msrp":"0","year":"2020","price":"39691","exterior_color":"White","mileage":"87623","dealer_zip":"65202","badges":["good_deal"],"cat":"luxurysuv_suv","bodystyle":"SUV","interior_color":"Cappuccino","cpo_package":null,"stock_type":"Used","vertical_position":6,"photo_count":4,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Navigator","fuel_type":"Gasoline","make":"Lincoln","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"5N1BT3BB2RC694388","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Nissan:Rogue:SV:2024","trim":"SV","listing_id":"82042db9-281e-4d4c-80b4-b1d6185b994e","canonical_mmt":"Nissan:Rogue:SV","drivetrain":"All-wheel Drive","msrp":"0","year":"2024","price":"20591","exterior_color":"Super Black","mileage":"52803","dealer_zip":"65202","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"cat":"crossover_compact","bodystyle":"SUV","interior_color":"Charcoal","cpo_package":null,"stock_type":"Used","vertical_position":7,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Rogue","fuel_type":"Gasoline","make":"Nissan","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"5UXCR6C08N9K37452","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"BMW:X5:xDrive40i:2022","trim":"xDrive40i","listing_id":"25ba5da9-3dd7-44d8-8ace-a8771bb56127","canonical_mmt":"BMW:X5:xDrive40i","drivetrain":"All-wheel Drive","msrp":"0","year":"2022","price":"48691","exterior_color":"Mineral White Metallic","mileage":"19174","dealer_zip":"65202","badges":["price_drop_in_cents","great_deal"],"cat":"luxurysuv_crossover","bodystyle":"SUV","interior_color":"Black","cpo_package":null,"stock_type":"Used","vertical_position":8,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"X5","fuel_type":"Gasoline","make":"BMW","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"3VVLR7RM7SM029854","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Volkswagen:Tiguan:2.0T SEL R-Line 4MOTION:2025","trim":"2.0T SEL R-Line 4MOTION","listing_id":"5404b55d-8228-4750-a54b-5ceeb14d04c1","canonical_mmt":"Volkswagen:Tiguan:2.0T SEL R-Line 4MOTION","drivetrain":"All-wheel Drive","msrp":"0","year":"2025","price":"37991","exterior_color":"Opal White","mileage":"2070","dealer_zip":"65202","badges":["price_drop_in_cents","great_deal"],"cat":"crossover_compact","bodystyle":"SUV","interior_color":"As","cpo_package":null,"stock_type":"Used","vertical_position":9,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Tiguan","fuel_type":"Gasoline","make":"Volkswagen","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"JTEMU5JR4M5850105","dealer_name":"Joe Machens Toyota","certified_preowned":true,"canonical_mmty":"Toyota:4Runner:SR5:2021","trim":"SR5","listing_id":"fdf1784a-e394-45ae-882a-bfbf99d43646","canonical_mmt":"Toyota:4Runner:SR5","drivetrain":"Four-wheel Drive","msrp":"0","year":"2021","price":"28967","exterior_color":"Classic Silver Metallic","mileage":"104846","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal","cpo"],"cat":"suv_midsize","bodystyle":"SUV","interior_color":"Black/Graphite","cpo_package":"Toyota","stock_type":"Used","vertical_position":10,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"4Runner","fuel_type":"Gasoline","make":"Toyota","sponsored_type":"standard","relevancy_score":null,"sponsored":true,"cpo_indicator":true},{"stock_sub":"","vin":"KM8R2DGE2RU726230","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Hyundai:PALISADE:SEL:2024","trim":"SEL","listing_id":"85424835-bcad-4426-a089-f20e78dc17c6","canonical_mmt":"Hyundai:PALISADE:SEL","drivetrain":"All-wheel Drive","msrp":"0","year":"2024","price":"28991","exterior_color":"Typhoon Silver","mileage":"66593","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal"],"cat":"crossover_midsize","bodystyle":"SUV","interior_color":"Gray/Black","cpo_package":null,"stock_type":"Used","vertical_position":11,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"PALISADE","fuel_type":"Gasoline","make":"Hyundai","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"JF2SJADC2FH419351","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Subaru:Forester:2.5i Premium:2015","trim":"2.5i Premium","listing_id":"d6cbf47e-45bf-4b16-a470-d096c5bd3fb7","canonical_mmt":"Subaru:Forester:2.5i Premium","drivetrain":"All-wheel Drive","msrp":"0","year":"2015","price":"10791","exterior_color":"Satin White Pearl","mileage":"140311","dealer_zip":"65202","badges":["price_drop_in_cents","fair_deal"],"cat":"crossover_compact","bodystyle":"SUV","interior_color":"Gray","cpo_package":null,"stock_type":"Used","vertical_position":12,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Forester","fuel_type":"Gasoline","make":"Subaru","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"1C4HJXEM9PW517793","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Jeep:Wrangler:4-Door Sahara 4x4:2023","trim":"4-Door Sahara 4x4","listing_id":"9bbc0a12-ac98-42ab-b91a-266eb7f4be7b","canonical_mmt":"Jeep:Wrangler:4-Door Sahara 4x4","drivetrain":"Four-wheel Drive","msrp":"0","year":"2023","price":"32991","exterior_color":"Black Clearcoat","mileage":"84363","dealer_zip":"65202","badges":["price_drop_in_cents","great_deal"],"cat":"suv_midsize","bodystyle":"SUV","interior_color":"Black","cpo_package":null,"stock_type":"Used","vertical_position":13,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Wrangler","fuel_type":"Diesel","make":"Jeep","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"1GYS4DKJ0KR178655","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Cadillac:Escalade:Platinum:2019","trim":"Platinum","listing_id":"59acc36d-bbe6-4e97-9820-7d8b731e55d3","canonical_mmt":"Cadillac:Escalade:Platinum","drivetrain":"Four-wheel Drive","msrp":"0","year":"2019","price":"29991","exterior_color":"Satin Steel Metallic","mileage":"132799","dealer_zip":"65202","badges":["price_drop_in_cents","great_deal"],"cat":"luxurysuv_suv","bodystyle":"SUV","interior_color":"Jet Black With Jet Black Accents","cpo_package":null,"stock_type":"Used","vertical_position":14,"photo_count":5,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Escalade","fuel_type":"Gasoline","make":"Cadillac","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"1C4RJHAG5RC108575","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Jeep:Grand Cherokee:Altitude:2024","trim":"Altitude","listing_id":"4bd84263-d85b-4fb6-a897-fd7d0197b3ad","canonical_mmt":"Jeep:Grand Cherokee:Altitude","drivetrain":"Four-wheel Drive","msrp":"0","year":"2024","price":"26991","exterior_color":"Silver Zynith","mileage":"59234","dealer_zip":"65202","badges":["price_drop_in_cents","fair_deal","american_made_index_ranking"],"cat":"suv_midsize","bodystyle":"SUV","interior_color":"Global Black","cpo_package":null,"stock_type":"Used","vertical_position":15,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"Grand Cherokee","fuel_type":"Gasoline","make":"Jeep","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"1GYKNDRS3KZ253957","dealer_name":"Joe Machens Toyota","certified_preowned":false,"canonical_mmty":"Cadillac:XT5:Luxury:2019","trim":"Luxury","listing_id":"6215f4fb-bbc9-4215-833d-91835e8a7501","canonical_mmt":"Cadillac:XT5:Luxury","drivetrain":"All-wheel Drive","msrp":"0","year":"2019","price":"14491","exterior_color":"Harbor Blue Metallic","mileage":"133106","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal","hot_car"],"cat":"luxurysuv_crossover","bodystyle":"SUV","interior_color":"Cirrus","cpo_package":null,"stock_type":"Used","vertical_position":16,"photo_count":42,"customer_id":"5363961","seller_type":"dealership","nvi_program":false,"model":"XT5","fuel_type":"Gasoline","make":"Cadillac","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"JN8BT3DC3RW381427","dealer_name":"Joe Machens Nissan","certified_preowned":true,"canonical_mmty":"Nissan:Rogue:Platinum:2024","trim":"Platinum","listing_id":"462d6ea4-9244-4fd7-acd7-ebfe75629eab","canonical_mmt":"Nissan:Rogue:Platinum","drivetrain":"Front-wheel Drive","msrp":"0","year":"2024","price":"27530","exterior_color":"Champagne Silver Metallic","mileage":"35479","dealer_zip":"65203","badges":["great_deal","american_made_index_ranking","cpo"],"cat":"crossover_compact","bodystyle":"SUV","interior_color":"Charcoal","cpo_package":"Nissan","stock_type":"Used","vertical_position":17,"photo_count":28,"customer_id":"5363960","seller_type":"dealership","nvi_program":false,"model":"Rogue","fuel_type":"Gasoline","make":"Nissan","sponsored_type":"standard","relevancy_score":null,"sponsored":true,"cpo_indicator":true},{"stock_sub":"","vin":"KM8R7DGE3SU871381","dealer_name":"Joe Machens Hyundai","certified_preowned":false,"canonical_mmty":"Hyundai:PALISADE:Calligraphy:2025","trim":"Calligraphy","listing_id":"d3484b6b-5210-47a8-b23a-c4c68f42df32","canonical_mmt":"Hyundai:PALISADE:Calligraphy","drivetrain":"All-wheel Drive","msrp":"0","year":"2025","price":"45900","exterior_color":"Abyss Black Pearl","mileage":"8037","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal","2025_award_winner"],"cat":"crossover_midsize","bodystyle":"SUV","interior_color":"Beige/Navy","cpo_package":null,"stock_type":"Used","vertical_position":18,"photo_count":38,"customer_id":"5363959","seller_type":"dealership","nvi_program":false,"model":"PALISADE","fuel_type":"Gasoline","make":"Hyundai","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"KL79MPSPXSB023191","dealer_name":"Joe Machens Volkswagen","certified_preowned":false,"canonical_mmty":"Chevrolet:Trailblazer:LT:2025","trim":"LT","listing_id":"1d0f1c67-c91f-4b96-a0b7-53cb0a930de1","canonical_mmt":"Chevrolet:Trailblazer:LT","drivetrain":"Front-wheel Drive","msrp":"0","year":"2025","price":"21325","exterior_color":"Summit White","mileage":"33606","dealer_zip":"65202","badges":["price_drop_in_cents","good_deal"],"cat":"suv_midsize","bodystyle":"SUV","interior_color":"Jet Black","cpo_package":null,"stock_type":"Used","vertical_position":19,"photo_count":32,"customer_id":"5364038","seller_type":"dealership","nvi_program":false,"model":"Trailblazer","fuel_type":"Gasoline","make":"Chevrolet","sponsored_type":"standard","relevancy_score":null,"sponsored":false,"cpo_indicator":false},{"stock_sub":"","vin":"5N1DR3DH2SC238907","dealer_name":"Joe Machens Nissan","certified_preowned":true,"canonical_mmty":"Nissan:Pathfinder:Platinum:2025","trim":"Platinum","listing_id":"69400803-34a5-4e6c-922e-ffd5358c0fef","canonical_mmt":"Nissan:Pathfinder:Platinum","drivetrain":"Front-wheel Drive","msrp":"0","year":"2025","price":"40003","exterior_color":"Super Black","mileage":"2151","dealer_zip":"65203","badges":["price_drop_in_cents","great_deal","american_made_index_ranking","cpo"],"cat":"suv_midsize","bodystyle":"SUV","interior_color":"Charcoal","cpo_package":"Nissan","stock_type":"Used","vertical_position":20,"photo_count":30,"customer_id":"5363960","seller_type":"dealership","nvi_program":false,"model":"Pathfinder","fuel_type":"Gasoline","make":"Nissan","sponsored_type":"standard","relevancy_score":null,"sponsored":true,"cpo_indicator":true}]}]