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

34386 Younggren
Covington, MI 49919
TIM KEOHANE with GREAT LAKES & LAND OF MARQUETTE, INC., original listing - (906) 228-9312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $628,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1856 Square Feet
Agency: GREAT LAKES & LAND OF MARQUETTE, INC.
Agency Phone: (906) 228-9312

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1985
Notes: MICHIGAN KOSKI LOG CABIN/HOME FOR SALE - This cabin on a 40 Acre property is located in Covington Township, near the Village of Covington, which is in south-western Baraga County. This Michigan, Upper Peninsula community, along with the neighboring Village of Watton, holds numerous cultural and recreational events throughout the year, and is a Year-Round Outdoor Recreational Haven! The area was first settled by French-Canadian loggers around 1885. Finnish settlers started arriving in 1898, and farming became more prevalent, but logging continued to be an important occupation. Crop and dairy farming, and logging are still done in the area today. - Covington is known for its Historical Museum, and for a beautiful 1900s Art-Deco/Finnish Style church which is open to the public, that was designed by a Chicago Art Institute Professor. - About a mile+ from the property is the Covington Multi-Purpose Building - the large covered pavilion hosts many outdoor activities in the summer months. One of these popular events is an annual July-Daylong Finnish Music Festival which features musicians playing Finnish inspired music, meals, and tours. In the winter the pavilion is a skating/hockey rink. There's also a ski-hill with a tow-rope there, for skiing, sledding, and snowboarding. - Just about 2+ miles to the north-west, via the Plains Road, is access to thousands of acres of Copper Country State Forest Lands, and about 2+ miles to the south are thousands more acres of Copper Country State Forest Lands for walk-in fishing, trapping, and hunting. The area is known for super hunting, with Black bear, Bobcat, Coyote, Raccoon, Red fox, Red squirrel, Ruffed grouse, Varying hare, and Whitetail deer sighted regularly. - Less than a mile to the north is the Kelsey Creek, which flows northward to join the Sturgeon River. Where the river crosses the Plains Road is a great spot to launch a canoe or fishing boat and cast for some fine Trout or Bass. Beautiful Tibbets Falls is just a short distance past this river crossing. (Where the Plains Road takes a sharp right turn, there is a post at this spot where a trail road leads to a parking area at the end of the road and the beginning of a trail to the Falls). There is access to a section of the "North Country National Scenic Trail" also from this site, and few miles further up the road is access to a main North-South Multi-Use State Trail (No. 5) for motorized and non-motorized fun year-round - Biking, Hiking, Horseback riding, off-Roading, Cross-Country Skiing, and Snowmobiling! Two miles to the east is 622-Acre, 7-Foot Deep, Vermilac Lake for some great fishing for planted Walleyes, and naturally occurring Northern pike, Perch, Sunfish, and Crappies. The Baraga Plains Waterfowl Management Area, Big Lake Campground, and the Baraga Plains ATV Trail are also local area outdoor points of interest. - The Custom Koski Log Cabin was built in 1985. You enter the home off of... Ask for Text In Associated Documents
MlsNumber: --
ListingId: 50147575


Listing Provided By: GREAT LAKES & LAND OF MARQUETTE, INC., original listing
Phone: (906) 228-9312
Office Phone: (906) 228-9312
Agent Name: TIM KEOHANE
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