2009 Toyota Avanza 1.5 - cheap and cheerful people and goods transporter, look for the 1500cc model as eventhough it is still underpowered it isn't as bad as getting the 1300cc model. It's a cheap model to own and maintain it doesn't require anything special, you can bring it to any shop and use cheapest parts it will still work. I just can't really get pass the looks personally, I don't like it. But it serves a purpose and if what you need is something that can transport for family of 7 people during the weekend and cargo during the weekday then its a good choice.
2008 Nissan Livina - there are similarities and differences between the Avanza and Livina. The Livina is based on a sedan car platform which is why its more lower and sleek, the Avanza is based on a box van platform which is why its boxy and tall. They both can perform the function of carrying 7 people and cargo. Livina is also abit underpowered because the bigger and heavier than what the 1600cc engine can output, yet still better than Avanza.
2006 Nissan X-trail - it seems like an X-trail marathon today, I can't remember how many times I recommended this car today. Anyways, function wise it should serve your purpose. If you need space for 7 people then you must either go with the Avanza or Livina. The AWD system is great and fuel saving, plus maintenance charges are quite cheap - it can use normal road tires too.
2009 Nissan Frontier - it cannot carry 7 people, it can only do 5 people max and not really spaciously because usually the extra cab for pickup to carry more people is a by-the-way function IMHO, okay for short trips but going outstation sitting at the rear in such cars is a torture. Cargo capacity for one model is better because the previous owner has already installed a roof so your cargo won't get wet in the rain but it also limits what kind of cargo you can carry, it can to fit the door. Big con for this car would be the need for specialty pickup tires and diesel engine roadtax (but diesel is good you get a powerful and frugal engine).
Thanks for the recommendation. I did my own research and is quite interested in the Hyundai Tucson but it is way over my budget except the 2010 model which is the closest to my budget. What's your comment on that SUV and also do you think the price will dip down to my budget range next year?