My Office Location:
American Associates

,
 
Listings Presented by:
Carol Haney
Call: 810-691-4125
Fax: 866-789-0779
Office: 810-733-3333
3670 WARWICK 
ROCHESTER HILLS, MI. 48309
$765,000
3 Beds 5 Baths 3,164 Sq Ft
Schools: Avondale School District 0.26 Acres Year Built: 1995
Property Description
Prepare to be captivated by this exquisite home nestled in the prestigious Pine Trace Community, boasting unparalleled curb appeal. Upon entry, a gracious foyer sets a welcoming tone, leading seamlessly to the expansive great room with stunning views of the lush backyard. Adjacent to the foyer, a cozy den with built-in shelving offers an ideal space for a private office or leisurely retreat. The great room and dining area are designed with soaring ceilings and a central fireplace, creating the perfect setting for gatherings. The chef-inspired kitchen features beautiful custom cabinetry, a sleek stainless steel island, double wall ovens, and elegant surfaces. The panoramic views of the resort-like backyard, featuring a built-in swimming pool and a lovely patio area for entertaining guests, are remarkable! The first-floor primary suite provides a luxurious sanctuary, complete with an ensuite primary bath featuring double vanities, a freestanding soaking tub, and an oversized shower. Completing the main level are a mudroom with ample storage and counter space, as well as a separate laundry room. Upstairs, a versatile loft area offers flexibility for a second home office. The second level also includes a bedroom with an ensuite bath, along with an oversized bedroom featuring a separate seating area that can easily be converted into two bedrooms. An additional full bath serves this floor. The fully furnished lower level is an entertainer's dream, featuring a sprawling recreation room with a second kitchen/bar area equipped with all appliances. Enjoy a game room area, a flexible multipurpose room, a full bathroom, and expansive storage space. This level projects a vibrant and inviting atmosphere for everyone. Additional amenities include a reverse osmosis water system serving both kitchens for pristine drinking water and an on-demand water heater and a whole house fan. This impeccably maintained residence is sure to please, where every detail has been meticulously updated
Features
Baths: 4 full, 1 half
Style: Colonial
Subdivision: PINE TRACE VILLAGE OCCPN 732
Exterior: Brick
Exterior Misc: Fenced Yard,Inground Pool,Patio,Porch
Fireplaces: Yes
Fireplace Description: Gas Fireplace,Grt Rm Fireplace
Garage: 3
Garage Description: Attached Garage,Side Loading Garage
Basement: Yes
Basement Description: Finished
Appliances: Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer
Cooling: Ceiling Fan(s),Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: Public Water
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $3,424
Est. Winter Taxes: $2,862
County: Oakland
HOA fees: 200
HOA fees Period: Quarterly
Month Lease:
    
Rooms
Bedroom 1: 14x16
Bedroom 2 : 12x14
Bedroom 3: 16x22
Bedroom 4:
Family Room: 25x32
Greatroom:
Dinning Room: 13x15
Kitchen: 15x22
Kitchen Flooring: Wood
Livingroom:
Lot Details
Acres: 0.26
Lot Dimensions: 80X157X86X125
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   3.144.42.200
Referrer  
Date/Time   03-Jul-24 04:17 AM
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)