Skip to main content

Contact seller

Contact seller

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

We value your privacy. Cars.com Privacy Notice

Customize your budget

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

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

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

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

Used SUVs for sale near Columbia, NY under $899,990

Filters 3 Year Price & payment Make Mileage Body style Ext. color All filters
650 matches 30 miles from 13357
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: Snow White Pearl
Int. color: Satin Black
Drivetrain: All-wheel Drive
MPG: 17-23
Fuel type: Gasoline
Transmission: 6-Speed Automatic
Engine: 3.3L V6 24V GDI DOHC
Stock #: 26341A
VIN: 5XYPKDA5XHG337341

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Bluetooth®, CD Player, 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: Leather Seats, Memory Seat, Third Row Seating

Reviews

Mastrovito Hyundai review

Great dealership to work with

Working with Belmin made for a pleasant car buying experience. My vehicle was made ready for me in a short time. The overall feeling in the showroom was very positive

2017 Kia Sorento SXL review

2017 KIA Sorento , I love my SUV!

2017 KIA Sorento , I love my SUV! I’ve had an issues at all until 2024. I had to have an oil pan leak. Also, Rear Bearing sensor. Other than that regular stuff such as tires windshield wiper, ect The vehicle was a year old and a one person owner when I purchased it

Vehicle information

Ext. color: White
Int. color: Green / Beige
Drivetrain: All-wheel Drive
MPG: 20-28
Fuel type: Gasoline
Transmission: 8-Speed Automatic with Auto-Shift
Engine: 2.5L I4 16V PDI DOHC Turbo
Stock #: 125596B
VIN: 5NMP5DGL9SH102083

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Roof Rack, Sunroof/Moonroof
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Memory Seat, Third Row Seating

Reviews

Mastrovito Hyundai review

Excellent service start to finish! The staff ROCK!

I highly recommend Mastrovito's! My salesperson was Belmin Mestrovac and he was excellent. He wasn't pushy. He was knowledgeable and helped me figure out the best option based on my likes and needs. I highly recommend contacting him if you have any questions. Belmin,Gina,Kristian,John,Aldin and Gabriella.... All of the staff there were fantastic from start to finish!

2025 Hyundai SANTA FE Calligraphy review

Been driving my new Santa Fe XRT for 40 days now.

Been driving my new Santa Fe XRT for 40 days now. The vehicle is great and has been useful for me. The financing process with Hyundai Motor Finance has been positive too. No complaints. Love my new family SUV. My dog loves it too.

Vehicle information

Ext. color: Abyss Black Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.8L V6 24V GDI DOHC
Stock #: 26271A
VIN: KM8R1DHE1NU485501

Features

Convenience: Adaptive Cruise Control, Keyless Entry
Entertainment: Apple CarPlay®, Bluetooth®, USB Port
Exterior: Alloy Wheels
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Third Row Seating

Reviews

Mastrovito Hyundai review

Mastrovito makes it easy/

This was the first time that I made an out of state vehicle purchase through the internet, Cars.com. Mastrovito sales and financial personnel made the purchase of our used Hyundai Santa Fe Plug in Hybrid as seemless as our hometown dealership. They handled all the out of state paperwork and sales taxes easy for us to title the car in our home state of Indiana.

2022 Hyundai PALISADE SE review

Just be aware that if you buy a white one that Hyundai

Just be aware that if you buy a white one that Hyundai had a problem with the paint just flaking off. On the roof of my car which is white, I have big strands and strips of paint coming off and the car only has 20,000 miles. They covered it under warranty for 10 years but it's just a hassle.

Vehicle information

Ext. color: Cascade Green Silica
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: S39584A
VIN: JF2SKAEC6PH444931

Features

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

Reviews

Subaru of Utica review

Justin Malagese Subaru Sales/Leasing Specialist!

Justin Malagese Subaru Sales/Leasing Specialist! Justin did a very great job for us picking out the Subaru Forester ! Down to earth and trustworthy .Andy & Nancy Hugick

2023 Subaru Forester Premium review

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

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

Vehicle information

Ext. color: Crystal Black Silica
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 #: S39524A
VIN: 4S4BTANC8L3204939

Features

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

Reviews

Subaru of Utica review

The Crosstrek is new to me.

The Crosstrek is new to me...after owning 4 Foresters, I wanted something slightly smaller, but equally as efficient, economical and safe. Jason gave me a thorough briefing and "ride-a-long" on two occasions...he is so knowledgeable about the products, and generous with his time in explaining it all...I would highly recommend Jason to everyone who is interested in learning about & purchasing a car, either new or used... Bonnie S

2020 Subaru Outback Limited review

Dependable and problem free

Best vehicle I have ever owned. Dependable, safe, comfortable ride, great fit & finish and responsive and overall excellent quality. No problems in 48,000 miles.

Vehicle information

Ext. color: Labrador Black Metallic
Int. color: Black
Drivetrain: Four-wheel Drive
MPG: 24-29
Fuel type: Gasoline
Transmission: Automatic CVT
Engine: 2.4L I4 16V MPFI SOHC
Stock #: 25550B
VIN: JA4AZ3A34KZ003612

Features

Convenience: Heated Seats, Keyless Entry, Keyless Start, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, Satellite Radio, USB Port
Exterior: Alloy Wheels, Roof Rack
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Rain Sensing Wipers, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

Mastrovito Hyundai review

Awesome place to visit.

Awesome place to visit. Answered all my questions. Have any questions or problems go see Eliut.

2019 Mitsubishi Outlander SE review

I have owned my Mitsubishi Outlander since 2018 and all

