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','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;

2846 Salvador Way
Castle Hayne, NC 28429

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $819,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3010
Agency: Coldwell Banker Sea Coast Advantage

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Nestled in the new Sunset Reach community, the exquisite Lumina Island by Kent Homes is ready for you to call home. With enchanting views of the expansive 12-acre lake, this home promises a haven of tranquility and luxury. Elegance and functionality merge seamlessly in this thoughtfully designed layout. The great room, kitchen, dining area, and enclosed loggia with bi-parting doors create a harmonious space for entertaining guests or enjoying cherished moments. The well-appointed kitchen boasts an expansive entertainment island, adorned with quartz countertops, a stainless steel gas cooktop, wall oven, and under-cabinet hood. A 'messy kitchen' and a spacious walk-in pantry keep clutter out of sight. The inviting great room features a stunning fireplace flanked by custom built-ins, providing a cozy retreat. Retreat to your private oasis at the back of the home, ensuring peace and relaxation. The primary suite graces you with beautiful trey ceilings and easy access to the laundry room for added convenience. The spa-like ensuite bathroom offers a fully tiled walk-in shower, double vanity with quartz countertops, and a private water closet. An additional bedroom and a study complete the first floor. Upstairs, do not miss the bonus room with a 210 sq foot covered balcony, which overlooks the lake. Another bedroom and full bath can be found on this level. Kent Homes takes pride in delivering superior craftsmanship, from the finest materials to meticulous attention to detail. This home incorporates energy-efficient features and smart systems, ensuring lower utility bills and a reduced environmental footprint. Sunset Reach is a brand-new gated, riverfront community, conveniently located 10 minutes from downtown Wilmington by boat or car. Residents can enjoy the completed walking and biking trail, as well as kayaking on the serene interior lake. Future amenities include a riverfront marina with boat slips for purchase, community pool with clubhouse, and a pickleball court.
MlsNumber: 100413604


Listing Provided By: Coldwell Banker Sea Coast Advantage, original listing
Name: Coldwell Banker Sea Coast Advantage
Phone: (910) 799-3435
Office Name: Coldwell Banker Sea Coast Advantage
Office Phone: (910) 799-3435
Agent Name: Team Thirty 4 North
Disclaimer: Copyright © 2024 NCRMLS/ 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','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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 Christina Russell
Christina Russell
ASCIIReal Broker-Aimee and Co.
Call Today!: (910) 612-9427

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App