Title Page Background
DEBUG FN args: Array ( [0] => 1288 [1] => [2] => [3] => agent ) BEFORE: Site: 1288 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1288 Igate: njhud LocID: 1288 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1288 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1288 [1] => [2] => [3] => lender ) BEFORE: Site: 1288 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1288 Igate: njhud LocID: 1288 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1288 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1288 [1] => [2] => [3] => other ) BEFORE: Site: 1288 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1288 Igate: njhud LocID: 1288 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1288 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

6634 Newcosta Avenue
Stanwood, MI 49346
Tyler Haynes with RE/MAX TOGETHER, original listing - (231) 629-4100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $779,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2950 Square Feet
Agency: RE/MAX TOGETHER
Agency Phone: (231) 629-4100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1981
Notes: A true must-see! This private retreat is nestled amongst 10 acres of lush woods and open fields, bordered on 2 sides by 219 acres of Consumers waterfront property. In a living setting well secluded from the road, you're sure to find your mornings on the covered 3 seasons screened-in porch from your bedroom's slider delightful, enjoying the sunrise through the trees, and the unbroken sounds of the abundant wildlife. This well-maintained and meticulously cared for 3 bed 3 bath home offers its next owner all of the ''extras'' they are in search of. This 3200+ square foot home was built to last, and has been improved upon since its completion with handmade wood features throughout and added insulation in most of the roof areas. The two fireplaces will keep you warm, including the downstairs wood-burning fireplace that provides a comfortable setting any time of the year, all while you enjoy the wet bar and walkout patio spanning over 60'. The downstairs also features a full bath and mudroom with nearby outdoor access, so cleanup after a day of biking nearby trails, fishing or boating the river, or hunting your ground or nearby state land is a breeze. The newly added hardscapes outside expand the scenery along with the fresh stain on the exterior providing added protection for years to come. A 24'x36' heated garage provides plenty of space for your toys, or moving about the cars with ease. If that isn't enough, there's the 30' x 42' pole barn that comes complete with a split space that's heated and cooled, while being set up to handle all the shop equipment you need to house your hobbies. Thoughtfully constructed and covered wood storage areas are placed within walking distance to the basement and the wood boiler keeping things dry year round. The newly added True Stream Fiber Optic service provides a stable internet for streaming and entertainment purposes. When you're not enjoying the wildlife or outdoor features you can find yourself on the water just minutes from Hardy Pond, catching Bluegill, Rock Bass, Walleye, Trout, and numerous other species in this 4000+ acre water system, boasting depths of up to 110ft. This waterway draws many enthusiasts from around the state with its boating experiences all season long as it spans over 50 miles of undeveloped shoreline. In the heart of the nearby acreage and within your reach, you'll find the illustrious Dragon Trail, with an expected 40-plus miles of compacted trail awaiting your adventurous side. All of this, only 40 miles north of Grand Rapids, and a short drive from HWY 131. This rare opportunity is sure to please, call to schedule your showing today! **Certain personal property can be included with the right offer.
MlsNumber: --
ListingId: 24027851


Listing Provided By: RE/MAX TOGETHER, original listing
Phone: (616) 318-2540
Office Phone: (231) 629-4100
Agent Name: Tyler Haynes
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => mecosta [3] => MI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: mecosta State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: mecosta State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1288 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Jacklynn Bissonette
Jacklynn Bissonette
ASCIICENTURY 21 Rockgate
Call Today!: (989) 317-5660

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App