I have owned my Mitsubishi Outlander since 2018 and all I’ve done was buy a battery, tires and brakes and she still gets 35 miles per gallon on gas. I’m afraid to touch it under the hood and only lifted it for window washer fluid and oil changes. I totally love this car. I will buy another one but it will be a 2019 and P.S. I can hold 4 35X12.50X 20LT tires when back seats are down. Best SUV sleeper by far without the expensive prices of Toyota and Honda!!! Buy, Buy, Buy!!!

Vehicle information

Ext. color: Glacial White Pearl
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.8L V6 24V GDI DOHC
Stock #: 125478A
VIN: 5XYP6DHCXNG233131

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Keyless Start, Navigation System, Remote Start
Entertainment: Apple CarPlay®, Bluetooth®, Satellite Radio
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Backup Camera, Blind Spot Monitor, Brake Assist, Lane Departure Warning, Rear Cross Traffic Alert, Stability Control
Seating: Leather Seats, Third Row Seating

Reviews

Mastrovito Hyundai review

waiting on call back from mr smith, regarding

waiting on call back from mr smith, regarding depreciation on 22 tucson vehicle, relating to asking price on 3 yr s old vs deprec. from 32 k new purchase. he is to call after thanksgiving, no call as of yet.

2022 Kia Telluride S review

If you want a comfortable, stylish, and affordable suv

If you want a comfortable, stylish, and affordable suv for your family this is the car for you. Makes me feel proud when driving it and holds its own compared to other luxury suvs that cost a lot more. My only complaints are that it’s a gas guzzler and at this price point all models should come with the digital speedometer dashboard and not just the highest trim levels.

Vehicle information

Ext. color: Apex Blue Pearl
Int. color: Ebony
Drivetrain: All-wheel Drive
MPG: 21-26
Fuel type: Gasoline
Transmission: 10-Speed Automatic
Engine: 2.0L I4 16V GDI DOHC Turbo
Stock #: 25821B
VIN: 5J8TC2H6XLL023105

Features

Convenience: Adaptive Cruise Control, Cooled Seats, Heated Seats, Keyless Entry, Keyless Start, Navigation System, Power Liftgate
Entertainment: Apple CarPlay®, Bluetooth®, HomeLink, Premium Sound System, Satellite Radio
Exterior: Alloy Wheels, Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Blind Spot Monitor, Brake Assist, LED Headlights, Lane Departure Warning, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

2020 Acura RDX A-Spec review

Awesome car questionable corporate

My wife and I absolutely Love our RDX. Unfortunately we recently had a mechanical issue and the part is on back order, 3 weeks later and still no part. So our vehicle is great but not sure about corporate??????

Vehicle information

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

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
Seating: Leather Seats

Reviews

Subaru of Utica review

A great, friendly and professional staff.

A great, friendly and professional staff. Our sales rep Jay Jackson was very courteous and very attentive to our needs. He showed us every vehicle we were interested in and didn't pressure us to purchase anything until we were assured that it was the right vehicle for us. Everyone from Jay, Bernard and Moe made the experience extremely easy and stress free.

2023 Nissan Rogue SV review

So far I have been pleased with the performance of my

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

Vehicle information

Ext. color: Classic Silver Metallic
Int. color: Black Graphite
Drivetrain: Four-wheel Drive
MPG: 17-20
Fuel type: Gasoline
Transmission: 5-Speed Automatic
Engine: 4.0L V6 24V MPFI DOHC
Stock #: 1262P
VIN: JTEBU5JR0J5596010

Features

Convenience: Keyless Entry, Navigation System
Entertainment: Bluetooth®, CD Player, Satellite Radio, USB Port
Exterior: Alloy Wheels, Roof Rack, Tow Hitch
Safety: Backup Camera, Brake Assist, Stability Control

Reviews

2018 Toyota 4Runner SR5 review

KDSS problems

Love my 4Runner but the only thing wrong with it is the KDSS problems that no one knows how to fix. Light comes on in the winter and starts leaking. Dealer replaced it once and they paid the $4, 000.00 because it was the first time that they had seen this. Now it almost winter and the lights coming back on.

Vehicle information

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

Features

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

Reviews

Nimey's New Generation Cars review

This is my third car from Nimey's New Generation Cars.

This is my third car from Nimey's New Generation Cars. Every time I shop here - I leave happy! Great people, great cars.

2022 Hyundai SANTA FE SEL 2.4 review

I've owned about 20 new vehicles and sold cars for 22

I've owned about 20 new vehicles and sold cars for 22 years, did a ton on research and ended up with the Caligraphy, it gives you so many features I wanted for a reasonable price. The engine is great and has plenty of power, great stereo, great highway cruiser as well. I have 32k miles, Hyundai has covered all my maintenance, and no warranty claims so far. Great Value! I have normally owned Toyota and Honda but wanted some features they either didn't have or I would have had to go to Lexus or Acura and pay way more for what I wanted.

Vehicle information

Ext. color: Crystal White Pearl
Int. color: Gray
Drivetrain: All-wheel Drive
MPG: 25-28
Fuel type: Gasoline
Transmission: CVT Transmission
Engine: 2.5L H-4 gasoline direct injection, DOHC, variable valve control
Stock #: F39731A
VIN: JF2SKAMC4PH486290

Features

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

Reviews

Don's Ford review

Mr. James From Cooperstown

Good experience. See Mr. Dave. I would trade again. Everything went well. Mr. Dave was pleasant and new his cars.See Mr Dave for the best deal. Great line up of used cars.

2023 Subaru Forester Wilderness review

Likes: spacious interior despite modest exterior

