Skip to main content

Contact seller

Contact seller

By clicking here, you authorize Cars.com and its sellers/partners to contact you by text/calls which may include marketing and be by autodialer. Calls may be prerecorded. You also agree to our Privacy Notice. Consent is not required to purchase goods/services.

We value your privacy. Cars.com Privacy Notice

Customize your budget

Est. max vehicle price based on your desired monthly budget (...% APR*. and ...% sales tax)
$...*
See matching cars

*Estimated payments are calculated by Cars.com and are for informational purposes only. We’ve estimated your taxes based on your provided ZIP code. These estimates do not include title, registration fees, lien fees, or any other fees that may be imposed by a governmental agency in connection with the sale and financing of the vehicle. Other taxes may apply. They do not represent a financing offer or a guarantee of credit from the seller. Actual terms vary by lender.

**Your Saved Vehicles list will be shared along with your contact information when you submit a vehicle request to a dealership. To opt out of this sharing, please view your options on Cars.com Privacy Notice.

About your privacy: Cars.com is asking for your ZIP and credit rating because it helps us to make an educated guess at your sales tax and loan interest. These two factors can greatly change your monthly payment.

Used compact SUVs for sale near Mexico, MO

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
198 matches 30 miles from 65265
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: Pearl White Tricoat
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 30-37
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L I3 Turbocharged DOHC 12V LEV3-ULEV50 201hp
Stock #: PC914350
VIN: 5N1BT3BAXPC914350

Features

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

Reviews

Joe Machens Nissan review

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.

2023 Nissan Rogue SV review

So far I have been pleased with the performance of my

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

Vehicle information

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

Features

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

Reviews

Joe Machens Volkswagen review

Great Service Center

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

2022 Volkswagen Tiguan 2.0T SE 4MOTION review

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

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

Vehicle information

Ext. color: Gun Metallic
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 #: PC892725
VIN: 5N1BT3AB0PC892725

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

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 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: Graphite Gray
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 24-30
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: SZ016163
VIN: JA4J4VA83SZ016163

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

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 Mitsubishi Outlander SE 2.5 S-AWC review

I purchased 2 new Mitsubishi Outlanders after doing

I purchased 2 new Mitsubishi Outlanders after doing Internet research on currently available mid-sized SUVs. A test drive nailed the choice. The 2025 model introduced several changes that have addressed prior criticisms about vague steering and hood vibrations and ride. The fit and finish of both exterior and interior is excellent, typical of a Japanese car and as good or better than the Toyota RAV4 or Nissan Rogue that were being considered (the Outlander and the Rogue share the same platform, but IMHO the Outlander is the better rendition). The interior of the SE trim is very plush at this price point with leatherette and suede seating that is supportive and "hugs" you and looks and feels better than more expensive luxury SUVs in this size class such as the Lincoln Corsair and Aviator. The standard Yamaha audio system produces astonishingly good sound with either Bluetooth audio or Sirius XM. The Outlander supports Android Auto, and its navigation is excellent. Steering feel is excellent and well-weighted, and braking is strong. The Outlander has a surprisingly small turning circle. The electronics assists and displays work flawlessly, especially the adaptive cruise control and lane-keeping and both front and rear parking assistance via the good-sized infotainment display screen, which also provides an overhead overall view (AI?). While the Outlander does have standard third-row seating, the seats and leg room are miniscule (suitable only for very small children or pets) and hard to access, but I plan to never use them for seating and keep them folded down to maximize cargo carrying space, which is even more generous with the second-row seatbacks folded down. Exterior styling is very bold and contemporary and distinctive, especially the front styling and the wheels; it has grown on me. The 2025 Outlander thankfully does not have that horrible stop-start feature where the engine shuts off if stopped at a traffic light, and in hot and humid Florida, the AC is not interrupted like on other new cars. The transmission shift lever is not intuitive to use, but eventually you get used to it (IMHO a simple rotary knob would be easier to use). The Outlander has a very generous power train warranty and comes with the initial three oil change services included. The horsepower is modest but more than adequate for city and suburban driving, and the CVT seems well mated to the engine and drives very smoothly. If Mitsubishi added a turbocharged version, that would certainly boost the acceleration.

