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;

438 W Washington
Gwinn, MI 49841
AVIS MEYERS-KETOLA with CENTURY 21 PRIME REALTY, original listing - (906) 228-5230

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,999
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1243 Square Feet
Agency: CENTURY 21 PRIME REALTY
Agency Phone: (906) 228-5230

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1965
Notes: Updated and Renewed Home on Spacious Corner Lot with Serene Views Nestled on a large corner double lot just over ½ acre, this charming home offers the perfect blend of modern updates and peaceful natural surroundings. The expansive backyard, backing onto a serene wooded area, provides a picturesque setting filled with wildlife—ideal for relaxing mornings with coffee or enjoying an evening meal on the back deck. Drive up the paved driveway to your oversized two-car garage, freshly painted with a newly installed garage door opener. Inside, you'll find ample space for storage, a workbench, or hobby space. Upon entering the home, a welcoming entryway with a closet provides the perfect spot to store coats and boots. The attention to detail throughout is immediately apparent. From the newly refreshed paint to the charming planter boxes lining the garage—ready for your perennials—this home is a true delight. Step up to the covered front porch, open the new storm door, and enter into the spacious living room, where natural light pours in from the large windows that wrap around the corner of the home. The cozy fireplace invites you to sit and unwind, making this space the perfect place for family gatherings or quiet evenings. The home features beautiful, dark wood laminate flooring throughout, creating a warm and cohesive look. From the living room, the dining area is a seamless transition, with garden doors that open wide to let in the fresh air during warmer months. The custom tile floors in the dining and kitchen areas add character, while the newly built-in bookshelf and one-of-a-kind desk in the kitchen offer both style and functionality. The updated kitchen boasts all-new cabinets, a deep sink with a lovely view of the backyard, and modern appliances, including a new dishwasher and refrigerator. A large pantry provides plenty of storage space, making meal prep a breeze. Fully renovated bathroom showcases new flooring, a stylish vanity, and a fresh shower enclosure. Also a large linen closet. As a bonus, the fully finished lower level offers a spacious recreation room with fresh paint and carpeting, ready for whatever you envision—home theater, game room, or workout space. The adjoining family room features another cozy fireplace and is perfect for entertaining. A designated area is set up with counter space for a refrigerator, making it easy to host guests. Need a quiet retreat? There’s also a freshly painted and carpeted room, ideal for a home office or study, along with ample storage space to keep everything organized. Finally, step outside to discover a double-story shed, complete with electricity, concrete flooring, and plenty of windows to let in natural light—perfect for
MlsNumber: --
ListingId: 50160842


Listing Provided By: CENTURY 21 PRIME REALTY, original listing
Phone: (906) 228-5230
Office Phone: (906) 228-5230
Agent Name: AVIS MEYERS-KETOLA
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