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

Terri Bias

Operator/Brokerage Owner | Terri Bias and Associates | PLACE

Agent profile image in message

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.
main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
View All (32)
property photo 1
property photo 2
property photo 3
204 Northgate Boulevard , Indian Trail, NC 28079
$424,900
Est. Payment: $2,176.55/mo
3 Bed
2 Bath
1403 Sqft
Status: active | Days on site: 46
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from Terri Bias, 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.
Agent profile image
Terri Bias
Operator/Brokerage Owner
View agent profile
Email
Call

House Description

SELLER IS OFFERING A $5,000 CLOSING CREDIT WITH AN ACCEPTABLE OFFER!! Welcome to this former model ranch home in the active adult community of The Esplanade at Northgate. A covered front porch welcomes you inside, where an open-concept layout connects the main living spaces. The kitchen features quartz countertops, stainless steel appliances, a gas range, a center island with bar seating, and a dining area, all flowing into the living room for easy everyday living and entertaining. The primary suite offers a tray ceiling, a walk-in closet, and an ensuite bath complete with a double vanity and a walk-in shower featuring a rain shower head. Step outside to enjoy multiple outdoor living spaces, including a covered back patio, a built-in fire pit, and a paver patio with a pergola—ideal for relaxing or gathering with family and friends. Built in 2021, this home offers added peace of mind with major components, including the roof and HVAC system, being only a few years old. Ideally situated directly across the street from an impressive collection of resort-style amenities, residents enjoy access to a heated pool, outdoor fireside gathering areas, cabanas, pickleball courts, bocce ball courts, a fitness center, walking trails, and more. As an added convenience, the HOA provides year-round lawn maintenance, allowing for low-maintenance living. Conveniently located near shopping, dining, and everyday essentials, this home offers the perfect blend of comfort, convenience, and an active lifestyle.
Show more

Highlights

Listed by Phil Puma , 704-578-8851 Puma & Associates Realty, Inc. , 704-375-2495. Canopy MLS mls logo

Property Type

Residential
Lot/Acreage
0.15

HOA Fee

325.5 Monthly

Year Built

2021

County

Union

 Neighborhood

Esplanade at Northgate

Listing ID

4362212

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:3
  • ▪ Bathrooms:2
  • ▪ Full Bathrooms:2
Appliances:Dishwasher, Gas Range, Gas Water Heater, Microwave
Air Cond:Central Air
Fireplaces:
Floor:Carpet,Laminate,Tile
Above Ground Sq Ft:1403
Below Ground Sq Ft:0
Other:
  • ▪ Additional:Kitchen Island, Open Floorplan, Storage, Walk-In Closet(s), Master on Main
Water:County Water

Exterior Features

Others:
  • ▪ Additional:Fire Pit, Lawn Maintenance
Sewer:County Sewer
Parking Features:Driveway,Attached Garage
Principal Interest
$2,177
Taxes
$271
HOA
$326

Home Price

$424,900

Loan Details

30 yrs
6.625%

Down Payment

20%
$84,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,176.55

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $2,176.55 $270.87 $325.50 $2,772.92
Yearly $26,118.54 $3,250.49 $3,906.00 $33,275.03
Total $783,556.21 $97,514.55 $117,180.00 $998,250.76

Today's Rates

30 Year

6.63%

20 Year

6.38%

15 Year

6%

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Aug 2026

Average Price

All Price Ranges
N/A
Aug 2026

Average Days on Market

All Price Ranges
N/A
Aug 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.

Based on information submitted to the MLS GRID as of the date listed below. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
The data relating to real estate on this website derive in part from the Internet Data Exchange program. Brokers make an effort to deliver accurate information, but buyers should independently verify any information on which they will rely in a transaction. All properties are subject to prior sale, change or withdrawal. Neither Terri Bias and Associates | PLACE nor any listing broker shall be responsible for any typographical errors, misinformation, or misprints, and they shall be held totally harmless from any damages arising from reliance upon this data. This data is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing.
Listings courtesy of Canopy MLS as distributed by MLS GRID

IDX service by Blueroof 360

Data last updated: 2026-08-24T16:15:07.000Z

© 2026 Canopy MLS

MLS Logo - Canopy MLS