Welcome to 4154 S Sunset Drive, uniquely positioned on Water's Edge Golf Course with beautiful views of Third Lake and a peaceful setting on 1.39 acres. This spacious 5 bedroom, 3 full bathroom home features an open floor plan, soaring cathedral ceilings and oversized windows that fill the home with natural light and showcase the scenic surroundings. The walkout lower level offers flexible living space for guests, entertaining or everyday living. Outside, enjoy an 18x38 above ground pool with surrounding deck, hot tub included, 3 stall attached garage, generator hookup, and deeded access to Third Lake. Recent updates include furnace in 2019 plus water heater, bedroom windows, septic pump and well bladder in 2023. Currently operating as a successful Airbnb with approximately $26,000 in bookings this year and reservations already in place. A rare Fremont opportunity with golf course frontage, peaceful water views and income potential.
Active
Price cut: $40.1K (7/20)
$499,900
4154 S Sunset Dr, Fremont, MI 49412
5beds
3,116sqft
Single Family Residence
Built in 1987
1.39 Acres Lot
$491,700 Zestimate®
$160/sqft
$-- HOA
What's special
Open floor planSoaring cathedral ceilingsGenerator hookupHot tub included
- 95 days
- 1,736
- 58
Zillow last checked:
Listing updated:
Listed by:
Amanda Patterson 231-724-0869,
Five Star Real Estate 231-733-3080
Source: MichRIC,MLS#: 26025060
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
- Main level bedrooms: 3
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Oven, Refrigerator, Washer, Water Softener Owned
- Laundry: In Hall, Laundry Room, Main Level
Features
- Ceiling Fan(s), Center Island, Eat-in Kitchen, Pantry
- Flooring: Carpet, Tile, Wood
- Windows: Screens, Insulated Windows
- Basement: Daylight,Full,Walk-Out Access
- Has fireplace: No
- Fireplace features: Living Room
Interior area
- Total structure area: 1,795
- Total interior livable area: 3,116 sqft
- Finished area below ground: 1,322
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Garage Faces Front, Garage Door Opener, Attached
- Garage spaces: 3
Features
- Stories: 1
- Exterior features: Balcony
- Has private pool: Yes
- Pool features: Above Ground
- Has spa: Yes
- Spa features: Hot Tub Spa
- Waterfront features: Lake
- Body of water: Third Lake
Lot
- Size: 1.39 Acres
- Dimensions: 255 x 322 x 255 x 240
- Features: Cul-De-Sac, Shrubs/Hedges
Details
- Parcel number: 1336236018
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Chalet
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Roof: Composition
Condition
- New construction: No
- Year built: 1987
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smoke Detector(s)
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $160/sqft
- Tax assessed value: $145,549
- Annual tax amount: $4,640
- Date on market: 7/12/2026
- Listing terms: Cash,FHA,VA Loan,MSHDA,Conventional
- Road surface type: Paved
Estimated market value
$491,700
$467,000 - $516,000
$2,948/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/20/2026 | Price change | $499,900-7.4%$160/sqft |
Source: | ||
| 7/12/2026 | Listed for sale | $540,000$173/sqft |
Source: | ||
| 6/5/2026 | Pending sale | $540,000$173/sqft |
Source: | ||
| 5/27/2026 | Listed for sale | $540,000-3.6%$173/sqft |
Source: | ||
| 5/2/2026 | Listing removed | $560,000$180/sqft |
Source: | ||
| 3/31/2026 | Price change | $560,000-6.5%$180/sqft |
Source: | ||
| 2/25/2026 | Price change | $599,000-9.6%$192/sqft |
Source: | ||
| 1/30/2026 | Pending sale | $662,400$213/sqft |
Source: | ||
| 11/27/2025 | Price change | $662,400-4%$213/sqft |
Source: | ||
| 10/22/2025 | Listed for sale | $690,000+176%$221/sqft |
Source: | ||
| 4/4/2018 | Sold | $250,000$80/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,640 +3.9% | $182,800 +8.4% |
| 2024 | $4,468 +57.1% | $168,600 +32.7% |
| 2023 | $2,844 -31.9% | $127,100 +5.3% |
| 2022 | $4,177 +1.7% | $120,700 |
| 2021 | $4,108 +200.3% | $120,700 |
| 2020 | $1,368 | $120,700 +2.7% |
| 2019 | -- | $117,500 +14.3% |
| 2018 | -- | $102,800 -0.5% |
| 2017 | -- | $103,300 +1% |
| 2016 | -- | $102,300 +0.5% |
| 2015 | -- | $101,800 -2.6% |
| 2014 | -- | $104,500 +0.4% |
| 2013 | -- | $104,100 +1.6% |
| 2012 | -- | $102,500 -4.7% |
| 2010 | -- | $107,600 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 49412
Nearby schools
Schools provided by the listing agent
- Elementary: Daisy Brook Elementary School
- Middle: Fremont Middle School
- High: Fremont High School
Source: MichRIC. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.







