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

221 Chicora Ln
Yemassee, SC 29945
Charleston Customer Service and Warranty with D.R. Horton - Charleston, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $439,215
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2159 Square Feet
Agency: D.R. Horton - Charleston
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Experience the Habersham floor plan, by America's Builder, DR Horton. This plan is the epitome of low country living with double front porches and immaculate curb appeal. As you walk through the front door, the openness of these 4 bed, 3 bath home is evident. The oversized guest room and full bath on the main are tucked away as a private suite. The main floor also showcases a large dining space, and a great room that is open to the chef's kitchen with massive pantry and storage. Step out onto the back patio to reconnect with nature, as you stare out over dense woods and stunning oak trees dripping with Spanish moss in this picturesque low country setting. There is also a roomy storage area off of the back patio. At the top of the stairs you'll find a laundry room, 2 additional guest rooms, and an enormous owner's suite with a closet and bath room that are beyond ordinary. The real magic of this room is the two French doors leading out to the full 2nd floor front porch! What a dream! All new homes will include D.R. Horton's Home is Connected package, an industry leading suite of smart home products that keeps homeowners connected with the people and place they value the most. This technology allows homeowners to monitor and control their home from the couch or across the globe. Products include touchscreen interface, video doorbell, front door light, z-wave t-stat, keyless door lock all controlled by included Alexa Dot and smartphone app with voice! *Square footage dimensions are approximate. *The photos you see here are for illustration purposes only, interior, and exterior features, options, colors and selections will differ. Please reach out to sales agent for options.
MlsNumber: --
ListingId: 51271+510-51271-512710000-0044


Listing Provided By: D.R. Horton - Charleston, original listing
Phone: (843) 284-5000
Agent Name: Charleston Customer Service and Warranty
Disclaimer: Copyright © 2025 D.R. Horton. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App