My Office Location:
American Associates
1453 N Elms Rd
Flint, MI 48532
 
Listings Presented by:
Randy Haney
Call: (810) 691-4124
Fax: (888) 696-4544
Office: (888) 733-3333
795 MAJESTIC 
ROCHESTER HILLS, MI. 48306
$1,199,999
4 Beds 5 Baths 4,070 Sq Ft
Schools: Rochester Community School District 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 provi
Features
Baths: 3 full, 2 half
Style: Colonial
Subdivision: CLEAR CREEK SUB NO 1
Exterior: Brick,Stone
Exterior Misc: Patio,Spa/Hot Tub
Fireplaces: Yes
Fireplace Description: FamRoom Fireplace,Gas Fireplace
Garage: 3
Garage Description: Attached Garage,Electric in Garage,Gar Door Opener
Basement: Yes
Basement Description: Finished
Appliances: Dishwasher,Disposal,Refrigerator
Cooling: Ceiling Fan(s),Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: None
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $4,802
Est. Winter Taxes: $3,930
County: Oakland
HOA fees: 525
HOA fees Period: Yearly
Month Lease:
    
Rooms
Bedroom 1: 15x20
Bedroom 2 : 15x12
Bedroom 3: 17x12
Bedroom 4: 16x11
Family Room:
Greatroom:
Dinning Room: 16x15
Kitchen: 11x16
Kitchen Flooring: Ceramic
Livingroom: 15x16
Livingroom Flooring: Wood
Lot Details
Acres: 0.39
Lot Dimensions: 95x179
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved Street
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.44.229
Referrer  
Date/Time   27-Sep-24 03:55 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)