My Office Location:
American Associates
2455 E Hill Rd.
Grand Blanc, MI 48439
 
Listings Presented by:
Jack Walker III
Call: (810) 240-4800
Fax: (888) 696-4544
Office: (810) 600-2181
29223 TRAILWOOD DRIVE
WARREN, MI. 48092
$384,990
4 Beds 3 Baths 2,238 Sq Ft
Schools: Warren Con 0.17 Acres Year Built: 2022
Property Description
NEW Home! Under Construction. Est. Delivery: September' 22. The Remington by Winnick Homes. HBA Builder of the Year & award-winning design. Timeless Transitional style & superior craftsmanship. Neutral décor by Interior Designer. Classic Island KT: Aristokraft Shaker-style cabinets w/42" Uppers in rich Espresso stain, Granite tops, higher-end stainless steel GE appliances & large Pantry. Luxurious Owner's Suite w/Spa-like bath. Loft space & Flex Room, Mud Hall to Laundry Centre. 9' ceilings - 1st floor. Extensive HW, ceramic & finish trim. Satin Nickel fixtures & hardware. Energy efficient features: 90%+ furnace, Silver Line Low E windows, Nelson Energy Seal & dimensional shingle. Insulated bsmt w/egress window. 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: Dishwasher,Disposal,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 # 21
    
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   18.225.98.186
Referrer  
Date/Time   03-Jul-24 01:26 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)