Title Page Background
HFQUERY 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 = 3439 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3439 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3439 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

5004&5005 Kinloss Drive
Fuquay Varina, NC 27526

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,295,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3710
Agency: Team Anderson Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Residential
Year Built: 2024
Notes: Bring your horses with country living in the heart of Wake County! Standing out among one the Triangle's most impressive custom-built new construction residences is a ranch-style home nestled on nearly 14 acres of level land, with no HOA restrictions, and is situated off Sunset Lake Road, just shy of the Holly Springs border. Spanning over 3,700 square feet with an additional 3,500 square feet of unfinished space on the second floor, available for future expansion, if desired! This thoughtfully designed estate has a 3-car attached garage with utility sink, utilizing the finest materials and customized elements such as 10' and 9' ceiling heights, oversized baseboards, and wide plank engineered hardwood styled floors. A true open floor concept in the heart of the home combines a sophisticated living space with elegant, coffered ceiling and a floor-to-ceiling stone fireplace with built-in shelving on either side and a gourmet kitchen showcasing an abundance of cabinetry, industrial size fridge/freezer, wall oven, quartz countertops, and an expansive center island adding storage and accent color. An adjacent breakfast nook compliments an array of table options plus a convenient drop station and generously sized laundry room as you enter from the garage. Over-sized windows display breathtaking views of the beautiful park-like setting. The primary bedroom boasts a walk-in closet and dual ensuite bathrooms, both including their own private commodes, vanity sinks, and walk-in showers. There is a guest suite on the opposite side of the home with a private bathroom and WIC. The other three flex rooms can be converted to bedrooms, home offices, fitness rooms, the list is endless. A screened-in porch equipped with outdoor fireplace and ceiling fan give additional living space year round! The backyard was designed with possible future in ground pool addition. Come see this incredible property in person!
MlsNumber: 10030782


Listing Provided By: Team Anderson Realty, original listing
Name: Team Anderson Realty
Phone: (919) 610-5126
Office Name: Team Anderson Realty
Office Phone: (919) 610-5126
Agent Name: Erica Anderson
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.


Local Real Estate Expert

HFQUERY 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 = 3439 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for DANI AND JOHNIE BLACKWELL
DANI AND JOHNIE BLACKWELL
ASCIITHE BLACKWELL GROUP Keller Williams Elite Realty
Call Today!: (919) 335-8152

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App