My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Janice Stuckey
Call: (810) 577-8496
Fax: (810) 579-3400
Office: (810) 750-3333
3751 ORMOND ROAD
CLARKSTON, MI. 48383
$1,300,000
4 Beds 6 Baths 3,621 Sq Ft
Schools: Huron Valley Year Built: 2002
Property Description
Spectacular sunset views from this all-sports lakefront. ONE OF A KIND ON THIS POPULAR LAKE. Be in by summer to enjoy July 4th festivities and breathtaking views. This home features 4 bedrooms, 4 bath, 2 1/2 baths, high-ceiling open kitchen/living area dual fireplace with a wall of windows overlooking the lake. An entertainer's dream feature butler's pantry, formal dining and living rooms. Neutral decor throughout offering crown moldings, wainscoting, substantial recessed lighting, spacious rooms throughout. Professionally landscaped incl lighting, 3 tiered trex decking w/glass panes, sea wall, substantial brick pavers and tiki bar. Full finished walkout with extensive over the top custom bar incl 2 bar frigs, dishwasher & ice maker, also incl private gym and full bath. Basement wine closet, cedar closet & extensive built-in storage shelves. Master suite w/ custom walk-in closets, sitting area w/fireplace & fantastic lake views. See additional feature sheet for more details.
Features
Baths: 4 full, 2 half
Style: Traditional
Subdivision: PLEASANT VIEW SUB -WHITE LAKE TWP
Construction: Brick,Wood
Exterior: Brick,Wood
Porchs: Deck,Porch
Fireplaces: 1
Fireplace Description: Gas
Garage: 2 Car
Garage Description: Direct Access,Electricity,Door Opener,Attached
Basement: Yes
Basement Description: Finished
Appliances: Built-In Refrigerator,Convection Oven,Dishwasher,Disposal,Dryer,Gas Cooktop,Microwave,Other,Plumbed For Ice Maker,Stainless Steel Appliance(s),Warming Drawer,Washer,Wine Refrigerator,Bar Fridge
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Septic Tank (Existing)
Watersource: Well (Existing)
Foundation : Basement
Special Features
Humidifier,Water Softener (owned),Central Vacuum,High Spd Internet Avail,Jetted Tub,Sound System,Wet Bar,Carbon Monoxide Alarm(s),Security Alarm (owned),Cable Available
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $6,474
Est. Winter Taxes: $3,522
County: Oakland
Month Lease:
Legal Description: T3N, R8E, SEC 7 PLEASANT VIEW SUB LOTS 10 & 11, ALSO THAT PART OF VAC ADAMS AVE ADJ TO SAME, ALSO OF 'SUPERVISOR'S PLAT NO 2' MOST NLY PART OF LOT 16 MEAS 36.5 FT ALG E LOT LINE & 35.5 FT ALG W LOT LINE 9-29-89 FR 016, 017 & 025
    
Waterfront
Water Name: White Lake
Water Description: Lake Front
Feet On Water: 0
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0
Lot Dimensions: 80x93x80x118
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.220.96.214
Referrer  
Date/Time   23-Sep-24 09:14 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)