4154 S Sunset Dr, Fremont, MI, 49412
About This Home
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.
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- Year built: 1987
Materials
- Roof: Composition
- Construction materials: Wood Siding
Type & Style
- Home type: SingleFamily
- Architectural style: Chalet
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Dishwasher,Dryer,Microwave,Oven,Refrigerator,Washer,Water Softener Owned
- Laundry features: In Hall,Laundry Room,Main Level
Basement
- Has basement: Yes
- Basement: Daylight,Full,Walk-Out Access
Bedrooms & Bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
- Main level bedrooms: 3
Features
- Ceiling Fan(s),Center Island,Eat-in Kitchen,Pantry
- Window features: Screens,Insulated Windows
- Flooring: Carpet,Tile,Wood
- Fireplace features: Living Room
- Finished area below ground: 1,322
Heating & Cooling
- Heating features: Forced Air
- Cooling features: Central Air
Interior Area
- Total structure area: 1,795
- Total interior livable area: 3,116 sqft
Property
Details
- Parcel number: 1336236018
- Zoning description: Residential
Features
- Stories: 1
- Private pool: Yes
- Pool features: Above Ground
- Exterior features: Balcony
- Has spa: Yes
- Spa features: Hot Tub Spa
- Waterfront features: Lake
- Waterbody name: Third Lake
Lot
- Lot size: 1.39 Acres
- Features: Cul-De-Sac,Shrubs/Hedges
- Lot size dimensions: 255 x 322 x 255 x 240
Parking
- Total spaces: 3
- Parking features: Garage Faces Front,Garage Door Opener,Attached
- Has garage: Yes
- Attached garage spaces: 3
- Covered spaces: 3
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Strong Wind
- Winter Weather
- Cold Wave
- Inland Flooding
- Ice Storm
- Lightning
- Tornado
How This Home’s Risks Compare
FEMA Declared Disasters in Newaygo County and Michigan
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $2,527 | $30,324 |
| Home Insurance * | $282 | $3,384 |
| Property Taxes | $408 | $4,896 |
| Electricity | $339 | $4,078 |
| Total | $3,556 | $42,672 |
Income You'd Need if You Spent...
Michigan FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-07-20 | Price change | $499,900 |
| 2026-07-12 | Listed for sale | $540,000 |
| 2026-06-05 | Pending sale | $540,000 |
| 2026-05-27 | Listed for sale | $540,000 |
| 2026-05-02 | Listing removed | $560,000 |
| 2026-03-31 | Price change | $560,000 |
| 2026-02-25 | Price change | $599,000 |
| 2026-01-30 | Pending sale | $662,400 |
| 2025-11-27 | Price change | $662,400 |
| 2025-10-22 | Listed for sale | $690,000 |
| 2018-04-04 | Sold | $250,000 |
View on Zillow