My Office Location:
American Associates
18035 Silver Pkwy
Fenton , MI 48430
 
Listings Presented by:
Teri Alexander
Call: (810) 845-3397
Fax: (888) 696-4544
Office: (810) 750-3333
795 MAJESTIC 
ROCHESTER HILLS, MI. 48306
$1,199,999
4 Beds 5 Baths 4,070 Sq Ft
Schools: Rochester 0.39 Acres Year Built: 2001
Property Description
This meticulous home was fully renovated in 2021/22. Located in the highly coveted subdivision of Clear Creek. Golf carts, scooters & bikes have become a way of transportation for Friday night football games at SCHS or visiting neighbors. Walking distance to SCHS and HMS, and a quick drive to downtown Rochester. On a Premium Lot, this is one of VERY few homes in the Sub that back up to protected woodlands, creek and a pond. A large common area next to the lot is sodded and maintained by the HOA - making the expansive yard appear even larger. The lot is very private and includes a cement patio, 2 paver patios, a fire pit and Caldera Hot Tub Spa and professional lush landscaping. New custom double iron entry with screens leads to a 2-story foyer with a grand open staircase. Full renovation includes hardwood and timeless tile floors, and extensive use of crown moldings, granite, quartzite, travertine and stone. Every detail in this incredible colonial is done to perfection, the spectacular millwork will astound you. Upstairs, the spacious master suite is completely renovated with double entry wood doors and a soffit in the 10ft ceilings. It boasts floor to ceiling sheers and motorized black-out shade. The master bath features quartzite countertops, double head walk-in shower, extensive stone, new soak tub and custom cabinets attached to a custom walk-in closet. The Chef's Kitchen includes a floor to ceiling stone archway, large island, granite countertops, 2 added pantry cabinets, built-in gas cooktop, stainless steel appliances, and much more. Formal dining room and living room combine as a beautiful entertainment area with butler pantry that leads to the kitchen. Two story great room has an overlook, fireplace and floor-to ceiling windows. The finished daylight lower level is an open concept and boasts a wet bar, bath, full gym area with industrial rubber matting & ample amounts of storage. 2 new furnaces are zoned for each floor and a tankless hot water heater provides an uninterrupted flow.
Features
Baths: 3 full, 2 half
Style: Colonial
Subdivision: CLEAR CREEK SUB NO 1
Construction: Brick,Stone
Exterior: Brick,Stone
Exterior Misc: Spa/Hot-tub,Lighting
Porchs: Patio
Fireplaces: 1
Fireplace Description: Gas
Garage: 3 Car
Garage Description: Electricity,Door Opener,Attached
Basement: Yes
Basement Description: Finished
Appliances: Dishwasher,Disposal,Double Oven,Exhaust Fan,Free-Standing Refrigerator,Gas Cooktop
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: None
Foundation : Basement
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $4,802
Est. Winter Taxes: $3,930
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T3N, R11E, SEC 1 & 2 CLEAR CREEK SUB NO 1 LOT 39 5-21-99 FR 351-001
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.39
Lot Dimensions: 95x179
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 284
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 22
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 1
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#"/>

Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   13.58.120.57
Referrer  
Date/Time   28-Sep-24 12:54 PM
Stack Trace
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)

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)