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

2336 Catholic Church Road
Stockbridge, MI 49285
The Laforet Team with RE/MAX Real Estate Professionals, original listing - (517) 321-8255

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $618,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2616 Square Feet
Agency: RE/MAX Real Estate Professionals
Agency Phone: (517) 321-8255

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: Welcome to this beautifully updated farmhouse, offering the perfect blend of modern comfort and timeless charm. The house with over 2,500 square feet of finished living space, features hand-scraped, ceramic-coated Hickory flooring throughout the main living areas, adding warmth and character. The formal living room and dining room provide an elegant space for family gatherings, while the den off the living room offers a cozy retreat to relax and take in the scenic farm views.<br /> The remodeled eat-in kitchen is a chef's dream, complete with stainless steel appliances, sleek quartz countertops, and a convenient coffee bar—ideal for any home cook looking for style and function. Upstairs, you'll find two spacious bedrooms, a large main bath, and the primary suite, a true sanctuary with ample space to unwind.<br /> Step outside and explore the incredible outdoor opportunities! Raised garden beds, a potting shed, and a large outdoor wood burner that provides heat indoors are just the beginning. The property also features a giant pole barn and an iconic Old School Red Barn, both with metal siding and roofs for lasting durability.<br /> The guest apartment is a standout feature, with a fully finished first floor currently set up as a home brewing space, but perfect for processing area for hunters. The second floor is a remodeled 1-bedroom apartment, ready for guests or potential rental income. The property with its own outbuildings and guest apartment, making for a total of approximately 10 acres, providing endless possibilities for hobby farming, recreation, or simply enjoying your private rural retreat. Don't miss the opportunity to own this exceptional propertyschedule your showing today!<br /> <br /> Sale to include 33-15-15-13-100-06 - COM AT THE N1/4 COR OF SEC 13 S02*28'40''W ON NS 1/4 LN 294 FT TO THE POB, S-02*28'40''W ON 1/4 LN 379.72 FT. -N90*W 660.18 FT -N02*28'40''E 623.48 FT- N88*51'03''E 162.50 FT- N02*40'20''E 46.99 FT- S90*E ON N SEC LN 289.91 FT- S 02*28'40''W 294 FT -S90*E 207.78 FT TO POB SEC 13 T1NR1E 8.62 AC +/-
MlsNumber: --
ListingId: 285015


Listing Provided By: RE/MAX Real Estate Professionals, original listing
Phone: (517) 321-8255
Office Phone: (517) 321-8255
Agent Name: The Laforet Team
Disclaimer: Copyright © 2024 Greater Lansing 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.


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 = 3328 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;
Real Estate Expert Photo for Rebecca Dunne
Rebecca Dunne
ASCIIHoward Hanna Real Estate Executives Lansing Office
Call Today!: (517) 416-8663

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App