Title Page Background
DEBUG FN args: Array ( [0] => 1900 [1] => [2] => [3] => agent ) BEFORE: Site: 1900 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1900 Igate: njhud LocID: 1900 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 = 1900 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] => 1900 [1] => [2] => [3] => lender ) BEFORE: Site: 1900 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1900 Igate: njhud LocID: 1900 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 = 1900 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] => 1900 [1] => [2] => [3] => other ) BEFORE: Site: 1900 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1900 Igate: njhud LocID: 1900 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 = 1900 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;
<< Go Back | All Foreclosures | | | All Cities

3107 Ocean Drive
Emerald Isle, NC 28594
Mary Cheatham King team with Keller Williams Crystal Coast, original listing - (252) 515-7291
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $3,699,900
Beds: 6
Baths: Full: 9, ½: 1
Status: Active
SqFt: 6238 Square Feet
Agency: Keller Williams Crystal Coast
Agency Phone: (252) 515-7291

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Come experience this Oceanfront ''Bliss by the Beach'' gem with over 6000 sq ft, featuring a pool, hot tub and amazing water views in all directions! This fully furnished home has an elevator to all floors, handicap accessible suite and ramp, and also has proven vacation rental income! Recent updates include: freshly painted interior and exterior; replacement of HVAC units; added a hot tub; changed some furniture, sofas, bedspreads, artwork; added a new grill; replaced TV's. Great spaces inside and out make this home a true gem with plenty of room to gather or spread out and find a quiet spot to enjoy the ocean breezes. Top floor offers four bedroom and bath suites for multiple primary suites, a flexible use room, oceanside balcony and a covered porch overlooking the water. Second floor features: a spacious ocean view living room with a fireplace and built-ins; a dedicated dining space with water views; a gourmet kitchen with island seating and double the stainless steel appliances; den or home office; two additional guest bedrooms; baths and a 1/2 bath for guests. Large waterside decking extends the living space to capture ocean breezes and tranquil views. The first floor recreation room has a wet-bar; a media room for movie nights; a full bath; large walk-in closet for storage and oceanside decking to the patio surrounding the inground pool. Outdoor spaces really shine with: handicap accessible ramp; ample covered porches, balconies, patio, in-ground swimming pool with fencing, boardwalk to the beach and a carport for parking. This home is a must-see for enjoying the coastal life-style! Notes: Please see the attorney drafted document concerning the ocean frontage; the linens do not convey
MlsNumber: --
ListingId: 100498725


Listing Provided By: Keller Williams Crystal Coast, original listing
Phone: (252) 518-5222
Office Phone: (252) 515-7291
Agent Name: Mary Cheatham King team
Disclaimer: Copyright © 2025 Hive MLS / Carteret County 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] => carteret [3] => NC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: carteret State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: carteret 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 = 1900 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;
Sandra Johnson
ASCIICrystal Coast Realty Group
Call Today!: (252) 269-3434

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App