Likes: spacious interior despite modest exterior dimensions, easy to maneuver, great visibility all around, comfortable ride, good traction, handling, and braking, nice interior finish on sport model, strong steering responsive headlights yet they don't blind opposing traffic, very good optional Harmon sound system, numerous effective safety features, low insurance premiums, adequate acceleration..a few cons: actual economy slightly under EPA estimates, seat may be a bit too firm for some but easy to address by adding a thin seat cushion, mandatory sunroof on all but the base model..I wish Subaru would just make that a single option..rough engine start-stop ..however I disable it each time I start engine so it can be a non issue...no reliability issues yet but since this has a cvt and fairly complex safety features, long term reliability is unknown..

Vehicle information

Ext. color: Baltic Gray Metallic Clearcoat
Int. color: Global Black
Drivetrain: Four-wheel Drive
MPG: 19-26
Fuel type: Gasoline
Transmission: Automatic
Engine: Pentastar 3.6L V-6 DOHC, variable valve control, regular unleade
Stock #: D607011A
VIN: 1C4RJHAG4PC607011

Features

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

Reviews

Chrysler Dodge Jeep RAM of Utica review

I had a great experience, the best price first, no back

I had a great experience, the best price first, no back and forth games. A great team, everyone involved was very helpful and honest.

2023 Jeep Grand Cherokee Altitude review

Natural upgrade choice

Runs smooth. Very comfortable. Always loved the Jeep brand so this was a natural upgrade. Love the options too. The adaptive cruise control is amazing.

Vehicle information

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

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

Reviews

Chrysler Dodge Jeep RAM of Utica review

An Unbeatable Car Buying Experience at chrysler, Dodge

An Unbeatable Car Buying Experience at chrysler, Dodge Jeep and Ram of Utica.– Ask for Tyler! I recently purchased a new vehicle from chrysler, Dodge Jeep and Ram of Utica., and I can genuinely say it was the most positive car-buying experience I've ever had. From the moment I walked in, I knew I was in good hands, and they truly went above and beyond to ensure all my needs were met. What truly set this experience apart was the exceptional service provided by Tyler. He wasn't just a salesperson; he was a true partner in the process. Tyler listened intently to my preferences, understood my budget, and expertly guided me through the options without any pressure. He was incredibly knowledgeable about every vehicle, patiently answering all my questions and providing insights I hadn't even considered. Tyler’s dedication didn’t stop at finding the right car. He seamlessly handled every aspect of the purchase, from navigating the paperwork to ensuring the vehicle was perfectly prepared for pickup. It felt like every detail was taken care of, making what can often be a stressful process feel incredibly smooth and enjoyable. He clearly values his customers and is committed to delivering outstanding service. If you're in the market for a new vehicle and are looking for a dealership that prioritizes customer satisfaction and provides truly personalized service, look no further than chrysler. Dodge, Jeep and Ram of Utica.. And seriously, do yourself a favor and ask for Tyler. His professionalism, expertise, and genuine desire to help make him an absolute standout. I wholeheartedly recommend them and will definitely be returning for any future automotive needs.

2022 Volkswagen Tiguan 2.0T SEL R-Line 4MOTION review

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

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

Vehicle information

Ext. color: Gun Metallic
Int. color: Charcoal
Drivetrain: All-wheel Drive
MPG: 26-33
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L I-4 gasoline direct injection, DOHC, variable valve control
Stock #: 15477
VIN: JN8AT3AB3MW206739

Features

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

Reviews

Rome Pre-Owned Auto Sales review

I went in with an open mind,I knew exactly what I wanted

I went in with an open mind,I knew exactly what I wanted RED jeep cherokee,I knew how much I could spend,being as I'm a women I no nothing about a vehicle so I had my son with me,they knew I was coming to try out the RED JEEP,no keys available,so it was decided I would try out a black one it was very nice,just like brand new,my son thought it would be idea for me,I baught it I love it,but it's not RED,they are very nice people to deal with,easy process,not pushy,I would recommend them to any one,I would buy another car from them again,and when they didn't even try and push the more expensive RED Jeep on me that says alot,I really love my black jeep

2021 Nissan Rogue S review

This 2021 Nissan Rogue SL is a great car.

This 2021 Nissan Rogue SL is a great car. It is very comfortable and loaded with features. I am very pleased with fuel efficiency. There has been no problems to report since I bought this car.

Vehicle information

Ext. color: Soul Red Crystal Metallic
Int. color: Black
Drivetrain: All-wheel Drive
MPG: 24-30
Fuel type: Gasoline
Transmission: Automatic
Engine: SKYACTIV-G 2.5L I-4 gasoline direct injection, DOHC, VVT variabl
Stock #: NG1345
VIN: JM3KFBCMXN1590282

Features

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

Reviews

Nimey's New Generation Cars review

I’ve purchased 4 cars from Nimey’s New Generation Cars

I’ve purchased 4 cars from Nimey’s New Generation Cars over the years, and they’ve been great every time. From the friendly service department to the no-pressure sales guys, I would never go anywhere else. Plus, they’re locally owned!

2022 Mazda CX-5 2.5 S Preferred Package review

Love our Mazdas!

We have owned our 2022 CX-5 Turbo for 10 moths and it is a great vehicle. Our previous SUV was an Acura RDX Advance. It too was great but this Mazda is of a higher quality and $10-$15,000 less when purchased new. Every once in a while the doors don’t lock when I walk away (I have it set up to do so) and that is the only issue I have had in 10 months and 10,000 miles. I highly recommend any Mazda product. We also own a ‘21 Miata RF, have owned several Miatas along with a Mazda6 Signature and a CX-9 Grand Touring. All have been great vehicles.

