{"id":4132670,"vin":"3MZBPACL8LM116982","dealer_id":6473,"year":2020,"make":"Mazda","model":"Mazda3","trim":null,"price":15800,"mileage":74984,"exterior_color":"Color","interior_color":"Color","stock_number":"Stock","listing_url":"https://cars.rootz.global/vehicle/3MZBPACL8LM116982","condition":"used","status":"sold","body_type":"Sedan/Saloon","engine":null,"engine_cylinders":4,"engine_displacement":2.5,"transmission":"Automatic","drivetrain":"4x2","fuel_type":"Gasoline","mpg_city":null,"mpg_highway":null,"doors":4,"seats":null,"recall_count":0,"complaint_count":0,"nhtsa_enriched_at":"2026-06-21 23:45:28","detail_scraped_at":"2026-06-08 07:49:01","first_seen":"2026-05-30 06:45:34","last_seen":"2026-06-25 06:33:17","created_at":"2026-05-30 06:45:34","updated_at":"2026-06-25 06:38:09","mpg_city_scraped":26,"mpg_highway_scraped":35,"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! 2020 Mazda Mazda3 Select Snowflake White Pearl SKYACTIV®-G 2.5L 4-Cylinder DOHC 16V 6-Speed Automatic FWD 18 x 7J Alloy Wheels, 4-Wheel Disc Brakes, 8 Speakers, ABS brakes, Air Conditioning, Alloy wheels, AM/FM radio, AppLink/Apple CarPlay and Android Auto, Auto High-beam Headlights, Automatic temperature control, Blind Spot Monitoring w/Rear Cross Traffic Alert, Brake assist, Bumpers: body-color, Compass, Delay-off headlights, Driver door bin, Driver vanity mirror, Dual front impact airbags, Dual front side impact airbags, Dual Zone Automatic Climate Control, Electronic Stability Control, Emergency communication system: MAZDA CONNECT, Exterior Parking Camera Rear, Front anti-roll bar, Front Bucket Seats, Front Center Armrest, Front dual zone A/C, Front reading lights, Front wheel independent suspension, Fully automatic headlights, Illuminated entry, Knee airbag, Leather Shift Knob, Leather Steering Wheel & Shift Knob, Leatherette Seat Trim, Low tire pressure warning, Mazda Advanced Keyless Entry, Occupant sensing airbag, Outside temperature display, Overhead airbag,","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":[]}