{"id":118122,"vin":"3C6UR5DL1TG307290","dealer_id":6173,"year":2026,"make":"Ram","model":"2500","trim":"Big Horn","price":74266,"mileage":36000,"exterior_color":"Granite Crystal Metallic Clearcoat","interior_color":"Black","stock_number":"TG307290","listing_url":"https://www.shottenkirk.com/vehicle/New/2026/Ram/2500/3C6UR5DL1TG307290/","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-06-18 08:01:35","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 | 3C6UR5DL1TG307290 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/7162a646-e2dd-4568-8b7d-c788766c5f6c.jpg","position":0},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/7162a646-e2dd-4568-8b7d-c788766c5f6c.jpg","position":0},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/035fc9fc-2aa7-4909-ab2f-21b9d5010c39.jpg","position":1},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/035fc9fc-2aa7-4909-ab2f-21b9d5010c39.jpg","position":1},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/714c7a17-ad9b-472b-bb58-079df7a7c892.jpg","position":2},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/714c7a17-ad9b-472b-bb58-079df7a7c892.jpg","position":2},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0f9fb5c4-d894-4a3c-a34c-8c2f86fa3fe1.jpg","position":3},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0f9fb5c4-d894-4a3c-a34c-8c2f86fa3fe1.jpg","position":3},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a9254c7f-7e47-489b-808f-e13e448e3850.jpg","position":4},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a9254c7f-7e47-489b-808f-e13e448e3850.jpg","position":4},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/e418a6a8-e043-4f8b-88f0-1ddfed8e6539.jpg","position":5},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/e418a6a8-e043-4f8b-88f0-1ddfed8e6539.jpg","position":5},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/215f20f4-ab6f-42d3-9fc0-14c23f6599a8.jpg","position":6},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/215f20f4-ab6f-42d3-9fc0-14c23f6599a8.jpg","position":6},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/7afd279e-e7b9-4895-9994-a770cc89e48e.jpg","position":7},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/7afd279e-e7b9-4895-9994-a770cc89e48e.jpg","position":7},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/7b09577b-00da-4d61-9c26-66d3b16aeea0.jpg","position":8},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/7b09577b-00da-4d61-9c26-66d3b16aeea0.jpg","position":8},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/52b4a871-2e9e-47ad-8405-3c5072af9ba7.jpg","position":9},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/52b4a871-2e9e-47ad-8405-3c5072af9ba7.jpg","position":9},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/9dc51e3d-4c9b-4ad3-a1ab-1fc510bfc93d.jpg","position":10},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/9dc51e3d-4c9b-4ad3-a1ab-1fc510bfc93d.jpg","position":10},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/c5f7b7bc-ead6-4ef5-b254-661157458127.jpg","position":11},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/c5f7b7bc-ead6-4ef5-b254-661157458127.jpg","position":11},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/389fd040-f973-445e-b07b-8f9cae22fa0d.jpg","position":12},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/389fd040-f973-445e-b07b-8f9cae22fa0d.jpg","position":12},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/99db5b89-03c0-4fe1-8c49-f4a87987f3a0.jpg","position":13},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/99db5b89-03c0-4fe1-8c49-f4a87987f3a0.jpg","position":13},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/4c6b8d8c-6229-470e-82f9-73ca8916e115.jpg","position":14},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/4c6b8d8c-6229-470e-82f9-73ca8916e115.jpg","position":14},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/95651851-5e5c-446c-b2a5-bb018f792f4c.jpg","position":15},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/95651851-5e5c-446c-b2a5-bb018f792f4c.jpg","position":15},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/3184d9b3-a8fd-4a71-853e-a54774f2e157.jpg","position":16},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/3184d9b3-a8fd-4a71-853e-a54774f2e157.jpg","position":16},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/dad690e8-8259-4cc9-b078-cad1013c806e.jpg","position":17},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/dad690e8-8259-4cc9-b078-cad1013c806e.jpg","position":17},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5a265056-fe33-476d-9b97-8c31dea03cb8.jpg","position":18},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5a265056-fe33-476d-9b97-8c31dea03cb8.jpg","position":18},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0e579b6e-a534-4dbc-8509-0697a8a88efb.jpg","position":19},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0e579b6e-a534-4dbc-8509-0697a8a88efb.jpg","position":19},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/c6930d09-76fd-493b-8589-08a894550917.jpg","position":20},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/c6930d09-76fd-493b-8589-08a894550917.jpg","position":20},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/10b9a077-9439-4dd1-bddb-1f2721283e79.jpg","position":21},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/10b9a077-9439-4dd1-bddb-1f2721283e79.jpg","position":21},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b94d57c1-a953-45e2-afdd-335030a4cf57.jpg","position":22},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b94d57c1-a953-45e2-afdd-335030a4cf57.jpg","position":22},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/ace31807-169c-4878-b80a-6b33edb9a82f.jpg","position":23},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/ace31807-169c-4878-b80a-6b33edb9a82f.jpg","position":23},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/3d4f435c-99c9-4f93-8557-b3a8d5d11989.jpg","position":24},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/3d4f435c-99c9-4f93-8557-b3a8d5d11989.jpg","position":24},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/708a5bfb-fdee-478e-aa19-5563aafe7dd0.jpg","position":25},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/708a5bfb-fdee-478e-aa19-5563aafe7dd0.jpg","position":25},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/bd9939d9-fa73-486e-b709-057253b06ec7.jpg","position":26},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/bd9939d9-fa73-486e-b709-057253b06ec7.jpg","position":26},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/ae3c6e62-9010-40d6-b946-702ba409de18.jpg","position":27},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/ae3c6e62-9010-40d6-b946-702ba409de18.jpg","position":27},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/738ff00f-60f8-4a2e-a94a-51ecf485ebad.jpg","position":28},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/738ff00f-60f8-4a2e-a94a-51ecf485ebad.jpg","position":28},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/23629f97-cadf-4bda-9421-1b92b298c6b5.jpg","position":29},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/23629f97-cadf-4bda-9421-1b92b298c6b5.jpg","position":29}],"recalls":[]}