Isle Fly Away


Type: House View: Surrounding Views Area: Surf City
3 Beds 2.5 Baths Sleeps 10 yes
Description

304 New Bern Ave., Surf City

You won't want to leave the welcoming nest at Isle Fly Away! With a fantastic location just a block from the beach and just north of downtown Surf City, this cottage offers an in-town budget friendly location that works for 2 families! The lower level provides the main living, dining, and kitchen as well as two bedrooms and 1.5 baths. The upstairs apartment, accessed via a private entry with exterior stairs only, additionally affords a bedroom, bathroom, seating area, and kitchenette. The outside spaces including the open and covered deck areas, screened porch on the side, and yard area are just right for hanging out with your canine companions or playing a friendly yard game. The house is being freshly painted and updated for the 2017 rental season! And to add to the appeal, the surrounding views from ocean to sound are complimentary!

  • Downstairs: 2 Bedrooms, 1.5 Baths. Upstairs: 1 Bedroom, 1 Bath.
  • Maximum Occupancy: 10.
  • Bed sizes downstairs: Queen, Queen + 1 Set of Bunks. Bed sizes upstairs: Queen + Sleeper Sofa.
  • The Bedding and Bath Linen Package for advertised bedrooms and baths with beds made prior to arrival is included! Top bunks are not pre-made. Bedding is not typically provided for sleeper sofas.
  • Central heat & air, dishwasher (downstairs), washer/dryer (upstairs and downstairs).
  • 4 cable (digital service) TVs including 1 TV upstairs.
  • Wireless high speed internet access.
  • Covered porch and open deck spaces with furniture.
  • Screened side porch.
  • Back yard area.
  • No outside shower.
  • Grilling allowed. No grill provided.
  • No smoking allowed in house.
  • Up to 4 dogs allowed - $150/week plus tax pet rent per dog.
  • Partial week getaways permitted - 3 night minimum stay required. Must be booked within 10 days of arrival within Saturday-Saturday time frame.
  • The public beach access is at the beginning of New Bern Ave.
    View the video tour.
  • Every effort is made to ensure that all information and photographs in Carolina Retreats’ advertising are accurate and complete. Rate information for properties is subject to change and the quote provided online is only valid at the time of booking. Carolina Retreats cannot be held responsible for possible typographical errors; omissions; price changes; changes in taxes; changes to Terms and Conditions; or changes made by vacation home owners in furnishings, equipment, or bed arrangements. Vacation homes are privately owned and changes may be made to homes or their contents. Carolina Retreats reserves the right to correct any errors.

    ...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 07:52 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)