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

16654 29 Mile Road
Albion, MI 49224

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1635
Agency: Visible Homes, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 1992
Notes: This enchanting 20-acre equestrian estate is a dream come true. Find peaceful living in a custom-built, 2-bedroom, 2-bath home brimming with character. The heart of the home, the family room boasts a 14-foot ceiling accented with rustic wood beams and a JØTUL brand wood burner renowned for its Norwegian design and efficiency. The kitchen boasts plentiful counter space, a Viking range & new Samsung high-tech fridge. A convenient pantry offers additional storage for all your cooking needs. Upstairs is a spacious primary bedroom steeped in character and charm. A conveniently located second floor laundry room is just behind the primary bathroom door. Ride in style with a brand new horse barn featuring a spacious 60'x120' indoor arena and stable including 4 stalls and space for storage or stall expansion. Three amazing ponds, two of which have Koi fish, grace the property. The large historic barn adds a touch of nostalgia and offers massive amounts of storage space. Relax and unwind on the screened-in gazebo porch featuring electricity and a ceiling fan. The foliage and grounds are extremely special boasting a stunning variety of mature trees, flowering shrubs, and vibrant perennials that create a breathtaking display throughout the seasons. Fragrant hyacinths and irises mingle with hostas, butterfly bushes, wisteria and hydrangeas. Flowering trees paint the landscape with their blooms, including dogwoods, lilacs, chestnuts, and magnolias. Japanese maples add a touch of fiery brilliance. Winding through the woods are a network of scenic riding and hiking trails. WANT MORE INFO? Click the Virtual Tour link which has much more detailed information, an enhanced photo gallery, a property video and interactive map! Please do not go to the property w/o an appointment.
MlsNumber: 24017465


Listing Provided By: Visible Homes, LLC, original listing
Name: Visible Homes, LLC
Phone: (734) 864-4044
Office Name: Visible Homes, LLC
Office Phone: (734) 864-4044
Agent Name: Nichole McCaig
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