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;

11274 Oakwood Drive
Jerome, MI 49249

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,900
Beds: 4
Baths: 3
Status: Pending
SqFt: 2912
Agency: C-21 Affiliated - Jackson

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2014
Notes: Its not every day the absolute perfect lake home hits the market! Welcome to 11274 Oakwood Drive, situated in the most desirable subdivision on the highly sought after North Lake LeAnn. Lake LeAnn offers 2 private lake basins, 470 acres of water, all sports, superior fishing, Multiple pull up beach parks for kids, and 9 miles of shoreline for the long pontoon rides! This stunning home has left no stone unturned with the newer build. With the three+Car garage and massive concrete driveway you will have tons of space for parking and lake toys. Walking in you will see solid 3/4 Hickory floors, cathedral ceilings, a massive walkout deck with glass railings, and the best sunset full lake view you could ask for. Speaking of amazing views you will notice a full lake view from your kitchen sink to your master suite! Walking downstairs you immediately feel the openness of the 9 foot ceilings and the comfort of the fully spray foam insulated house. Home was specifically built with 20" floor trusses conveniently hiding all mechanicals and offering the most solid floor you will find. The quality of construction on this lake home simply is'nt matched. Walking out of your basement you will notice a hot tub for your sunset nights, a level yard built up with an outstanding poured retaining wall which allows for large gradual steps to the dock. All lake equipment will be included in sale. This truly will be the most move in ready home that hits the lake this summer, do not miss out! ***Agents please read only remarks for more information on additional items included ***
MlsNumber: 24010820


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