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

4050 Puddle Pond Rd , Indian Trail, NC 28079
$509,990
Est. Payment: $1,133.31/mo
4 Bed
3 Bath
2813 Sqft
Status: Active | Days on site: 154
Get Pre-Qualified
2594 - R66004
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

The Hamilton is a spacious primary on the main floorplan that offers both comfort and style. The main level features a formal dining room, as well as a casual dining area that flows seamlessly to a covered outdoor patio perfect for entertaining or relaxing. The well-appointed kitchen boasts abundant cabinet storage, gourmet kitchen with a gas cook-top and a large island, while the primary suite offers a generously sized walk-in closet. A convenient powder room completes the main floor. Upstairs, you’ll find three generously sized bedrooms, two with walk-in closets, a full bath with double vanity, separate from the tub/shower/toilet, and another single vanity for the 3rd bedroom. Enjoy a spacious loft ideal for a second living area, office, or playroom. With easy access to the nearby towns of Matthews, Mint Hill, Concord, and Ballantyne, you can enjoy the tranquility of nature while staying connected to town amenities. Find your perfect blend of nature, convenience, and community at Moore Farms.

Highlights

Listed by Bradley Norris , 704-586-9469 Dream Finders Realty, LLC. , 910-988-4888.

Property Type

Residential

Lot/Acreage
0.14

HOA Fee

135 Monthly

Year Built

2026

County

Union

Neighborhood

Moore Farm

Listing ID

4370353

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:4
  • Bathrooms:3
  • Full Bathrooms:2
  • 1/2 Bathrooms:1
Appliances:Dishwasher, Disposal, Electric Water Heater, Exhaust Fan, Gas Cooktop, Microwave, Wall Oven
Air Cond:Central Air
Fireplaces:
Floor:Laminate,Tile
Above Ground Sq Ft:2813
Below Ground Sq Ft:0
Other:
  • Additional:Entrance Foyer, Kitchen Island, Open Floorplan, Pantry, Walk-In Closet(s), Master on Main
Water:County Water

Exterior Features

Roof:Architectural Shingle
Sewer:County Sewer
Parking Features:Attached Garage,Garage Door Opener,Garage Faces Front

Open House

Upcoming Open Houses
Saturday 11:00 am - 4:00 pm Sep 19
Sunday 1:00 pm - 5:00 pm Sep 20
Principal Interest
$1,133
Taxes
$325
HOA
$135

Home Price

$509,990

Loan Details

30 yrs
%

Down Payment

20%
$101,998
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:
$1,133.31

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $1,133.31 $325.12 $135.00 $1,593.43
Yearly $13,599.73 $3,901.42 $1,620.00 $19,121.16
Total $407,992.00 $117,042.71 $48,600.00 $573,634.71

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 (Indian Trail, 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.