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

143 Azalea Court
Swansboro, NC 28584
Teresa & Bucky Smith Team with Bluewater Real Estate - EI, original listing - (252) 354-5921

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3662 Square Feet
Agency: Bluewater Real Estate - EI
Agency Phone: (252) 354-5921

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Over an Acre, directly on the White Oak River! In-Ground Pool, Community Boat Dock, Your Own Private Boat Slip, 3 Bedrooms, Master Suite on Main Floor, Open Living Room, Sitting Area for Magnificent Views, Formal Dining Room, Kitchen Open to Breakfast Area, Huge Room Over the Garage, Beautiful Wooden Floors, Screened-In Porch, Large Open Deck, Covered Porch off the Master Bedroom and Sitting Room, Large Patio for Entertaining, Whole House Generator w/500-gallon Buried Tank, Hurricane Shutters, Fence, Detached Garage with Shop Area and Storage Area, Moisture Barrier Installed, Retaining Wall, Grand Front Porch and Beautifully Landscaped Yard. What more could you be looking for? Private Waterfront Community with dues of only $975 a year. Located only minutes from the Beaches of Emerald Isle. Award winning schools, close to shopping, restaurants, medical facilities, and more... Fishing, Golfing, Boating, Hunting, Swimming and Beach Activities. Western Park for numerous kid's sports,<br /> and the Gym, for those who love to work out. Historic Swansboro 5 minutes away by boat and only minutes away by driving. Sit out on your deck on the Fourth of July and watch Fireworks from Swansboro and neighboring waterfront communities across the river. Jump in your boat and catch your evening dinner or stop by a local fish market if luck wasn't with you. Many locals head out towards the sound, where they can stop on a vacant sand bar to enjoy relaxation and solitude, while others head to their favorite spot for their dogs play time.<br /> Emerald Isle, one of the largest beach municipalities in NC, about a 10-minute drive or less, depending on traffic, and has all sorts of entertainment, including the yearly St. Patrick's Day Festival., Beach Music Festival, Emerald Isle Marathon, Fishing Tournaments Don't forget Historic Beaufort, about a 30-minute drive away. So much to do, such beautiful water views, this could be you very own Dream Home!
MlsNumber: --
ListingId: 100463060


Listing Provided By: Bluewater Real Estate - EI, original listing
Phone: (252) 354-2128
Office Phone: (252) 354-5921
Agent Name: Teresa & Bucky Smith Team
Disclaimer: Copyright © 2024 NCRMLS/ 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

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 = 1951 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;
Kim Fasching
ASCIIeXp Realty
Call Today!: (910) 382-6911

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App