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

171 S Genessee Street
Bellaire, MI 49615
Julia Pietrowicz with Keller Williams Northern Michi, original listing - (231) 922-7002

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1176 Square Feet
Agency: Keller Williams Northern Michi
Agency Phone: (231) 922-7002

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Turn-key waterfront opportunity! 100’ frontage on Intermediate River with direct access to Antrim County’s highly sought after lower chain-of lakes! This 2 bedroom, 1 1/2 bath carriage house is in the charming village of Bellaire. Appreciate the location, within walking distance to town, & the convenience of municipal water, sewer, & natural gas. What a great way to realize your dream of having an Up North getaway! The carriage house offers an oversized 3-car garage with a 2 bedroom 1.5 bath apartment upstairs. An open floor plan, spacious living room with fireplace, full kitchen with tile floors, main floor laundry & a sunroom, provide comfortable living. While the fireplace may warm you on the cooler days, the sunroom may become your favorite space regardless of season. A covered patio offers a great outdoor space for relaxing or grilling. If you want even more living space, with just under an acre of land there is plenty of property where you could build a house. The seller will be happy to share their ideas. While the property is in the village, you’ll appreciate the natural environment with views of the river & woods. A few friendly neighborhood deer often come to visit & when you’re at the river you’ll likely see the swans go by or the muskrats frolicking at the shore. You can fish off the dock, or head out to all-sports Lake Bellaire, just a short boat ride away. Within an hour, you can get to Torch Lake, & you can spend days exploring the wonderful lakes & rivers on the lower chain. You will be less than a mile from town where you can enjoy numerous restaurants, theater, bakery, ice cream shop & more. The area also offers multiple golf courses, Shanty Creek Resort for golf & skiing, & Glacial Hills Pathway & Natural Area is also close by. Head Up North anytime of the year. There’s always something to do & now you’ll have a place of your own.
MlsNumber: --
ListingId: 1925328


Listing Provided By: Keller Williams Northern Michi, original listing
Phone: (231) 360-0739
Office Phone: (231) 922-7002
Agent Name: Julia Pietrowicz
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