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 Fayette, MO under $30,000

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
386 matches 30 miles from 65248
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: Mercury Gray Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 DOHC, MIVEC variable valve control, regular unleaded, eng
Stock #: RU002823
VIN: JA4ARUAU4RU002823

Features

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

Reviews

Columbia Honda review

Great Experience

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

2024 Mitsubishi Outlander Sport SE review

traded my 2021 for a 2024 Mitsubishi Outlander Sport

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

Vehicle information

Ext. color: Sangria Red
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.8L V6 24V GDI DOHC
Stock #: NG274368
VIN: 5XYP6DHC4NG274368

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Navigation System, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

2022 Kia Telluride S review

If you want a comfortable, stylish, and affordable suv

If you want a comfortable, stylish, and affordable suv for your family this is the car for you. Makes me feel proud when driving it and holds its own compared to other luxury suvs that cost a lot more. My only complaints are that it’s a gas guzzler and at this price point all models should come with the digital speedometer dashboard and not just the highest trim levels.

Vehicle information

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

Features

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

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.

2021 Kia Telluride LX review

Excellent Telluride

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

Vehicle information

Ext. color: Pearl White Tricoat
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L I3 Turbocharged DOHC 12V LEV3-ULEV50 201hp
Stock #: PW460326
VIN: JN8BT3BBXPW460326

Features

Convenience: Adaptive Cruise Control, Keyless Entry, Keyless Start, 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 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: White
Int. color: Sandstone
Drivetrain: All-wheel Drive
MPG: 17-24
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 3.0L V6 24V GDI DOHC Twin Turbo
Stock #: LGL31116
VIN: 5LM5J7XC6LGL31116

Features

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

Reviews

2020 Lincoln Aviator Reserve AWD review

Well, first thing is first.

Well, first thing is first. This is a great American luxury suv, problem, just that. We Americans worry too much about things we don't need and forgo things we do and thus you have most American companies especially auto manufacturers. Charge a lot but receive very little in durability but ague that it's offered at least. Precisely why the Japanese and recently the German luxury manufacturers do it better. They are not just trying to make a xxxx load of money, they actually care that their products are what they are being hyped as and stand the test of time regardless of the deepness of their customers pockets. So does the Lincoln produce a great product, Yes and No and that's a problem in this class as their asking price. For $60+k the vehicle shouldn't have any negative reviews let alone quality issues. The American car makers are an unfortunate mixed bag and leave me always expecting more. Maybe the true intent after all, planned obsolescence. Non the less I'd recommend a good extended warranty because when things fail outside of warranty, most likely it will cost more then the vehicle in the 1st place.

Vehicle information

Ext. color: Portofino Blue Metallic
Int. color: Ebony/Light Oyster Stitch
Drivetrain: All-wheel Drive
MPG: 22-27
Fuel type: Gasoline
Transmission: Automatic
Engine: Ingenium 2L I-4 gasoline direct injection, DOHC, variable valve
Stock #: MU8175A
VIN: SADCK2FX5LA632129

Features

Convenience: 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
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Mercedes-Benz of Columbia review

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

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

2020 Jaguar F-PACE Prestige P250 AWD Automatic review

The F-Pace is an excellent sporty SUV.

The F-Pace is an excellent sporty SUV. 2.5L engine has been completely trouble free. The suspension on this generation is a bit firmer than the newer generation. The performance and fuel economy is great. The infotainment system allows for apple car play (corded). The F Pace is bigger than other compact SUVs in its class. I wish Jag wasn’t so committed to going all electric because they have taken the Land Rover Velar and made the F-Pace more sporty and luxurious.

Vehicle information

Ext. color: Oxford White
Int. color: Ebony
Drivetrain: Four-wheel Drive
MPG: 20-27
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: EcoBoost 2.3L I-4 gasoline direct injection, DOHC, variable valv
Stock #: PGB22705
VIN: 1FMSK8DH1PGB22705

Features

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

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!

2023 Ford Explorer XLT review

Great car

