Charleston Homes with Riverview Lot description

4 Beds ⋅ 4.5 Baths ⋅ 26023334 MLS ⋅ South Of Broad SubDv. ⋅ Active Status

This custom built South of Broad residence is a rare find featuring a 2 car garage, rooftop deck & WATER VIEWS of the Charleston Harbor!Other notable features include an elevator to all 4 floors, multiple outdoor terraces & porches, 2 game / bonus rooms for flex space usage (1 on ground level & the 2nd on the 4th floor), multiple living rooms, large eat in kitchen with state of the art appliances, 10ft ceilings with nearly floor to ceiling storm rated windows throughout, copper roof, a plethora of storage closets & is light filled throughout. There are 3 bedrooms on the 3rd level with an optional 4th bedroom on 4th floor in the 2nd flex space - all with ensuitebathrooms. Enter through a gated palm tree lined driveway & lush landscaping to find a thoroughly unique & built to last home. This residence was thoughtfully built using concrete & stucco, assuring it is extremely solid & virtually sound proof! The nearly 12 foot elevation of the home itself is another bonus which offers additional privacy from passersby. If having a pool is important, there is room for one! The home has only had ONE owner since it was custom built in 2007. Do not miss this exceedingly rare opportunity to own a new(er) home with all the modern conveniences in the heart of the historic district, but without the historic home maintenance! See Documents section for Information Sheet + Floor Plan. Systems Info: New Hot Water Heater (2026). 3 Newer HVACS (replaced 2023-2025) & have been regularly serviced & maintained. New Trim Paint (2026). The information herein is furnished to the best of the Listing Agent's knowledge, but is subject to verification by the purchaser and their agent. Listing Agent assumes no responsibility for correctness thereof, nor warrant the accuracy of the information or the condition of the property. If square footage is important - measure. Buyer to verify schools.

101 S Battery Street, Charleston

$725,000

4 Beds ⋅ 3.5 Baths ⋅ 26023165 MLS ⋅ Magnolia Ranch SubDv. ⋅ Active Status

2041 Old Fort Avenue offers exceptional privacy on a spacious 0.93-acre lot in a peaceful creekside setting. This sprawling one-story brick ranch features approximately 3,670 square feet of living space with frontage on Church Creek, a tidal tributary of the Ashley River, and scenic marsh views. Situated on the outskirts of the established Magnolia Ranch subdivision at the very end of Old Fort Avenue, the property is surrounded by mature azaleas, fruit trees, and majestic live oaks, creating a secluded setting that feels remarkably private while remaining conveniently located.Built on a slab foundation, the home offers an open and spacious layout with four generously sized bedrooms, a formal dining room, large den, sunroom, dedicated laundry room, storage rooms and covered rear porchOriginal hardwood floors add character throughout, while fireplaces provide inviting gathering spaces--a wood-burning fireplace in the living room and gas logs in the den. Additional features include an attached two-car carport measuring approximately 729 square feet, as well as a substantial detached garage and workshop with power totaling approximately 1,058 square feet. The additional outbuilding offers excellent flexibility for vehicle storage, hobbies, equipment, or workshop use. Priced below appraised value, 2041 Old Fort Avenue presents a rare opportunity to renovate and personalize a substantial creekfront property offering nearly an acre of land, expansive living and storage space, marsh views, and outstanding privacy. The property is being sold in as-is condition. NO HOA

2041 Old Fort Avenue, Charleston

$2,700,000

5 Beds ⋅ 4.5 Baths ⋅ 26022935 MLS ⋅ Ripley Cove SubDv. ⋅ Active Status

