Unit 1 - Loggerhead Inn


Type: Condo-hotel Unit View: Surrounding Views Area: Loggerhead Inn
1 Beds 1 Baths Sleeps 4 yes
Description

622 N. New River Dr., Unit 1, Surf City

Located less than one mile from the iconic Topsail Island "swing bridge” in the heart to Surf City, the Loggerhead Inn is a historic, boutique Topsail Island Hotel. Offering 36 guest rooms of varying sizes and price points, as well as a private swimming pool and unbeatable location directly across from a prime beach access, the Loggerhead Inn is an amazing slice of paradise for travelers looking for relaxation and uncrowded beaches and also those looking for fishing, surfing and exploring! Under new ownership and management in 2018, extensive room upgrades and improvements have been made to meet the expectations of today’s discerning traveler. Whatever you are looking for, the Loggerhead Inn will provide the perfect lodging choice for your visit to Surf City and the Topsail Island area!

Each individual condo-hotel unit offers new bedding, cable TV, WIFI, a mini fridge, microwave, Keurig style coffer maker, along with new and inviting decor, and bathroom with fresh bath linens. The Bedding and Bath package is provided with beds pre-made prior to arrival and fresh bath linens in the en suite bathroom! On site amenities include a shared gravel lot with a parking space right in front of the unit, a community-style picnic area, and a private complex pool! The public beach access is just up the street and the complex is walking distance to shops and restaurants!

This unit:
  • 2 Queen bed suite with private connected bath offering walk-in shower.
  • Maximum Occupancy: 4.
  • The Bedding and Bath Linen Package with beds made prior to arrival is included!
  • Single level on ground level - no stairs - paved lot with parking directly in front of room with covered wooden boardwalk entry - great feature for mobility challenged!
  • Window unit heat & air, ceiling fans, mini-fridge, coffee maker, microwave.
  • Room has been nicely updated for 2018!
  • Cable TV.
  • Wireless high speed internet access.
  • Loggerhead Inn private complex pool (available by Memorial Weekend, closes by October 1st; may open as early as May 15th and close as early as Labor Day).
  • Short walking distance to public beach access.
  • Walking distance to area shops and restaurants.
  • No smoking allowed in room. Guests who smoke or use vapor type devices in rooms will be charged an additional $200 fee for cleaning and restoration.
  • 1 dog allowed - $25 per night plus tax non-refundable pet rent applies. This amount is not included in initial Quote for your stay and is to be paid prior to arrival. The only dogs permitted must be friendly, housebroken, flea free dogs over 12 months old that are on a veterinarian approved monthly flea/tick treatment and prevention program. Dogs are not permitted on furniture. We understand that many dogs naturally shed - guests should take steps to remove pet hair prior to Check Out. Guest is responsible for any accidental damages that occur such as carpet stains or damage to walls, floors, or furniture. Unreported pet damages may result in additional charges to guests.
  • Nightly stays are permitted - 2 night minimum stay required.
  • ...Show More
    Calendar
    Available
    Unavailable
    Check-In
    Check-Out
    SwipeDrag for Availability

    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.

    Subquery returns more than 1 row
     
    The error occurred in E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/components/Homeaway.cfc: line 1671
    Called from E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/_rates-tab.cfm: line 1
    Called from E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/property.cfm: line 35
    Called from E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/components/Homeaway.cfc: line 1671
    Called from E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/_rates-tab.cfm: line 1
    Called from E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/property.cfm: line 35
    1669 : 			from
    1670 : 				pp_season_rates where
    1671 :    			strpropid = <cfqueryparam CFSQLType="CF_SQL_VARCHAR" value="#arguments.strpropid#">
    1672 : 			group by start_date
    1673 : 			order by start_date
    

    SQLSTATE   21000
    DATASOURCE   topsail_realty_v12
    VENDORERRORCODE   1242
    SQL    select dtBeginDate as start_date,dtEndDate as end_date, (SELECT dblrate from pp_season_rates er2 where strpropid = (param 1) and er2.dtBeginDate = pp_season_rates.dtBeginDate and strChargeBasis = 'Daily') as nightly_rate, (SELECT dblrate from pp_season_rates er3 where strpropid = (param 2) and er3.dtBeginDate = pp_season_rates.dtBeginDate and strChargeBasis = 'Weekly') as weekly_rate from pp_season_rates where strpropid = (param 3) group by start_date order by start_date
    Resources:

    Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
    Remote Address   18.212.222.217
    Referrer  
    Date/Time   15-Feb-19 09:11 PM
    Stack Trace
    at cfHomeaway2ecfc1166752651$funcGETPROPERTYRATES.runFunction(E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/components/Homeaway.cfc:1671) at cf_rates2dtab2ecfm2126936842.runPage(E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/_rates-tab.cfm:1) at cfproperty2ecfm1011332538.runPage(E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/property.cfm:35) at cfHomeaway2ecfc1166752651$funcGETPROPERTYRATES.runFunction(E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/components/Homeaway.cfc:1671) at cf_rates2dtab2ecfm2126936842.runPage(E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/_rates-tab.cfm:1) at cfproperty2ecfm1011332538.runPage(E:/inetpub/wwwroot/domains/topsail-realty.com/htdocs/booking/property.cfm:35)

    java.sql.SQLException: Subquery returns more than 1 row
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    	at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2047)
    	at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1921)
    	at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3278)
    	at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:462)
    	at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2997)
    	at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2245)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2638)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
    	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
    	at com.mysql.jdbc.PreparedStatement.$fr$execute(PreparedStatement.java:1199)
    	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java)
    	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
    	at coldfusion.sql.Executive.executeQuery(Executive.java:1501)
    	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
    	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
    	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
    	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
    	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
    	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
    	at cfHomeaway2ecfc1166752651$funcGETPROPERTYRATES.runFunction(E:\inetpub\wwwroot\domains\topsail-realty.com\htdocs\components\Homeaway.cfc:1671)
    	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
    	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
    	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
    	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
    	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
    	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:643)
    	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432)
    	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402)
    	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483)
    	at cf_rates2dtab2ecfm2126936842.runPage(E:\inetpub\wwwroot\domains\topsail-realty.com\htdocs\booking\_rates-tab.cfm:1)
    	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
    	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
    	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
    	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000)
    	at cfproperty2ecfm1011332538.runPage(E:\inetpub\wwwroot\domains\topsail-realty.com\htdocs\booking\property.cfm:35)
    	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
    	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
    	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
    	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
    	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
    	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
    	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
    	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
    	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
    	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
    	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
    	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
    	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
    	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
    	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
    	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
    	at coldfusion.CfmServlet.service(CfmServlet.java:219)
    	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
    	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
    	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764)
    	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
    	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
    	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801)
    	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
    	at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
    	at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
    	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
    	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
    	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.lang.Thread.run(Thread.java:748)