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;

1224 Riverbend Drive Sw
Shallotte, NC 28470
Denise Young with Coldwell Banker Sea Coast Advantage, original listing - (910) 842-1555

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,250,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 4769 Square Feet
Agency: Coldwell Banker Sea Coast Advantage
Agency Phone: (910) 842-1555

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Luxury waterfront property like no other! This home blends luxurious comfort with practical design, perfect for entertaining and everyday living so lets get to the upgrades & features: Grand entrance with a wall of tall windows to capture the amazing Views of the pool & Shallotte river! Brazilian Cherry hardwood floors, plantation shutters, 12' ceilings, Terracotta tile floors w/Radiant heat in kitchen & family room, formal dining room, beautiful light fixtures, crown molding, formal living room w/gas fireplace. Chef's dream kitchen featuring stainless appliances. Refrigerator/freezer (2021), large gas cooktop, double oven w/warming drawer, built in microwave, 2 drawer dishwasher, tile backsplash, granite ctops, huge island, walk-in pantry, beautiful wood cabinetry, breakfast area & family room All with the grand Views! Full bath on main floor, game room, home office, & 2 car garage w/Heat & Air + central vacuum! Covered back porch overlooking the saltwater heated pool w/spill over spa & new pavers (2024). Pier to dock w/ reinforced pilings (2019), double stone bulkhead, HVAC's (2020), Both water heaters (2019), irrigation, upgraded landscape lighting, whole house generator & more Back inside & upstairs to find a huge 2nd family room, 2 bedrooms with shared bath, custom wood shelving in all bedroom closets, 3rd bedroom w/ensuite. Large owners suite featuring double tray ceiling, private porch overlooking the Views, 2 walk-in closets, & an amazing spa-like bath! Separate vanities, deep soaking tub & walk-in tile shower plus heated Travertine tile floor. Laundry room (washer/dryer conveys) w/many cabinets, folding space & sink to complete the 2nd floor but don't forget about the many covered porches to capture the Views! 3rd floor is a huge walk-in attic that is heated & cooled + central vacuum there too. This incredible property has so many features to list! Your choice of beaches, golf courses, shopping & dining all within a few miles of this spectacular property!
MlsNumber: --
ListingId: 100478585


Listing Provided By: Coldwell Banker Sea Coast Advantage, original listing
Phone: (910) 444-8518
Office Phone: (910) 842-1555
Agent Name: Denise Young
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