by Hotel :
by Province :

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='chumphon' order by location,thrate
Hotel name. Location Stars Rates    Breakfast show only
Suriwong Hotel Chumphon Chumphon City   10 $ incl.
Chumphon Palace Hotel Chumphon City   13 $ incl.
Chumphon Gardens Hotel Chumphon City   14 $ incl.
Nana Buri Hotel Chumphon City   17 $
Morakot Twin Hotel Chumphon Chumphon City   22 $
Chumphon Islands - 1 Day Trip (Siam Catamaran) Chumphon City   31 $ incl.
A-Te' Hotel Chumphon Chumphon City   42 $ incl.
De Sea Almond Chumphon, Sairee Beach   28 $ incl. recommend
Sara Beachfront Boutique Resort Pathio, Bang Son Beach   96 $ incl. recommend
Sai Ngam Beach Resort Pathio, Bangburd Beach   49 $ incl. recommend
Baan Talay Thungwualaen Pathio, Thungwaulaen Beach   25 $ incl.
Nana Beach Resort Pathio, Thungwaulaen Beach   32 $ incl. recommend
Chumphon Cabana & Diving Resort Pathio, Thungwualaen Beach   43 $ incl.
Armonia Village Resort & Spa Pathio, Thungwualaen Beach   64 $
Tusita Wellness Resort Tungtako, Arunothai Beach   91 $ incl.
Rates for Chumphon hotels are subject to 7% VAT and 10% service charge .
provided by