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

6139 W Us 2 Highway
Norway, MI 49870
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: $598,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 2454 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: 5 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: Your Pot of Gold May Be At The End Of This Rainbow… - This special property is located off the south side of US Highway 2 west of the Village of Norway. Norway is a city in Dickinson County, in the western Upper Peninsula of Michigan. The town is known as the City of Trails, and known for its beautiful scenery, which attracts tourists from all over the world. -Dickinson County is situated on the Menominee River, which forms the border between Michigan and Wisconsin. - Living in this County offers many ways to enjoy the outdoors in every season. - In the summer: There’s whitewater rafting through the Piers Gorge on the Menominee River. You can canoe, kayak and fish on the many lakes and rivers in this County. Dickinson County has three golf courses, one, TimberStone, has a Top-Rated designation by Golf Digest and Golf Week. You can go mountain biking, and even alpine rock climb and go zip-lining here. There’s the Fumee Falls roadside waterfall, and the Fumee Lake Natural Area which provides 1,800 acres of nature watching and photographing of bald eagles, loons, warblers, and many species of animals and plants, including orchids. You can watch races at the Norway Speedway, a 1/3 mile paved American Speedway Association member track. The Summer wraps up with the Dickinson County Fair, each Labor Day. - Fall offers great hunting because of the quantity of whitetail deer in the area, as well as seasons for other game animals. In Winter World-Class international ski jumpers compete each year at the Pine Mountain Ski Jump, the largest ski jumping facility in North America. Pine Mountain also has lit cross country trails and a ski area for lots of family fun. The area boasts of 120 miles of snowmobile trails! - The Property offered for sale not only has a beautiful home, but some very awesome features located at the back of the property that will be beyond your expectations. - The Home Main Floor features a spacious Living Room with Lp-Gas Fireplace, Kitchen and Dining Area. Off the Dining Area is a Three-Season Room where you can relax and enjoy beautiful views. Just down the Hall are three Bedrooms, and a Full Bath. - From the Kitchen is a Back Foyer with a Laundry Center, Half Bath, and a door leading to the Attached 13x26 2-Car Garage, and the Stairway to the Lower Level. Here you will find a large Family Room with a Wood Burning Fireplace, Craft Room, and the Basement Mechanical Area, plus lots of Storage! - After viewing the beautiful home, turn up the driveway and stay to the right and continue around the home to the back yard. - To your left you will see a 195 square foot “Old Store” building (built in the 1960s) that can be used for Storage or a Studio. It has a cement floor and electric heat. - Immediately to the right you will see the Alpaca Barn next to the parking area, and ‘will be greeted by sweet alpacas greeting you with their “smiles”. - The Current Owners began an Alpaca Business here in 2005 – The alpacas currently living here are negotiable to the right family. - In 2010 a beautiful 36x48, 1728 square foot building was erected in this area – This huge space, is currently used as a Show Room for many beautiful alpaca products. But it could be used for a multitude of other purposes – such as a Wedding Chapel, Event Center, Workout Studio, Classrooms, or Retail Space. - This building Main Level features high Vaulted Ceilings with floor to ceiling windows, a Gathering Area with a stone-faced Fireplace that people can cozy up next to, a Sales Area, Classroom Area, Office Space, Check Out Area and a Wheelchair Compliant Restroom. This Level is surrounded on three sides by an Exterior Deck, to enjoy the panoramic views of the property, with alpaca grazing in the several grassy corrals. - An open stairway leads to a Loft Area, for more Office Space, and lots of Storage. (Con't: Ask Agent For A Copy of the Text Found In Associated Documents)
MlsNumber: --
ListingId: 50145302


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