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(); } ?> <?=$venshortname?> » Exclusive Getaway Vacations
Toll Free (800) 881-1227
hotline prices Vacationing with Island Dollars is more fun! Learn more...

Wave Runners

Come and enjoy a thrilling 75-minute ride on the newest VX Yamaha Wave Runners.

Departing from the docks of Palmetto Bay, you follow a One HHI guide as you idle through the heart of the island, Broad Creek. Broad Creek geographically divides Hilton Head, extending 6 miles inland, and flows eastward into the Calibogue Sound.

As you ride through the creek, you enjoy views of some of the most sought-after properties in Hilton Head’s real estate market. After making your way down the creek, you open up to the largest riding area the island has to offer, the Calibogue Sound.

Once you hit the Calibogue, you are able to cruise at your own pace, tailoring your ride to your liking. Whether you choose a fast and riveting ride or cruise slow and steady, you are able to take in the beautiful surroundings of the Lowcountry and its indigenous wildlife, such as our Atlantic bottlenose dolphins!



Things to Know Before You Go:
  • Duration: 1.25 hours
  • Ages 6+
  • Must be 18 years old with a valid drivers license to operate
  • 450 lbs. weight limit

Website:


Address: