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;

202 S Main Street
Colerain, NC 27924
NANCY WINSLOW with Keller Williams Realty Points East, original listing - (252) 355-6000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $229,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3040 Square Feet
Agency: Keller Williams Realty Points East
Agency Phone: (252) 355-6000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1820
Notes: Priced below appraised value. The Henry-Beasley House, c1820, is a two-story Greek Revival-style house sheathed with weatherboard and filled with charm and character. The two panel entrance door is surrounded by transom and sidelights. The first floor windows are nine-over-nine double-hung sash and the second floor windows are nine-over-six, most with original wavy glass, with fluted surrounds and Greek key motifs at the corners. Heart of pine floors throughout all the main areas and are in great condition showing off the natural beauty in the wood. The center hall/foyer is wide with high ceilings. As you'll see in the photos, there is plenty of room for displaying large antiques. The formal living areas on each side of the front door offer plenty of entertaining space with beautiful architectural features. A new chimney has been built on the left side, which helps set up the spectacular over 6' tall ornate mantle. The fireplace on the right side/den area is currently being used for a wood-burning fireplace. The large formal dining room features a ceiling medallion with prominent hanging chandelier. This room comfortably holds a table for 12 and very large antique side items. The kitchen on the back has been recently renovated to include new appliances and a working wood stove. Upstairs can be accessed from the back entrance off the kitchen and back door or from the front foyer. Here you'll find 4 large bedrooms, tons of natural light, a full bath with access to the upstairs front hall and the back landing. The laundry room is located downstairs off the kitchen. Outside features includes a beautifully crafted water feature, 5' tall black coated chainlink fence, and a two-bay, two-story garage with workshop. Protective covenants are attached to the deed with Preservation NC. This is a contributing building in Colerain's National register Historic District, making it eligible for historic tax credits. Call today to schedule a private showing.
MlsNumber: --
ListingId: 100471027


Listing Provided By: Keller Williams Realty Points East, original listing
Phone: (252) 355-6000
Office Phone: (252) 355-6000
Agent Name: NANCY WINSLOW
Disclaimer: Copyright © 2025 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