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

4747 140th Ln NE , Ham Lake, MN 55304
$2,989,000
Est. Payment: $14,943.01/mo
5 Bed
6 Bath
7398 Sqft
Status: active with contingency | Days on site: 190
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275

By providing your number, you are expressly consenting, in writing, to receive telemarketing and other messages, including calls or texts at the number you provided above. This consent is not required to purchase any good or service. Message and data rates may apply. Text STOP to cancel.

This site is protected by reCAPTCHA and the GooglePrivacy Policy and Terms of Service apply.

House Description

Elwell Farms is an exclusive, master planned enclave spanning 515 pristine acres and bordering the protected beauty of the Carlos Avery Wildlife Management Area. With 106 acreage homesites, this distinguished community offers privacy, serenity, and an exceptional standard of luxury living. Hanson Builders presents 15 premier homesites in Phase 1, many showcasing picturesque wooded settings and tranquil pond views. The STONEHAVEN, to be featured in the 2026 Fall Artisan Home Tour, exemplifies sophisticated design and superior craftsmanship. The main level is both grand and inviting, offering an open concept layout enhanced by floor-to-ceiling black Marvin windows, 10' ceilings, and custom beams and architectural detailing throughout. The chef’s kitchen is a statement of both form and function, featuring a substantial center island, exterior-wall sink, professional-grade range, and an elegant walk-through prep pantry. A vaulted hearth room with a striking stone-to-ceiling fireplace creates a dramatic yet welcoming focal point. The upper level hosts four generously sized bedrooms and a bonus room/theater, including a private owner’s retreat with dual walk-in closets. Secondary bedrooms are thoughtfully designed with bespoke features such as Buddy Bunks, a Princess Alcove, and private en-suite baths. The fully finished lower level elevates entertaining with a sport court, golf simulator with viewing area, stylish wet bar, and an additional bedroom. A heated six-car garage with floor drains and a dedicated man cave completes this exceptional residence. Life at Elwell Farms is enhanced by resort-inspired community amenities, including a pool and clubhouse, playground with picnic pavilion, pickleball courts, fishing pier, and miles of scenic walking trails. Elwell Farms offers a rare opportunity to enjoy refined luxury in a truly extraordinary natural setting.

Highlights

Listed by Lucas K Hanson , 763-360-9942 and Jenna Pietrzak , 763-913-9607 Edina Realty, Inc. , 763-420-2424. Minneapolis/St. Paul and St. Cloud - Northstar MLS

Property Type

Residential

Lot/Acreage
1.55

HOA Fee

100 Monthly

Year Built

2026

County

Anoka

Area

Elwell Farms

Neighborhood

Elwell Farms

School District

Anoka-Hennepin

Listing ID

7007993

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:5
  • Bathrooms:6
  • Full Bathrooms:2
  • 3/4 Bathrooms:3
  • 1/2 Bathrooms:1
Appliances:Air-To-Air Exchanger, Cooktop, Dishwasher, Disposal, Dryer, Exhaust Fan, Gas Water Heater, Water Filtration System, Microwave, Range, Refrigerator, Stainless Steel Appliances, Washer, Water Softener Owned, Wine Cooler
Air Cond:Central Air
Fireplaces:Gas,Living Room
Above Ground Sq Ft:4839
Below Ground Sq Ft:2559
Basement:Drain Tiled,Finished,Concrete,Sump Pump,Tile Shower,Walkout
Other:Deck,Exercise Room,French Doors,Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Natural Woodwork,Patio,Paneled Doors,Security System,In-Ground Sprinkler,Sun Room,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Wet Bar,Walk-In Closet,3/4 Basement,Basement,Bathroom Ensuite,Full Primary,Private Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Upper Level 3/4 Bath,Upper Level Full Bath,Primary Walk-Thru,Walk-In Shower Stall,Walk Thru,Separate/Formal Dining Room,2nd Floor Laundry,4 BR on One Level,Primary Bdr Suite
Other:Well

Exterior Features

Lot:Sod Included in Price,Tree Coverage - Medium
Lot Dimensions:XXX
Zoning:Residential-Single Family
Roof:Age 8 Years or Less,Asphalt,Pitched
Sewer:Private Sewer
Parking Features:Attached Garage,Asphalt,Electric Vehicle Charging Station(s),Floor Drain,Finished Garage,Garage Door Opener,Heated Garage,Insulated Garage
Principal Interest
$14,943
Taxes
$167
HOA
$100

Home Price

$2,989,000

Loan Details

30 yrs
6.391%

Down Payment

20%
$597,800
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:
$14,943.01

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $14,943.01 $166.67 $100.00 $15,209.68
Yearly $179,316.11 $2,000.00 $1,200.00 $182,516.11
Total $5,379,483.24 $60,000.00 $36,000.00 $5,475,483.24
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
Jul 2026

Average Price

All Price Ranges
N/A
Jul 2026

Average Days on Market

All Price Ranges
N/A
Jul 2026
Market insight data is pulled from the same city as the listing being viewed (Ham Lake, MN).

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-07-23T00:16:07.000Z

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