My Office Location:
American Associates

,
 
Listings Presented by:
Randy Haney
Call: (810) 691-4124
Fax: (888) 696-4544
Office: (810) 733-3435
54218 TRIESTE COURT
SHELBY TWP, MI. 48316
$899,000
5 Beds 7 Baths 5,000 Sq Ft
Schools: Utica 0.41 Acres Year Built: 2007
Property Description
STUNNING & IMMACULATE CUSTOM COLONIAL!! Prestigious Carrington Manor Home w/5 Bdrms, 5 Full & 2 Half Baths. EXTENSIVE upgrades include Paver Courtyard Driveway w/3 car Side-Turned Garage. Gorgeous entry w/Hardwood floors, Designated Executive Office w/Solid Wood Shelving. Warm & Welcoming Great Room w/Gas Fireplace & Impressive Custom Mantle, Built-In Wood Shelving & Exquisite Coffered Ceiling. Gourmet Kitchen w/Custom LaFata Cabinets, Huge Island, SS Appliances, Alluring Trim & Crown Molding. Formal Dining w/Panned Ceiling & Wainscoting. Extensive Engineered Deck w/Iron Railings & Spiral Staircase to Lower Patio. Mud Room upon Entry from Garage. Distinguished Wood Staircases w/Iron Railings to Upper & Lower Levels. Upper Level w/Breathtaking Oversized Luxurious Master Suite w/Incredible Master Bath & Closet. 2 Generous Sized Bedrooms w/Ensuites & Huge Bonus Room w/Full Bath. Finished Walkout w/Bedroom, Full Bathroom, Storage Space, Patio Overlooking Professionally Landscaped Yard.
Features
Baths: 5 full, 2 half
Style: Colonial
Subdivision: CARRINGTON MANOR # 04
Construction: Asphalt,Brick,Stone,Wood
Exterior: Asphalt,Brick,Stone,Wood
Exterior Misc: Lighting
Porchs: Porch - Covered,Deck,Patio,Porch
Fireplaces: 1
Fireplace Description: Gas
Garage: 3 Car
Garage Description: 2+ Assigned Spaces,Direct Access,Electricity,Door Opener,Attached
Basement: Yes
Basement Description: Partially Finished,Walkout Access
Appliances: Water Purifier Owned,Built-In Refrigerator,Dishwasher,Disposal,Dryer,Gas Cooktop,Microwave,Range Hood,Stainless Steel Appliance(s),Washer,Washer/Dryer Stacked
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Humidifier,Water Softener (owned),High Spd Internet Avail,Jetted Tub,Programmable Thermostat,Cable Available
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $5,098
Est. Winter Taxes: $3,531
County: Macomb
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: CARRINGTON MANOR #4 LOT 89 LIBER 128 / PAGES 19-22
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.41
Lot Dimensions: 115x181x70x241
Barns:
Stalls:
Pole Buildings:
Paved Road: 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.119.159.178
Referrer  
Date/Time   28-Sep-24 01:01 PM
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)