Best car I’ve ever owned. Does everything I want//need it to do. Always starts in the morning. I’ve been camping with it and slept inside the car. Plenty of room

Vehicle information

Ext. color: Pyrite Silver 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 #: NM156027
VIN: 3VV2B7AX1NM156027

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

Reviews

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: Gray
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: NH486640
VIN: JF2SKAEC0NH486640

Features

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

Reviews

2022 Subaru Forester Premium review

Beyond Satisfied!

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

Vehicle information

Ext. color: Ebony Black
Int. color: Grey
Drivetrain: Front-wheel Drive
MPG: 23-31
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 port/direct injection, DOHC, CVVT variable valve contro
Stock #: SG340142
VIN: 5XYRL4JC3SG340142

Features

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

2025 Kia Sorento S review

There is quite a bit to love about my 2025 Kia Sorento X

There is quite a bit to love about my 2025 Kia Sorento X Line. Great features, decent size navigation screen. However, I find the seat to be a bit uncomfortable due to the edging on the back of the seat with how it is curved. Also, I’m not sure exactly how long the paint job will last as my salesman did mention it’s not the best. My dealership wiped it clean instead of actually washing it before I took possession of it and this caused swirl marks all over it!

Vehicle information

Ext. color: Ruby Red Metallic Tinted Clearcoat
Int. color: Medium Light Camel
Drivetrain: Front-wheel Drive
MPG: 17-24
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 DOHC, variable valve control, regular unleaded, engine
Stock #: GGA33157
VIN: 1FM5K7D81GGA33157

Features

Convenience: Keyless Entry, Keyless Start
Entertainment: Bluetooth®, CD Player, USB Port
Exterior: Alloy Wheels, Roof Rack
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Stability Control
Seating: Third Row Seating

Reviews

Kia of Columbia review

2018 Stinger

Andrew was awesome to work with. I had a wonderful experience and love love love my new car... The sales manager and staff were very friendly and easy to work with. I would recommend them to anyone..

2016 Ford Explorer XLT review

Great SUV, NOISY inside. Get ext. Warranty!

2016 Platinum. Nice SUV, comfortable, very powerful, decent fuel economy, fair build quality, but there are some things to be aware of; the AWD models have a PTU (power transfer unit) which sends power to the rear wheels. It is positioned very close to the exhaust, and the heat generated by the turbochargers literally cooks the gear oil in the PTU, causing it to fail. The unit only holds about a quart of oil, and is NOT serviced or checked, even when you have the vehicle serviced at the dealer. We had trouble with the front camera, and the recirculation actuator on the climate control. If you are considering a used Explorer, I highly recommend buying the best warranty you can! The only complaint I have is the road noise. On new pavement, it's quiet, but on all other roads it's VERY loud inside!

Vehicle information

Ext. color: Oxford White
Int. color: Sandstone
Drivetrain: Four-wheel Drive
MPG: 20-27
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 2.3L I-4 gasoline direct injection, DOHC, variable valv
Stock #: PGB63550
VIN: 1FMSK8FH9PGB63550

Features

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

Reviews

Columbia Honda review

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.

2023 Ford Explorer Limited review

2023 Ford Explorer XLT

Have only had vehicle for 3 weeks but really like it. I’ve had F150’s for the past 12 years and thought I’d miss my truck, but I’m really enjoying this explorer. It’s more comfortable and fun to drive and the gas mileage is better.

Vehicle information

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

Features

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

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.

2021 Jeep Grand Cherokee Limited review

I just love everything about my 2021 80th anniversary

I just love everything about my 2021 80th anniversary edition G/C! I purchased new but now has 81000km. So much enjoy all the style comfort with no issues. So much more reliable and better looking than the new body style that was released later in 2021.

Vehicle information

Ext. color: Magnetite Gray Metallic
Int. color: Slate Black
Drivetrain: All-wheel Drive
MPG: 26-32
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: S3182895
VIN: 4S4BTAFC5S3182895

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, Roof Rack, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control

Reviews

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 Subaru Outback Premium review

I have owned 4 outback's.