Homes in Ripley Cove are rarely offered for sale, making 9 Transom Court an exceptional opportunity to experience true waterfront living in one of Charleston's most central and sought-after marina communities. Designed by Darryl Cobb and custom built by Sintra Homes, this three-story residence offers 3,648 square feet of thoughtfully designed living space, soaring ceilings, an elevator serving all three levels, and beautiful water views throughout. A deeded 60-foot deepwater boat slip--one of the largest in the community--conveys with the property, providing effortless access to Charleston Harbor and beyond.The location is equally impressive, with convenient access to Highway 61, Porter-Gaud, Downtown Charleston, top-rated schools, and an array of dining, shopping, and everyday amenitiIts strategic location provides remarkably easy access to the Peninsula and surrounding areas, often making the commute more convenient than many downtown addresses. From the moment you enter, the home showcases a refined blend of craftsmanship and coastal sophistication. A slate-tiled foyer, soaring ceilings, and gleaming walnut floors create a welcoming first impression. Recent improvements include fresh interior paint, refinished flooring, new LED recessed lighting with integrated night-light features, and new exterior fans on the porches. The first level offers two bedrooms, two full baths, a media room opening to a Charleston-style courtyard, and a versatile space ideal for dining, working, or relaxing. A custom trim package is showcased throughout this level and continues across the home, while 2x6 construction and abundant built-in closet storage further reflect the quality of the home's craftsmanship. The main living level is filled with natural light and features a distinctive coal basket fireplace, with double French doors fitted with phantom screens opening to a covered porch overlooking the marina. The adjoining dining area flows seamlessly into the chef's kitchen, appointed with honed Carrara marble and soapstone-quartz countertops, custom cabinetry, a Sub-Zero refrigerator, Wolf range, Viking hood, Bosch dishwasher, and white porcelain farmhouse sink. A bedroom or study with Juliet balcony and a half bath complete this level. Upstairs, the vaulted primary suite provides a private retreat with a white-washed paneled ceiling and private balcony overlooking the marina and river. The suite includes a custom walk-in closet and luxurious stone-tiled bath with soaking tub, dual vanities, separate water closet, and oversized walk-in shower. A second guest suite with private bath and a dedicated laundry room complete the top level. True stone tile adds a timeless finish to all of the home's bathrooms. Outdoor spaces are designed for relaxed Lowcountry living, with custom copper gas lanterns, multiple porches, mature palms, and a beautifully landscaped walled Charleston courtyard featuring brick and bluestone hardscaping. The courtyard also offers the potential to add a pool, creating an even more private outdoor retreat. With its architectural pedigree, exceptional craftsmanship, premium finishes, deeded deepwater slip, and enviable proximity to Downtown Charleston, Charleston Harbor, area beaches, and Porter-Gaud, 9 Transom Court offers a rare opportunity to enjoy sophisticated waterfront living with the convenience of an exceptionally connected location.

9 Transom Court, Charleston

$475,000

2 Beds ⋅ 2 Baths ⋅ 26022863 MLS ⋅ Waterway South SubDv. ⋅ Active Status

Welcome to Waterway South, where stunning Stono River and marsh views create the perfect Lowcountry backdrop! This 2-bedroom, 2-bath end-unit townhome offers two stories of comfortable living, an upgraded kitchen, abundant natural light, and beautiful water and marsh views that immediately set this home apart. Plus, BRAND NEW ROOF & the HVAC installed in 2025!!!Step outside onto the rear deck and take in the peaceful scenery overlooking the marsh and Stono River. A retractable canopy provides shade when desired, making this an ideal space for morning coffee, evening cocktails, outdoor dining, or simply relaxing and enjoying the ever-changing Lowcountry views.Inside, the upgraded kitchen offers both style and functionality and flows into the home's inviting living spaces. The end-unit location provides additional privacy and natural light, while the two-story layout creates separation between living and sleeping areas. Located in the established Waterway South community in the heart of West Ashley, this home offers the combination buyers are looking for...beautiful views, outdoor living, an updated interior, and a convenient location with easy access to shopping, dining, downtown Charleston, and the surrounding Lowcountry. Whether you're searching for a primary residence, Charleston retreat, or simply a home where the view never gets old, this River Breeze townhome is one you won't want to miss. Come experience the marsh and river views for yourself!

167 River Breeze Drive Unit #Unit 16, Charleston

$285,000

2 Beds ⋅ 2 Baths ⋅ 26021972 MLS ⋅ Ashley House SubDv. ⋅ Active Status

Wake up to breathtaking panoramic views from the 10th floor of Ashley House, where the Ashley River stretches to the left and Charleston's iconic skyline--including the Ravenel Bridge--creates an unforgettable backdrop to the right.This 2-bedroom, 2-bath condominium offers an incredible opportunity to own in one of downtown Charleston's most desirable locations. Featuring a private balcony, spacious living areas, and an ideal floor plan, this home is ready for its next chapter.Enjoy the convenience of downtown living with world-class dining, shopping, waterfront parks, and historic Charleston just moments from your front door. Whether you're searching for a primary residence, a second home, or an investment in one of Charleston's most sought-after locations, this condo offers unbeatablviews, outstanding potential, and exceptional value. Water/sewer, pest control, property insurance, exterior/Common area maintenance, are covered in the monthly Regime Fee. Don't miss this rare opportunity to create your dream home in the heart of downtown Charleston.

