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;

10560 Plaza Court
Jerome, MI 49249
IAN STEWART with ERA REARDON REALTY, L.L.C., original listing - (517) 782-2996

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,000,560
Beds: 1
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3664 Square Feet
Agency: ERA REARDON REALTY, L.L.C.
Agency Phone: (517) 782-2996

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Beautiful Custom Log Home on All Sports Lake Le Ann South.<br /> Come enjoy this beautiful lake in the ''Grandest Of Fashion''<br /> <br /> Built in 2001, this magnificent lakefront property has awe inspiring cathedral ceilings throughout, complete open floor plan with beautiful lake views and 177 feet of water frontage.<br /> Located on a 0.66 acre lot on a quiet cul-de-sac, this home welcomes you with a large front porch area boasting well crafted fieldstone pillars and 8'' Swedish pine logs. Entering this warm and inviting home you will experience a very welcoming and spacious foyer area with half bathroom. The incredible open floor plan draws you into a great room that has a total WOW! factor. Custom fieldstone wood burning fireplace and chimney that effortlessly blends into the wooden logs and soaring structure of this home. Andersen windows throughout the home with a sun tint added to the expansive A frame windows in the great room. Great open kitchen area with recess and pendant lighting, custom cabinets, center island, pantry, breakfast bar and built in desk option. Decagon shaped dining room with panoramic views. The main floor also offers a very large primary bedroom with full bathroom and spacious walk-in closet, separate laundry room, mud room and full bath. The well crafted staircase leads you to the 2nd level where you experience a sizable open library / loft area that give you wonderful lake views, a private office area overlooking the main floor primary suite, large 2nd & 3rd bedrooms with double closets and an additional full bathroom. Lower walkout area has an abundance of room for entertaining with a bar area, a Caribbean ocean themed game room, storage room & utility room. Gen/ Tran whole home generator hook up, Geothermal heat system, 2.5 Car garage with additional area above currently used for storage but could be developed into additional living space.<br /> Additional Features Include: Large decks, patio, 6 person hot tub, heated driveway, additional parking area / basketball court, outdoor fire pit, boardwalk dock area within a no wake zone.
MlsNumber: --
ListingId: 24058116


Listing Provided By: ERA REARDON REALTY, L.L.C., original listing
Phone: (517) 414-9979
Office Phone: (517) 782-2996
Agent Name: IAN STEWART
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