- 6 beds
- 5 baths
- 6,595 sqft
- ~7 acre lot
- $181 per sqft
- 2001 build
- – on site
Discover your luxury retreat on over 6.5 acres! This exceptional 6-bedroom, 4.5-bath home offers 4,100+ sq ft plus a fully finished lower level. The complete remodel of the kitchen features Caf© and Viking appliances, new cabinetry & countertops, an 8-ft island, and heated floors. The first-floor primary suite offers a spa-inspired bath complete with a soaking tub, walk-in shower, and heated floors. Rich walnut flooring and soaring ceilings enhance the great room, with a gas fireplace and Sonos sound system. An expansive bonus room provides the perfect space for a home gym, office, or playroom. The finished lower level includes a theater room, bar, family room, full bath and additional bedrooms. Step outside to your own paradise featuring a stunning saltwater pool with waterfall, large patio, new landscaping, and a 60x40 heated barn. Home Generac generator. Additional updates include new windows (2021), HVAC, hot water tank, roof (2018), well & well pump (2019), and driveway (2024). Filled with high-end upgrades and thoughtful details, too many to list!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 20, 2025
•
MLS# 57050178518 —
The Building
-
Year Built:2001
-
Construction Materials:Brick, Stone
-
Architectural Style:Contemporary
-
Levels:OneandOneHalf
-
Basement:Finished, Full
-
Basement:true
-
Foundation Details:Basement
-
Patio And Porch Features:Patio
-
Building Area Source:PublicRecords
-
Above Grade Finished Area:4171.0
-
Above Grade Finished Area Source:PublicRecords
-
Below Grade Total Area:2424
-
Below Grade Finished Area:2424.0
Interior
-
Interior Features:WetBar, WalkInClosets
-
Fireplace:true
-
Fireplace Features:GreatRoom
Room Dimensions
-
Living Area:6595.0
Location
-
Cross Street:Rauch / Douglas
The Property
-
Parcel Number:0803300850
-
Property Type:Residential
-
Property Subtype:SingleFamilyResidence
-
Lot Size Acres:6.53
-
Lot Size Dimensions:303 x irreg
-
Zoning Description:Residential
-
Other Structures:PoleBarn
Listing Agent
- Contact info:
- Agent phone:
- (734) 854-4000
- Office phone:
- (734) 854-4000
Taxes
-
Tax Legal Description:2020R16858 2014R14044 2008R23006 2007R13742 2518-255 1920-620 SEC 33 T7S R7E 6.535 AC PART OF SW 1/4 OF SEC 33 COM AT SE COR OF SW 1/4 OF SEC 33 TH N 00 DEG 00' 41" W ON E LI OF SW 1/4 OF SEC 33 1442.31 FT TH N 90 DEG 00' 00" W 678.51 FT FOR POB TH S 38 DEG 52' 00" W 515.94 FT TO PNT ON CNT LI OF ROBINSHIRE DR TH S 90 DEG 00' 00" W 33.00 FT TO PNT OF CURVATURE TH IN NW'ERLY DIRECTION ON A CURVE BEARING TO THE RIGHT RADIUS OF 300 FT ARC LENGTH OF 674.74 FT CENTRAL ANGLE OF 128 DEG 52' 00" CHORD BEARING N 25 DEG 34' 00" W CHORD DISTANCE OF 541.25 FT TO PNT OF TANGENCY TH N 38 DEG 52' 00" E 303.07 FT TH S 51 DEG 08 00" E 513.95 FT TO POB. ALSO 1/13 OF THE FOLLOWING RETENTION POND PARCEL 1.690 AC PART OF SW 1/4 OF SEC 33 BEG AT NE COR OF LOT
-
Tax Annual Amount:9878.04
Beds
-
Total Bedrooms:6
Baths
-
Total Baths:5
-
Full Baths:4
-
Half Baths:1
Heating & Cooling
-
Heating:ForcedAir, NaturalGas
-
Heating:true
-
Cooling:CentralAir
-
Cooling:true
Utilities
-
Sewer:SepticTank
-
Water Source:Well
Appliances
-
Appliances:Dishwasher, Microwave, Oven, Refrigerator, Range, WaterSoftenerOwned
Schools
-
High School District:Ida
The Community
-
Subdivision Name:SHERWOOD PARK
-
Pool Features:InGround
-
Waterfront:false
-
Association:true
Parking
-
Garage:true
-
Garage Spaces:3.0
-
Attached Garage:true
-
Parking Features:ThreeCarGarage, Attached
IDX provided courtesy of Realcomp II Ltd., via Estately and Southeastern Border Association of REALTORS, © 2025 Realcomp II Ltd. Shareholders
Estately Inc. is a Michigan licensed brokerage #6505374810, managed by Michigan licensed REALTOR® broker Darren Yearsley #6505374810.
IDX information is provided exclusively for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
IDX provided courtesy of Realcomp II Ltd. via Estately Inc. and REALCOMP. ©2025 Realcomp II Ltd. Shareholders.
Monthly cost estimate

Asking price
$1,200,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$6,425
|
Taxes | $823 |
Insurance | $330 |
Utilities | $252 See report |
Total | $7,830/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/20/25
Jun 20, 2025
|
Listed / Active | REALCOMP | $1,200,000 | |
6/16/25
Jun 16, 2025
|
Delisted / Withdrawn | REALCOMP | $1,200,000 |