14 Lockwood Drive Unit #Apt 10i, Charleston

$4,250,000

3 Beds ⋅ 2.5 Baths ⋅ 26021772 MLS ⋅ Harleston Village SubDv. ⋅ Active Status

Experience refined living at The Charles, an extraordinary new residence on the Charleston peninsula. Edged by parks, harbor, and river views, these stately townhomes are surrounded by the historic neighborhoods of Harleston Village and South of Broad. Featuring a private street-level entry and gracious multi-story design, this townhome combines historic Charleston charm with the comfort and efficiency of contemporary construction. Inside, discover uncompromising craftsmanship including designer finishes and light-filled living spaces ideal for both entertaining and everyday living. The gourmet kitchen features custom millwork, chef-grade appliances, and a spacious island. Upstairs, the primary suite is a sanctuary with spa-like bath and tranquil views.

368 Broad Street, Charleston

$999,990

3 Beds ⋅ 2.5 Baths ⋅ 26021516 MLS ⋅ Church Creek Landing SubDv. ⋅ Active Status

Welcome to one of the best waterfront values on the market! Built in 2023, this like-new 3-bedroom, 2.5-bath home in the highly desirable Church Creek Landing has been impeccably maintained and is completely move-in ready, offering all the benefits of new construction without the wait. Perfectly positioned on deep water with access to a shared dock, this exceptional property provides a rare opportunity to embrace the Lowcountry waterfront lifestyle at an incredible value.Constructed with elevated construction, the home features a spacious garage on the ground level, providing ample room for parking, storage, and all your boating and outdoor gear. Double front porches create timeless Charleston charm while offering the perfect places to relax and enjoy the surrounding views.Step inside to discover a thoughtfully designed floor plan. Just off the foyer is a versatile flex space that can easily serve as a formal dining room, home office, or sitting room to suit your lifestyle. The heart of the home is the expansive open-concept great room, where the living room, kitchen, and dining area flow seamlessly together to create an inviting space for everyday living and entertaining. The spacious living room is filled with abundant natural light and anchored by a cozy fireplace, creating a warm and welcoming atmosphere. The gourmet kitchen is designed to impress, featuring abundant cabinet and counter space, a large center island with bar seating, stainless steel appliances, including a built-in oven and microwave, and a convenient butler's pantry for additional storage and prep space. Just off the dining area, step onto the covered back porch, where there's plenty of room for outdoor seating while enjoying peaceful water views--the perfect setting for morning coffee or evening sunsets. Upstairs, a cozy loft provides additional flexible living space, ideal for a reading nook, home office, or study area. From the loft, step onto the second-story front porch overlooking the community pond, offering yet another peaceful place to unwind. The spacious primary suite serves as a private retreat, complete with a large walk-in closet and a luxurious ensuite bathroom featuring a double-sink vanity, a beautifully tiled walk-in shower, and a separate soaking tub for ultimate relaxation. Two generously sized secondary bedrooms share easy access to a well-appointed full bathroom, while the conveniently located laundry room makes everyday living even more practical. Outside, the backyard offers even more to enjoy with a 3-hole putting green, making it easy to practice your short game while taking in the beautiful surroundings. From the backyard, you'll also enjoy convenient access to the shared deep-water dock, offering endless opportunities for boating, fishing, kayaking, and enjoying the coastal lifestyle. Ideally located just minutes from shopping, dining, and everyday conveniences, with easy access to major highways, this home combines the tranquility of waterfront living with exceptional convenience. Opportunities like this are becoming increasingly rare--especially under $1 million. Combining like-new construction, modern finishes, deep-water access, Charleston-inspired architecture, and an unbeatable waterfront setting, this exceptional home is truly one of the best values on the market. Don't miss your chance to own a piece of the Lowcountry waterfront lifestyle--schedule your private showing today! Use preferred lender to buy this home and receive an incentive towards your closing costs!

2230 Waterfowl Lane, Charleston

$1,995,000

