Title Page Background
DEBUG FN args: Array ( [0] => 3181 [1] => [2] => [3] => agent ) BEFORE: Site: 3181 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3181 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3181 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3181 [1] => [2] => [3] => lender ) BEFORE: Site: 3181 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3181 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3181 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3181 [1] => [2] => [3] => other ) BEFORE: Site: 3181 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3181 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3181 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;

227 Beyerlein
Frankenmuth, MI 48734

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $311,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1514 Square Feet
Agency: Century 21 Signature - Frankenmuth

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator
Architectural Style: Ranch
Construction Materials: Brick
Cooling: Ceiling Fan(s)
Flooring: Carpet, Laminate, Concrete
Heating: Forced Air, Fireplace
Interior Features: Hardwood Floors, CERAMIC FLOORS
Rooms: Basement, Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Den, Dining Room, Kitchen, Laundry, Family Room, Living Room, Library

Window Features

Exterior Features: Porch, Patio, Deck, Shed, Fenced Yard, Lawn Sprinkler, Pool/Hot Tub
Fencing: Fenced
Parking Features: Garage, Garage - Attached
Other Features: Packing Shed, Shed(s)
Patio and Porch Features: Patio, Porch, Deck

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Vates Addition

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1955
Notes: Welcome to your dream home. A charming residence nestled in the heart of the vibrant City of Frankenmuth. This delightful property, now on the market, is perfectly designed for those who appreciate the blend of modern updates with cozy living spaces. Step inside to discover an open floor plan that invites warmth and natural light, making it an ideal setting for both relaxing and entertaining. The heart of this home, an updated kitchen, boasts custom cupboards that provide ample storage while adding elegance to your cooking experiences. Along with it, the main floor bathroom has been tastefully updated, ensuring a blend of style and functionality. The main floor has two well-appointed bedrooms, offering serene retreats for members of the family. A great office space, formal dining area, and a sitting room. Adding to its appeal is a partially finished basement featuring a family room perfect for gatherings, a convenient kitchenette, a workshop, an additional bathroom, and a bedroom—offering versatility whether you need more living space or an area for guests. Outside, the fenced-in yard becomes your oasis with its huge deck and patio area—ideal for outdoor dining or simply enjoying quiet mornings. The multi-level landscaping with sprinklers adds to the allure of this outdoor space, making garden maintenance both simple and enjoyable. The whole home and attached garage offers tons of storage. Situated in a welcoming community known for its charm and conveniences, 227 Beyerlein St. promises a lifestyle marked by comfort and convenience. Don't miss the opportunity to make this house your home.
MlsNumber: --


Listing Provided By: Century 21 Signature - Frankenmuth, original listing
Phone: (989) 239-7486
Office Phone: (989) 652-6080
Agent Name: Angie Muehlfeld
Disclaimer: Copyright © 2024 Multiple Listing Service MiRealSource. 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