Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
 
The error occurred in \\ocean\html\myrtlebeachgolfhotels_com\Application.cfm: line 60
 
58 : 
59 : 	<cfquery name="getSpecialsRotator" datasource="#dsn#">
60 : 		select rotationCount from featuredPackagesRotation <cfif url.accomid neq 0>where accomId = #Trim(url.accomid)#<cfelse> where (accomid=#getFeaturedAccomodation.accomId#)</cfif> and
61 : 		(website='oceanresortsgolf.com')
62 : 	</cfquery>
VENDORERRORCODE   102
SQLSTATE   HY000
SQL    select rotationCount from featuredPackagesRotation where (accomid=) and (website='oceanresortsgolf.com')
DATASOURCE   oceanResorts
Resources:

Browser   ColdFusion
Remote Address   66.153.188.182
Referrer  
Date/Time   07-Sep-10 08:48 PM
Stack Trace
at cfApplication2ecfm1377266738.runPage(\\ocean\html\myrtlebeachgolfhotels_com\Application.cfm:60) at cfApplication2ecfm1377266738.runPage(\\ocean\html\myrtlebeachgolfhotels_com\Application.cfm:60) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533)
	at cfApplication2ecfm1377266738.runPage(\\ocean\html\myrtlebeachgolfhotels_com\Application.cfm:60)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:261)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53)
	at coldfusion.CfmServlet.service(CfmServlet.java:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

   Litchfield Beach & Golf Resort


Valid Dates: -
Arrival Days:
Length of Stay: nights minimum -- nights maximum
14276 Ocean Hwy
Pawleys Island, SC  29585

View More Images
map it |  driving directions  | website 		Rates from (USD): $46.00

Relax and enjoy the ultimate vacation at Litchfield Beach & Golf Resort. Our Resort is perfectly located in the beautiful Litchfield Beach/Pawleys Island section of the Grand Strand. This location affords our guest easy access to all the sights and sounds of Myrtle Beach, yet still offers that secluded, "away from it all" feeling a vacation should have. The Litchfield / Pawleys Island area has been a favorite family vacation destination for centuries, where visitors come to enjoy the warm waters and cool breezes of the Atlantic. The area has retained its historic Lowcountry charm, and today offers a superb selection of recreational amenities, including golf, tennis, shopping and dining, along with the most beautiful beaches on the East Coast. Experience your dream vacation at Litchfield Beach & Golf Resort.
Check-in: 4:00 PM   Check-out: 11:00 AM
What to expect: Spread over 4,300 acres, the resort never feels crowded even in the busiest seasons. While golf and tennis are the principal appeals, vacationers interested in sunbathing, the beach, and water attractions also come for relaxing, tranquil holidays.

Amenity highlights: Two outdoor pools, two indoor pools, spa tubs, and a 200-foot lazy river offer diversions apart from golf on the resort's three courses and tennis on 17 clay courts at the resort's renowned Litchfield Racquet Club. The miles-long, uncrowded beach provides year-round walking opportunities and seasonal swimming-and-sunning. Salt marshes, lakes, and streams delight birdwatchers.

Insider tip: Louis' at Pawleys, a widely known restaurant serving refined Lowcountry cooking, is located 3 miles from the resort within the Hammock Shops, a collection of shops and galleries shaded by trees.

Services/Amenities:
A health-and-beauty spa offers massage, body scrubs and wraps, facials, and hair and nail care. A fitness center provides cardio and weight machines, free weights, and also a sauna and steam room. An air-conditioned business center features two computers offering complimentary high-speed Internet access (restricted to guests age 18 and older).

  • Swimming pool - indoor
  • Swimming pool - children's
  • Full-service health spa
  • Sauna 
  • Fitness equipment
  • Restaurant(s) in hotel
  • Limo or Town Car service (surcharge)
  • Ballroom(s)
  • Conference room(s)
  • Internet access in public areas - high speed
  • Audio-visual equipment
  • Security guard
  • Safe-deposit box - front desk
  • Hair salon
  • Shopping on site 
  • Elevator/lift
  • Airport transportation (surcharge)
  • Swimming pool - outdoor
  • Spa tub
  • Steam room
  • Concierge desk
  • Health club
  • Bar/lounge
  • Parking (free)
  • Business center
  • Banquet facilities
  • Meeting rooms (small groups)
  • Internet access in public areas - complimentary
  • Porter
  • 24-hour front desk
  • Tour assistance
  • Gift shops
  • Fireplace in lobby
  • Air-conditioned public areas
  • Wedding services

Rooms
The 4,300-acre resort offers the following guest accommodations:
  • Two four-story condominium building a half-mile from the beach containing rooms, one-bedroom and 2 bedroom condominium. (No ocean view.)
  • A six-story condominium building facing the beach containing oceanfront one and two bedroom condominiums. (Ocean view not guaranteed.)
  • One- and two-story villas offering scenic-view two, three and four bedroom accommodations in complexes located between the main resort complex and the beach.  (No ocean view.)
  • One- and two-story villas offering two, three and four bedroom fairway accommodations adjacent to one of the resort's three golf courses. (No ocean view.)

Water attractions near the main resort complex comprise a 75-foot-long outdoor pool and, under a translucent roof, a 50-foot-long indoor pool and four-person spa tub.  The outdoor pool features a lazy river, outdoor spa, kiddie pool and play plaza. These pools are accessible to all suite, villa and condominium guests of Litchfield Beach and Golf Resort.

Water attractions near buildings containing oceanfront one and two bedroom condominiums include an oceanfront pool complex lined by palm trees and sheltered from east winds by beach-grass-covered dunes. The complex comprises a 200-foot lazy river with tubes, a 75-foot-long pool, a toddlers' pool, and an eight-person spa tub. Within one of the buildings are a 45-by-15-foot indoor pool and four-person spa tub. This oceanfront complex is for the exclusive guests of the oceanfront Bridgewater guests.

Villas' guests enjoy exclusive access to pools located within or near each complex of villas throughout the resort.
Recreation
The sprawling, 4,300-acre resort features three 18-hole golf courses flanked by fairway-villa accommodations and situated across Highway 17 (Ocean Highway) from buildings with suites and villas offering scenic views. The courses are Litchfield Country Club, River Club, and Willbrook Plantation, each occupying a former rice plantation and featuring moss-draped oak trees and small lakes. The resort also arranges tee times at the remainder of the Myrtle Beach area's 120 golf courses.

The resort's renowned Litchfield Racquet Club offers instruction and features 17 clay tennis courts (surcharges for play). Play on hard-surface tennis courts scattered throughout the resort is complimentary. Use of a racquetball court in the Health & Fitness Center is available for a small surcharge.

The resort provides scheduled shuttle service in summer between the main resort complex and the beach, a half-mile away. The principal beach-access point features wood sunning decks furnished with lounge chairs and wood-shingle shades. Wooden stairways to the beach cross low dunes covered by fragile grasses. Rental umbrellas and beach chairs are available. The resort doesn't offer water sports equipment, but independent operators nearby rent equipment in summer.

The resort encompasses the expansive salt marshes characteristic of the Lowcountry and home to wildlife and birds. Rental bicycles offer birdwatchers an opportunity to view around the vast resort.  Newly expanded bicycle paths give you a broader scope of wildlife and nature activities.

The recreational activities listed below are available either on-site or near the resort; fees may apply.

  • Golfing on site
  • Jet skiing nearby
  • Scuba diving nearby
  • Snorkeling nearby
  • Racquetball on site
  • Running track/path on site 
  • Bicycle rentals on site
  • Fishing nearby
  • Golf - driving range on site
  • Sailing nearby
  • Windsurfing nearby
  • Swimming on site
  • Tennis on site  
  • Hiking/biking trails on site
  • Parasailing nearby
  • Bird watching on site

Policies
Note: Guests age 20 and under are not permitted unless accompanied by an adult.

Extra person charges apply.
For surcharges, rollaway beds and cribs (infant beds) are available and should be requested at the time of booking.
Photo identification and credit card or cash deposit are required at check-in for incidental charges.
Special requests are subject to availability upon check-in. Special requests made via this Web site cannot be guaranteed and may incur additional charges.

  • Pets not allowed
  • Check-in time is 4 PM
  • Check-out time is 11 AM
Dining
Webster's Lowcountry Grill & Tavern - Air-conditioned dining room and outdoor deck seating. Leather-couch lounge with large-screen television.  Buffet and à la carte breakfast serving daily. Dinner choices vary seasonally and menus are chosen by our executive chef. We offer a variety of seafood, steaks and more daily.

Each of the three golf course clubhouses includes a restaurant, with meal offerings and hours varying by season.
Property Images
Litchfield Beach & Golf Resort
14276 Ocean Hwy
Pawleys Island, SC  29585

View More Images
map it |  driving directions  | website 		Rates from (USD): $46.00


Litchfield Beach & Golf Resort Specials

1) 2011 Saturday Summer Weekly Rentals - Arrive Saturday for a full week stay in oceanfront, oceanview or scenic accommodations.
Book Now
2) 2011 Sunday Summer Weekly Rentals - Arrive Sunday for a full week stay in oceanfront, oceanview or scenic accommodations.
Book Now
3) Bring Your Sweetheart To The Beach And Enjoy Our Romantic Getaway Retreat - Save more than 30% on this romantic package that includes a massage or facial and champagne for two.
Book Now
4) Enjoy A Delicious Breakfast Buffet on this special deal and SAVE! - Enjoy great savings while you have a delicious buffet breakfast each morning of your stay!
Book Now
5) Enjoy beautiful mornings in Paradise with our Starbucks Bed & Breakfast Getaway! - Enjoy a continental breakfast at Starbucks PLUS up to 30% savings on your accommodations!
Book Now
6) Getaway to Sunshine with up to 30% savings on this All Inclusive Package that includes a full breakfast buffet each morning! - Enjoy Beautiful Litchfield Beach and Brookegreen Gardens on this all inclusive package!
Book Now
7) Litchfield Tennis Special - Come to one of the Country's TOP tennis resorts at TOP SAVINGS!
Book Now
8) Save 30% on your vacation when you arrive any Sunday or Monday and stay 3 or more nights! - Hurry! This special has a limited time offer and may expire soon!
Book Now
View All Specials

