{"id":2827426,"vin":"JM3KFBBLXR0443934","dealer_id":6473,"year":2024,"make":"Mazda","model":"Cx-5","trim":"Select Package","price":21500,"mileage":80869,"exterior_color":"Color","interior_color":"Color","stock_number":"Stock","listing_url":"https://cars.rootz.global/vehicle/JM3KFBBLXR0443934","condition":"used","status":"active","body_type":"Sport Utility Vehicle [SUV]/Multipurpose Vehicle [MPV]","engine":null,"engine_cylinders":4,"engine_displacement":2.5,"transmission":"Automatic","drivetrain":"4WD/4-Wheel Drive/4x4","fuel_type":"Gasoline","mpg_city":null,"mpg_highway":null,"doors":null,"seats":null,"recall_count":0,"complaint_count":0,"nhtsa_enriched_at":"2026-06-22 00:21:13","detail_scraped_at":"2026-06-02 07:25:56","first_seen":"2026-05-21 06:42:38","last_seen":"2026-06-25 06:35:33","created_at":"2026-05-21 06:42:38","updated_at":"2026-06-25 06:35:33","mpg_city_scraped":null,"mpg_highway_scraped":null,"dealer_fees":1174,"dealer_fees_detail":"[{\"amount\":587,\"label\":\"$587 admin\"},{\"amount\":587,\"label\":\"$587 admin\"}]","features":null,"description":"Welcome to Subaru of Columbia! Let’s make your next car buying experience not only exciting, but simple. Our upfront & hassle free approach gives all of our customers the ability to purchase with confidence and ease. You can expect: Invoice pricing on new Subaru, great trade in values, and flexible financing that fits your budget. While offering New and Pre-Owned vehicles, we are committed to building life long relationships and servicing the Columbia, Jefferson City, and Central Missouri area. Our Subaru family is here and excited to help with all of your automotive needs! Make sure to contact us about our incredibly low New Subaru lease payments or New & Certified Pre-Owned Subaru special financing. Visit us today at 1200 Interstate 70 Dr SW, Columbia, MO 65203 or call us at 573-993-3400. Also, follow us on Facebook and TikTok for all of our latest promotions, specials, and Subaru of Columbia content! 2024 Mazda CX-5 2.5 S Select Package Jet Black Mica SKYACTIV®-G 2.5L 4-Cylinder DOHC 16V 6-Speed Automatic AWD 4-Wheel Disc Brakes, 4.624 Axle Ratio, 6 Speakers, ABS brakes, Air Conditioning, Alloy wheels, AM/FM radio, AppLink/Apple CarPlay and Android Auto, Auto High-beam Headlights, Automatic temperature control, Bumpers: body-color, Delay-off headlights, Driver door bin, Driver vanity mirror, Dual front impact airbags, Dual front side impact airbags, E911 Automatic Emergency Notification, Electronic Stability Control, Emergency communication system: MAZDA CONNECT, Exterior Parking Camera Rear, Four wheel independent suspension, Front anti-roll bar, Front Bucket Seats, Front Center Armrest w/Storage, Front dual zone A/C, Front reading lights, Fully automatic headlights, Heated Front Bucket Seats, Heated front seats, Illuminated entry, Infotainment System Voice Command, Leather Shift Knob, Leather steering wheel, Leatherette Seat Trim, Low tire pressure warning, Multifunction Commander Control, Occupant sensing airbag, Outside temperature display, Overhead airbag, O","carfax_url":null,"num_owners":null,"accident_free":null,"certified":1,"warranty":"warranty{background-color:#fff;-webkit-box-shadow:0 0 15px 0 rgba(0,0,0,.07);box-shadow:0 0 15px 0 rgba(0,0,0,.07);padding:2.29em 1.43em}.warranty--rounded{border-radius:.36em}@media (min-width:992px)","dealer_name":"Columbia Honda","dealer_city":"Columbia","dealer_state":"MD","dealer_zip":null,"dealer_phone":null,"dealer_website":"https://www.columbiahonda.com","photos":[],"recalls":[]}