This home's estimate is 49.8% higher than the average sale price ($538K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate







































623 Front St Unit 215 (2-B), Georgetown, SC 29440
About this home
Waterfront living just steps from incredible dining, shops, and the charismatic charm of historic, downtown Georgetown, SC. Georgetown was named one of USA Today's best coastal small towns two years in a row (2018, 2019). The unique setting of this 2 story, 4 bedroom, 4 bath villa provides a riverfront lifestyle as a year round home or a vacation getaway. Upon entering the gated Harborwalk Village, you're immediately drawn to the beautifully maintained courtyard garden. The villa itself is spacious with an easy flowing floor plan. The open living concept of the kitchen, family room and dining combined allows for comfortable together time or entertaining. Two masters (one on each level) are included as well as a large bonus room currently used as storage that could easily be an office, large closet/dressing room, playroom, or an additional bedroom. Enjoy boating, fishing or simply lounging on the 1st level screened porch or 2nd level master balcony overlooking the river with spectacular views abounding. Your designated boat slip will accommodate boats up to 11' beam by 35' length. Exceptional features throughout - this upgraded villa is one to see today! Assigned parking & shared elevator are also conveniences provided. All measurements are approximated and should be verified by the buyer.
Redfin Estimate
Earn from this home
List your home with Redfin and save $8,056
List your home for rent
Market trends in 29440, SC
Last updated September 2026
Buyer's Market
Seller's Market
Balanced market
- $1,649,0004 beds4.5 baths4,182 sq ft486 Debordieu Colony Lantana Cir, Georgetown, SC 29440(843) 443-9400
- OPEN SAT, 11AM TO 1PM
See all
Provided by Redfin
Sale history for 623 Front St Unit 215 (2-B)
$211/sq ft
$211/sq ft
$228/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Property details
Parking
- Parking
- Features: Assigned
Interior
- Bathroom Information
- # of Full Bathrooms: 4
- Room 1 Information
- Other
- Features: Bedroom on Main Level
- Room 2 Information
- Master Bedroom
- Features: Ceiling Fan(s), Walk-In Closet(s)
- Room 3 Information
- Master Bathroom
- Features: Bathtub, Double Vanity, Separate Shower
- Room 4 Information
- Kitchen
- Features: Kitchen Island, Pantry, Stainless Steel Appliances, Solid Surface Counters
- Room 5 Information
- Family Room
- Features: Ceiling Fan(s)
- Laundry Information
- Features: Washer Hookup
- Equipment
- Appliances: Dryer, Washer
- Interior Features
- Door Features: Insulated Doors
- Furnished
- Flooring: Wood
- Other Features: Furnished, Handicap Access, Window Treatments, Bedroom on Main Level, High Speed Internet
Exterior
- Building Information
- Construction Details: HardiPlank Type
- Exterior Features
- Exterior Features: Balcony, Dock, Elevator, Handicap Accessible, Porch, Storage
- Patio And Porch Features: Balcony, Rear Porch, Porch, Screened
- Green Features
- Green Energy Efficient: Doors, Windows
- Lot Information
- Lot Features: City Lot
- Waterfront Features: River Access
- Zoning: PUD
- Property Information
- Has View
- Entry Level: 2
- Foundation Details: Raised
- Resale
Financial
- Rental Information
- Pets Allowed Details: Owner Only, Yes
Utilities
- Utility Information
- Utilities: Electricity Available, Water Available, High Speed Internet Available
- Water Source: Public
- Heating & Cooling
- Has Cooling
- Cooling: Central Air
- Has Heating
- Heating: Central
Location
- HOA Information
- Has Home Owners Association
- Association Fee: $770
- Quarterly
- Association Fee Includes: Association Management, Common Areas, Cable TV, Insurance, Legal/Accounting, Maintenance Grounds, Trash
- Association Amenities: Owner Allowed Golf Cart, Pet Restrictions, Boat Slip, Trash, Cable TV, Elevator(s), Maintenance Grounds
- Community Information
- Community Features: Boat Slip, Cable TV, Golf Carts OK, Internet Access
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Condo/Co-op
- Year Built: —
- Year Renovated: —
- County: Georgetown County
- APN: 05-0029-112-01-04
Around this home
Schools
Public PreK-5 • Assigned • 2.4mi
Public 6-8 • Assigned • 1.9mi
Public 9-12 • Assigned • 2.0mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Estimated 80%+ chance of a flood reaching the building in the next 30 years
0.15% chance of being in a wildfire in next 30 years
7 days above 108° expected this year, 17 days in 30 years
99% chance of strong winds in next 30 years
0 unhealthy days expected this year, 1 days in 30 years
Sun exposure
In this area, properties receive around 9.2 hours in June and 5.6 hours in December, placing it above the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 29440
Home values near 623 Front St Unit 215 (2-B)
| Address | Redfin Estimate |
|---|---|
- Beds | - Baths | 1140 Sq. Ft. | $517,649 |
- Beds | - Baths | 1284 Sq. Ft. | $671,153 |
| Address | Redfin Estimate |
|---|---|
- Beds | - Baths | 1284 Sq. Ft. | $673,275 |
- Beds | - Baths | 2379 Sq. Ft. | $1,036,890 |
| Address | Redfin Estimate |
|---|---|
- Beds | - Baths | 2379 Sq. Ft. | $924,302 |
- Beds | - Baths | 2109 Sq. Ft. | $935,700 |
More real estate resources
- Neighborhoods
- Zip Codes
- Cities
- Popular Searches
| South Island Plantation homes for sale |
| 29440 homes for sale |
| DeBordieu Colony homes for sale | |||
| Pawleys Island homes for sale | |||
| Murrells Inlet homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.
















































United States
Canada