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

1702 Palmetto Boulevard
Edisto Island, SC 29438
Johnny Black with Edisto Sales & Rentals Realty, original listing - (843) 869-2527

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,800,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: --
Agency: Edisto Sales & Rentals Realty
Agency Phone: (843) 869-2527

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Luxurious high-quality custom home in a Prime Oceanfront Location! Experience beachfront living like never before with spectacular views, a spacious design and modern amenities at every turn! The minute you step inside the front door you will be impressed! A wide entrance foyer greets you that flows into a spacious great room with 2 separate seating areas surrounded by windows & breathtaking views of the water! The gourmet kitchen with bay window features beautiful cabinetry, stainless appliances, granite countertops & a large central island! There's plenty of seating in the dining area and also stool seating at the island! Everyone will love relaxing on the expansive beachside porch enjoying the cool seabreezes & there is also an open deck for the sun lovers in your group!... The main level features a large oceanside Bedroom with walk in bathroom, 2 guest Bedrooms, each with a private Bath, walk-in laundry room including ice maker & extra refrigerator, 1/2 bath and a residential home elevator with access to all floors for your convenience!<br /> From the main floor, head upstairs and you'll enter a Den/Entertainment Room that opens out to a full length covered beachside porch. You'll be mesmerized by the endless ocean views & the soothing sounds of the surf! This upstairs level has 2 expansive oceanfront Bedrooms with private baths and a street side Bedroom with 2 sets of built-in Bunkbeds with full bath that's sure to be a hit with the younger crowd! <br /> Underneath the house there's plenty of parking & seating and also gravel parking in front & the sides. There's a large storage room for all of your recreational toys & an enclosed outdoor shower to use after after a fun day on the water! The backyard is fenced and beautifully landscaped & makes a great place for entertaining & cookouts! It also has its own private boardwalk to the beach!<br /> Some of the numerous features in this great home include pine floors throughout the house, custom tile baths, large walk-in private owner's closet, a new standing seam metal roof, Bahama shutters, hardie plank siding, new exterior paint, beadboard & shiplap, surround sound system, upgraded lighting, smart locks, dry entrance from the ground level & much more! <br /> This wonderful 6 Bedroom, 6.5 Bath home will easily accommodate your whole crowd and is truly a rare find! It comes fully furnished with quality items & attractive decor. It it is an excellent rental property with over $186,000 in gross income booked so far in 2025! This is a good one... Don't miss it!
MlsNumber: --
ListingId: 25008486


Listing Provided By: Edisto Sales & Rentals Realty, original listing
Phone: (843) 869-2527
Office Phone: (843) 869-2527
Agent Name: Johnny Black
Disclaimer: Copyright © 2025 CHS Regional MLS. 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 = 2329 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Donna Urban
Donna Urban
ASCIIThe Agent Owned Realty Co.
Call Today!: (843) 830-2913

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App