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

5851 Freeland Bay N , Hugo, MN 55038
$1,089,900
Est. Payment: $2,422.00/mo
5 Bed
5 Bath
5241 Sqft
0.3 Acres
Status: active | Days on site: 23
Get Pre-Qualified
40961 - 505006005
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

Wake up to peaceful pond views, spend your evenings watching sunsets over protected wetlands, and experience the best of luxury new construction in one of Hugo's most desirable communities. This recently completed Charlotte by Robert Thomas Homes blends timeless architecture with thoughtfully curated designer finishes and over 5,200 finished square feet of luxury living. From the dramatic two-story entry to the sun-filled gathering room, gourmet chef's kitchen, inviting sunroom, and expansive maintenance-free deck, every space was intentionally designed for connection, comfort, and effortless entertaining. The upper level is anchored by a stunning vaulted owner's retreat featuring a spa-inspired bath with a freestanding soaking tub, oversized walk-in shower, and two generous walk-in closets. Three additional bedrooms, three bathrooms, a spacious bonus room, and upper-level laundry complete the home's incredibly functional layout. Downstairs, the finished walkout level offers endless flexibility with a large family room, fifth bedroom, full bath, dedicated exercise room, and direct access to your private backyard overlooking protected wetlands. Professionally selected finishes, including wide-plank white oak flooring, custom cabinetry, Calacatta quartz countertops, brushed gold fixtures, and designer lighting create a home that feels sophisticated yet inviting. Every detail has already been selected, allowing you to enjoy the excitement of a brand-new home without the wait or stress of making design decisions. Luxury. Privacy. Nature. A home designed for the way you truly want to live. Mahtomedi School District 832.

Highlights

Listed by David E Steger , 612-366-8160 Robert Thomas Homes, Inc. , 952-322-8700. Minneapolis/St. Paul and St. Cloud - Northstar MLS

Property Type

Residential

Lot/Acreage
0.3

HOA Fee

67 Monthly

Year Built

2026

County

Washington

Area

Watercrest of Hugo

Neighborhood

Watercrest of Hugo

School District

Mahtomedi

Listing ID

7152277

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:5
  • ▪ Bathrooms:5
  • ▪ Full Bathrooms:4
  • ▪ 1/2 Bathrooms:1
Appliances:Air-To-Air Exchanger, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Exhaust Fan, Humidifier, Gas Water Heater, Microwave, Refrigerator, Stainless Steel Appliances, Washer, Water Softener Owned
Air Cond:Central Air
Fireplaces:
Above Ground Sq Ft:3854
Below Ground Sq Ft:1387
Basement:Finished
Other:
  • ▪ Additional:Full Basement, Private Primary, Main Floor 1/2 Bath, Upper Level Full Bath, Kitchen/Dining Room
Water:City Water/Connected

Exterior Features

Lot Dimensions:80.20x135.00x80.20x135.00
Zoning:Residential-Single Family
Sewer:City Sewer/Connected
Parking Features:Attached Garage

Open House

