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 cars for sale near Sturgeon, MO under $299,914

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
1,489 matches 30 miles from 65284
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: Horizon Blue Pearl
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.5L H4 16V GDI DOHC
Stock #: PH412545
VIN: JF2SKAPCXPH412545

Features

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

Reviews

Mazda of Columbia review

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!

2023 Subaru Forester Limited review

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

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

Vehicle information

Ext. color: Slate Gray Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 17-20
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.7L I4 Turbocharged DOHC 16V LEV3-SULEV30 310hp
Stock #: SZ194978
VIN: 1GCPKBEK2SZ194978

Features

Convenience: Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, Premium Sound System, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, 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.

2025 Chevrolet Silverado 1500 Custom review

Love this car.

Love this car. I wish there was more to the interior though, as it is pretty plain and nothing extraordinary. If they had the bigger infotainment screen for the front bench seat it would have a gotten that one. This car over all is great bang for the buck.

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

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 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: Platinum White Pearl
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 29-37
Fuel type: Gasoline
Transmission: Automatic
Engine: 1.5L I-4 gasoline direct injection, DOHC, i-VTEC variable valve
Stock #: RA045523
VIN: 1HGCY1F35RA045523

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

Reviews

Columbia Honda review

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 Honda Accord EX 1.5T review

Got this car as part of a trade with my 2013 Chevy

Got this car as part of a trade with my 2013 Chevy Malibu. It's not a bad car did have a few issues with the spark plugs that came out of nowhere. And they had to be replaced along with a few other issues but outside of that it's been a pretty reliable car that has gotten me from point a to point b. Everything works well the Bluetooth has worked wonders along with the seats being comfortable and it drives smooth.

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

Joe Machens Mazda

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

2024 Subaru Outback Premium review

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

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

Vehicle information

Ext. color: Still Night Pearl
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 29-35
Fuel type: Gasoline
Transmission: Automatic
Engine: 1.5L I-4 gasoline direct injection, DOHC, i-VTEC variable valve
Stock #: NA115860
VIN: 1HGCV1F47NA115860

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control
Seating: Leather Seats

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 Honda Accord Sport SE 1.5T review

This is a solid comfortable car nearing luxury status.

This is a solid comfortable car nearing luxury status. My only concern is the infotainment system freezing at times and ignition loses connection with the FOB every once in awhile.

Vehicle information

Ext. color: Iridium Silver Metallic
Int. color: Ash / Dark Gray
Drivetrain: Rear-wheel Drive
MPG: 17-24
Fuel type: Gasoline
Transmission: 7-Speed Automatic
Engine: 3.5L V6 24V MPFI DOHC
Stock #: BA307172
VIN: WDDHF5GB5BA307172

Features

Convenience: Heated Seats, Keyless Entry, Navigation System
Entertainment: Bluetooth®, CD Player, DVD Player, HomeLink, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Brake Assist, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Mazda of Columbia review

lartiquefreeman2206@yahoo.com

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

2011 Mercedes-Benz E-Class E 350 review

HAD TO HAVE ANOTHER

I mistakenly sold my 2012 E350 in 2023 thinking I should upgrade to an SUV. I regretted selling the wagon, though the 2020 MB GLB was a very nice vehicle. So I found a 2011 E350 wagon and couldn't been happier. Maintenance is key, yes. But the leather (not MBTex) wears very well, and the exterior is flawless.

Vehicle information

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

Features

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

Reviews

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

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: Everest White Pearl
Int. color: Light Gray
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 #: RW424285
VIN: JN8BT3BB3RW424285

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

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 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: Agate Black Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 17-23
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 3.5L V-6 port/direct injection, DOHC, Ti-VCT variable v
Stock #: MU8165
VIN: 1FTFW1E87PKF66524

Features

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

Reviews

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.

2023 Ford F-150 Lariat review

A little choppy on dirt roads, feel the uneven paved

