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 New Franklin, MO

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
247 matches 30 miles from 65274
Be the first to know!

Save your search and get notified when new inventory arrives.

Prequalify now

It only takes a few minutes and won't affect your credit.

Get Prequalified
Est. $400 /mo*
Down Payment
$0
Net trade-in value
$0
Months
72
APR
7.0%
Sales tax
0.0%

Vehicle information

Ext. color: Everest White Pearl
Int. color: Light Gray
Drivetrain: All-wheel Drive
MPG: 28-34
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L DOHC
Stock #: RW173686
VIN: JN8BT3CB5RW173686

Features

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

2024 Nissan Rogue SL review

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

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

Vehicle information

Ext. color: 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 #: NC710529
VIN: 5N1BT3BB7NC710529

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

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.

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: Polymetal Gray Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 26-30
Fuel type: Gasoline
Transmission: Automatic
Engine: SKYACTIV-G 2.5L I-4 gasoline direct injection, DOHC, variable va
Stock #: S0700253
VIN: JM3KFBCM5S0700253

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

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.

2025 Mazda CX-5 2.5 S Carbon Edition review

I bought myself a Christmas gift, a new CX5

I bought myself a Christmas gift, a new CX5 SignatureTurbo the day after Christmas and I absolutely love it! I don't' know why I didn't get one sooner. I have always been a Toyota, Lexus guy, but I must say this classy vehicle beats the others. Why, let's start with the interior. Mazda makes some of the most beautiful interiors! Exteriors too!! The fit and finish are superb! The CX 5 is extremely quiet and smooth riding, and I can honestly say it is quieter than any Lexus I have had in the past. There is also the fun factor! If you haven't tried a Mazda, you need to. They are a driver's car and fun to drive. The trim level I have has the Bose system and has a beautiful surround sound. Crank up the volume and it's awesome! The safety features are excellent, and everything is conveniently located. There is no need in paying for other Luxury cars when you can get a Mazda and save thousands, and they are the best keep secret out there. Luxury, fun, good looks for much less. I am definitely staying in the Mazda family.

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 #: MU8353
VIN: JN8BT3BA2RW350946

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

Mercedes-Benz of Columbia review

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

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

2024 Nissan Rogue SV review

I'm in the car I always wanted!

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

Vehicle information

Ext. color: Pure White
Int. color: Titan Black
Drivetrain: Front-wheel Drive
MPG: 23-30
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: RM124536
VIN: 3VVRB7AXXRM124536

Features

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

2024 Volkswagen Tiguan 2.0T S review

30mpg avg with the longest and widest roof rail base for

30mpg avg with the longest and widest roof rail base for outdoor gear at a price that made sense. 2nd row middle seat folds down individually for skis and paddles. Remote start on the vw app is great for cooling the interior down on a 100 degree day from a distance. Rear seat door opening and leg room is huge great for elders to enter easily and for parents loading car seats.

Vehicle information

Ext. color: Gray
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: MU8283A
VIN: YV4L12RVXP1265580

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Remote Start
Entertainment: 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, Memory Seat

Reviews

Mercedes-Benz of Columbia review

I highly recommend Mercedes-Benz of Columbia

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

2023 Volvo XC60 B5 Core review

This is 100% one of the best cars I’ve owned.

This is 100% one of the best cars I’ve owned. Comparing it to my previously owned Acuras, Audis, BMWs, Buicks, Cadillacs, GMCs, Land Rover Range Rovers, Mercedes-Benzs, Porsches, Volkswagens, this is one of my top favorite vehicles for comfort, performance, technology, driving, etcetera. I 10/10 recommend.

Vehicle information

Ext. color: Pure White
Int. color: Titan Black
Drivetrain: All-wheel Drive
MPG: 21-27
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: MM036693
VIN: 3VV2B7AXXMM036693

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless 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, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

Joe Machens Volkswagen review

GREAT SERVICE!

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

2021 Volkswagen Tiguan 2.0T SE 4MOTION review

Great car and I shopped several

Great car, quiet ride mostly for an SUV, glad I bought it, tested Honda CRV, Mazda CX-5, Hyundai Tucson, Kia Sorrento, Chevrolet Equinox, Terrain, and many others, at that time I could not make a comparison with Toyota since there were none to be tested, the Tiguan stood above the others

Vehicle information

Ext. color: Horizon Blue
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 #: RH413608
VIN: JF2SKACC1RH413608

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, 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, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control

