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 = 1892 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 = 1892 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 = 1892 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;

405 Confederate Street
Windsor, NC 27983
Christy Wallace with EXP Realty, original listing - (888) 584-9431

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $280,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2462 Square Feet
Agency: EXP Realty
Agency Phone: (888) 584-9431

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Nestled in a serene and well-established neighborhood in small-town Windsor, this home offers a unique and tranquil retreat. Situated on a spacious .50-acre lot, this property boasts an inviting landscape with majestic tall pines, lush centipede grass, and vibrant azaleas that bloom in a spectacular display every spring.<br /> As you step inside, you'll be captivated by the rustic charm of cedar walls, floors, and ceilings, creating a warm and inviting ambiance throughout. The heart of the home is the living room, featuring vaulted ceilings and a striking stone fireplace, perfect for cozy evenings.<br /> The kitchen and dining area are thoughtfully designed for both connection and convenience. They are perfect for engaging with the family while preparing dinner or entertaining a large crowd, making this space a true gathering spot.<br /> The main floor includes a primary ensuite bedroom with a large walk-in closet, providing a private sanctuary for relaxation. Off the living room, an extra-large deck, newly redone, invites you to enjoy outdoor living at its finest—ideal for hosting guests or soaking in the peaceful surroundings.<br /> The second floor offers a versatile loft overlooking the living room, along with two generously sized guest bedrooms and a full bath. A third-floor bonus/flex room adds endless possibilities: a home office, game room, or creative studio—the choice is yours!<br /> The backyard is a private oasis, bordered by trees at the back property line. A large storage barn provides ample space for tools, hobbies, or storage needs.Located in Windsor, this home is perfectly positioned for convenient access to Greenville, Edenton, and the Outer Banks, blending small-town charm with accessibility to larger hubs and coastal escapes.<br /> 405 Confederate Lane isn't just a house—it's a lifestyle. Come see the possibilities this extraordinary property holds!
MlsNumber: --
ListingId: 100476184


Listing Provided By: EXP Realty, original listing
Phone: (888) 584-9431
Office Phone: (888) 584-9431
Agent Name: Christy Wallace
Disclaimer: Copyright © 2024 Hive MLS / Coastal Plains Association of REALTORS. 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