Vehicle information

Ext. color: Twilight Blue Metallic
Int. color: Slate Black
Drivetrain: All-wheel Drive
MPG: 25-32
Fuel type: Gasoline
Transmission: Automatic
Engine: 2.5L H-4 DOHC, variable valve control, regular unleaded, engine
Stock #: 15336
VIN: 4S4BSACC6J3229325

Features

Convenience: Heated Seats, Keyless Entry
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, CD Player, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Roof Rack
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Stability Control

Reviews

Rome Pre-Owned Auto Sales review

THESE GUYS ARE AMAZING !

THESE GUYS ARE AMAZING !!! I want to Thank you for everything- Matt, Jason and Anthony. You guys went far and beyond expectations. Matt, you are definitely the sweetest guy I ever met. With a sick husband at home, bringing the car to me to test drive is one thing I will never forget. I would go back in a milli-second to buy a car from them again. It's nice to know that humanity still lives in this World. I'll love you guys 4 ever !!!!

2018 Subaru Outback 2.5i Premium review

Awesome, but not perfect.

I think for the most part, I like my car. I have had a couple issues, one of them is probably not the cars fault, (but seeing other people have the same issue, it makes me wonder) I now have 50k miles on it and in that time I have only had to replace the battery and tires, to be expected on a 6 year old car. (and windshield) The windshield is the questionable item. It seemed to crack out of nowhere and I thought I must have gotten a small rock chip while driving down the highway and just didn't see it until it started to crack. So I replaced it at a cost of almost $1000. However, I am on an Outback form and it seems to be a common complaint with outback owners of this year, having the windshield crack out of nowhere. Could it be the frame design? Maybe, but it does seem suspicious that others have had the same issue. One other problem I have had is if I let my car sit unused for like 5 days, the battery goes completely dead. There seems to be a parasitic drain somewhere on the car. It doesn't happen if I drive it every day, but if it sits for about 5 days unused, the battery goes completely dead. I have read it has something to do with the DCS system in the car, but you have to pay the dealer a diagnostic fee to verify. I drive it enough I have not gotten it checked, but next time I am at the dealer I am going to ask them about it.

Vehicle information

Ext. color: Kings Red
Int. color: Cinnamon
Drivetrain: All-wheel Drive
MPG: 22-29
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 2.0L I4 16V GDI DOHC Turbo
Stock #: K4753A
VIN: 3VV2B7AXXNM089248

Features

Convenience: Adaptive Cruise Control, Heated Seats, Keyless Entry, Power Liftgate, Remote Start
Entertainment: Bluetooth®, Satellite Radio
Exterior: Alloy Wheels, Roof Rack
Safety: Backup Camera, Brake Assist, Lane Departure Warning, Rain Sensing Wipers, Stability Control
Seating: Leather Seats

Reviews

LeadCar Honda Yorkville review

Yesterday, I took delivery of my 2026 Honda CR-V Hybrid

Yesterday, I took delivery of my 2026 Honda CR-V Hybrid Sport L and couldn’t be happier! 🚙✨ A huge thank you to Tom Cole, Josh Crannell, and Matt Darling—they were nothing short of amazing throughout the entire process. I had already secured financing with my bank (who I’ve purchased 5 vehicles from), but decided last minute to let their finance manager, Matt Darling, take a shot. I’m so glad I did—he got me an APR 2% lower than my bank! 🙌 The best part? I drove away with the exact vehicle I wanted, without giving up a single option, all while staying within my budget. If you’re in the market for a new ride, look no further than LeadCar Honda. They truly made me feel like family. ❤️

2022 Volkswagen Tiguan 2.0T SE review

A Satisfied User Who Got His Moneys Worth

It's a medium-sized SUV. It's not a Porsche, Audi or MB. It is comfortable, reliable, the size and capacity I sought. In two years I've put on ~24K miles and absolutely no problems. My wife is handicapped and uses a walker. She thought the car was comfortable and we made two round trips from Hartford, CT to Key West. In the last 60 years We've had a Beetle, Passat, and a VW Bus that carried our family of four and 2 Dachshunds aacross the country and back to Connecticut - Twice!

Vehicle information

Ext. color: Burgundy
Int. color: Navy
Drivetrain: All-wheel Drive
MPG: 19-24
Fuel type: Gasoline
Transmission: 8-Speed Automatic
Engine: 3.8L V6 24V GDI DOHC
Stock #: K4616A
VIN: KM8R7DGE1RU670265

Features

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

Reviews

2024 Hyundai PALISADE Calligraphy review

I have had the car for almost three months.

I have had the car for almost three months. I used it when my son’s family and others visited so I often used every seat. I have a Limited Trim with a tow hitch. I got the car for visiting family and also to be able to tow a small to medium sized camper. I have owned many Mercedes, BMW’s, Mini’s and other brands and this is the most luxurious. It is as good or better than the German cars on equipment and comfort, just not as fast. Ventilated seats, three rows of power and heated seats and all the tech you can want, which I love. My favorite is the amazing lane keep assist which practically drives the car by itself and the 360 camera for parking and not hitting things. Try to price a Mercedes or BMW 3-row with the same features and you will be at least $85-90k if not more. You could buy his and hers Palisades for the same money, the Calligraphy even has the massage seats. The car is quiet, smooth and absolutely gorgeous interior. I can afford most any car I want and I personally love the value proposition of this car and the low maintenance costs. The car plays a musical tune every time you close the door like a welcome. All my camping gear fits into the back with room to spare (and third row down). The only quirk is the rain sensing wipers do not seem too sensitive. I don’t mind no wireless Car Play as a plugged in phone stays charged. Once I tow with it I will write another review but if you want this feature know it comes with a hitch, ball, prewired with the wire kit for trailer brakes and a tow mode! That’s pretty cool. Full sized spare, too. If you want luxury, space, lots of seats and good towing capacity run and get one. You don’t need to shop the competition unless it’s the Telluride. I got a great year end deal on mine, too. Hyundai is improving its vehicles every single year. I have had three now (Kona, Tucson and Palisade) and they have all been great. Oh, I have gotten up to 26mpg on the highway but most the time my mileage is exactly like the ratings. As low as teens in the city doing errands. Not bad for a two ton car.