Reviews

2024 Subaru Forester Premium review

the forester sport is very reliable get 26 mpg on most of

the forester sport is very reliable get 26 mpg on most of my daily commutes. Drives great in the winter (even though I have the same tires they came with). Traveling in it on road trips are great, 31 mpg using the cruise control and lane assist. It's not a very fast SUV but it honestly worth it. I tend to speed, but it's not something that actually bothers me. I was worried it would be too sluggish. I picked the forester for my road trips, and extra stuff I drive with.

Vehicle information

Ext. color: Summit White
Int. color: Light Neutral w/Ebony Accents
Drivetrain: Front-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: LD228547
VIN: LRBFXCSAXLD228547

Features

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

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

2020 Buick Envision FWD Essence review

Glad to have made the move!

Really like this SUV! Wanted more room than my Encore. Has everything I need! Good feeling when friends tell you how much they like the ride and the looks! Wife now driving the Encore, and she loves it!

Vehicle information

Ext. color: Deep Black Pearl
Int. color: Titan Black
Drivetrain: All-wheel Drive
MPG: 21-28
Fuel type: Gasoline
Transmission: 8-Speed Automatic with Tiptronic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: NM090932
VIN: 3VV4B7AX5NM090932

Features

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

Reviews

Joe Machens Toyota review

So happy with our purchase.

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

2022 Volkswagen Tiguan 2.0T SEL R-Line 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: Magnetite Gray Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: SH536282
VIN: JF2SLDRC4SH536282

Features

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

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 Subaru Forester Limited review

My first Subaru although each of my kids had a used one

My first Subaru although each of my kids had a used one as their first cars. Very well made, It is quite comfortable but I wish the seats went up a little bit more. I bought the Premium model and it has everything you could ask for. Handles great, has more than enough oomph, and I am averaging around 26.5 mpg in mostly city driving. Took a 200 mile out and back trip, and averaged 34.8 mpg. I will certainly buy another Subaru when it is time, usually every 2-3 years.

Vehicle information

Ext. color: Ice Silver Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: PH413654
VIN: JF2SKAEC5PH413654

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

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 Subaru Forester Premium 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: Skyscraper Gray Metallic
Int. color: Cognac
Drivetrain: All-wheel Drive
MPG: 21-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: P9R43411
VIN: 5UX53DP02P9R43411

Features

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

Reviews

Joe Machens Volkswagen review

Simply the Best

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

2023 BMW X3 xDrive30i review

Love it.

Love it. Car is comfy, quick and the wonderful B58 Twin-Scroll Turbo I6 makes all the right noises! Awesome daily driver. Period! Interior has all of the amenities you could ever ask for. Ride is luxury-oriented but also can grip & RIP through the corners, almost as well as any sports sedan out there pretty much.

Vehicle information

Ext. color: Titanium Flash Mica
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: SKYACTIV-G 2.5L I-4 gasoline direct injection, DOHC, variable va
Stock #: G0684085
VIN: JM3KE2CY9G0684085

Features

Convenience: Keyless Entry, Keyless Start
Entertainment: Bluetooth®, CD Player, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, Rear Cross Traffic Alert, Stability Control

Reviews

CDJR of Columbia review

Carson was my sales rep.

Carson was my sales rep. Walked in wanting a jeep, left in a new jeep compass. Wonderful experience overall!

2016 Mazda CX-5 Touring review

Whether you’re an enthusiast or not, you will enjoy this

Whether you’re an enthusiast or not, you will enjoy this thing until the wheels fall off. Now, if you’re an enthusiast, or just someone who loves the feel of the road underneath you but needs something fairly practical? This is the car for you. With ample power, and steering feel that would put some sports cars to shame, you will feel confident, and often joyous when behind the wheel of the CX-5, especially with the Manual version that came in the “Sport” trim! Although that engine is suggested to be fairly gutless. However, if you prefer the automatic versions with the larger engine, like in my Grand Touring trim, you will absolutely be able to enjoy the road, regardless of the local speed limit. The CX-5 may not be the fastest car in its class, but it surely is the most fun, and the best value among its competitors.. but it’s mainly just fun. I recently got my CX-5 at my local dealer, and it has done nothing but get me to work when I want it to, taken me on small trips to wherever I want, and without any real complaints. Only times it gets annoyed with me is if I need to pass anybody at highway, but that’s what makes it so much fun to live with in my opinion, especially with the little rev-happy 4-pot motors that it can come with. In conclusion, if you want a sub-compact crossover.. but also want the feel of Mazda’s own roadster? Get the CX-5. It will bring you as many smiles per gallon as you need it to.

