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;

3042 Brodie Road
South Branch, MI 48761
CHERYL MCDONELL with HAPPY ACRES REAL ESTATE, original listing - (586) 747-8767

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $185,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1176 Square Feet
Agency: HAPPY ACRES REAL ESTATE
Agency Phone: (586) 747-8767

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Nestled in a serene location, this charming two-bedroom, one-bath home offers the perfect blend of year-round living and a tranquil up north retreat. With the National Forest right across the street and the picturesque Alcona Pond just a short hike away, this home is a gateway to nature's splendors, providing endless opportunities for outdoor adventures. The home sits in a quiet area, surrounded by the peaceful ambiance of the forest. Imagine waking up to the sound of birds chirping and the fresh scent of pine trees. Whether it's hiking, fishing, or hunting, you are just steps away from nature's playground. Designed for ease of living, this low-maintenance home is ready for your next up north escapade. The open kitchen, dining, and living room area create a welcoming space, perfect for entertaining guests or relishing quiet family moments. The kitchen features an island with pull-out cupboards, making meal prep convenient and enjoyable. A newer roof and a Trane furnace guarantee that you stay warm and dry, no matter the weather. The back porch is a haven for watching sunsets, offering a relaxing spot to unwind after a day of adventure. The two-car garage provides ample room for storing all your up north toys, with RV hookup and lean-to. Additionally, a garden shed offers extra storage for tools and outdoor equipment, while the fenced yard ensures privacy and a safe space for pets to roam, plus an additional lot off Rose St. The home currently features one bathroom, but a second bath can easily be returned to a full bath. Additional features include Kohler whole house generator for reliable power, new hot water heater, new screen doors and doorwall and windows. For those who love to explore, the home is conveniently located near ORV, snowmobile, and the Shore-to-Shore trail. Whether you are an avid hiker, a fishing enthusiast, or a hunting aficionado, this home offers the perfect base for all your outdoor pursuits.
MlsNumber: --
ListingId: 1932337


Listing Provided By: HAPPY ACRES REAL ESTATE, original listing
Phone: (586) 747-8767
Office Phone: (586) 747-8767
Agent Name: CHERYL MCDONELL
Disclaimer: Copyright © 2025 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