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 = 1244 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1244 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1244 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

1693 Elm Road
Frankfort, MI 49635
Tyler Jeleniewski with Preferred, Realtors® Ltd, original listing - (734) 459-6000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,349,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 1986 Square Feet
Agency: Preferred, Realtors® Ltd
Agency Phone: (734) 459-6000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 26 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Introducing an extraordinary opportunity to own a stunning property in Frankfort Michigan! Nestled on one of the highest elevations overlooking a serene valley with breathtaking views of Lake Michigan and the charming city of Frankfort. Four separate parcels being sold together as one. The 2.75 acre parcel at 1693 Elm offers 3,122 square feet of elegant living space surrounded by an additional 23.25 acres(approx.) of beautifully maintained wooded land.<br /> This remarkable residence features 3 generously-sized bedrooms and 3.5 bathrooms, thoughtfully designed to ensure both comfort and privacy. The outdoor features are truly exceptional, with a spacious 40x45 pole barn providing ample storage for all your recreational equipment and outdoor gear. The expansive wrap-around deck is perfect for soaking in the stunning vistas, whether you're relaxing with a book or hosting vibrant gatherings.<br /> Enhancing the property’s functionality is a large walkout basement complete with a mini-kitchen, ideal for entertaining guests or for family get-togethers. Additionally, a 1,200 sq. foot(approx.) rental unit located on the property secluded from the main house opens up possibilities for extra income or versatile living arrangements.<br /> Biking distance to nearby beaches such as Frankfort Beach & Point Betsie. A short drive to Crystal Lake and Crystal Mountain provides endless options for recreation and relaxation. Adventurous outdoor pursuits await, from kayaking along the serene Betsie River to witnessing the spectacular fall salmon runs in the Betsie and Platte Rivers. Don’t miss the scenic drive along M-22, showcasing the region's vibrant fall foliage, and take advantage of the proximity to the Sleeping Bear Dunes for even more exploration. Frankfort offers a variety of dining and shopping options just a short drive away - this property seamlessly blends tranquility with accessibility. Schedule your private tour today and discover the unique lifestyle that 1693 Elm has to offer!
MlsNumber: --
ListingId: 20250023281


Listing Provided By: Preferred, Realtors® Ltd, original listing
Phone: (734) 459-6000
Office Phone: (734) 459-6000
Agent Name: Tyler Jeleniewski
Disclaimer: Copyright © 2025 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