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

222 Haddrell Street
Mount Pleasant, SC 29464

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,375,000
Beds: 5
Baths: 4
Status: Active
SqFt: --
Agency: The Cassina Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2014
Notes: Welcome to this magnificent waterfront property, offering approximately 4,000 sqft of luxurious living space. This stunning residence, designed by architect Hunter Kennedy and built by Richie Johnson, boasts unparalleled craftsmanship and attention to details throughout the home.With 5 bedrooms and 3.5 baths, this home provides a spacious and comfortable environment for both family living and entertaining. The expansive living areas feature 10ft ceilings both up and down, creating an open and airy atmosphere throughout.One of the standout features of this property is the primary bedroom. The windows offer views of the pool and floods the room with an abundance of natural light. As you lay your head down and face north, Hunter Kennedy's thoughtful design shines through with a corner window, providing a picturesque vista of the marshland. This carefully crafted space invites you to start your mornings immersed in the beauty of nature, creating a tranquil and rejuvenating retreat within the comfort of your own home.<br /> <br /> <br /> <br /> As you step outside, you'll discover a pool with an 8.5ft deep end, perfect for refreshing dips and entertainment. The pool house's grill cabinet, built by Guy Ando, consists of solid mahogany with a soapstone top, for further enjoyment outdoors with the convenience of an outdoor grilling area.<br /> <br /> <br /> <br /> With approximately 1,000 sqft, the covered porches are 12'+ wide and contain a 3' roof overhang. The four sets of french doors in the indoor living area open to the screened porch to fully let the outdoor area incorporate the interior space. You are able to embrace the wood-burning fireplace outside as it adds warmth and charm to the outdoor living area. Additionally, beyond the porch, a 40ft true deep water boat slip on Shem Creek offers direct access to the water for boating enthusiasts.<br /> <br /> <br /> <br /> This residence seamlessly combines comfort, style, and functionality, making it an ideal haven for those seeking the ultimate waterfront lifestyle. Immerse yourself in the serene surroundings, where every detail has been meticulously designed to enhance the enjoyment of coastal living. Make this waterfront property your own, where luxury meets the Lowcountry charm, and endless possibilities await.
MlsNumber: 24001325


Listing Provided By: The Cassina Group, original listing
Name: The Cassina Group
Phone: (843) 628-0008
Office Name: The Cassina Group
Office Phone: (843) 628-0008
Agent Name: Robertson Allen
Disclaimer: Copyright © 2024 Charleston Trident 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 = 2324 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;
Margaret Loos
ASCIIeXp Realty LLC
Call Today!: (843) 270-4252

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App