Agent profile image in chat bubble
Agent profile image in chat header

Hatch Brokered by Real

| Hatch Brokered by Real | Real Brokerage LLC | PLACE

Agent profile image in message

400 Hill Ave , Star Prairie, WI 54026
$949,900
Est. Payment: $4,865.85/mo
3 Bed
4 Bath
2885 Sqft
Status: active | Days on site: 153
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from Hatch Brokered by Real, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

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.

Highlights

Listed by Melissa Wiegele , 651-403-0184 Coldwell Banker Realty , 715-386-9060. Minneapolis/St. Paul and St. Cloud - Northstar MLS

Property Type

Residential

Lot/Acreage
26.42

Year Built

1915

County

St. Croix

School District

New Richmond

Listing ID

7032444

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:3
  • Bathrooms:4
  • Full Bathrooms:3
  • 3/4 Bathrooms:1
Appliances:Refrigerator
Air Cond:Central Air
Fireplaces:Wood Burning,Wood Burning Stove
Above Ground Sq Ft:2885
Below Ground Sq Ft:0
Basement:Block,Full,Sump Basket,Sump Pump,Walkout
Other:
  • Additional:Deck, Hardwood Floors, Kitchen Window, Main Floor Primary Bedroom, Natural Woodwork, Porch, Panoramic View, Washer/Dryer Hookup, Main Floor 3/4 Bath, Main Floor Full Bath, Upper Level Full Bath, Kitchen/Dining Room, Divided Bdr Flr Plan, Main Floor Bedroom
Water:Private

Exterior Features

Lot:River Front,Additional Land Available,Accessible Shoreline,Irregular Lot,Property Adjoins Public Land,Tree Coverage - Medium,Chain Link,Wood,Waterfront
Lot Dimensions:Irregular
Zoning:Agriculture,Other,Shoreline
Roof:Asphalt
Sewer:Private Sewer
Parking Features:Detached Garage,Gravel,Finished Garage,Heated Garage,Insulated Garage,Multiple Garages,Storage
Principal Interest
$4,866
Taxes
$561

Home Price

$949,900

Loan Details

30 yrs
6.625%

Down Payment

20%
$189,980
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$4,865.85

Principal

Taxes

Principal Taxes HOA Total
Monthly $4,865.85 $560.50 $0.00 $5,426.35
Yearly $58,390.21 $6,726.00 $0.00 $65,116.21
Total $1,751,706.38 $201,780.00 $0.00 $1,953,486.38
Lender profile image
Will Provost
Loan Originator
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Aug 2026

Average Price

All Price Ranges
N/A
Aug 2026

Average Days on Market

All Price Ranges
N/A
Aug 2026
Market insight data is pulled from the same city as the listing being viewed (Star Prairie, WI).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than Hatch Brokered by Real | Real Brokerage LLC | PLACE are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers.
Digital Millennium Copyright Act (DMCA) Notice The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to Michael Bisping, Director, Customer Relations, Regional Multiple Listing Service of Minnesota, Inc, 2550 University Avenue West, Suite 259S Saint Paul, MN 55114 or by email to mbisping@northstarmls.com. Questions can be directed by phone to 651-251-3200.The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Information Deemed Reliable but not guaranteed.
Copyright 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.
Broker Reciprocity

IDX service by Blueroof 360

Data last updated: 2026-08-25T00:48:07.000Z

© 2026 Minneapolis/St. Paul and St. Cloud - Northstar MLS