My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Christine Johnson
Call: (248) 702-5352
Fax: (888) 696-4544
Office: (810) 750-3333
3133 EMERAUDE TRAIL
OAKLAND, MI. 48306
$1,575,000
4 Beds 6 Baths 5,200 Sq Ft
Schools: Rochester 0.48 Acres Year Built: 2014
Property Description
Impeccably-maintained 2014 Moceri-built colonial nestled on 1/2-acre cul-de-sac lot in the desirable Kingsridge community. Better than new construction: This home offers immediate occupancy for buyers, comes fully landscaped, includes all appliances, and features a professionally-finished lower level and outdoor lanai. Recent updates include exterior & interior painting and new carpet throughout. Additional premium features include hand-scraped hardwood flooring, extensive trim package with crown & applied wall molding as well as custom-stained paneling, gourmet kitchen with built-in appliances, 2-way gas fireplaces in great room/library and primary suite as well as additional outdoor lanai gas fireplace, and more! Oversized primary suite includes sitting room, 5-piece bathroom, and generous walk-in-closet with custom organizer system. Bonus Room on 2nd floor could become 5th bedroom. Dual laundry facilities for convenience (located on 1st and 2nd floors). Finished lower level is an entertainer's dream with large wet bar, theater system, billiards room, additional family room, full bath, and flex room (perfect for exercise space or crafts). Garage includes additional workshop space with organizers & floor tile system, as well as expanded driveway for ample parking. Sale includes all appliances as shown (kitchen, laundry, bar), TVs currently shown in lower level, reverse osmosis & water softener systems, basement bar stools & theater chairs. Pool table negotiable/included with acceptable offer to sellers. Sale excludes the neon signs throughout the lower level. Washer/Dryer in 2nd floor laundry to be swapped with alternative set.
Features
Baths: 4 full, 2 half
Style: Colonial
Subdivision: KINGSRIDGE NO 2
Construction: Brick,Stone,Wood
Exterior: Brick,Stone,Wood
Exterior Misc: Lighting
Porchs: Porch - Covered,Porch
Fireplaces: 1
Fireplace Description: Gas
Garage: 3 Car
Garage Description: Side Entrance,Electricity,Attached
Basement: Yes
Basement Description: Finished
Appliances: Water Purifier Owned,Built-In Electric Oven,Dishwasher,Disposal,Dryer,Free-Standing Refrigerator,Gas Cooktop,Microwave,Range Hood,Stainless Steel Appliance(s),Washer,Bar Fridge
Cooling: Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Humidifier,Water Softener (owned),Circuit Breakers,Furnished - No,Other,High Spd Internet Avail,Programmable Thermostat,Wet Bar,Carbon Monoxide Alarm(s),Security Alarm (owned),Cable Available,Egress Window(s),ENERGY STAR® Qualified Window(s)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $9,042
Est. Winter Taxes: $4,371
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T4N, R11E, SEC 31 KINGSRIDGE NO 2 LOT 58 4-27-12 FR 400-015
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.48
Lot Dimensions: 75 x 207 x 190 x 164
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   3.141.35.185
Referrer  
Date/Time   27-Sep-24 02:48 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)