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...

Pinecrest Plantation Golf Club

Tucked away in the beautiful South Carolina Lowcountry, Pinecrest Golf Club is peacefully secluded, yet decidedly exciting. The 18-hole championship golf course is a worthy challenge for any golfer — with water, trees and sand traps ready to greet you, even on the shortest holes.

Pinecrest offers an assortment of amenities, including a continuously stocked pro shop. Here featured is the best public practice facility in Bluffton: a double-sided range, two large putting greens and a chipping green.

Home of the IJGA - International Junior Golf Academy



Club Amenities:
  • Semi-Private
  • Pro Shop
  • Club Rental
  • Double-sided Practice Range
  • Two Large Putting Greens
  • Chipping Area
  • Practice Bunker
  • GPS
  • Golf School
  • Food and Beverage


Course Details:
  • Course Architect: Rocky Roquemore
  • Number of Holes: 18
  • Par 72
  • Yardage: 6,881
  • Slope: 140
  • Rating: 73.1


Website:


Address:


Phone:


Hours:

Summer Hours (Apr 1 - Sep 30):
Course: 8:00am to 8:00pm
Practice Tee: 7:30am to Dusk
Pro Shop: 7:30am to 6:00pm

Seasonal Hours (Oct 1 - Mar 31):
Course: 8:30am to Dusk
Practice Tee: 8:00am to Dusk
Pro Shop: 8:00am to 5:30pm


About:

Proper Golf Attire required