Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3330 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3330 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3330 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

14311 Wright Drive
Fenton, MI 48430
Stephen Oaks with RE/MAX Classic, original listing - (248) 737-6800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $774,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3200 Square Feet
Agency: RE/MAX Classic
Agency Phone: (248) 737-6800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2024
Notes: 1st floor Master suite with 2 person tile shower, free standing tub, & dual vanities. This Wooded beautiful setting 4-5 bedroom 3 1/2 baths available for sale. Walk out Basement prepped for a bath. 4 car attached garage. Huge beautiful Porch. Princess/In-law suite upstairs and the other 2 bedrooms have a Jack n Jill bath all tile. Similar plan at 183 Briawood available to walk through but sold almost completed.<br /> Open floor plan Kitchen with wood floors, Island, Pantry with appliance/bar counter & plenty of cabinet & counter space.<br /> Great room with Vaulted ceilings stone fireplace & large windows with amazing wooded views. Conveniently located to Freeway, downtown Fenton & Linden. Many features in this home you wont find in others. Attached to this listing, you will find 3D tours of previous homes built by Stone Hollow. <br /> We have two lots available here in this sub to build. Let us custom design a home that perfectly fits your needs. <br /> Stone Hollow has a wide selection of homes available for viewing and one almost complete in Highland, Novi, Brighton, Milford, White Lake, and Fenton. Additionally, they have ongoing construction projects that you can purchase. <br /> 632 Perthshire Highland Home is Built & in Mechanical phase still time to pick all interior finishes.<br /> 197 Briarwood Basement is in 1 acre lot with no association so you can have fences & pole barn.<br /> 2 more homes started in Fenton with boat dock on Lake Ponemah. 3488 & 3482 Cottage Cove. Use your boat dock this summer while we build your home.<br /> If you prefer, Stone Hollow can also build on your own lot, whether it's your own design or one of the many designs they have available, such as 2863 Pine Bluffs Ct. Cobblestone Sub. Almost ready for interior finishes & available for sale.<br /> Another option is 1039 Troon in Prestwick golf course community. Contact us now to explore the possibilities and find the perfect home or lot for you.
MlsNumber: --
ListingId: 20240043051


Listing Provided By: RE/MAX Classic, original listing
Phone: (248) 755-0897
Office Phone: (248) 737-6800
Agent Name: Stephen Oaks
Disclaimer: Copyright © 2024 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3330 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
John Sedlarik
ASCIIThe Sedlarik Group Realty
Call Today!: (810) 252-6749

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App