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

3430 Curtisville Road
South Branch, MI 48761

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $545,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3008
Agency: CAROLE WILSON REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39 acre(s)
Property Type: Residential
Year Built: 2000
Notes: Exquisite! These don't come around very often. All one level living set back off the road on a small hill in God's country. Paved road for easy access. This 2x6 construction home was built with all the upgrades: Marvin and Anderson windows, 5 inch well, and heated garage. Massive entertaining space that measures apx. 28x32 to hold all the family gatherings or large parties complete with it's own bathroom boasting a urinal! This room has wrap around views to the field to watch the deer and wildlife or to look out at the beautiful stocked pond. This could be a massive master if the 4th bedroom is needed. Very well maintained landscaping and gardens with a patio. Off to the side another garage/pole barn that is apx. 28x40 with an overhang to house all the toys and equipment. This 39 acre spread would be perfect for an up north retreat to hunt or full time residence. This property adjoins the national forest that goes all the way to M-33. This property has upwards of 20 deer daily that come to say hello. Inside the semi-open concept kitchen has stainless steel appliances, custom made Mr. Todd cabinets, some solid surface counters and an island for all of the food prep. You could eat off the floor in this beauty with the pride of ownership being apparent. Master en suite, skylights, custom gutters, 6 panel hardwood interior doors, gas fireplace, wood stove, sidewalks and hard floors make for very comfortable living. 50/50 open and wooded.
MlsNumber: 1920405


Listing Provided By: CAROLE WILSON REAL ESTATE, original listing
Name: CAROLE WILSON REAL ESTATE
Phone: (989) 728-0382
Office Name: CAROLE WILSON REAL ESTATE
Office Phone: (989) 728-0382
Agent Name: MICHELLE BASSI
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors 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