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

23868 200th Avenue
Tustin, MI 49688

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2958
Agency: Cb Schmidt - Cadillac

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Property Type: Residential
Year Built: 1992
Notes: Immaculate, 3Bedroom, 3Bath home on 21 gorgeous acres, bordering State land! Awesome kitchen with quartz counters and all the appliances are included. Main floor master bedroom with a shared full bathroom (includes a shower and a soothing jetted tub), plus 2bedrooms upstairs with the 2nd full bathroom. The main floor also includes the living room with a fireplace; the fabulous knotty pine family room with cathedral ceiling and the 2nd fireplace (beautiful masonry); and the 3 season screened porch overlooking the beautiful wooded setting! Now to the walk-out lower level with its expansive additional family room, the 3rd fireplace, 3rd full bathroom, an office(or a non-conforming 4th bedroom), plus the laundry and storage area! See MORE... In all, nearly 3000 SF of finished living space here for family, entertaining, room to roam! Outdoors you will enjoy the 30 X 40 garage with a large loft, paved driveway, pretty landscaping, garden area, and peaceful wooded surroundings! You can hunt, hike, snowmobile, or just bask in the calm and enjoy the abundant wildlife! (Frequent sightings of deer bounding through the yard in the evenings!) You're a short drive to Cadillac for shopping, unique eateries, and magnificent Lakes Cadillac & Mitchell for all your fishing, boating and swimming fun!! Close to Caberfae ski area and only about one hour to Lake Michigan and Traverse City!
MlsNumber: 24018595


Listing Provided By: Cb Schmidt - Cadillac, original listing
Name: Cb Schmidt - Cadillac
Phone: (231) 775-1737
Office Name: Cb Schmidt - Cadillac
Office Phone: (231) 775-1737
Agent Name: Peter Nemish
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App