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;

516 Blemhuber
Marquette, MI 49855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $729,900
Beds: 4
Baths: 3
Status: Active
SqFt: 1782
Agency: Call Terry Huffman Co DBA RE/MAX 1st Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Envision a sprawling ranch that exudes quality throughout its expansive layout, designed to accommodate the seamless integration of indoor comfort with outdoor living. This home is a testament to thoughtful design, where every detail is a stroke of intention, creating a living experience that is as luxurious as it is comfortable! As you enter the home you will immediately feel the quality of the construction. The well-appointed kitchen is so tastefully done with quartz countertops, custom hardwood floors, subway ceramic tile backsplash, under cabinet lighting, slow close drawers and top of the line appliances. The dining area transitions gracefully into the living room - the cozy fireplace and custom-built bookshelf/entertainment center is the main focal point of this room. The living room has beautiful views of south Marquette and this time of year you can even see Lake Superior. The window placement is this home is spot on allowing natural light from every angle. Directly off the living room you'll find the in-home office with built in cabinetry, open shelving, enclosed storage, desk space and French doors allowing for privacy when needed. The master bedroom suite is AMAZING with tray ceilings, bay window, walk in closet, glass and ceramic walk-in shower and double sinks. The main floor laundry has a utility sink and conveniently located just off the kitchen as you enter the home through the 3-car attached garage. The full finished walk-out lower level offers a realm of possibilities - with high ceilings, direct access to outside and huge windows this area is true living space. The bonus rec room is the perfect spot for watching sporting events, movies or gaming. This room also has an area perfect for workout equipment. The adjacent family room has sliding glass doors with access to the backyard and check out the pool table - this will be a favorite gathering place for family and friends. The bathroom is downright gorgeous - so spacious and the massive walk-in glass and ceramic shower will not disappoint. There are also 2 nice sized bedrooms, a mechanical/storage room and a 2nd laundry room to help with efficiency in daily life. This home boasts a spacious deck, perfect for hosting events or maybe savoring some peaceful quiet time. Prefer the shade then you'll enjoy the afternoon and evenings watching the wildlife come in from under the retractable awning positioned perfectly over the lower lever patio. The home has central air, inground sprinklers (6 zone), bathroom ceiling heaters and custom Hunter Douglas blinds! Located on a quiet dead-end street close to schools, Lake Superior, parks, biking and walking trails - this home has it all!
MlsNumber: 50138653


Listing Provided By: Call Terry Huffman Co DBA RE/MAX 1st Realty, original listing
Name: Call Terry Huffman Co DBA RE/MAX 1st Realty
Phone: (906) 225-1136
Office Name: RE/MAX 1ST REALTY
Office Phone: (906) 225-1136
Agent Name: KELLIE HILLIER-GENSCHAW
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