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

42158 Askins Creek Drive
Avon, NC 27915
Trisha Midgett with Midgett Realty - Rodanthe, original listing - (252) 986-6321

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 2080 Square Feet
Agency: Midgett Realty - Rodanthe
Agency Phone: (252) 986-6321

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20,500 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to your slice of coastal paradise! This stunning new construction in the sought-after Askins Creek subdivision is not just a house—it's your next beach escape. With 5 bedrooms and 4.5 bathrooms, this semi-sound front gem blends modern luxury with that laid-back beach vibe we all crave. Step into the upper level and be wowed by the open floor plan that effortlessly brings together the living, dining, and kitchen areas—perfect for gathering with friends and family after a day on the water. The custom kitchen is a chef's dream, featuring gleaming quartz countertops, ample storage, and soaring cathedral ceilings that make the space feel both grand and welcoming. The upper level also boasts a luxurious en-suite bedroom and a handy half bath for guests. Downstairs, the comfort continues with three more en-suite bedrooms and a fourth bedroom, offering everyone their own private retreat. And did I mention the elevator? No more lugging groceries or beach gear up the stairs—just easy living at its finest. But let’s talk about those views! The home's semi-sound front location means you’ll be treated to stunning vistas of the sound and sunsets that are nothing short of spectacular. Just imagine unwinding on your deck with a cold drink, watching the sky turn into a masterpiece of color. And the best part? You’re just a short stroll away from deeded beach access. Whether you’re into sunbathing, shell hunting, or simply feeling the sand between your toes, you’re going to love the easy beachside living this home offers. For the adventurous souls, ORV Beach Access Ramp 38 is right nearby, giving you year-round access to the pristine shores—whether you’re on foot or in your 4x4. Plus, you’re just minutes from the iconic Canadian Hole, where kite boarders and windsurfers come to play on the East Coast’s best waters. And when you’re ready to explore beyond the beach, Avon has it all—from the island’s only chain grocery store to top-notch restaurants, unique gift shops, a medical center, and the historic Avon Fishing Pier. This is more than just a home—it’s your ticket to the ultimate Outer Banks lifestyle. Don’t miss out on making it yours!
MlsNumber: --
ListingId: 126593


Listing Provided By: Midgett Realty - Rodanthe, original listing
Phone: (252) 986-6321
Office Phone: (252) 986-6321
Agent Name: Trisha Midgett
Disclaimer: Copyright © 2024 Outer Banks 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 = 1912 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;
Real Estate Expert Photo for Janel Hansen
Janel Hansen
ASCIIBerkshire Hathaway HomeServices
Call Today!: (703) 328-8028

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App