My Office Location:
American Associates
2455 E Hill Rd. Ste B
Grand Blanc, MI 48439
 
Listings Presented by:
Maurice Williams
Call: (810) 610-4123
Fax: (888) 696-4544
Office: (810) 600-2180
18170 PARKSHORE 
NORTHVILLE, MI. 48168
$1,300,000
4 Beds 6 Baths 4,001 Sq Ft
Schools: Northville Public Schools 0.42 Acres Year Built: 2000
Property Description
Elegance & luxury abound in 4000 sq ft Moceri built home w/57’ of shoreline on beautiful crystal clear Teal-Stoneridge Lake. Stunning lake views from all levels of East facing lake side of home. Luxurious 2 story 20’ entry foyer w/stone flooring at the base of stylish grand staircase. Solid oak flooring & 9’ ceilings throughout the main level that seem endless. A formal Living Room & sitting parlor w/gas fireplace total 28’. The formal Dining Room sits 12 or more w/ease. The truly great 2 story Great Room is 24’ long w/ beautiful custom built ins & fireplace chase w/ornate custom woodwork & floor to ceiling windows that bathe w/morning sun & offer stunning lake views. The breakfast area & dream Kitchen offer panoramic views of Teal Lake & an 8’ high doorwall opens to a elevated composite protrusion deck affording 180 degree lake views. Main floor Laundry & Mud Room lead to 3+ car garage w/9’ ceiling. The 1,750 sq ft custom finished Lower Level features fully equipped Second Kitchen, Wet Bar, huge Family Room w/hand scrapped hardwood floors, 2 gas fireplaces, Theatre/Media Room w/surround sound, Fitness Center, 2 Bathrooms & 14’x10’ Bonus Room (potential Bedroom). Lower Level walks out to18’x18’ paver patio w/paver walkway direct access to the lakeshore beach & your own boat dock. With a few adjustments the Lower Level can easily be an ultra private & comfortable Multigenerational Living Space. Two staircases lead to the Second Level & overlook bridge above the Great Room. The large Primary Suite windows face Teal Lake w/breathtaking lake views from the Primary Bedroom & sitting area & includes a 14’x15’ walk in closet/dressing room w/custom built ins. Bedrooms 2 & 3 are spacious w/walk in closets & flank a large Jack & Jill Full Bathroom w/2 custom vanity spaces. Spacious Bedroom 4 is bright and sunny & includes a walk in closet & an adjoining Full Bath. New roof, two hi-eff z
Features
Baths: 4 full, 2 half
Style: Colonial
Subdivision: STONEWATER SUB NO 2
Exterior: Brick
Exterior Misc: Exterior Balcony,Deck,Lawn Sprinkler,Patio,Porch,Terrace
Fireplaces: Yes
Fireplace Description: Basement Fireplace,Grt Rm Fireplace,LivRoom Fireplace
Garage: 3
Garage Description: Attached Garage,Electric in Garage,Gar Door Opener,Side Loading Garage,Workshop,Direct Access
Basement: Yes
Basement Description: Finished,Walk Out
Appliances: Disposal,Microwave,Range/Oven,Refrigerator
Cooling: Central A/C
Heating: Forced Air,Zoned Heating
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: Public Water
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $9,392
Est. Winter Taxes: $5,917
County: Wayne
HOA fees: 1750
HOA fees Period: Yearly
Month Lease:
    
Waterfront
Water Name: Teal-Stoneridge Lake
Water Description: Boat Facility,Dock/Pier Facility,Lake Frontage,Lake/River Access,Water View,Waterfront,Beach Access,Beach Front
Feet On Water: 0
Rooms
Bedroom 1: 24x17
Bedroom 2 : 16x12
Bedroom 3: 12x12
Bedroom 4: 16x12
Family Room: 24x23
Greatroom:
Dinning Room: 18x12
Kitchen: 18x18
Kitchen Flooring: Wood
Livingroom: 21x12
Livingroom Flooring: Wood
Lot Details
Acres: 0.42
Lot Dimensions: 93.80 x 233.50
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved Street
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   3.15.29.119
Referrer  
Date/Time   27-Sep-24 03:48 PM
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)