Opportunities like this don't come around often. Waterfront, just minutes to downtown Charleston, with views that truly set this property apart. This is a rare find!Situated along the Ashley River in the desirable Avondale neighborhood, this unique 5-bedroom home offers sweeping, unobstructed views of the water, The Citadel, and the Charleston skyline, with glimpses of the Arthur Ravenel Jr. Bridge in the distance. Mature live oaks frame the property, and the tidal creek access offers the opportunity for kayaking or simply enjoying the natural surroundings right from your backyard.As you approach the home, you're welcomed by a unique jasmine-covered walkway leading to a large, covered front porch. Step inside the approximately 3,136 square foot home and you're immediately drawnto the picturesque water views showcased from the impressive two-story living room. Just off the main living area, a spacious screened porch provides the perfect setting to relax and take in Lowcountry sunsets over the Ashley River. The main living spaces flow seamlessly between the living, dining, and kitchen areas, ideal for both everyday living and entertaining. The kitchen features stainless steel appliances, a gas range, granite countertops, a built-in breakfast nook, and a huge pantry just off to the side, offering plenty of additional storage. A standout feature on the main level is a spacious flex room, offering versatility as a den, home office, gym, or even a fifth bedroom. There is also a full bath and a guest bedroom on the first floor, complete with a convenient Murphy bed, maximizing both function and space for visitors. Upstairs, you'll find the remaining bedrooms, including a spacious primary suite where the views are truly breathtaking. Waking up to the Ashley River and Charleston skyline is something that sets this home apart, and even the updated primary ensuite bathroom captures these incredible views. The primary suite also features a well-appointed bath and a generous walk-in closet. What truly makes this home special is the combination of location and views. Being just minutes from downtown Charleston while still enjoying a private waterfront setting is something you don't see often. Priced $200k below appraised value & flood insurance is NOT required! If you've been waiting for a property that offers both character and a one-of-a-kind setting, this is one worth seeing.