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']; $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(); } ?> Holiday Inn Express ยป Exclusive Getaway Vacations
Toll Free (800) 881-1227
hotline prices Vacationing with Island Dollars is more fun! Learn more...


Hotel Amenities

Complimentary Hot Breakfast Free Parking, including bus parking Outdoor Heated Pool
Free Wall Street Journal Daily Business Center Fitness Center
Picnic Area Cable/Satellite TV Local Bike Path Access
Free WiFi Free Shuttle to Beach and Area Shops (Seasonal) Bicycle Rental (Seasonal)

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: