The Rains Team
call for more info
404-620-4571
Ask a Question
Add to Favorites
Send to a Friend
Schedule a Showing
Request More Info
Our Financing Partner
Dalton Carter
Lender
Lic. 1566538
Office:
Direct: 678-425-4140
AP Mortgage
340 Jesse Jewell Parkway
Suite 500A
Gainesville, GA 30501
Apply for a Loan
For Sale
MLS Number 10541918
3 Bedrooms
3 Bathrooms
1 Half Baths
3,800 Square Feet *estimated
Set in the popular Turtle Cove Flamingo neighborhood, this 3-BR, 3-BA home offers a comfortable blend of space, style, and function. Thoughtfully planned, the interior provides 3,800 square feet of finished living space with an open, livable feel from room to room. A bright, open kitchen offers generous workspace, storage, and a direct view into the main gathering spaces. Open concept living and dining spaces create a comfortable setting for gatherings of all kinds. Step outside to approximately 0.407 acres, creating a comfortable setting for outdoor living and weekend gatherings. The property includes parking available for multiple vehicles, offering convenience for residents and guests. Residents of Turtle Cove Flamingo enjoy a blend of neighborhood charm and easy access to everyday conveniences. After roughly 188 days on the market, this home remains a strong option in the area. With an asking price of $995,000, this property represents an appealing opportunity in the current market.
From Jackson Lake Rd. Turn right onto Turtle cove trlwy, then right onto flamingo ct. The house is on the left in the cul-de-sac.
Association Fee Includes
Swimming
Tennis
Community Features
Clubhouse
Golf
Lake
Playground
Pool
Tennis Court(s)
Appliances
Dishwasher
Disposal
Dryer
Microwave
Refrigerator
Washer
Architectural Style
Contemporary
Basement
Bath Finished
Finished
Full
Construction Materials
Stucco
Fireplace Features
Living Room
Wood Burning Stove
Interior Features
Master On Main Level
Vaulted Ceiling(s)
Walk-In Closet(s)
Wet Bar
Kitchen Features
Kitchen Island
Laundry Features
In Basement
Financing Available
Cash
Conventional
Patio and Porch Features
Screened
Selling Status
Updated/Remodeled
Security Features
Carbon Monoxide Detector(s)
Smoke Detector(s)
Utilities
Cable Available
Electricity Available
Water Available
Window Features
Double Pane Windows
Lot Size
Less than .5 Acres
Water Front Features
Deep Water Access,Lake
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/homesforsaleatlanta.com/wwwroot/featuredprop/propdetails.cfm: line 1203
Called from C:/home/homesforsaleatlanta.com/wwwroot/featuredprop/propdetails.cfm: line 156
Called from C:/home/homesforsaleatlanta.com/wwwroot/featuredprop/propdetails.cfm: line 1
Called from C:/home/homesforsaleatlanta.com/wwwroot/404error.cfm: line 572
Called from C:/home/homesforsaleatlanta.com/wwwroot/404error.cfm: line 1
Called from C:/home/homesforsaleatlanta.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.210 |
| Referrer |
|
| Date/Time |
10-Dec-25 07:13 AM |
|
|
Stack Trace
|
at cfpropdetails2ecfm1672628300._factor21(C:/home/homesforsaleatlanta.com/wwwroot/featuredprop/propdetails.cfm:1203) at cfpropdetails2ecfm1672628300._factor23(C:/home/homesforsaleatlanta.com/wwwroot/featuredprop/propdetails.cfm:156) at cfpropdetails2ecfm1672628300.runPage(C:/home/homesforsaleatlanta.com/wwwroot/featuredprop/propdetails.cfm:1) at cf404error2ecfm1942838120._factor31(C:/home/homesforsaleatlanta.com/wwwroot/404error.cfm:572) at cf404error2ecfm1942838120._factor32(C:/home/homesforsaleatlanta.com/wwwroot/404error.cfm:1) at cf404error2ecfm1942838120.runPage(C:/home/homesforsaleatlanta.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 cfpropdetails2ecfm1672628300._factor21(C:\home\homesforsaleatlanta.com\wwwroot\featuredprop\propdetails.cfm:1203)
at cfpropdetails2ecfm1672628300._factor23(C:\home\homesforsaleatlanta.com\wwwroot\featuredprop\propdetails.cfm:156)
at cfpropdetails2ecfm1672628300.runPage(C:\home\homesforsaleatlanta.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 cf404error2ecfm1942838120._factor31(C:\home\homesforsaleatlanta.com\wwwroot\404error.cfm:572)
at cf404error2ecfm1942838120._factor32(C:\home\homesforsaleatlanta.com\wwwroot\404error.cfm:1)
at cf404error2ecfm1942838120.runPage(C:\home\homesforsaleatlanta.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)
|
|