I have owned 4 outback's. I was tboned by a F150 ford truck going at least 55 mph and walked away. Safe comfortable cars. My new Outback Wilderness is the most comfortable of all I have owned. My Touring 2021 Outback was close to being as comfortable

Vehicle information

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

Features

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

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.

2022 Kia Telluride EX review

We purchased the 2022 Telluride Prestige Nightfall for

We purchased the 2022 Telluride Prestige Nightfall for our family car. We couldn’t be happier and would recommend this vehicle based on looks, practicality, space, and reliability.

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 #: RC572791
VIN: 1V2HR2CA6RC572791

Features

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

Reviews

Columbia Honda review

Columbia Hondas Service Department

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

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

Traded my 23 Atlas SE Technology V6 for the 24 SEL R-Line

Traded my 23 Atlas SE Technology V6 for the 24 SEL R-Line premium. This SUV is fantastic, a great value, reliable and the performance of the turbo 4 engine is excellent and most impressive. I've driven Volkswagen's for years and this one hasn't disappointed. Advice to Volkswagen, bring back the TDI!

Vehicle information

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

Features

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

Reviews

Columbia Honda review

top notch service

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

2023 Nissan Rogue S review

I’m very happy with my 2023 Nissan Rogue.

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

Vehicle information

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

Features

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

Reviews

Joe Machens Toyota review

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

2021 Nissan Rogue Platinum review

This 2021 Nissan Rogue SL is a great car.

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

Vehicle information

Ext. color: 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 #: PW479941
VIN: JN8BT3BB4PW479941

Features

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

2023 Nissan Rogue SV review

The best car I have owned.

The best car I have owned. Bought it brand new, now I have about 30,000 miles on it and I have had zero problems! Take care of your car and you won’t have any problems!

Vehicle information

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

Features

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

Reviews

Joe Machens Volkswagen review

GREAT SERVICE!

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

2024 Nissan Rogue SV review

I've owed the rogue SV for some 9 months and I'm very

I've owed the rogue SV for some 9 months and I'm very pleased with the ride, performance and reliability . Prior to me purchased this car I rented a bunch of competitors to narrow down my choice. The Rogue has alot of features that really come in handy. It's a very thought out vehicle. On long highway trips it holds the road very steadily at 90 MPH and my gas consumption was in the low 40's. For the money to me it's the best value out there

About SUVs

FAQs

What is the cheapest SUV available?

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

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 IQL has the longest range among SUVs and can travel up to 450 miles on a single charge depending on electric motor and battery options.

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

Which automaker has the most SUV deals?

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

Where can I find the most SUV deals?

The most SUV deals can be found near Columbia, MO with 174 great deals out of 576 listings starting at $4,994.

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

386 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 Fayette, MO