Vehicle information

Ext. color: Pearl White Tricoat
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: Automatic
Engine: VC-Turbo 1.5L I-3 gasoline direct injection, DOHC, CVTCS variabl
Stock #: NW337300
VIN: JN8BT3BB6NW337300

Features

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

Reviews

Joe Machens Volkswagen review

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.

2022 Nissan Rogue SV review

Comfortable car

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

Vehicle information

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

Features

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

Reviews

Columbia Honda review

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.

2025 Mazda CX-5 2.5 S Select Package review

We were loyal Subaru owners previously but were forced to

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

Vehicle information

Ext. color: Crystal White Pearl
Int. color: Brown
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L H4 16V GDI DOHC
Stock #: 26321A
VIN: JF2SLDTC6SH455938

Features

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

Reviews

Pearl Motor Company review

The splash guards look fantastic.

The splash guards look fantastic. Definitely kicked up the outside of the Denali. We waited in the Customer Lounge and it was very nice and comfortable. It didn't take them very long to complete the work either.

2025 Subaru Forester Touring review

I have had a 21, 23 and now a 25 Subaru Forester Premium

I have had a 21, 23 and now a 25 Subaru Forester Premium and over the years they have gotten better. I didn’t think I would like the large screen but now after two weeks of driving it, I’m loving it. It is a safe and reliable vehicle for small families and seniors like me.

Vehicle information

Ext. color: Alloy Silver Metallic
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 24-31
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L I4 16V GDI DOHC
Stock #: 1939
VIN: JA4J3UA85PZ013124

Features

Convenience: Adaptive Cruise Control, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

Pearl Motor Company review

Quick, efficient, reasonably-priced oil change.

Quick, efficient, reasonably-priced oil change. The Pearl Motor Co. Team was friendly, and the lounge/waiting area was clean with well-appointed amenities. Top-Notch facility, Top-Notch people!

2023 Mitsubishi Outlander SE review

2023 Mitsubishi Outlander SEL BLACK EDITION.

2023 Mitsubishi Outlander SEL BLACK EDITION. I bought mines brand new on Nov 2022. So far it had a recall for firmware update. As of now. Almost 15 k miles and no issues. I love all the features and was told ot doesn't have the issues its predecessor had. Mitsubishi invested millions in the 2023 models so hopefully I can get 200k or more miles out of it.

Vehicle information

Ext. color: Black Clearcoat
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 17-21
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.6L V-6 DOHC, variable valve control, regular unleaded, engine
Stock #: EL263160
VIN: 1C4AJWBG2EL263160

Features

Convenience: Keyless Entry, Navigation System
Entertainment: Bluetooth®, CD Player, DVD Player, USB Port
Exterior: Alloy Wheels, Sunroof/Moonroof, Tow Hooks
Safety: Automatic Emergency Braking, Brake Assist, Stability Control

Reviews

Joe Machens Hyundai review

Aaron Veal did a amazing job helping my son get into his

Aaron Veal did a amazing job helping my son get into his first new car...this is the second vehicle we have gotten from him...Thanks for always looking out for us !!

2014 Jeep Wrangler Sahara review

Awesome vehicle

They care overall is great. Fred is fixing any of the little things that we knew about it prior to me taking it!!! Fred added on so much and is putting new tires on and fixing any of the little things!!!!!

Vehicle information

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

Features

Convenience: Adaptive Cruise Control, Heated Steering Wheel, Keyless Start, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio, USB Port
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, Lane Departure Warning, Stability Control
Seating: Leather Seats

Reviews

Pearl Motor Company review

Joe Ellison was a fantastic salesman who was very

