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

210 E Mcneil
Corunna, MI 48817

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $510,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3060
Agency: Home Field Michigan Real Estate Consultants

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2004
Notes: Discover the epitome of Craftsman-style elegance at 210 E McNeil St. in charming Corunna, MI. This exquisite 4-bedroom, 3-bathroom residence is a masterpiece of architectural design and impeccable craftsmanship. Step inside, and you'll be immediately captivated by the stunning interior details and custom finishes that adorn this home. Cathedral ceilings create an open, airy atmosphere, while abundant windows flood the space with natural light. The heart of the home is a gourmet kitchen that opens into the large dining space. It features high-end appliances, granite countertops, and an island perfect for gathering. The private master suite is a retreat of its own, boasting a large walk-in closet and a luxurious en-suite bathroom. The allure of this home doesn't stop indoors. Outside, the professionally landscaped yard is a work of art, providing a beautiful backdrop to your daily life. Entertain friends and family on the amazing multi-tiered deck, an ideal setting for outdoor gatherings, barbecues, or simply enjoying the tranquility of your surroundings. Situated in the heart of Corunna, this property offers the perfect blend of small-town charm and modern convenience. You'll have easy access to local shops, schools, and community amenities, making it a great place to call home. 210 E McNeil St. is not just a house; it's a statement of artful living. With its craftsman elegance, superior finishes, and carefully designed spaces, it's a home that truly stands out. Don't miss the opportunity to make it yours and experience the pinnacle of comfortable, stylish living in Corunna. **Included in the sale is Lot 026-18-200-001-01, which includes a 56x72 pole building, a 40x60 pole barn with an attached 14x32 tool shed, and the 20x60 office building which can be used for a business or easily converted into living quarters. Altogether, the lots total 3 acres.** Please be respectful and do not enter the property without a scheduled showing.
MlsNumber: 50125382


Listing Provided By: Home Field Michigan Real Estate Consultants, original listing
Name: Home Field Michigan Real Estate Consultants
Phone: (989) 725-5088
Office Name: Home Field Michigan Real Estate
Office Phone: (989) 725-5088
Agent Name: Philip Hadley
Disclaimer: Copyright © 2024 Greater Shiawassee Regional Board 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