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 Fayette, MO under $499,970

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

Save your search and get notified when new inventory arrives.

Prequalify now

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

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

Vehicle information

Ext. color: 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: Super Black Clearcoat
Int. color: Charcoal
Drivetrain: Front-wheel Drive
MPG: 27-37
Fuel type: Gasoline
Transmission: CVT with Xtronic
Engine: 2.5L 4-Cylinder DOHC 16V
Stock #: SN329150
VIN: 1N4BL4EV8SN329150

Features

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

Reviews

Joe Machens Nissan review

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

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 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: 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: Crystal Black Pearl
Int. color: Black
Drivetrain: Front-wheel Drive
MPG: 30-37
Fuel type: Gasoline
Transmission: Automatic
Engine: 2L I-4 gasoline direct injection, DOHC, i-VTEC variable valve co
Stock #: RH553429
VIN: 2HGFE2F52RH553429

Features

Convenience: Adaptive Cruise Control, Keyless Entry, Keyless Start, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Automatic Emergency Braking, Backup Camera, 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.

2024 Honda Civic Sport review

Heather was an amazing sales woman, I truly appreciate

Heather was an amazing sales woman, I truly appreciate her hard work for making today happen! I purchased my first car by myself. I can’t wait to love my new Honda Civic

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

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

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

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 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 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 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: Moonlight Cloud
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: Automatic
Engine: Lambda II 3.8L V-6 gasoline direct injection, DOHC, D-CVVT varia
Stock #: SU819199
VIN: KM8R2DGE9SU819199

Features

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

Reviews

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

2025 Hyundai PALISADE SEL review

We love our new vehicle!

We love our new vehicle!! Very comfortable and it drives great!! Tons of room. Safety features are perfect. We are extremely happy with our purchase

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

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.

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.

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

Columbia Hondas Service Department

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

2024 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 Silver 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 #: RN391263
VIN: 1N4BL4DV7RN391263

Features

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

Reviews

Columbia Honda review

top notch service

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

2024 Nissan Altima 2.5 SV review

Great mileage and very nice interior.

Great mileage and very nice interior. Lotsa stuff but sadly only drivers window is auto. Wheels are terrible. They look great but very hard to clean. Good trunk space and nice seats. Having problems with backup camera it looks very foggy. Had it back to dealer twice, no luck. No CD player.. big downgrade.

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

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

*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,400 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 $499,970 in Fayette, MO by make

Find great prices by city

Find great prices on used cars in Fayette, MO

Used cars by body style and price

