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

Jenn Smart

| SEO pages, v2 chat

Agent profile image in message

W11012 460th Avenue , Prescott, WI 54021
$1,298,750
Est. Payment: $6,749.99/mo
3 Bed
5 Bath
4842 Sqft
Status: Active | Days on site: 9
Get Pre-Qualified
8205 - 506001133,892010090
By proceeding you are providing Jenn Smart with your express written consent to send you marketing and promotional communications via calls or prerecorded messages dialed by a natural person or by using an artificial or automated telephone dialing system.

By checking the box, you consent to receive marketing text messages. If checked, you consent to receiving texts including marketing and promotional communications, from Jenn Smart. Messages and data rates may apply. Message frequency varies. 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 & Conditions and Privacy Policy.

House Description

OFFER FELL THRU putting this beauty back on the market! Extraordinary residence in sought-after Trumpeter Valley—available due to relocation. Perfectly positioned for exceptional privacy, this stunning home is nestled on 5.9 beautifully landscaped acres that showcase the natural beauty of the surrounding setting. Thoughtfully designed with both elegance and comfort in mind, the home features an open-concept layout enhanced by the rich warmth of Alder wood throughout. A spacious foyer welcomes you into the impressive vaulted Great Room, where expansive windows bring the outdoors in and create a seamless connection to nature. The gourmet kitchen is truly a chef’s dream, offering new quartz countertops, a large center island, high-end appliances, and a well-appointed butler’s pantry. The adjoining dining area is bright and airy, highlighted by oversized windows and access to a screened porch—perfect for relaxing and enjoying the peaceful, private surroundings. A warm and inviting office with custom built-ins provides the ideal work-from-home space. The luxurious primary suite features its own fireplace for added ambiance, along with a spacious private bath designed for comfort and retreat. An open staircase with custom ironwork leads to the expansive lower level, where you’ll find a beautifully designed wet bar with custom cabinetry and ambient lighting. The walkout family room features a stunning fireplace and access to the outdoors, while the recreation room—open to a dedicated workout area—is ideal for entertaining and everyday living. Two additional bedrooms and two baths complete this level. Car enthusiasts and hobbyists will appreciate the finished and heated 4-car attached garage, as well as the separate finished and heated 2-car detached garage. Trumpeter Valley offers a truly unique lifestyle, featuring 288 acres of preserved natural beauty and approximately 9 miles of groomed trails—exclusively available to residents. This exceptional property is a rare opportunity and truly a must-see.

Highlights

Listed by Carol Toner , 612-414-5050 and Michael Olson , 612-384-7666 Coldwell Banker Realty , 651-738-9262. Minneapolis/St. Paul and St. Cloud - Northstar MLS

Property Type

Residential

Lot/Acreage
5.92

HOA Fee

315 Annually

Year Built

2011

County

Pierce

Neighborhood

Trumpeter Valley

School District

Prescott

Listing ID

7136629

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:3
  • Bathrooms:5
  • Full Bathrooms:2
  • 3/4 Bathrooms:1
  • 1/2 Bathrooms:2
Appliances:Air-To-Air Exchanger, Cooktop, Dishwasher, Dryer, Electric Water Heater, Exhaust Fan, Fuel Tank - Rented, Microwave, Refrigerator, Stainless Steel Appliances, Wall Oven, Water Softener Owned
Air Cond:Central Air
Fireplaces:Family Room,Gas,Living Room,Primary Bedroom
Above Ground Sq Ft:2483
Below Ground Sq Ft:2359
Basement:Drain Tiled,Finished,Full,Sump Pump,Walkout
Other:
  • Additional:Ceiling Fan(s), Exercise Room, Hardwood Floors, Kitchen Center Island, Kitchen Window, Primary Bedroom Walk-In Closet, Main Floor Primary Bedroom, Natural Woodwork, Paneled Doors, Porch, Security System, In-Ground Sprinkler, Tile Floors, Vaulted Ceiling(s), Washer/Dryer Hookup, Wet Bar, Walk-In Closet, Two Basement Baths, 3/4 Basement, 3/4 Primary, Bathroom Ensuite, Full Basement, Private Primary, Main Floor 1/2 Bath, Main Floor Full Bath, Separate Tub & Shower, Walk-In Shower Stall, Informal Dining Room, Separate/Formal Dining Room, All Living Facilities on One Level, Main Floor Primary, Main Floor Bedroom, Main Floor Laundry
Water:Drilled,Well

Exterior Features

Lot:Irregular Lot,Tree Coverage - Medium
Lot Dimensions:29x903x376x329x624
Zoning:Residential-Single Family
Roof:Asphalt,Pitched
Sewer:Mound Septic
Parking Features:Attached Garage,Detached Garage,Asphalt,Concrete,Heated Garage,Insulated Garage
Principal Interest
$6,750
Taxes
$1,206
HOA
$315

Home Price

$1,298,750

Loan Details

30 yrs
6.766%

Down Payment

20%
$259,750
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:
$6,749.99

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $6,749.99 $1,206.17 $315.00 $8,271.15
Yearly $80,999.86 $14,474.00 $3,780.00 $99,253.86
Total $2,429,995.78 $434,220.00 $113,400.00 $2,977,615.78
Lender profile image
So-Crates Johnson
Dust, Wind, Dude
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
Sep 2026

Average Price

All Price Ranges
N/A
Sep 2026

Average Days on Market

All Price Ranges
N/A
Sep 2026
Market insight data is pulled from the same city as the listing being viewed (Prescott, 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 SEO pages, v2 chat 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-09-10T11:04:07.000Z

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