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

Dream Team United

| Dream Team United | Keller Williams Connected | PLACE

Agent profile image in message

173 Freshwater Ln , Mooresville, NC 28117
$1,500,000
Est. Payment: $3,333.33/mo
4 Bed
4 Bath
4044 Sqft
Status: Under Contract-Show | Days on site: 10
Get Pre-Qualified
9012 - 22507,R18770
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from , 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

Fall in love with the timeless Southern charm, inviting warmth, and effortless indoor-outdoor living of this exceptional custom home. From the moment you enter, the thoughtful design and inviting atmosphere are immediately apparent, with an open, airy floor plan that naturally draws you toward the heart of the home and beyond to a dream backyard retreat. The renovated kitchen is both beautiful and functional, featuring a generous island with seating, a new 5-burner gas cooktop and a farmhouse sink. The spacious breakfast area overlooks the backyard, while the great room flows seamlessly from the kitchen and features a striking stacked-stone fireplace, custom built-ins, and a see-through design that connects directly to the screened porch. It is a home that truly comes alive when entertaining, allowing guests to move effortlessly from the interior to the outdoor spaces. The main-level primary suite offers a peaceful retreat with a newly redesigned spa-inspired bath with an oversized shower and freestanding tub. A dedicated office, elegant dining room with butler’s pantry, and thoughtfully designed laundry room with sink and drop zone complete the main level. Upstairs, three additional bedrooms, a versatile bonus room and walk-in storage room provide great spaces to live in. However the true magic of this property may be found outdoors. The backyard has been transformed into a private resort-like escape, complete with a fiberglass pool and slide, therapeutic hot tub, and expansive flagstone patio & full outdoor bath. A large covered porch with Phantom screens, vaulted tongue-and-groove ceiling, and a fully equipped outdoor kitchen with grill, sink, dishwater refrigerator creates an inviting extension of the home and the perfect setting for everything from relaxed evenings to unforgettable gatherings. Every detail was thoughtfully considered to create a home that feels as wonderful as it functions. Residents of The Farms enjoy resort-style amenities and a true neighborhood lifestyle. The community features a full-time activities director, Junior Olympic-size pool, pavilion with outdoor kitchen, six tennis courts, six pickleball courts, beach volleyball, basketball court, soccer field, walking trails, and a gated boat/RV storage lot. Conveniently located on the Brawley Peninsula near Lake Norman, residents enjoy easy access to Hager Creek public boat launch, as well as nearby shopping, dining, and top-rated schools. Beautifully appointed, exceptionally warm, and designed around the way people truly want to live, this is more than a home it is a place made for gathering, relaxing, and making memories!

Highlights

Listed by Jessica Babington , 704-658-8849 and Micaela Brewer , 704-658-8849 Trump International Realty Charlotte , 704-799-0700.

Property Type

Residential

Lot/Acreage
0.91

HOA Fee

880 Semi-Annually

Year Built

2004

County

Iredell

Neighborhood

The Farms

Listing ID

4411253

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:4
  • Bathrooms:4
  • Full Bathrooms:3
  • 1/2 Bathrooms:1
Appliances:Dishwasher, Disposal, Double Oven, Dryer, Gas Range, Microwave, Refrigerator, Washer/Dryer
Air Cond:Central Air
Fireplaces:Gas,Great Room
Floor:Carpet,Tile,Wood
Above Ground Sq Ft:4044
Below Ground Sq Ft:0
Other:
  • Additional:Attic Walk In, Built-in Features, Drop Zone, Entrance Foyer, Kitchen Island, Open Floorplan, Pantry, Storage, Walk-In Closet(s), Has Fireplace, Master on Main
Water:Community Well

Exterior Features

Lot:Private,Wooded
Zoning:RA
Roof:Architectural Shingle
Others:
  • Additional:Hot Tub, Gas Grill, In-Ground Hot Tub / Spa, In-Ground Irrigation, Outdoor Kitchen, Outdoor Shower
Sewer:Septic Installed
Parking Features:Attached Garage
Principal Interest
$3,333
Taxes
$956
HOA
$880

Home Price

$1,500,000

Loan Details

30 yrs
%

Down Payment

20%
$300,000
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:
$3,333.33

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $3,333.33 $956.25 $880.00 $5,169.58
Yearly $40,000.00 $11,475.00 $10,560.00 $62,035.00
Total $1,200,000.00 $344,250.00 $316,800.00 $1,861,050.00

Today's Rates

30 Year

0%

20 Year

0%

15 Year

0%

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 (Mooresville, NC).

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.