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

1994 W River Avenue
Oscoda, MI 48750

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1664
Agency: REAL ESTATE ONE NORTHEAST

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1969
Notes: Seven Mile Hill~ Fabulous location overlooking Foote Pond and Foote Dam. A familiar location to people who live in the area. Consumers Power gives you an easement to the water's edge for $138.00 yearly. Not your typical 3-bedroom 2 bath 2-story home. This place has a lot of character from when you walk into your stylish kitchen with all modern appliances, unique lighting, backsplash and stainless-steel sink and dish drain. Open floor plan gives you the opportunity to enlarge your dining area or living area. Reclaimed brick wood burning fireplace in living room. Patio doors lead to a 6 x 192 Screened in Back porch. Upper level gives you room for 2/3 bedrooms, 3/4 bath, cast iron/brick wood burning stove and a great view. Wide pine plank flooring. 2017 The owners installed a new L.P. heating system with A.C. and a heat pump. Home is generator wired and has a cement pad. New well with submersed pump. Backyard has a 4' privacy fence, 12 x 8 potting/mower shed with electricity, Mature cherry, plum & apple trees. Mature pine trees in front and back, walkway to the sand hill. 1-car oversized garage, Partial basement has a wine cellar, mechanical room and access to the crawl space. Circular driveways give you easy access in and out. This is a very desirable location. Would make a great Air B&B. House has been professionally, completely repainted on the outside. Beautiful job!! See the before and after pictures at bottom of photos.
MlsNumber: 1910381


Listing Provided By: REAL ESTATE ONE NORTHEAST, original listing
Name: REAL ESTATE ONE NORTHEAST
Phone: (989) 739-9129
Office Name: REAL ESTATE ONE NORTHEAST
Office Phone: (989) 739-9129
Agent Name: JUDY LIMBACH
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