phangan-guide.com
by Hotel :
by Province :
THB USD EUR GBP AUD SEK
currency
certified

SELECT hotel.*, xhotels.*, fx.thbex, SVCharge * thbex AS thrate, (SVCharge * usdex) AS usrate FROM ((hotel LEFT JOIN fx ON hotel.unit = fx.cursym) LEFT JOIN provinces ON hotel.province = provinces.pv_key) LEFT JOIN xhotels ON hotel.HNO = xhotels.hno WHERE MEMCAT='hotel' and Active<>0 AND (listings=2 or listings=3) AND hotel.Region='kohsamui' order by location,thrate
Hotel name. Location Stars Rates    Breakfast show only
recommended
Remarks:
Rates for Kohsamui hotels are subject to 7% VAT and 10% service charge .
provided by R24.org