My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Geri Schnekenburger
Call: (810) 845-7861
Fax: (888) 696-4544
Office: (810) 750-3333
2817 VINEYARDS DRIVE
TROY, MI. 48098
$1,250,000
4 Beds 6 Baths 4,910 Sq Ft
Schools: Bloomfield Hills 0.55 Acres Year Built: 2000
Property Description
This magnificent, custom built, Joseph Phillip Craig, 1-1/2 story home, with its 5 bedrooms, 4.2 baths, and finished walkout lower level, is being offered on the market for the first time. Boasting approximately 7,500 square feet of finished space, this gently lived in home delivers quality craftsmanship along with its many fine appointments and a beautifully landscaped yard. Nestled in Bailey’s Vineyard, a highly desirable neighborhood that is just minutes away from freeways, shopping and dining. The home’s entry level features a grand two-story foyer with curved floating staircase, generous use of wall and crown moldings, and an open staircase to the finished walk-out lower level, welcome visitors to the home. Additionally, there is a study with French doors, natural fireplace with marble surround and a custom wood mantle. The great room features 3 large elliptical top windows, plantation shutters, a natural masonry fireplace with marble surround with beautiful wood mantle. The large kitchen boasts a large kitchen sink window allowing in generous amounts of natural light, built-in appliances, Brazilian cherry flooring, Wood-Mode cabinets, granite countertops, and a vast island with prep sink and snack bar seating. The spacious owner's suite features a tray ceiling, three walk-in closets with California style organizers and shelving, and a large bathroom with jetted tub, separate oversized stall shower, his and hers vanities, and a make-up vanity. The upper floor offers a bedroom suite with full bathroom, and two bedrooms that share a dual entry full bath. The finished lower level features an updated full kitchen with quartz countertops and backsplash, wrap around snack bar seating, gas range, microwave, and there are multiple gathering areas, a natural fireplace, a bedroom, a full bath, and a large storage area. There is tons of storage, a whole house standby generator (2017), and all three HVAC systems are newer (2015). The care for this home has been meticulous, and it is in immaculate condition.
Features
Baths: 4 full, 2 half
Style: Colonial
Subdivision: BAILEYS VINEYARDS SUB
Construction: Brick
Exterior: Brick
Exterior Misc: Whole House Generator,Awning/Overhang(s),BBQ Grill,Lighting
Porchs: Porch - Covered,Patio,Porch,Terrace
Fireplaces: 1
Fireplace Description: Gas,Natural
Garage: 3 Car
Garage Description: Side Entrance,Direct Access,Electricity,Door Opener,Attached
Basement: Yes
Basement Description: Finished,Interior Entry (Interior Access),Walkout Access
Appliances: Vented Exhaust Fan,Built-In Refrigerator,Dishwasher,Disposal,Double Oven,Electric Cooktop,Microwave
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air,High Efficiency Sealed Combustion,Zoned
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Humidifier,100 Amp Service,220 Volts,Circuit Breakers,Utility Smart Meter,Furnished - No,Central Vacuum,Other,High Spd Internet Avail,Jetted Tub,Programmable Thermostat,Wet Bar,Security Alarm (owned),Cable Available,Egress Window(s)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $13,173
Est. Winter Taxes: $2,835
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T2N, R11E, SEC 7 BAILEYS VINEYARDS SUB LOT 13 1-11-95 FR 306-001
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.55
Lot Dimensions: 118x157x184x159
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved,Pub. Sidewalk
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   3.144.48.204
Referrer  
Date/Time   28-Sep-24 06:10 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)