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

831 Meadow Road
Walstonburg, NC 27888
AMANDA HIGHTOWER with United Real Estate East Carolina, original listing - (252) 355-3129

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $680,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 4442 Square Feet
Agency: United Real Estate East Carolina
Agency Phone: (252) 355-3129

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1920
Notes: Southern charm and tradition at its finest! You don't want to miss a chance to own this gorgeous 1925 home that has all the old school charm but modern updates. There are so many features that you are sure to love including: beautiful hardwood floors ,6 fireplaces throughout the entire home, 9' ceilings throughout the downstairs, a primary suite downstairs with bathroom attached and a walk in closet, a kitchen with custom cherry cabinets, corian tops, an island with a sink, open to a breakfast area with lots of windows and a vaulted ceiling, a dining room with a baldwin brass light fixture and heart pine floors, a laundry room with a sink, a pull down iron board, cabinets and cubbies. There is also an office downstairs with a brick fireplace made from the bricks of the original home. The office space connects to the primary room but also has a separate door so business guest don't have to come through the house. Upstairs you will love the bonus room plus two additional office spaces or playrooms and 2 bedrooms and one full bathroom. There is large, beautiful trim throughout the entire home. So many details that you will not find in newer homes and that you don't want to miss! Home also has tankless hot water heater, a gas pack that was put in October 2023, a brick patio, 4 porches so you can sit and enjoy the country views from any side of the house, Christmas light switch, a double detached carport with lights, and a wired and salt treated utility shed. All of this sitting on .91 acres in Walstonburg just minutes away from Greenville, Wilson, Kinston and Goldsboro. So much love and thought was put into every detail on this home, you are sure to fall in love the moment you walk in!
MlsNumber: --
ListingId: 100475206


Listing Provided By: United Real Estate East Carolina, original listing
Phone: (252) 355-3129
Office Phone: (252) 355-3129
Agent Name: AMANDA HIGHTOWER
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