2 Beds ⋅ 2.5 Baths ⋅ 26021078 MLS ⋅ Daniel Island SubDv. ⋅ Active Status

Currently the only waterfront residence available at The Waterfront, this exceptional home offers sweeping Wando River views, breathtaking Lowcountry sunrises, and the effortless luxury of lock-and-leave living. This beautifully designed 2-bedroom, 2.5 -bath residence offers an open-concept floor plan with a chef's kitchen, butler's pantry, expansive porches, generous walk-in closets, and a spa-inspired primary suite featuring a soaking tub and wet room--equally suited for quiet mornings and elegant entertaining.Recently enhanced with more than $15,000 in upgrades, the home features professionally refinished cabinetry with a factory-quality finish, designer hardware, and upgraded LED lighting throughout.From your private balcony, enjoy peaceful river views before strolling to Kingstide, The DIME, waterfront parks, Carefree Boat Club, Credit One Stadium, the Daniel Island Ferry, and miles of scenic walking and biking trails--all just moments from your front door. Whether you're seeking a primary residence, a Lowcountry retreat, or the perfect lock-and-leave second home, The Waterfront offers an exceptional lifestyle with a waterfront pool, pool house, fitness center, residents' lounge, The Post, beautifully maintained green spaces, and direct access to the Wando River. Quarterly HOA dues include resort-style amenities, professional management, exterior maintenance, building insurance, and utilities including water, sewer, cable, internet, and phone--allowing you to simply lock the door and travel with confidence, knowing your home is professionally cared for while you're away.

600 Waterman Street Unit #Unit 732, Charleston

$669,000

3 Beds ⋅ 3 Baths ⋅ 26020683 MLS ⋅ Sable On The Marsh SubDv. ⋅ Active Status

Luxury condo with marsh and river views . The main level has the open layout living space including kitchen, and a bedroom with full bathroom. Second floor has the primary bedroom with a beautiful bathroom. The second floor also contains the third bedroom and bathroom. The condo is just a couple of minutes to the beach. There is a patio on ground floor with shower. Large 2 car garage, plenty of room for flex space. EV charging set up in garage . The are relaxing fountains in the community area. Overflow parking. Beautiful views from the porches on the 2nd and 3rd facing the marsh. HOA covers exterior maintenance, flood insurance, termite bond, exterior pest control

118 Howard Mary Drive Unit #118b, Charleston

$2,750,000

5 Beds ⋅ 4 Baths ⋅ 26020408 MLS ⋅ Edgewater Park SubDv. ⋅ Active Status

Embrace lowcountry living at its best with this exceptional deepwater estate situated at 1315 S. Edgewater Drive. Nestled among ancient oaks on .58-acres that offers stunning waterfront views . The spacious backyard features beautiful vistas, brick firepit, a huge five-car garage w/dual-sided doors for easy water access boat storage (dock plans convey). Inside, you will find oak hardwood flooring throughout, a formal dining room with a fireplace, a gourmet kitchen equipped with large island, a gas range & double Bosch ovens. The kitchen flows seamlessly into a family room with vaulted ceilings, a second fireplace & sliding doors that open to the back patio. Best of all, there is a huge second living area that could be a separate guest area, mother-n-law suite or AirBNB

1315 S Edgewater Drive, Charleston

$4,989,000

4 Beds ⋅ 5.5 Baths ⋅ 26019988 MLS ⋅ The Settlement SubDv. ⋅ Active Status

