x
Showing 1 of 0
X
Save

404 Three Greens Drive
Huntersville NC 28078 US

$1,149,000

Active Listing ID 4369086
bed icon
5 bed
bath icon
6.00 Bath (5 Full , 1 Half)
lot icon
Lot: 0.37 Acres
home icon
Single Family Residence

$1,149,000

Active Listing ID 4369086
Save

404 Three Greens Drive 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!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.37 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 5
  • 1/2 Bathrooms: 1
  • Cooling System: Zoned, Central Air, Ceiling Fan(s)
  • Exterior Finish: In-Ground Irrigation
  • Floor Covering: Tile, Carpet, Wood
  • Roof Type: Shingle
  • Heating Fuels: Natural Gas, Zoned, Forced Air
  • Additional Features
  • Fireplace
  • Patio
  • Pool

School Information

  • School
  • Blythe(Elementary)
  • J.M. Alexander(MiddleSchool)
  • North Mecklenburg(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1149000
  • unparsedaddress: 404 Three Greens Drive
  • postalcity: Huntersville
  • stateorprovince: NC
  • country: US
  • postalcode: 28078
  • bathroomsfull: 5
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.37
  • lotsizeunits: Acres
  • lotsizearea: 0.37
  • livingarea: 5095
  • livingareaunits: Square Feet
  • latitude: 35.414057
  • longitude: -80.758144
  • listagentfullname: Brian Bain
  • listagentemail: brian@bainfrey.com
  • listagentkey: 3yd-CMLSNC-32161
  • listagentmlsid: 32161
  • listagentpreferredphone: 7049915055
  • listagentofficephone: 7049915055
  • listofficekey: 3yd-CMLSNC-9148
  • listofficemlsid: 9148
  • disclaimer: Copyright © 2026 Canopy MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: CMLSNC
  • yearbuilt: 2006
  • listingcontractdate: 2026-04-24
  • listagenturl: http://www.kwcharlotteuniversity.com
  • countyorparish: Mecklenburg
  • parcelnumber: 021-091-25
  • elementaryschool: Blythe
  • highschool: North Mecklenburg
  • appliances: Convection Oven, Dishwasher, Disposal, Electric Oven, Electric Range, Gas Cooktop, Gas Water Heater, Microwave, Plumbed For Ice Maker, Refrigerator with Ice Maker, Washer/Dryer
  • cooling: Zoned, Central Air, Ceiling Fan(s)
  • constructionmaterials: Brick Full
  • flooring: Tile, Carpet, Wood
  • heating: Natural Gas, Zoned, Forced Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 3
  • parkingtotal: 0
  • parkingfeatures: Garage - Attached, Garage, Open
  • roof: Shingle
  • view: Golf Course
  • waterfrontyn: False
  • franchiseaffiliation: Keller Williams Realty
  • interiorfeatures: Attic Other, Wet Bar, Whirlpool
  • exteriorfeatures: In-Ground Irrigation
  • windowfeatures: Insulated Windows
  • architecturalstyle: Other
  • rooms: Bedroom 1, Laundry Room, Bedroom 4, Bathroom 4, Bedroom 2, Bathroom 5, Bathroom 2, Bedroom 5, Bathroom 3, Bathroom 6, Bedroom 3, Bathroom 1, Dining Room, Bonus Room
  • securityfeatures: Security System
  • otherstructures: Other
  • patioandporchfeatures: Patio
  • dock: False
  • poolprivateyn: True
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -80.75814, 35.41406
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-CMLSNC-4369086", "OpenHouseEndTime": "2026-05-03 17:00:00", "OpenHouseId": "3660696", "OpenHouseRemarks": null, "OpenHouseStartTime": "2026-05-03 14:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Keller Williams Realty University Market Center", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"brian@bainfrey.com", "ListBrokerageCity":"Charlotte", "ListBrokerageCountry":"US", "ListBrokerageEmail":"elaineprice@kw.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/CMLSNC/c5ababc31cb4ce58011cb4f4480914a8/20141215234555721.png", "ListBrokerageName":"Keller Williams Realty University Market Center", "ListBrokeragePhone":"(704) 409-4700", "ListBrokeragePostalCode":"28269", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":"Suite 100", "ListBrokerageUnparsedAddress":"8520 Cliff Cameron Dr", "ListBrokerageWebsiteUrl":"http://www.kwcharlotteuniversity.com", "ListOfficeAddress1":"8520 Cliff Cameron Dr Ste 100", "ListOfficeAddress2":"Suite 100", "ListOfficeBrokerMlsId":"9148", "ListOfficeCity":"Charlotte", "ListOfficeCountry":"US", "ListOfficeEmail":"bic@kwclt.com", "ListOfficePostalCode":"28269", "ListOfficeStateOrProvince":"NC", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Other - Huntersville, NC", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/404-Three-Greens-Dr_Huntersville_NC_28078_M68317-09154?f=listhub&s=CMLSNC&m=4369086&c=rexren", "MLSModificationTimestamp":"2026-04-28 16:48:06", "Neighborhoods":[{"Description":null, "Name":"Skybrook"}], "PostalCode":null, "RoomCount":15, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":null, "TaxDescription":"L208 M44-307", "TaxYear":null}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 4/28/2026 5:45:33 PM GMT
Source Updated Date: 5/1/2026 6:56:17 PM GMT

Courtesy of: Brian Bain, Keller Williams Unlimited, brian@bainfrey.com

Copyright © 2026 Canopy MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.