5900 Water Rd
Rothbury, MI 49452
Local Information
© Google
-- mins to
Description
A place to call home at the Double JJ Resort! Spacious log cabin boasts 2 bedrooms, 2 full baths and loft area. Beautiful decor; great view and fun things to do all year round. Full basement w/laundry area. The master suite features a private bath and in-room Jacuzzi Tub. Living area opens up with vaulted ceilings and a fireplace for cozy nights in. This charming home will place you in a family-oriented “Old West” town, with all the amenities of present-day Michigan. Common areas are professionally maintained by resort staff. All resort services are available including: shuttle rides, housekeeping, catering services, property and rental management. Available ranch amenities include: renowned Thoroughbred Golf Course, horseback trail rides, Gold Rush Indoor Waterpark, Back Forty Water Park, dog sledding, snow tubing, sleigh rides, rodeo, haunted trails, conference rooms, and more! Perfect location, just 3 hours from Detroit or Chicago and minutes from the sandy shores of Lake Michigan.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources.
Home Highlights
Parking
No Info
Outdoor
No Info
HOA
None
Price/Sqft
No Info
Listed
Less than a day ago
Home Details for 5900 Water Rd
|
|---|
Property Type / Style Property Type: Unknown |
Price History for 5900 Water Rd
| Date | Price | Event | Source |
|---|---|---|---|
| 03/17/2021 | $57,500 | Sold | N/A |
| 06/08/2018 | $53,900 | Sold | N/A |
| 04/27/2011 | $45,000 | Sold | N/A |
Market trends in New Era
Last updated April 2026
Avg. sale price
—
Sale-to-List Price
—
Price per sq ft
—
Available listings
—
- Results are loading
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $2,361 |
| Assessment | $102,400 |
Home facts updated by county records
Homeowner tools
Estimated monthly rent$1,204/mo
Comparable Sales for 5900 Water Rd
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.45 | Single-Family Home | $115,000 | 11/03/25 | 3 | 1 | 864 | |
0.48 | Single-Family Home | $30,000 | 04/14/26 | - | - | ||
0.48 | Single-Family Home | $5,100 | 08/26/25 | - | - | ||
0.74 | Single-Family Home | $140,000 | 08/08/25 | 3 | 1 | 1,074 | |
0.82 | Single-Family Home | $30,000 | 08/06/25 | - | - | ||
0.70 | Single-Family Home | $186,000 | 07/21/25 | 2 | 1 | 1,100 | |
0.84 | Single-Family Home | $154,500 | 06/27/25 | 4 | 2 | 2,115 | |
1.07 | Single-Family Home | $110,000 | 01/20/26 | 3 | 1 | 1,434 | |
1.02 | Single-Family Home | $160,000 | 09/29/25 | 4 | 2 | 1,700 | |
1.36 | Single-Family Home | $60,000 | 04/13/26 | 2 | 1 | 1,071 |
Nearby homes
Get a sense of prices in the area by checking nearby homes.
OFF MARKETBerkshire Hathaway HomeServices Kee Realty Browns
OFF MARKETColdwell Banker Woodland Schmidt Whitehall
OFF MARKETCore Realty Partners LLC
OFF MARKETHanson Real Estate Group
SOLDJAN 2, 2026Keller Williams Ann Arbor Mrkt
OFF MARKETFive Star Real Estate - Hart
Assigned Schools
These are the assigned schools for 5900 Water Rd.
- Shelby High School
- 9-12
- Public
- 355 Students
6/10GreatSchools RatingParent Rating AverageThe teachers/staff are highly involved and work very hard to help every student meet their potential. As a student I've learned not to think on a strictly black or white scale and that the world is only as big as you want it to be. The teachers here are highly educated (for the most part) and it shows. Although I did not attend sports as an athlete here, the coaches have instilled great values on the athletes. The architecture is very open although the colors are slightly... off (the decorator was colorblind). Shelby works very hard on being sure the art program is funded and even when funding is low, the school has always been determined to keep as many opportunities open as possible. (Shelby attends the One Act Festival in MCC every year)Student Review11y ago - Shelby Middle School
- 6-8
- Public
- 246 Students
7/10GreatSchools RatingParent Rating AverageThe food does not taste very good.Parent Review5y ago - Thomas Read Elementary School
- K-5
- Public
- 445 Students
4/10GreatSchools RatingParent Rating AverageShelby has under gone some serious curriculum changes in the last couple of years and I can see the difference in my child's academics! He loves to go to school and loves being a Shelby Tiger! I am sad that he won't be there next year as the school only goes until 3rd grade. Loving caring teachers and Principal-really like a school family!!!Parent Review9y ago 
Check out schools near 5900 Water Rd.
What Locals Say about New Era
At least 1 Trulia users voted on each feature.
100 % Say people would walk alone at night
100 % Say there's wildlife
100 % Say car is needed
100 % Say it's dog friendly
100 % Say yards are well-kept
100 % Say it's quiet
83 % Say parking is easy
75 % Say kids play outside
67 % Say it's walkable to restaurants
67 % Say there's holiday spirit
58 % Say neighbors are friendly
50 % Say streets are well-lit
50 % Say they plan to stay for at least 5 years
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Apartments for Rent
- Results are loading
Homes for sale near 5900 Water Rd
AUCTION0.51 ACRES
FOR SALE BY OWNER1 ACRE
0.28 ACRESFive Star Real Estate - Hart
NEW - 2 DAYS AGO0.73 ACRESColdwell Banker Woodland Schmidt Grand Haven
See more homes for sale inRothbury
Off Market Homes Near 5900 Water Rd
SOLDJUN 1, 2026Five Star Real Estate Whitehall
SOLDMAY 18, 2026Five Star Real Estate - Town Square Group
SOLDMAY 15, 2026Allen Edwin Realty LLC
SOLDMAY 7, 2026Five Star Real Estate Whitehall
SOLDMAY 1, 2026Five Star Real Estate Fremont- See more homes for sale inRothbury
5900 Water Rd, Rothbury, MI 49452 is a unknown. This property is not currently available for sale. 5900 Water Rd was last sold on Mar 17, 2021 for $57,500.