Skip to main content

Contact seller

Contact seller

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

We value your privacy. Cars.com Privacy Notice

Customize your budget

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

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

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

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

Used SUVs for sale near Boonville, MO

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
796 matches 30 miles from 65233
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: Black Metallic
Int. color: Black Onyx
Drivetrain: Four-wheel Drive
MPG: 16-22
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 3.5L V6 24V PDI DOHC Twin Turbo
Stock #: NEL12649
VIN: 5LMJJ2LT4NEL12649

Features

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

Vehicle information

Ext. color: Brilliant Silver Metallic
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 28-35
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 1.5L DOHC
Stock #: RC695588
VIN: 5N1BT3BB4RC695588

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

Reviews

Joe Machens Nissan review

Great people

Scott Glasgow was very helpful. He actually listened to our needs and provided solutions. He cares for his customers and we are glad to know him.

2024 Nissan Rogue SV review

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

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

Vehicle information

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

Features

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

Reviews

Columbia Honda review

Great Experience

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

2024 Toyota 4Runner SR5 review

I have yet to get this 2024 4runner TRD Pro stuck, and I

I have yet to get this 2024 4runner TRD Pro stuck, and I have tried. Love this thing. Its already made it across the country and back. Ive had it since April of 2024 and about to break 20k miles. Had water to the bumper and mud to the frame and this thing keeps on ticking wheels keep turnin.

Vehicle information

Ext. color: Red Diamond
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 24-29
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.4L I-4 MIVEC variable valve control, regular unleaded, engine
Stock #: MU8238
VIN: JA4AZ3A34LZ021240

Features

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

Reviews

Mercedes-Benz of Columbia review

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

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

2020 Mitsubishi Outlander SEL review

This Outlander is the best.

This Outlander is the best.It is better than a mercedes royal's rice and b m w. We love this vehicle! The handling is the best!

Vehicle information

Ext. color: White Frost Tricoat
Int. color: Alpine Umber
Drivetrain: Four-wheel Drive
MPG: 14-18
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoTec3 6.2L V-8 gasoline direct injection, variable valve contr
Stock #: M6031A
VIN: 1GKS2EKL6PR427877

Features

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

Reviews

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!

Vehicle information

Ext. color: Cinnabar Metallic
Int. color: Ebony Seats
Drivetrain: All-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: 9-Speed Automatic
Engine: 2.0L Turbocharged
Stock #: PD160627
VIN: LRBFZSR44PD160627

Features

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

Reviews

Joe Machens Nissan review

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 Buick Envision Avenir review

My only complaint is that I cannot seem to close the door

My only complaint is that I cannot seem to close the door mirrors. Small complaint and not really a flaw but cosmetic. The car is amazing. It has plenty of room and acceleration. It is comfortable and luxurious too.

Vehicle information

Ext. color: Pearl White Tricoat
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 #: PC903607
VIN: 5N1BT3BAXPC903607

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.

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: Soul Red Crystal Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.5L I4 16V GDI DOHC
Stock #: R0437849
VIN: JM3KFBBL0R0437849

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start
Entertainment: Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Reviews

Mazda of Columbia review

Angel Garrett

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

2024 Mazda CX-5 2.5 S Select Package review

This is my first CX-5.

This is my first CX-5. I love it. Previously I drove a mazda tribute which was a 6 cylinder. I was reluctant to purchase a smaller vehicle with a smaller engine, but I’ve been pleased. My only negative comment is regarding the leg room in the back seat. It’s not great but workable for most average size adults.

Vehicle information

Ext. color: Silver Mist Metallic
Int. color: Titan Black
Drivetrain: All-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, variable valve control,
Stock #: RC526160
VIN: 1V2HR2CA5RC526160

Features

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

Reviews

Joe Machens Volkswagen review

Better than EXCELLENT -- Not just a VW Dealer!

