My Office Location:
American Associates

,
 
Listings Presented by:
Randy Haney
Call: 810-691-4124
Fax: 888-696-4544
Office: 810-733-3435
2748 TURTLE LAKE DRIVE
BLOOMFIELD HILLS, MI. 48302
$2,875,000
5 Beds 7 Baths 4,983 Sq Ft
Schools: Pontiac 1.12 Acres Year Built: 2001
Property Description
Welcome to this beautifully updated home, Built TSA and designed by Alex Bogaerts, this grand limestone estate is located on a lush, wooded 1+ acre site in the gated community of Turtle Lake. As you step inside this former model home, you'll be greeted by a stunning first floor completely updated in 2023. The master bedroom boasts a new custom bathroom with quartz vanity tops, adding a touch of elegance to your morning routine. The first floor features new wood flooring throughout all of the first floor. an updated staircase, and new chandeliers that adds a touch of glamour with a limestone fireplace, and mahogany doors The kitchen is a chef's dream, with all-new custom cabinets, quartz countertops, and top-of-the-line appliances, including an icemaker and cappuccino machine. Step down to the finished walk-out basement, where you'll find a new theater room complete with a projector and speakers, and a beautifully updated kitchen with a BAR and new complete appliances, perfect for entertaining guests. The basement also offers a fireplace, workout room an additional bedroom, and two full bathrooms. Rest easy knowing your home is equipped with security system cameras. Outside, the landscaping has been updated with floodlights and a complete new deck is being finished. Other features include a full house backup generator and four new one-piece toilets with bidets and heated seats. Don't miss your chance to call this beautifully updated home your own. Please only pre-qualified buyers with proof of financing or funds emailed to Amy Jindo before showings. All measurements to be verified &dimensions are approximate. I.D.R.B.N.G. B.A.T.V.A.I.
Features
Baths: 5 full, 2 half
Style: Colonial,Country French
Subdivision: TURTLE LAKE CONDO
Construction: Brick,Stone
Exterior: Brick,Stone
Exterior Misc: Whole House Generator,Gate House
Porchs: Balcony,Porch - Covered,Patio,Porch,Breezeway,Patio - Covered
Fireplaces: 1
Garage: 3 Car
Garage Description: Direct Access,Attached
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Wine Cooler,Built-In Freezer,Built-In Gas Oven,Convection Oven,Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Cooktop,Microwave,Washer,Bar Fridge
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Dual-Flush Toilet(s),Jetted Tub,Furnished - Negotiable,Programmable Thermostat,WaterSense® Labeled Toilet(s)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $16,494
Est. Winter Taxes: $12,447
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T2N, R10E, SEC 6, 7 & 8 OAKLAND COUNTY CONDOMINIUM PLAN NO 1223 TURTLE LAKE UNIT 53 L 20903 P 732 10-17-00 FR 226-005
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 1.12
Lot Dimensions: 156x385x92x402
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved,Private
Map

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

Variable BINGMAPKAY is undefined.

 
The error occurred in C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 284
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 22
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 1
 
282 : <div class="detail_grouping">Map</div>
283 : <cfif isdefined("latitude") and latitude gt 0 and longitude lt 0>
284 : <img src="http://dev.virtualearth.net/REST/v1/Imagery/Map/Road/#gethomes.latitude#,#gethomes.longitude#/14?pp=#gethomes.latitude#,#gethomes.longitude#;20;&mapSize=320,240&key=#BingMapKay#"/>
285 : <cfelse>
286 : <img src="http://dev.virtualearth.net/REST/V1/Imagery/Map/Road/#URLEncodedFormat(streetnumber)#<cfif isdefined("StreetDirection") and StreetDirection IS NOT ""> #URLEncodedFormat(StreetDirection)#</cfif> #URLEncodedFormat(StreetName)#<cfif isdefined("StreetSuffix") and StreetSuffix IS NOT ""> #URLEncodedFormat(StreetSuffix)#</cfif>,#URLEncodedFormat(ZIP)#/?mapSize=320,240&key=#BingMapKay#"/>
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.189.145.83
Referrer  
Date/Time   02-Jul-24 01:06 AM
Stack Trace
at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:284) at cfpop_print_view2ecfm1017774844._factor10(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:22) at cfpop_print_view2ecfm1017774844.runPage(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:1) 

coldfusion.runtime.UndefinedVariableException: Variable BINGMAPKAY is undefined.
	at coldfusion.runtime.CfJspPage._get(CfJspPage.java:221)
	at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:928)
	at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:284)
	at cfpop_print_view2ecfm1017774844._factor10(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:22)
	at cfpop_print_view2ecfm1017774844.runPage(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
	at coldfusion.CfmServlet.service(CfmServlet.java:107)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doRequestNoFilter(FusionReactorCoreFilter.java:712)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:341)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at com.seefusion.Filter.doFilter(Filter.java:49)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)