Title Page Background
DEBUG FN args: Array ( [0] => 1958 [1] => [2] => [3] => agent ) BEFORE: Site: 1958 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1958 Igate: njhud LocID: 1958 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1958 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1958 [1] => [2] => [3] => lender ) BEFORE: Site: 1958 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1958 Igate: njhud LocID: 1958 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1958 AND i.igate IN ('cihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1958 [1] => [2] => [3] => other ) BEFORE: Site: 1958 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1958 Igate: njhud LocID: 1958 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1958 AND i.igate IN ('cihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4120 W Wilson Street
Farmville, NC 27828
KEVIN LEE with RE/MAX PREFERRED REALTY, original listing - (252) 355-5006

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $536,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2682 Square Feet
Agency: RE/MAX PREFERRED REALTY
Agency Phone: (252) 355-5006

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Proudly sitting on nearly an acre of beautiful land, a home crafted in 2021 with a level of custom detail that makes it better than new. The craftsmanship speaks for itself. Elegant trim work frames every space, and the layout flows with effortless grace, offering both comfort and luxury. The heart of the home a chef's kitchen, where a grand island anchors the space. Outfitted with top-of-the-line Bosch stainless steel appliances, including a double full-size oven, a sleek gas cooktop, and a custom-designed vent hood, it's made for both everyday cooking and unforgettable gatherings.<br /> But the true surprise? A hidden pantry room. At first glance, it looks like a tall cabinet—but open it, and you're welcomed into an enormous, secret walk-in pantry that's as functional as it is fun. The primary suite is a peaceful retreat with generous proportions, his and her walk-in closets, and private access to the laundry room. The ensuite bathroom offers a spa-like experience, complete with a large walk-in shower and a freestanding statement tub that begs for long soaks.<br /> The great room sits at the center of the home, a warm, welcoming space with a fireplace flanked by custom cabinetry and floating shelves. Entertaining is easy thanks to the built-in wet bar, perfect for evening cocktails or weekend brunches. Two additional bedrooms are thoughtfully connected by a Jack-and-Jill bathroom, providing privacy and practicality. Upstairs, a finished bonus room over the garage opens up possibilities—media room, office, guest space, you name it. Just off the garage, a well-designed mudroom with a powder bath and built-in coat hooks keeps things tidy and organized. Even the garage shines—spotless, spacious, and meticulously maintained.Step outside and you'll understand what makes this property truly special. The expansive yard stretches wide, offering space to breathe, play, and relax. At its heart: a stunning patio with a built-in fireplace, the perfect spot to gather under the stars.
MlsNumber: --
ListingId: 100505533


Listing Provided By: RE/MAX PREFERRED REALTY, original listing
Phone: (252) 355-1238
Office Phone: (252) 355-5006
Agent Name: KEVIN LEE
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