Title Page Background
DEBUG FN args: Array ( [0] => 1312 [1] => [2] => [3] => agent ) BEFORE: Site: 1312 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1312 Igate: njhud LocID: 1312 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1312 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1312 [1] => [2] => [3] => lender ) BEFORE: Site: 1312 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1312 Igate: njhud LocID: 1312 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1312 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1312 [1] => [2] => [3] => other ) BEFORE: Site: 1312 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1312 Igate: njhud LocID: 1312 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1312 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

5547 S Byron Road
Durand, MI 48429
Jason Bluer with EXIT Realty Home Partners, original listing - (517) 699-2150
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $699,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4573 Square Feet
Agency: EXIT Realty Home Partners
Agency Phone: (517) 803-2345

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 25 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Equestrian amenities are truly exceptional and tailored to impress. The 232' x 64' Kentucky-style saddle horse training barn includes 24 solid oak stalls, a straight away indoor riding arena/convertible bullpen, an observation room with a bathroom, bunkhouse plus a kitchenette and office -designed with functionality in mind. Perfectly situated just an hour from Metro Detroit, Ann Arbor, and Lansing, this stunning 26- acre estate combines classic character with modern upgrades, making it a rare find for horse enthusiasts and country living lovers alike. An additional 95' x 40' hip-roof barn offers a loft that easily stores up to 3,000 bales of hay, extra foaling stalls, and a lean-to opening to thoughtfully connected paddocks and pastures. The 4-board fencing throughout ensures safety and aesthetic appeal, while the expansive 100' x 200' outdoor arena is ideal for training and shows. For your equipment needs, a 60' x 48' utility barn with cement flooring and 220 power keeps everything secure and organized. Additional storage shed and chicken coup. The remaining unfenced acreage is a hay field. Originally built at the turn of the century, this beautifully updated and expanded home features a spacious first-floor primary suite complete with dual walk-in closets and a walkout deck. The kitchen is outfitted with sleek stainless steel appliances and offers the perfect space for gathering and entertaining in the breakfast nook or formal dining room. The newly remodeled basement features new carpet and paint. Several new mechanicals. This is more than just a farm; it's a lifestyle.
MlsNumber: --
ListingId: 287392


Listing Provided By: EXIT Realty Home Partners, original listing
Phone: (517) 996-2628
Office Phone: (517) 699-2150
Agent Name: Jason Bluer
Disclaimer: Copyright © 2025 Greater Lansing Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => shiawassee [3] => MI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: shiawassee State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: shiawassee State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1312 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Tara Jenkins
Tara Jenkins
ASCIISelleck Agency
Call Today!: (989) 277-7672

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App