This picturesque town is Colmar which is Alsace wine region in north-eastern France. It's cheerful and colorful houses with the flowers make the town looks like a fairy tale place. It is also the home to international summer festival of classical music - Festival de Colmar. 

The nearest airport to this town is Strabourg Airport and their public transport is this extensive and efficient bus network called TRACE (transport de colmar & environs). It costs 1.05 Euros for per person

S$100 = 62.6802 EUR

Just tried Airfrance airway and apparently it costs roughly $1800 to travel there(during sep period, for 6 days)! oh godddd .... Have not even include accommodation.

(via http://www.tripadvisor.com/Hotel_Review-g187073-d239294-Reviews-La_Maison_des_Tetes-Colmar_Haut_Rhin_Alsace.html )

One awesome hotel, as mentioned in comments. The historic feel of the building and modern room adds favor to the charming town. 

( via http://www.tripadvisor.com/Hotel_Review-g562692-d1958412-Reviews-Hotel_La_Bergerie-Beblenheim_Haut_Rhin_Alsace.html ) 

Another pleasant looking hotel found! The comments are really good! It's a family hotel and check this out ! ( via http://www.hotel-la-bergerie.com/chambres-en.html )

Wow... I wonder how it feels like to be there. I bet I will fall so deeply in love with the town and not bear to return. 

Learn the important phrases! ( via http://www.tripadvisor.com/Travel-g187070-s604/France:Important.Phrases.html )