We finally bought the above car, a Toyota Sienta 1.5 liter for S$32,500 with all the extra features. We decided to pay half the amount for my parent-in-laws as a present. In return, we have the privilege of driving the car whenever it is not in use. Renting a car in Japan is very expensive.
My sister-in-law got her Mitsubishi 650cc for about S$20,000 last year. This car is fine if you do not carry too much cargo or baggage or more than 2 people. It is economical and reliable too.