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

1771 Serena Dr.
Myrtle Beach, SC 29579

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,400,000
Beds: 5
Baths: 7
Status: Active
SqFt: 5753
Agency: Berkshire Hathaway HomeServices Myrtle Beach Real

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: There are only a few more opportunities to build and live in your dream home in Riviera Village directly on the Intercoastal Waterway. Lot 82 Grand Dunes watches the sunrise and sunset, up and down the Intracoastal Waterway. The designer has detailed a glorious 5 bedroom, 5 full bath, 3 half bath home to be built, and it will have conveniences and features that comfort and excite the lucky owners of this amazing property! This property has views of the Intracoastal Waterway, along with endless vision for multiple bonus spaces that can be used for an art studio, office, game room or fitness studio. Each space includes a large open room with a private bedroom, walk in closet, private bathroom, and powder room just off of the large open spaces. The landscape architect has planned a resort-style oasis in the backyard that will not disappoint even the most selective buyers. The home specifications include all the amenities that a property of this magnitude can afford; including a sauna, private multiple tier pool, hot tub/spa, elevator, and multiple fire places and a full outdoor kitchen to name a few. The new owner will be able to have as much or as little input with the interior design finishes and selections. If a gourmet kitchen, expansive ceilings, molding, trim, custom woodwork throughout, along with designer features, cabinetry, tiles, mosaics, and hardwood floors are what you have visioned for your Myrtle Beach Home, then 1771 Serina Dr is waiting for you to make your own. This home can be exactly how you envision the space. The owners at Grande Dunes can enjoy the private 2200-acre amenity rich development. The Ocean Club offers oceanfront pools with food & beverage service, along with meeting rooms and countless activities. Additionally, the community has an 18-hole golf course, dining, pro shop, along with several on-site restaurants, deep water marina, a Har-Tru tennis facility with a pro store and miles or biking/walking trails! The design team and developer look forward to meeting you when you are ready to explore the countless options this home has and visit one of the best lots in Myrtle Beach SC.
MlsNumber: 2303052


Listing Provided By: Berkshire Hathaway HomeServices Myrtle Beach Real, original listing
Name: Berkshire Hathaway HomeServices Myrtle Beach Real
Phone: (843) 449-9444
Office Name: BHHS Myrtle Beach Real Estate
Office Phone: (843) 449-9444
Agent Name: Patrick Zarcone
Disclaimer: Copyright © 2024 Coastal Carolina 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 = 2340 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;
Sandy Hartman
ASCIIRealty One Group Dockside
Call Today!: (443) 995-2767

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App