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;

255 Birchridge
Marquette, MI 49855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $485,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 1610
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: 1998
Notes: This wonderful standalone Marquette townhome has all the features you could dream of! Main floor living is possible in this spacious home featuring over 3000 finished square feet. The large composite deck overlooks the quarry pond below, and the canopy of trees gives off a very private and wooded feel. Abundant wildlife inhabits the pond area right in your front yard, the evening sunsets can be incredible, and the pond can be accessed by all association members at a common trail to the North end. Off of the deck is an amazing brick stone paver patio area with grill and fire feature hooked up to natural gas. The driveway is plowed by the association in the winter, as well as the lawn care in the summer. Inside, you will be amazed at the openness and natural light flowing through the main living and kitchen areas. Maple ¾” solid hardwood flooring throughout the main floor as well as all solid oak panel interior doors. The kitchen features granite counters, beautiful tile backsplash, all new stainless appliances late last year, and a convenient main floor laundry closet and large pantry closet. Access to the garage is from the kitchen as well for easily hauling in the groceries. The master suite is large with loads of natural light and wooded views as well, large master bath with tile floors, double granite sinks and custom tile shower. The main floor guest bath also has tile floors and custom tile shower and marble vanity top. Nicely sized main floor guest bedrooms again with lots of natural light, the one doubles as the library with incredible solid oak built in bookshelves. Very reasonable utilities including central air for the warmer summer days. But wait there’s more! The lower level of this home is where the magic happens. Aside from a large legal 4th guest bedroom, the large family room rec area has a wet bar with custom solid slab bar top, sink, refrigerator, gas fireplace, custom built wood murphy bed for more overflow for guests, an exercise room, cedar electric sauna and full bathroom – this home truly has it all! Loads of storage in the basement mechanical room as well as large racks in the garage. All offers due Monday March 11th at 5pm with response within 24 hours after.
MlsNumber: 50134688


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: MICHAEL GOLISEK
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