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

5520 Sw Boardman
South Boardman, MI 49680
Lisa Russell with REO-Cadillac-233028, original listing - (231) 468-3441

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $315,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 2250 Square Feet
Agency: REO-Cadillac-233028
Agency Phone: (231) 468-3441

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1936
Notes: This corner lot offers a tranquil water view of Wellman Pond, with direct water access right across the street. Enjoy fishing in the baited pond, or take a stroll along the scenic path that leads to the local store, passing by a beautiful waterfall along the way. Wellman Pond is a part of the Boardman River, flowing from western Kalkaska, adding natural beauty and recreational opportunities just steps from your property. Whether you're looking to build a cozy retreat or simply enjoy the peaceful water views, this lot is an ideal slice of northern Michigan paradise. Don’t miss this opportunity to own a solid 3-bedroom, 1-bathroom home with exceptional features! Set on a beautifully landscaped lot with an irrigation system in place, this home boasts a spacious kitchen, a newer addition, and bulletproof, hurricane-resistant windows on the east side for added peace of mind. Though the home needs some finishing touches, it has great bones. The septic is large enough to support an addition. The property includes an oversized two-car heated garage and a fenced backyard, perfect for keeping your furry friends safe. Conveniently located between Traverse City, Cadillac, and Kalkaska, this home is perfectly positioned for access to nearby towns and amenities. This is a must-see for anyone seeking both comfort and potential in a well-built home! Pictured is a double commercial lot across the street that the seller would like to sell along with the home. MLS #197574. A great opportunity for your new or existing business venture.
MlsNumber: --
ListingId: 1928804


Listing Provided By: REO-Cadillac-233028, original listing
Phone: (231) 645-0488
Office Phone: (231) 468-3441
Agent Name: Lisa Russell
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