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
Single-familyProperty Type
2003Year Built
10 acresLot Size
$305Est. Price/Sq.Ft.
2 car garageParking
Listed by Coral Van Ells• Howard Hanna Real Estate Services-Adrian
Claim this home to receive a free report every month with insights on the changing estimate.
Earn from this home
Refinance
$0
Est. cash available
Get cash now or lower your monthly rate
Rent
$2,467/mo
Redfin rental estimate
List your home for rent
Market trends in 49040, MI
Last updated September 2026
Buyer's Market
Seller's Market
Seller's market
Sale-to-List Price
96.2%
+2.2% MoM
Median sale price
$256K
$18K MoM
Avg. days on market
25d
0 days MoM
Recently sold homes
12
5 MoM
Provided by Redfin
Sale history for 57135 N Farrand Rd
Date
Event
Price
MiRealSource-MiMLS #50171198
Jul 11, 2025
Sold
$870,000
$270/sq ft
May 21, 2025
Pending
—
Apr 11, 2025
Listed
$899,000
$279/sq ft
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
REALCOMP #56050171198
Jul 11, 2025
Sold
$870,000
$270/sq ft
May 21, 2025
Pending
—
Apr 11, 2025
Listed
$899,000
$279/sq ft
MiRealSource-MiMLS #50153357
Nov 8, 2024
Listing Removed
—
Nov 5, 2024
Listing Removed
—
Oct 21, 2024
Price Changed
$1,199,000
$371/sq ft
Oct 15, 2024
Price Changed
$1,995,000
$618/sq ft
Sep 13, 2024
Price Changed
$1,299,000
$402/sq ft
Aug 26, 2024
Listed
$1,359,000
$421/sq ft
REALCOMP #56050153357
Nov 8, 2024
Listing Removed
—
Oct 21, 2024
Price Changed
$1,199,000
$371/sq ft
Oct 14, 2024
Price Changed
$1,995,000
$618/sq ft
Sep 13, 2024
Price Changed
$1,299,000
$402/sq ft
Aug 26, 2024
Listed
$1,359,000
$421/sq ft
SW Michigan MLS #21115749
Jan 5, 2022
Sold
$715,000
$221/sq ft
Nov 22, 2021
Pending
—
Nov 18, 2021
Listed
$749,900
$232/sq ft
Greater Lansing AoR #70238977
Jan 5, 2022
Sold
$715,000
$221/sq ft
Nov 18, 2021
Listed
$749,900
$232/sq ft
REALCOMP #68021115749
Jan 5, 2022
Sold
$715,000
$221/sq ft
Nov 22, 2021
Pending
—
Nov 18, 2021
Listed
$749,900
$232/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$3,810 (−63.1%)
2024
$10,334 (+64.2%)
2023
$6,295 (+60.3%)
2022
$3,926 (+100.7%)
2019
$1,957 (−62.9%)
2018
$5,275 (+3.4%)
2016
$5,103 (+1.1%)
2015
$5,049
Tax history for 57135 N Farrand Rd
Year
Property tax
Land + Additions
Assessment*
2025
$3,810 (−63.1%)
2024
$10,334 (+64.2%)
2023
$6,295 (+60.3%)
2022
$3,926 (+100.7%)
2019
$1,957 (−62.9%)
2018
$5,275 (+3.4%)
2016
$5,103 (+1.1%)
2015
$5,049
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
—
Baths
1.5
Stories
—
Lot width
—
Lot depth
—
Lot size
10 Acres
Year renovated
—
Sq. Ft.
3,380
Year built
—
Style
Single Family Residential
County
St. Joseph County
APN
002 010 003 20
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 2
Garage Type: Attached Garage
Interior
Interior Features
Has Fireplace
# of Rooms (Total): 12
# of Fireplaces (Total): 1
Has Fireplace
Fireplace Features: Gas Fireplace
Bedroom Information
Bedroom 1 Level: Main
Bedroom 1 Dimensions: 18 x 16
Bedroom 1 Floor Covering: Wood
Bedroom 1 Floor Covering: Wood
Bedroom 2 Level: Lower
Bedroom 2 Dimensions: 18 x 13
Bedroom 2 Floor Covering: Carpet
Bedroom 3 Level: Upper
Bedroom 3 Dimensions: W=15
Bedroom 3 Floor Covering: Carpet
Bedroom 4 Level: Upper
Bedroom 4 Dimensions: 14 x 18
Bedroom 4 Floor Covering: Carpet
Bedroom 5 Level: Lower
Bedroom 5 Dimensions: 14 x 11
Bedroom 5 Floor Covering: Carpet
Bathroom Information
Lower
# of Lavatories: 1
# of Bathrooms (Full): 3
# of Baths/Lavatories (Total): 4
Bathroom 1 Information
Lavatory 1 Width: 7
Lavatory 1 Length: 12
Lavatory 1 Level: Main
Lavatory 1 Floor Covering: Ceramic
Bathroom 1 Floor Covering: Ceramic
Bathroom 1 Level: Main
Bathroom 2 Information
Bathroom 2 Floor Covering: Ceramic
Bathroom 2 Level: Second
Bathroom 2 Length: 17
Bathroom 2 Width: 11
Bathroom 3 Information
Bathroom 3 Floor Covering: Ceramic
Bathroom 3 Level: Lower
Bathroom 3 Length: 7
Bathroom 3 Width: 9
Dining/Kitchen Information
Kitchen Floor Covering: Wood
Kitchen Level: Main
Kitchen Dimension: 14 x 16
Family/Great Room Information
Sun/Florida Room Floor Covering: Wood
Family Room Floor Covering: Wood
Sun/Florida Room Level: Main
Sun/Florida Room Dimensions: 8 x 19
Family Room Level: Main
Family Room Dimensions: 35 x 15
Library/Den/Living Room Information
Living Room Floor Covering: Wood
Living Room Level: Main
Living Room Dimensions: 18 x 16
Laundry/Basement Information
Laundry Room Floor Covering: Ceramic
Basement : Has Basement
Basement Type: Poured, Full
Laundry Room Level: Main
Laundry Room Dimensions: 12 x 10
Exterior
Exterior Features
Exterior Construction: Stone, Vinyl Siding
Foundation Type: Basement
Property Features
On Waterfront
Water Features: All Sports Lake, Waterfront
Frontage Type: Road
Lake Name: Sturgeon Lke
Property Information
Out Buildings: Pole Barn
Property Type: Residential
Structure Style: 1 1/2 Story
Year Built: 2003
Below Grade Sq. Ft.: 2326
Below Grade Sq. Ft. (Finished): 1599
Lot Information
SITE/LOT FEATURES: Rural, Wooded
Lot Size: 2,911,485
Land Information
Land Contract: No
Acreage: 10
Frontage: 291
Financial
Tax/Assessments Information
Total Tax Amount: $10,519
Summer Tax Year: 2024
Summer Tax Amount: $3,891
Winter Tax Year: 2024
Winter Tax Amount: $6,628
Utilities
Utility Information
Heat/Fuel Type: LP/Propane Gas
Water: Private Well
Cooling System: Ceiling Fan(S), Central A/C
Heating System: Forced Air
Sewer Septic: Septic
Location
Unit 5 Information
Living Room Dimensions: L=4827
School Information
School District: Colon Community School District
School District: Colon Community School District
Address Information
Street Designation: Road
Location Details
Directions: M-66 West of Colon Rd North Farrand Rd
Municipality: Colon Twp
Mail City: Colon
Subdivision: none
Municipality: Colon Twp
Area (Municipality): Colon Twp (75002)
Public facts
Beds: —
Baths: 1.5
Sq. Ft.: 3,380
Stories: —
Lot Size: 10 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: St. Joseph County
APN: 002 010 003 20
Home facts updated by county records on Sep 2, 2026
Other
Listing Information
Originating MLS: Lenawee County Association
Originating MLS: Lenawee
Around this home
Schools
Colon Elementary School
Public K-8 • Assigned • 1.0mi
5/10
Colon High School
Public 6-12 • Assigned • 1.1mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 100° expected this year, 15 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Colon, MI • 49040
Average low and high temperatures (°F)
28
15
35
20
54
34
62
42
68
49
80
61
84
66
79
60
77
54
66
45
49
36
36
23
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.3 hours in
June and 2.8 hours in December, placing it below the
U.S. average for solar exposure.
10.3 hrs
2.8 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$935,000 – $1.13M
Sell confidently with a local market expert in Colon. 3 minutes to get started.