Title Page Background
DEBUG FN args: Array ( [0] => 202 [1] => [2] => [3] => agent ) BEFORE: Site: 202 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 202 Igate: njhud LocID: 202 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 202 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 202 [1] => [2] => [3] => lender ) BEFORE: Site: 202 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 202 Igate: njhud LocID: 202 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 202 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 202 [1] => [2] => [3] => other ) BEFORE: Site: 202 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 202 Igate: njhud LocID: 202 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 202 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

205 Windfall Creek Drive
Chapel Hill, NC 27517

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,998,500
Beds: 5
Baths:
Status: Active
SqFt: 7788 Square Feet
Agency: Urban Durham Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Range, Refrigerator, Cooktop - Gas, Oven - Double
Architectural Style: Other
Construction Materials: Stone, HardiPlank Type, Stone Veneer
Flooring: Carpet, Tile, Hardwood
Heating: Central Furnace, Forced Air, Fireplace
Interior Features: High Speed Internet, Entrance Foyer, Kitchen Island, Pantry, Storage, High Ceilings, Walk-in Shower, In-law Floorplan, Bookcases, Separate Shower, Primary Downstairs, Crown Molding, Double Vanity, Granite Counters, Chandelier, Stone Counters, Smooth Ceilings, Bathtub/Shower Combination, Bathtub Only, Second Primary Bedroom, Dual Closets, Apartment/Suite
Rooms: Office, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Dining Room, Kitchen, Laundry, Media Room, Family Room, Living Room, Library, Exercise Room, Game Room

Window Features

Exterior Features: Porch, Deck, Partially Cleared, Wooded, Screened, Front Yard, Garden, Landscaped, Views, Many Trees, Back Yard, Rain Gutters, Basketball Court, Hardwood Trees
Parking Features: Garage, Driveway
Patio and Porch Features: Porch, Deck
Roof: Shingle
Vegetation: Wooded

Neighborhood/Schools

Elementary School/District: Chatham - N Chatham
Middle/Junior High School/District:
High School/District: Chatham - Seaforth
Subvidision Name: Windfall Creek

Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Welcome to this exquisite Windfall Creek Estate, a stunning home nestled on 4.45 acres, boasting a blend of classic features and timeless design. Constructed with unparalleled craftsmanship, this residence offers a rare combination of elegance and functionality not commonly found in newer properties. Discover the enchantment of three hidden reading and play nooks concealed behind ''magical'' library bookshelves, creating an inspiring space to read and imagine. Unleash your imagination on the whimsical built-in 3rd floor stage, perfect for the most imaginative play sessions. For music aficionados, a first-rate piano room awaits, complemented by a sophisticated audio system that allows classical melodies to resonate throughout the home.The primary retreat is a sanctuary of comfort, featuring two walk-in closets, Diamon-Fusion coated ultra-clear shower glass, and two Rinnai eternal hot water heaters, ensuring relaxation and convenience. Meanwhile, the guest retreat with its private entrance offers unrivaled privacy for visitors.Entertainment knows no bounds with a dedicated theater, home gym, art studio, and a well-appointed home office, catering to every lifestyle need. Outdoor enthusiasts will be captivated by the magnificent stone walls, charming screened porch, and expansive deck - perfect for grilling and enjoying the serene wooded views. Lush gardens and a sprawling grass play yard provide the ideal setting for gatherings and outdoor activities. Step inside this Windfall treasure and experience a refuge of tranquility that you'll never want to leave.
MlsNumber: --


Listing Provided By: Urban Durham Realty, original listing
Phone: (919) 810-7005
Office Phone: (919) 237-3701
Agent Name: Mary Hunter
Disclaimer: Copyright © 2024 Triangle MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App