{"id":3735967,"vin":"LRBFZPE45RD015795","dealer_id":5897,"year":2024,"make":"Buick","model":"Envision","trim":"Essence","price":33499,"mileage":13675,"exterior_color":"Color","interior_color":"Color","stock_number":"photos","listing_url":"https://cars.rootz.global/vehicle/LRBFZPE45RD015795","condition":"used","status":"active","body_type":"Sport Utility Vehicle [SUV]/Multipurpose Vehicle [MPV]","engine":null,"engine_cylinders":4,"engine_displacement":2,"transmission":null,"drivetrain":"AWD/All-Wheel Drive","fuel_type":"Gasoline","mpg_city":null,"mpg_highway":null,"doors":4,"seats":null,"recall_count":0,"complaint_count":0,"nhtsa_enriched_at":"2026-06-22 00:31:36","detail_scraped_at":"2026-06-06 07:44:44","first_seen":"2026-05-28 06:17:09","last_seen":"2026-06-25 06:36:23","created_at":"2026-05-28 06:17:09","updated_at":"2026-06-25 06:36:23","mpg_city_scraped":22,"mpg_highway_scraped":28,"dealer_fees":699,"dealer_fees_detail":"[{\"amount\":699,\"label\":\"$699 dealer\"}]","features":null,"description":"Remainder of factory warranty applies to this low mileage beauty!!!!!, REMAINING FACTORY POWERTRAIN WARRANTY APPLIES!!!!, Envision Sport Touring, 4D Sport Utility, AWD. We are located in Mesa at u.S. 60 and Superstition Springs boulevard. Clean CARFAX. Recent Arrival! 22/28 City/Highway MPG","carfax_url":"https://www.carfax.com/vehiclehistory/ar20/5mpOTZUZEqfgH_IcJSqxzcsGQBPR7GL1r22jTMv6gsoNeC44yUT1eGpoU_TgsPo6Qol7LB9DP7oKLjWHMOVs2uB-n1hRboq9BPE","num_owners":null,"accident_free":1,"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":"North Corpus Christi Honda","dealer_city":"CORPUS CHRISTI","dealer_state":"TX","dealer_zip":"78410","dealer_phone":"(361) 248-3600","dealer_website":"https://www.supershonda.com","photos":[],"recalls":[]}