{"id":5832634,"vin":"KM8R5DGE0RU677942","dealer_id":6473,"year":2024,"make":"Hyundai","model":"Palisade","trim":"Limited","price":36698,"mileage":42924,"exterior_color":"Color","interior_color":"Color","stock_number":"Stock","listing_url":"https://cars.rootz.global/vehicle/KM8R5DGE0RU677942","condition":"used","status":"active","body_type":"Sport Utility Vehicle [SUV]/Multipurpose Vehicle [MPV]","engine":null,"engine_cylinders":null,"engine_displacement":3.8,"transmission":null,"drivetrain":"4WD/4-Wheel Drive/4x4","fuel_type":"Gasoline","mpg_city":null,"mpg_highway":null,"doors":5,"seats":null,"recall_count":0,"complaint_count":0,"nhtsa_enriched_at":"2026-06-22 00:27:50","detail_scraped_at":"2026-06-18 07:36:43","first_seen":"2026-06-12 06:39:01","last_seen":"2026-06-25 06:36:07","created_at":"2026-06-12 06:39:01","updated_at":"2026-06-25 06:36:07","mpg_city_scraped":null,"mpg_highway_scraped":null,"dealer_fees":1174,"dealer_fees_detail":"[{\"amount\":587,\"label\":\"$587.00 admin fee\"},{\"amount\":587,\"label\":\"$587.00 admin fee\"}]","features":null,"description":"AVAILABLE AT JOE MACHENS HYUNDAI! CALL 573-474-7400 TODAY! 2024 Hyundai Palisade Limited AWD Steel Graphite w/ Lt Beige Leather Interior Clean Experian AutoCheck Vehicle History Report HYUNDAI CERTIFIED PRE-OWNED VEHICLE! - 10-Year / 100,000 Mile Powertrain Warranty - CARFAX Vehicle History Report - 173-Point Inspection - 10-Year / Unlimited Mileage Roadside Assistance - Rental Car Coverage & Travel Breakdown Benefits - 3 Months of All Access SiriusXM - Piece of Mind knowing you are covered by Hyundai Factory Warranty! ADVANCED SAFETY TECHNOLOGIES Front, Front & 2nd Row Side, Side-Curtain & Driver's Knee Airbags Forward Collision-Avoidance Assist Lane Keeping Assist; Lane Following Assist Driver Attention Warning Blind-Spot Collision Warning Blind-Spot View Monitor Rear Cross-Traffic Collision-Avoidance Assist Parking Distance Warning - Forward & Reverse Immobilizer POWERTRAIN TECHNOLOGY 3.8L V6 Engine w/ Idle Stop & Go 8-Speed Automatic Transmission w/ Paddle Shifters HTRAC AWD EXTERIOR 20 Alloy Wheels LED Headlights, Tail Lights, & Daytime Running Lights Auto-Dimming Heated Side Mirrors Dual Pane Sunroof Roof Side Rails Temporary Spare Tire COMFORT & CONVENIENCE Smart Cruise Control Highway Driving Assist Surround View Monitor Head-Up Display 12.3 Digital Instrument Cluster Dual Automatic Temperature Control Auto-Dimming Rearview Mirror w/ HomeLink® Proximity Key with Push Button Start Leather Seating Surfaces Power Front Seats Integrated Memory Driver's Seat 2nd Row Captain's Chairs Power 3rd Row Seats Heated Front, 2nd and 3rd Row Seats Ventilated Front and 2nd Row Seats Heated Steering Wheel Manual Rear Side Window Sunshade Ambient Lighting Hands-free Smart Liftgate w/ Auto Open Front, 2nd and 3rd Row USB Ports 115V Power Outlet MULTIMEDIA & CONNECTIVITY 12.3 Navigation System w/AM/FM/HD RadioTM Android AutoTM & Apple CarPlay® Harman Kardon® Premium Audio Wireless Phone Charger Digital Key SiriusXM® Bluelink+ All-Inclusive Connected Services Wi-Fi Hotspot Full ","carfax_url":null,"num_owners":null,"accident_free":null,"certified":1,"warranty":"warranty{background-color:#fff;-webkit-box-shadow:0 0 15px 0 rgba(0,0,0,.07);box-shadow:0 0 15px 0 rgba(0,0,0,.07);padding:2.29em 1.43em}.warranty--rounded{border-radius:.36em}@media (min-width:992px)","dealer_name":"Columbia Honda","dealer_city":"Columbia","dealer_state":"MD","dealer_zip":null,"dealer_phone":null,"dealer_website":"https://www.columbiahonda.com","photos":[],"recalls":[]}