Mr Anthony Heaper was--is my salesman. We were doing wonderfully with a 2015 Silky Blue VW GOLF, and the car "sold" before I started to finalized my offer, and transportation situations. I live in Tulsa, and I have confidence we will buy our VW from Joe Machens via Mr. Anthony Heaper. Anthony is not pushy, very polite, and helpful. Only down side to buy from Joe, is I live in Tulsa. No way to take advantage of the LOCAL Dealership "FREEBIES." Believe the end price will make it all worth while. ~`~`~` PS: I have visited the local VW dealer, and they were not too friendly.

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

Only have it six months, bought it spur of the moment!

Only have it six months, bought it spur of the moment! my wife thought i was crazy! I owned Many cars and have a few now this is a good SUV 30 Thousand less than the Audi Q 7 but made the same , only inside and outside different.

Vehicle information

Ext. color: 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 #: RM194515
VIN: 3VVRB7AX0RM194515

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

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.

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: Ice Cap
Int. color: Black/Graphite
Drivetrain: Four-wheel Drive
MPG: 16-19
Fuel type: Gasoline
Transmission: Automatic
Engine: 4L V-6 DOHC, VVT-i variable valve control, regular unleaded, eng
Stock #: P6198511
VIN: JTERU5JR2P6198511

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Navigation System
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof, Tow Hitch, Tow Hooks
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.

2023 Toyota 4Runner TRD Off Road Premium review

Great looking, fun to drive 4x4, super reliable, leather

Great looking, fun to drive 4x4, super reliable, leather interior but strong enough for 2 dogs and 2 kids. Goes anywhere. Roof rack easy to use. HAs all the electronic helper (BSM, cross traffic alert, lane keeping, adaptive cruise). The downside is the gas milage. 16.5 to 18 mpg depending on time of year & type of gas (summer vs winter gas). No service issues in 45,000 miles but they did some fuel pump recall when I was in for an oil change

Vehicle information

Ext. color: Diamond Black
Int. color: Global Black
Drivetrain: Four-wheel Drive
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.6L V6 OHV
Stock #: R8542900
VIN: 1C4RJHAG8R8542900

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats

Reviews

Mazda of Columbia review

Joe Machens Mazda

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

2024 Jeep Grand Cherokee Laredo review

Have owned Jeeps for 35 years.

Have owned Jeeps for 35 years. This is the most comfortable ever. Altitude 4x2 L, V6, avg. 19-24 MPG. Tow up to 8,000. 6 passenger with 2 fold downs in back. Paid 34k with 18k miles

Vehicle information

Ext. color: 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 #: NC705555
VIN: 5N1BT3BB5NC705555

Features

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

Reviews

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: Brilliant Silver 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 #: RC696844
VIN: 5N1BT3BB1RC696844

Features

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

Reviews

Mazda of Columbia review

lartiquefreeman2206@yahoo.com

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

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: Jet Black Mica
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.5L I4 DOHC 16V LEV3 SULEV30 187hp
Stock #: R0439305
VIN: JM3KFBBL3R0439305

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

Joe Machens Nissan review

Scotty Glasgow is awesome!

Loved working with Scotty. He doesn't pressure you into making a quick decision; he gives you plenty of information on the positives and negatives of different models; and best of all he is a genuinely nice guy. I definitely recommend him!

2024 Mazda CX-5 2.5 S Select Package review

I absolutely love my 2024 CX5 Preferred.

I absolutely love my 2024 CX5 Preferred. It's my first SUV and my first Mazda (after 3 Cutlasses, 2 BMW's, an Audi, an Acura, and 4 Lexus sedans) and I couldn't be happier. The interior is luxurious, the ride is powerful yet smooth and quiet (equal to Lexus) and the handling is great. I test drove a RAV4 and a CRV and there was no comparison. It's fun to drive and I recommend it whole-heartedly.

Vehicle information

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

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

2024 Kia Sorento S review

I've own a 2024 Kia Sorento SX Prestige for two months

I've own a 2024 Kia Sorento SX Prestige for two months and have been completely satisfied with it. It has more then enough power. For those who have an issue with the dual clutch transmission, should understand that it is a computer controlled manual transmission. It will respond a bit differently then a conventional torque converter type. Some have said it doesn't shift smoothly at lower speeds but I personally have had no issues. I live in Pittsburgh Pa, which has a hilly terrain and bad roads and no problems so far. Stop and go traffic has been a none issue. Very smooth shifting transmission! The ride quality is very good. A little on the firmer side, but it takes large bumps well. Seats are comfortable and the interior has a premium feel. I've own a 2019 Honda Pilot Touring and in my opinion, the Sorento is better in every way except for the room in the rear. And where it excels is in the features it offers! It's much better equipped than Pilot at a less expensive price. It has so far been the best car I've own in my fifty years of buying cars! Everything works! Sorento has been one of Kia's more reliable vehicles. I highly highly recommend!

Vehicle information

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

Features

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

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

2024 Subaru Outback Premium review

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

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

Vehicle information

Ext. color: Twilight Black
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 22-25
Fuel type: Gasoline
Transmission: Automatic
Engine: Smartstream 2.5L I-4 port/direct injection, DOHC, CVVT variable
Stock #: PH594097
VIN: 5NMS2DAJ0PH594097

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: Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control

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.

2023 Hyundai SANTA FE SEL 2.4 review

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

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

Vehicle information

Ext. color: White Pearl
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 22-28
Fuel type: Gasoline
Transmission: 8-Speed Automatic with Auto-Shift
Engine: 2.5L I4 16V PDI DOHC Turbo
Stock #: PH526367
VIN: 5NMS44ALXPH526367

Features

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

Reviews

Mazda of Columbia review

2023 Mitsubishi PHEV ?Outstanding Vehicles?!

2023 Mitsubishi PHEV - ?Best Vehicle We have ever owned?!!

2023 Hyundai SANTA FE Limited review

I have a 2023 Hyundai Santa Fe 2.

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

Vehicle information

Ext. color: Crystal White Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 26-32
Fuel type: Gasoline
Transmission: CVT Lineartronic
Engine: 2.5L 4-Cylinder DOHC 16V
Stock #: S3191916
VIN: 4S4BTADC6S3191916

Features

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

Reviews

Joe Machens Nissan review

JM Nissan Rocks

Adam was super friendly and helpful. Shawn and Mike were also helpful. Thank you so much!! I love my car. Thank for giving us several great vehicles to choose from. I am sure we'll be back for a next vehicle down the road.

2025 Subaru Outback Premium review

Last November I drove my 2018 Outback Premium (which I

Last November I drove my 2018 Outback Premium (which I loved) to the local dealer to test drive a 2025 Limited XT and get the complimentary $50 Visa card they were promoting at the time, and ended up driving back in the new XT. Following are my impressions after 10 months of ownership. We're big fans of Subaru's safety tech. My wife's car is a 2023 Forester, and the Reverse Automatic Braking has saved her from at least one accident. Her previous car was a 2021 Hyundai Tucson, and its reverse sensors seemed like they never worked. If safety is a priority, you won't find many manufacturers that beat Subaru (same for their all wheel drive system). The newer generation EyeSight system is superior to the 2018's. I would commonly turn off the Pre-Collision Braking on the 2018 (which was easy with the physical switch unlike the virtual switch accessible only through the head unit on the 2025) since I found it to be oversensitive when I was following someone making a right turn. The 2018 would prematurely brake which I feared could lead to being rear ended. My 2025 does not have the same issue, and while it has given me a blinking/beeping warning in the dash display in similar situations, it has not started actually braking like the 2018. For me, I have found I only get warnings from the car when my driving actually warrants it. The extra power of the 2.4L turbo (XT) was a big selling point, although I feel it's not mated to the CVT as well as the non-turbo 2.5L. There is noticeable throttle lag with the XT which you have to get used to, but man, it really moves after that momentary lag. I never found my 2018 non-turbo to be underpowered, but I definitely love the extra punch of the turbo. One of my biggest hesitancies with the 2025 was all the touchscreen buttons/menus of the head unit, but the joy of driving the car has softened my annoyance. Since I don't feel the need to shut off any safety features, I never have to look for them in the head unit menus. When I start the car, I only turn off the auto start/stop with the dedicated button at the bottom of the screen and wait the usual 20-30 seconds for the head unit to fully boot up giving the turbo/engine time to get lubricated before I put her into drive. I'm a big fan of wireless Android Auto and have found it to be very stable (and much better than the wireless dongles I tried with the 2018). I use the automatic climate control 99% of the time, so I don't miss the physical buttons and knobs in the dash (all I need are temperature up/down which ARE physical buttons). It's a great cruising vehicle with a great ride, and I look forward to packing the family inside for extended road trips. I'm happy we have the last year of the "wagon" generation of Outbacks and plan to keep it for many enjoyable miles.

About SUVs

FAQs

What is the cheapest SUV available?

The Dodge Journey is the cheapest available SUV by average Cars.com listing price, with an average listing price of $10,377.

Which SUV has the best MPG?

The Lexus UX 200 has the best MPG among traditional internal combustion SUVs and offers up to 29 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 IQ has the longest range among SUVs and can travel up to 450 miles on a single charge depending on electric motor and battery options.

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

Which automaker has the most SUV deals?

Jeep has the most available SUV deals on Cars.com with 17045 great deals out of 58565 listings starting at $1.

Where can I find the most SUV deals?

The most SUV deals can be found near Columbia, MO with 330 great deals out of 1220 listings starting at $5,999.

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

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

796 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

Used SUVs by city

SUVs in Boonville, MO by make

Find great prices on used SUVs in Boonville, MO

SUVs in Boonville, MO by size

[{"applied_filter_criteria":"{\"bodystyle\":[\"suv\"],\"cpo_indicator\":false,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"cpo_package":null,"canonical_mmt":"Lincoln:Navigator:Reserve","dealer_zip":"65203","stock_sub":"","vertical_position":1,"exterior_color":"Black Metallic","nvi_program":false,"listing_id":"5e7e5511-6a03-48b4-ae1f-f0e56f21ffb0","trim":"Reserve","vin":"5LMJJ2LT4NEL12649","mileage":"28966","drivetrain":"Four-wheel Drive","year":"2022","fuel_type":"Gasoline","badges":["great_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"6039707","stock_type":"Used","canonical_mmty":"Lincoln:Navigator:Reserve:2022","relevancy_score":null,"dealer_name":"Joe Machens Ford","interior_color":"Black Onyx","seller_type":"dealership","photo_count":30,"model":"Navigator","price":"57098","bodystyle":"SUV","make":"Lincoln","msrp":null,"certified_preowned":false,"cpo_indicator":false,"cat":"luxurysuv_suv"},{"cpo_package":"Nissan","canonical_mmt":"Nissan:Rogue:SV","dealer_zip":"65203","stock_sub":"","vertical_position":2,"exterior_color":"Brilliant Silver Metallic","nvi_program":false,"listing_id":"c0119ccd-553b-4f60-958f-cc656f5b36ba","trim":"SV","vin":"5N1BT3BB4RC695588","mileage":"55573","drivetrain":"All-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","great_deal","american_made_index_ranking","cpo"],"sponsored":true,"sponsored_type":"standard","customer_id":"5363960","stock_type":"Used","canonical_mmty":"Nissan:Rogue:SV:2024","relevancy_score":null,"dealer_name":"Joe Machens Nissan","interior_color":"Charcoal","seller_type":"dealership","photo_count":27,"model":"Rogue","price":"21871","bodystyle":"SUV","make":"Nissan","msrp":"0","certified_preowned":true,"cpo_indicator":true,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"Toyota:4Runner:SR5","dealer_zip":"65202","stock_sub":"","vertical_position":3,"exterior_color":"Classic Silver Metallic","nvi_program":false,"listing_id":"b9636f83-dde0-42c4-9944-7fa5e370784e","trim":"SR5","vin":"JTEMU5JR8R6287562","mileage":"33116","drivetrain":"Four-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5354599","stock_type":"Used","canonical_mmty":"Toyota:4Runner:SR5:2024","relevancy_score":null,"dealer_name":"Columbia Honda","interior_color":"Black/Graphite","seller_type":"dealership","photo_count":32,"model":"4Runner","price":"36500","bodystyle":"SUV","make":"Toyota","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"suv_midsize"},{"cpo_package":null,"canonical_mmt":"Mitsubishi:Outlander:SEL","dealer_zip":"65203","stock_sub":"","vertical_position":4,"exterior_color":"Red Diamond","nvi_program":false,"listing_id":"bf3da2d7-b1b2-4b77-b0c6-b98fcd9e0234","trim":"SEL","vin":"JA4AZ3A34LZ021240","mileage":"93861","drivetrain":"Four-wheel Drive","year":"2020","fuel_type":"Gasoline","badges":["good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5243424","stock_type":"Used","canonical_mmty":"Mitsubishi:Outlander:SEL:2020","relevancy_score":null,"dealer_name":"Mercedes-Benz of Columbia","interior_color":"Black","seller_type":"dealership","photo_count":34,"model":"Outlander","price":"15455","bodystyle":"SUV","make":"Mitsubishi","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"GMC:Yukon:Denali Ultimate","dealer_zip":"65203","stock_sub":"","vertical_position":5,"exterior_color":"White Frost Tricoat","nvi_program":false,"listing_id":"797824fc-93a7-4219-809f-75e8b6c5ef88","trim":"Denali Ultimate","vin":"1GKS2EKL6PR427877","mileage":"16707","drivetrain":"Four-wheel Drive","year":"2023","fuel_type":"Gasoline","badges":["good_deal","hot_car"],"sponsored":false,"sponsored_type":"standard","customer_id":"5243424","stock_type":"Used","canonical_mmty":"GMC:Yukon:Denali Ultimate:2023","relevancy_score":null,"dealer_name":"Mercedes-Benz of Columbia","interior_color":"Alpine Umber","seller_type":"dealership","photo_count":39,"model":"Yukon","price":"78589","bodystyle":"SUV","make":"GMC","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"suv_fullsize"},{"cpo_package":null,"canonical_mmt":"Buick:Envision:Avenir","dealer_zip":"65203","stock_sub":"","vertical_position":6,"exterior_color":"Cinnabar Metallic","nvi_program":false,"listing_id":"beac5b42-e865-47f7-b62d-50c507c12891","trim":"Avenir","vin":"LRBFZSR44PD160627","mileage":"19728","drivetrain":"All-wheel Drive","year":"2023","fuel_type":"Gasoline","badges":["price_drop_in_cents","good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5363960","stock_type":"Used","canonical_mmty":"Buick:Envision:Avenir:2023","relevancy_score":null,"dealer_name":"Joe Machens Nissan","interior_color":"Ebony Seats","seller_type":"dealership","photo_count":28,"model":"Envision","price":"33723","bodystyle":"SUV","make":"Buick","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"luxurysuv_crossover"},{"cpo_package":null,"canonical_mmt":"Nissan:Rogue:SV","dealer_zip":"65202","stock_sub":"","vertical_position":7,"exterior_color":"Pearl White Tricoat","nvi_program":false,"listing_id":"855b9deb-0491-40e7-9717-e8772cf61163","trim":"SV","vin":"5N1BT3BAXPC903607","mileage":"58750","drivetrain":"Front-wheel Drive","year":"2023","fuel_type":"Gasoline","badges":["good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5354599","stock_type":"Used","canonical_mmty":"Nissan:Rogue:SV:2023","relevancy_score":null,"dealer_name":"Columbia Honda","interior_color":"Charcoal","seller_type":"dealership","photo_count":34,"model":"Rogue","price":"18700","bodystyle":"SUV","make":"Nissan","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"Mazda:CX-5:2.5 S Select Package","dealer_zip":"65202","stock_sub":"","vertical_position":8,"exterior_color":"Soul Red Crystal Metallic","nvi_program":false,"listing_id":"2afdf3db-d5dd-4c00-8ae5-fbdb3a3d6d58","trim":"2.5 S Select Package","vin":"JM3KFBBL0R0437849","mileage":"43500","drivetrain":"All-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364156","stock_type":"Used","canonical_mmty":"Mazda:CX-5:2.5 S Select Package:2024","relevancy_score":null,"dealer_name":"Mazda of Columbia","interior_color":"Black","seller_type":"dealership","photo_count":27,"model":"CX-5","price":"23700","bodystyle":"SUV","make":"Mazda","msrp":null,"certified_preowned":false,"cpo_indicator":false,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION","dealer_zip":"65202","stock_sub":"","vertical_position":9,"exterior_color":"Silver Mist Metallic","nvi_program":false,"listing_id":"cd29c564-dbbc-471f-aa10-d248e1dc5371","trim":"2.0T SE w/Technology 4MOTION","vin":"1V2HR2CA5RC526160","mileage":"47685","drivetrain":"All-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","fair_deal","american_made_index_ranking"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364038","stock_type":"Used","canonical_mmty":"Volkswagen:Atlas:2.0T SE w/Technology 4MOTION:2024","relevancy_score":null,"dealer_name":"Joe Machens Volkswagen","interior_color":"Titan Black","seller_type":"dealership","photo_count":6,"model":"Atlas","price":"30696","bodystyle":"SUV","make":"Volkswagen","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"crossover_midsize"},{"cpo_package":null,"canonical_mmt":"Volkswagen:Tiguan:2.0T S","dealer_zip":"65202","stock_sub":"","vertical_position":10,"exterior_color":"Pure White","nvi_program":false,"listing_id":"902abfaf-e883-46b3-bb53-4ed289d4032f","trim":"2.0T S","vin":"3VVRB7AX0RM194515","mileage":"18960","drivetrain":"Front-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364038","stock_type":"Used","canonical_mmty":"Volkswagen:Tiguan:2.0T S:2024","relevancy_score":null,"dealer_name":"Joe Machens Volkswagen","interior_color":"Titan Black","seller_type":"dealership","photo_count":49,"model":"Tiguan","price":"22572","bodystyle":"SUV","make":"Volkswagen","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"Toyota:4Runner:TRD Off Road Premium","dealer_zip":"65202","stock_sub":"","vertical_position":11,"exterior_color":"Ice Cap","nvi_program":false,"listing_id":"7915ea6c-bdf2-40da-a6ab-0e21db4f02e7","trim":"TRD Off Road Premium","vin":"JTERU5JR2P6198511","mileage":"33261","drivetrain":"Four-wheel Drive","year":"2023","fuel_type":"Gasoline","badges":["great_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364038","stock_type":"Used","canonical_mmty":"Toyota:4Runner:TRD Off Road Premium:2023","relevancy_score":null,"dealer_name":"Joe Machens Volkswagen","interior_color":"Black/Graphite","seller_type":"dealership","photo_count":6,"model":"4Runner","price":"45973","bodystyle":"SUV","make":"Toyota","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"suv_midsize"},{"cpo_package":null,"canonical_mmt":"Jeep:Grand Cherokee:Laredo","dealer_zip":"65202","stock_sub":"","vertical_position":12,"exterior_color":"Diamond Black","nvi_program":false,"listing_id":"4d542e61-97c6-44fd-b6f1-0d0a1460df47","trim":"Laredo","vin":"1C4RJHAG8R8542900","mileage":"34094","drivetrain":"Four-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","fair_deal","american_made_index_ranking"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364156","stock_type":"Used","canonical_mmty":"Jeep:Grand Cherokee:Laredo:2024","relevancy_score":null,"dealer_name":"Mazda of Columbia","interior_color":"Global Black","seller_type":"dealership","photo_count":27,"model":"Grand Cherokee","price":"30900","bodystyle":"SUV","make":"Jeep","msrp":null,"certified_preowned":false,"cpo_indicator":false,"cat":"suv_midsize"},{"cpo_package":null,"canonical_mmt":"Nissan:Rogue:SV","dealer_zip":"65203","stock_sub":"","vertical_position":13,"exterior_color":"Gun Metallic","nvi_program":false,"listing_id":"f59ade72-b460-4ba0-892e-370ca58acb57","trim":"SV","vin":"5N1BT3BB5NC705555","mileage":"54447","drivetrain":"All-wheel Drive","year":"2022","fuel_type":"Gasoline","badges":["good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"6039707","stock_type":"Used","canonical_mmty":"Nissan:Rogue:SV:2022","relevancy_score":null,"dealer_name":"Joe Machens Ford","interior_color":"Charcoal","seller_type":"dealership","photo_count":30,"model":"Rogue","price":"20809","bodystyle":"SUV","make":"Nissan","msrp":null,"certified_preowned":false,"cpo_indicator":false,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"Nissan:Rogue:SV","dealer_zip":"65202","stock_sub":"","vertical_position":14,"exterior_color":"Brilliant Silver Metallic","nvi_program":false,"listing_id":"6e4d355e-cbc0-4beb-b275-0abc96550f5f","trim":"SV","vin":"5N1BT3BB1RC696844","mileage":"43392","drivetrain":"All-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","great_deal","american_made_index_ranking"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364156","stock_type":"Used","canonical_mmty":"Nissan:Rogue:SV:2024","relevancy_score":null,"dealer_name":"Mazda of Columbia","interior_color":"Charcoal","seller_type":"dealership","photo_count":31,"model":"Rogue","price":"22100","bodystyle":"SUV","make":"Nissan","msrp":null,"certified_preowned":false,"cpo_indicator":false,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"Mazda:CX-5:2.5 S Select Package","dealer_zip":"65203","stock_sub":"","vertical_position":15,"exterior_color":"Jet Black Mica","nvi_program":false,"listing_id":"8dc40e08-13ec-41eb-8c3b-262fbff7ec20","trim":"2.5 S Select Package","vin":"JM3KFBBL3R0439305","mileage":"48351","drivetrain":"All-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5363960","stock_type":"Used","canonical_mmty":"Mazda:CX-5:2.5 S Select Package:2024","relevancy_score":null,"dealer_name":"Joe Machens Nissan","interior_color":"Black","seller_type":"dealership","photo_count":29,"model":"CX-5","price":"23199","bodystyle":"SUV","make":"Mazda","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"crossover_compact"},{"cpo_package":null,"canonical_mmt":"Kia:Sorento:S","dealer_zip":"65202","stock_sub":"","vertical_position":16,"exterior_color":"Gravity Grey","nvi_program":false,"listing_id":"07a392f3-3f9a-40e7-8cbf-03b4e53dff01","trim":"S","vin":"5XYRLDJC1RG290903","mileage":"36193","drivetrain":"All-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"sponsored":false,"sponsored_type":"standard","customer_id":"5354599","stock_type":"Used","canonical_mmty":"Kia:Sorento:S:2024","relevancy_score":null,"dealer_name":"Columbia Honda","interior_color":"Black","seller_type":"dealership","photo_count":33,"model":"Sorento","price":"27300","bodystyle":"SUV","make":"Kia","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"crossover_midsize"},{"cpo_package":null,"canonical_mmt":"Subaru:Outback:Premium","dealer_zip":"65202","stock_sub":"","vertical_position":17,"exterior_color":"Brilliant Bronze Metallic","nvi_program":false,"listing_id":"4f533e1a-66b4-4956-ab48-719e9826e6cb","trim":"Premium","vin":"4S4BTADC2R3146594","mileage":"90719","drivetrain":"All-wheel Drive","year":"2024","fuel_type":"Gasoline","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364156","stock_type":"Used","canonical_mmty":"Subaru:Outback:Premium:2024","relevancy_score":null,"dealer_name":"Mazda of Columbia","interior_color":"Black","seller_type":"dealership","photo_count":27,"model":"Outback","price":"21500","bodystyle":"SUV","make":"Subaru","msrp":null,"certified_preowned":false,"cpo_indicator":false,"cat":"wagonhatchback_wagon"},{"cpo_package":null,"canonical_mmt":"Hyundai:SANTA FE:SEL 2.4","dealer_zip":"65202","stock_sub":"","vertical_position":18,"exterior_color":"Twilight Black","nvi_program":false,"listing_id":"225398fd-8886-4b0e-89bc-41c45d90f623","trim":"SEL 2.4","vin":"5NMS2DAJ0PH594097","mileage":"47215","drivetrain":"All-wheel Drive","year":"2023","fuel_type":"Gasoline","badges":["great_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5354599","stock_type":"Used","canonical_mmty":"Hyundai:SANTA FE:SEL 2.4:2023","relevancy_score":null,"dealer_name":"Columbia Honda","interior_color":"Gray","seller_type":"dealership","photo_count":32,"model":"SANTA FE","price":"21000","bodystyle":"SUV","make":"Hyundai","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"crossover_midsize"},{"cpo_package":null,"canonical_mmt":"Hyundai:SANTA FE:Limited","dealer_zip":"65202","stock_sub":"","vertical_position":19,"exterior_color":"White Pearl","nvi_program":false,"listing_id":"910f8bd7-87bf-4ef1-9c4a-2ac6df95eda5","trim":"Limited","vin":"5NMS44ALXPH526367","mileage":"70257","drivetrain":"Front-wheel Drive","year":"2023","fuel_type":"Gasoline","badges":["price_drop_in_cents","good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5364156","stock_type":"Used","canonical_mmty":"Hyundai:SANTA FE:Limited:2023","relevancy_score":null,"dealer_name":"Mazda of Columbia","interior_color":"Black","seller_type":"dealership","photo_count":28,"model":"SANTA FE","price":"22300","bodystyle":"SUV","make":"Hyundai","msrp":null,"certified_preowned":false,"cpo_indicator":false,"cat":"crossover_midsize"},{"cpo_package":null,"canonical_mmt":"Subaru:Outback:Premium","dealer_zip":"65203","stock_sub":"","vertical_position":20,"exterior_color":"Crystal White Pearl","nvi_program":false,"listing_id":"6917a636-7667-4beb-a1ff-ffa9f99ee8a0","trim":"Premium","vin":"4S4BTADC6S3191916","mileage":"9093","drivetrain":"All-wheel Drive","year":"2025","fuel_type":"Gasoline","badges":["good_deal"],"sponsored":false,"sponsored_type":"standard","customer_id":"5363960","stock_type":"Used","canonical_mmty":"Subaru:Outback:Premium:2025","relevancy_score":null,"dealer_name":"Joe Machens Nissan","interior_color":"Black","seller_type":"dealership","photo_count":27,"model":"Outback","price":"29006","bodystyle":"SUV","make":"Subaru","msrp":"0","certified_preowned":false,"cpo_indicator":false,"cat":"wagonhatchback_wagon"}]}]