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

107 Regency Circle
Merry Hill, NC 27957
Gayle King with CarolinaEast Real Estate, original listing - (252) 312-6154

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $789,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2400 Square Feet
Agency: CarolinaEast Real Estate
Agency Phone: (252) 312-6154

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: .Located in the stunning gated community of Occano, this modern farmhouse new construction model home offers an open floor plan and one level living. Designed by Allison Ramsey Architects, this exceptional custom home is designed with large open spaces and privacy when guests are visiting. An open divided foyer separates the home into two wings. The primary bedroom is in the left wing. The primary bedroom also has an entrance from the interior, the front and rear of the home. The primary bath has a step in shower, double vanities and a soaking tub. Your guests will enjoy privacy in their own suites in the right wing of the home, each with their own bathroom and walk-in closet. Experience tranquil views from every room of the house. The great room with its vaulted ceiling and is met with the gourmet kitchen and room for a large farm table. Step through rear doors to an open covered porch and take in the views of a large fishing pond to the rear. Sit on the front porch and watch the golfers drive by on their golf carts and tee off from the 12 hole. Occano is a gated community offering membership to the Arnold Palmer 18 hole golf course, outdoor swimming pool, tennis courts/Pickleball courts, a marina, boat launch, boat storage and private beach. The community is a golf cart friendly community. The Club membership is optional. Occano is located 20 minutes from Edenton and approx an 1.5 hours to Virginia Beach and an hour from the OBX.<br /> Required disclosure:Obtain the property report required by federal law. No federal agency has judged the merits or value of this property.
MlsNumber: --
ListingId: 100468235


Listing Provided By: CarolinaEast Real Estate, original listing
Phone: (703) 980-5334
Office Phone: (252) 312-6154
Agent Name: Gayle King
Disclaimer: Copyright © 2024 NCRMLS/ 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App