My Office Location:
American Associates

,
 
Listings Presented by:
Angela Odden
Call: (248) 807-0181
Fax: (888) 696-4544
Office: (810) 244-7040
38254 CHARWOOD 
STERLING HEIGHTS, MI. 48312
$339,900
1,628 Sq Ft
Schools: Utica 0.25 Acres Year Built: 1967
Property Description
Discover the perfect blend of comfort, elegance, and convenience at 38254 Charwood Drive, a stunning all-brick single-family ranch in the heart of Sterling Heights, MI. This beautifully maintained home features 3 spacious bedrooms, 2 remodeled bathrooms, and 1,628 square feet of refined living space, with over 1,000 additional square feet of finished basement space. Step inside to be greeted by desirable details such as wainscoting throughout, refinished hardwood floors, and new doors. The open kitchen is a chef's delight, offering oak cabinets, granite countertops, barstool seating, and seamless integration with the dining area and family room. The family room is a cozy retreat with a gas fireplace featuring a stone hearth and surround, and a sliding glass door that opens to the backyard oasis. Both bathrooms have been tastefully remodeled with new tile and Euro glass doors, adding a touch of modern luxury. The exterior of this home is equally impressive, starting with a sizeable front porch and meticulously maintained landscaping. The backyard is a private paradise, featuring a concrete patio with a raised sunbathing terrace, an inground heated saltwater pool complete with a slide and diving board, an inground jacuzzi, and a putting green. There is ample space for patio furniture and a BBQ area, making it an ideal spot for entertaining and enjoying the outdoors. This home is perfectly situated near schools like the sought-after Messmore Elementary school, shopping centers, restaurants, and grocery stores, providing ultimate convenience. It is also minutes from M-53 and M-59, yet nestled in a quiet, family-friendly neighborhood. Nearby parks and entertainment options include Clinton River Park North, Dodge Park, Rammler Golf Club, and Plum Brook Golf Club, catering to a variety of recreational interests. Additional features of this home include a central vacuum system, updated electrical, and two sump pumps with a B-Dry system, ensuring comfort and peace of mind. T
Features
Baths: 2 full
Style: Ranch
Subdivision: Schmidt & Record
Construction: Brick
Exterior: Brick
Exterior Misc: Spa/Hot-tub,Fenced,Pool - Inground
Porchs: Patio,Porch
Fireplaces: 1
Fireplace Description: Gas
Garage: 2 Car
Garage Description: Attached
Basement: Yes
Basement Description: Finished
Appliances: Dishwasher,Dryer,Microwave,Oven,Range/Stove,Refrigerator,Washer
Cooling: Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
High Spd Internet Avail
Tax, Fees & Legal
Land Contract: No
Est. Summer Taxes: $2,692
Est. Winter Taxes: $261
County: Macomb
HOA fees: 1
Month Lease:
Legal Description: SCHMIDT & RECORD SUB.
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.25
Lot Dimensions: 81 x 134
Barns:
Stalls:
Pole Buildings:
Paved Road: Private,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.222.121.74
Referrer  
Date/Time   08-Jul-24 10:16 AM
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)