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 = 1314 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 = 1314 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 = 1314 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;

8140 S 2nd Street
Mattawan, MI 49071
David Lambe Elevate Team with Michigan Top Producers, original listing - (269) 222-2550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,999
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3027 Square Feet
Agency: Michigan Top Producers
Agency Phone: (269) 222-2550

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: OPEN HOUSE Sunday 10/13 from1-3. Welcome to your dream home! Nestled on a sprawling 1.86-acre lot, this beautifully maintained 1999 Cape Cod home offers the perfect blend of modern convenience and serene country living. Located in the highly desired Mattawan School District, this property is a rare find with its proximity to multiple restaurants, lakes, and easy access to the highway. This home features three spacious bedrooms and two full bathrooms on the main floor, providing convenient living all on one level. The upstairs is an oversized bedroom/living space, offering additional versatility. The basement includes two bedrooms, a full bathroom, and a kitchen, perfect for extended family or guests. The open concept living area on the main floor creates an inviting space, ideal for entertaining and everyday living. You'll appreciate the convenience of the attached two-car garage, providing ample storage and easy access to your vehicles.<br /> <br /> Enjoy the charm of the front porch, ideal for relaxing and taking in the surroundings. The property also features a back patio, perfect for outdoor gatherings and enjoying the expansive 1.86 acres.<br /> <br /> Situated just minutes from multiple restaurants and picturesque lakes, and less than 10 minutes to the highway, you'll enjoy the tranquility of country living with the convenience of city accessibility. This exceptional property is not just a home, but a lifestyle. Whether you're looking to start a small farm, indulge in gardening, or simply enjoy the peace and quiet of rural life, this home has it all.<br /> <br /> Schedule a showing today and experience the perfect balance of luxury and country living!
MlsNumber: --
ListingId: 24053064


Listing Provided By: Michigan Top Producers, original listing
Phone: (269) 290-0298
Office Phone: (269) 222-2550
Agent Name: David Lambe Elevate Team
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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