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

311 S Lakeshore
Marquette, MI 49855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $775,000
Beds: 2
Baths: 4
Status: Active
SqFt: 1398
Agency: ARTISAN REAL ESTATE GROUP

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: The Customs House: Unit 1 provides 1848 sq ft of active downtown living, multilevel Marquette views, its efficient layout includes an open feel in 2 entertaining areas, a plethora of windows allowing natural light to grace your space. Inspired by & accentuating the original sandstone walls, the designer complements the buildings historical nature with a blend of classic and modern finishes. Crisp, clean kitchen & bathroom tile work accompanies white walls & deep gray trim, softened by natural, warm wood accents placed strategically throughout the unit. Modern lighting fixtures illuminate the beauty. Designed for maximum functionality, the kitchen boasts quartz countertops, solid-wood cabinetry & wood salvaged from the original building. Baths feature custom-made vanities crafted locally & contemporary plumbing fixtures & heated floors on timers. Right off the building is the bike path that runs through town in both directions, access to boating,kayaking, watersports and fishing right off the dock within walking distance, and when you want to relax, the beach is a short walk down the bike path. All of Marquette’s vibrant downtown including 16 restaurants, & social district is just a casual stroll away. Want the best seats to view the fireworks for the 4th of July? From the back of the building you get front row seats to the Ore Dock Fireworks display and you don’t have to hassle with parking with 8 parking spots at the building and 3 more dedicated spaces along 1 MQT Place. Phase two brings an outside area with fire pit garden & storage for outdoor rec.
MlsNumber: 50140866


Listing Provided By: ARTISAN REAL ESTATE GROUP, original listing
Name: ARTISAN REAL ESTATE GROUP
Phone: (906) 273-0652
Office Name: NEXTHOME SUPERIOR LIVING
Office Phone: (906) 214-4267
Agent Name: STEPHANIE JONES
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