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

2950 S Advance Rd
East Jordan, MI 49727

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $374,900
Beds: 5
Baths: 2
Status: Active
SqFt: 2605
Agency: Pat O'Brien & Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential
Year Built: 1913
Notes: Welcome to this inviting family residence, strategically located adjacent to the growing city of East Jordan, ensuring convenience for all your daily needs. Nestled on 9.88-acre, this charming home boasts a picturesque setting with a gentle stream meandering through the landscape. This spacious 5-bedroom, 2-bathroom home is well maintained and ready for you to move right in. The heart of the home is the generously sized kitchen, dining, and living area, thoughtfully designed for family gatherings and entertaining. Here, you'll find a cozy decorative wood stove as the centerpiece, providing both warmth and charm to the space. Nice enclosd porch For those with a penchant for vehicles and hobbies, the property offers the added convenience of an attached 4-car garage, providing ample space for all your storage and parking needs. This property offers the best of both worlds - the tranquility of rural living with the convenience of city amenities just a stone's throw away. The nearby amenities do not fall short. Jordan River Valley: East Jordan is known for its proximity to the Jordan River Valley, a beautiful natural area with opportunities for hiking, biking, and exploring nature. Lake Charlevoix: Lake Charlevoix is nearby and offers opportunities for boating, fishing, swimming, and other water-based activities. Boyne City: Boyne City is a short drive away and offers additional shopping, dining, and recreational opportunities. It's known for its charming downtown area. Boyne Mountain Resort: If you're a fan of skiing, golfing, or other recreational activities, Boyne Mountain Resort is within reach and provides year-round entertainment. Charlevoix: The nearby town of Charlevoix is known for its scenic beauty, including its famous "floating" drawbridge. It offers more dining, shopping, and cultural experiences. Petoskey: A bit further to the northwest, Petoskey is a larger town with even more amenities, including a vibrant downtown area and access to Lake Michigan.
MlsNumber: 472456


Listing Provided By: Pat O'Brien & Associates, original listing
Name: Pat O'Brien & Associates
Phone: (231) 582-1700
Office Name: Pat O'Brien & Associates - Boyne City
Office Phone: (231) 582-1700
Agent Name: Gary Roberts
Disclaimer: Copyright © 2024 Northern Michigan MLS. 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