Upcoming Open Houses
Thursday 9:00 am - 7:00 pm Oct 22
Friday 9:00 am - 7:00 pm Oct 23
Saturday 9:00 am - 7:00 pm Oct 24
Sunday 9:00 am - 7:00 pm Oct 25
Monday 9:00 am - 7:00 pm Oct 26
Tuesday 9:00 am - 7:00 pm Oct 27
Wednesday 9:00 am - 7:00 pm Oct 28
Thursday 9:00 am - 7:00 pm Oct 29
Friday 9:00 am - 7:00 pm Oct 30
Saturday 9:00 am - 7:00 pm Oct 31
Sunday 9:00 am - 7:00 pm Nov 1
Monday 9:00 am - 7:00 pm Nov 2
Tuesday 9:00 am - 7:00 pm Nov 3
Wednesday 9:00 am - 7:00 pm Nov 4
Thursday 9:00 am - 7:00 pm Nov 5
Friday 9:00 am - 7:00 pm Nov 6
Saturday 9:00 am - 7:00 pm Nov 7
Sunday 9:00 am - 7:00 pm Nov 8
Monday 9:00 am - 7:00 pm Nov 9
Tuesday 9:00 am - 7:00 pm Nov 10
Wednesday 9:00 am - 7:00 pm Nov 11
Thursday 9:00 am - 7:00 pm Nov 12
Friday 9:00 am - 7:00 pm Nov 13
Saturday 9:00 am - 7:00 pm Nov 14
Sunday 9:00 am - 7:00 pm Nov 15
Monday 9:00 am - 7:00 pm Nov 16
Tuesday 9:00 am - 7:00 pm Nov 17
Wednesday 9:00 am - 7:00 pm Nov 18
Thursday 9:00 am - 7:00 pm Nov 19
Friday 9:00 am - 7:00 pm Nov 20
Saturday 9:00 am - 7:00 pm Nov 21
Sunday 9:00 am - 7:00 pm Nov 22
Monday 9:00 am - 7:00 pm Nov 23
Tuesday 9:00 am - 7:00 pm Nov 24
Wednesday 9:00 am - 7:00 pm Nov 25
Thursday 9:00 am - 7:00 pm Nov 26
Friday 9:00 am - 7:00 pm Nov 27
Saturday 9:00 am - 7:00 pm Nov 28
Sunday 9:00 am - 7:00 pm Nov 29
Monday 9:00 am - 7:00 pm Nov 30
Tuesday 9:00 am - 7:00 pm Dec 1
Wednesday 9:00 am - 7:00 pm Dec 2
Thursday 9:00 am - 7:00 pm Dec 3
Friday 9:00 am - 7:00 pm Dec 4
Saturday 9:00 am - 7:00 pm Dec 5
Sunday 9:00 am - 7:00 pm Dec 6
Monday 9:00 am - 7:00 pm Dec 7
Tuesday 9:00 am - 7:00 pm Dec 8
Wednesday 9:00 am - 7:00 pm Dec 9
Thursday 9:00 am - 7:00 pm Dec 10
Friday 9:00 am - 7:00 pm Dec 11
Saturday 9:00 am - 7:00 pm Dec 12
Sunday 9:00 am - 7:00 pm Dec 13
Monday 9:00 am - 7:00 pm Dec 14
Tuesday 9:00 am - 7:00 pm Dec 15
Wednesday 9:00 am - 7:00 pm Dec 16
Thursday 9:00 am - 7:00 pm Dec 17
Friday 9:00 am - 7:00 pm Dec 18
Saturday 9:00 am - 7:00 pm Dec 19
Sunday 9:00 am - 7:00 pm Dec 20
Monday 9:00 am - 7:00 pm Dec 21
Tuesday 9:00 am - 7:00 pm Dec 22
Wednesday 9:00 am - 7:00 pm Dec 23
Thursday 9:00 am - 7:00 pm Dec 24
Friday 9:00 am - 7:00 pm Dec 25
Saturday 9:00 am - 7:00 pm Dec 26
Sunday 9:00 am - 7:00 pm Dec 27
Monday 9:00 am - 7:00 pm Dec 28
Tuesday 9:00 am - 7:00 pm Dec 29
Wednesday 9:00 am - 7:00 pm Dec 30
Thursday 9:00 am - 7:00 pm Dec 31
Friday 9:00 am - 7:00 pm Jan 1
Saturday 9:00 am - 7:00 pm Jan 2
Sunday 9:00 am - 7:00 pm Jan 3
Monday 9:00 am - 7:00 pm Jan 4
Tuesday 9:00 am - 7:00 pm Jan 5
Wednesday 9:00 am - 7:00 pm Jan 6
Thursday 9:00 am - 7:00 pm Jan 7
Friday 9:00 am - 7:00 pm Jan 8
Saturday 9:00 am - 7:00 pm Jan 9
Sunday 9:00 am - 7:00 pm Jan 10
Monday 9:00 am - 7:00 pm Jan 11
Tuesday 9:00 am - 7:00 pm Jan 12
Wednesday 9:00 am - 7:00 pm Jan 13
Thursday 9:00 am - 7:00 pm Jan 14
Friday 9:00 am - 7:00 pm Jan 15
Saturday 9:00 am - 7:00 pm Jan 16
Sunday 9:00 am - 7:00 pm Jan 17
Monday 9:00 am - 7:00 pm Jan 18
Tuesday 9:00 am - 7:00 pm Jan 19
Wednesday 9:00 am - 7:00 pm Jan 20
Thursday 9:00 am - 7:00 pm Jan 21
Friday 9:00 am - 7:00 pm Jan 22
Saturday 9:00 am - 7:00 pm Jan 23
Sunday 9:00 am - 7:00 pm Jan 24
Monday 9:00 am - 7:00 pm Jan 25
Tuesday 9:00 am - 7:00 pm Jan 26
Wednesday 9:00 am - 7:00 pm Jan 27
Thursday 9:00 am - 7:00 pm Jan 28
Friday 9:00 am - 7:00 pm Jan 29
Saturday 9:00 am - 7:00 pm Jan 30
Sunday 9:00 am - 7:00 pm Jan 31
Monday 9:00 am - 7:00 pm Feb 1
Tuesday 9:00 am - 7:00 pm Feb 2
Wednesday 9:00 am - 7:00 pm Feb 3
Thursday 9:00 am - 7:00 pm Feb 4
Friday 9:00 am - 7:00 pm Feb 5
Saturday 9:00 am - 7:00 pm Feb 6
Sunday 9:00 am - 7:00 pm Feb 7
Monday 9:00 am - 7:00 pm Feb 8
Tuesday 9:00 am - 7:00 pm Feb 9
Wednesday 9:00 am - 7:00 pm Feb 10
Thursday 9:00 am - 7:00 pm Feb 11
Friday 9:00 am - 7:00 pm Feb 12
Saturday 9:00 am - 7:00 pm Feb 13
Sunday 9:00 am - 7:00 pm Feb 14
Monday 9:00 am - 7:00 pm Feb 15
Tuesday 9:00 am - 7:00 pm Feb 16
Wednesday 9:00 am - 7:00 pm Feb 17
Thursday 9:00 am - 7:00 pm Feb 18
Friday 9:00 am - 7:00 pm Feb 19
Saturday 9:00 am - 7:00 pm Feb 20
Sunday 9:00 am - 7:00 pm Feb 21
Monday 9:00 am - 7:00 pm Feb 22
Tuesday 9:00 am - 7:00 pm Feb 23
Wednesday 9:00 am - 7:00 pm Feb 24
Thursday 9:00 am - 7:00 pm Feb 25
Friday 9:00 am - 7:00 pm Feb 26
Saturday 9:00 am - 7:00 pm Feb 27
Sunday 9:00 am - 7:00 pm Feb 28
Monday 9:00 am - 7:00 pm Mar 1
Tuesday 9:00 am - 7:00 pm Mar 2
Wednesday 9:00 am - 7:00 pm Mar 3
Thursday 9:00 am - 7:00 pm Mar 4
Friday 9:00 am - 7:00 pm Mar 5
Saturday 9:00 am - 7:00 pm Mar 6
Sunday 9:00 am - 7:00 pm Mar 7
Monday 9:00 am - 7:00 pm Mar 8
Tuesday 9:00 am - 7:00 pm Mar 9
Wednesday 9:00 am - 7:00 pm Mar 10
Thursday 9:00 am - 7:00 pm Mar 11
Friday 9:00 am - 7:00 pm Mar 12
Saturday 9:00 am - 7:00 pm Mar 13
Sunday 9:00 am - 7:00 pm Mar 14
Monday 9:00 am - 7:00 pm Mar 15
Tuesday 9:00 am - 7:00 pm Mar 16
Wednesday 9:00 am - 7:00 pm Mar 17
Thursday 9:00 am - 7:00 pm Mar 18
Friday 9:00 am - 7:00 pm Mar 19
Saturday 9:00 am - 7:00 pm Mar 20
Sunday 9:00 am - 7:00 pm Mar 21
Monday 9:00 am - 7:00 pm Mar 22
Tuesday 9:00 am - 7:00 pm Mar 23
Wednesday 9:00 am - 7:00 pm Mar 24
Thursday 9:00 am - 7:00 pm Mar 25
Friday 9:00 am - 7:00 pm Mar 26
Saturday 9:00 am - 7:00 pm Mar 27
Sunday 9:00 am - 7:00 pm Mar 28
Monday 9:00 am - 7:00 pm Mar 29
Tuesday 9:00 am - 7:00 pm Mar 30
Wednesday 9:00 am - 7:00 pm Mar 31
Thursday 9:00 am - 7:00 pm Apr 1
Friday 9:00 am - 7:00 pm Apr 2
Principal Interest
$2,422
Taxes
$695
HOA
$67

Home Price

$1,089,900

Loan Details

30 yrs
0%

Down Payment

20%
$217,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:
$2,422.00

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $2,422.00 $694.81 $67.00 $3,183.81
Yearly $29,064.00 $8,337.74 $804.00 $38,205.74
Total $871,920.00 $250,132.05 $24,120.00 $1,146,172.05
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
Oct 2026

Average Price

All Price Ranges
N/A
Oct 2026

Average Days on Market

All Price Ranges
N/A
Oct 2026
Market insight data is pulled from the same city as the listing being viewed (Hugo, 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-10-22T10:01:08.000Z

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