Modern coastal luxury awaits at 4017 Kaolin Street, a custom-built masterpiece designed by local designer Betsy Glass. Three years in the making, the home offers stunning marsh and water views of the Ashley River, complete with a private tidal dock, boat lift, and saltwater pool and hot tub. Offered fully furnished, it's truly one of a kind from the moment you walk in. The home was crafted around three guiding principles: unique modern coastal design, maintenance-free living, and biophilic design that brings the natural world indoors. Betsy paired the highest level of finishes and materials with a design sensibility that blends coastal lifestyle with modern sophistication. To achieve a maintenance-free exterior, the home makes extensive use of Knotwood, a wood-grain aluminum that delivers the warmth of wood with none of the upkeep, throughout the screening, pergolas, railings, and trellises. Multiple porches, patios, and covered spaces invite indoor-outdoor living at every turn. Enter through a black Marquina marble tile inlay bordered in wood, which gives way to chevron hardwood floors flowing through the open living room and kitchen. The kitchen features contrasting white and black Silestone quartz countertops with a waterfall edge over a multilevel island made for dining and entertaining. Linear-style cabinet faces are finished in quartz slabs and lined in white oak. A six-burner Bertazzoni gas range is flanked by open shelving, while the dishwasher and stove hood are Thermador. The side-by-side 30-inch fridge and freezer columns offer smart, hands-free technology, and the kitchen is finished with custom designer lighting, touchless faucets, a custom hood, an oversized sink, double trash pull-outs, and toe-kick lighting throughout. A 12-foot pass-through window, designed and manufactured by Euro-Wall, overlooks outdoor bar seating and connects the kitchen to the pool and outdoor kitchen, letting marsh breezes in whether you're hosting or unwinding after a long day. The living room is anchored by a gas fireplace, custom designer lighting, and custom painted wood wall treatments, with built-in seating and storage flanking the fireplace on either side. The staircase serves as a true statement piece, drawing together the design language of the kitchen and living room. The outdoor patio is an entertainer's dream, outfitted with an ice machine, a separate sink, a beverage center, and a trash pull-out. The kitchen and dining area include a refrigerator, marine-grade Blaze appliances, polished porcelain slab countertops, an ice maker, and a grill beneath a custom stucco hood, all flowing seamlessly from the screened-in porch to the firepit area to the pool. The screened-in porch features a vaulted ceiling, exposed beams, and no-see-um-level screening durable enough to withstand small pets. Just beyond it, a turfed area with a custom firepit is the perfect spot to take in the stars. The custom saltwater pool overlooks the water and dock and was designed to feel like a five-star resort. Black marble glass mosaic coping lends a serene ambiance, and the pool is heated, lit, and self-cleaning. The butler's pantry extends the kitchen's luxury with nature slat walls, backless cabinets, waterfall quartz countertops, and a commercial-grade True refrigerator, dishwasher, microwave drawer, and touchless faucet sink. Around the corner, the first-floor laundry room offers a stackable, king-capacity front-load washer and dryer, a pull-out hamper, a hanging pole, a double trash pull-out, and a touchless faucet sink, finished with Et Noir Silestone counters and a vertical tongue-and-groove backsplash. A custom dog water station, complete with wall-mounted swing-arm faucets, leash hooks, and nature slat wall panels, rounds out this thoughtfully designed wing. The primary suite is a true sanctuary, sophisticated yet genuinely cozy. Custom wooden slat walls and a live moss panel bring quiet, natural texture to the room, while a gas fireplace anchors the space beneath a ridge-and-crossbeam vaulted ceiling. A spacious covered porch with privacy doors extends the suite outdoors. The primary bath is the height of luxury, with a black marble vanity and shower walls and flooring in beautifully veined white Venato marble. The shower includes dual showerheads, a rainfall feature, and a drainless design that feels like vacation every day. Flat-panel cabinets keep the look modern and clean, and a 9-foot built-in storage cabinet adds ample space. Just around the corner, an outdoor shower connects directly to the pool. The primary walk-in closet is finished in elmwood white oak with two built-in framed mirrors and custom lighting. Upstairs, painted wood wall treatments center each bedroom with a contemporary touch. The first guest bath is finished in Venice green verde mix terrazzo on both the floor and shower walls, with wall-mount and rain showerheads. The second guest bath makes its own statement with custom terrazzo sinks and orange-and-white star-and-cross cement tile. A second-floor laundry tower is tucked into a decorative cabinet with a folding station and custom cabinetry. Down the hall, a cozy den and office feature a built-in desk with quartz counters, elmwood white oak lower drawers, and glass upper cabinetry with interior lighting. The white oak elmwood daybed includes built-in drawers and shelving, with slat paneling tying the daybed and office together for a custom, cohesive look. The upstairs powder room continues the slat wall theme with a floating waterfall quartz vanity and a quartz backsplash wall. The upstairs covered porch is where every day should end. A pergola keeps the sun at bay while you take in expansive views of the Ashley River, and a full beverage area -- with ice maker, refrigerator, and a custom gas fireplace -- makes it perfect for happy hour or cozy fall and winter evenings. Downstairs, a moody powder room to the right of the entry features an Et Noir quartz vanity with storage drawers and screen-printed geometric Thibaut wallpaper. Down the hall, an office is finished with chevron flooring that carries up the walls, a built-in desk, and aluminum-framed glass cabinets with lit interiors. The office connects to a breezeway leading to the three-car garage and guest house, complete with its own dog-wash station for easy pet care. The private guest house is a full experience of its own, announced by a showstopping Tilda chandelier. Inside the entry, a custom drop zone features black vertical wall paneling, a floating bench seat, wall sconces, and built-in cabinets. The guest house functions as a complete home, with its own kitchen, laundry space, bedroom, living room, bathroom, and private porch. Vaulted ceilings open up the space and lead to a covered porch overlooking a historic park designated by the Charleston County Historical Society, home to one of the oldest surviving structures in South Carolina. The kitchen includes a dishwasher, a pull-out drawer fridge and freezer, a microwave drawer, a sink, and a stackable washer/dryer, all framed by open shelving, floor-to-ceiling cabinets, and black vertical wall paneling. The guest suite bathroom is finished in serene charcoal soapstone and terrazzo tile. Other important features on the home include custom baseboards with design, detailed doors with no casings, unique 4-inch square can lighting, Toto wall mounted toilets throughout, hurricane impact rated doors and windows, hardy plank siding, metal bi-colored black and whiteroof, self-draining stucco flower planters filled with lavender, marble outdoor flooring and steps with a non-slip material added, and a concrete tabby and oyster shell fill driveway with artificial turf in between. The Settlement at Ashley Hall is a premier waterfront community in Charleston, situated on the Ashley River and listed on the National Register of Historic Places. Towering oaks predate the Declaration of Independence, and the community enjoys 1,000 feet of riverfront, complete with a riverfront community pool, covered pavilion, firepit, and a community deep-water dock, all just minutes from the Charleston International Airport, grocery stores, restaurants, and marinas.

