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

4824 Middle Road
Trenton, NC 28585

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths: 3
Status: Active
SqFt: 4067
Agency: ERA KINSTON REALTY GROUP

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential
Year Built: 1997
Notes: Seeing is believing-so come take a look! This treasure could be YOUR dream come true! Beautiful brick home on 40 acres (mostly cleared) with 2 ponds AND 2 large outbuildings to boot! Gorgeous hardwood floors beneath rival the splendor of the tray ceilings above. <br /> <br /> Great attention to detail in this home with keystone arched doorways, custom window treatments, crown moldings and an ornate fireplace mantel with fluted columns and dentil molding. <br /> <br /> Lots of places to gather-large formal living room, cozy den, spacious kitchen with a dining area encased by floor to ceiling windows! Just off the den, you will find the perfect office space for those able to work from home nowadays. Next, head upstairs to the larger-than-life game room with paneled wood ceilings. So much room to spread out upstairs with a third bedroom, half bath and a large bonus room that could serve a variety of purposes. Come and go via covered porches on front AND back that provide expansive panoramic views. Relax while watching a spectacular sunset or the occasional sightings of geese, ducks or deer that come and go. Immaculately cared for lawn offers blooms and colored foliage practically year-round! Never worry about inclement weather raining on your parade with the full-house Generac generator. Such a unique land/home package deal that comes along once in a lifetime. Don't let it slip through your fingers! Perfectly positioned about halfway between the capital, Raleigh and the coast. Multiple smaller airports nearby as well in New Bern and Jacksonville.
MlsNumber: 100416680


Listing Provided By: ERA KINSTON REALTY GROUP, original listing
Name: ERA KINSTON REALTY GROUP
Phone: (252) 526-0400
Office Name: KINSTON REALTY GROUP
Office Phone: (252) 526-0400
Agent Name: ANGIE HARRISON POTTER
Disclaimer: Copyright © 2024 NCRMLS/ 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