Title Page Background
DEBUG FN args: Array ( [0] => 1956 [1] => [2] => [3] => agent ) BEFORE: Site: 1956 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1956 Igate: njhud LocID: 1956 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 = 1956 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1956 [1] => [2] => [3] => lender ) BEFORE: Site: 1956 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1956 Igate: njhud LocID: 1956 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 = 1956 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1956 [1] => [2] => [3] => other ) BEFORE: Site: 1956 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1956 Igate: njhud LocID: 1956 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 = 1956 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

107 Chowan Circle
Hertford, NC 27944
Steve Wentz with AP Realty Company, LLC, original listing - (252) 426-4653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,025,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4809 Square Feet
Agency: AP Realty Company, LLC
Agency Phone: (252) 426-4653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: Stunning Waterfront Golf Course Home in Albemarle Plantation<br /> Welcome to your dream home, perfectly situated on a quiet cul-de-sac with breathtaking views of the water, golf course, and marina. This elegant all-brick, custom-built residence has been lovingly maintained by its original owner and offers over 4,800 square feet of thoughtfully designed living space.<br /> Step inside to soaring ceilings, exquisite moldings, and an abundance of natural light streaming through the expansive wall of windows—capturing the picturesque scenery. The open-concept kitchen flows seamlessly into the great room, featuring custom cabinetry, built-ins, and a cozy gas-log fireplace for chilly evenings. A formal dining room, also adorned with built-ins, adds a touch of sophistication.<br /> The first-floor primary suite is a serene retreat, boasting a spacious en-suite bath. A guest suite on the main level offers convenience and privacy, while two additional en-suite bedrooms upstairs each include cedar-lined closets and private baths—both showcasing spectacular views. A unique bonus room with cedar-plank tongue-and-groove ceilings and skylights provides versatile space for an office, studio, or entertainment area.<br /> Outdoor living is unparalleled here. Enjoy gentle Southern breezes from the balcony, deck, or grilling patio, all overlooking lush landscaping, a private fishpond, and the tranquil waterfront. The home is equipped with a security system, a sprinkler system, a whole-house generator hookup, and ample storage, including a walk-in attic and an oversized two-car garage.<br /> Nestled in the prestigious Albemarle Plantation, this master-planned community offers resort-style amenities, including a 166-slip marina, championship golf course, clubhouse, two restaurants, a fitness and community center, tennis and bocce courts, and a sparkling pool. Enjoy waterfront dining at the charming Dockside Café—just a short walk away.<br /> Don't miss this rare opportunity to own a premier home in an unbeatable
MlsNumber: --
ListingId: 100495003


Listing Provided By: AP Realty Company, LLC, original listing
Phone: (252) 339-5735
Office Phone: (252) 426-4653
Agent Name: Steve Wentz
Disclaimer: Copyright © 2025 Hive MLS / Albemarle Area 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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => perquimans [3] => NC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: perquimans State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: perquimans State: NC 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 = 1956 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Stephanie Forloines
Stephanie Forloines
ASCIIBerkshire Hathaway HomeServices
Call Today!: (757) 751-5571

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App