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 = 3462 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 = 3462 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 = 3462 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;

31145 Woodside Drive
Franklin, MI 48025

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,995,000
Beds: 3
Baths: 5
Status: Pending
SqFt: 5118
Agency: The Agency Hall & Hunter

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2015
Notes: Exquisite residence custom built by TSA and designed (interiors by Corey Damen Jenkins) to maximize the stunning setting, this home was meticulously handcrafted with extraordinary attention to detail. Upon entry, you are greeted by an elegant foyer with 20 ft ceilings & richly accented formal living room. Blending modern luxury with timeless architecture, this home features extensive millwork & wainscoting, designer wallpapers, herringbone wood floors & vaulted ceilings. The light filled main level provides effortless flow between the palatial dining and family room. A tastefully appointed gourmet kitchen leads out to a covered loggia complete with fireplace overlooking the private grounds and salt water pool. Eat-in kitchen is complete with large island with leathered granite countertops, Perspectives cabinetry, Ann Sacks backsplash, walk-in pantry, butler’s pantry & top of the line appliances. Cozy study with adjoining wet bar & barrel ceiling, gardening room, laundry & spacious mud room complete main level. First floor primary suite boasts a spacious walk in closet, sitting area, luxurious bath with steam shower, heated floors, soaking tub, dual sinks, & water closet. Second ensuite bedroom with walk-in closet. 2nd floor loft space can be converted to 3rd bedroom. A walk out lower level is mainly unfinished, offering plenty of storage and room to design whatever fits your needs. Also includes 2nd laundry, changing room & half bath. Attractive salt water pool complete with exposed aggregate and limestone patio, professionally landscaped grounds, outdoor kitchen with built in bbq and wood burning pizza oven. Attached heated 3 car garage, full house generator, central vac & Control4 system. A secluded and private property offering the best of luxury living.
MlsNumber: 20240009278


Listing Provided By: The Agency Hall & Hunter, original listing
Name: The Agency Hall & Hunter
Phone: (248) 229-6100
Office Name: The Agency Hall & Hunter
Office Phone: (248) 229-6100
Agent Name: Cindy Obron Kahn
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App