{"id":117698,"vin":"5FPYK3F74SB035056","dealer_id":6173,"year":2025,"make":"Honda","model":"Ridgeline","trim":"TrailSport","price":42155,"mileage":1830,"exterior_color":"Crystal Black Pearl","interior_color":"Black","stock_number":"HP0627","listing_url":"https://www.shottenkirk.com/vehicle/Used/2025/Honda/Ridgeline/5FPYK3F74SB035056/","condition":"used","status":"active","body_type":"Pickup","engine":"3.5","engine_cylinders":6,"engine_displacement":3.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:01:12","detail_scraped_at":"2026-06-18 07:59:25","first_seen":"2026-05-05 00:42:28","last_seen":"2026-06-25 06:41:50","created_at":"2026-05-05 00:42:28","updated_at":"2026-06-25 06:41:50","mpg_city_scraped":null,"mpg_highway_scraped":null,"dealer_fees":1948,"dealer_fees_detail":"[{\"amount\":899,\"label\":\"$899.00 dealer\"},{\"amount\":150,\"label\":\"$150.00 dealer\"},{\"amount\":899,\"label\":\"$899.00 dealer\"}]","features":null,"description":"Used 2025 Honda Ridgeline TrailSport+ in West Burlington IA | 5FPYK3F74SB035056 on Shottenkirk Automotive Group","carfax_url":null,"num_owners":null,"accident_free":null,"certified":1,"warranty":"warranty-font-size-two,\n        .total-savings,\n        .map_title_bottom {\n            color: #bf1b21;\n        }\n\n        .google-box-container-left-bottom,\n        .box-three-container,\n        .box","dealer_name":"Shottenkirk Toyota Weatherford","dealer_city":"HUDSON OAKS","dealer_state":"TX","dealer_zip":"76087","dealer_phone":null,"dealer_website":"https://www.shottenkirk.com","photos":[{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0fbea004-515c-4a74-9ce1-1dbeb1478299.jpg","position":0},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0fbea004-515c-4a74-9ce1-1dbeb1478299.jpg","position":0},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/939fafea-b0e0-4fdb-a101-71355cafb072.jpg","position":1},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/939fafea-b0e0-4fdb-a101-71355cafb072.jpg","position":1},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/8575d0d8-ec38-4b31-bcd7-1399a4ab2ef2.jpg","position":2},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/8575d0d8-ec38-4b31-bcd7-1399a4ab2ef2.jpg","position":2},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d2eb938b-5bb2-45f3-b439-bc16301e2736.jpg","position":3},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d2eb938b-5bb2-45f3-b439-bc16301e2736.jpg","position":3},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0bfdf2cd-95bd-4a3c-ba29-0274a7e65ddd.jpg","position":4},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0bfdf2cd-95bd-4a3c-ba29-0274a7e65ddd.jpg","position":4},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/894b445d-e79c-4345-b4a7-399b1124decb.jpg","position":5},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/894b445d-e79c-4345-b4a7-399b1124decb.jpg","position":5},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/fe3d0994-6dc9-4f75-a36c-d1e29a1818a3.jpg","position":6},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/fe3d0994-6dc9-4f75-a36c-d1e29a1818a3.jpg","position":6},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/9689f615-cf52-4d4b-be84-a1f42b5b48a7.jpg","position":7},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/9689f615-cf52-4d4b-be84-a1f42b5b48a7.jpg","position":7},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/f81e2fbe-ca64-46e3-a0ca-7b081aa012b7.jpg","position":8},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/f81e2fbe-ca64-46e3-a0ca-7b081aa012b7.jpg","position":8},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ab140f22-ef35-4c63-9db1-c45ef21656f8.jpg","position":9},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ab140f22-ef35-4c63-9db1-c45ef21656f8.jpg","position":9},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/45d547c5-1d42-4fca-b375-ca0cc05d0e02.jpg","position":10},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/45d547c5-1d42-4fca-b375-ca0cc05d0e02.jpg","position":10},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/f5a87734-fae7-4a9c-994f-f75469d98962.jpg","position":11},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/f5a87734-fae7-4a9c-994f-f75469d98962.jpg","position":11},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/3e8606b3-2e0e-411f-a7dc-71986bcf1112.jpg","position":12},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/3e8606b3-2e0e-411f-a7dc-71986bcf1112.jpg","position":12},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ce165a59-c070-4674-bf60-32cb96ac8f00.jpg","position":13},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ce165a59-c070-4674-bf60-32cb96ac8f00.jpg","position":13},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/b97a782c-8bbe-4fa5-9ec7-1f0c1144e52e.jpg","position":14},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/b97a782c-8bbe-4fa5-9ec7-1f0c1144e52e.jpg","position":14},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ffbbacd7-9dd8-4032-b122-7c1a730b5922.jpg","position":15},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ffbbacd7-9dd8-4032-b122-7c1a730b5922.jpg","position":15},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/cede82fb-64b5-4a67-a282-8838a72ae6e0.jpg","position":16},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/cede82fb-64b5-4a67-a282-8838a72ae6e0.jpg","position":16},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/2c39098c-2387-4383-a11d-a7c28c807043.jpg","position":17},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/2c39098c-2387-4383-a11d-a7c28c807043.jpg","position":17},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d3463b6b-a3f8-45a5-9424-03860e85bb40.jpg","position":18},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d3463b6b-a3f8-45a5-9424-03860e85bb40.jpg","position":18},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/803b6379-2fce-46a4-96f6-28fb430af24a.jpg","position":19},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/803b6379-2fce-46a4-96f6-28fb430af24a.jpg","position":19},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/5de8a7cd-0199-4b30-a887-58a928b91d14.jpg","position":20},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/5de8a7cd-0199-4b30-a887-58a928b91d14.jpg","position":20},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/6a6eb383-7b43-4d79-8e2b-70b68316f347.jpg","position":21},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/6a6eb383-7b43-4d79-8e2b-70b68316f347.jpg","position":21},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/49a34637-b946-48c4-91a8-3fc20564104a.jpg","position":22},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/49a34637-b946-48c4-91a8-3fc20564104a.jpg","position":22},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c50923b1-f30c-4ee9-9aaf-4c6fbba19a19.jpg","position":23},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c50923b1-f30c-4ee9-9aaf-4c6fbba19a19.jpg","position":23},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/97a95342-7e5a-4681-881d-880085ea8ed6.jpg","position":24},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/97a95342-7e5a-4681-881d-880085ea8ed6.jpg","position":24},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/48c1c68d-77c7-475d-a908-effa6bde8066.jpg","position":25},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/48c1c68d-77c7-475d-a908-effa6bde8066.jpg","position":25},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/cd7d5b4f-c6d4-44a2-8243-eb959509efa1.jpg","position":26},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/cd7d5b4f-c6d4-44a2-8243-eb959509efa1.jpg","position":26},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/29d96eed-5af8-4de5-9aa1-9675e94edcba.jpg","position":27},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/29d96eed-5af8-4de5-9aa1-9675e94edcba.jpg","position":27},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/4f411c31-7066-4f35-a32e-0aa11cb29690.jpg","position":28},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/4f411c31-7066-4f35-a32e-0aa11cb29690.jpg","position":28},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/37bf4a10-36ff-4ab0-bd0c-e6906e116394.jpg","position":29},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/37bf4a10-36ff-4ab0-bd0c-e6906e116394.jpg","position":29},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/fa0aad44-2dc3-4066-82f1-3b55eb558cc2.jpg","position":30},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/fa0aad44-2dc3-4066-82f1-3b55eb558cc2.jpg","position":30},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/2685f4e8-8166-4cad-b9e0-d1df425f7322.jpg","position":31},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/2685f4e8-8166-4cad-b9e0-d1df425f7322.jpg","position":31},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0cb62be3-f995-4fb1-872e-deba93b3b9d6.jpg","position":32},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0cb62be3-f995-4fb1-872e-deba93b3b9d6.jpg","position":32},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/547ffca9-1bc7-43fc-b3e7-c5352f98a768.jpg","position":33},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/547ffca9-1bc7-43fc-b3e7-c5352f98a768.jpg","position":33},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0c083659-be38-4364-8730-d1bc395a9484.jpg","position":34},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0c083659-be38-4364-8730-d1bc395a9484.jpg","position":34},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d736c0ad-582d-45e8-a883-3283ade847a4.jpg","position":35},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d736c0ad-582d-45e8-a883-3283ade847a4.jpg","position":35},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/31598663-afd3-4ca7-bbe0-7359183f9299.jpg","position":36},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/31598663-afd3-4ca7-bbe0-7359183f9299.jpg","position":36},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0351584c-fa61-46e7-a4af-2880fd1db099.jpg","position":37},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0351584c-fa61-46e7-a4af-2880fd1db099.jpg","position":37}],"recalls":[]}