For Sale
MLS Number 10609146
4 Bedrooms
4 Bathrooms
1 Half Baths
4,100 Square Feet *estimated
Set outside of a traditional subdivision in Cumming, this well cared for 4-bedroom, 4-bath home offers space, comfort, and freedom from HOA restrictions. With 4,100 square feet of finished living space, this floor plan offers generous gathering spaces as well as comfortable private retreats. The kitchen was planned for both everyday meals and special occasions, with plenty of room to cook, serve, and connect. The main living areas are filled with natural light and provide an easy flow for hosting friends or enjoying quiet evenings at home. Outside, the property offers approximately 0.45 acres, giving ample room to relax, play, or plan future outdoor projects. The property includes parking available for multiple vehicles, offering convenience for residents and guests. Set outside of a formal subdivision, this address in Cumming offers a more independent feel with no mandatory HOA. With approximately 82 days on the market, this home is well positioned for the next owner. With an asking price of $1,587,000, this property represents an appealing opportunity in the current market.
From Walmart in Cumming, turn L onto Market Place Blvd. In 0.3 mi, turn R onto Buford Hwy. In 0.2 mi, turn R onto 400 N. In 3.6 mi, take exit 16 onto Pilgrim Mill Road. In 0.4 mi, turn R onto Pilgrim Mill Rd. In 2.0 mi, take a slight R turn onto Sinclair Shores Rd. In 300 ft, turn R onto Sinclair Shores Road. In 0.6 mi, turn L onto Bald Ridge Park Rd. In 600 ft, turn R onto Merritt Drive. In 150 ft, the destination is on your left. Sign in place.
Association Fee Includes
Other
Community Features
Lake
Sidewalks
Street Lights
Architectural Style
Contemporary
European
Traditional
Construction Materials
Brick
Other
Dining Room Features
Dining Rm/Living Rm Combo
Fireplace Features
Basement
Family Room
Gas Log
Other
Interior Features
Beamed Ceilings
Double Vanity
High Ceilings
Tile Bath
Vaulted Ceiling(s)
Walk-In Closet(s)
Kitchen Features
Breakfast Area
Breakfast Bar
Kitchen Island
Pantry
Second Kitchen
Walk-in Pantry
Laundry Features
In Mud Room,Upper Level
Financing Available
1031 Exchange
Cash
Conventional
FHA
USDA Loan
VA Loan
Patio and Porch Features
Deck
Patio
Porch
Selling Status
New Construction
Rooms
Family Room
Game Room
Great Room
Laundry
Office
Utilities
Cable Available
Electricity Available
High Speed Internet
Phone Available
Water Available
Lot Size
Less than .5 Acres
Lot Features
Level
Open Lot
Private
Water Front Features
Lake,Lake Access,Private
Waterfront Frontage
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
|
Element WATERFRONTFRONTAGE is undefined in GETMLS.
|
|
|
| |
The error occurred in C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm: line 1203
Called from C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm: line 156
Called from C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm: line 1
Called from C:/home/rainsteamflowerybranch.com/wwwroot/404error.cfm: line 572
Called from C:/home/rainsteamflowerybranch.com/wwwroot/404error.cfm: line 1
Called from C:/home/rainsteamflowerybranch.com/wwwroot/404error.cfm: line 1
|
1201 : <cfif getmls.waterfrontfootage GT 0>
1202 : <div id="propdetailsfeatures">
1203 : <div id="propdetailsfeatureslist">Waterfront Frontage</div><div id="propdetailsfeaturesitem">#getmls.waterfrontfrontage#</div>
1204 : </div><!-- prop details features -->
1205 : </cfif>
|
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
216.73.216.153 |
| Referrer |
|
| Date/Time |
10-Dec-25 10:44 AM |
|
|
Stack Trace
|
at cfpropdetails2ecfm361942929._factor21(C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm:1203) at cfpropdetails2ecfm361942929._factor23(C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm:156) at cfpropdetails2ecfm361942929.runPage(C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm:1) at cf404error2ecfm588997773._factor31(C:/home/rainsteamflowerybranch.com/wwwroot/404error.cfm:572) at cf404error2ecfm588997773._factor32(C:/home/rainsteamflowerybranch.com/wwwroot/404error.cfm:1) at cf404error2ecfm588997773.runPage(C:/home/rainsteamflowerybranch.com/wwwroot/404error.cfm:1)
coldfusion.runtime.UndefinedElementException: Element WATERFRONTFRONTAGE is undefined in GETMLS.
at coldfusion.runtime.DotResolver.resolveSplitNameInMap(DotResolver.java:143)
at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:2034)
at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:2354)
at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:2344)
at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:2324)
at cfpropdetails2ecfm361942929._factor21(C:\home\rainsteamflowerybranch.com\wwwroot\featuredprop\propdetails.cfm:1203)
at cfpropdetails2ecfm361942929._factor23(C:\home\rainsteamflowerybranch.com\wwwroot\featuredprop\propdetails.cfm:156)
at cfpropdetails2ecfm361942929.runPage(C:\home\rainsteamflowerybranch.com\wwwroot\featuredprop\propdetails.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
at cf404error2ecfm588997773._factor31(C:\home\rainsteamflowerybranch.com\wwwroot\404error.cfm:572)
at cf404error2ecfm588997773._factor32(C:\home\rainsteamflowerybranch.com\wwwroot\404error.cfm:1)
at cf404error2ecfm588997773.runPage(C:\home\rainsteamflowerybranch.com\wwwroot\404error.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
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:60)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
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:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
|
|