{"id":117908,"vin":"3C7WRLEL0TG285189","dealer_id":6173,"year":2026,"make":"Ram","model":"4500","trim":null,"price":69340,"mileage":36000,"exterior_color":"Ceramic Gray Clearcoat","interior_color":"Black","stock_number":"R3975","listing_url":"https://www.shottenkirk.com/vehicle/New/2026/Ram/4500HD/3C7WRLEL0TG285189/","condition":"new","status":"active","body_type":"Incomplete","engine":"6.7","engine_cylinders":6,"engine_displacement":6.7,"transmission":null,"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:22","detail_scraped_at":"2026-06-18 08:00:19","first_seen":"2026-05-05 00:42:30","last_seen":"2026-06-25 06:41:50","created_at":"2026-05-05 00:42:30","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 4500HD Tradesman in West Burlington IA | 3C7WRLEL0TG285189 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/640x640/common-vehicle-media/46d947ac-5448-4885-8b3e-e44a029fcba1.jpeg","position":0},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/46d947ac-5448-4885-8b3e-e44a029fcba1.jpeg","position":0},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d238558d-60aa-49df-b209-f4cdd947fe1e.jpeg","position":1},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/d238558d-60aa-49df-b209-f4cdd947fe1e.jpeg","position":1},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/62a69374-d1cc-4483-90f8-d06c0c578f08.jpeg","position":2},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/62a69374-d1cc-4483-90f8-d06c0c578f08.jpeg","position":2},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/6d96146c-9e22-488e-b844-6e68e0afe768.jpeg","position":3},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/6d96146c-9e22-488e-b844-6e68e0afe768.jpeg","position":3},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/19c22b2f-3a5d-4cab-b010-1f92c5612d17.jpeg","position":4},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/19c22b2f-3a5d-4cab-b010-1f92c5612d17.jpeg","position":4},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a521ec3a-b43a-4bca-b524-bc2d8f7f8ac1.jpeg","position":5},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a521ec3a-b43a-4bca-b524-bc2d8f7f8ac1.jpeg","position":5},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/24c272f4-1f4c-40e7-bd62-78d616e63d42.jpeg","position":6},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/24c272f4-1f4c-40e7-bd62-78d616e63d42.jpeg","position":6},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c31ccefa-c7b1-4139-acf4-0eb9c470052a.jpeg","position":7},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c31ccefa-c7b1-4139-acf4-0eb9c470052a.jpeg","position":7},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/2de1a7d2-a556-4823-9575-9d151ff9a6d8.jpeg","position":8},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/2de1a7d2-a556-4823-9575-9d151ff9a6d8.jpeg","position":8},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c7f35d94-2892-4471-a1b6-db936600ef94.jpeg","position":9},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c7f35d94-2892-4471-a1b6-db936600ef94.jpeg","position":9},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/8ca169fc-aded-49aa-910c-c29d7c44c376.jpeg","position":10},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/8ca169fc-aded-49aa-910c-c29d7c44c376.jpeg","position":10},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/23dd4aea-7c49-47a3-a7ec-01990a2b7169.jpeg","position":11},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/23dd4aea-7c49-47a3-a7ec-01990a2b7169.jpeg","position":11},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/453762fa-e240-4534-939c-e0907f2f2ce1.jpeg","position":12},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/453762fa-e240-4534-939c-e0907f2f2ce1.jpeg","position":12},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a73cddc3-8676-4cc0-a5c1-2f283b491e11.jpeg","position":13},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a73cddc3-8676-4cc0-a5c1-2f283b491e11.jpeg","position":13},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/377f1e29-701f-4356-af95-382ac11215e4.jpeg","position":14},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/377f1e29-701f-4356-af95-382ac11215e4.jpeg","position":14},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/972dee5b-33f1-40f3-ae73-64631aeef1b9.jpeg","position":15},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/972dee5b-33f1-40f3-ae73-64631aeef1b9.jpeg","position":15},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0b2e97c5-e559-4dca-8980-16e517f2eee1.jpeg","position":16},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/0b2e97c5-e559-4dca-8980-16e517f2eee1.jpeg","position":16},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/465e4dbd-65c3-4dd7-a98d-e89a97c29f99.jpeg","position":17},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/465e4dbd-65c3-4dd7-a98d-e89a97c29f99.jpeg","position":17},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/56ea2799-1ced-4367-b9a4-969b5d958f7a.jpeg","position":18},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/56ea2799-1ced-4367-b9a4-969b5d958f7a.jpeg","position":18},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/8db4006f-a46e-4ff4-8527-6ef8b9c5140a.jpeg","position":19},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/8db4006f-a46e-4ff4-8527-6ef8b9c5140a.jpeg","position":19},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c296530c-715a-4ff5-8c5c-a119c2f1d9bc.jpeg","position":20},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/c296530c-715a-4ff5-8c5c-a119c2f1d9bc.jpeg","position":20},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/5d5fdca0-fb50-42cd-89ad-18fda0f1a1cb.jpeg","position":21},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/5d5fdca0-fb50-42cd-89ad-18fda0f1a1cb.jpeg","position":21},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/3bbb467f-638d-4828-9f1a-a2247ca3d0a6.jpeg","position":22},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/3bbb467f-638d-4828-9f1a-a2247ca3d0a6.jpeg","position":22},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/4377977e-da5c-4b94-bc6e-7ee254c17377.jpeg","position":23},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/4377977e-da5c-4b94-bc6e-7ee254c17377.jpeg","position":23},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/e1effee9-cd92-4809-94ca-3ec13f3e4e75.jpeg","position":24},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/e1effee9-cd92-4809-94ca-3ec13f3e4e75.jpeg","position":24},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/783c7d7a-1ac4-4eff-8bbd-d521099fadc7.jpeg","position":25},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/783c7d7a-1ac4-4eff-8bbd-d521099fadc7.jpeg","position":25},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ad9e9b20-e3c5-4f67-ba83-7a5b22c07d2c.jpeg","position":26},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/ad9e9b20-e3c5-4f67-ba83-7a5b22c07d2c.jpeg","position":26},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a2072dd6-9432-41f6-9e01-94c3f942e5f8.jpeg","position":27},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a2072dd6-9432-41f6-9e01-94c3f942e5f8.jpeg","position":27},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a92993a2-0bbb-427d-a749-9dda34c67358.jpeg","position":28},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/a92993a2-0bbb-427d-a749-9dda34c67358.jpeg","position":28},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/eabd622a-add9-4666-a909-499bb891079e.jpeg","position":29},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/eabd622a-add9-4666-a909-499bb891079e.jpeg","position":29},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/6e1a3a63-2f08-4127-a067-9e3b57b86f55.jpeg","position":30},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/6e1a3a63-2f08-4127-a067-9e3b57b86f55.jpeg","position":30},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/93b05b9b-0534-497c-a898-f0f8cf9aca8e.jpeg","position":31},{"url":"https://assets.cai-media-management.com/resize/640x640/common-vehicle-media/93b05b9b-0534-497c-a898-f0f8cf9aca8e.jpeg","position":31}],"recalls":[]}