My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Sally Newland
Call: (810) 955-4898
Fax: (810) 579-3400
Office: (810) 600-2175
114 BERNSTADT STREET
NOVI, MI. 48377
$1,350,000
4 Beds 4 Baths 4,088 Sq Ft
Schools: Walled Lake 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 for those seeking a versatile & luxurious lake living experience.
Features
Baths: 4 full, 0 half
Style: Colonial
Construction: Stone,Vinyl
Exterior: Stone,Vinyl
Exterior Misc: Awning/Overhang(s),Gutter Guard System,Lighting,Fenced
Porchs: Balcony,Porch - Covered,Patio,Porch,Patio - Covered
Garage: 2 Car
Garage Description: Electricity,Door Opener,Heated,Workshop,Attached
Basement: Yes
Basement Description: Unfinished
Appliances: Water Purifier Owned,Built-In Electric Range,Convection Oven,Dryer,Free-Standing Refrigerator,Microwave,Washer
Cooling: Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Well (Existing)
Foundation : Crawl,Basement
Special Features
Circuit Breakers,Dual-Flush Toilet(s),Other,High Spd Internet Avail,Programmable Thermostat,Water Softener (owned)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $6,724
Est. Winter Taxes: $344
County: Oakland
Month Lease:
Legal Description: T1N, R8E, SEC 3 IDLEMERE PARK LOTS 94 TO 97 INCL EXC S 40 FT MORE PARTICULARLY DESC AS BEG AT NE COR OF SD LOT 94, TH S 03-56-42 E 80 FT, TH S 86-03-18 W 160.36 FT, TH N 03-56-42 W 95.94 FT, TH S 88-15-51 E 161.16 FT TO BEG ------------------------------------------ 12-5-18 FR 22-03-454-013 jl
    
Waterfront
Water Name: WALLED LAKE
Water Description: Across the Road Water Frontage,Beach Access,Lake Privileges,Private Water Frontage,Shared Water Frontage
Feet On Water: 0
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.33
Lot Dimensions: 80X160
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 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.12.136.3
Referrer  
Date/Time   13-Jul-24 02:09 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)