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

540 S Lakeshore
Marquette, MI 49855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $564,900
Beds: 2
Baths: 2
Status: Pending
SqFt: 1102
Agency: LOOK REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2013
Notes: Discover the pinnacle of luxury living in Marquette at this exquisite condo located in the heart of the city's most desirable area, Founders Landing. Nestled right across from the pristine waters of Lake Superior, this residence offers breathtaking views of endless sunsets and the iconic Ore Dock, creating a picturesque backdrop for your daily life. Step inside this beautifully designed home to find an open-concept kitchen and living area, perfect for both entertaining and everyday living. The kitchen features elegant cherry cabinets, sleek granite countertops, and modern appliances. The seamless flow into the spacious living room, bathed in natural light from the large windows, makes this space warm and inviting. This condo boasts two generously-sized bedrooms both with lake views and two full bathrooms. The primary bedroom is a serene retreat, complete with a walk-in closet, a double sink vanity, and a beautifully tiled shower. The secondary bedroom is perfect for guests or a home office, offering ample space and comfort. One of the standout features of this property is the expansive covered deck overlooking Lake Superior. Imagine starting your day with a cup of coffee or ending it with a glass of wine, all while taking in the stunning lake views and vibrant sunrises and sunsets. Founders Landing is known for its scenic beauty and central location; this area has been transformed into a vibrant community. You'll be steps away from the best restaurants, shopping, and cultural attractions that Marquette has to offer. Don’t miss this rare opportunity to own a piece of Marquette’s most sought-after location. Schedule a showing today and experience the unparalleled beauty and convenience of living at Founders Landing!
MlsNumber: 50143460


Listing Provided By: LOOK REALTY, original listing
Name: LOOK REALTY
Phone: (906) 228-7255
Office Name: LOOK REALTY
Office Phone: (906) 228-7255
Agent Name: STEVE PELTO
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