Find Your Dream Home: Search 10,000+ Homes for Sale

4747 140th Avenue NE, Ham Lake, MN 55304

$2,989,000

Welcome to Hanson Builders Stonehaven in Elwell Farms!

Elwell Farms Community Pool and Clubhouse

Property Type: Residential Bedrooms: 5 Baths: 6 Square Footage: 7,646 Lot Size (sq. ft.): 67,518 Status: Active

Current Price: $2,989,000 List Date: 1/13/2026 Last Modified: 5/27/2026

Overview

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 cr ... (Read more)

Listing Details MLS# 7007993

General Property Information

Assoc Mgmt Co. Phone #: 763-421-5435
Association Fee Frequency: Monthly
Association Mgmt Co. Name: TBD
Common Wall: No
Lot Measurement: Acres
Manufactured Home?: No
Multiple PIDs?: No
New Development: Yes
Number of Fireplaces: 2
Projected Completion Date: 2026-10-01
Year Built: 2026
Yearly/Seasonal: Yearly
Zoning: Residential-Single Family
Bath Full: 2
Bath Three Quarters: 3
Bath Half: Yes
Main Floor Total SqFt: 2255
Above Grd Total SqFt: 4839
Below Grd Total SqFt: 2807
Total SqFt: 7646
Total Finished Sqft: 7398.00
FireplaceYN: Yes
Style: (SF) Single Family
Foundation Size: 2807
Association Fee: 100
Garage Stalls: 6
Lot Dimensions: XXX
Acres: 1.55
Assessment Pending: Unknown
Bath Quarter: 0

Property Features

Accessible: None Air Conditioning: Central Air Amenities Unit: Deck; Exercise Room; French Doors; Hardwood Floors; In-Ground Sprinkler; Kitchen Center Island; Kitchen Window; Natural Woodwork; Paneled Doors; Patio; Primary Bedroom Walk-In Closet; Security System; Sun Room; Tile Floors; Vaulted Ceiling(s); Walk-In Closet; Washer/Dryer Hookup; Wet Bar Appliances: Air-To-Air Exchanger; Cooktop; Dishwasher; Disposal; Dryer; Microwave; Range; Refrigerator; Washer; Water Filtration System; Wine Cooler Association Fee Includes: Professional Mgmt; Shared Amenities Assumable Loan: Not Assumable Basement: Drain Tiled; Sump Pump; Tile Shower Bath Description: Primary Walk-Thru; Main Floor 1/2 Bath; Upper Level 3/4 Bath; Upper Level Full Bath; Full Primary; Private Primary; 3/4 Basement; Bathroom Ensuite; Separate Tub & Shower; Walk Thru; Walk-In Shower Stall Builder Information: Builders Association of the Twin Cities Construction Status: Under Construc/Spec Homes Dining Room Description: Separate/Formal Dining Room Electric: 200+ Amp Service; Circuit Breakers Exterior: Brick/Stone; Cement Board; Metal Family Room Characteristics: Great Room; Main Level Fencing: None Fireplace Characteristics: Gas Burning; Living Room Fuel: Natural Gas Heating: Forced Air Laundry: Electric Dryer Hookup; Laundry Room; Sink; Upper Level; Washer Hookup Lot Description: Sod Included in Price; Tree Coverage - Medium Parking Characteristics: Finished Garage; Floor Drain; Garage Door Opener; Heated Garage; Insulated Garage Pool Description: Below Ground; Heated; Shared Road Frontage: City Street Roof: Age 8 Years or Less; Asphalt Shingles; Pitched Sellers Terms: Cash; Conventional Sewer: Private Sewer Special Search: 2nd Floor Laundry; 4 BR on One Level; Primary Bdr Suite Stories: Two Water: Well

Contract Information

Maximum Price: 4000000
Minimum Price: 1500000
Contingency: None
Original List Price: 2989000
ListPrice: 2989000
Owner is an Agent?: Yes
Auction?: No

Location Tax and Other Information

House Number: 4747
Street Name: 140th
Street Suffix: Avenue
Street Direction Suffix: NE
Postal City: Ham Lake
County: Anoka
State: MN
Zip Code: 55304
Complex/Dev/Subdivision: Elwell Farms

Assessments

Tax With Assessments: 2000
Assessment Balance: 0

Builder Information

Builder ID: HANSON BUILDERS INC
Builder License Number: 4568
Builder Name: HANSON BUILDERS INC
Builders Association of the Twin Cities: Yes

More Information

Building Information

Finished SqFt Above Ground: 4839
Finished SqFt Below Ground: 2559

Insurance Fee

Insurance Fee Frequency: N/A
Insurance Fee: 0

Lease Details

Land Leased: Not Applicable

Miscellaneous Information

Community Name: Elwell Farms
Homestead: No

Ownership

Fractional Ownership: No

Parking Characteristics

