The arrival of winter means for many a time of leisure in the fascinating Chiang Mai. This land of Nakhon Phing is a must go destination for friends, families and lovers.
Among the mountains hides a small tranquil city. A short river flowing through algae covered rocks, glittering golden pagodas, the immaculate natural beauty and the greatness of the Lanna culture the root of all northern culture are factors that make Chia
An eastern popular beach resort, Chon Buri is a weekend sanctuary for many tourists who seek escape from hectic everyday life. Apart from the beautiful beaches, many other attractions, e.g., zoos, temples and delicious restaurants, await every visitor’s d
Kanchanaburi is a place full of stories, memories and sentiments. The province’s natural wonders make Kanchanaburi a prime
destination for ecotourists and adventurers. You may wonder that many temples can be found in the middle of remote green forests. T
A trip to Khon Kaen, a city in the heart of the Northeast or Isan, always comes with the music of the Khaen and the sight of Khun flowers. Fun filled city, this place is home to ancient settlements, monuments and quite a number of natural tourist attracti
Krabi is the “liveable city with friendly people”. This slogan
succinctly explains the charm of the “Emerald of the Andaman Sea” which draws tourists from around the world to discover more than 130 islands she has to offer. Tourists can relax in the blue
Lampang could be very cold, but the smiles of the natives provide all the needed warmth. It is a tourist destination that manages to preserve the old town charm. A visit to this province of unseen natural beauty and it will not be overlooked ever again.
SELECT country_id, '' AS festival_place_id, country_name_eng, country_title_eng, country_pic, 'country' AS type_travel, '' AS place_title , country_enterdate,zone_id
FROM kbank_country
WHERE country_title != '' and zone_id<>'9' order by country_name_eng