Skip to main content
Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
Skybrook
1/48
$1.1M

$1,149,000

404 Three Greens Drive

Huntersville, NC 28078

5Beds
5Baths
5,095Sq Ft
2006Built

About This Property

Sophisticated Living at 404 Three Greens Drive Skybrook | Huntersville’s Premier Golf Course Community.

|

Experience luxury in this beautiful John Wieland home where architectural elegance meets a resort-style backyard; this property offers unparalleled privacy with a stunning infinity pool and hot tub that overlook the 15th fairway. The backyard is a private sanctuary designed for the ultimate entertainer. Whether you are hosting a summer bbq or enjoying a quiet evening, the amenities are unmatched. A custom-designed infinity pool featuring a built-in hot tub. Outdoor Kitchen equipped with a built-in grill for seamless al fresco dining. Enjoy front-row seats to spectacular sunrises and sunsets with "forever views" across the golf course and total privacy. The home boasts a sophisticated layout highlighted by custom professional design and high-end finishes. A soaring two-story living room serves as the heart of the home, flooded with natural light. Features professionally designed custom cabinetry, granite countertops, stainless steel appliances and tile backsplash. A rare main-level bedroom with en suite offers flexibility for guests. All other bedrooms are located on the second level, each featuring its own dedicated bathroom for maximum privacy. The Primary Retreat is a true escape featuring a cozy fireplace and spa-like custom mirrors and finishes. The third floor is the "crown jewel" of the home. This massive bonus level includes: Full Wet Bar & Bath: Perfect for long movie nights or game days. Ample room for a pool table and more—this is the ultimate entertaining zone. It also offers the best views in the house, overlooking the pool and the rolling Skybrook fairways. This home has been meticulously maintained with significant recent upgrades: Brand New Roof was just installed for years of worry-free living and freshly encapsulated crawl space. Professionally designed tile work and designer mirrors throughout that set this home apart from the rest. Live the Skybrook lifestyle in a home that truly has it all. Schedule your private tour of 404 Three Greens Drive today!

CAR MLS # 299943047

Quick Facts

Time on Site

1 month ago

Property Type

Residential

Year Built

2006

Price/Sq.Ft.

$226

Property Details
Bedrooms:
5
Bathrooms:
5
Living Area:
5,095 SqFt
Sub-Type:
SingleFamilyResidence
Schools
Elementary:
Blythe
Middle:
J.M. Alexander
High:
North Mecklenburg
School assignments may change. Contact the school district to confirm.

Features & Amenities

Features:
  • Attic Other
  • Wet Bar
  • Whirlpool

Location & Map

Address

404 Three Greens Drive, Huntersville, NC 28078

Community

Skybrook

Map View

Loading map...

Additional Information

Utilities

Sewer
  • Public Sewer
Water Source
  • City

Lot And Land

Fencing
  • Fenced
Lot Features
  • On Golf Course
Lot Size Units
Acres
Lot Size Dimensions
96x174x94x171

Pool And Spa

Private Pool
true
Pool Features
  • Fenced
  • In Ground
  • Pool/Spa Combo

Agent Contacts

Listing Agent
Listing agent: Brian Bain (704-991-5055)
Listing Office
Listing provided courtesy of: Keller Williams Unlimited (704-409-4700)
Request Showing
  • Palmetto Park Realty Team Fort Mill: 803.548.6123
Source Identification
Details provided by CANOPYMLS as Distributed by MLS Grid and may not match the public record. Learn more.

Interior Details

Heating
  • Forced Air
  • Natural Gas
  • Zoned
Flooring
  • Carpet
  • Tile
  • Wood
Sq Ft Main
1919
Room Count
15
Sq Ft Lower
0
Sq Ft Third
1045
Sq Ft Upper
2131
Bedroom Main
1
Bedroom Third
0
Bedroom Upper
4
Full Bath Main
1
Half Bath Main
1
Full Bath Third
1
Full Bath Upper
3
Half Bath Third
0
Half Bath Upper
0
Half Bathrooms
1
Total Bathrooms
6
Window Features
  • Insulated Window(s)
Laundry Features
  • Electric Dryer Hookup
  • Gas Dryer Hookup
  • Utility Room
  • Upper Level
Sq Ft Unheated Main
610
Interior Features
  • Attic Other
  • Wet Bar
  • Whirlpool
Main Level Garage Y N
1
Security Features
  • Security System
Sq Ft Unheated Third
0
Sq Ft Unheated Total
610
Sq Ft Unheated Upper
0
Fireplace Features
  • Gas
  • Gas Log
  • Great Room
  • Primary Bedroom
Sq Ft Total Property H L A
5095

Exterior Features

Roof
  • Architectural Shingle
Exterior Features
  • In-Ground Irrigation
Construction Materials
  • Brick Full
Patio And Porch Features
  • Patio
  • Terrace
  • Other - See Remarks

Parking And Garage

Parking Features
  • Attached Garage
  • Garage Door Opener
  • Garage Faces Side

Waterfront And View

View
  • Golf Course

Financial Information

City Taxes Paid To
Huntersville
H O A Subject To Dues
Mandatory

Dwelling And Structure

Architectural Style
  • Traditional

Basement And Foundation

Foundation Details
  • Crawl Space

Zoning And Restrictions

Zoning Specification
R

Square Footage And Levels

Levels
  • Three
Above Grade Finished Area
5095
Below Grade Finished Area
0

Additional C A R Information

Web U R L
Https://www.bainfrey.com/homes-for-sale/ N C/huntersville/28078/404-three-greens-dr/bid-47-4369086
Assumable
No
Auction Y N
0
List Team I D
T M100620
C C R Subject To
Yes
Owner Agent Y N
0
Deed Reference
26607-820
List Team Mls Id
R23740
Construction Type
Site Built
Attribution Contact
Mls Major Change Type
Under Contract- Show
Down Payment Resource Y N
0
Attribution Type Listing
List Agent Email
Green Verification Count
0
Syndicate Participation
Participant Options
Association Annual Expense
564.00
Canopy MLS

IDX information is provided exclusively for consumers' personal, non-commercial use only; it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS GRID. Use of this site may be subject to an end user license agreement. Based on information submitted to the MLS GRID as of Sat, May 9, 2026. 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. Some IDX listings have been excluded from this website. Any use by you of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. DMCA Notice: Palmetto Park Realty respects the intellectual property rights of others. If you believe that your work has been copied in a way that constitutes copyright infringement, please provide our designated agent with written notice containing the following information: (1) identification of the copyrighted work claimed to have been infringed; (2) identification of the material that is claimed to be infringing; (3) your contact information; (4) a statement that you have a good faith belief that use of the material is not authorized; and (5) a statement that the information in the notification is accurate and you are authorized to act on behalf of the copyright owner. Please send DMCA notices to: [email protected]