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

5533 Ashlyn Drive
Castle Hayne, NC 28429
Tracy Lewchuk with Coldwell Banker Sea Coast Advantage, original listing - (910) 799-3435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $875,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2758 Square Feet
Agency: Coldwell Banker Sea Coast Advantage
Agency Phone: (910) 799-3435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Welcome to this elegant custom home with a secluded, peaceful homesite on approximately 1.69 acres and a completely turnkey interior. Set at the end of a cul-de-sac in a quiet section of Castle Hayne, the location is a short drive to a variety of restaurants, shops, local beaches and Downtown Wilmington - the home is minutes away but worlds apart. A wrap-around front porch creates<br /> a welcoming atmosphere for this home with a unique floor plan offering 1993 heated living space and an additional 765 square feet above the 4 car garage giving any family plenty of growing room. The classy lead glass entry door exudes sophistication, custom millwork and moldings and designer window treatments add to the elegance of this property. Custom built in 2005, the residence features a flowing, open floor plan with vaulted ceilings, hickory wood floors in most of the living areas, an expansive bonus room with a free standing wet bar, a home theater and abundant garage space for six vehicles. There are 6 individual garage bays for vehicles, toys, workshop, home gym, craft space, additional storage - the possibilities are endless. The oversized windows in the great room bring abundant natural light into the space. The French doors open to a covered patio overlooking a completely fenced, private section of the backyard. Separated from the great room by a breakfast bar with counter seating, the kitchen features custom wood cabinetry, ample counter space, pendant lighting and all appliances included. Airy and bright, the kitchen is open to a breakfast nook with a bay window and adjacent to a large formal dining room. Two generous secondary bedrooms, a laundry room and a spacious primary suite complete the floor plan of the main home. Certain to impress, the primary suite includes a large sitting area, a walk-in closet, dual sinks, dual shower heads and custom pebble stone flooring in the walk in- shower. A breezeway connects the main home to the bonus room and theater over the four-car garage consisting of 765 additional living space, which is not listed in the heated total square footage. This space offers a half bath, sink, cabinets and ample living space, the bonus room/theater room could be easily converted into a one-bedroom apartment, teenager or mother-in-law suite. Custom lighting, a large 73" TV and an integrated Bose surround sound system that can be negotiated for purchase could make the theater move-in ready for the new owner. The home shows meticulous attention to detail throughout. Other features include an oversized two car garage with walk upstairs to a floored attic space, a whole house generator, dehumidifier, water softener by Culligan, ADT security system, dual zone HVAC systems, hurricane shutters and/or Lexan on all windows and doors, the roof was replaced in 2022, a 500 gallon propane tank (leased), 50 amp plug for RV, operable Bahama shutters, epoxy floors in<br /> all garages, fire pit area, and a reverse osmosis water filtrations system. With ample garage space for a prized collection of vehicles and/or a yoga studio/fitness center/game room, a refined interior with space for multiple generations and a convenient yet quiet location, this is the ultimate legacy property. Schedule your private showing today.
MlsNumber: --
ListingId: 100474972


Listing Provided By: Coldwell Banker Sea Coast Advantage, original listing
Phone: (910) 799-3435
Office Phone: (910) 799-3435
Agent Name: Tracy Lewchuk
Disclaimer: Copyright © 2024 Hive MLS / Cape Fear Realtors MLS, Inc. 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 = 1949 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 Linda Thomas
Linda Thomas
ASCII1st Class Real Estate Coastal Choice
Call Today!: (508) 958-3576

Local Mortgage Pro

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 = 1949 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;
Real Estate Expert Photo for Eric Coomes NMLS #2356937
Eric Coomes NMLS #2356937
ASCIIAlcova Mortgage
Call Today!: (704) 488-1770

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App