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 = 1333 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1333 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1333 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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;

County Road 14
Grand Marais, MN 55604
William J. Lannon with Timber Ghost Realty LLC, original listing - (651) 329-0873

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Timber Ghost Realty LLC
Agency Phone: (651) 329-0873

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 44 acre(s)
Property Type: Land-Other
Year Built: --
Notes: GRAND MARIAS, MN: THE ULTIMATE NORTH SHORE GETAWAY ON LAKE SUPERIOR. <br /> 44.50 acres For Sale on Highway 14 just outside Grand Marais !<br /> Grand Marias has been named America's Coolest Small Town (Budget Travel Magazine), Top 10 Beach Getaways (Outside Magazine), and Next Great Adventure Town (National Geographic Adventure Magazine). In Grand Marais you'll meet some of the most friendly, creative and talented people, both visitors and locals alike. Snap up on this opportunity to own 44.50 acres of undeveloped land on Highway 14 just, 9 miles from downtown Grand Marais and approx 1.5 miles from Lake Superior. Cook County is a very sought after outdoor recreation destination. Building your home or cabin on this expansive property (close to Lake Superior) offers many beaches to wander and endless rock hunting. This North Shore / Lake Superior region has excellent stream fishing and offshore fishing. The Susie Islands and Isle Royale access is just down the road in Grand Portage Minnesota. The North Shore Hiking, Biking Trail is down the road. Ruffed grouse hunting in this region is considered some of the best in the USA. During the fall, the trees show spectacular and colorful foliage. Nearby is unbelievable outdoor winter recreation including many cross country ski trails, and Lutsen Mountains Ski and Summer Resort. Cook County is a destination for snowmobile enthusiasts. This property has many mature tree species and Kimball Creek runs through the property. Upon walking the land, it is apparent there are Whitetail Deer roaming. This 44.50 acre parcel has legal access onto County Road 14 and electricity at the road. If you are interested in walking the property, I would be happy to escort you, however not necessary !
MlsNumber: --
ListingId: 6579660


Listing Provided By: Timber Ghost Realty LLC, original listing
Phone: (218) 390-6663
Office Phone: (651) 329-0873
Agent Name: William J. Lannon
Disclaimer: Copyright © 2024 Regional Multiple Listing Service of Minnesota [NorthStarMLS]. 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