Garage Dimensions: IRR
Garage Door Height: 8
Garage Door Width: 16
Garage Square Feet: 1801
Finished Garage: Yes
Floor Drain: Yes
Garage Door Opener: Yes
Heated Garage: Yes
Insulated Garage: Yes

Unit Details

Total Units Available: 14
Total Units Sold: Yes

Office/Member Info

Association: MAAR

Location, Tax and Other Information

AssocFeeYN: Yes
Legal Description: LOT 3 BLOCK 3 ELWELL FARMS
Listing City: Ham Lake
Map Page: 51
Municipality: Ham Lake
School District: Anoka-Hennepin
School District Phone: 763-506-1000
Property ID Number: TBD
Tax Year: 2026
Tax Amount: 2000
In Foreclosure?: No
Potential Short Sale?: No
Lender Owned?: No

Directions & Remarks

Public Remarks: 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.
Directions: North on Lexington Ave NE, turn Right onto 143rd Avenue NE, turn Right onto Opal Street NE, left on 140th Avenue NE. Home is on the Left.

Accessible

None: Yes

Air Conditioning

Central Air: Yes

Amenities Unit

Deck: Yes
Exercise Room: Yes
French Doors: Yes
Hardwood Floors: Yes
In-Ground Sprinkler: Yes
Kitchen Center Island: Yes
Kitchen Window: Yes
Natural Woodwork: Yes
Paneled Doors: Yes
Patio: Yes
Primary Bedroom Walk-In Closet: Yes
Security System: Yes
Sun Room: Yes
Tile Floors: Yes
Vaulted Ceiling(s): Yes
Walk-In Closet: Yes
Washer/Dryer Hookup: Yes
Wet Bar: Yes

Appliances

Air-To-Air Exchanger: Yes
Cooktop: Yes
Dishwasher: Yes
Disposal: Yes
Dryer: Yes
Microwave: Yes
Range: Yes
Refrigerator: Yes
Washer: Yes
Water Filtration System: Yes
Wine Cooler: Yes

Association Fee Includes

Professional Mgmt: Yes
Shared Amenities: Yes

Assumable Loan

Not Assumable: Yes

Basement

Drain Tiled: Yes
Sump Pump: Yes
Tile Shower: Yes

Bath Description

Primary Walk-Thru: Yes
Main Floor 1/2 Bath: Yes
Upper Level 3/4 Bath: Yes
Upper Level Full Bath: Yes
Full Primary: Yes
Private Primary: Yes
3/4 Basement: Yes
Basement: Yes
Bathroom Ensuite: Yes
Separate Tub & Shower: Yes
Walk Thru: Yes
Walk-In Shower Stall: Yes

Construction Status

Under Construc/Spec Homes: Yes

Dining Room Description

Separate/Formal Dining Room: Yes

Electric

200+ Amp Service: Yes
Circuit Breakers: Yes

Exterior

Brick/Stone: Yes
Cement Board: Yes
Metal: Yes

Family Room Characteristics

Great Room: Yes
Main Level: Yes

Fencing

None: Yes

Fireplace Characteristics

Gas Burning: Yes
Living Room: Yes

Fuel

Natural Gas: Yes

Heating

Forced Air: Yes

Laundry

Electric Dryer Hookup: Yes
Laundry Room: Yes
Sink: Yes
Upper Level: Yes
Washer Hookup: Yes

Lot Description

Sod Included in Price: Yes
Tree Coverage - Medium: Yes

Patio, Porch and Deck Features

Composite Decking: Yes
Deck: Yes
Front Porch: Yes

Pool Description

Below Ground: Yes
Heated: Yes
Shared: Yes

Road Frontage

City Street: Yes

Roof

Age 8 Years or Less: Yes
Asphalt Shingles: Yes
Pitched: Yes

Sellers Terms

Cash: Yes
Conventional: Yes

Sewer

Private Sewer: Yes

Special Search

2nd Floor Laundry: Yes
4 BR on One Level: Yes
Primary Bdr Suite: Yes

Stories

Two: Yes

Water

Well: Yes

Room Information

Room Name	Dimensions	Level
Athletic Court	26.5x21	Lower
Bonus Room	18x16	Upper
Dining Room	15x11	Main
Exercise Room	17x13	Lower
Family Room	19x19	Lower
Fifth (5th) Bedroom	14x17	Lower
First (1st) Bedroom	19x15.5	Upper
Fourth (4th) Bedroom	13x12	Upper
Kitchen	19x13	Main
Living Room	19.5x19	Main
Second (2nd) Bedroom	13x12	Upper
Third (3rd) Bedroom	13x12	Upper

Listing Office: Edina Realty, Inc.

Last Updated: May - 27 - 2026

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity SM Program of the Regional Multiple Listing Service of Minnesota, Inc. The information provided is deemed reliable but not guaranteed. Properties subject to prior sale, change or withdrawal. ©2024 Regional Multiple Listing Service of Minnesota, Inc All rights reserved.