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 ('pahud','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 = 'pahud', 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 ('pahud','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 = 'pahud', 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 ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3411 Charter Oaks Drive
Farmville, NC 27828
Caroline Johnson with Caroline Johnson Real Estate Inc, original listing - (252) 717-6253

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 4
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5603 Square Feet
Agency: Caroline Johnson Real Estate Inc
Agency Phone: (252) 717-6253

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Absolutely Stunning & Like New, Custom-Built Home w/ No Expense Spared & Fully Furnished (Everything Included)! This 4 Bedroom/5.5 Bath Beauty w/ Bonus/Theater Room & 4 Temperature Controlled Garages w/ Epoxy Floors has ALL the Bells & Whistles Throughout! The Gorgeous Kitchen Boasts Top-of-the-Line Thermador Appliances Plus Sub-Zero Refrigerator, Quartz Counters & Large Island Bar, Tile Backsplash/Floors, Pot Filler, Farmhouse Sink, & Walk-Thru Pantry Room. Desirable Open Floorplan b/t Kitchen & Living Room w/ Coffered Ceiling & Built-ins Plus Formal Dining Room w/ Wainscoting. The Spa Inspired Owner's Suite Features Walk-in Closet w/ Custom Cabinetry & Built-in Dressers Plus Dazzling Owner's Bath Offers Walk-Through Tile Shower with Body Jets, Freestanding Tub, Two Vanities, & Private Water Closet. All 4 Bedrooms are Located on 1st Floor w/ Ensuite Baths & Heated Tile Flooring. Venture Upstairs via the Lighted Staircase to the Bonus/Theater Room Which Includes Pool Table, Theater Seats, Equipment, & Additional Full Bath. Live Large Outdoors Under the Covered Back Porch Well Equipped with an Outdoor Kitchen Including Kamado Joe Grill, Aspire Gas Grill, Hoshizaki Ice Maker, & Beverage Cooler. The Covered Lounge Area has Brick Accented Fireplace. Take a Plunge in the Concrete Saltwater & Heated Pool with Sun Deck and Hot Tub, Jets, Color Changing Lights, Slide, & Diving Board. Other Outdoor Features: Conditioned Pool House w/ Full Bath, Brick Wood Burning Fireplace, Tons of Travertine Decking, & Brick Privacy Fence. Other Extras Include: Brazilian Cherry Wood Floors, Speaker/Sound System in Multiple Rooms & Outside, Spacious Laundry Room with Cabinetry & Sink, Plantation Blinds, Security System, 8 Ft. Interior Doors, Built-in Drop Zone Area, (2) Tankless H20 Heaters, Dehumidifier in Lighted Crawlspace, Tons of Outdoor Lighting, Walk-in Attic Storage, Professional Landscaping w/ Numerous Crepe Myrtles & Rose Bushes, & So Much More! Unbelievably Amazing Inside & Out!
MlsNumber: --
ListingId: 100487856


Listing Provided By: Caroline Johnson Real Estate Inc, original listing
Phone: (252) 717-6253
Office Phone: (252) 717-6253
Agent Name: Caroline Johnson
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