{"id":118125,"vin":"3C6UR5DL9TG307294","dealer_id":6173,"year":2026,"make":"Ram","model":"2500","trim":"Big Horn","price":74634,"mileage":36000,"exterior_color":"Diamond Black Crystal Pearlcoat","interior_color":"Black","stock_number":"TG307294","listing_url":"https://www.shottenkirk.com/vehicle/New/2026/Ram/2500/3C6UR5DL9TG307294/","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:11","detail_scraped_at":"2026-06-18 08:01:36","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 | 3C6UR5DL9TG307294 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/f4612f5f-60d2-4882-90d9-64af4321fd93.jpg","position":0},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/f4612f5f-60d2-4882-90d9-64af4321fd93.jpg","position":0},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/9244aec1-bcc7-47f3-ba82-b34205a0aac5.jpg","position":1},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/9244aec1-bcc7-47f3-ba82-b34205a0aac5.jpg","position":1},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a758648c-ccaa-494b-9a31-6dd1910370aa.jpg","position":2},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a758648c-ccaa-494b-9a31-6dd1910370aa.jpg","position":2},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5e9f1215-da86-454e-9494-495c94ff4f8e.jpg","position":3},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5e9f1215-da86-454e-9494-495c94ff4f8e.jpg","position":3},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/eae140cf-ef52-40fd-bde3-31a93107b395.jpg","position":4},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/eae140cf-ef52-40fd-bde3-31a93107b395.jpg","position":4},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/72c434ab-ff38-4a1b-97bc-0394952c8d84.jpg","position":5},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/72c434ab-ff38-4a1b-97bc-0394952c8d84.jpg","position":5},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/1cd8d6cf-232f-480e-9ab5-caf4290b90c8.jpg","position":6},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/1cd8d6cf-232f-480e-9ab5-caf4290b90c8.jpg","position":6},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/e8fcb555-0d76-42bb-9505-42d787ddacf2.jpg","position":7},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/e8fcb555-0d76-42bb-9505-42d787ddacf2.jpg","position":7},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/f845da36-3d07-471c-9dea-2c677c1c3608.jpg","position":8},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/f845da36-3d07-471c-9dea-2c677c1c3608.jpg","position":8},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/d8698253-529f-4adf-b9a6-0f20d4b7b288.jpg","position":9},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/d8698253-529f-4adf-b9a6-0f20d4b7b288.jpg","position":9},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b0bc760c-c75a-4895-9d4c-7d3241676ae8.jpg","position":10},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b0bc760c-c75a-4895-9d4c-7d3241676ae8.jpg","position":10},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0d8bb964-ead2-4a81-bc33-7c6b058df261.jpg","position":11},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0d8bb964-ead2-4a81-bc33-7c6b058df261.jpg","position":11},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/f747d236-e660-4017-8a4a-957e6db98993.jpg","position":12},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/f747d236-e660-4017-8a4a-957e6db98993.jpg","position":12},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/174bc282-c4a2-44c2-bca8-4e2a09ea3362.jpg","position":13},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/174bc282-c4a2-44c2-bca8-4e2a09ea3362.jpg","position":13},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/2489be50-080b-43ee-bdc8-0aec46504508.jpg","position":14},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/2489be50-080b-43ee-bdc8-0aec46504508.jpg","position":14},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0858a7ac-4218-4ae3-bb42-1c25fd159a4b.jpg","position":15},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0858a7ac-4218-4ae3-bb42-1c25fd159a4b.jpg","position":15},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b52be7bb-6f2c-4802-9394-29fa1612e141.jpg","position":16},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/b52be7bb-6f2c-4802-9394-29fa1612e141.jpg","position":16},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5c8ed8fc-e631-4be4-a959-85411f7ad6b0.jpg","position":17},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5c8ed8fc-e631-4be4-a959-85411f7ad6b0.jpg","position":17},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a9314326-63e6-40e5-b21b-86d38eba9d88.jpg","position":18},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a9314326-63e6-40e5-b21b-86d38eba9d88.jpg","position":18},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/91f8981d-a814-4c67-b8c7-3b938f155e00.jpg","position":19},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/91f8981d-a814-4c67-b8c7-3b938f155e00.jpg","position":19},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/d2bbe6ad-92c6-42e2-9366-1a319a39d57d.jpg","position":20},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/d2bbe6ad-92c6-42e2-9366-1a319a39d57d.jpg","position":20},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/c0f82aec-6917-4b25-9861-3af83a39db00.jpg","position":21},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/c0f82aec-6917-4b25-9861-3af83a39db00.jpg","position":21},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/96637418-5a10-4938-bc8f-15ca3449bafe.jpg","position":22},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/96637418-5a10-4938-bc8f-15ca3449bafe.jpg","position":22},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a78e266a-a293-4ce6-9aab-d2bc65cfaea8.jpg","position":23},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/a78e266a-a293-4ce6-9aab-d2bc65cfaea8.jpg","position":23},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/4ceaa2b2-6923-4d3e-9b83-ec5f32fec18d.jpg","position":24},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/4ceaa2b2-6923-4d3e-9b83-ec5f32fec18d.jpg","position":24},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5033620a-99f6-4957-857c-81a1b3d2c50b.jpg","position":25},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/5033620a-99f6-4957-857c-81a1b3d2c50b.jpg","position":25},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/eb3c3c21-fa72-4c8b-8ede-e9aab7b0f6cc.jpg","position":26},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/eb3c3c21-fa72-4c8b-8ede-e9aab7b0f6cc.jpg","position":26},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0fcb8c3b-e135-4592-b477-03e8ae5528fb.jpg","position":27},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/0fcb8c3b-e135-4592-b477-03e8ae5528fb.jpg","position":27},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/4e747db8-3c9c-4185-99fa-712189f3fffc.jpg","position":28},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/4e747db8-3c9c-4185-99fa-712189f3fffc.jpg","position":28},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/25f5ae7e-77ed-4c74-aeea-e6ce7e9e880e.jpg","position":29},{"url":"https://assets.cai-media-management.com/resize/1024x1024/common-vehicle-media/25f5ae7e-77ed-4c74-aeea-e6ce7e9e880e.jpg","position":29}],"recalls":[]}