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

2184 German Street N
Maplewood, MN 55109
David Saint Germain with MetroHomesMarket.com, original listing - (651) 770-5000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $425,000
Beds: 4
Baths: Full: 2
Status: Active Under Contract
SqFt: 2100 Square Feet
Agency: MetroHomesMarket.com
Agency Phone: (651) 770-5000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Introducing a charming and beautifully updated two-story contemporary house that checks all the boxes for your dream home wishlist. This property offers a delightful mix of space, style, and functionality, making it a perfect fit for those who appreciate a move-in-ready home with plenty of modern amenities. With four well-appointed bedrooms and two bathrooms, this home is spacious enough to comfortably accommodate both your living and work-from-home needs. The house features a versatile loft area perfect for setting up your remote office or a cozy playroom. The light-filled primary bedroom ensures a peaceful retreat after a long day. The heart of this home is the recently updated kitchen which boasts appliances and opens to the dining and living areas, creating an inviting open-concept space. Whether you're whipping up a meal or entertaining guests, the layout facilitates easy interaction and a warm, sociable atmosphere. The living room, complete with a wood-burning fireplace, provides a perfect spot for chilly evenings. The vaulted ceilings and skylights throughout the home, floods the space with natural light, creating an airy and pleasant atmosphere. Updated windows ensure energy efficiency and quiet comfort. Fresh paint and new carpeting throughout mean you can tick off 'renovating' from your to-do list and simply enjoy the art of living. Step outside to discover more features that make this home a standout. The front porch welcomes you with open arms, setting the stage for many relaxing evenings watching the world go by. At the rear, an expansive deck off the kitchen invites you to host summer barbecues and family gatherings, all overlooking a fully fenced backyard that promises privacy and security. For those who can never have too much storage, there's a handy storage shed that ensures your garage remains clutter-free, expansive garage space and lower laundry room. Speaking of garages, car enthusiasts or anyone needing extra space will fall in love with the oversized garage, perfect for vehicles, workbenches, and more. A concrete driveway completes the picture, combining functionality with curb appeal. Located in a friendly and convenient neighborhood, your new home is just a stone's throw from essential amenities. Enjoy quick access to grocery stores, parks, and public transportation links, making your daily errands as convenient as possible. This property isn’t just a house; it’s the backdrop to your life’s next exciting chapter. Why just read about it when you can experience it yourself? Book your showing today and discover why this home is where your heart is set to reside. Let's make your dream home a reality!
MlsNumber: --
ListingId: 6700302


Listing Provided By: MetroHomesMarket.com, original listing
Phone: (952) 210-6962
Office Phone: (651) 770-5000
Agent Name: David Saint Germain
Disclaimer: Copyright © 2025 Regional Multiple Listing Service of Minnesota [NorthStarMLS]. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1379 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;
Anthony Rodriguez
ASCIIKeller Williams Realty Integrity Edina
Call Today!: (651) 402-4726

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App