A little choppy on dirt roads, feel the uneven paved road surfaces. I attribute this to the 4X4 suspension. Excellent payload , 1865 lbs.for the non-turbo 3.3 liter which has been stellar performer in 35K miles. I average 24mpg all weather. Very good drive modes, sport kicks it up to V8 feel, shift on the fly seamless. Handles great with loads 1000 lbs. plus. Hot riding vinyl seats are sport like hugging you, difficult to turn around to look out the back window. I don't rely solely on back up camera because it does hide the corners where pedestrians are. Confining driving position barely allows for my 6 foot frame. Seats belong in a sports car, not a truck! I should have got the cloth seats! The cab lacks much space behind seats for a small cooler of water or duffel bag. The transmission was clunky in the first 4 months. I think it was the computer adjusting for driving habits. The 12" touch screen has many features and can be turned off. Integrated phone is easy set up, Personal music can be played or built in music apps. The maps are great showing satellite view and North South configuration based on direction view. Service often freezes when you get in valleys. The worst feature is vehicle manual on computer, takes 10x longer to find what you are looking for. Ask Ford to order a printed booklet! The instrument panel is well laid out however the steering wheel sometimes obstructs information. The tilt, telescope wheel is perfect for shorter drivers. There are many cluster views to choose from and two trip odometers, a big plus. I choose one layout for all driving. Took a long time to get used to where radio controls are as I was always turning down the blower motor switch. Blower motor has 8 speeds and whisper quiet up to 5. Also has an ac booster for quick cab cooling, heat, nice! The stereo has equalizer, 4 speakers and will blow out your ear drums unless you have deafness. I find the adjustments for instrument brightness, headlights, fog, and bed lights to be very awkward, An afterthought by Ford engineers? Placed at lower left below segregated instrument layout. Needs to be easily visible, not hidden from view and adjustment. The high beams light up the next county and 50 feet up the treeline. Not sure I need to see owls in the trees, but I can. The flash to pass feature needs to be more blinks, changing lanes that fast is dangerous. The windshield is large and raked offering a full road view and pillars don't obstruct the roadway. The rear view camera can be used while driving and shows tailgaters. The rear window has defrost, tint. The tint is great but defrost is imo a dumb idea. Window easily defrosts with heat or defogs with ac. This isn't a car! I chose Ford over competition because my last F150 gave me 400K, never left me stranded, had a great V6, super good tranny and decent fuel mileage. I like the payload, handling, maps and my music from my apps. I like the aluminum clad where my last steel truck started rusting everywhere. The weight is nimble feel while driving, almost sporty on twisty roadways with very good acceleration and quicker stopping. The cost of ownership is less than foreign and many domestic. I have no recalls in 2 years. I drive in snow often, the handling and my confidence level are excellent but I still have weight in the bed for traction since this is 700 lbs. lighter than my 2013. Overall, I like this vehicle very much and look forward to a new one, better designed or upgraded 2028.

Vehicle information

Ext. color: White Metallic
Int. color: Sandstone
Drivetrain: All-wheel Drive
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 3L V-6 gasoline direct injection, DOHC, variable valve
Stock #: MU8156
VIN: 5LMYJ8XY5PNL00309

Features

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

2023 Lincoln Aviator Black Label Grand Touring AWD review

Check the options

We bought the standard model and now wish we had gone up to the Reserve level as some of the luxury options that we assumed came with the Lincoln name were missing.

Vehicle information

Ext. color: Black Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 3.5L V6 24V PDI DOHC Twin Turbo
Stock #: MFA23238
VIN: 1FTFW1E83MFA23238

Features

Convenience: Adaptive Cruise Control, Heated Seats, Heated Steering Wheel, Keyless Entry, Navigation System
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof, Tow Hitch
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, Lane Departure Warning, Stability Control
Seating: Memory Seat

Reviews

2021 Ford F-150 Lariat review

Great truck, I have no issues with this truck.

Great truck, I have no issues with this truck. Occasionally the Snyc screen freezes up. Acceleration is excellent. Highway MPG is 23 Local is around 12 mpg. Mixed City Highway is 15 mpg

Vehicle information

Ext. color: Super Black Clearcoat
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 27-39
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 2.5L 4-Cylinder DOHC 16V
Stock #: SN326394
VIN: 1N4BL4BV4SN326394

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port, WiFi Hotspot
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

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!

2025 Nissan Altima 2.5 S review

I've owned 7 total with 0 issues.

I've owned 7 total with 0 issues. The cvt is quick and responsive. The exhaust has a nice tone to it. Seats are comfortable I've owned German luxury cars and I prefer the Altima seats. I love my car.

Vehicle information

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

Features

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

Reviews

Mazda of Columbia review

Upgraded review from 10/10

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