Litchfield Beach & Golf Resort Golf Packages

1) 20% OFF Tee Times This Fall! - The Prime Times Signature courses are currently offering 20% OFF the regular price for Fall 2010! Courses include King's North, Wild Wing, Long Bay Club and 11 others.
Book Now
2) 3 Round Plantation Golf Spectacular Savings Event! - Save BIG on the return of our Resort Golf Special! Savings of up to $25 per round!
Book Now
3) 3 Round Resort Summer Golf Special - Enjoy the lowest prices of the summer on our 3 round summer resort special!
Book Now
4) 50% OFF Tee Times - Fall 2010  - Play before 8:00am & save big!!! Tee times from just $30 this fall - choose from 14 Award-Winning courses. Including TPC of Myrtle Beach, Wild Wing,Tradition Club, Blackmoor, River Club and Willbrook.
Book Now
5) Enjoy the best of golf on the South Strand on the Waccamaw Trail! - Enjoy the best experience on the South Strand on the Award Winning Waccamaw Trail!
Book Now
6) Golf the Award Winning Waccamaw Trail with no restrictions on length of stay or number of rounds! - Enjoy the best of the south end golf courses when you golf the Waccamaw Golf Trail!
Book Now
7) Myrtle Beach's Best 7-Round Package! - Prime Times - Play 6 rounds & get your 7th FREE! Choose from 14 award-winning designs, including: King's North, TPC of Myrtle Beach & Long Bay Club.
Book Now
8) Prime Times - Play 2, Get 1 FREE This Fall! - Get a FREE round this Fall and SAVE up to $90 per golfer. Rates begin at just $54 for each round! This Fall 2010 special is valid today through 11/14/10.
Book Now
9) Prime Times - Play 3, Get 2 FREE This Fall! - Play 3 Prime Times Courses this fall and get 2 additional rounds for FREE. Courses include King's North, TPC of Myrtle Beach & Long Bay Club.
Book Now
10) Prime Times Signature Play 4, Get 1 FREE This Fall - Myrtle Beach's most popular golf package. Choose 4 award-winning courses and your 5th round is FREE! Courses include Myrtle Beach National, Blackmoor & River Club.
Book Now
11) The Player's Choice - Choose From ALL Myrtle Beach Area Courses!  - Rounds From Just $34 This Summer & $42 This Fall! SAVE BIG with weekday and afternoon rates on Myrtle Beach's best courses; including Willbrook, River Club and Blackmoor.
Book Now
12) The Ultimate Golf Insider Experience - Our best golf package ever! Each player receives $65 in gift cards when you play 3 rounds or more on your choice of 32 top-rated courses!
Book Now
View All Golf Packages