My Office Location:
American Associates

,
 
Listings Presented by:
Scott Haney
Call: (810) 875-6022
Fax: (888) 696-4544
29201 TRAILWOOD DRIVE
WARREN, MI. 48092
$379,990
4 Beds 3 Baths 2,400 Sq Ft
Schools: Warren Con 0.17 Acres Year Built: 2022
Property Description
NEW Home - Under Construction! Est. Delivery: September '22. The Winchester by Winnick Homes. HBA Builder of the Year & award-winning design. Transitional style w/superior craftsmanship. Neutral décor by Interior Designer. Classic White KT w/huge Island. Aristokraft Shaker-style cabinets w/42" uppers, Quartz tops, higher-end stainless GE appliances & Walk-in Pantry. Luxurious Owner's Suite w/Spa-like Bath. Flex Rm, Mud Hall & convenient 2nd floor Laundry Centre. 9' ceilings - 1st floor. Extensive HW, ceramic & finish trim. Oil-Rubbed Bronze fixtures & hardware. Energy efficient features: 90% furnace, Silver Line Low E windows, Nelson Energy Seal & dimensional shingle. Insulated bsmt w/egress window. Garage storage. Great neighborhood w/central location. Offers commerce, recreation & easy commuting. Minutes to I-696, I-75 & M-53. Manufacturer's Warranties. Representative int/ext photos. HOA services apply to common area. Fixed Selections due to ongoing supply chain & skilled labor shortage.
Features
Baths: 2 full, 1 half
Style: Colonial,Traditional
Subdivision: THE RESERVE AT HERITAGE VILLAGE CONDO #943
Construction: Brick,Other,Vinyl
Exterior: Brick,Other,Vinyl
Exterior Misc: Lighting
Porchs: Porch - Covered,Porch
Fireplaces: 1
Fireplace Description: Gas
Garage: 2 Car
Garage Description: Direct Access,Electricity,Attached
Basement: Yes
Basement Description: Interior Entry (Interior Access),Unfinished
Appliances: Disposal,ENERGY STAR® qualified dishwasher,Free-Standing Gas Oven,Free-Standing Gas Range,Microwave,Plumbed For Ice Maker,Stainless Steel Appliance(s)
Cooling: Central Air,ENERGY STAR® Qualified A/C Equipment
Heating: ENERGY STAR® Qualified Furnace Equipment,Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
High Spd Internet Avail,Programmable Thermostat,Cable Available,Egress Window(s)
Tax, Fees & Legal
Home warranty: Yes
Land Contract: No
Est. Summer Taxes: $372
Est. Winter Taxes: $9
County: Macomb
HOA fees: 1
HOA fees Period: Monthly
Month Lease:
Legal Description: THE RESERVE AT HERITAGE VILLAGE; M.C.C.P. NO. 943; UNIT # 20
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.17
Lot Dimensions: 60 x 121
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved,Private,Pub. Sidewalk
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.133.108.0
Referrer  
Date/Time   04-Oct-24 09:11 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)