Skip main navigation
Active
    • Price cut: $49.6K (5/28)
    $949,900

    400 Hill Ave, Star Prairie, WI 54026

    3beds
    2,885sqft
    : 
    Loading
    Get pre-qualified
    Single Family
    Built in 1915
    26.42 Acres Lot
    $895,800 Zestimate®
    $329/sqft
    $-- HOA

    What's special

    Existing two story homeDedicated workshopBreathtaking river frontage
    Introducing the one you’ve been waiting for—the historic Star Prairie Trout Farm, now available and ready for its next chapter. Set on an incredible stretch of the Apple River with approximately 1,000+ feet of frontage, this truly one of a kind property offers unmatched natural beauty and endless potential. Whether you’re dreaming of a private retreat, hobby farm, or something entirely unique, the opportunity here is rare. The property is currently zoned Conservancy and Agricultural, with the ability to rebuild on the existing footprint, allowing a future owner to create a stunning riverside residence in an unforgettable setting. The existing two story home features 3 bedrooms with the potential for a fourth, and while it requires a full remodel, the bones and location offer an exceptional canvas. Imagine waking up to river views from every bedroom and enjoying peaceful mornings on the screened in porch overlooking the water. In addition to the main home, the property includes a guest home with 1 bedroom and full living quarters, perfect for extended family, guests, or additional income potential. The outbuildings are just as impressive, with a total of five detached garage stalls providing ample storage for vehicles, equipment, or recreational toys. A dedicated workshop adds even more functionality, while one heated outbuilding still houses a commercial freezer, smoker, plumbing, and commercial sinks, opening the door to a variety of creative or business uses. Properties like this don’t come around often. With its rich history, breathtaking river frontage, and limitless possibilities, the Star Prairie Trout Farm is truly something you have to see to believe.
    111 days
    |
    974
    |
    25
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Melissa Wiegele 651-403-0184,

    Coldwell Banker Realty

    Source: NorthstarMLS as distributed by MLS GRID,MLS#: 7032444MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 4
      • Full bathrooms: 3
      • 3/4 bathrooms: 1
      Bedroom
      • Level: Upper
      • Area: 385.28 Square Feet
      • Dimensions: 22.4x17.2
      Bedroom 2
      • Level: Main
      • Area: 160.93 Square Feet
      • Dimensions: 12.1x13.3
      Bedroom 3
      • Level: Main
      • Area: 186.12 Square Feet
      • Dimensions: 14.1x13.2
      Dining room
      • Level: Main
      • Area: 117.66 Square Feet
      • Dimensions: 11.1 x 10.6
      Kitchen
      • Level: Main
      • Area: 194.34 Square Feet
      • Dimensions: 15.8x12.3
      Living room
      • Level: Main
      • Area: 413.28 Square Feet
      • Dimensions: 28.7 x 14.4
      Loft
      • Level: Upper
      • Area: 296.05 Square Feet
      • Dimensions: 15.5x19.10
      Office
      • Level: Main
      • Area: 273.31 Square Feet
      • Dimensions: 18.1 x 15.10
      Other
      • Level: Main
      • Area: 238 Square Feet
      • Dimensions: 17x14
      Heating
      • Forced Air, Fireplace(s)
      Cooling
      • Central Air
      Appliances
      • Included: Refrigerator
      • Laundry: In Basement, Electric Dryer Hookup, Washer Hookup
      Features
      • Basement: Block,Full,Sump Basket,Sump Pump,Walk-Out Access
      • Number of fireplaces: 2
      • Fireplace features: Wood Burning, Wood Burning Stove
      Interior area
      • Total structure area: 4,015
      • Total interior livable area: 2,885 sqft
      • Finished area above ground: 2,885
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 5
      • Parking features: Detached Garage, Gravel, Garage, Heated Garage, Insulated Garage, Multiple Garages, Storage
      • Garage spaces: 5
      • Details: Garage Door Height (7), Garage Door Width (16)
      Accessibility
      • Accessibility features: None
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Deck, Enclosed, Screened, Side Porch
      • Pool features: None
      • Fencing: Chain Link,Wood
      • Has view: Yes
      • View description: North, Panoramic, River
      • Has water view: Yes
      • Water view: River
      • Waterfront features: River Front, Waterfront Elevation(4-10), Lake Bottom(Gravel, Sand, Excellent Sand)
      • Frontage length: Water Frontage: 1069
      Lot
      • Size: 26.42 Acres
      • Features: Additional Land Available, Accessible Shoreline, Irregular Lot, Property Adjoins Public Land, Tree Coverage - Medium
      • Topography: Flood Plain,Level
      Details
      • Additional structures: Garage(s), Second Residence, Workshop, Storage Shed
      • Foundation area: 1130
      • Parcel number: 182102695000
      • Zoning description: Agriculture,Other,Shoreline

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family
      Materials
      • Block, Frame
      • Roof: Asphalt
      Condition
      • New construction: No
      • Year built: 1915

      Utilities & green energy

      • Electric: Circuit Breakers
      • Gas: Natural Gas
      • Sewer: Private Sewer
      • Water: Private

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Star Prairie

      Financial & listing details

      • Price per square foot: $329/sqft
      • Tax assessed value: $560,200
      • Annual tax amount: $6,726
      • Date on market: 3/24/2026
      • Road surface type: Paved

        Estimated market value

        $895,800

        $851,000 - $941,000

        $2,730/mo

        Price history

        DateEventPrice
        5/28/2026Price change$949,900-5%$329/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7032444 Report a problem
        3/24/2026Listed for sale$999,500$346/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7032444 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$7,559 +12%$410,500 +0%
        2024$6,750 +5.3%$410,400
        2023$6,411 +12.1%$410,400 +0%
        2022$5,719 -38.9%$410,200 +2.6%
        2021$9,357 +8.2%$399,700 -0.1%
        2020$8,650 -12.1%$399,900
        2019$9,840 +6.3%$399,900
        2018$9,253 +9.4%$399,900
        2017$8,456 +1.4%$399,900
        2016$8,342 +3.6%$399,900
        2015$8,053 +1.1%$399,900
        2014$7,963 +0.5%$399,900
        2013$7,924 -8.1%$399,900
        2012$8,627 +23.9%$399,900 +14.9%
        2011$6,961 -2.5%$347,900
        2010$7,141 +8.5%$347,900 +4.9%
        2009$6,579 +0.3%$331,600
        2008$6,556 -0.5%$331,600 +0%
        2007$6,591 +11%$331,500
        2006$5,939 +4%$331,500
        2005$5,709 $331,500
        2004-- $331,500
        2003$5,799 $331,500 +13.3%
        2002-- $292,700
        2001-- $292,700
        2000-- $292,700
        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.
        Get pre-qualified

        Climate risks

        Neighborhood: 54026

        Getting around

        17 / 100
        Car-Dependent
        29 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other New Richmond Topics

                Search
                Updates
                Favorites
                Plan
                Inbox