Goodpm tsikoteers!

My brother is asking for help what are his options when buying a 2nd hand car with a budget of 500k below? I've seen other threads and some searches for that price range and as i see the FD, Jazz, Altis are within the range. Though i also want your opinions regarding this.

I'll list what the car will be used for.

Size of family: 3 (1 baby)
No. of helpers: 2
Car will be mostly used by my sister-in-law during weekdays and route will be san juan - ortigas only
On weekends, car will be used to go to cavite and or bulacan (grandparents)
Hoping to get the best bang-for-the-buck car at 500k or less
Hoping to get 2008 model and up (06-07 okay)
Best FC
Should be A/T since my sister-in-law doesn't drive manual

If you were in this situation, what would you get?

Thanks in advance tsikoteers. I'll be glad to answer all other questions that is needed :D