Vehicle information

Ext. color: Caspian Blue 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 #: LP506941
VIN: KNMAT2MV2LP506941

Features

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

Reviews

CDJR of Columbia review

Very professional and courteous staff.

Very professional and courteous staff. My salesman Cole helped me throughout the process and steered me to a car I truly love. I appreciate the patience and hard work they put into the deal

2020 Nissan Rogue S review

Recommended

Nice interiors, good spaces, great color, perfect for family and daily use, engine in perfect conditions, the seller Juan Gonzalez from Seminole Toyota help me a lot in the right choice

Vehicle information

Ext. color: Satin Steel Metallic
Int. color: Ebony w/Ebony Accents
Drivetrain: All-wheel Drive
MPG: 20-25
Fuel type: Gasoline
Transmission: Automatic
Engine: ECOTEC 2L I-4 gasoline direct injection, DOHC, variable valve co
Stock #: LD169469
VIN: LRBFX3SXXLD169469

Features

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

CDJR of Columbia review

My experience with cdjr of Columbia was a 10/10.

My experience with cdjr of Columbia was a 10/10. Rich Whitler was was my sales associate he got me the truck and deal I wanted. He's as professional as I've ever experienced. He never pressured me a single time and kept workn for me the entire time thank you Rich!

2020 Buick Envision AWD Premium I review

My 2nd Buick traded my 2019 Encore for 2020 Envisi

It's been great so far. Will be taking it on a road trip first of June. Bought in Jan 2021. Love the interior styling and comfort. Love the Satin Steel Metallic Color. Would recommend.

Vehicle information

Ext. color: Soul Red Crystal Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 26-30
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.5L I4 16V GDI DOHC
Stock #: S0742004
VIN: JM3KFBCM7S0742004

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, USB Port
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, 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!

2025 Mazda CX-5 2.5 S Preferred 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: Alpine White
Int. color: Oyster W/Contrast
Drivetrain: All-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: B21126A
VIN: 5UXTR9C59KLE17537

Features

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

Reviews

BMW of Columbia - MO review

Two kids - two cars

I've worked with Josh Reichlin and Rusty Drewing a couple times already for my personal vehicle purchases, but with my 15-year old twins getting their permits, we needed something for them as well. Josh was great to work with as usual - helping us sort through the options until we found what worked best for us. Negotiations with him and Rusty went quickly and smoothly with us reaching a fair deal on each vehicle. I highly recommend BMW of Columbia for both new and used vehicles. I should also mention Brad Davis in the finance department was great as well. Their customer service can't be beat and with a fair deal on the purchase what else can you ask for?

2019 BMW X3 xDrive30i review

This vehicle was very fun to drive, it is comfortable and

This vehicle was very fun to drive, it is comfortable and sporty, and the handling was excellent. Barely any issues, just overall a great driving experience.

Vehicle information

Ext. color: Silver Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 23-28
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: RF152469
VIN: 1GYFZDR47RF152469

Features

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

Kia of Columbia review

A great experience!

This is our 1st Kia and we absolutely love it. Had a great salesman, Derek, who went above and beyond with his customer service abilities. Knowledgeable about Kia and was able to answer our questions. Keith and Mike, asst. Managers, were quite helpful. Mike really came through in solving an issue we were having. Thank you all and we are looking forward to our new relationship with Kia and its employees.

2024 Cadillac XT4 Premium Luxury review

Having owned 1 srx and 2 xt5.

Having owned 1 srx and 2 xt5. Now an xt4, I think it is the most appealing. My loaded sport has all the luxury and safety features. I drive it in sport for kicks, and 2wd for economy. If you don't need cargo space but like the xt5, go for it! Enjoy!

Vehicle information

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

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, 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

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!

2024 Kia Sportage X-Line review

Great customer service.

Great customer service. My Kia Sportage drives very comfortably. Love the heated seats. Great for carrying large items cause you can put the back seats down.

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

Which SUV has the best MPG?

