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','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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;

1341 Corey Court
Bellaire, MI 49615

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,900
Beds: 2
Baths: 1
Status: Pending
SqFt: 1080
Agency: Keller Williams Northern Michigan

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2002
Notes: Northeastern Log Home on lovely wooded corner lot in Swiss Village East. Whether you are looking for an Up North getaway or an income property, this is a very nice option. It is the quintessential cabin in the woods and it is just minutes from Shanty Creek Resort and the ski slopes at Schuss Mountain, and about 10 minutes from the charming village of Bellaire. When you want to get away from things, relax on the wrap around covered porch listening to the breeze in the towering trees. You can also enjoy the warmth of the gas fireplace in the living room. The cabin has an open floor plan with a galley style kitchen, dining area and living room with vaulted ceilings. The wood interior surfaces will reinforce that you’re at the cabin. There is a main floor bedroom and combination bath & laundry room with a stackable washer and dryer. Upstairs is a larger bedroom and a spacious loft that is currently being used as a bedroom and sitting/game area. In addition to the porch being extended around the house, the seller added a metal roof, paved the driveway, and insulated the crawl space. The furnace and heat pumps were replaced too. The heat pump offers heat and air conditioning and the furnace kicks in when the temperature is below 25. The gas fireplace also helps supplement the heat and provides a welcome ambiance. Swiss Village East includes access to a park area on the Cedar River, along with several parks throughout the neighborhood. This has been a successful rental and it is available furnished, with all furniture and contents, so if you want to continue it as a vacation rental, you can cover a good bit of your costs.
MlsNumber: 1920660


Listing Provided By: Keller Williams Northern Michigan, original listing
Name: Keller Williams Northern Michigan
Phone: (231) 947-8200
Office Name: Keller Williams Northern Michi
Office Phone: (231) 947-8200
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