American Associates - 5054 TRAILWOOD, WARREN, MI. 48092

My Office Location:

American Associates

Listings Presented by:

Angela Odden

Call: (248) 807-0181
Fax: (888) 696-4544
Office: (810) 244-7040

5054 TRAILWOOD

WARREN, MI. 48092

$489,900

5 Beds 3 Baths 2,900 Sq Ft
Schools: Warren Consolidated Schools Year Built: 2015

Property Description

**UPDATED** HIGHEST AND BEST DUE BY TUESDAY, APRIL 30TH, 2024! Take a step into and discover luxury in every detail of this breathtaking colonial home, located in the prestigious Heritage Village. Enjoy 2900 sq. ft of space and a 1900 sq. ft. basement with a beautiful 2nd kitchen and pantry. Let's not forget the daylight windows in the basement too plus insulation. The CUSTOM walk out from basement to garage will surely raise an eyebrow! With 5 bedrooms, 3 full baths, and premium upgrades throughout, including high ceilings, maple cabinets, granite counters, and slate/stainless steel appliances, indulgence awaits. Entertain in style with an extra-large great room featuring a cozy fireplace and a curved balcony to overlook it too!. Retreat to the master suite oasis with an ultra-high octogan pan ceiling and custom walk-in closet and 4 other spacious bedrooms. Additional features include Anderson windows, energy efficient furnace, programmable sprinkler system, loft, mudroom, and open floor plan. This property is more than a home; it's a haven of elegance and comfort. Schedule a showing today and experience luxury living in the HEART of Warren. Schedule your showing today!

Features

Baths: 3 full, 0 half
Style: Colonial
Subdivision: THE RESERVE AT HERITAGE VILLAGE CONDO #943
Exterior: Brick
Garage: 2
Garage Description: Attached Garage,Electric in Garage,Gar Door Opener
Basement: Yes
Basement Description: Outside Entrance,Partially Finished
Appliances: Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: Public Water,Public Water at Street
Foundation : Basement

Tax, Fees & Legal

Est. Summer Taxes: $8,359
Est. Winter Taxes: $234
County: Macomb
HOA fees: 75
HOA fees Period: Monthly
Month Lease:

Rooms

Bedroom 1: 15x20
Bedroom 2 : 12x15
Bedroom 3: 11x12
Bedroom 4: 8x10
Family Room:
Greatroom:
Dinning Room:
Kitchen: 14x22
Kitchen Flooring: Ceramic
Livingroom:

Lot Details

Barns:
Stalls:
Pole Buildings:

Map

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#"/>

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)