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 on 07/11/25
$870,000
57135 Farrand Rd, Colon, MI 49040
5beds
4,827sqft
Single Family Residence
Built in 2003
10 Acres Lot
$910,300 Zestimate®
$180/sqft
$3,843 Estimated rent
Home value
$910,300
$692,000 - $1.20M
$3,843/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: July 11, 2025 at 11:07am
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
- 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 & neighborhood
Location
- Region: Colon
- Subdivision: None
Other
Other facts
- 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 | ||
| 5/21/2025 | Pending sale | $899,000$186/sqft |
Source: MiRealSource #50171198 | ||
| 4/11/2025 | Listed for sale | $899,000-25%$186/sqft |
Source: MiRealSource #50171198 | ||
| 11/8/2024 | Listing removed | $1,199,000$248/sqft |
Source: MiRealSource #50153357 | ||
| 10/21/2024 | Price change | $1,199,000-39.9%$248/sqft |
Source: MiRealSource #50153357 | ||
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% |
Find assessor info on the county website
Neighborhood: 49040
Nearby schools
GreatSchools rating
- 4/10Colon Elementary SchoolGrades: K-8Distance: 1 mi
- 4/10Colon High SchoolGrades: 6-12Distance: 1.1 mi
- NALeonidas SchoolGrades: K-8Distance: 3.7 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 pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$910,300
2% more+ $18,206
With Zillow Showcase(estimated)
$928,506