2023 Nissan Rogue SL review

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: Gray Metallic
Int. color: Slate 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 #: MU8168A
VIN: 4S4BTAFC9N3156305

Features

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

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.

2022 Subaru Outback Premium review

Got a '22 Touring XT.

Got a '22 Touring XT. I knew the base engine was pathetic so I wanted the turbo. Gladly sacrifice some MPG for way more power. They shouldn't even offer the base engine on this car. Anyway, after 44k miles it's running like a champ. Absolutely no issues with the electronics (a few minor glitches here and there but nothing to take to the dealer for), CVT is fine, engine is fine, the AWD is second to none! Plowed right through a 15" blizzard through Kansas City like it was nothing. My biggest gripe are the squeaks and rattles. Highly annoying. My '17 Chevy Colorado with 64k miles is tighter and quieter. Cargo space is top notch, I have a bad back so getting in and out of a taller vehicle is much easier. But there is just too much tech and driver assistance, Subaru needs to tone it down a little. I still prefer to actually DRIVE my car, not have the car drive me. Overall I'm still happy with it.

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: Super White
Int. color: Cement
Drivetrain: Four-wheel Drive
MPG: 18-22
Fuel type: Gasoline
Transmission: Automatic
Engine: 3.5L V-6 port/direct injection, DOHC, variable valve control, re
Stock #: MM397376
VIN: 3TMCZ5AN3MM397376

Features

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

Reviews

Joe Machens Volkswagen review

GREAT SERVICE!

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

2021 Toyota Tacoma TRD Off Road review

My 2010 had 317,000 miles when I bought my 2021.

My 2010 had 317,000 miles when I bought my 2021. I absolutely love the changes that toyota has made. My 2021 is a perfect truck for comfort and reliability.

Vehicle information

Ext. color: Polymetal Gray Metallic
Int. color: Red
Drivetrain: All-wheel Drive
MPG: 23-29
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 2.5L I4 16V GDI DOHC
Stock #: R0465026
VIN: JM3KFBCLXR0465026

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, 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

2023 Mitsubishi PHEV ?Outstanding Vehicles?!

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

2024 Mazda CX-5 2.5 S Carbon Edition 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: Garnet Pearl Metallic
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 27-39
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 gasoline direct injection, DOHC, CVTCS variable valve c
Stock #: PN375238
VIN: 1N4BL4DV9PN375238

Features

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

Reviews

Joe Machens 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 Nissan Altima 2.5 SV review

Aesthetically pleasing.

Aesthetically pleasing. Awesome fuel economy!!! Handles well. I used to drive a 2018 Altima SV until a deer decided that i needed to purchase a new vehicle, otherwise, I'd still be driving that one which was totaled at 227k+ miles...190k+ miles by me (personally) in 4 and a half yrs. The front seats feel slightly smaller though....maybe it's just me.

Vehicle information

Ext. color: Race Red
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 18-23
Fuel type: Gasoline
Transmission: Automatic
Engine: EcoBoost 2.7L V-6 port/direct injection, DOHC, Ti-VCT variable v
Stock #: LKE72787
VIN: 1FTEW1EP0LKE72787

Features

Convenience: Keyless Entry, Remote Start
Entertainment: Bluetooth®, WiFi Hotspot
Exterior: Alloy Wheels, Tow Hitch, Tow Hooks
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, 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.

2020 Ford F-150 XL review

Great vehicle!!

I was searching for a specific vehicle and I found a few on cars.com. 2020 F-150 Super Cab 2.7L Ecoboost, 10 speed transmission. At first I was concerned since I've never had a truck with a small V6. I was looking for good HP and good MPG. I liked the sporty trim STX look. Great acceleration and great MPG. Much better than my previous 2006 F-150 5.4L, which was a great truck, but it was time for a change. I do recommend this vehicle if you want MPG, power, and great towing capacity.

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

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

Cars under $299,914 in Sturgeon, MO by make

Find great prices by city

Find great prices on used cars in Sturgeon, MO

Used cars by body style and price