Vehicle information

Ext. color: Fuji White
Int. color: Ebony/Tan Stitch
Drivetrain: All-wheel Drive
MPG: 22-27
Fuel type: Gasoline
Transmission: Automatic
Engine: Ingenium 2L I-4 gasoline direct injection, DOHC, variable valve
Stock #: 15430
VIN: SADCK2GX8LA638862

Features

Convenience: Heated Seats, Heated Steering Wheel, Keyless Entry, Keyless Start, Navigation System, Power Liftgate, Remote Start
Entertainment: Android Auto®, Apple CarPlay®, Bluetooth®, HomeLink, USB Port, WiFi Hotspot
Exterior: Alloy Wheels, Sunroof/Moonroof
Safety: Automatic Emergency Braking, Backup Camera, Brake Assist, Lane Departure Warning, Stability Control
Seating: Leather Seats, Memory Seat

Reviews

Rome Pre-Owned Auto Sales review

The people here are amazing!

The people here are amazing! Rhiannon helped me get a great car. I'm so greatful!

2020 Jaguar F-PACE Prestige P300 AWD Automatic review

The F-Pace is an excellent sporty SUV.

The F-Pace is an excellent sporty SUV. 2.5L engine has been completely trouble free. The suspension on this generation is a bit firmer than the newer generation. The performance and fuel economy is great. The infotainment system allows for apple car play (corded). The F Pace is bigger than other compact SUVs in its class. I wish Jag wasn’t so committed to going all electric because they have taken the Land Rover Velar and made the F-Pace more sporty and luxurious.

About SUVs

FAQs

What is the cheapest SUV available?

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

Which SUV has the best MPG?

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

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

Which SUV has the longest range?

The Cadillac Escalade IQ has the longest range among SUVs and can travel up to 450 miles on a single charge depending on electric motor and battery options.

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

Which automaker has the most SUV deals?

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

Where can I find the most SUV deals?

The most SUV deals can be found near Bridgewater, NY with 218 great deals out of 775 listings starting at $6,250.

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

650 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

Find great prices by city

Find great prices on used SUVs in Columbia, NY

