At The Lake Vacation Rentals, LLC
+1 (603) 253-9871

Adirondack style Winnipesaukee waterfront home with 4 bedrooms and SW EXP
Please call for rates

Type: House
Dogs Allowed: No
Location: Meredith, NH

10

Sleeps

4

Beds

3

Baths

Overview

Adirondack style Winnipesaukee Waterfront home. Southwest exposure with sun all day, scenic views of the lake and mountains and breathtaking sunsets in the evenings.
Private 4-bedroom, 3-bathroom, open concept style home. Cathedral ceilings, living, kitchen, and dining area all on the main level. This level also features a bedroom with a queen-sized bed and a bathroom with a shower. Comfortable leather seating that surrounds the classic stone gas fireplace. Seating for 8 at the dining table, with additional seating at the breakfast bar in the kitchen. Enjoy the majestic views of the lake through the large, picturesque windows.
3-Season porch is also off the main living area for a little extra peace and quiet. Take advantage of the beautiful summer evenings outside while grilling for the group. Afterwards you and your guests can feast on the large outdoor furnished deck.
The primary suite offers a king-sized bed, lounge chair and bathroom with shower. The lower level also features 2 bedrooms and a full bathroom. A spacious living area for gathering, plenty of seating and a large-screen TV.
Meticulously landscaped waterfront lot with a path through the expansive backyard. Relax with an afternoon nap on the hammock and in the evenings, gather around the 6-seat fire pit while enjoying your company.
Waterfront deck and a 26\' private dock.
No pets are allowed at this property. Maximum occupancy for this home is 10. Maximum 4 vehicles at any one time at this home. Hot Tub is not for guest use.
Linens: Sheets, bath towel sets and arrival bedmaking service are all included with this rental. This DOES NOT include beach towels.
Please note: Amenities and furnishings can change at any time without notice. At Owner discretion, exterior cameras may be in place now or in the future.
This property is managed by At The Lake Vacation Rentals, LLC. State of New Hampshire Meals and Rentals Tax Operator\'s License #058822

Amenities

Clothes Dryer Washing Machine Wifi Free Wifi Dishwasher Lake Lake View Lakefront Water View Waterfront Full Kitchen Dishwasher Microwave Coffee Maker Toaster Washing Machine Dryer Central Air Air Conditioning Ceiling Fans Fireplace 3 Season Room Water Source Well Nearby ATM Nearby Post Office Nearby Bank Nearby Internet Cafe Wireless Internet Area FitnessCenter Nearby Grocery Outlet Shopping (30-45 minutes) Movie Theatres Golf Course Winnipesaukee Playhouse Bank of NH Meadowbrook Pavilion Perched Beach Steps into Water Natural Shorefront Dock Fire Pit Deck Patio Deck and/or Patio Furniture Gas Grill Waterfront Lakefront On Water Close to Town Southwestern Exposure Basic Cable TV Under $12000 Under $15,000 Under $20,000 Meredith Neck Road New Hampshire's Lakes Region Lake Winnipesaukee Lakes Region
\
Rates
Start Date End Date Weekly Nightly
03/11/2024 12/31/2026 $7,525.00 - $9,779.00 $1,075.00 - $1,397.00
SwipeDrag for Rates

Recent Reviews About This Property

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringselect * from be_reviews where unitcode = '1527-243184' and approved = 'Yes' order by createdAt desc
DatabaseName
stringMySQL
DatabaseVersion
string8.4.4-4
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-j-9.3.0 (Revision: 20ef8ee9eb4294a03858acccea0ddad3525f1ff9)
Datasource
stringbooking_clients
DataSource
stringbooking_clients
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringSELECT command denied to user 'icndshw5_bcdsn'@'192.168.0.42' for table 'be_reviews'
NativeErrorCode
number1142
queryError
stringselect * from be_reviews where unitcode = '1527-243184' and approved = 'Yes' order by createdAt desc
Sql
stringselect * from be_reviews where unitcode = '1527-243184' and approved = 'Yes' order by createdAt desc
SQLState
string42000
StackTrace
stringlucee.runtime.exp.DatabaseException: SELECT command denied to user 'icndshw5_bcdsn'@'192.168.0.42' for table 'be_reviews' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:990) at com.mysql.cj.jdbc.ClientPreparedStatement.$fr$execute(ClientPreparedStatement.java:384) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:307) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at booking.print_cfm$cf.call(/booking/print.cfm:155) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:761) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string153: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and&nbsp;approved&nbsp;=&nbsp;'Yes'<br> 154: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;order&nbsp;by&nbsp;createdAt&nbsp;desc<br> <b>155: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 156: <br> 157: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfquery&nbsp;name=&quot;getEscapiaReviews&quot;&nbsp;dataSource=&quot;#settings.booking.dsn#&quot;&gt;<br>
codePrintPlain
string153: and approved = 'Yes' 154: order by createdAt desc 155: </cfquery> 156: 157: <cfquery name="getEscapiaReviews" dataSource="#settings.booking.dsn#">
column
number0
id
string??
line
number155
Raw_Trace
stringbooking.print_cfm$cf.call(/booking/print.cfm:155)
template
string/var/www/domains/lakesregionrentals.com/htdocs/booking/print.cfm
type
stringcfml
type
stringdatabase
where
string