[{"applied_filter_criteria":"{\"cpo_indicator\":false,\"max_price_range\":299914,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"crossover_compact","trim":"Limited","stock_sub":"","nvi_program":false,"customer_id":"5364156","year":"2023","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Gray","listing_id":"06c284f4-d632-423a-a7e8-ae16df067379","vin":"JF2SKAPCXPH412545","canonical_mmty":"Subaru:Forester:Limited:2023","dealer_zip":"65202","mileage":"100290","drivetrain":"All-wheel Drive","model":"Forester","relevancy_score":null,"dealer_name":"Mazda of Columbia","price":"23900","bodystyle":"SUV","make":"Subaru","sponsored":false,"canonical_mmt":"Subaru:Forester:Limited","sponsored_type":"standard","photo_count":28,"vertical_position":1,"certified_preowned":false,"badges":["price_drop_in_cents","good_deal"],"exterior_color":"Horizon Blue Pearl","msrp":null},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"truck_fullsize","trim":"Custom","stock_sub":"","nvi_program":false,"customer_id":"5363960","year":"2025","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Black","listing_id":"7f54c411-0eef-43ff-b776-1e8e9be10cd1","vin":"1GCPKBEK2SZ194978","canonical_mmty":"Chevrolet:Silverado 1500:Custom:2025","dealer_zip":"65203","mileage":"35535","drivetrain":"Four-wheel Drive","model":"Silverado 1500","relevancy_score":null,"dealer_name":"Joe Machens Nissan","price":"39994","bodystyle":"Truck","make":"Chevrolet","sponsored":false,"canonical_mmt":"Chevrolet:Silverado 1500:Custom","sponsored_type":"standard","photo_count":27,"vertical_position":2,"certified_preowned":false,"badges":["good_deal","american_made_index_ranking"],"exterior_color":"Slate Gray Metallic","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":true,"cat":"crossover_compact","trim":"SV","stock_sub":"","nvi_program":false,"customer_id":"5363960","year":"2024","fuel_type":"Gasoline","cpo_package":"Nissan","interior_color":"Charcoal","listing_id":"c0119ccd-553b-4f60-958f-cc656f5b36ba","vin":"5N1BT3BB4RC695588","canonical_mmty":"Nissan:Rogue:SV:2024","dealer_zip":"65203","mileage":"55573","drivetrain":"All-wheel Drive","model":"Rogue","relevancy_score":null,"dealer_name":"Joe Machens Nissan","price":"21871","bodystyle":"SUV","make":"Nissan","sponsored":true,"canonical_mmt":"Nissan:Rogue:SV","sponsored_type":"standard","photo_count":27,"vertical_position":3,"certified_preowned":true,"badges":["price_drop_in_cents","great_deal","american_made_index_ranking","cpo"],"exterior_color":"Brilliant Silver Metallic","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"sedan_midsize","trim":"EX 1.5T","stock_sub":"","nvi_program":false,"customer_id":"5354599","year":"2024","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Black","listing_id":"977d3af0-573a-4164-b262-2dd2dfb3bf05","vin":"1HGCY1F35RA045523","canonical_mmty":"Honda:Accord:EX 1.5T:2024","dealer_zip":"65202","mileage":"52233","drivetrain":"Front-wheel Drive","model":"Accord","relevancy_score":null,"dealer_name":"Columbia Honda","price":"23200","bodystyle":"Sedan","make":"Honda","sponsored":false,"canonical_mmt":"Honda:Accord:EX 1.5T","sponsored_type":"standard","photo_count":33,"vertical_position":4,"certified_preowned":false,"badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"exterior_color":"Platinum White Pearl","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"wagonhatchback_wagon","trim":"Premium","stock_sub":"","nvi_program":false,"customer_id":"5364156","year":"2024","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Black","listing_id":"4f533e1a-66b4-4956-ab48-719e9826e6cb","vin":"4S4BTADC2R3146594","canonical_mmty":"Subaru:Outback:Premium:2024","dealer_zip":"65202","mileage":"90719","drivetrain":"All-wheel Drive","model":"Outback","relevancy_score":null,"dealer_name":"Mazda of Columbia","price":"21700","bodystyle":"SUV","make":"Subaru","sponsored":false,"canonical_mmt":"Subaru:Outback:Premium","sponsored_type":"standard","photo_count":27,"vertical_position":5,"certified_preowned":false,"badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"exterior_color":"Brilliant Bronze Metallic","msrp":null},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"sedan_midsize","trim":"Sport SE 1.5T","stock_sub":"","nvi_program":false,"customer_id":"5354599","year":"2022","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Black","listing_id":"12b949b3-1d46-4995-82c5-0fc33b2b77f6","vin":"1HGCV1F47NA115860","canonical_mmty":"Honda:Accord:Sport SE 1.5T:2022","dealer_zip":"65202","mileage":"76680","drivetrain":"Front-wheel Drive","model":"Accord","relevancy_score":null,"dealer_name":"Columbia Honda","price":"23600","bodystyle":"Sedan","make":"Honda","sponsored":false,"canonical_mmt":"Honda:Accord:Sport SE 1.5T","sponsored_type":"standard","photo_count":33,"vertical_position":6,"certified_preowned":false,"badges":["price_drop_in_cents","good_deal"],"exterior_color":"Still Night Pearl","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"luxurypassenger_plus","trim":"E 350","stock_sub":"","nvi_program":false,"customer_id":"5364156","year":"2011","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Ash / Dark Gray","listing_id":"909f4e98-bf21-4a5c-9886-6f5354bebb39","vin":"WDDHF5GB5BA307172","canonical_mmty":"Mercedes-Benz:E-Class:E 350:2011","dealer_zip":"65202","mileage":"90860","drivetrain":"Rear-wheel Drive","model":"E-Class","relevancy_score":null,"dealer_name":"Mazda of Columbia","price":"9700","bodystyle":"Sedan","make":"Mercedes-Benz","sponsored":false,"canonical_mmt":"Mercedes-Benz:E-Class:E 350","sponsored_type":"standard","photo_count":28,"vertical_position":7,"certified_preowned":false,"badges":["price_drop_in_cents","good_deal"],"exterior_color":"Iridium Silver Metallic","msrp":null},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"crossover_compact","trim":"SV","stock_sub":"","nvi_program":false,"customer_id":"5364038","year":"2022","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Charcoal","listing_id":"1fb061cb-19e2-4868-90f2-995ec4c79e53","vin":"5N1BT3BB9NC671863","canonical_mmty":"Nissan:Rogue:SV:2022","dealer_zip":"65202","mileage":"63580","drivetrain":"All-wheel Drive","model":"Rogue","relevancy_score":null,"dealer_name":"Joe Machens Volkswagen","price":"19438","bodystyle":"SUV","make":"Nissan","sponsored":false,"canonical_mmt":"Nissan:Rogue:SV","sponsored_type":"standard","photo_count":50,"vertical_position":8,"certified_preowned":false,"badges":["price_drop_in_cents","good_deal"],"exterior_color":"Caspian Blue Metallic","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"crossover_compact","trim":"SV","stock_sub":"","nvi_program":false,"customer_id":"5354599","year":"2024","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Light Gray","listing_id":"6b1e6e44-8496-4011-a3e0-1c20a1a18c00","vin":"JN8BT3BB3RW424285","canonical_mmty":"Nissan:Rogue:SV:2024","dealer_zip":"65202","mileage":"43566","drivetrain":"All-wheel Drive","model":"Rogue","relevancy_score":null,"dealer_name":"Columbia Honda","price":"20800","bodystyle":"SUV","make":"Nissan","sponsored":false,"canonical_mmt":"Nissan:Rogue:SV","sponsored_type":"standard","photo_count":32,"vertical_position":9,"certified_preowned":false,"badges":["price_drop_in_cents","fair_deal","american_made_index_ranking"],"exterior_color":"Everest White Pearl","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"truck_fullsize","trim":"Lariat","stock_sub":"","nvi_program":false,"customer_id":"5243424","year":"2023","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Black","listing_id":"957a0de4-b1e5-4458-b219-8c265aed0a31","vin":"1FTFW1E87PKF66524","canonical_mmty":"Ford:F-150:Lariat:2023","dealer_zip":"65203","mileage":"35601","drivetrain":"Four-wheel Drive","model":"F-150","relevancy_score":null,"dealer_name":"Mercedes-Benz of Columbia","price":"46607","bodystyle":"Truck","make":"Ford","sponsored":false,"canonical_mmt":"Ford:F-150:Lariat","sponsored_type":"standard","photo_count":36,"vertical_position":10,"certified_preowned":false,"badges":["good_deal"],"exterior_color":"Agate Black Metallic","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"luxurysuv_crossover","trim":"Black Label Grand Touring AWD","stock_sub":"","nvi_program":false,"customer_id":"5243424","year":"2023","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Sandstone","listing_id":"d28abdb6-35f3-464c-ac4e-51c42049139e","vin":"5LMYJ8XY5PNL00309","canonical_mmty":"Lincoln:Aviator:Black Label Grand Touring AWD:2023","dealer_zip":"65203","mileage":"72019","drivetrain":"All-wheel Drive","model":"Aviator","relevancy_score":null,"dealer_name":"Mercedes-Benz of Columbia","price":"44239","bodystyle":"SUV","make":"Lincoln","sponsored":false,"canonical_mmt":"Lincoln:Aviator:Black Label Grand Touring AWD","sponsored_type":"standard","photo_count":38,"vertical_position":11,"certified_preowned":false,"badges":["good_deal"],"exterior_color":"White Metallic","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"truck_fullsize","trim":"Lariat","stock_sub":"","nvi_program":false,"customer_id":"6039707","year":"2021","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Black","listing_id":"346fdcc0-9bc2-4627-9325-e961ee43ce9e","vin":"1FTFW1E83MFA23238","canonical_mmty":"Ford:F-150:Lariat:2021","dealer_zip":"65203","mileage":"104220","drivetrain":"Four-wheel Drive","model":"F-150","relevancy_score":null,"dealer_name":"Joe Machens Ford","price":"31922","bodystyle":"Truck","make":"Ford","sponsored":false,"canonical_mmt":"Ford:F-150:Lariat","sponsored_type":"standard","photo_count":16,"vertical_position":12,"certified_preowned":false,"badges":["good_deal"],"exterior_color":"Black Metallic","msrp":null},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":true,"cat":"sedan_midsize","trim":"2.5 S","stock_sub":"","nvi_program":false,"customer_id":"5363960","year":"2025","fuel_type":"Gasoline","cpo_package":"Nissan","interior_color":"Charcoal","listing_id":"526ff113-f460-4b67-9193-8432b950ab21","vin":"1N4BL4BV4SN326394","canonical_mmty":"Nissan:Altima:2.5 S:2025","dealer_zip":"65203","mileage":"2968","drivetrain":"Front-wheel Drive","model":"Altima","relevancy_score":null,"dealer_name":"Joe Machens Nissan","price":"22767","bodystyle":"Sedan","make":"Nissan","sponsored":true,"canonical_mmt":"Nissan:Altima:2.5 S","sponsored_type":"standard","photo_count":27,"vertical_position":13,"certified_preowned":true,"badges":["great_deal","american_made_index_ranking","cpo"],"exterior_color":"Super Black Clearcoat","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"crossover_compact","trim":"SL","stock_sub":"","nvi_program":false,"customer_id":"5364156","year":"2023","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Charcoal","listing_id":"4e1662b4-6b37-48b0-a1c4-c11ff5970223","vin":"5N1BT3CA9PC796922","canonical_mmty":"Nissan:Rogue:SL:2023","dealer_zip":"65202","mileage":"57921","drivetrain":"Front-wheel Drive","model":"Rogue","relevancy_score":null,"dealer_name":"Mazda of Columbia","price":"23300","bodystyle":"SUV","make":"Nissan","sponsored":false,"canonical_mmt":"Nissan:Rogue:SL","sponsored_type":"standard","photo_count":29,"vertical_position":14,"certified_preowned":false,"badges":["great_deal"],"exterior_color":"Gun Metallic","msrp":null},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"wagonhatchback_wagon","trim":"Premium","stock_sub":"","nvi_program":false,"customer_id":"5243424","year":"2022","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Slate Black","listing_id":"2e83ebc5-6c87-41bf-8c87-9cfc7b97ddda","vin":"4S4BTAFC9N3156305","canonical_mmty":"Subaru:Outback:Premium:2022","dealer_zip":"65203","mileage":"80128","drivetrain":"All-wheel Drive","model":"Outback","relevancy_score":null,"dealer_name":"Mercedes-Benz of Columbia","price":"22389","bodystyle":"SUV","make":"Subaru","sponsored":false,"canonical_mmt":"Subaru:Outback:Premium","sponsored_type":"standard","photo_count":36,"vertical_position":15,"certified_preowned":false,"badges":["great_deal"],"exterior_color":"Gray Metallic","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"crossover_compact","trim":"2.0T S","stock_sub":"","nvi_program":false,"customer_id":"5364038","year":"2024","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Titan Black","listing_id":"902abfaf-e883-46b3-bb53-4ed289d4032f","vin":"3VVRB7AX0RM194515","canonical_mmty":"Volkswagen:Tiguan:2.0T S:2024","dealer_zip":"65202","mileage":"18960","drivetrain":"Front-wheel Drive","model":"Tiguan","relevancy_score":null,"dealer_name":"Joe Machens Volkswagen","price":"22572","bodystyle":"SUV","make":"Volkswagen","sponsored":false,"canonical_mmt":"Volkswagen:Tiguan:2.0T S","sponsored_type":"standard","photo_count":49,"vertical_position":16,"certified_preowned":false,"badges":["price_drop_in_cents","good_deal"],"exterior_color":"Pure White","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"truck_compact","trim":"TRD Off Road","stock_sub":"","nvi_program":false,"customer_id":"5364038","year":"2021","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Cement","listing_id":"59c143de-60cf-4805-bfd0-2a8478698f3f","vin":"3TMCZ5AN3MM397376","canonical_mmty":"Toyota:Tacoma:TRD Off Road:2021","dealer_zip":"65202","mileage":"44940","drivetrain":"Four-wheel Drive","model":"Tacoma","relevancy_score":null,"dealer_name":"Joe Machens Volkswagen","price":"37880","bodystyle":"Truck","make":"Toyota","sponsored":false,"canonical_mmt":"Toyota:Tacoma:TRD Off Road","sponsored_type":"standard","photo_count":6,"vertical_position":17,"certified_preowned":false,"badges":[],"exterior_color":"Super White","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"crossover_compact","trim":"2.5 S Carbon Edition","stock_sub":"","nvi_program":false,"customer_id":"5364156","year":"2024","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Red","listing_id":"33b533d4-b598-4caf-9934-e877e02dc350","vin":"JM3KFBCLXR0465026","canonical_mmty":"Mazda:CX-5:2.5 S Carbon Edition:2024","dealer_zip":"65202","mileage":"41163","drivetrain":"All-wheel Drive","model":"CX-5","relevancy_score":null,"dealer_name":"Mazda of Columbia","price":"26500","bodystyle":"SUV","make":"Mazda","sponsored":false,"canonical_mmt":"Mazda:CX-5:2.5 S Carbon Edition","sponsored_type":"standard","photo_count":32,"vertical_position":18,"certified_preowned":false,"badges":["price_drop_in_cents","fair_deal"],"exterior_color":"Polymetal Gray Metallic","msrp":null},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"sedan_midsize","trim":"2.5 SV","stock_sub":"","nvi_program":false,"customer_id":"5364038","year":"2023","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Charcoal","listing_id":"c58e1fbe-274b-4f0c-b5b4-f42490add550","vin":"1N4BL4DV9PN375238","canonical_mmty":"Nissan:Altima:2.5 SV:2023","dealer_zip":"65202","mileage":"66281","drivetrain":"Front-wheel Drive","model":"Altima","relevancy_score":null,"dealer_name":"Joe Machens Volkswagen","price":"18270","bodystyle":"Sedan","make":"Nissan","sponsored":false,"canonical_mmt":"Nissan:Altima:2.5 SV","sponsored_type":"standard","photo_count":49,"vertical_position":19,"certified_preowned":false,"badges":["good_deal"],"exterior_color":"Garnet Pearl Metallic","msrp":"0"},{"stock_type":"Used","seller_type":"dealership","cpo_indicator":false,"cat":"truck_fullsize","trim":"XL","stock_sub":"","nvi_program":false,"customer_id":"5354599","year":"2020","fuel_type":"Gasoline","cpo_package":null,"interior_color":"Black","listing_id":"ac29ee3f-a7e5-437a-9157-4100566b5c2f","vin":"1FTEW1EP0LKE72787","canonical_mmty":"Ford:F-150:XL:2020","dealer_zip":"65202","mileage":"76499","drivetrain":"Four-wheel Drive","model":"F-150","relevancy_score":null,"dealer_name":"Columbia Honda","price":"26500","bodystyle":"Truck","make":"Ford","sponsored":false,"canonical_mmt":"Ford:F-150:XL","sponsored_type":"standard","photo_count":12,"vertical_position":20,"certified_preowned":false,"badges":["good_deal"],"exterior_color":"Race Red","msrp":"0"}]}]