870 Longstone Landing

870 Longstone Landing, Alpharetta, GA 30022

For Sale
MLS Number 10612488
6 Bedrooms
5 Bathrooms
0 Half Baths
Square Footage - Not Provided
Welcome to your newly renovated lakefront home in the highly sought-after swim/tennis community of Glenn Abbey! This stunning four-sided brick home impresses from the start with its grand two-story foyer and soaring 18-foot windows in the great room, showcasing breathtaking views of the lake. The chef's kitchen has been beautifully remodeled, as have all bathrooms, creating a modern, move-in ready feel. With two fireplaces on the main level, the home is perfect for both everyday living and entertaining. Step onto the expanded oversized deck and enjoy peaceful moments overlooking the water. Freshly painted throughout with refinished hardwood floors, this home offers 6 bedrooms and 5 bathrooms, providing space for the entire family. A bedroom with full bath on the main level is ideal for guests or multigenerational living. Upstairs, the oversized primary suite features its own fireplace, a luxurious spa-like bath, and serene lake views-your private retreat. Three additional bedrooms complete the upper level. The fully finished terrace level adds even more living space with a walkout to the backyard, abundant storage, and potential for future customization. This rare lakefront opportunity blends elegance, functionality, and resort-style living-all in a prime Johns Creek location. Don't miss the chance to make this your forever home!
County
Neighborhood
Year Built
2000
Lot Size
.5 to 1 Acre
Taxes
$11,616
High School
Middle School
Elementary School
Appliances
Dishwasher,Disposal,Double Oven,Microwave,Refrigerator
Architectural Style
Brick 4 Side,Traditional
Association
Yes
Association Fee
$1,650
Initiation Fee
$3,000
Association Fee Includes
Reserve Fund,Swimming,Tennis
Basement
Bath Finished,Daylight,Exterior Entry,Finished,Interior Entry
Community Features
Clubhouse,Park,Playground,Pool,Sidewalks,Street Lights,Swim Team,Tennis Court(s)
Construction Materials
Brick
Cooling
Ceiling Fan(s),Central Air
Dining Room Features
Seats 12+
Fencing
Wood
Fireplace Features
Gas Starter,Master Bedroom
Flooring
Carpet,Hardwood,Laminate,Tile
Heating
Forced Air
Home Warranty
No
Interior Features
Bookcases,High Ceilings,Rear Stairs,Walk-In Closet(s)
Kitchen Features
Breakfast Area,Kitchen Island,Walk-in Pantry
Laundry Features
In Mud Room
Levels
Three Or More
Financing Available
Cash,Conventional
Lot Features
Private
Lot Size Estimated
0.62
Tax ID Number
11 003000051558
Parking Features
Attached,Garage,Garage Door Opener,Kitchen Level,Side/Rear Entrance
Parking Total
3
Patio and Porch Features
Deck
Selling Status
Resale
Roof
Composition
Rooms
Family Room,Great Room,Keeping Room,Laundry
Security Features
Security System
Sewer Type
Public Sewer
Total Fire Places
3
Utilities
Cable Available,Electricity Available,Natural Gas Available,Phone Available,Sewer Available,Underground Utilities,Water Available
View
Lake
Water Source
Public
Water Front Features
No Dock Or Boathouse
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 549
Called from C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm: line 136
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
 
547 : 		<cfif getmls.waterfrontfootage GT 0>
548 : 	<div id="propdetailsfeatures"> 
549 :    		<div id="propdetailsfeatureslist">Waterfront Frontage</div><div id="propdetailsfeaturesitem">#getmls.waterfrontfrontage#</div> 
550 :    	</div><!-- prop details features -->
551 : 		</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   08-Dec-25 08:57 AM
Stack Trace
at cfpropdetails2ecfm361942929._factor14(C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm:549) at cfpropdetails2ecfm361942929._factor19(C:/home/rainsteamflowerybranch.com/wwwroot/featuredprop/propdetails.cfm:136) 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._factor14(C:\home\rainsteamflowerybranch.com\wwwroot\featuredprop\propdetails.cfm:549)
	at cfpropdetails2ecfm361942929._factor19(C:\home\rainsteamflowerybranch.com\wwwroot\featuredprop\propdetails.cfm:136)
	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)