buying advice

Hello and thanks in advance for your help. Did my research and think a Pilot would be the best investment for me. I want to be around 25-29k all in. Looking to keep the car at least 8 years. My question which year and model should I get within that price range? Two car seats 15kmiles a year...