Unique custom built home on 10 acres partially wooded with trails. Just under 300 ft lake frontage on all-sports Sturgeon lake. 5 bedrooms 3.5 baths over 5,000 sq/ft. Kitchen features custom cherry cabinets and granite counters. Living room open with 28 ft. vaulted ceiling, Stone gas fireplace. Sun room and sitting room. lots of windows to enjoy the lake views and abundance of wildlife. 3 season room with new windows. Lower walk-out level features bedroom, bathroom, home office/bedroom. Wine cellar/storm shelter with concrete walls, floors and ceiling with steel beam. Lots of storage. 30x30 Outbuilding features a garden room, tractor barn and storage workshop, plenty of room to store summer toys. New metal roof on house and outbuilding, whole house generator. 2.5 hours from Chicago or Detroit
Sold for $870,000
$870,000
57135 Farrand Rd, Colon, MI 49040
5beds
4,827sqft
Single Family Residence
Built in 2003
10 Acres Lot
$918,300 Zestimate®
$180/sqft
$3,864 Estimated rent
Home value
$918,300
Estimated sales range
Not available
$3,864/mo
Zestimate® history
Owner options
List your home for rent
$3,864/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,864/mo
Rent Zestimate®
Refinance and save
$5,435/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,435/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Tractor barnGas fireplaceStorage workshopGarden roomWine cellarMetal roofLake frontage
Zillow last checked:
Listing updated:
Listed by:
Coral Van Ells 517-403-8518,
Howard Hanna Real Estate Services-Adrian
Bought with:
Jennie Avis, 6501430238
Redfin Corporation
Source: MiRealSource,MLS#: 50171198
Originating MLS: Lenawee County Association of REALTORS
Originating MLS: Lenawee County Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Main level bathrooms: 1
- Main level bedrooms: 1
Bedroom 1
- Features: Wood
- Level: Main
- Area: 288
- Dimensions: 18 x 16
Bedroom 2
- Features: Carpet
- Level: Lower
- Area: 234
- Dimensions: 18 x 13
Bedroom 3
- Features: Carpet
- Level: Upper
- Area: 240
- Dimensions: 16 x 15
Bedroom 4
- Features: Carpet
- Level: Upper
- Area: 252
- Dimensions: 14 x 18
Bedroom 5
- Features: Carpet
- Level: Lower
- Area: 154
- Dimensions: 14 x 11
Bathroom 1
- Features: Ceramic
- Level: Main
Bathroom 2
- Features: Ceramic
- Level: Second
- Area: 187
- Dimensions: 17 x 11
Bathroom 3
- Features: Ceramic
- Level: Lower
- Area: 63
- Dimensions: 7 x 9
Family room
- Features: Wood
- Level: Main
- Area: 525
- Dimensions: 35 x 15
Kitchen
- Features: Wood
- Level: Main
- Area: 224
- Dimensions: 14 x 16
Living room
- Features: Wood
- Level: Main
- Area: 288
- Dimensions: 18 x 16
Heating
- Forced Air, Propane
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Laundry: Main Level
Features
- Flooring: Ceramic Tile, Wood, Carpet
- Basement: Full,Concrete
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 5,554
- Total interior livable area: 4,827 sqft
- Finished area above ground: 3,228
- Finished area below ground: 1,599
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Features
- Levels: One and One Half
- Stories: 1.5
- On waterfront: Yes
- Waterfront features: All Sports Lake, Waterfront
- Body of water: Sturgeon Lke
- Frontage type: Road
- Frontage length: 291
Lot
- Size: 10 Acres
- Dimensions: 291 x 1485
- Features: Rural, Wooded
Details
- Additional structures: Pole Barn
- Parcel number: 00201000320
- Special conditions: Private
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Stone, Vinyl Siding
- Foundation: Basement, Concrete Perimeter
Condition
- New construction: No
- Year built: 2003
Utilities & green energy
- Sewer: Septic Tank
- Water: Private Well
Community & HOA
Community
- Subdivision: None
HOA
- Has HOA: No
Location
- Region: Colon
Financial & listing details
- Price per square foot: $180/sqft
- Tax assessed value: $825,600
- Annual tax amount: $10,519
- Date on market: 4/11/2025
- Cumulative days on market: 38 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 7/11/2025 | Sold | $870,000-3.2%$180/sqft |
Source:  MiRealSource #50171198 Report a problem | ||
| 5/21/2025 | Pending sale | $899,000$186/sqft |
Source: MiRealSource #50171198 Report a problem | ||
| 4/11/2025 | Listed for sale | $899,000-25%$186/sqft |
Source: MiRealSource #50171198 Report a problem | ||
| 11/8/2024 | Listing removed | $1,199,000$248/sqft |
Source: MiRealSource #50153357 Report a problem | ||
| 10/21/2024 | Price change | $1,199,000-39.9%$248/sqft |
Source: MiRealSource #50153357 Report a problem | ||
| 10/14/2024 | Price change | $1,995,000+53.6%$413/sqft |
Source: MiRealSource #50153357 Report a problem | ||
| 9/13/2024 | Price change | $1,299,000-4.4%$269/sqft |
Source: MiRealSource #50153357 Report a problem | ||
| 8/26/2024 | Listed for sale | $1,359,000+90.1%$282/sqft |
Source: MiRealSource #50153357 Report a problem | ||
| 1/5/2022 | Sold | $715,000-4.7%$148/sqft |
Source:  MichRIC #21115749 Report a problem | ||
| 11/22/2021 | Pending sale | $749,900$155/sqft |
Source: MichRIC #21115749 Report a problem | ||
| 11/19/2021 | Listed for sale | $749,900$155/sqft |
Source: MichRIC #21115749 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $10,232 +5.2% | $412,800 +6.6% |
| 2024 | $9,729 +63.1% | $387,100 +16.5% |
| 2023 | $5,964 | $332,300 +17.6% |
| 2022 | -- | $282,600 +7.6% |
| 2021 | $5,803 | $262,700 -1.3% |
| 2020 | -- | $266,200 +31.7% |
| 2018 | -- | $202,100 -0.6% |
| 2017 | -- | $203,300 -2% |
| 2016 | -- | $207,400 +3.3% |
| 2015 | -- | $200,700 +6.2% |
| 2014 | -- | $189,000 -5.5% |
| 2012 | -- | $200,000 +3.3% |
| 2011 | -- | $193,700 -15.6% |
| 2010 | -- | $229,600 -0.2% |
| 2009 | -- | $230,000 +5.6% |
| 2008 | -- | $217,900 +8.2% |
| 2007 | -- | $201,300 +6.1% |
| 2006 | -- | $189,800 +26.4% |
| 2005 | -- | $150,200 +5.6% |
| 2004 | -- | $142,200 +337.5% |
| 2003 | -- | $32,500 |
Find assessor info on the county website
Neighborhood: 49040
Nearby homes
- $393,900-- bd1 ba2.7k sqft57175 Farrand Rd, Colon, MI 49040Off Market
- $229,000-- bd-- ba-- sqft57175 Farrand Rd, Colon, MI 49040Off Market
- $580,500-- bd3 ba1.9k sqft57077 Farrand Rd, Colon, MI 49040Off Market
- $360,000-- bd1 ba1.7k sqft56899 Farrand Rd, Colon, MI 49040Sold
- $--10 AcresLot 3 Farrand Rd, colon, MI 49040Off Market
- $--10.25 AcresFarrand Rd, Colon, MI 49040Off Market
- $50,0005 bd4 ba7.2k sqft56861 Farrand Rd, Colon, MI 49040Sold
- $--0.93 Acres175 Streetm86 #483, Colon, MI 49040Off Market
Nearby schools
GreatSchools rating
- 5/10Colon Elementary SchoolGrades: K-8Distance: 1 mi
- 5/10Colon High SchoolGrades: 6-12Distance: 1.1 mi
Schools provided by the listing agent
- District: Colon Community School District
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$918,300
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$918,300
- Michigan
- Saint Joseph County
- Colon
- 49040
- 57135 Farrand Rd
Nearby cities
Nearby zip codes
Other Colon Topics