[{"applied_filter_criteria":"{\"cpo_indicator\":false,\"max_price_range\":499970,\"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":[{"cat":"truck_fullsize","vin":"1GCPKBEK2SZ194978","trim":"Custom","price":"39994","listing_id":"7f54c411-0eef-43ff-b776-1e8e9be10cd1","canonical_mmty":"Chevrolet:Silverado 1500:Custom:2025","year":"2025","relevancy_score":null,"bodystyle":"Truck","canonical_mmt":"Chevrolet:Silverado 1500:Custom","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Joe Machens Nissan","fuel_type":"Gasoline","exterior_color":"Slate Gray Metallic","mileage":"35535","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Chevrolet","drivetrain":"Four-wheel Drive","customer_id":"5363960","model":"Silverado 1500","photo_count":27,"seller_type":"dealership","badges":["good_deal","american_made_index_ranking"],"certified_preowned":false,"vertical_position":1,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Black"},{"cat":"crossover_compact","vin":"5N1BT3BB4RC695588","trim":"SV","price":"21871","listing_id":"c0119ccd-553b-4f60-958f-cc656f5b36ba","canonical_mmty":"Nissan:Rogue:SV:2024","year":"2024","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Nissan:Rogue:SV","sponsored":true,"stock_sub":"","cpo_indicator":true,"dealer_name":"Joe Machens Nissan","fuel_type":"Gasoline","exterior_color":"Brilliant Silver Metallic","mileage":"55573","msrp":"0","stock_type":"Used","cpo_package":"Nissan","make":"Nissan","drivetrain":"All-wheel Drive","customer_id":"5363960","model":"Rogue","photo_count":27,"seller_type":"dealership","badges":["price_drop_in_cents","great_deal","american_made_index_ranking","cpo"],"certified_preowned":true,"vertical_position":2,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Charcoal"},{"cat":"sedan_midsize","vin":"1N4BL4EV8SN329150","trim":"2.5 SL","price":"28571","listing_id":"e4095359-988a-4873-96db-e944f0ce4eb3","canonical_mmty":"Nissan:Altima:2.5 SL:2025","year":"2025","relevancy_score":null,"bodystyle":"Sedan","canonical_mmt":"Nissan:Altima:2.5 SL","sponsored":true,"stock_sub":"","cpo_indicator":true,"dealer_name":"Joe Machens Nissan","fuel_type":"Gasoline","exterior_color":"Super Black Clearcoat","mileage":"3143","msrp":"0","stock_type":"Used","cpo_package":"Nissan","make":"Nissan","drivetrain":"Front-wheel Drive","customer_id":"5363960","model":"Altima","photo_count":28,"seller_type":"dealership","badges":["price_drop_in_cents","good_deal","american_made_index_ranking","cpo"],"certified_preowned":true,"vertical_position":3,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Charcoal"},{"cat":"sedan_midsize","vin":"1HGCY1F35RA045523","trim":"EX 1.5T","price":"23200","listing_id":"977d3af0-573a-4164-b262-2dd2dfb3bf05","canonical_mmty":"Honda:Accord:EX 1.5T:2024","year":"2024","relevancy_score":null,"bodystyle":"Sedan","canonical_mmt":"Honda:Accord:EX 1.5T","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Columbia Honda","fuel_type":"Gasoline","exterior_color":"Platinum White Pearl","mileage":"52233","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Honda","drivetrain":"Front-wheel Drive","customer_id":"5354599","model":"Accord","photo_count":33,"seller_type":"dealership","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"certified_preowned":false,"vertical_position":4,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Black"},{"cat":"crossover_compact","vin":"3VVRB7AX0RM194515","trim":"2.0T S","price":"22572","listing_id":"902abfaf-e883-46b3-bb53-4ed289d4032f","canonical_mmty":"Volkswagen:Tiguan:2.0T S:2024","year":"2024","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Volkswagen:Tiguan:2.0T S","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Joe Machens Volkswagen","fuel_type":"Gasoline","exterior_color":"Pure White","mileage":"18960","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Volkswagen","drivetrain":"Front-wheel Drive","customer_id":"5364038","model":"Tiguan","photo_count":49,"seller_type":"dealership","badges":["price_drop_in_cents","good_deal"],"certified_preowned":false,"vertical_position":5,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Titan Black"},{"cat":"truck_fullsize","vin":"1FTFW1E87PKF66524","trim":"Lariat","price":"46607","listing_id":"957a0de4-b1e5-4458-b219-8c265aed0a31","canonical_mmty":"Ford:F-150:Lariat:2023","year":"2023","relevancy_score":null,"bodystyle":"Truck","canonical_mmt":"Ford:F-150:Lariat","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Mercedes-Benz of Columbia","fuel_type":"Gasoline","exterior_color":"Agate Black Metallic","mileage":"35601","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Ford","drivetrain":"Four-wheel Drive","customer_id":"5243424","model":"F-150","photo_count":37,"seller_type":"dealership","badges":["good_deal"],"certified_preowned":false,"vertical_position":6,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Black"},{"cat":"luxurysuv_crossover","vin":"5LMYJ8XY5PNL00309","trim":"Black Label Grand Touring AWD","price":"44239","listing_id":"d28abdb6-35f3-464c-ac4e-51c42049139e","canonical_mmty":"Lincoln:Aviator:Black Label Grand Touring AWD:2023","year":"2023","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Lincoln:Aviator:Black Label Grand Touring AWD","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Mercedes-Benz of Columbia","fuel_type":"Gasoline","exterior_color":"White Metallic","mileage":"72019","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Lincoln","drivetrain":"All-wheel Drive","customer_id":"5243424","model":"Aviator","photo_count":39,"seller_type":"dealership","badges":["good_deal"],"certified_preowned":false,"vertical_position":7,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Sandstone"},{"cat":"truck_fullsize","vin":"1FTFW1E83MFA23238","trim":"Lariat","price":"31922","listing_id":"346fdcc0-9bc2-4627-9325-e961ee43ce9e","canonical_mmty":"Ford:F-150:Lariat:2021","year":"2021","relevancy_score":null,"bodystyle":"Truck","canonical_mmt":"Ford:F-150:Lariat","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Joe Machens Ford","fuel_type":"Gasoline","exterior_color":"Black Metallic","mileage":"104220","msrp":null,"stock_type":"Used","cpo_package":null,"make":"Ford","drivetrain":"Four-wheel Drive","customer_id":"6039707","model":"F-150","photo_count":16,"seller_type":"dealership","badges":["good_deal"],"certified_preowned":false,"vertical_position":8,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Black"},{"cat":"sedan_compact","vin":"2HGFE2F52RH553429","trim":"Sport","price":"23800","listing_id":"9110555c-b91b-4088-858a-6bcf5274cb27","canonical_mmty":"Honda:Civic:Sport:2024","year":"2024","relevancy_score":null,"bodystyle":"Sedan","canonical_mmt":"Honda:Civic:Sport","sponsored":true,"stock_sub":"","cpo_indicator":true,"dealer_name":"Columbia Honda","fuel_type":"Gasoline","exterior_color":"Crystal Black Pearl","mileage":"37293","msrp":"0","stock_type":"Used","cpo_package":"HondaTrue Certified","make":"Honda","drivetrain":"Front-wheel Drive","customer_id":"5354599","model":"Civic","photo_count":33,"seller_type":"dealership","badges":["price_drop_in_cents","good_deal","american_made_index_ranking","cpo"],"certified_preowned":true,"vertical_position":9,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Black"},{"cat":"wagonhatchback_wagon","vin":"4S4BTAFC9N3156305","trim":"Premium","price":"22389","listing_id":"2e83ebc5-6c87-41bf-8c87-9cfc7b97ddda","canonical_mmty":"Subaru:Outback:Premium:2022","year":"2022","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Subaru:Outback:Premium","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Mercedes-Benz of Columbia","fuel_type":"Gasoline","exterior_color":"Gray Metallic","mileage":"80128","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Subaru","drivetrain":"All-wheel Drive","customer_id":"5243424","model":"Outback","photo_count":37,"seller_type":"dealership","badges":["great_deal"],"certified_preowned":false,"vertical_position":10,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Slate Black"},{"cat":"crossover_compact","vin":"5N1BT3CA9PC796922","trim":"SL","price":"23300","listing_id":"4e1662b4-6b37-48b0-a1c4-c11ff5970223","canonical_mmty":"Nissan:Rogue:SL:2023","year":"2023","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Nissan:Rogue:SL","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Mazda of Columbia","fuel_type":"Gasoline","exterior_color":"Gun Metallic","mileage":"57921","msrp":null,"stock_type":"Used","cpo_package":null,"make":"Nissan","drivetrain":"Front-wheel Drive","customer_id":"5364156","model":"Rogue","photo_count":29,"seller_type":"dealership","badges":["great_deal"],"certified_preowned":false,"vertical_position":11,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Charcoal"},{"cat":"truck_compact","vin":"3TMCZ5AN3MM397376","trim":"TRD Off Road","price":"37880","listing_id":"59c143de-60cf-4805-bfd0-2a8478698f3f","canonical_mmty":"Toyota:Tacoma:TRD Off Road:2021","year":"2021","relevancy_score":null,"bodystyle":"Truck","canonical_mmt":"Toyota:Tacoma:TRD Off Road","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Joe Machens Volkswagen","fuel_type":"Gasoline","exterior_color":"Super White","mileage":"44940","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Toyota","drivetrain":"Four-wheel Drive","customer_id":"5364038","model":"Tacoma","photo_count":6,"seller_type":"dealership","badges":[],"certified_preowned":false,"vertical_position":12,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Cement"},{"cat":"crossover_compact","vin":"JM3KFBCLXR0465026","trim":"2.5 S Carbon Edition","price":"26500","listing_id":"33b533d4-b598-4caf-9934-e877e02dc350","canonical_mmty":"Mazda:CX-5:2.5 S Carbon Edition:2024","year":"2024","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Mazda:CX-5:2.5 S Carbon Edition","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Mazda of Columbia","fuel_type":"Gasoline","exterior_color":"Polymetal Gray Metallic","mileage":"41163","msrp":null,"stock_type":"Used","cpo_package":null,"make":"Mazda","drivetrain":"All-wheel Drive","customer_id":"5364156","model":"CX-5","photo_count":32,"seller_type":"dealership","badges":["price_drop_in_cents","fair_deal"],"certified_preowned":false,"vertical_position":13,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Red"},{"cat":"sedan_midsize","vin":"1N4BL4DV9PN375238","trim":"2.5 SV","price":"18270","listing_id":"c58e1fbe-274b-4f0c-b5b4-f42490add550","canonical_mmty":"Nissan:Altima:2.5 SV:2023","year":"2023","relevancy_score":null,"bodystyle":"Sedan","canonical_mmt":"Nissan:Altima:2.5 SV","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Joe Machens Volkswagen","fuel_type":"Gasoline","exterior_color":"Garnet Pearl Metallic","mileage":"66281","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Nissan","drivetrain":"Front-wheel Drive","customer_id":"5364038","model":"Altima","photo_count":49,"seller_type":"dealership","badges":["good_deal"],"certified_preowned":false,"vertical_position":14,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Charcoal"},{"cat":"crossover_midsize","vin":"KM8R2DGE9SU819199","trim":"SEL","price":"34131","listing_id":"be408a01-574f-4009-abc4-2c4d9b13ef49","canonical_mmty":"Hyundai:PALISADE:SEL:2025","year":"2025","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Hyundai:PALISADE:SEL","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Joe Machens Volkswagen","fuel_type":"Gasoline","exterior_color":"Moonlight Cloud","mileage":"35127","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Hyundai","drivetrain":"All-wheel Drive","customer_id":"5364038","model":"PALISADE","photo_count":51,"seller_type":"dealership","badges":["great_deal","2025_award_winner"],"certified_preowned":false,"vertical_position":15,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Black"},{"cat":"truck_fullsize","vin":"1FTEW1EP0LKE72787","trim":"XL","price":"26500","listing_id":"ac29ee3f-a7e5-437a-9157-4100566b5c2f","canonical_mmty":"Ford:F-150:XL:2020","year":"2020","relevancy_score":null,"bodystyle":"Truck","canonical_mmt":"Ford:F-150:XL","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Columbia Honda","fuel_type":"Gasoline","exterior_color":"Race Red","mileage":"76499","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Ford","drivetrain":"Four-wheel Drive","customer_id":"5354599","model":"F-150","photo_count":12,"seller_type":"dealership","badges":["great_deal"],"certified_preowned":false,"vertical_position":16,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Black"},{"cat":"crossover_midsize","vin":"5XYRLDJC1RG290903","trim":"S","price":"27300","listing_id":"07a392f3-3f9a-40e7-8cbf-03b4e53dff01","canonical_mmty":"Kia:Sorento:S:2024","year":"2024","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Kia:Sorento:S","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Columbia Honda","fuel_type":"Gasoline","exterior_color":"Gravity Grey","mileage":"36193","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Kia","drivetrain":"All-wheel Drive","customer_id":"5354599","model":"Sorento","photo_count":33,"seller_type":"dealership","badges":["price_drop_in_cents","good_deal","american_made_index_ranking"],"certified_preowned":false,"vertical_position":17,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Black"},{"cat":"sedan_midsize","vin":"1N4BL4DV7RN391263","trim":"2.5 SV","price":"19000","listing_id":"31ac6c13-0821-41a4-ae67-34f3b101a81d","canonical_mmty":"Nissan:Altima:2.5 SV:2024","year":"2024","relevancy_score":null,"bodystyle":"Sedan","canonical_mmt":"Nissan:Altima:2.5 SV","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Columbia Honda","fuel_type":"Gasoline","exterior_color":"Brilliant Silver Metallic","mileage":"56259","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Nissan","drivetrain":"Front-wheel Drive","customer_id":"5354599","model":"Altima","photo_count":33,"seller_type":"dealership","badges":["price_drop_in_cents","good_deal","american_made_index_ranking","hot_car"],"certified_preowned":false,"vertical_position":18,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Charcoal"},{"cat":"crossover_compact","vin":"JN8BT3BB3RW424285","trim":"SV","price":"20800","listing_id":"6b1e6e44-8496-4011-a3e0-1c20a1a18c00","canonical_mmty":"Nissan:Rogue:SV:2024","year":"2024","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Nissan:Rogue:SV","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Columbia Honda","fuel_type":"Gasoline","exterior_color":"Everest White Pearl","mileage":"43566","msrp":"0","stock_type":"Used","cpo_package":null,"make":"Nissan","drivetrain":"All-wheel Drive","customer_id":"5354599","model":"Rogue","photo_count":32,"seller_type":"dealership","badges":["price_drop_in_cents","fair_deal","american_made_index_ranking"],"certified_preowned":false,"vertical_position":19,"nvi_program":false,"dealer_zip":"65202","sponsored_type":"standard","interior_color":"Light Gray"},{"cat":"crossover_compact","vin":"5N1BT3BB5NC705555","trim":"SV","price":"20821","listing_id":"f59ade72-b460-4ba0-892e-370ca58acb57","canonical_mmty":"Nissan:Rogue:SV:2022","year":"2022","relevancy_score":null,"bodystyle":"SUV","canonical_mmt":"Nissan:Rogue:SV","sponsored":false,"stock_sub":"","cpo_indicator":false,"dealer_name":"Joe Machens Ford","fuel_type":"Gasoline","exterior_color":"Gun Metallic","mileage":"54447","msrp":null,"stock_type":"Used","cpo_package":null,"make":"Nissan","drivetrain":"All-wheel Drive","customer_id":"6039707","model":"Rogue","photo_count":30,"seller_type":"dealership","badges":["good_deal"],"certified_preowned":false,"vertical_position":20,"nvi_program":false,"dealer_zip":"65203","sponsored_type":"standard","interior_color":"Charcoal"}]}]