Skip main navigation
Active
  • $540,000

    4154 S Sunset Dr, Fremont, MI 49412

    5beds
    3,116sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1987
    1.39 Acres Lot
    $526,900 Zestimate®
    $173/sqft
    $-- HOA

    What's special

    Open floor planSoaring cathedral ceilingsGenerator hookupHot tub included
    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.
    46 days
    |
    143
    |
    4
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Amanda Patterson 231-724-0869,

    Five Star Real Estate 231-733-3080

    Source: MichRIC,MLS#: 26025060MLS Logo

      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: $173/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

        $526,900

        $501,000 - $553,000

        $3,106/mo

        Price history

        DateEventPrice
        7/12/2026Listed for sale$540,000$173/sqft
        Source: MichRIC #26025060 Report a problem
        6/5/2026Pending sale$540,000$173/sqft
        Source: MichRIC #26025060 Report a problem
        5/27/2026Listed for sale$540,000-3.6%$173/sqft
        Source: MichRIC #26025060 Report a problem
        5/2/2026Listing removed$560,000$180/sqft
        Source: MichRIC #25054302 Report a problem
        3/31/2026Price change$560,000-6.5%$180/sqft
        Source: MichRIC #25054302 Report a problem
        2/25/2026Price change$599,000-9.6%$192/sqft
        Source: MichRIC #25054302 Report a problem
        1/30/2026Pending sale$662,400$213/sqft
        Source: MichRIC #25054302 Report a problem
        11/27/2025Price change$662,400-4%$213/sqft
        Source: MichRIC #25054302 Report a problem
        10/22/2025Listed for sale$690,000+176%$221/sqft
        Source: MichRIC #25054302 Report a problem
        4/4/2018Sold$250,000$80/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax 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.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 49412

        Getting around

        12 / 100
        Car-Dependent
        21 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        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.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes