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

968 Ashburton Road Se
Bolivia, NC 28422
Charlene Cole with Southern Realty Advantage LLC, original listing - (910) 933-6223

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3108 Square Feet
Agency: Southern Realty Advantage LLC
Agency Phone: (910) 933-6223

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Welcome to this stunning 3-bedroom, 3.5-bath luxury home in the amenity-rich RiverSea Plantation, built in 2023 with impeccable craftsmanship and thoughtful design. The open-concept living, dining and kitchen area is truly the heart of the home, offering an airy, light-filled space perfect for gathering and entertaining. The living room features soaring ceilings open to the second floor, custom gas logs and large windows that bring the outdoors in. The dining area includes plantation shutters and tray ceiling for a touch of elegance, while the chef's kitchen is a masterpiece, boasting an oversized island, upgraded stainless steel appliances, a Wolf propane cooktop with hood, stainless farm sink, and premium quartz countertops. Ample soft-close cabinetry, slide-out drawers and a walk-in pantry complete this culinary space. Just off the main living area, the primary suite offers a private retreat, featuring a tray ceiling, double walk-in closets with ventilated wood shelving, plantation shutters and a luxurious ensuite bath with double vanity and tiled walk-in shower. Upstairs, you'll find 2 bedrooms, each with its own bath, along with a spacious bonus room perfect for an office, media room, 4th bedroom or extra living space. Relax on the inviting front porch or Carolina room, both finished with charming wood tongue-and-groove ceilings, and take in the lush, professionally landscaped yard. Other highlights include a large office with barn doors on the main level, upgraded lighting and fixtures throughout, a roomy laundry room, abundant storage, and an oversized 2-car garage with an epoxy floor. The beautifully landscaped yard includes an irrigation system to maintain its lush appearance and has room to add your own private pool. Only 12 minutes from Holden Beach, this home perfectly balances luxury, convenience, and comfort in one of the area's most desirable communities. Make your appointment today before it is gone.
MlsNumber: --
ListingId: 100475246


Listing Provided By: Southern Realty Advantage LLC, original listing
Phone: (910) 933-6223
Office Phone: (910) 933-6223
Agent Name: Charlene Cole
Disclaimer: Copyright © 2024 Hive MLS / Brunswick 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 = 1894 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 Sarah Lattanza
Sarah Lattanza
ASCIICoastal Carolina Real Estate Group
Call Today!: (724) 777-9912

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App