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

13435 E Michigan Avenue
Clinton, MI 49236
Nichole McCaig with Visible Homes, LLC, original listing - (734) 864-4044

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1201 Square Feet
Agency: Visible Homes, LLC
Agency Phone: (734) 864-4044

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 122 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 1900
Notes: This beautiful 122-acre property in Washtenaw County has a rich history dating back to the early 1900's. It's a dream come true for horse lovers and entrepreneurs alike! The property features a charming 2 bedroom, 1 bathroom farmhouse and a top-notch 17-stall horse barn. Other barn features include a large office/lounge, a wash rack and a stall with stocks. With ample space for storage and the potential to accommodate three additional stalls, there's room for barn expansion to suit your needs. Benefit from the convenience of training on the property's dedicated half-mile race track. Macon Creek runs through the land, adding to the beauty of the place. There's even a freshly painted detached 2-car garage for your vehicles. The wide-open land gives you the opportunity to build your dream home someday! This property is ideal for anyone with an entrepreneurial spirit. Whether you want to open a vet clinic, start a farm, or run an equestrian business, this land has endless possibilities. With 50 tillable acres, the property offers opportunities for many agricultural pursuits. Additionally, there's potential for selective hardwood harvesting or a solar land lease, providing versatile income options. WANT MORE INFO? Click the Virtual Tour link which has much more detailed information, an enhanced photo gallery, a property video and interactive map! Do not go to the property without an appointment.
MlsNumber: --
ListingId: 24028416


Listing Provided By: Visible Homes, LLC, original listing
Phone: (734) 368-5653
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