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

1344 S Hadley Road
Ortonville, MI 48462
Carole Porretta with Coventry Realty LLC, original listing - (810) 678-2288

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $900,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3000 Square Feet
Agency: Coventry Realty LLC
Agency Phone: (810) 678-2288

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Property Type: Residential-Farm
Year Built: 1910
Notes: Amazing location, price and unique opportunity for a family, equestrian or investor! 1900's farmhouse has been renovated over the years and grown in size from probably 1000 to over 3500 sq ft! Offers two kitchens, lots of lower level living space and the garage converted into a huge family room with large primary bedroom up one of two staircases. Four bedrooms and two baths - needs updating, decorating and love but a wonderful home on a great piece of land! Tall Michigan basement has the original stone walls, updated electric and new water heater. The previous homeowner, a talented writer/builder/artist, created several outdoor living spaces with coin logs and bottle glass windows and loved it for over 45 years. Included on this 25 acres are 11 pastures, two barns and a 120/60 indoor arena (possibly 144x60 with fencing down) currently homing an equine veterinary clinic. These owners temporarily lived upstairs utilizing the huge observation room below as the clinic with a kitchen, full bath, flex room, storage, and office space all viewing the arena with an observation room. A 4' tall crawl/storage space under the clinic houses a new furnace. Attached to the arena and divided into 3 sections are four 10x12 stalls, laundry facilities, storage and new hot water heater, heated wash rack, treatment area with utility room, ceiling heat, padded surgery stall and two 10x12 isolation stalls with in/out and direct access to the arena. The main horse barn South aisle features 8 stalls, 2 doubles, feed room and hay loft for 700 bales. North aisle has five foaling stalls, three 20x14 and two 10x12 stalls and a heated tack room. Two small paddocks in front, 6 medium pastures, 3 with sheds, 2 large turnout fields and a 100x200 outdoor arena. Lots of 3-board and wire fencing and the property pretty much encased with 5+ acres of woods on rolling, beautiful property! Also available is an adjacent 2017 1500 sq ft ranch on Galahad, 3 bed/2 bath with walkout basement on 5 more acres for a total of 30 acres for $1,250,000!
MlsNumber: --
ListingId: 20240082093


Listing Provided By: Coventry Realty LLC, original listing
Phone: (810) 678-2288
Office Phone: (810) 678-2288
Agent Name: Carole Porretta
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

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 = 3461 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;
Stacy Rader
ASCIIRoss Realty
Call Today!: (248) 730-5093

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App