[{"applied_filter_criteria":"{\"bodystyle\":[\"suv\"],\"cpo_indicator\":false,\"max_price_range\":899990,\"min_price_range\":0,\"search_range\":\"30\",\"shippable\":true,\"sort_field\":\"searchRank1\",\"sort_order\":\"desc\",\"stock_type\":\"used\"}","search_type":"general-inventory-search","sponsored_type_eligible":["inventory_ad"],"vehicle_array":[{"cpo_indicator":false,"vin":"5XYPKDA5XHG337341","dealer_zip":"13495","price":"17699","sponsored":false,"sponsored_type":"standard","trim":"SXL","canonical_mmt":"Kia:Sorento:SXL","model":"Sorento","stock_sub":"","interior_color":"Satin Black","cat":"crossover_midsize","cpo_package":null,"customer_id":"5397841","certified_preowned":false,"canonical_mmty":"Kia:Sorento:SXL:2017","badges":["price_drop_in_cents","good_deal","hot_car"],"drivetrain":"All-wheel Drive","exterior_color":"Snow White Pearl","photo_count":33,"seller_type":"dealership","bodystyle":"SUV","msrp":"17699","listing_id":"0398ad14-7307-4cb9-bc8c-99493df1d0eb","nvi_program":false,"dealer_name":"Mastrovito Hyundai","year":"2017","make":"Kia","stock_type":"Used","relevancy_score":null,"vertical_position":1,"fuel_type":"Gasoline","mileage":"73808"},{"cpo_indicator":false,"vin":"5NMP5DGL9SH102083","dealer_zip":"13495","price":"43199","sponsored":false,"sponsored_type":"standard","trim":"Calligraphy","canonical_mmt":"Hyundai:SANTA FE:Calligraphy","model":"SANTA FE","stock_sub":"","interior_color":"Green / Beige","cat":"crossover_midsize","cpo_package":null,"customer_id":"5397841","certified_preowned":false,"canonical_mmty":"Hyundai:SANTA FE:Calligraphy:2025","badges":["great_deal","american_made_index_ranking","2025_award_winner"],"drivetrain":"All-wheel Drive","exterior_color":"White","photo_count":26,"seller_type":"dealership","bodystyle":"SUV","msrp":"43199","listing_id":"26769666-fd04-4108-8612-84589a6db07a","nvi_program":false,"dealer_name":"Mastrovito Hyundai","year":"2025","make":"Hyundai","stock_type":"Used","relevancy_score":null,"vertical_position":2,"fuel_type":"Gasoline","mileage":"7640"},{"cpo_indicator":false,"vin":"KM8R1DHE1NU485501","dealer_zip":"13495","price":"26299","sponsored":false,"sponsored_type":"standard","trim":"SE","canonical_mmt":"Hyundai:PALISADE:SE","model":"PALISADE","stock_sub":"","interior_color":"Black","cat":"crossover_midsize","cpo_package":null,"customer_id":"5397841","certified_preowned":false,"canonical_mmty":"Hyundai:PALISADE:SE:2022","badges":["price_drop_in_cents","good_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Abyss Black Pearl","photo_count":30,"seller_type":"dealership","bodystyle":"SUV","msrp":"26299","listing_id":"2a5a37b8-b27b-467d-a327-293965057dfe","nvi_program":false,"dealer_name":"Mastrovito Hyundai","year":"2022","make":"Hyundai","stock_type":"Used","relevancy_score":null,"vertical_position":3,"fuel_type":"Gasoline","mileage":"55748"},{"cpo_indicator":false,"vin":"JF2SKAEC6PH444931","dealer_zip":"13495","price":"26432","sponsored":false,"sponsored_type":"standard","trim":"Premium","canonical_mmt":"Subaru:Forester:Premium","model":"Forester","stock_sub":"","interior_color":"Gray","cat":"crossover_compact","cpo_package":null,"customer_id":"5380235","certified_preowned":false,"canonical_mmty":"Subaru:Forester:Premium:2023","badges":["great_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Cascade Green Silica","photo_count":30,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"fdc74401-4ce7-4774-a59d-7c1c6226d23f","nvi_program":false,"dealer_name":"Subaru of Utica","year":"2023","make":"Subaru","stock_type":"Used","relevancy_score":null,"vertical_position":4,"fuel_type":"Gasoline","mileage":"33368"},{"cpo_indicator":false,"vin":"4S4BTANC8L3204939","dealer_zip":"13495","price":"21926","sponsored":false,"sponsored_type":"standard","trim":"Limited","canonical_mmt":"Subaru:Outback:Limited","model":"Outback","stock_sub":"","interior_color":"Slate Black","cat":"wagonhatchback_wagon","cpo_package":null,"customer_id":"5380235","certified_preowned":false,"canonical_mmty":"Subaru:Outback:Limited:2020","badges":["price_drop_in_cents","great_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Crystal Black Silica","photo_count":30,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"d731df36-9ca7-47d1-9b6c-9647ea4e6641","nvi_program":false,"dealer_name":"Subaru of Utica","year":"2020","make":"Subaru","stock_type":"Used","relevancy_score":null,"vertical_position":5,"fuel_type":"Gasoline","mileage":"62271"},{"cpo_indicator":false,"vin":"JA4AZ3A34KZ003612","dealer_zip":"13495","price":"15599","sponsored":false,"sponsored_type":"standard","trim":"SE","canonical_mmt":"Mitsubishi:Outlander:SE","model":"Outlander","stock_sub":"","interior_color":"Black","cat":"crossover_compact","cpo_package":null,"customer_id":"5397841","certified_preowned":false,"canonical_mmty":"Mitsubishi:Outlander:SE:2019","badges":["price_drop_in_cents","great_deal"],"drivetrain":"Four-wheel Drive","exterior_color":"Labrador Black Metallic","photo_count":31,"seller_type":"dealership","bodystyle":"SUV","msrp":"15599","listing_id":"4ee745ac-f9bf-4b55-ba53-07f8ea7eead0","nvi_program":false,"dealer_name":"Mastrovito Hyundai","year":"2019","make":"Mitsubishi","stock_type":"Used","relevancy_score":null,"vertical_position":6,"fuel_type":"Gasoline","mileage":"60831"},{"cpo_indicator":false,"vin":"5XYP6DHCXNG233131","dealer_zip":"13495","price":"24599","sponsored":false,"sponsored_type":"standard","trim":"S","canonical_mmt":"Kia:Telluride:S","model":"Telluride","stock_sub":"","interior_color":"Black","cat":"suv_midsize","cpo_package":null,"customer_id":"5397841","certified_preowned":false,"canonical_mmty":"Kia:Telluride:S:2022","badges":["good_deal","2022_award_winner"],"drivetrain":"All-wheel Drive","exterior_color":"Glacial White Pearl","photo_count":28,"seller_type":"dealership","bodystyle":"SUV","msrp":"24599","listing_id":"c6a14b51-fe6b-4236-a931-e87674f01f76","nvi_program":false,"dealer_name":"Mastrovito Hyundai","year":"2022","make":"Kia","stock_type":"Used","relevancy_score":null,"vertical_position":7,"fuel_type":"Gasoline","mileage":"70582"},{"cpo_indicator":false,"vin":"5J8TC2H6XLL023105","dealer_zip":"13495","price":"25499","sponsored":false,"sponsored_type":"standard","trim":"A-Spec","canonical_mmt":"Acura:RDX:A-Spec","model":"RDX","stock_sub":"","interior_color":"Ebony","cat":"luxurysuv_crossover","cpo_package":null,"customer_id":"5397841","certified_preowned":false,"canonical_mmty":"Acura:RDX:A-Spec:2020","badges":["price_drop_in_cents","great_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Apex Blue Pearl","photo_count":34,"seller_type":"dealership","bodystyle":"SUV","msrp":"25499","listing_id":"50fb4514-f282-4653-92d1-6573582bab0f","nvi_program":false,"dealer_name":"Mastrovito Hyundai","year":"2020","make":"Acura","stock_type":"Used","relevancy_score":null,"vertical_position":8,"fuel_type":"Gasoline","mileage":"72393"},{"cpo_indicator":false,"vin":"5N1BT3BB9PC682879","dealer_zip":"13495","price":"23797","sponsored":false,"sponsored_type":"standard","trim":"SV","canonical_mmt":"Nissan:Rogue:SV","model":"Rogue","stock_sub":"","interior_color":"Charcoal","cat":"crossover_compact","cpo_package":null,"customer_id":"5380235","certified_preowned":false,"canonical_mmty":"Nissan:Rogue:SV:2023","badges":["great_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Gun Metallic","photo_count":30,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"85b7dc2c-8f05-4c81-b7d0-2fc5d670bf7e","nvi_program":false,"dealer_name":"Subaru of Utica","year":"2023","make":"Nissan","stock_type":"Used","relevancy_score":null,"vertical_position":9,"fuel_type":"Gasoline","mileage":"18275"},{"cpo_indicator":false,"vin":"JTEBU5JR0J5596010","dealer_zip":"13495","price":"32999","sponsored":false,"sponsored_type":"standard","trim":"SR5","canonical_mmt":"Toyota:4Runner:SR5","model":"4Runner","stock_sub":"","interior_color":"Black Graphite","cat":"suv_midsize","cpo_package":null,"customer_id":"5397841","certified_preowned":false,"canonical_mmty":"Toyota:4Runner:SR5:2018","badges":["fair_deal"],"drivetrain":"Four-wheel Drive","exterior_color":"Classic Silver Metallic","photo_count":30,"seller_type":"dealership","bodystyle":"SUV","msrp":"32999","listing_id":"8a340619-dfe8-4849-b388-0c63a1ecc021","nvi_program":false,"dealer_name":"Mastrovito Hyundai","year":"2018","make":"Toyota","stock_type":"Used","relevancy_score":null,"vertical_position":10,"fuel_type":"Gasoline","mileage":"86098"},{"cpo_indicator":false,"vin":"5NMS2DAJXNH415139","dealer_zip":"13501","price":"22990","sponsored":false,"sponsored_type":"standard","trim":"SEL 2.4","canonical_mmt":"Hyundai:SANTA FE:SEL 2.4","model":"SANTA FE","stock_sub":"","interior_color":"Black","cat":"crossover_midsize","cpo_package":null,"customer_id":"184676","certified_preowned":false,"canonical_mmty":"Hyundai:SANTA FE:SEL 2.4:2022","badges":["great_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Portofino Gray","photo_count":33,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"d076162e-2948-45f2-878c-7d836b6e75c0","nvi_program":false,"dealer_name":"Nimey's New Generation Cars","year":"2022","make":"Hyundai","stock_type":"Used","relevancy_score":null,"vertical_position":11,"fuel_type":"Gasoline","mileage":"28369"},{"cpo_indicator":true,"vin":"JF2SKAMC4PH486290","dealer_zip":"13502","price":"28615","sponsored":true,"sponsored_type":"standard","trim":"Wilderness","canonical_mmt":"Subaru:Forester:Wilderness","model":"Forester","stock_sub":"","interior_color":"Gray","cat":"crossover_compact","cpo_package":"Ford Blue Advantage Blue","customer_id":"199719","certified_preowned":true,"canonical_mmty":"Subaru:Forester:Wilderness:2023","badges":["price_drop_in_cents","good_deal","cpo"],"drivetrain":"All-wheel Drive","exterior_color":"Crystal White Pearl","photo_count":22,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"78a6a218-ce12-4503-94f5-787a7e5c29a9","nvi_program":false,"dealer_name":"Don's Ford","year":"2023","make":"Subaru","stock_type":"Used","relevancy_score":null,"vertical_position":12,"fuel_type":"Gasoline","mileage":"33607"},{"cpo_indicator":false,"vin":"1C4RJHAG4PC607011","dealer_zip":"13495","price":"30544","sponsored":false,"sponsored_type":"standard","trim":"Altitude","canonical_mmt":"Jeep:Grand Cherokee:Altitude","model":"Grand Cherokee","stock_sub":"","interior_color":"Global Black","cat":"suv_midsize","cpo_package":null,"customer_id":"6285","certified_preowned":false,"canonical_mmty":"Jeep:Grand Cherokee:Altitude:2023","badges":["price_drop_in_cents","good_deal","2023_award_winner"],"drivetrain":"Four-wheel Drive","exterior_color":"Baltic Gray Metallic Clearcoat","photo_count":26,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"3ebef76f-7b24-45d7-bc94-075c621dbef5","nvi_program":false,"dealer_name":"Chrysler Dodge Jeep RAM of Utica","year":"2023","make":"Jeep","stock_type":"Used","relevancy_score":null,"vertical_position":13,"fuel_type":"Gasoline","mileage":"44920"},{"cpo_indicator":false,"vin":"3VV4B7AX2NM176148","dealer_zip":"13495","price":"25321","sponsored":false,"sponsored_type":"standard","trim":"2.0T SEL R-Line 4MOTION","canonical_mmt":"Volkswagen:Tiguan:2.0T SEL R-Line 4MOTION","model":"Tiguan","stock_sub":"","interior_color":"Titan Black","cat":"crossover_compact","cpo_package":null,"customer_id":"6285","certified_preowned":false,"canonical_mmty":"Volkswagen:Tiguan:2.0T SEL R-Line 4MOTION:2022","badges":["price_drop_in_cents","fair_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Platinum Gray Metallic","photo_count":26,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"7871b21c-0167-4887-bd50-ab155c9f0c62","nvi_program":false,"dealer_name":"Chrysler Dodge Jeep RAM of Utica","year":"2022","make":"Volkswagen","stock_type":"Used","relevancy_score":null,"vertical_position":14,"fuel_type":"Gasoline","mileage":"27797"},{"cpo_indicator":false,"vin":"JN8AT3AB3MW206739","dealer_zip":"13440","price":"20100","sponsored":false,"sponsored_type":"standard","trim":"S","canonical_mmt":"Nissan:Rogue:S","model":"Rogue","stock_sub":"","interior_color":"Charcoal","cat":"crossover_compact","cpo_package":null,"customer_id":"194537","certified_preowned":false,"canonical_mmty":"Nissan:Rogue:S:2021","badges":["price_drop_in_cents","good_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Gun Metallic","photo_count":27,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"7f2b1ccb-8425-4701-84a4-2767ec6d9047","nvi_program":false,"dealer_name":"Rome Pre-Owned Auto Sales","year":"2021","make":"Nissan","stock_type":"Used","relevancy_score":null,"vertical_position":15,"fuel_type":"Gasoline","mileage":"54819"},{"cpo_indicator":false,"vin":"JM3KFBCMXN1590282","dealer_zip":"13501","price":"24249","sponsored":false,"sponsored_type":"standard","trim":"2.5 S Preferred Package","canonical_mmt":"Mazda:CX-5:2.5 S Preferred Package","model":"CX-5","stock_sub":"","interior_color":"Black","cat":"crossover_compact","cpo_package":null,"customer_id":"184676","certified_preowned":false,"canonical_mmty":"Mazda:CX-5:2.5 S Preferred Package:2022","badges":["good_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Soul Red Crystal Metallic","photo_count":33,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"a94812a2-6e73-4928-b806-61f64fe6d400","nvi_program":false,"dealer_name":"Nimey's New Generation Cars","year":"2022","make":"Mazda","stock_type":"Used","relevancy_score":null,"vertical_position":16,"fuel_type":"Gasoline","mileage":"36156"},{"cpo_indicator":false,"vin":"4S4BSACC6J3229325","dealer_zip":"13440","price":"17388","sponsored":false,"sponsored_type":"standard","trim":"2.5i Premium","canonical_mmt":"Subaru:Outback:2.5i Premium","model":"Outback","stock_sub":"","interior_color":"Slate Black","cat":"wagonhatchback_wagon","cpo_package":null,"customer_id":"194537","certified_preowned":false,"canonical_mmty":"Subaru:Outback:2.5i Premium:2018","badges":["fair_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Twilight Blue Metallic","photo_count":23,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"2962e70e-d1b7-4058-9f41-7dc13a84147a","nvi_program":false,"dealer_name":"Rome Pre-Owned Auto Sales","year":"2018","make":"Subaru","stock_type":"Used","relevancy_score":null,"vertical_position":17,"fuel_type":"Gasoline","mileage":"86175"},{"cpo_indicator":false,"vin":"3VV2B7AXXNM089248","dealer_zip":"13495","price":"19074","sponsored":false,"sponsored_type":"standard","trim":"2.0T SE","canonical_mmt":"Volkswagen:Tiguan:2.0T SE","model":"Tiguan","stock_sub":"","interior_color":"Cinnamon","cat":"crossover_compact","cpo_package":null,"customer_id":"6050525","certified_preowned":false,"canonical_mmty":"Volkswagen:Tiguan:2.0T SE:2022","badges":["price_drop_in_cents","great_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Kings Red","photo_count":35,"seller_type":"dealership","bodystyle":"SUV","msrp":null,"listing_id":"19c3be06-bfc6-4e8c-84bf-39aea2f797c8","nvi_program":false,"dealer_name":"LeadCar Honda Yorkville","year":"2022","make":"Volkswagen","stock_type":"Used","relevancy_score":null,"vertical_position":18,"fuel_type":"Gasoline","mileage":"68680"},{"cpo_indicator":false,"vin":"KM8R7DGE1RU670265","dealer_zip":"13495","price":"38798","sponsored":false,"sponsored_type":"standard","trim":"Calligraphy","canonical_mmt":"Hyundai:PALISADE:Calligraphy","model":"PALISADE","stock_sub":"","interior_color":"Navy","cat":"crossover_midsize","cpo_package":null,"customer_id":"6050525","certified_preowned":false,"canonical_mmty":"Hyundai:PALISADE:Calligraphy:2024","badges":["fair_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Burgundy","photo_count":34,"seller_type":"dealership","bodystyle":"SUV","msrp":null,"listing_id":"28d25139-4f10-4a7f-bc48-ca8949dc354e","nvi_program":false,"dealer_name":"LeadCar Honda Yorkville","year":"2024","make":"Hyundai","stock_type":"Used","relevancy_score":null,"vertical_position":19,"fuel_type":"Gasoline","mileage":"16348"},{"cpo_indicator":false,"vin":"SADCK2GX8LA638862","dealer_zip":"13440","price":"20500","sponsored":false,"sponsored_type":"standard","trim":"Prestige P300 AWD Automatic","canonical_mmt":"Jaguar:F-PACE:Prestige P300 AWD Automatic","model":"F-PACE","stock_sub":"","interior_color":"Ebony/Tan Stitch","cat":"luxurysuv_crossover","cpo_package":null,"customer_id":"194537","certified_preowned":false,"canonical_mmty":"Jaguar:F-PACE:Prestige P300 AWD Automatic:2020","badges":["price_drop_in_cents","good_deal"],"drivetrain":"All-wheel Drive","exterior_color":"Fuji White","photo_count":31,"seller_type":"dealership","bodystyle":"SUV","msrp":"0","listing_id":"081999b2-f56a-44ee-8f5b-c61a2a5c601d","nvi_program":false,"dealer_name":"Rome Pre-Owned Auto Sales","year":"2020","make":"Jaguar","stock_type":"Used","relevancy_score":null,"vertical_position":20,"fuel_type":"Gasoline","mileage":"78235"}]}]