{"id":118127,"vin":"3C6UR5DL3TG307291","dealer_id":6173,"year":2026,"make":"Ram","model":"2500","trim":"Big Horn","price":67591,"mileage":36000,"exterior_color":"Bright White Clearcoat","interior_color":"Black","stock_number":"TG307291","listing_url":"https://www.shottenkirk.com/vehicle/New/2026/Ram/2500/3C6UR5DL3TG307291/","condition":"new","status":"active","body_type":"Pickup","engine":"6.7","engine_cylinders":6,"engine_displacement":6.7,"transmission":"Automatic","drivetrain":"4WD/4-Wheel Drive/4x4","fuel_type":"Diesel","mpg_city":null,"mpg_highway":null,"doors":null,"seats":null,"recall_count":0,"complaint_count":0,"nhtsa_enriched_at":"2026-06-21 23:40:07","detail_scraped_at":"2026-05-08 03:22:29","first_seen":"2026-05-05 00:42:31","last_seen":"2026-06-25 06:41:50","created_at":"2026-05-05 00:42:31","updated_at":"2026-06-25 06:41:50","mpg_city_scraped":null,"mpg_highway_scraped":null,"dealer_fees":null,"dealer_fees_detail":null,"features":null,"description":"New 2026 Ram 2500 Big Horn in West Burlington IA | 3C6UR5DL3TG307291 on Shottenkirk Automotive Group","carfax_url":null,"num_owners":null,"accident_free":null,"certified":null,"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/1024x1024/common-vehicle-media/66ca5e7c-894e-47d1-aa5f-5e3cba4643ec.jpg","position":0},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/70869e5e-2779-475d-8458-2b40c6c9afaa.jpg","position":1},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/bd7b2887-e87d-427a-a2b4-64b3e50c83ae.jpg","position":2},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/4af675be-7cd2-42fd-a2f3-fa48c2ef34b3.jpg","position":3},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/53e1fbe9-16f7-4ae3-b9c8-d08777391f18.jpg","position":4},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/eb5f2085-2e6f-44dc-b416-b00901ab509d.jpg","position":5},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/6c908621-0e37-4021-91e7-9332cc26b8f2.jpg","position":6},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/824d930b-721a-4926-8845-511d3a3dcad4.jpg","position":7},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/6b674814-b370-4bf8-9bcd-ed591cc78080.jpg","position":8},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/75390c72-d736-46a3-b351-8f23127bf900.jpg","position":9},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/101185f0-e2a0-41db-9d74-ded285fa0ed6.jpg","position":10},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5d0c8948-a1ef-4dc1-8a32-38ddfb77e7c9.jpg","position":11},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0c964892-6a2e-45e7-976a-dd3dd9201be8.jpg","position":12},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b5223073-38c1-4a69-b4cc-f48cd2ba4c08.jpg","position":13},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/548e183e-b19e-4ee1-8116-97b8c42826ee.jpg","position":14},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/37a45b7a-ce07-4e9d-bbcb-6740c585c2dc.jpg","position":15},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/62f48d08-951b-4cbf-bf0f-539a48fd0d02.jpg","position":16},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/97ba57b8-b1b1-4e32-9de2-cd788b5c1c9e.jpg","position":17},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/731c047a-980e-4196-85bf-fe8677a54d6b.jpg","position":18},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b74de9d2-d858-4f35-a53c-4a59d78aa449.jpg","position":19},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/01ad9efe-8e38-4f97-abd8-57a4310e14e8.jpg","position":20},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/88e1be5a-1869-41fa-9014-90236087082f.jpg","position":21},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/75417851-f6fe-4552-b58b-e81b99e2211a.jpg","position":22},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/497e3b9b-9bab-49a3-aff3-f97e605aef60.jpg","position":23},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/cb2d5f57-0ecb-455c-a87f-d692aeb2026c.jpg","position":24},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/37834143-7ee6-4f88-bea8-55ae64be2dfa.jpg","position":25},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/3f0a97a5-444d-4923-8eac-b33fddb4665e.jpg","position":26},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/6cc8b515-91e6-477c-a428-8279c3ff9d18.jpg","position":27},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/6ab31492-fdc2-451a-946c-9510890a652e.jpg","position":28},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/ed1344c4-fee7-4b5f-8769-ef64c55782fe.jpg","position":29}],"recalls":[]}