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

9425 &amp 9435 Birch Ridge
Onaway, MI 49765
Caitlin Anderson with Schmidt Realtors, original listing - (231) 526-1100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $835,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2200 Square Feet
Agency: Schmidt Realtors
Agency Phone: (231) 526-1100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Don't miss this exceptional gem, offering over 200 feet of lakefront on Black Lake, three expansive lots, and direct access to 332 acres of state land bordering the parcel. Location, Location, Location! This estate provides the ultimate privacy and tranquility at the dead end of a quiet road. Featuring 4 bedrooms and 2 bathrooms, this home is designed for comfort, main floor living, and style. Enjoy a freshly remodeled kitchen with brand-new stainless steel appliances, elegant hard surface countertops, and a fresh coat of paint throughout. The main level boasts new luxury vinyl plank flooring, while the second floor is adorned with plush new carpeting. Enjoy sprucing up the small cabin on the adjoining parcel for company overflow or rental income. Additional highlights include a detached 2-car garage, large garden, and the fact that this home is move-in ready, allowing immediate occupancy! Embrace the stunning fall colors and breathtaking sunrises from your new lakeside haven. Black Lake has over 10,000 acres of beautiful clear blue water, and known for its excellent boating opportunities, making it the perfect lake for water enthusiasts of all kinds. It is celebrated for its exceptional fishing, from Northern Pike, Large Mouth Bass, Muskie and with over 1.2 million walleye planted in its waters in the last decade alone, it is a fisherman's paradise. Come see this legacy home and imagine all the memories waiting to be made.
MlsNumber: --
ListingId: 474900


Listing Provided By: Schmidt Realtors, original listing
Phone: (608) 387-3952
Office Phone: (231) 526-1100
Agent Name: Caitlin Anderson
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt REALTORS. 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