Joe Ellison was a fantastic salesman who was very knowledgeable. The entire team at PMC was phenomenal. We will definitely be back in the future the next time we need to purchase a vehicle as our overall experience was a good one. We highly recommend Pearl Motor Company.

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: Brilliant Silver Metallic
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 DOHC, variable valve control, regular unleaded, engine
Stock #: KC823203
VIN: 5N1AT2MV4KC823203

Features

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

Reviews

Joe Machens Hyundai review

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

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

2019 Nissan Rogue SL review

Very sharp

I am very pleased with my Rogue. It is a 2019 that I purchased with 13K. I think the styling is very good and the interior is roomy. I'm 6' and my brother is 6-2 and we both have plenty of headroom in the front or the back. The turning radius is very good. Only downside (which I don't care about) is the acceleration is only mediocre. Overall, highly recommended.

Vehicle information

Ext. color: Gun Metallic
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 DOHC, variable valve control, regular unleaded, engine
Stock #: JC770739
VIN: 5N1AT2MV0JC770739

Features

Convenience: Keyless Entry
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, USB Port, WiFi Hotspot
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Rear Cross Traffic Alert, Stability Control

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

2018 Nissan Rogue S review

This was a replacement vehicle for a Toyota Camry that

This was a replacement vehicle for a Toyota Camry that was totaled. Bought it, it was 3 years old with 36,032 miles on it. Been rear ended $14,000 in Damages to the rear, there’s only 2 things I would complain about. One getting a replacement Drivers seat has been a problem, I’ve even looked in Auto salvage yards to get a replacement seat, it’s been a headache, and if you do find one you got to give the first 2 numbers of the VIN # so the wiring Harness will work.. if you have the American built version , the Japanese or Korean Version Wiring Harnesses will not work, they will bolt in, but the Harnesses won’t work. Been looking for 3 years for a seat , still can’t find one. I’ve looked in both North & South Carolina for a replacement seat.

Vehicle information

Ext. color: Rhodium White Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 24-30
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.5L I4 16V GDI DOHC
Stock #: P0187767
VIN: JM3KFBDM3P0187767

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

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!

2023 Mazda CX-5 2.5 S Premium review

Very pleased!

I am delighted with my 2023 CX-5 Signature in the hard-to-find Eternal Blue. I've had it about one year now and it's more than adequate for my driving needs. No, I don't need a rattle-prone pano sunroof. The six-speed non-CVT transmission is just fine. Never need or use(less) the paddle shifters. Performance with regular fuel is just fine. As an "early senior", I don't need huge cargo or passenger space. Only complaints are the Apple CarPlay isn't wireless; and miss the power tilt/telescope steering wheel and power memory exit seat that I had on my unbeloved '20 Lexus NX (which I was glad to get rid of!). All told, I'm a Mazda believer and buh-bye Lexus!

Vehicle information

Ext. color: Horizon Blue Pearl
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L H4 16V GDI DOHC
Stock #: PH412545
VIN: JF2SKAPCXPH412545

Features

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

Reviews

Mazda of Columbia review

lartiquefreeman2206@yahoo.com

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

2023 Subaru Forester Limited review

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

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

Vehicle information

Ext. color: Gun Metallic
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 29-36
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 1.5L I3 12V GDI DOHC Turbo
Stock #: PC796922
VIN: 5N1BT3CA9PC796922

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Mazda of Columbia review

Upgraded review from 10/10

Quoting review I am retracting first, as the dealership solved the issues pleasantly and professionally,”My wife and I purchased a 2019 Ford Edge from this dealership on 10/10/22. Our salesman was Glenn Gannaway. After coming to an agreement on the purchase of the vehicle, we had filled out a form for requests to be completed as part of the deal. One request was to repair or replace the damaged headliner. Secondly, Glenn told us he would get us the second of the pair of key fobs. Thirdly, we requested a bottle of touch up paint to take care of small nicks in the exterior paint. Now three weeks later, we are still waiting for these requests to be taken care of by this dealership.” The updated review is a five star review “We purchased a 2019 Ford Edge Titanium from this dealership on 11/10/22. We traded in our Ford Escape and our F-150 on this vehicle to have lower payment and more comforts. The deal went well with Glenn Gannaway as our salesman and Josh Woodruff taking care of the finances. Josh did an excellent job with our financing and made sure that we were able to get a refund on our unused Ford warranty balance. They gave us a fair trade on both of our vehicles and a reasonable price on our Ford Edge. There were a couple of items that had to be taken care of after the sale on the we owe sheet. The headliner had some damage and there was a few small paint chips and only one key fob with the Edge. The dealership has provided touch up paint for the chips and purchased a second key fob for us. They had repairs made to the headliner, and although it doesn’t look brand new, it is acceptable and hardly noticeable. The experience, although time consuming has ended on a good note and I would recommend buying a new or used vehicle from the Machens Auto Group.”

2023 Nissan Rogue SL review

Purchased my Rogue about one month ago.

Purchased my Rogue about one month ago. I previously owned a Lexus ES350 and wanted a small SUV but the luxury brands didn’t do it for me. Likes: Works well as a daily driver Has all the room I need SL trim level is very nice, love 360 camera Bought from a great dealership Dislikes The Bose sound system is horrible Mid 20’s MPG, could be better Overall, very happy with my choice and glad I didn’t go with the CX5 I almost bought.

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

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.

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: Moonlight White
Int. color: Almond
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L I4 16V MPFI DOHC
Stock #: 216696B
VIN: KNMAT2MV6FP534312

Features

Convenience: Keyless Entry, Keyless Start, Navigation System, Power Liftgate
Entertainment: Bluetooth®, CD Player, Satellite Radio
Exterior: Alloy Wheels, Roof Rack
Safety: Backup Camera, Brake Assist, Stability Control

Reviews

Jim Butler Centralia review

The best experience I’ve had!

The best experience I’ve had! From start to finish. Great job to the team in Centralia!

2015 Nissan Rogue SV review

I have a 2015 Nissan Rogue SV AWD and it has always been

I have a 2015 Nissan Rogue SV AWD and it has always been reliable and never had any mechanical issues with it. I really believe the mechanical issues some owners experience comes down to regular maintenance being done. It’s a great looking SUV and it’s no wonder there are so many on the road.

Vehicle information

Ext. color: Magnetic Black Pearl
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 2.5L I-4 DOHC, variable valve control, regular unleaded, engine
Stock #: KW258175
VIN: JN8AT2MT7KW258175

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, 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.

2019 Nissan Rogue SV review

Truly an amazing car

I truly love driving this car. Tons of space of the inside, great on gas, and good acceleration for a crossover SUV when you put your foot down.

Vehicle information

Ext. color: Abyss Black Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 28-33
Fuel type: Gasoline
Transmission: Automatic
Engine: Nu 2L I-4 DOHC, D-CVVT variable valve control, regular unleaded,
Stock #: PU011783
VIN: KM8K2CAB8PU011783

Features

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

Reviews

Joe Machens Volkswagen review

Great to work with!

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

2023 Hyundai KONA SE review

Purchased the car a month ago and it does not disappoint.

Purchased the car a month ago and it does not disappoint. Has got a kick to it. Brakes are a little choppy but reliable. Inside is comfortable. Enough room and yet compact.

Vehicle information

Ext. color: Crystal Black Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 40-34
Fuel type: Hybrid
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, i-VTEC variable valve co
Stock #: TE015158
VIN: 7FARS6H97TE015158

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

Reviews

Columbia Honda review

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!

2026 Honda CR-V Hybrid Sport Touring AWD review

We've only had the car for about 2 weeks, but it's been

We've only had the car for about 2 weeks, but it's been great so far. Gas mileage with this hybrid has been about 44.5 mpg with mostly city driving, cabin is comfortable for driver and passengers, the GPS and audio systems work well, and I can see the bright red color pretty easily in parking lots!

About SUVs

FAQs

What is the cheapest SUV available?

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

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 24549 great deals out of 69858 listings starting at $1.

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

198 matches Clear
Reset
Basics
Price & payment Full Price Monthly
Monthly budget search results are estimated based on a 72-month loan term with $0 down payment, $0 trade-in value, 0.0% sales tax and 7.0% APR. Inputs can be personalized using the calculator.
Financing
Deal rating
Vehicle history
Awards
Style
Body style
Vehicle size
Cab type
Exterior color
Interior color
Performance
Transmission
Drivetrain
Cylinders
Fuel type
EV range
EV charge time
Features
Convenience
Entertainment
Exterior
Safety
Seating
Door count
Seller info
Seller type
Keyword
Update
Show only
[{"applied_filter_criteria":"{\"bodystyle\":[\"suv\"],\"cpo_indicator\":false,\"search_range\":\"30\",\"shippable\":true,\"size_slugs\":[\"compact\"],\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"19687","relevancy_score":null,"trim":"SV","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"224cd334-6e70-43de-bc61-fd468ab2ac45","dealer_zip":"65203","mileage":"52136","stock_sub":"","sponsored":false,"badges":["good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5363960","msrp":"0","vin":"5N1BT3BAXPC914350","canonical_mmty":"Nissan:Rogue:SV:2023","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","dealer_name":"Joe Machens Nissan","cpo_indicator":false,"exterior_color":"Pearl White Tricoat","drivetrain":"Front-wheel Drive","vertical_position":1,"year":"2023","photo_count":28,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Tiguan","price":"19189","relevancy_score":null,"trim":"2.0T SE 4MOTION","interior_color":"Titan Black","sponsored_type":"standard","listing_id":"66d2a142-5af1-435d-874d-34370a581b3f","dealer_zip":"65202","mileage":"83899","stock_sub":"","sponsored":false,"badges":["good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5364038","msrp":"0","vin":"3VV2B7AX4NM009118","canonical_mmty":"Volkswagen:Tiguan:2.0T SE 4MOTION:2022","seller_type":"dealership","canonical_mmt":"Volkswagen:Tiguan:2.0T SE 4MOTION","make":"Volkswagen","dealer_name":"Joe Machens Volkswagen","cpo_indicator":false,"exterior_color":"Platinum Gray Metallic","drivetrain":"All-wheel Drive","vertical_position":2,"year":"2022","photo_count":6,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"19300","relevancy_score":null,"trim":"S","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"235a0afd-d194-4205-916e-a6e64c8002d8","dealer_zip":"65202","mileage":"51543","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","great_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5354599","msrp":"0","vin":"5N1BT3AB0PC892725","canonical_mmty":"Nissan:Rogue:S:2023","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:S","make":"Nissan","dealer_name":"Columbia Honda","cpo_indicator":false,"exterior_color":"Gun Metallic","drivetrain":"All-wheel Drive","vertical_position":3,"year":"2023","photo_count":36,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Outlander","price":"26500","relevancy_score":null,"trim":"SE 2.5 S-AWC","interior_color":"Black","sponsored_type":"standard","listing_id":"80e12eaa-085f-41b9-ac40-94ce3241bacf","dealer_zip":"65202","mileage":"20323","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5354599","msrp":"0","vin":"JA4J4VA83SZ016163","canonical_mmty":"Mitsubishi:Outlander:SE 2.5 S-AWC:2025","seller_type":"dealership","canonical_mmt":"Mitsubishi:Outlander:SE 2.5 S-AWC","make":"Mitsubishi","dealer_name":"Columbia Honda","cpo_indicator":false,"exterior_color":"Graphite Gray","drivetrain":"Four-wheel Drive","vertical_position":4,"year":"2025","photo_count":37,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"23615","relevancy_score":null,"trim":"SV","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"6cb3cdde-25a1-4be4-b05c-77dd4a656cf9","dealer_zip":"65202","mileage":"24090","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5364038","msrp":"0","vin":"JN8BT3BB6NW337300","canonical_mmty":"Nissan:Rogue:SV:2022","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","dealer_name":"Joe Machens Volkswagen","cpo_indicator":false,"exterior_color":"Pearl White Tricoat","drivetrain":"All-wheel Drive","vertical_position":5,"year":"2022","photo_count":43,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"CX-5","price":"23800","relevancy_score":null,"trim":"2.5 S Select Package","interior_color":"Black","sponsored_type":"standard","listing_id":"45889741-7f66-4890-8bed-62ca68610d15","dealer_zip":"65202","mileage":"23412","stock_sub":"","sponsored":false,"badges":["great_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5354599","msrp":"0","vin":"JM3KFBBL5S0583993","canonical_mmty":"Mazda:CX-5:2.5 S Select Package:2025","seller_type":"dealership","canonical_mmt":"Mazda:CX-5:2.5 S Select Package","make":"Mazda","dealer_name":"Columbia Honda","cpo_indicator":false,"exterior_color":"Platinum Quartz Metallic","drivetrain":"All-wheel Drive","vertical_position":6,"year":"2025","photo_count":6,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Forester","price":"38500","relevancy_score":null,"trim":"Touring","interior_color":"Brown","sponsored_type":"standard","listing_id":"9fefe025-a9d4-4c40-8f5e-90193bc96a6c","dealer_zip":"65265","mileage":"10449","stock_sub":"","sponsored":false,"badges":["good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"182187","msrp":"38950","vin":"JF2SLDTC6SH455938","canonical_mmty":"Subaru:Forester:Touring:2025","seller_type":"dealership","canonical_mmt":"Subaru:Forester:Touring","make":"Subaru","dealer_name":"Pearl Motor Company","cpo_indicator":false,"exterior_color":"Crystal White Pearl","drivetrain":"All-wheel Drive","vertical_position":7,"year":"2025","photo_count":27,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Outlander","price":"23950","relevancy_score":null,"trim":"SE","interior_color":"Black","sponsored_type":"standard","listing_id":"7bc54f59-df60-4df0-b987-755cacdb81a3","dealer_zip":"65265","mileage":"20277","stock_sub":"","sponsored":false,"badges":["great_deal","hot_car"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"182187","msrp":"23950","vin":"JA4J3UA85PZ013124","canonical_mmty":"Mitsubishi:Outlander:SE:2023","seller_type":"dealership","canonical_mmt":"Mitsubishi:Outlander:SE","make":"Mitsubishi","dealer_name":"Pearl Motor Company","cpo_indicator":false,"exterior_color":"Alloy Silver Metallic","drivetrain":"Front-wheel Drive","vertical_position":8,"year":"2023","photo_count":23,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Wrangler","price":"17779","relevancy_score":null,"trim":"Sahara","interior_color":"Black","sponsored_type":"standard","listing_id":"ed2e140b-96c4-43e5-83ec-472bb9b81559","dealer_zip":"65202","mileage":"61473","stock_sub":"","sponsored":false,"badges":["hot_car"],"certified_preowned":false,"cat":"suv_midsize","customer_id":"5363959","msrp":"0","vin":"1C4AJWBG2EL263160","canonical_mmty":"Jeep:Wrangler:Sahara:2014","seller_type":"dealership","canonical_mmt":"Jeep:Wrangler:Sahara","make":"Jeep","dealer_name":"Joe Machens Hyundai","cpo_indicator":false,"exterior_color":"Black Clearcoat","drivetrain":"Four-wheel Drive","vertical_position":9,"year":"2014","photo_count":16,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"23500","relevancy_score":null,"trim":"SV","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"fe90b8bf-56d9-42e3-b187-09e12a79e3b9","dealer_zip":"65265","mileage":"43059","stock_sub":"","sponsored":false,"badges":["good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"182187","msrp":"24500","vin":"5N1BT3BB7PC837879","canonical_mmty":"Nissan:Rogue:SV:2023","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","dealer_name":"Pearl Motor Company","cpo_indicator":false,"exterior_color":"Gun Metallic","drivetrain":"All-wheel Drive","vertical_position":10,"year":"2023","photo_count":25,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"14877","relevancy_score":null,"trim":"SL","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"ba774d1a-2a88-4bdb-bafe-d9619678a87a","dealer_zip":"65202","mileage":"95205","stock_sub":"","sponsored":false,"badges":["great_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5363959","msrp":"0","vin":"5N1AT2MV4KC823203","canonical_mmty":"Nissan:Rogue:SL:2019","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:SL","make":"Nissan","dealer_name":"Joe Machens Hyundai","cpo_indicator":false,"exterior_color":"Brilliant Silver Metallic","drivetrain":"All-wheel Drive","vertical_position":11,"year":"2019","photo_count":8,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"13999","relevancy_score":null,"trim":"S","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"4dbf0d27-123a-4a6a-b64d-d803e5dcc3d4","dealer_zip":"65203","mileage":"68574","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5395269","msrp":"0","vin":"5N1AT2MV0JC770739","canonical_mmty":"Nissan:Rogue:S:2018","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:S","make":"Nissan","dealer_name":"Kia of Columbia","cpo_indicator":false,"exterior_color":"Gun Metallic","drivetrain":"All-wheel Drive","vertical_position":12,"year":"2018","photo_count":27,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"CX-5","price":"23200","relevancy_score":null,"trim":"2.5 S Premium","interior_color":"Black","sponsored_type":"standard","listing_id":"227906ce-abef-4089-88a5-83d64d3b5d2a","dealer_zip":"65202","mileage":"59957","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5364156","msrp":null,"vin":"JM3KFBDM3P0187767","canonical_mmty":"Mazda:CX-5:2.5 S Premium:2023","seller_type":"dealership","canonical_mmt":"Mazda:CX-5:2.5 S Premium","make":"Mazda","dealer_name":"Mazda of Columbia","cpo_indicator":false,"exterior_color":"Rhodium White Metallic","drivetrain":"All-wheel Drive","vertical_position":13,"year":"2023","photo_count":28,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Forester","price":"20700","relevancy_score":null,"trim":"Limited","interior_color":"Gray","sponsored_type":"standard","listing_id":"06c284f4-d632-423a-a7e8-ae16df067379","dealer_zip":"65202","mileage":"100290","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5364156","msrp":null,"vin":"JF2SKAPCXPH412545","canonical_mmty":"Subaru:Forester:Limited:2023","seller_type":"dealership","canonical_mmt":"Subaru:Forester:Limited","make":"Subaru","dealer_name":"Mazda of Columbia","cpo_indicator":false,"exterior_color":"Horizon Blue Pearl","drivetrain":"All-wheel Drive","vertical_position":14,"year":"2023","photo_count":28,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"21200","relevancy_score":null,"trim":"SL","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"4e1662b4-6b37-48b0-a1c4-c11ff5970223","dealer_zip":"65202","mileage":"57921","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5364156","msrp":null,"vin":"5N1BT3CA9PC796922","canonical_mmty":"Nissan:Rogue:SL:2023","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:SL","make":"Nissan","dealer_name":"Mazda of Columbia","cpo_indicator":false,"exterior_color":"Gun Metallic","drivetrain":"Front-wheel Drive","vertical_position":15,"year":"2023","photo_count":28,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Outlander","price":"26391","relevancy_score":null,"trim":"SEL 2.5 2WD","interior_color":"Light Gray","sponsored_type":"standard","listing_id":"576a405e-5fae-4352-b497-21fff8559e93","dealer_zip":"65202","mileage":"25791","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal","hot_car"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5363961","msrp":"0","vin":"JA4J3WA88RZ087927","canonical_mmty":"Mitsubishi:Outlander:SEL 2.5 2WD:2024","seller_type":"dealership","canonical_mmt":"Mitsubishi:Outlander:SEL 2.5 2WD","make":"Mitsubishi","dealer_name":"Joe Machens Toyota","cpo_indicator":false,"exterior_color":"White Diamond","drivetrain":"Front-wheel Drive","vertical_position":16,"year":"2024","photo_count":42,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"12530","relevancy_score":null,"trim":"SV","interior_color":"Almond","sponsored_type":"standard","listing_id":"40361400-65ea-4a1e-8b6d-c60f0134f016","dealer_zip":"65240","mileage":"126731","stock_sub":"","sponsored":false,"badges":["good_deal","hot_car"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5397028","msrp":null,"vin":"KNMAT2MV6FP534312","canonical_mmty":"Nissan:Rogue:SV:2015","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","dealer_name":"Jim Butler Centralia","cpo_indicator":false,"exterior_color":"Moonlight White","drivetrain":"All-wheel Drive","vertical_position":17,"year":"2015","photo_count":36,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"Rogue","price":"11691","relevancy_score":null,"trim":"SV","interior_color":"Charcoal","sponsored_type":"standard","listing_id":"a65ce536-bd0d-444c-9b6a-51b7df78b737","dealer_zip":"65202","mileage":"139474","stock_sub":"","sponsored":false,"badges":["good_deal","hot_car"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5363961","msrp":"0","vin":"JN8AT2MT7KW258175","canonical_mmty":"Nissan:Rogue:SV:2019","seller_type":"dealership","canonical_mmt":"Nissan:Rogue:SV","make":"Nissan","dealer_name":"Joe Machens Toyota","cpo_indicator":false,"exterior_color":"Magnetic Black Pearl","drivetrain":"Front-wheel Drive","vertical_position":18,"year":"2019","photo_count":5,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":null,"stock_type":"Used","model":"KONA","price":"15587","relevancy_score":null,"trim":"SE","interior_color":"Black","sponsored_type":"standard","listing_id":"b1224ae8-260b-4a01-a32a-81dbf7e72726","dealer_zip":"65202","mileage":"88763","stock_sub":"","sponsored":false,"badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"cat":"crossover_compact","customer_id":"5364038","msrp":"0","vin":"KM8K2CAB8PU011783","canonical_mmty":"Hyundai:KONA:SE:2023","seller_type":"dealership","canonical_mmt":"Hyundai:KONA:SE","make":"Hyundai","dealer_name":"Joe Machens Volkswagen","cpo_indicator":false,"exterior_color":"Abyss Black Pearl","drivetrain":"All-wheel Drive","vertical_position":19,"year":"2023","photo_count":42,"fuel_type":"Gasoline","nvi_program":false},{"bodystyle":"SUV","cpo_package":"HondaTrue Certified","stock_type":"Used","model":"CR-V Hybrid","price":"38000","relevancy_score":null,"trim":"Sport Touring AWD","interior_color":"Black","sponsored_type":"standard","listing_id":"f82fd525-fcbd-4af1-993a-f156eff1ae72","dealer_zip":"65202","mileage":"7177","stock_sub":"","sponsored":true,"badges":["price_drop_in_cents","great_deal","cpo"],"certified_preowned":true,"cat":"hybrid_suv","customer_id":"5354599","msrp":"0","vin":"7FARS6H97TE015158","canonical_mmty":"Honda:CR-V Hybrid:Sport Touring AWD:2026","seller_type":"dealership","canonical_mmt":"Honda:CR-V Hybrid:Sport Touring AWD","make":"Honda","dealer_name":"Columbia Honda","cpo_indicator":true,"exterior_color":"Crystal Black Pearl","drivetrain":"All-wheel Drive","vertical_position":20,"year":"2026","photo_count":34,"fuel_type":"Hybrid","nvi_program":false}]}]