Execute("select name, full_description as hotel_full_description, short_desc, oneline_desc, url, low_season, low_rate, mid_season, mid_rate, high_season, high_rate, checkin, checkout, fees_stmt, pay_methods, pets, address from hotelsegv where AccomName='$hotel'"); $name = $row->fields['name']; $hotel_full_description = $row->fields['hotel_full_description']; $short_desc = $row->fields['short_desc']; $oneline_desc = $row->fields['oneline_desc']; $url = $row->fields['url']; $lowseason = $row->fields['low_season']; $lowrate = $row->fields['low_rate']; $midseason = $row->fields['mid_season']; $midrate = $row->fields['mid_rate']; $highseason = $row->fields['high_season']; $highrate = $row->fields['high_rate']; $checkin = $row->fields['checkin']; $checkout = $row->fields['checkout']; $feestmt = $row->fields['fees_stmt']; $paymethods = $row->fields['pay_methods']; $pets = $row->fields['pets']; $address = $row->fields['address']; $peturl = '

Visit the Park Lane website for more information.

'; $row = $conn->Execute("select id from offersegv where AccomName='$hotel' order by sort_order"); while(!$row->EOF){ $ids[] = $row->fields['id']; $row->MoveNext(); } } else { echo "no conn"; exit; } $ofr = ''; $offers = ''; if($conn) { $row = $conn->Execute("SELECT DISTINCT ONN.id, ONN.offer_key, ONN.name, ONN.AccomName, ONN.sort_order, ONN.featured, ONN.full_description, ONN.offer, ONN.offer_title, ONN.offer_nights, IFNULL(G1.offer_gift_display,'') as offer_gift, IFNULL(G2.offer_gift_display,'') as offer_add_gift, ONN.offer_price, ONN.offer_retail, ONN.offer_bonusarr, ONN.offer_foot, ONN.tu6, CAST((CAST(ONN.offer_retail AS DECIMAL(18,0)) - CAST(ONN.offer_price AS DECIMAL(18,0))) AS DECIMAL(18,0) ) AS offer_sav FROM offersegv ONN LEFT JOIN giftsegv G1 ON G1.offer_gift = ONN.offer_gift LEFT JOIN giftsegv G2 ON G2.offer_gift = ONN.offer_add_gift WHERE ONN.offer_key = '$offerkey' ORDER BY ONN.sort_order"); while(!$row->EOF){ $id = $row->fields['id']; $hotelname = $row->fields['name']; $hotel = $row->fields['AccomName']; $retail = $row->fields['offer_retail']; $price = $row->fields['offer_price']; $gift = $row->fields['offer_gift']; $giftother = $row->fields['offer_add_gift']; $nights = $row->fields['offer_nights']; $days = $nights + 1; $bfoot = $row->fields['offer_foot']; $savings = $row->fields['offer_sav']; //Create the Promotional Offers Boxes $ofr = '

(Retail Value $'.$retail.')

'.$hotelname.'

~ for ~

'.$days.' Days and '.$nights.' Nights

~ plus receive ~
hotline prices'.$gift.'
'; if($giftother != '') { $ofr .= '
~ and ~
'.$giftother.'
';} if($bfoot != '') { $ofr .= '
~ and ~
'.$bfoot.'
';} $ofr .= '

GETAWAY PACKAGE PRICE:

$'.$price.'.00 Total

(You Save $'.$savings.')

'; // individual offer end // // Combine offer boxes $offers .= $ofr; $row->MoveNext(); // end of foreach } } else { echo "no conn"; exit(); } ?> Beach House Resort ยป Exclusive Getaway Vacations
Toll Free (800) 881-1227
hotline prices Vacationing with Island Dollars is more fun! Learn more...


Hotel Amenities

Hotel beach access Tiki Hut with live music year round Resort-style Pool
Fruit-infused water in the lobby Business Center Fitness Center
Keurig Coffee Maker On-site Parking Cable/Satellite TV
Wifi Available

Seasonal Room Prices

Low Middle High
Standard 2-Queen Bed, Non-Smoking $ $ $

General Hotel Information

Address:


Check-In/Out Times:

Check-in at .

Check-out at .


Hotel Requirements:

Payment types accepted at this hotel: .


Pet Policy: