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

670 Co Rd Cvv
Champion, MI 49814-0000
SCOTT SYRJALA with COLDWELL BANKER SCHMIDT REALTORS, original listing - (906) 225-5992

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,925,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2252 Square Feet
Agency: COLDWELL BANKER SCHMIDT REALTORS
Agency Phone: (906) 225-5992

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 136 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Embrace the unparalleled peace and privacy of this extraordinary log cabin, where natural beauty meets modern comfort! Discover the perfect retreat in this beautiful 4-bedroom, 2-bathroom log cabin, skillfully constructed in 1994 and set on a sprawling 130-acre parcel on the serene shores of private Trembath Lake. This unique property is being split from a larger parent parcel, offering you an escape into nature. This home features stunning, large logs that create an inviting and warm atmosphere. Spanning over 2,250 square feet, the home has a spacious open-concept layout, highlighted by a breathtaking vaulted ceiling that provides panoramic views of the lake. Enjoy seamless living with a well-appointed kitchen that flows into the cozy living room, perfect for gatherings or peaceful evenings. This home also boasts several charming fireplaces, each adding warmth and character to the living spaces. Trembath Lake is renowned for its remarkable abundance of walleye and pike, making it a fisherman’s dream. The lake is a non-gas engine lake, ensuring a peaceful environment, ideal for relaxation. Venture out to explore the extensive trail system, perfect for hiking, biking or taking the ATVs or Snowmobiles through the picturesque landscape. With a newly installed solar system, this property exemplifies sustainability while offering the serenity of a private retreat. Additionally, this property has a detached two-car garage which provides ample storage for your vehicles and outdoor gear as well as a gazebo and shed. The Upper Peninsula of Michigan is a breathtaking tapestry of natural beauty, where lush forests meet rugged shorelines and crystal-clear lakes. Renowned for its stunning landscapes, the region boasts majestic waterfalls, scenic cliffs, and sweeping vistas that showcase the vibrant colors of each season. The UP's charm lies not only in its stunning scenery but also in its rich cultural heritage and welcoming communities, making it a truly enchanting destination. Please be sure to check out the video.
MlsNumber: --
ListingId: 50157390


Listing Provided By: COLDWELL BANKER SCHMIDT REALTORS, original listing
Phone: (906) 361-1858
Office Phone: (906) 225-5992
Agent Name: SCOTT SYRJALA
Disclaimer: Copyright © 2024 Upper Peninsula Association of 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