The Nissan Rogue has the best MPG among traditional internal combustion SUVs and offers up to 30 MPG city and 37 MPG highway for a combined rating of 33 MPG. The Kia Niro has the best MPG amongst SUVs with hybrid powertrains, reaching 53 MPG city and 54 MPG highway for a combined rating of 53 MPG.

These figures are based on EPA mileage ratings and are for comparison purposes only. The actual mileage will vary depending on the selected vehicle model year, trim, driving conditions, driving habits, vehicle maintenance, and other factors.

Which SUV has the longest range?

The Cadillac Escalade 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 20957 great deals out of 66661 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.

247 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":[{"photo_count":28,"model":"Rogue","canonical_mmt":"Nissan:Rogue:SL","dealer_name":"Joe Machens Nissan","stock_sub":"","cat":"crossover_compact","dealer_zip":"65203","vin":"JN8BT3CB5RW173686","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2024","stock_type":"Used","price":"27707","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Light Gray","customer_id":"5363960","vertical_position":1,"nvi_program":false,"exterior_color":"Everest White Pearl","sponsored":false,"mileage":"22593","certified_preowned":false,"listing_id":"14e59873-1487-4bef-bc9f-866ff10f7ce0","fuel_type":"Gasoline","canonical_mmty":"Nissan:Rogue:SL:2024","badges":["good_deal","american_made_index_ranking"],"trim":"SL","sponsored_type":"standard","relevancy_score":null,"make":"Nissan"},{"photo_count":33,"model":"Rogue","canonical_mmt":"Nissan:Rogue:SV","dealer_name":"Columbia Honda","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"5N1BT3BB7NC710529","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2022","stock_type":"Used","price":"18280","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Charcoal","customer_id":"5354599","vertical_position":2,"nvi_program":false,"exterior_color":"Super Black","sponsored":false,"mileage":"76768","certified_preowned":false,"listing_id":"a8903a96-95f0-47a2-a001-d9dab2978a0f","fuel_type":"Gasoline","canonical_mmty":"Nissan:Rogue:SV:2022","badges":["good_deal"],"trim":"SV","sponsored_type":"standard","relevancy_score":null,"make":"Nissan"},{"photo_count":47,"model":"CX-5","canonical_mmt":"Mazda:CX-5:2.5 S Carbon Edition","dealer_name":"Joe Machens Volkswagen","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"JM3KFBCM5S0700253","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2025","stock_type":"Used","price":"25830","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Black","customer_id":"5364038","vertical_position":3,"nvi_program":false,"exterior_color":"Polymetal Gray Metallic","sponsored":false,"mileage":"15321","certified_preowned":false,"listing_id":"095e0c60-2580-4f52-b841-d372b1f487bf","fuel_type":"Gasoline","canonical_mmty":"Mazda:CX-5:2.5 S Carbon Edition:2025","badges":["good_deal","hot_car"],"trim":"2.5 S Carbon Edition","sponsored_type":"standard","relevancy_score":null,"make":"Mazda"},{"photo_count":33,"model":"Rogue","canonical_mmt":"Nissan:Rogue:SV","dealer_name":"Mercedes-Benz of Columbia","stock_sub":"","cat":"crossover_compact","dealer_zip":"65203","vin":"JN8BT3BA2RW350946","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2024","stock_type":"Used","price":"21588","bodystyle":"SUV","seller_type":"dealership","drivetrain":"Front-wheel Drive","interior_color":"Charcoal","customer_id":"5243424","vertical_position":4,"nvi_program":false,"exterior_color":"Super Black","sponsored":false,"mileage":"51377","certified_preowned":false,"listing_id":"bcb17661-9b14-4ddb-a6c9-fb196a4c2986","fuel_type":"Gasoline","canonical_mmty":"Nissan:Rogue:SV:2024","badges":["great_deal","american_made_index_ranking"],"trim":"SV","sponsored_type":"standard","relevancy_score":null,"make":"Nissan"},{"photo_count":7,"model":"Tiguan","canonical_mmt":"Volkswagen:Tiguan:2.0T S","dealer_name":"Columbia Honda","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"3VVRB7AXXRM124536","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2024","stock_type":"Used","price":"21200","bodystyle":"SUV","seller_type":"dealership","drivetrain":"Front-wheel Drive","interior_color":"Titan Black","customer_id":"5354599","vertical_position":5,"nvi_program":false,"exterior_color":"Pure White","sponsored":false,"mileage":"17391","certified_preowned":false,"listing_id":"3138ebc3-c814-4994-ae3b-e08de3195512","fuel_type":"Gasoline","canonical_mmty":"Volkswagen:Tiguan:2.0T S:2024","badges":["great_deal"],"trim":"2.0T S","sponsored_type":"standard","relevancy_score":null,"make":"Volkswagen"},{"photo_count":36,"model":"XC60","canonical_mmt":"Volvo:XC60:B5 Core","dealer_name":"Mercedes-Benz of Columbia","stock_sub":"","cat":"luxurysuv_crossover","dealer_zip":"65203","vin":"YV4L12RVXP1265580","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2023","stock_type":"Used","price":"23980","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Charcoal","customer_id":"5243424","vertical_position":6,"nvi_program":false,"exterior_color":"Gray","sponsored":false,"mileage":"81421","certified_preowned":false,"listing_id":"7f668921-54fa-47c4-a22c-ee362ae6a18f","fuel_type":"Gasoline","canonical_mmty":"Volvo:XC60:B5 Core:2023","badges":["great_deal"],"trim":"B5 Core","sponsored_type":"standard","relevancy_score":null,"make":"Volvo"},{"photo_count":6,"model":"Tiguan","canonical_mmt":"Volkswagen:Tiguan:2.0T SE 4MOTION","dealer_name":"Joe Machens Volkswagen","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"3VV2B7AXXMM036693","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2021","stock_type":"Used","price":"14239","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Titan Black","customer_id":"5364038","vertical_position":7,"nvi_program":false,"exterior_color":"Pure White","sponsored":false,"mileage":"118897","certified_preowned":false,"listing_id":"d119ddac-3a8e-440c-b09a-89f2dae77555","fuel_type":"Gasoline","canonical_mmty":"Volkswagen:Tiguan:2.0T SE 4MOTION:2021","badges":["good_deal"],"trim":"2.0T SE 4MOTION","sponsored_type":"standard","relevancy_score":null,"make":"Volkswagen"},{"photo_count":17,"model":"Forester","canonical_mmt":"Subaru:Forester:Premium","dealer_name":"Subaru of Columbia","stock_sub":"","cat":"crossover_compact","dealer_zip":"65203","vin":"JF2SKACC1RH413608","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2024","stock_type":"Used","price":"22500","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Gray","customer_id":"6066303","vertical_position":8,"nvi_program":false,"exterior_color":"Horizon Blue","sponsored":false,"mileage":"86790","certified_preowned":false,"listing_id":"d5397c1d-f88b-4acf-91ad-093eac1ca4c2","fuel_type":"Gasoline","canonical_mmty":"Subaru:Forester:Premium:2024","badges":["good_deal","hot_car"],"trim":"Premium","sponsored_type":"standard","relevancy_score":null,"make":"Subaru"},{"photo_count":29,"model":"Envision","canonical_mmt":"Buick:Envision:FWD Essence","dealer_name":"Kia of Columbia","stock_sub":"","cat":"luxurysuv_crossover","dealer_zip":"65203","vin":"LRBFXCSAXLD228547","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2020","stock_type":"Used","price":"17499","bodystyle":"SUV","seller_type":"dealership","drivetrain":"Front-wheel Drive","interior_color":"Light Neutral w/Ebony Accents","customer_id":"5395269","vertical_position":9,"nvi_program":false,"exterior_color":"Summit White","sponsored":false,"mileage":"77230","certified_preowned":false,"listing_id":"c72ca932-7bee-4caf-ab10-24d6c56e68eb","fuel_type":"Gasoline","canonical_mmty":"Buick:Envision:FWD Essence:2020","badges":["price_drop_in_cents","good_deal"],"trim":"FWD Essence","sponsored_type":"standard","relevancy_score":null,"make":"Buick"},{"photo_count":46,"model":"Tiguan","canonical_mmt":"Volkswagen:Tiguan:2.0T SEL R-Line 4MOTION","dealer_name":"Joe Machens Toyota","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"3VV4B7AX5NM090932","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2022","stock_type":"Used","price":"17691","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Titan Black","customer_id":"5363961","vertical_position":10,"nvi_program":false,"exterior_color":"Deep Black Pearl","sponsored":false,"mileage":"127713","certified_preowned":false,"listing_id":"356e17c6-e480-442f-a3d2-4cff7c29bd9d","fuel_type":"Gasoline","canonical_mmty":"Volkswagen:Tiguan:2.0T SEL R-Line 4MOTION:2022","badges":["price_drop_in_cents","good_deal","hot_car"],"trim":"2.0T SEL R-Line 4MOTION","sponsored_type":"standard","relevancy_score":null,"make":"Volkswagen"},{"photo_count":11,"model":"Forester","canonical_mmt":"Subaru:Forester:Limited","dealer_name":"Columbia Honda","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"JF2SLDRC4SH536282","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2025","stock_type":"Used","price":"34000","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Black","customer_id":"5354599","vertical_position":11,"nvi_program":false,"exterior_color":"Magnetite Gray Metallic","sponsored":false,"mileage":"6976","certified_preowned":false,"listing_id":"85a7c5d2-03a9-40a3-b28c-eb7ba2bc8330","fuel_type":"Gasoline","canonical_mmty":"Subaru:Forester:Limited:2025","badges":["good_deal","hot_car"],"trim":"Limited","sponsored_type":"standard","relevancy_score":null,"make":"Subaru"},{"photo_count":46,"model":"Forester","canonical_mmt":"Subaru:Forester:Premium","dealer_name":"Joe Machens Volkswagen","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"JF2SKAEC5PH413654","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2023","stock_type":"Used","price":"24169","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Black","customer_id":"5364038","vertical_position":12,"nvi_program":false,"exterior_color":"Ice Silver Metallic","sponsored":false,"mileage":"58472","certified_preowned":false,"listing_id":"a2b4bed4-bc2c-4e15-92cb-634583cd06a1","fuel_type":"Gasoline","canonical_mmty":"Subaru:Forester:Premium:2023","badges":["good_deal"],"trim":"Premium","sponsored_type":"standard","relevancy_score":null,"make":"Subaru"},{"photo_count":52,"model":"X3","canonical_mmt":"BMW:X3:xDrive30i","dealer_name":"Joe Machens Volkswagen","stock_sub":"","cat":"luxurysuv_crossover","dealer_zip":"65202","vin":"5UX53DP02P9R43411","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2023","stock_type":"Used","price":"34947","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Cognac","customer_id":"5364038","vertical_position":13,"nvi_program":false,"exterior_color":"Skyscraper Gray Metallic","sponsored":false,"mileage":"28648","certified_preowned":false,"listing_id":"b181d1f1-27b0-4033-9211-67d9ebacf4a6","fuel_type":"Gasoline","canonical_mmty":"BMW:X3:xDrive30i:2023","badges":["price_drop_in_cents","good_deal"],"trim":"xDrive30i","sponsored_type":"standard","relevancy_score":null,"make":"BMW"},{"photo_count":45,"model":"CX-5","canonical_mmt":"Mazda:CX-5:Touring","dealer_name":"CDJR of Columbia","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"JM3KE2CY9G0684085","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2016","stock_type":"Used","price":"17800","bodystyle":"SUV","seller_type":"dealership","drivetrain":"Front-wheel Drive","interior_color":"Black","customer_id":"5363962","vertical_position":14,"nvi_program":false,"exterior_color":"Titanium Flash Mica","sponsored":false,"mileage":"35812","certified_preowned":false,"listing_id":"f12802e1-8c85-439b-be28-d57340d9c738","fuel_type":"Gasoline","canonical_mmty":"Mazda:CX-5:Touring:2016","badges":["price_drop_in_cents","good_deal","hot_car"],"trim":"Touring","sponsored_type":"standard","relevancy_score":null,"make":"Mazda"},{"photo_count":17,"model":"Rogue","canonical_mmt":"Nissan:Rogue:S","dealer_name":"CDJR of Columbia","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"KNMAT2MV2LP506941","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2020","stock_type":"Used","price":"9300","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Charcoal","customer_id":"5363962","vertical_position":15,"nvi_program":false,"exterior_color":"Caspian Blue Metallic","sponsored":false,"mileage":"168298","certified_preowned":false,"listing_id":"e50c6fdc-5b1e-4486-9d08-b616ba004848","fuel_type":"Gasoline","canonical_mmty":"Nissan:Rogue:S:2020","badges":["price_drop_in_cents","great_deal","hot_car"],"trim":"S","sponsored_type":"standard","relevancy_score":null,"make":"Nissan"},{"photo_count":18,"model":"Envision","canonical_mmt":"Buick:Envision:AWD Premium I","dealer_name":"CDJR of Columbia","stock_sub":"","cat":"luxurysuv_crossover","dealer_zip":"65202","vin":"LRBFX3SXXLD169469","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2020","stock_type":"Used","price":"23000","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Ebony w/Ebony Accents","customer_id":"5363962","vertical_position":16,"nvi_program":false,"exterior_color":"Satin Steel Metallic","sponsored":false,"mileage":"36741","certified_preowned":false,"listing_id":"bdd4ebba-98e0-4dba-9d6f-8194a31174ef","fuel_type":"Gasoline","canonical_mmty":"Buick:Envision:AWD Premium I:2020","badges":["good_deal"],"trim":"AWD Premium I","sponsored_type":"standard","relevancy_score":null,"make":"Buick"},{"photo_count":32,"model":"CX-5","canonical_mmt":"Mazda:CX-5:2.5 S Preferred Package","dealer_name":"Mazda of Columbia","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"JM3KFBCM7S0742004","cpo_indicator":false,"cpo_package":null,"msrp":null,"year":"2025","stock_type":"Used","price":"28200","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Black","customer_id":"5364156","vertical_position":17,"nvi_program":false,"exterior_color":"Soul Red Crystal Metallic","sponsored":false,"mileage":"424","certified_preowned":false,"listing_id":"7df8410a-cb5d-49f4-83af-5ef7f0a6f3f5","fuel_type":"Gasoline","canonical_mmty":"Mazda:CX-5:2.5 S Preferred Package:2025","badges":["price_drop_in_cents","good_deal"],"trim":"2.5 S Preferred Package","sponsored_type":"standard","relevancy_score":null,"make":"Mazda"},{"photo_count":36,"model":"X3","canonical_mmt":"BMW:X3:xDrive30i","dealer_name":"BMW of Columbia - MO","stock_sub":"","cat":"luxurysuv_crossover","dealer_zip":"65203","vin":"5UXTR9C59KLE17537","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2019","stock_type":"Used","price":"12905","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Oyster W/Contrast","customer_id":"152419","vertical_position":18,"nvi_program":false,"exterior_color":"Alpine White","sponsored":false,"mileage":"156540","certified_preowned":false,"listing_id":"2c08bab8-dc42-4104-9ac6-3ab345d4826e","fuel_type":"Gasoline","canonical_mmty":"BMW:X3:xDrive30i:2019","badges":["good_deal"],"trim":"xDrive30i","sponsored_type":"standard","relevancy_score":null,"make":"BMW"},{"photo_count":32,"model":"XT4","canonical_mmt":"Cadillac:XT4:Premium Luxury","dealer_name":"Kia of Columbia","stock_sub":"","cat":"luxurysuv_crossover","dealer_zip":"65203","vin":"1GYFZDR47RF152469","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2024","stock_type":"Used","price":"25290","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Black","customer_id":"5395269","vertical_position":19,"nvi_program":false,"exterior_color":"Silver Metallic","sponsored":false,"mileage":"57096","certified_preowned":false,"listing_id":"56dad41e-aaae-4dc6-89b6-f5079dcacf0b","fuel_type":"Gasoline","canonical_mmty":"Cadillac:XT4:Premium Luxury:2024","badges":["great_deal","american_made_index_ranking"],"trim":"Premium Luxury","sponsored_type":"standard","relevancy_score":null,"make":"Cadillac"},{"photo_count":11,"model":"Sportage","canonical_mmt":"Kia:Sportage:X-Line","dealer_name":"Columbia Honda","stock_sub":"","cat":"crossover_compact","dealer_zip":"65202","vin":"5XYK6CDF8RG232179","cpo_indicator":false,"cpo_package":null,"msrp":"0","year":"2024","stock_type":"Used","price":"27400","bodystyle":"SUV","seller_type":"dealership","drivetrain":"All-wheel Drive","interior_color":"Black","customer_id":"5354599","vertical_position":20,"nvi_program":false,"exterior_color":"Ebony Black","sponsored":false,"mileage":"25964","certified_preowned":false,"listing_id":"fb00fd4e-13ff-4bd0-a5bd-c85d881dfbfc","fuel_type":"Gasoline","canonical_mmty":"Kia:Sportage:X-Line:2024","badges":["good_deal","american_made_index_ranking"],"trim":"X-Line","sponsored_type":"standard","relevancy_score":null,"make":"Kia"}]}]