My Office Location:
American Associates
18035 Silver Pkwy.
Fenton, MI 48430
 
Listings Presented by:
Mike Shkreli
Call: (810) 471-2567
Fax: (888) 696-4544
Office: (810) 714-6004
114 BERNSTADT 
NOVI, MI. 48377
$1,350,000
4 Beds 4 Baths 4,088 Sq Ft
Schools: Walled Lake Cons School District 0.33 Acres Year Built: 1961
Property Description
Discover your dream home in Novi, rebuilt 2022 situated on picturesque Walled Lake with deeded lake access and docking privileges. Enjoy all activities that lake life has to offer; boating, tubing, fishing, kayaking and paddle-boarding to your hearts content. This remarkable multi-generational residence offers 4 spacious bedrooms & 4 modern baths, including two luxurious master suites—one on the main floor & one upstairs—ensuring privacy & comfort for all family & guests. The heart of this home is the chef’s kitchen, designed for culinary enthusiasts. It features a massive center island, perfect for meal prep & casual dining, a walk-in pantry, with storage for all your kitchen essentials. The kitchen's open layout seamlessly connects to the living & dining areas, creating an ideal space for entertaining. Experience unparalleled comfort with dual HVAC systems, a water softener & R.O. system. The expansive master suite upstairs is a true retreat, boasting a private balcony where you can enjoy your morning coffee or unwind in the evening while overlooking the serene surroundings. This suite includes a walk-in closet & an extra-large walk-in shower. The versatile four-seasons room, offers a perfect spot to relax & enjoy the natural beauty of every season. The recreation room is an adaptable space that can be transformed into a game room, gym, dance studio, or any other space that suits your needs & lifestyle. The outdoor space is equally impressive, featuring a large fenced yard with a concrete patio perfect for outdoor entertaining, gardening, or simply enjoying the fresh air. The property is fully prepped for a whole-house generator & EV charging, ensuring you are ready for any situation. A massive concrete driveway provides plenty of parking for family & guests, while the heated garage adds a touch of luxury, making cold winter mornings more manageable. Combining modern amenities, thoughtful design, & an unbeatable location. This home is perfect
Features
Baths: 4 full, 0 half
Style: Colonial
Exterior: Stone,Vinyl Siding
Exterior Misc: Exterior Balcony,Fenced Yard,Patio,Porch
Garage: 2
Garage Description: Attached Garage,Electric in Garage,Gar Door Opener,Heated Garage,Workshop
Basement: Yes
Basement Description: Unfinished
Appliances: Dryer,Microwave,Range/Oven,Refrigerator,Washer
Cooling: Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: Private Well
Foundation : Basement,Crawl
Tax, Fees & Legal
Est. Summer Taxes: $6,724
Est. Winter Taxes: $344
County: Oakland
HOA fees:
Month Lease:
    
Waterfront
Water Name: WALLED LAKE
Water Description: All Sports Lake,Dock/Pier Facility,Lake/River Access,Water View,Waterfront,Beach Access,Shared Waterfront
Feet On Water: 0
Rooms
Bedroom 1: 15x18
Bedroom 2 : 11x15
Bedroom 3: 14x16
Bedroom 4: 16x10
Family Room:
Greatroom:
Dinning Room: 12x15
Kitchen: 12x18
Livingroom: 15x24
Lot Details
Acres: 0.33
Lot Dimensions: 80X160
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.144.42.200
Referrer  
Date/Time   30-Jun-24 10:23 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)