My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Geri Schnekenburger
Call: (810) 845-7861
Fax: (888) 696-4544
Office: (810) 750-3333
2817 LONG MEADOW 
ROCHESTER HILLS, MI. 48307
$519,000
4 Beds 3 Baths 2,714 Sq Ft
Schools: Avondale School District 0.28 Acres Year Built: 2001
Property Description
DON’T MAKE A MOVE WITHOUT stopping by this STUNNING two-story colonial nestled in a great neighborhood offering an array of desirable features. Upon entering, notice the grand vaulted entry foyer that sets the tone for the spaciousness throughout the open areas. This home offers a chef’s kitchen with built-in stainless-steel appliances, granite countertops, barstool peninsula for extra seating, wood floor, recessed lighting. Sunny breakfast nook with door wall gives access to the deck to enjoy outdoor living. Adjacent to the kitchen is the family room with large picture window and cozy fireplace with mantle. Hardwood throughout. The first floor offers a ½ bath and laundry room as well. Laundry is right off the 2-car attached garage for convenience. Upstairs offers, 3 great bedrooms all with wood floors, ceiling fans and step-in closets. Large ceramic bath is shared with the 3 bedrooms and has a large vanity with double sinks and a shower/tub combo. Plenty of storage. The huge primary suite awaits and doesn’t disappoint. Offering a tranquil retreat with vaulted ceilings, ceiling fan, both a step in closet and huge walk in with organizers, recessed light rolled edge vintage look deep soaking bathtub. Large double vanities and separate shower. Full unfinished basement. This home boasts numerous updates with new 2023 roof, exterior paint, deck, modern lighting, appliances, A/C and furnace 2020. Enjoy the semi-private tree lined lot with a GREAT cozy brick patio and firepit tucked in the trees. Located on a prime lot, quiet Cul-de-sac street with sidewalks. Minutes from great parks, Oakland University, M-59, restaurants, and shopping.
Features
Baths: 2 full, 1 half
Style: Colonial
Subdivision: CUMBERLAND WOODS SUB NO 2
Exterior: Brick,Wood
Exterior Misc: Deck,Patio
Fireplaces: Yes
Fireplace Description: FamRoom Fireplace,Gas Fireplace
Garage: 2
Garage Description: Attached Garage,Electric in Garage,Gar Door Opener
Basement: Yes
Basement Description: Unfinished
Appliances: Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer
Cooling: Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: Public Water
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $3,069
Est. Winter Taxes: $2,567
County: Oakland
HOA fees: 175
HOA fees Period: Yearly
Month Lease:
    
Rooms
Bedroom 1: 18x15
Bedroom 2 : 13x12
Bedroom 3: 11x12
Bedroom 4: 10x12
Family Room:
Greatroom:
Dinning Room: 11x12
Kitchen: 15x12
Kitchen Flooring: Wood
Livingroom:
Lot Details
Acres: 0.28
Lot Dimensions: 75 x 160
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.136.234.229
Referrer  
Date/Time   24-Jun-24 08:42 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)