include("Startconnect.php");
$sqldetail = "SELECT * FROM hoteldetail WHERE hotelid='$hotelid';";
$resultdetail = mysql_db_query($database,$sqldetail);
$datadetail = mysql_fetch_array($resultdetail);
$sqlfac = "SELECT * FROM hotelfacilitynew WHERE hotelid='$hotelid';";
$resultfac = mysql_db_query($database,$sqlfac);
$datafac = mysql_fetch_array($resultfac);
$sqlpic = "SELECT * FROM picture WHERE hotelid='$hotelid';";
$resultpic = mysql_db_query($database,$sqlpic);
$datapic = mysql_fetch_array($resultpic);
$sqlmata = "SELECT * FROM matatag WHERE hotelid='$hotelid';";
$resultmata = mysql_db_query($database,$sqlmata);
$datamata = mysql_fetch_array($resultmata);
$sqlrate = "SELECT * FROM ratepricenew where hotelid = '$hotelid' ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultrate = mysql_db_query($database,$sqlrate);
$num_rows_rate=mysql_num_rows($resultrate);
$sqlsdate = "SELECT DATE_FORMAT(startdate,'%d %b %Y') AS startdatefull FROM ratepricenew where hotelid ='$hotelid' ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultsdate = mysql_db_query($database,$sqlsdate);
$sqledate = "SELECT DATE_FORMAT(enddate,'%d %b %Y') AS enddatefull FROM ratepricenew where hotelid = '$hotelid' ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultedate = mysql_db_query($database,$sqledate);
$sqlnumroom ="SELECT roomtype ,COUNT(*) AS numroom FROM ratepricenew WHERE hotelid = '$hotelid' GROUP BY roomtype ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;" ;
$resultnumroom = mysql_db_query($database,$sqlnumroom);
$num_rows_room=mysql_num_rows($resultnumroom);
$sqlnumbed2="SELECT roomtype ,COUNT(DISTINCT bedtype) AS numbed FROM ratepricenew WHERE hotelid ='$hotelid' GROUP BY roomtype ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultnumbed2 = mysql_db_query($database,$sqlnumbed2);
$num_rows_bed2=mysql_num_rows($resultnumbed2);
$sqlnumbed="SELECT roomtype,bedtype ,COUNT(*) AS numbed FROM ratepricenew WHERE hotelid = '$hotelid' GROUP BY roomtype,bedtype ORDER BY roomtype,FIELD(bedtype,'Single','Twin/Double','Triple') ,startdate;";
$resultnumbed = mysql_db_query($database,$sqlnumbed);
$num_rows_bed=mysql_num_rows($resultnumbed);
?>
80 Moo 4, Hubkrapong-Praburi Highway , Cha Am , Phetchaburi , , Thailand
Telephone:
+32 456 233-40
Facsimile:
The Imperial Lake View Hotel & Golf Club is a fascinating place for a golfing and family vacation. Its location on the banks of a picturesque lake with a mountain backdrop is perfect for helping one while away those holiday hours where the troubles at the office back home are forgotten.
The Imperial Lake View Hotel and Golf Club, Cha Am is just 16 kilometers from the main Petchkasem Road ( on Hubkrapong-Pranburi Highway ). The Imperial Lake View Hotel & Golf Club is located on the west coast of the Gulf of Siam, approximately 2 hours drive or a 25 minutes flight from Bangkok and 25 kilometers from Hua-Hin ( Thailand's oldest major beach resort and golfing area ).
Imperial Lake View Hotel & Golf Club - Facilities & Services
Restaurants
Coffee Shop
Gift Shop
Banquet & Conference Facilities
Business Services
Library
Laundry Service
Golf Course
Tennis Courts
Squash Court
Swimming Pool
Jacuzzi
Snooker
Games Room
restaurant
conference room
Swimming Pool
Imperial Lake View Hotel & Golf Club - Rooms & Accommodation
• Hotel rates are per room per night, nett, non commissionable, and inclusive of service charge 10% and current applicable Value Added Tax 7%.
• Single room = One person, Twin/Double room = Two persons, Triple room = Three persons, including extra bed.