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;

13755 Sunrise
Baraga, MI 49908

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3000
Agency: Douglass Real Estate, Inc DBA RE/MAX Douglass Real

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2003
Notes: LAKE SUPERIOR at its finest......this is a supreme location with a panoramic, breathtaking view (from all areas of the home and property)..of the Huron Mountains, Keweenaw Bay, Lake Superior open waters, Pequaming and the Portage Entry, as the access to the Portage Canal and "The Copper Country'.....so as a boater/sportsman, you can easily get to all points .....and can enjoy premier fishing and boating conditions..........the shoreline is sandy/pebbles, so swimming is a must....you are just minutes from Baraga and L'Anse for shops and restaurants.........and the casino........and just 25 min from the cities of Houghton/Hancock.......the home combines a log cabin built in 1984 ...with a living room, kitchen area, two bedrooms and full bath..this could be an extended family living area......combines with the modern two-story home with basement, crawl space, built in 2003.. with a beautiful open floor plan and windows to showcase the water view......there is a main bedroom on the ground floor, though the sellers prefer their master to be upstairs..complete with a VIEW, vaulted ceiling, full bath and jetted tub and walk-in closet...also a loft area for the adventuresome kids to enjoy as sleeping space...,..the two-car connected garage has an area that was designed to use for an office...or hot tub....... the grounds are enjoyed during the seasons in which waterfront is enjoyed...with seating, firepit, and grill ,,,,,,,just another reason to know this is a quality lifestyle property. The home has three furnaces...main home, log section and garage..... Link to more photos: https://wetransfer.com/downloads/e12138d158ed8c9a720d05306153f51b20230531162452/973973
MlsNumber: 50099071


Listing Provided By: Douglass Real Estate, Inc DBA RE/MAX Douglass Real, original listing
Name: Douglass Real Estate, Inc DBA RE/MAX Douglass Real
Phone: (906) 482-1000
Office Name: RE/MAX DOUGLASS R.E.-H
Office Phone: (906) 482-1000
Agent Name: KAREN LAHTI
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