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

4633 Lightkeepers Way
Little River, SC 29566

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $317,200
Beds: 2
Baths: 2
Status: Active
SqFt: --
Agency: Realty ONE Group Dockside

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1993
Notes: What a view! Located on the marina, this end unit, top floor condo at Yacht Club @ Lightkeepers Village features 2 bedrooms, 2 full bathrooms, a screened in porch, an open floor plan, AND it comes FURNISHED including washer/dryer! The unit features a split bedroom floor plan with one bedroom overlooking the front of the building and the primary suite located at the rear of the condo. The primary bedroom has a walk-in closet and an en suite primary bath with linen closet, double sinks, and tub/shower combination. Primary also has access to the cozy screened in porch which overlooks the beautiful marina and Intracoastal Waterway, endless boats, lighthouse, and boardwalk! Living area boasts an open floor plan with kitchen, dining area, and living room ideal for entertaining. The view from the large picture window that can be seen from the entire living area is a SHOWSTOPPER! The unit had new carpet installed in the bedrooms in 2021. The guest bathroom was updated in 2020 and Luxury Vinyl flooring was put in both bathrooms. New living room fan, guest bedroom fan/light, and new roof on the building less than a year old. The unit also has a storage closet outside the front door to accommodate outdoor "toys" or just some additional storage space. Lightkeepers is located in Little River, South Carolina on the Waterway. Beautiful neighborhood with great amenities including two pools, a club house, and tennis courts. Additionally, you are only minutes from the beaches of North Myrtle/Cherry Grove! Experience the many exciting area events including free summer Main Street concerts, a wide variety of year-round festivals, and more! Conveniently located near many grocery stores, coffee shops, restaurants, entertainment venues, beaches, shopping, hospitals, and churches! This is a MUST SEE unit. Just imagine grabbing your cup of coffee or glass of wine and heading to the screened porch to relax and watch the boats during sunrise and sunset. Don't miss this one!
MlsNumber: 2325812


Listing Provided By: Realty ONE Group Dockside, original listing
Name: Realty ONE Group Dockside
Phone: (843) 492-4030
Office Name: Realty ONE Group Dockside
Office Phone: (843) 492-4030
Agent Name: Kolbie Bowling
Disclaimer: Copyright © 2024 Coastal Carolina 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App