My Office Location:
American Associates
18035 Silver Pkwy
Fenton , MI 48430
 
Listings Presented by:
Teri Alexander
Call: (810) 845-3397
Fax: (888) 696-4544
Office: (810) 750-3333
1723 MYSTIC HILLS DRIVE
MILFORD, MI. 48380
$1,000,000
4 Beds 5 Baths 4,418 Sq Ft
Schools: Huron Valley 3.26 Acres Year Built: 1998
Property Description
Welcome home to your stunning colonial in the luxury community of Mystic Hills. From the moment you walk in you will find gorgeous custom details throughout: radiant in-floor heating on all three levels, custom woodwork and hardwood floors. Two story great room features a dual sided fireplace and large windows overlooking the backyard. Gourmet kitchen with granite countertops, custom cabinets, professional stainless steel appliances with 3 ovens and 6 burner gas cooktop. Hearth room, breakfast nook, formal living and dinning rooms, large office, 2 powder rooms and laundry all on the entry level. On the second floor find the master suite featuring a tray ceiling, large walk-in closet, private en-suite bath with dual vanities, shower, and jetted tub. Three additional bedrooms 1 with a private bath and two that share a jack and jill bath. Enjoy entertaining on your 3.26 acre retreat with 2 fire pits, brick paver patio, and garden.
Features
Baths: 3 full, 2 half
Style: Colonial
Subdivision: MYSTIC HILLS ESTATES
Construction: Brick
Exterior: Brick
Exterior Misc: Whole House Generator,BBQ Grill,Lighting
Porchs: Porch - Covered,Patio,Porch
Fireplaces: 1
Fireplace Description: Gas
Garage: 5 Car
Garage Description: Direct Access,Electricity,Door Opener,Side Entrance,Attached
Basement: Yes
Basement Description: Walkout Access
Appliances: Built-In Gas Range,Built-In Refrigerator,Convection Oven,Dishwasher,Disposal,Dryer,Microwave,Range Hood,Stainless Steel Appliance(s),Washer,Bar Fridge
Cooling: Central Air
Heating: Radiant,Zoned
Fuel: Natural Gas
Waste: Septic Tank (Existing)
Watersource: Well (Existing)
Foundation : Basement
Special Features
Humidifier,Water Softener (owned),Central Vacuum,High Spd Internet Avail,Jetted Tub,Programmable Thermostat,Sound System,Wet Bar,Air Purifier,Security Alarm (owned),Cable Available
Tax, Fees & Legal
Home warranty: Yes
Land Contract: No
Est. Summer Taxes: $5,399
Est. Winter Taxes: $2,253
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T2N, R7E, SEC 20 MYSTIC HILLS ESTATES LOT 5 5-24-88 FR 126-004
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 3.26
Lot Dimensions: 200x696x250x598
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved
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 286
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 22
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 1
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#"/>
287 : </cfif>
288 : 	

Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.227.183.153
Referrer  
Date/Time   23-Sep-24 09:36 PM
Stack Trace
at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:286) 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:286)
	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)