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

149 Low Tide Court
Charleston, SC 29492
Taylor Charpia with The Boulevard Company, LLC, original listing - (843) 723-1988

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,450,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: --
Agency: The Boulevard Company, LLC
Agency Phone: (843) 723-1988

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Nestled along the picturesque Wando River in the heart of the Lowcountry, this classic executive home embodies the essence of coastal living. With four bedrooms and four bathrooms spread across 2,842 square feet, this residence offers ample space for both relaxation and entertaining.As you step inside, you'll be greeted by rich hardwood floors that run throughout the home, abundant natural light streaming through numerous windows, and soaring ceilings that enhance the sense of openness.Just off the foyer, a versatile flex space awaits behind elegant French doors. Currently serving as a light-filled office, this room features stunning wainscoting, crown molding, and baseboards, making it equally suitable for use as a formal dining room. The foyer leads into an expansiveliving area, anchored by a striking gas fireplace and custom built-in cabinetry. A large sliding glass door at the rear of the living room opens fully to reveal a spacious screened porch and deck, seamlessly blending indoor and outdoor living.<br /> <br /> The chef's kitchen is designed to impress, boasting a large island with bar seating, custom lighting, stainless steel appliances, a walk-in pantry, and a mix of glass-front and solid cabinetry for ample storage. Adjacent to the kitchen, a dining area overlooks the porch, deck, and tranquil water views, creating a serene backdrop for every meal.<br /> <br /> The home features an elevator accessible from the garage (which provides ample space for at least four cars) and serves all levels of the residence, offering convenience and easy access throughout the home.<br /> <br /> Upstairs, just off the landing, a cozy space perfect for a library or media room provides access to an outdoor porch. Two secondary bedrooms on this level share a Jack-and-Jill bathroom, while the primary suite offers a private sanctuary. This luxurious retreat features beamed ceilings, abundant natural light, a walk-in closet with custom shelving, and an en-suite bathroom with a soaking tub, dual vanities, and a walk-in shower.<br /> <br /> The outdoor spaces are equally captivating, offering scenic views that will inspire daily. Whether enjoying your morning coffee on the deck or hosting a sunset gathering, the waterfront setting provides an unparalleled backdrop. The property includes a dock with a covered pavilion and a floating dock, complete with deep-water access for boating enthusiasts.<br /> <br /> Every detail of this beautifully appointed home has been thoughtfully designed to create a seamless blend of luxury and comfort. Located in a vibrant community, this property offers the perfect combination of Lowcountry elegance and modern convenience, making it an ideal retreat for those seeking a harmonious lifestyle surrounded by natural beauty. With close proximity to Charleston, Mt. Pleasant, and both I-26 and I-526, this property is located in the center of it all. Book your showings today!
MlsNumber: --
ListingId: 24030680


Listing Provided By: The Boulevard Company, LLC, original listing
Phone: (843) 723-1988
Office Phone: (843) 723-1988
Agent Name: Taylor Charpia
Disclaimer: Copyright © 2024 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 = 2321 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;
Jason Petteway
ASCIIeXp Realty
Call Today!: (206) 853-1979

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App