4017 Kaolin Street, Charleston

$950,000

6 Beds ⋅ 4 Baths ⋅ 26019648 MLS ⋅ Wando Point SubDv. ⋅ Active Status

Assumable loan available with an approximate 2.5% interest rate, subject to buyer qualification and loan assumption approval. Behind the gates of Wando Point, where moss-draped oaks, waterfront homes, and quiet streets create one of Mount Pleasant's most private enclaves, a home awaits that captures everything people love about the Lowcountry. Life here revolves around the water. Reserved exclusively for residents, the community's private deepwater dock and boat slips make spontaneous sunset cruises, early morning fishing trips, and weekends on Charleston Harbor part of everyday life, not special occasions. Thoughtfully designed across three spacious levels, the home effortlessly balances sophisticated entertaining with comfortable everyday living.The entry level offers a private guest retreat with two generous bedrooms and a beautifully appointed full bath, creating the perfect space for visiting family, long-term guests, or multigenerational living. The main level is where the home truly comes alive. Rich Brazilian cherry hardwood floors, custom millwork, and light-filled living spaces create an atmosphere that feels both elegant and inviting. The custom kitchen anchors the home, flowing seamlessly into the formal dining room, intimate coffee nook, spacious living area, and dedicated office with an adjoining full bath. Just beyond, the screened porch becomes an extension of the living space, inviting long conversations, evening cocktails, and quiet mornings surrounded by the beauty of the Lowcountry. The top floor is reserved for relaxation. Two spacious guest bedrooms accompany an exceptional primary suite that feels more like a private retreat than simply a bedroom. Bathed in natural light, the suite offers oversized walk-in closets and a spa-inspired bath complete with a soaking tub, expansive custom shower, dual vanities, and the kind of thoughtful design that transforms everyday routines into moments of comfort. Every detail reflects great care, from hardwood and tile flooring throughout to plantation shutters, updated HVAC systems, a tankless water heater, an insulated attic, integrated security features, and an oversized three-car garage with abundant storage. Just minutes from downtown Charleston, Daniel Island, Isle of Palms, and Sullivan's Island, Wando Point offers something increasingly rare, a gated waterfront community where privacy, boating, and everyday luxury coexist effortlessly. Some homes offer beautiful finishes. This one offers a lifestyle that begins the moment you arrive home.

141 Wando Reach Road, Charleston

Charleston Homes with Riverview Lot description

Newest Charleston Homes with Riverview Lot description