Skip to Navigation

Search Thousands of Properties in Greater Minnesota & Western Wisconsin.

Property Details

4747 140th Avenue NE
Ham Lake, MN 55304

Price: $2,989,000

Listing # 7007993


Contact Agent

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 five-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.

Basic Features:

Style Single Family Residence
Type Residential
Zoning Residential-Single Family
Year Built 2026
School District Anoka-Hennepin
County Anoka
Lot Size XXX
Acreage 1.55 acres
Bedrooms 5
Total Baths 6
Garage 6 Car IRR
Lot Description Sod Included in Price,Tree Coverage - Medium
Above Grade 4,839 sq ft
Below Grade 2,559 sq ft
Tax $ / Year $2,000 / 2026
Tax ID
Legal Description

Includes:

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

Rooms Size Level
Athletic Court 27x21 L
Bedroom 19x16 U
Bedroom 2 13x12 U
Bedroom 3 13x12 U
Bedroom 4 13x12 U
Bedroom 5 14x17 L
Bonus Room 18x16 U
Dining Room 15x11 M
Exercise Room 17x13 L
Family Room 19x19 L
Kitchen 19x13 M
Living Room 20x19 M
Study 12x11 M
Sun Room 18x20 M
Additional Features
Government Programs
Terrain Type
Roads City Street
Baths 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 ...
Basement Drain Tiled,Finished,Concrete,Sump Pump,Tile Shower,Walkout
Cooling Central Air
Driveway
Electric Circuit Breakers,200+ Amp Service
Fireplace Gas,Living Room
Foundation 2807.00
Fuel Source Natural Gas
Handicap Access None
Heating Forced Air
New Construction 1
Pool Below Ground,Heated,Outdoor,Shared
Roof Age 8 Years or Less,Asphalt,Pitched
Sewer Service Private Sewer
Water Service Well
Water Heater
Parking Lot Attached Garage,Asphalt,Electric Vehicle Charging Station(s),Floor Drain,Finished Garage,Garage Door Opener,Heated Garage,Insulated Garage
Exterior Construction
Fencing None
Laundry E

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 Coldwell Banker Nybo & Associates are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers.

DISCLAIMER: The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. This data is updated daily. Some properties which appear for sale on this web site may subsequently have sold and may no longer be available. By viewing these listings, you are agreeing to abide by the RMLS End-User License Agreement.

© 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.

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.