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 Road
Covington, MI 49919
Timothy Keohane with Great Lakes & Land Real Estate Co, Inc - Marquette, 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: 2816 Square Feet
Agency: Great Lakes & Land Real Estate Co, Inc - Marquette
Agency Phone: (906) 228-9312

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Other
Year Built: --
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 an Open Deck that wraps around three sides of the structure. A Main Floor Front Door Foyer is flanked on one side by a 23 x 24 Great Room with a high open, beamed ceiling. It features full log interior log walls, with Birdseye and Cherry window trimming. A stone fireplace is in one corner, and across there are built-in bookshelves. At the opposite side of the Foyer is access to a large 12x20 Kitchen. A large central Island has a countertop with built-in cook stove, lower cabinetry, and an area for casual dining with a view of the outdoors. Along the outer wall are additional custom cabinets, and a countertop with a sink placed under a window that provides a view of the fields outside. The counter continues along a wall where the built-in oven, and a pass through to the spacious 11x14 Dining Room. A 6x8 Half-Bath is located along a back Hallway which has a Door to the Back Deck, and a Stairway to the Lower Level. The Upper Level is reached by a Custom Log Spiral Staircase. The Upper Level has a landing that could be used for a small office/sewing/crafting area, a 12x15 Bedroom, and a 10x12 Bathroom with a standalone shower and jacuzzi style tub. The Lower Level has a 16x32 Recreation Room, with Walk-Out Doors to the back yard, and birds-eye wood Bar. A Central Hallway leads you to a 10x14 Bedroom, a 10x10 Bedroom, an 8x10 Bathroom with a jetted bath with shower, and a large Laundry/Mechanical Room. There is in-floor heating in this Lower Level. If you are seeking a Log Home/Cabin for year-round adventures in the Upper Peninsula, Check This One Out!
MlsNumber: --
ListingId: 50147575


Listing Provided By: Great Lakes & Land Real Estate Co, Inc - Marquette, original listing
Phone: (906) 228-9312
Office Phone: (906) 228-9312
Agent Name: Timothy Keohane
Disclaimer: Copyright © 2024 LandLeader. 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