[{"applied_filter_criteria":"{\"bodystyle\":[\"suv\"],\"cpo_indicator\":false,\"max_price_range\":30000,\"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":[{"badges":["great_deal"],"photo_count":32,"certified_preowned":false,"seller_type":"dealership","customer_id":"5354599","trim":"SE","drivetrain":"Four-wheel Drive","vertical_position":1,"model":"Outlander Sport","vin":"JA4ARUAU4RU002823","relevancy_score":null,"dealer_zip":"65202","year":"2024","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"44177","bodystyle":"SUV","stock_type":"Used","price":"17000","cat":"crossover_compact","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Black","msrp":"0","exterior_color":"Mercury Gray Metallic","canonical_mmt":"Mitsubishi:Outlander Sport:SE","make":"Mitsubishi","cpo_package":null,"dealer_name":"Columbia Honda","listing_id":"74b0f5fd-0342-49ce-a593-209a7c2437e5","canonical_mmty":"Mitsubishi:Outlander Sport:SE:2024"},{"badges":["great_deal","2022_award_winner"],"photo_count":28,"certified_preowned":false,"seller_type":"dealership","customer_id":"6039707","trim":"S","drivetrain":"All-wheel Drive","vertical_position":2,"model":"Telluride","vin":"5XYP6DHC4NG274368","relevancy_score":null,"dealer_zip":"65203","year":"2022","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"54771","bodystyle":"SUV","stock_type":"Used","price":"28213","cat":"suv_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Black","msrp":null,"exterior_color":"Sangria Red","canonical_mmt":"Kia:Telluride:S","make":"Kia","cpo_package":null,"dealer_name":"Joe Machens Ford","listing_id":"61dd0fb7-8771-4d0f-89a9-fc77d67c22f4","canonical_mmty":"Kia:Telluride:S:2022"},{"badges":["good_deal"],"photo_count":6,"certified_preowned":false,"seller_type":"dealership","customer_id":"5364038","trim":"LX","drivetrain":"All-wheel Drive","vertical_position":3,"model":"Telluride","vin":"5XYP2DHC6MG147115","relevancy_score":null,"dealer_zip":"65202","year":"2021","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"109561","bodystyle":"SUV","stock_type":"Used","price":"18363","cat":"suv_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Black","msrp":"0","exterior_color":"Gravity Grey","canonical_mmt":"Kia:Telluride:LX","make":"Kia","cpo_package":null,"dealer_name":"Joe Machens Volkswagen","listing_id":"7e802a4f-ed0a-40bc-909a-d5b42fb20d87","canonical_mmty":"Kia:Telluride:LX:2021"},{"badges":["good_deal","cpo"],"photo_count":28,"certified_preowned":true,"seller_type":"dealership","customer_id":"5363960","trim":"SV","drivetrain":"All-wheel Drive","vertical_position":4,"model":"Rogue","vin":"JN8BT3BBXPW460326","relevancy_score":null,"dealer_zip":"65203","year":"2023","stock_sub":"","nvi_program":false,"sponsored":true,"fuel_type":"Gasoline","mileage":"28338","bodystyle":"SUV","stock_type":"Used","price":"23215","cat":"crossover_compact","cpo_indicator":true,"sponsored_type":"standard","interior_color":"Charcoal","msrp":"0","exterior_color":"Pearl White Tricoat","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","cpo_package":"Nissan","dealer_name":"Joe Machens Nissan","listing_id":"e964c365-1c6c-49e3-a9fa-ce984c0d3ec2","canonical_mmty":"Nissan:Rogue:SV:2023"},{"badges":["great_deal"],"photo_count":32,"certified_preowned":false,"seller_type":"dealership","customer_id":"6039707","trim":"Reserve AWD","drivetrain":"All-wheel Drive","vertical_position":5,"model":"Aviator","vin":"5LM5J7XC6LGL31116","relevancy_score":null,"dealer_zip":"65203","year":"2020","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"93075","bodystyle":"SUV","stock_type":"Used","price":"26984","cat":"luxurysuv_crossover","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Sandstone","msrp":null,"exterior_color":"White","canonical_mmt":"Lincoln:Aviator:Reserve AWD","make":"Lincoln","cpo_package":null,"dealer_name":"Joe Machens Ford","listing_id":"a78637f0-0baa-44b9-93eb-4bc0c095af90","canonical_mmty":"Lincoln:Aviator:Reserve AWD:2020"},{"badges":["price_drop_in_cents","good_deal"],"photo_count":37,"certified_preowned":false,"seller_type":"dealership","customer_id":"5243424","trim":"Prestige P250 AWD Automatic","drivetrain":"All-wheel Drive","vertical_position":6,"model":"F-PACE","vin":"SADCK2FX5LA632129","relevancy_score":null,"dealer_zip":"65203","year":"2020","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"95426","bodystyle":"SUV","stock_type":"Used","price":"16580","cat":"luxurysuv_crossover","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Ebony/Light Oyster Stitch","msrp":"0","exterior_color":"Portofino Blue Metallic","canonical_mmt":"Jaguar:F-PACE:Prestige P250 AWD Automatic","make":"Jaguar","cpo_package":null,"dealer_name":"Mercedes-Benz of Columbia","listing_id":"fdd60577-18c4-4ae7-abcd-a3984f0cb0e5","canonical_mmty":"Jaguar:F-PACE:Prestige P250 AWD Automatic:2020"},{"badges":["price_drop_in_cents","good_deal"],"photo_count":42,"certified_preowned":false,"seller_type":"dealership","customer_id":"5363961","trim":"XLT","drivetrain":"Four-wheel Drive","vertical_position":7,"model":"Explorer","vin":"1FMSK8DH1PGB22705","relevancy_score":null,"dealer_zip":"65202","year":"2023","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"75129","bodystyle":"SUV","stock_type":"Used","price":"25791","cat":"suv_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Ebony","msrp":"0","exterior_color":"Oxford White","canonical_mmt":"Ford:Explorer:XLT","make":"Ford","cpo_package":null,"dealer_name":"Joe Machens Toyota","listing_id":"12148280-3931-459a-b2ba-47b448174ccf","canonical_mmty":"Ford:Explorer:XLT:2023"},{"badges":["good_deal"],"photo_count":35,"certified_preowned":false,"seller_type":"dealership","customer_id":"5364038","trim":"2.0T SE 4MOTION","drivetrain":"All-wheel Drive","vertical_position":8,"model":"Tiguan","vin":"3VV2B7AX1NM156027","relevancy_score":null,"dealer_zip":"65202","year":"2022","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"96667","bodystyle":"SUV","stock_type":"Used","price":"15999","cat":"crossover_compact","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Titan Black","msrp":"0","exterior_color":"Pyrite Silver Metallic","canonical_mmt":"Volkswagen:Tiguan:2.0T SE 4MOTION","make":"Volkswagen","cpo_package":null,"dealer_name":"Joe Machens Volkswagen","listing_id":"b1388de5-eebc-44e7-a73a-e962427cdb6e","canonical_mmty":"Volkswagen:Tiguan:2.0T SE 4MOTION:2022"},{"badges":["good_deal"],"photo_count":18,"certified_preowned":false,"seller_type":"dealership","customer_id":"6066303","trim":"Premium","drivetrain":"All-wheel Drive","vertical_position":9,"model":"Forester","vin":"JF2SKAEC0NH486640","relevancy_score":null,"dealer_zip":"65203","year":"2022","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"91200","bodystyle":"SUV","stock_type":"Used","price":"19400","cat":"crossover_compact","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Gray","msrp":"0","exterior_color":"Crimson Red Pearl","canonical_mmt":"Subaru:Forester:Premium","make":"Subaru","cpo_package":null,"dealer_name":"Subaru of Columbia","listing_id":"7582afff-5c5d-4345-b615-f78243e78f8e","canonical_mmty":"Subaru:Forester:Premium:2022"},{"badges":["price_drop_in_cents","good_deal","american_made_index_ranking","hot_car","cpo"],"photo_count":32,"certified_preowned":true,"seller_type":"dealership","customer_id":"5395269","trim":"S","drivetrain":"Front-wheel Drive","vertical_position":10,"model":"Sorento","vin":"5XYRL4JC3SG340142","relevancy_score":null,"dealer_zip":"65203","year":"2025","stock_sub":"","nvi_program":false,"sponsored":true,"fuel_type":"Gasoline","mileage":"317","bodystyle":"SUV","stock_type":"Used","price":"29999","cat":"crossover_midsize","cpo_indicator":true,"sponsored_type":"standard","interior_color":"Grey","msrp":"0","exterior_color":"Ebony Black","canonical_mmt":"Kia:Sorento:S","make":"Kia","cpo_package":"Kia","dealer_name":"Kia of Columbia","listing_id":"e1d61336-26a1-4ae6-a4aa-455ef0d5910c","canonical_mmty":"Kia:Sorento:S:2025"},{"badges":["price_drop_in_cents","great_deal"],"photo_count":30,"certified_preowned":false,"seller_type":"dealership","customer_id":"5395269","trim":"XLT","drivetrain":"Front-wheel Drive","vertical_position":11,"model":"Explorer","vin":"1FM5K7D81GGA33157","relevancy_score":null,"dealer_zip":"65203","year":"2016","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"142836","bodystyle":"SUV","stock_type":"Used","price":"9999","cat":"suv_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Medium Light Camel","msrp":"0","exterior_color":"Ruby Red Metallic Tinted Clearcoat","canonical_mmt":"Ford:Explorer:XLT","make":"Ford","cpo_package":null,"dealer_name":"Kia of Columbia","listing_id":"6d3c7616-f68c-4e9e-bc48-875d123d003c","canonical_mmty":"Ford:Explorer:XLT:2016"},{"badges":["good_deal"],"photo_count":34,"certified_preowned":false,"seller_type":"dealership","customer_id":"5354599","trim":"Limited","drivetrain":"Four-wheel Drive","vertical_position":12,"model":"Explorer","vin":"1FMSK8FH9PGB63550","relevancy_score":null,"dealer_zip":"65202","year":"2023","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"66776","bodystyle":"SUV","stock_type":"Used","price":"28000","cat":"suv_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Sandstone","msrp":"0","exterior_color":"Oxford White","canonical_mmt":"Ford:Explorer:Limited","make":"Ford","cpo_package":null,"dealer_name":"Columbia Honda","listing_id":"4d5df955-d189-48cf-bd6b-e366a02e7e1c","canonical_mmty":"Ford:Explorer:Limited:2023"},{"badges":["good_deal"],"photo_count":5,"certified_preowned":false,"seller_type":"dealership","customer_id":"5363961","trim":"Limited","drivetrain":"Four-wheel Drive","vertical_position":13,"model":"Grand Cherokee","vin":"1C4RJFBG8MC632573","relevancy_score":null,"dealer_zip":"65202","year":"2021","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"59119","bodystyle":"SUV","stock_type":"Used","price":"24991","cat":"suv_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Black","msrp":"0","exterior_color":"Bright White Clearcoat","canonical_mmt":"Jeep:Grand Cherokee:Limited","make":"Jeep","cpo_package":null,"dealer_name":"Joe Machens Toyota","listing_id":"bd2e5c31-22ba-46f5-8901-534954893a6f","canonical_mmty":"Jeep:Grand Cherokee:Limited:2021"},{"badges":["good_deal"],"photo_count":33,"certified_preowned":false,"seller_type":"dealership","customer_id":"5354599","trim":"Premium","drivetrain":"All-wheel Drive","vertical_position":14,"model":"Outback","vin":"4S4BTAFC5S3182895","relevancy_score":null,"dealer_zip":"65202","year":"2025","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"18509","bodystyle":"SUV","stock_type":"Used","price":"29700","cat":"wagonhatchback_wagon","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Slate Black","msrp":"0","exterior_color":"Magnetite Gray Metallic","canonical_mmt":"Subaru:Outback:Premium","make":"Subaru","cpo_package":null,"dealer_name":"Columbia Honda","listing_id":"45053ef6-b058-41d2-8a94-efa681dfb417","canonical_mmty":"Subaru:Outback:Premium:2025"},{"badges":["price_drop_in_cents","good_deal","2022_award_winner"],"photo_count":42,"certified_preowned":false,"seller_type":"dealership","customer_id":"5363961","trim":"EX","drivetrain":"All-wheel Drive","vertical_position":15,"model":"Telluride","vin":"5XYP3DHC6NG223169","relevancy_score":null,"dealer_zip":"65202","year":"2022","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"86453","bodystyle":"SUV","stock_type":"Used","price":"25152","cat":"suv_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Black","msrp":"0","exterior_color":"Wolf Gray","canonical_mmt":"Kia:Telluride:EX","make":"Kia","cpo_package":null,"dealer_name":"Joe Machens Toyota","listing_id":"a7b654f5-5e28-454c-a248-6b40140fab01","canonical_mmty":"Kia:Telluride:EX:2022"},{"badges":["great_deal","american_made_index_ranking"],"photo_count":37,"certified_preowned":false,"seller_type":"dealership","customer_id":"5354599","trim":"2.0T SE w/Technology 4MOTION","drivetrain":"All-wheel Drive","vertical_position":16,"model":"Atlas","vin":"1V2HR2CA6RC572791","relevancy_score":null,"dealer_zip":"65202","year":"2024","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"33021","bodystyle":"SUV","stock_type":"Used","price":"29800","cat":"crossover_midsize","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Titan Black","msrp":"0","exterior_color":"Silver Mist Metallic","canonical_mmt":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION","make":"Volkswagen","cpo_package":null,"dealer_name":"Columbia Honda","listing_id":"f0abb330-b05a-4874-86d7-3a4ea6f95175","canonical_mmty":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION:2024"},{"badges":["price_drop_in_cents","fair_deal"],"photo_count":38,"certified_preowned":false,"seller_type":"dealership","customer_id":"5354599","trim":"S","drivetrain":"Front-wheel Drive","vertical_position":17,"model":"Rogue","vin":"5N1BT3AA1PC895219","relevancy_score":null,"dealer_zip":"65202","year":"2023","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"60378","bodystyle":"SUV","stock_type":"Used","price":"16700","cat":"crossover_compact","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Charcoal","msrp":"0","exterior_color":"Super Black","canonical_mmt":"Nissan:Rogue:S","make":"Nissan","cpo_package":null,"dealer_name":"Columbia Honda","listing_id":"daeecf51-87c2-42bb-ac5a-658350a45e60","canonical_mmty":"Nissan:Rogue:S:2023"},{"badges":["price_drop_in_cents","great_deal","hot_car"],"photo_count":42,"certified_preowned":false,"seller_type":"dealership","customer_id":"5363961","trim":"Platinum","drivetrain":"All-wheel Drive","vertical_position":18,"model":"Rogue","vin":"JN8AT3DD2MW308420","relevancy_score":null,"dealer_zip":"65202","year":"2021","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"77635","bodystyle":"SUV","stock_type":"Used","price":"20391","cat":"crossover_compact","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Charcoal","msrp":"0","exterior_color":"Caspian Blue Metallic","canonical_mmt":"Nissan:Rogue:Platinum","make":"Nissan","cpo_package":null,"dealer_name":"Joe Machens Toyota","listing_id":"d658b85c-8e58-464a-845d-3372f94d6d9b","canonical_mmty":"Nissan:Rogue:Platinum:2021"},{"badges":["price_drop_in_cents","great_deal","hot_car"],"photo_count":17,"certified_preowned":false,"seller_type":"dealership","customer_id":"6066303","trim":"SV","drivetrain":"All-wheel Drive","vertical_position":19,"model":"Rogue","vin":"JN8BT3BB4PW479941","relevancy_score":null,"dealer_zip":"65203","year":"2023","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"10056","bodystyle":"SUV","stock_type":"Used","price":"23000","cat":"crossover_compact","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Charcoal","msrp":"0","exterior_color":"Pearl White Tricoat","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","cpo_package":null,"dealer_name":"Subaru of Columbia","listing_id":"21fedfb2-a3fa-4c6d-8515-b63ccddbb6ca","canonical_mmty":"Nissan:Rogue:SV:2023"},{"badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"photo_count":44,"certified_preowned":false,"seller_type":"dealership","customer_id":"5364038","trim":"SV","drivetrain":"All-wheel Drive","vertical_position":20,"model":"Rogue","vin":"5N1BT3BB2RC694388","relevancy_score":null,"dealer_zip":"65202","year":"2024","stock_sub":"","nvi_program":false,"sponsored":false,"fuel_type":"Gasoline","mileage":"52803","bodystyle":"SUV","stock_type":"Used","price":"19731","cat":"crossover_compact","cpo_indicator":false,"sponsored_type":"standard","interior_color":"Charcoal","msrp":"0","exterior_color":"Super Black","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","cpo_package":null,"dealer_name":"Joe Machens Volkswagen","listing_id":"56e205b9-bc6e-4656-a25c-1d61e4eb27cf","canonical_mmty":"Nissan:Rogue:SV:2024"}]}]