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

11434 Oakwood Drive
Jerome, MI 49249

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $959,000
Beds: 5
Baths: 5
Status: Active
SqFt: 4321
Agency: C-21 Affiliated - Jackson

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: Are you seeking breathtaking island views from every corner of your home? Look no further than 11434 Oakwood Drive on the private, all-sports Lake LeAnn. This lake offers a serene 'up north in the pines' ambiance, perfect for water sports enthusiasts, top-tier fishing experiences, and tranquil kayaking rides! Grab your favorite boat drink and set sail to the various beach parks, letting the kids have fun while you bask in the sun.<br /> <br /> This home stands out as one of the premier properties on the lake, nestled in the prestigious Royal Shores Subdivision. Upon arrival, you'll be captivated by the stunning brickwork and a full wrap-around Trex deck designed with an overhang to shield your outdoor furniture from the summer elements. Stepping onto the deck, you'll be greeted by a meticulously landscaped yard leading down to a stamped lakeside patioideal for leisurely hangouts.<br /> <br /> Upon entering through the custom front door, you'll be greeted by exquisite natural hardwood floors and a wall of oversized windows offering a panoramic view of the lake. The open-concept layout is perfect for hosting gatherings, allowing seamless transitions from the kitchen to the living room and out to the back deck patio. The spacious design accommodates large family get-togethers effortlessly.<br /> <br /> The master suite is a true sanctuary with expansive windows and a walkout to the deck! Upstairs, a loft area features its own living room and a second master suite. The fully finished basement boasts multiple bedroom options, a complete kitchen, a media/game room, and, best of all, the panoramic view is preserved through the home's extensive windows. Complete with an oversized showerperfect for rinsing off after a day of tubing on the lakethis home is ideal for those seeking a permanent residence or a luxurious second lake home that can comfortably accommodate everyone!<br /> ** AGENTS please see private remarks **
MlsNumber: 24025579


Listing Provided By: C-21 Affiliated - Jackson, original listing
Name: C-21 Affiliated - Jackson
Phone: (517) 888-0050
Office Name: C-21 Affiliated - Jackson
Office Phone: (517) 888-0050
Agent Name: BRETT MILES
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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