{"id":"b09bcd5a-2853-4d4e-85c5-544ea7331189","vin":"5NMP3DGL9TH220528","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"XRT","body_style":"suv","odometer":{"value":9,"unit":"mi"},"pricing":{"sale_price":39726,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Shimmering Silver Pearl","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP3DGL9TH220528_27485_2740909788.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-xrt-5nmp3dgl9th220528"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.654Z"}
{"id":"b587ca89-2aae-455e-b81d-c00377cb98c8","vin":"KM8RKES28TU070917","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"Limited","body_style":"suv","odometer":{"value":21,"unit":"mi"},"pricing":{"sale_price":49842,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Typhoon Silver Metallic","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RKES28TU070917_27485_2740910056.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-limited-km8rkes28tu070917"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.653Z"}
{"id":"746fa516-984d-4971-9bed-cd03f7628f19","vin":"5NMP24GL3TH210645","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"SEL","body_style":"suv","odometer":{"value":9,"unit":"mi"},"pricing":{"sale_price":35323,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP24GL3TH210645_27485_2740910228.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-sel-5nmp24gl3th210645"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.652Z"}
{"id":"1e4e86f5-6c0a-4080-9905-f04ebbb0c65d","vin":"KMHLS4DG4TU184454","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":12,"unit":"mi"},"pricing":{"sale_price":24019,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Amazon Gray","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG4TU184454_27485_2740909087.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg4tu184454"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.651Z"}
{"id":"679e8dd8-7256-4fb1-8329-0c8f671b72ec","vin":"5NMP2DGL4TH170415","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"SEL","body_style":"suv","odometer":{"value":24,"unit":"mi"},"pricing":{"sale_price":37106,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP2DGL4TH170415_27485_2740909935.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-sel-5nmp2dgl4th170415"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.650Z"}
{"id":"6777feb0-2f68-428f-86dd-320dd0bccae0","vin":"KMHLM4DG5TU217536","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":14,"unit":"mi"},"pricing":{"sale_price":23328,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLM4DG5TU217536_27485_2740115913.jpg?ver=20260718","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhlm4dg5tu217536"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.649Z"}
{"id":"41cd2d97-3f3f-4a52-bee1-d39910bccadd","vin":"KMHLS4DGXTU210409","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24019,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DGXTU210409_27485_2740910235.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dgxtu210409"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.649Z"}
{"id":"69bcbf4a-64ee-4d6d-81e3-210cb3944188","vin":"KMHLP4DG4TU183015","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"Limited","body_style":"sedan","odometer":{"value":20,"unit":"mi"},"pricing":{"sale_price":26132,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Light Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLP4DG4TU183015_27485_2740909966.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-limited-kmhlp4dg4tu183015"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.648Z"}
{"id":"90ceedf8-c7da-4186-9b42-415b5f8df7b2","vin":"KMHLS4DG6TU210407","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24019,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG6TU210407_27485_2740910003.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg6tu210407"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.647Z"}
{"id":"b94589c7-d14a-4850-8e98-baab1aa819a9","vin":"KM8RJES24TU060761","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"XRT Pro","body_style":"suv","odometer":{"value":32,"unit":"mi"},"pricing":{"sale_price":45549,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Pacific Sapphire","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RJES24TU060761_27485_2740910064.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-xrt-pro-km8rjes24tu060761"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.646Z"}
{"id":"6802ee09-a167-40b9-80cc-0b62cfc65930","vin":"KM8RKES26TU091765","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"Limited","body_style":"suv","odometer":{"value":12,"unit":"mi"},"pricing":{"sale_price":49827,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Cast Iron Brown Pearl","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RKES26TU091765_27485_2740910105.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-limited-km8rkes26tu091765"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.645Z"}
{"id":"1c7c5ab3-61fd-4d28-b953-1bcd117d7d69","vin":"5NMP4DGL9TH225841","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"Limited","body_style":"suv","odometer":{"value":14,"unit":"mi"},"pricing":{"sale_price":44071,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Pecan Brown"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP4DGL9TH225841_27485_2739694437.jpg?ver=20260717","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-limited-5nmp4dgl9th225841"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.644Z"}
{"id":"bba0e9b2-71ea-4408-b546-3b2ceb2d45d1","vin":"5NMP2DGL9TH194855","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"SEL","body_style":"suv","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":37552,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ultimate Red","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP2DGL9TH194855_27485_2740909633.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-sel-5nmp2dgl9th194855"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.643Z"}
{"id":"c86213fa-adca-442b-8215-335fd536762b","vin":"5NMP2DGL2TH160398","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"SEL","body_style":"suv","odometer":{"value":70,"unit":"mi"},"pricing":{"sale_price":36935,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Hampton Gray","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP2DGL2TH160398_27485_2740910175.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-sel-5nmp2dgl2th160398"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.642Z"}
{"id":"771176d8-d116-4623-850d-c942657629d6","vin":"KM8RMES29TU057006","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"Calligraphy","body_style":"suv","odometer":{"value":36,"unit":"mi"},"pricing":{"sale_price":53357,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Abyss Black Pearl","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RMES29TU057006_27485_2740909300.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-calligraphy-km8rmes29tu057006"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.641Z"}
{"id":"735dba06-989b-4223-8c13-95dd53d32474","vin":"KM8RN5S29TU088124","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"SEL Premium","body_style":"suv","odometer":{"value":30,"unit":"mi"},"pricing":{"sale_price":45023,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray Pearl","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RN5S29TU088124_27485_2740910020.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-sel-premium-km8rn5s29tu088124"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.640Z"}
{"id":"a1b012b8-f037-4b28-857b-6ca998620a4f","vin":"KMHLS4DG5TU209748","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24499,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG5TU209748_27485_2740115970.jpg?ver=20260718","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg5tu209748"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.639Z"}
{"id":"6d5be097-a335-4844-b138-6e3d7b8eeb86","vin":"KMHLS4DGXTU176374","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":11,"unit":"mi"},"pricing":{"sale_price":24160,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DGXTU176374_27485_2740909979.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dgxtu176374"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.638Z"}
{"id":"6369972b-a9f9-496d-903b-a48e08ea2db4","vin":"KMHLS4DG5TU210298","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24009,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG5TU210298_27485_2740909602.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg5tu210298"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.637Z"}
{"id":"1b01b5cb-6a37-458f-8313-fadf696f210b","vin":"KMHLS4DG7TU176686","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24160,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG7TU176686_27485_2740115713.jpg?ver=20260718","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg7tu176686"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.636Z"}
{"id":"60ad7303-aa2f-4741-b935-9d904005a8ea","vin":"KMHLS4DGXTU178173","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":11,"unit":"mi"},"pricing":{"sale_price":24563,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DGXTU178173_27485_2740115949.jpg?ver=20260718","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dgxtu178173"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.635Z"}
{"id":"c22a0458-c28f-4f8d-ab5a-578ba97f1bb8","vin":"5NMJECDE8TH724004","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Tucson","trim":"Limited","body_style":"suv","odometer":{"value":175,"unit":"mi"},"pricing":{"sale_price":38475,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"White Pearl","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L 4-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_tucson_0_5NMJECDE8TH724004_27485_2740909744.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-tucson-limited-5nmjecde8th724004"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"4","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":5,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.635Z"}
{"id":"d96d9d30-5eda-4392-8c90-f87e3f7cd3f7","vin":"KMHLS4DG2TU179060","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":12,"unit":"mi"},"pricing":{"sale_price":24116,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Amazon Gray","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG2TU179060_27485_2740909080.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg2tu179060"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.634Z"}
{"id":"652a9a00-a935-4adb-a8f4-8d859b2d5e5e","vin":"KM8RJES23TU062968","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"XRT Pro","body_style":"suv","odometer":{"value":33,"unit":"mi"},"pricing":{"sale_price":46956,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray Pearl","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RJES23TU062968_27485_2740909610.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-xrt-pro-km8rjes23tu062968"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.633Z"}
{"id":"cd4ad8ce-3c4f-4d56-a0bf-b5f20b0ea09a","vin":"KMHLS4DG3TU182386","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":11,"unit":"mi"},"pricing":{"sale_price":24019,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Abyss Black","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG3TU182386_27485_2740910141.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg3tu182386"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.632Z"}
{"id":"f41f00c9-4f23-4b7c-a781-bdb919ac94fd","vin":"KM8RKES28TU092478","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"Limited","body_style":"suv","odometer":{"value":12,"unit":"mi"},"pricing":{"sale_price":49846,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Titan Green","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RKES28TU092478_27485_2740909882.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-limited-km8rkes28tu092478"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.631Z"}
{"id":"cad73d32-2f90-4960-9f9f-3692d4b4faff","vin":"KMHLM4DG0TU219565","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":22834,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Amazon Gray","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLM4DG0TU219565_27485_2740909585.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhlm4dg0tu219565"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.630Z"}
{"id":"0d728310-739c-4069-bd25-04a972b964b1","vin":"5NMP3DGL8TH221234","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"XRT","body_style":"suv","odometer":{"value":8,"unit":"mi"},"pricing":{"sale_price":39028,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP3DGL8TH221234_27485_2740909543.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-xrt-5nmp3dgl8th221234"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.629Z"}
{"id":"e6607e84-cc0e-4141-850c-e282d51c8607","vin":"KM8RLES28TU109132","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"SEL","body_style":"suv","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":44268,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Creamy White Pearl","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RLES28TU109132_27485_2740910097.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-sel-km8rles28tu109132"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.628Z"}
{"id":"bd3b8b41-b4f2-4e7d-9a71-b7abfbf67e1d","vin":"KMHLS4DGXTU178819","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24115,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DGXTU178819_27485_2740909940.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dgxtu178819"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.627Z"}
{"id":"e3a7cc01-e3d0-473e-9952-1b77e2742063","vin":"KMHLS4DG8TU134589","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24560,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Black"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG8TU134589_27485_2740115657.jpg?ver=20260718","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg8tu134589"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.626Z"}
{"id":"706f993a-2653-46d3-921d-7055cb8f9dc2","vin":"KMHLS4DG6TU184598","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":13,"unit":"mi"},"pricing":{"sale_price":24595,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Serenity White","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG6TU184598_27485_2740115396.jpg?ver=20260718","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg6tu184598"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.625Z"}
{"id":"3dc0cacc-bb98-463b-b2c4-9b7b2f99e56a","vin":"KMHLS4DG9TU210238","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Elantra","trim":"SEL Sport","body_style":"sedan","odometer":{"value":10,"unit":"mi"},"pricing":{"sale_price":24009,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ecotronic Gray","interior":"Gray"},"drivetrain":"FWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_elantra_2026_KMHLS4DG9TU210238_27485_2740910009.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-elantra-sel-sport-kmhls4dg9tu210238"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"5","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":1,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.625Z"}
{"id":"1a5a747f-499a-47f4-b400-1cc13425f53d","vin":"KM8RLES23TU106574","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Palisade","trim":"SEL","body_style":"suv","odometer":{"value":8,"unit":"mi"},"pricing":{"sale_price":44268,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Creamy White Pearl","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"3.5L 6-cyl","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_palisade_2026_KM8RLES23TU106574_27485_2740909953.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-palisade-sel-km8rles23tu106574"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"4","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":3,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.624Z"}
{"id":"a064a117-0c37-471b-aa9f-259d369fe76b","vin":"5NMP2DGL4TH186937","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"SEL","body_style":"suv","odometer":{"value":11,"unit":"mi"},"pricing":{"sale_price":37266,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ultimate Red","interior":"Black"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP2DGL4TH186937_27485_2740910053.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-sel-5nmp2dgl4th186937"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.623Z"}
{"id":"f15cfda1-b2c9-46a1-9976-b84ed98a48e0","vin":"5NMP2DGL9TH164495","stock_number":null,"status":"on_lot","condition":"New","year":2026,"make":"Hyundai","model":"Santa Fe","trim":"SEL","body_style":"suv","odometer":{"value":17,"unit":"mi"},"pricing":{"sale_price":37582,"msrp":null,"currency":"USD"},"location":{"dealer_id":"8d1a5353-4a19-45ee-9086-f6de678cb746","dealer_name":"Joe Machens Hyundai Columbia","dealer_slug":"joe-machens-hyundai-columbia-columbia-mo","city":"Columbia","state":"MO","zip":"65202"},"color":{"exterior":"Ultimate Red","interior":"gray"},"drivetrain":"AWD","fuel_type":"GASOLINE","transmission":"Automatic","engine":"2.5L","images":[{"url":"https://imgcdn.lotlinx.com/vdn/27485/hyundai_santa%20fe_2026_5NMP2DGL9TH164495_27485_2740909513.jpg?ver=20260721","primary":true}],"urls":{"vdp":"https://opendealer.shop/joe-machens-hyundai-columbia-columbia-mo/2026-hyundai-santa-fe-sel-5nmp2dgl9th164495"},"safety_rating":{"source":"NHTSA","program":"5-Star Safety Ratings (NCAP)","overall":"5","frontal_driver":"5","frontal_passenger":"5","side":"5","side_driver":"5","rollover":"4","source_url":"https://www.nhtsa.gov/ratings"},"recall_summary":{"source":"NHTSA","scope":"year_make_model","open_recall_count":4,"has_open_recalls":true,"has_park_it":false,"has_park_outside":false,"fetched_at":"2026-07-27T12:00:42.906Z"},"updated_at":"2026-07-30T06:17:23.621Z"}