35ZsGgqb Homes with Waterfall - Artificial Lot Description

35ZsGgqb Homes with Waterfall - Artificial Lot Description

Welcome to the enchanting world of 35ZsGgqb County, North Carolina, where nature’s beauty meets modern living! Nestled in the heart of the Tar Heel State, this area is renowned for its picturesque landscapes, friendly communities, and an abundance of outdoor activities. Whether you’re a nature enthusiast or someone who simply enjoys the tranquility of a serene environment, this county offers a perfect blend of rural charm and suburban convenience.

One of the most captivating features of homes in this region is the stunning artificial waterfall lots. Imagine waking up to the soothing sounds of cascading water right in your backyard! These thoughtfully designed properties not only enhance the aesthetic appeal of your home but also create a serene oasis for relaxation and entertainment. The gentle flow of water adds a unique charm, making every moment spent outdoors feel like a retreat.

In addition to the beautiful homes with waterfall features, 35ZsGgqb County boasts a variety of amenities, from local parks to vibrant shopping districts. The community is known for its welcoming atmosphere, making it an ideal place for families, retirees, and young professionals alike. With excellent schools, recreational facilities, and a rich cultural scene, you’ll find everything you need to live your best life.

Discover the allure of 35ZsGgqb County, where every day feels like a vacation. Explore the homes with artificial waterfall lots and experience the tranquility and beauty that await you in this charming North Carolina community. Your dream home is just a waterfall away!

Newest 35ZsGgqb Homes with Waterfall - Artificial Lot Description

$575,000
4 Beds ⋅ 3 Baths ⋅ 4409674 MLS ⋅ ACTIVE Status
Discover your own private retreat in the desirable Royal Pines community! This inviting home offers the perfect blend of comfort, creativity, and nature. The beautifully landscaped yard is a gardener's paradise, filled with spaces to cultivate, relax, and enjoy the outdoors. A charming detached shed, currently used as an art studio, offers endless possibilities as a workshop, hobby space, home office, or playhouse. Wander along the private walking trail that meanders through the property, leading to a peaceful water feature, creating a tranquil setting for morning coffee, quiet reflection, or unwinding after a long day. Inside, you'll find comfortable living spaces filled with natural light and a functional layout designed for everyday living. The lower-level ensuite and family room are perfect for a guest suite or multigenerational living. Conveniently located in South Asheville, just minutes from shopping, dining, parks, and the Asheville Airport, this special property offers a rare opportunity to enjoy the beauty of nature without sacrificing convenience.

340 Sycamore Drive, Arden

Listing courtesy of Howard Hanna Beverly-Hanks Asheville-Biltmore Park. viv.snyder@howardhannatate.com
$920,000
5 Beds ⋅ 6 Baths ⋅ 4400840 MLS ⋅ COMING SOON Status
Indoor and outdoor living at its finest in Quellin. This stunning 5-bedroom 4 bath home is sure to impress the most discerning buyer. Elegantly situated on over half an acre of lush, mature landscaping, this full brick home enjoys a showstopper pool complete with a waterfall with jumping platform and a hidden grotto. A large hot tub with waterfall attached to the pool make the pool a year-round feature. The pool can be heated by Natural gas, extending the fun well into the cooler months. Plenty of pool decking for lounging, an outdoor fire pit, as well as an oversized covered back patio built with entertaining in mind featuring an outdoor kitchen. The indoor spaces are equally impressive with a chef's kitchen and a two-story great room. This home is being offered by the original owner and the love and care of it is evident. Noticed the refinished hardwood floors, updated kitchen, new carpeting, and fully encapsulated crawl space. This home is conveniently located close to downtown Historic Waxhaw which includes local restaurants, charming shopping, breweries, as well as many planned events and festivals throughout the year. The Community of Quellin also has many desirable features such as a a outdoor pool, clubhouse, playground, pickle ball courts, as well as scenic walking trails. This community enjoys all the convenance's of the city including exceptional schools however the charm and sprawling space of life in the country. This home has to be seen to be appreciated. Schedue a tour today.

8403 Dunton Court Unit #50, Waxhaw

Listing courtesy of NorthGroup Real Estate LLC. Katherine-Young@carolina.rr.com
$490,000
2 Beds ⋅ 2 Baths ⋅ 4400613 MLS ⋅ ACTIVE Status
Beautiful Craftsman-inspired ranch home featuring the highly sought-after Copper Ridge floor plan in award-winning 55+ Sun City Carolina Lakes. Perfectly situated on a premium cul-de-sac lot, this thoughtfully designed residence offers an open-concept layout with spacious living areas, abundant natural light, and seamless indoor-outdoor living. Inside, the home showcases elegant architectural details, including wainscoting in the foyer and dining area, along with crown molding throughout much of the home, adding timeless character and sophistication. The gourmet kitchen features granite countertops, stainless steel appliances, abundant cabinetry, and an open design that flows effortlessly into the dining and living areas, making it ideal for both everyday living and entertaining. A dedicated office/flex room with French doors provides the perfect space for working from home, hobbies, or additional guest accommodations. The bright sunroom, enhanced with elegant French doors, overlooks the beautifully landscaped backyard and flows effortlessly to the rear patio, complete with a pergola and a convenient gas hookup for grilling and entertaining. A partially fenced yard and tranquil water feature create a private outdoor retreat. Lawn maintenance is included, with the homeowner responsible for maintaining the lawn and landscaping inside the fenced area. The primary suite and ensuite bathroom offer a peaceful escape with ample room to relax, while the guest bedroom features custom built-in storage, providing exceptional organization and functionality. Recent updates provide exceptional value and peace of mind, including a NEW roof, interior paint, blinds, and screens (2026), and HVAC maintenance has been prepaid for the year through Freeman's Heating & Air. The water heater and garage door systems were replaced in 2025, and new luxury vinyl plank flooring was added throughout the main living areas and office in 2024. This move-in-ready home combines timeless Craftsman charm, quality upgrades, and exceptional indoor and outdoor living, all while enjoying the award-winning, resort-style amenities of Sun City Carolina Lakes.

2027 Maned Goose Court, Fort Mill

Listing courtesy of Real Broker, LLC. 843-343-3538
$1,400,000
4 Beds ⋅ 4 Baths ⋅ 4404061 MLS ⋅ ACTIVE UNDER CONTRACT Status
Such an exciting and elevated home in the thriving, sought-after neighborhood of Hembstead! Top rated schools and amazing South Charlotte location close to SouthPark, downtown Matthews, I-485 and the Arboretum area! This property is stunning! Beautifully updated and sits on over half an acre with a newly sodded backyard that lives like a true oasis - think hot tub, gorgeous water fall feature, fire pit, amazing custom extended deck, and bougie chicken coop! Inside, you will find approx. 3,700 SF of above grade thoughtful design: a luxury, renovated Thermador appointed kitchen, generous screened-in porch, hardwoods throughout most of the home, and custom built-ins at every turn. This intentional floor plan offers 4 bedrooms, 3 full baths, 1 half bath, a dedicated office, and a bonus room, with all bedrooms conveniently located on the second floor! Perfectly maintained! Roof replaced in 2025. Situated on one of Hembstead’s most picturesque streets - close to the amenities, yet perfectly tucked away. Community amenities include club house, pool, tennis courts, pickle ball, sport court, play ground, picnic area, and miles of walking trails! This is a very rare opportunity to secure an immaculate, top tier home in one of South Charlotte’s most beloved neighborhoods.

2630 Alanby Lane, Charlotte

Listing courtesy of Corcoran HM Properties. tiffanywhite@hmproperties.com
$1,450,000
4 Beds ⋅ 4 Baths ⋅ 4404140 MLS ⋅ ACTIVE Status
Tucked away on a peaceful cul-de-sac in the gated community of Bright's Creek, this Arts & Crafts-style home offers privacy enhanced by mature, professionally designed landscaping. Rich custom woodwork and quality craftsmanship create a warm, inviting interior. Step onto the covered rear porch overlooking a serene pasture, creating the perfect setting for morning coffee or evening relaxation. Outside, you'll find two stunning custom waterfalls, one cascading into a beautiful koi pond, along with a private fire pit for gathering with family and friends. Located within Bright's Creek, where membership is available for purchase to enjoy championship golf, equestrian facilities, dining, fitness, and more. Luxury mountain living at its finest.

153 Glenn Court, Mill Spring

Listing courtesy of Howard Hanna Beverly-Hanks. brightscreek@beverly-hanks.com
$2,200,000
5 Beds ⋅ 7 Baths ⋅ 4378734 MLS ⋅ ACTIVE Status
This spacious, architecturally designed, custom built home incorporates wooded views, mountain views, and a professionally built creek and waterfall that converge at a moss covered sitting/respite spot. Unwind and recharge while listening to the creek and waterfall flow. This home, sitting on three lots in Montreat, is a rare find. The relatively gentle semi-circular driveway with abundant level parking allows you to casually stroll to the main entrance. Opening the full lite glass entrance doors leads directly into the Great Room presenting a cathedral ceiling, native stone fireplace, wide plank hardwood flooring, and a grand open floor plan. Expansive glass lets in natural light and provides views of the surrounding mountains. Solid oak flooring is throughout this home. Conversation and interaction within the dining, kitchen, and living areas is easy and comfortable with this open design. The skylights and structural ceiling components add a refined mountain feel with their use of wood, depth, space, and light. Just off of the Great Room is the master bedroom with an ensuite bath. The alluring beauty of this room comes from many design details including; extensive glass and skylights, a cathedral ceiling, major wood accents, a view of the mountains from the front and a view of the waterfall and landscaped woods from the back, and a private covered porch. The main floor has direct access to the extra large two car garage. The laundry is also on this level. There are two staircases that lead to the lower level. Taking the well crafted oak staircase from the Great Room leads to the Family Room on the lower level. This room has a stone fireplace and French doors that lead outside onto the covered deck. Flanking this room are two ensuite bedrooms. The wide hallway leads to a kitchenette with unique views to the creek and extensive stonework outside, and two more ensuite bedrooms. At the end of the hallway is a media or recreation room, and an additional full bath with a clawfoot tub. From this recreation room there is access to the outside deck, the back staircase, and to the “pool room” and outside lap pool. This Endless Pool is exceptional in size and features, but will need at least a new liner and some decking work. Taking advantage of the southern and western exposure, the roof has an extensive solar panel array for alternative energy.

117 Shenandoah Terrace, Montreat

Listing courtesy of Matt Ashley Real Estate LLC. Matt@MAshleyRealEstate.com
$660,000
4 Beds ⋅ 3 Baths ⋅ 4398596 MLS ⋅ ACTIVE Status
Tucked into the mountains of Western North Carolina, this enchanting cottage-styled home offers a rare blend of natural beauty, thoughtful updates, and an exceptional community lifestyle. Impeccably maintained and truly move-in ready, every detail has been lovingly cared for. The heart of the property is a stunning handcrafted waterfall surrounded by lush native plantings, creating a peaceful retreat where the soothing sounds of cascading water become part of everyday life. The beautifully curated gardens are a Certified Wildlife Habitat®, attracting songbirds, butterflies, and other native wildlife. Mature old-growth trees provide cool shade throughout the warmer months, making the outdoor spaces perfect for relaxing, entertaining, or simply enjoying nature. Inside, beautifully refinished hardwood floors flow throughout the home, while the inviting living room features a gas fireplace for cool mountain evenings. The kitchen has been updated with quartz countertops and new appliances, offering both style and functionality. The oversized primary suite is a true retreat, with peaceful views overlooking the gardens and mountains beyond. A spacious ensuite bath provides a spa-like escape, creating the perfect place to unwind at the end of the day. The partially unfinished basement space offers potential for future expansion and is already plumbed for an additional bathroom, providing an opportunity to create additional living space, a guest suite, hobby room, or home office tailored to your needs. Outside, there's ample yard space for gardening, pets, and play, all surrounded by established landscaping that feels both private and welcoming. Located in an active, walkable neighborhood, residents enjoy neighborhood picnics and holiday celebrations and a sense of community while benefiting from low HOA fees. Enjoy the best of mountain living with everyday conveniences just 8 minutes away, downtown Asheville, Asheville Regional Airport, and some of the area's best hiking just 15 minutes from your door, while Lake Lure is only a scenic 30-minute drive away. Whether you're seeking a full-time residence or a mountain getaway, this home offers the perfect combination of comfort, community, convenience, and the natural beauty that makes Western North Carolina so special. Check out the video:https://www.youtube.com/watch?v=W5rt1iNSxdA

22 Meadow Brook Drive, Fletcher

Listing courtesy of Unique: A Real Estate Collective. traceyn@uniquecollective.us
$8,900,000
10 Beds ⋅ 9 Baths ⋅ 4399197 MLS ⋅ ACTIVE Status
RARE, REFINED REMARKABLE. Your life unfolds inspired by a paradise of privacy, peace and perfection. Views of distant blue mountains are punctuated by the expansive fairways and greens of the fabled Biltmore Forest Country Club. Landscape worthy of a botanical garden envelops your life. This signature estate was designed by Richard Sharp Smith, supervising architect of the Biltmore House. Commissioned by Burnham S Colburn, who served on the Board of Edith Vanderbilt's Biltmore Company, he was a charter member of the Biltmore Forest Country Club and oversaw the nascent development of the Town of Biltmore Forest. One of the original three homes built in the Forest and sited on one of the prime lots. it was celebrated at the 100th anniversary of the Town and the Club. It is sited in the area known as the Golden Horsehoe, a reference to the horse shoe shaped area around the golf course populated by the early mansions of the Roaring 20s. This century has brought an addition designed for open modern living including a spacious kitchen open to the vaulted family room, a screened view porch with built in grill, hardscape and landscape featuring a pool and spa,a pool recreation room with a kitchen and second billiards room or exercise room, croquet and bocci lawns, new computer controlled electric, plumbing, HVAC, slate roof on the main house, thermopane windows, remodeled baths, a theater room, a 100kw generator, lwells for landscape and an attached garage. Blending the finest in modern living with the patina of history, this estate is for the discriminating buyer who demands a location and livability second ot none. The Town of Biltmore Forest is located less than ten minutes from vibrant downtown Asheville and less than twenty minutes from the regional airport, Surrounded by fine dining and shopping it is bordered by the Blue Ridge Parkway and hosts a part of the Mountain to Sea Trail. It has its own police force, a private Country Club and pre k to 12th grade day school and medical offices. Carved from the Biltmore Estate in 1922 the Town offers many opportunities to its residents for recreation and socialization.Its peaceful serpentine roads lead past streams to parks and a bass pond. It is a haven for walkers and bikers. Enjoy the finest of mountain living.

7 Stuyvesant Road, Biltmore Forest

Listing courtesy of Howard Hanna Beverly-Hanks Asheville-Biltmore Park. ann.skoglund@howardhannatate.com
$559,000
2 Beds ⋅ 2 Baths ⋅ 4394336 MLS ⋅ ACTIVE Status
A SECOND CHANCE AT THIS ONE HAS COME ALONG!! If you'd like to make the Blue Ridge Parkway part of your regular commute than two plus acres atop a knoll await you with breathtaking, panoramic, long range, layered mountain views. Located about a 20 minute drive from town this mini homestead boasts a cozy 2 bedroom 2 bathroom cottage with flexible bonus space, thoughtful features and lots of updates through out. The outdoor living is impressive with wrap around decking and patios that give an unplugged appreciation for the serene location. The largely flat and usable yard is covered in mature flowering landscaping and has private walking paths between rock lined beds and has space to expand or enjoy an open yard. There are several outbuildings for guests hobbies and storage. This is a luxury location with an approachable vibe

854 Ox Creek Crest Lane, Weaverville

Listing courtesy of NextHome Partners. ZachPenlandRealtor@gmail.com
$1,290,000
3 Beds ⋅ 3 Baths ⋅ 4394682 MLS ⋅ ACTIVE Status
This private and secluded mountain retreat sits on a 1.14-acre heavily treed homesite in the gated Cummings Cove Golf & Country Club. It offers breathtaking long-range, year-round southwestern mountain and sunset views from nearly every room. This Custom Home is loaded with upgrades throughout the home! The gentle sounds of a custom three-tier waterfall just outside the front door, welcome you along the flagstone walkway to the inviting front porch, accented with cedar and stone columns. Step through the front door and be captivated by the expansive mountain vistas that immediately take center stage. Designed for comfortable main-level living, the open floor plan features a formal dining area framed by custom arched windows overlooking the beautifully landscaped waterfall & stone columns. The chef's kitchen is a masterpiece, showcasing custom knotty alder cabinetry, stone accents, a striking copper hood over the natural gas cooktop, upgraded granite countertops, Island with sink & breakfast bar, and abundant workspace for entertaining. Just off the breakfast nook, the three-season room offers a cozy gas-log fireplace and direct access to the spacious 15' x 18' deck featuring Trex decking, cedar posts, stainless steel cable railing, and spectacular mountain views. The great room delivers a true mountain-lodge ambiance with its soaring 18-foot vaulted ceiling, exposed wood like accents and arched beams, floor-to-ceiling stone gas log fireplace, and dramatic 4' x 8' custom arched windows fitted with designer shades. The luxurious primary suite is a private retreat, featuring a coffered wood ceiling, expansive mountain-view windows, an oversized 8' x 12' walk-in closet, dual-sink granite vanity, and a spacious custom tile walk-in shower. A split-bedroom design ensures privacy for family and guests. Additional features include a well-appointed laundry room with granite countertops, abundant cabinetry, and space for a freezer. Engineered hardwood flooring throughout. Versatile upstairs bonus room with storage that can serve as a recreation room, office, or additional sleeping area. A 10' x 14' finished basement storage or workshop area and full crawl space provide excellent storage options. Outside, the heavily landscaped backyard offers a small grassy area surrounded by natural greenery, creating the perfect setting for a fire pit and outdoor gatherings beneath the stars. The whole property is landscaped with beautiful evergreens for year round privacy & extensive beauty in the springtime. Enjoy a 3 car oversized garage with a small work space. Resort-Style Mountain Living nestled in the heart of the Blue Ridge Mountains, Cummings Cove Golf & Country Club is more than a gated community, it's an active lifestyle destination with resort style amenities. Monthly HOA dues of just $180 provide access to exceptional amenities, including a heated pool and spa, water aerobics, fitness center and classes, tennis courts, pickleball courts and clinics, bocce ball, dog park, community garden, numerous clubs and social activities, and on-site dining and bar service at the clubhouse. The community's championship golf course is open year-round, with memberships available but not required. Ideally located, the community is just minutes from DuPont State Recreational Forest and Pisgah National Forest, offering endless opportunities for hiking, biking, fishing, waterfalls, and outdoor recreation. The charming mountain towns of Hendersonville and Brevard are approximately 20 minutes away, providing excellent shopping, dining, healthcare, entertainment, and year-round festivals. Everyday conveniences are nearby in Etowah and Horseshoe, while Asheville Regional Airport is conveniently located about 20 minutes from the community. This exceptional mountain home combines luxury craftsmanship, stunning views, privacy, and an unparalleled lifestyle in one of Western North Carolina's premier gated communities. NOTE: Floor plan is in MLS Docs

48 S Mountain Morning Lane, Hendersonville

Listing courtesy of Keller Williams Mtn Partners, LLC. SoldByKW@kw.com
$840,000
4 Beds ⋅ 3 Baths ⋅ 4387037 MLS ⋅ ACTIVE UNDER CONTRACT Status
Discover the perfect blend of comfort, space, and privacy in this beautifully maintained 4-bedroom, 3-bath home nestled in one of Laurel Park's most desirable areas. With approximately 3,400 square feet of heated living space, this property offers room to spread out while entertaining indoors or outside. Abundant natural light through the skylights and an open floor plan with a spacious living room, 65" TV with sound bar and remote-controlled natural gas fireplace. Designer kitchen with a Wi-Fi-enabled refrigerator and double oven. The primary bedroom has an en-suite bath with a large shower and tub, a walk-in closet, and a screened porch with a large open deck. Wi-Fi, washer, and dryer are also included. Downstairs has poured concrete walls with abundant storage, and the 2nd Primary bedroom with a large walk-in closet. The great room has a wet bar and refrigerator. Stroll outside to a large concrete area that leads to a magnificent water feature that has waterfalls that cascade over the rocks into the pond for a mesmerizing effect on your mind. The peace and quiet of nature at its finest.

25 Linden Turn, Hendersonville

Listing courtesy of RE/MAX Results. brickcox54@gmail.com
$1,025,000
4 Beds ⋅ 4 Baths ⋅ 4390493 MLS ⋅ ACTIVE Status
Hidden among the privacy of lush hardwoods in coveted Lake Adger, 175 Green Hills Road is a breathtaking mountain retreat. Encompassing more than 14 wooded acres, this exceptional property invites exploration with over one mile of private trails winding through the natural landscape. A scenic gated drive meanders through the woods before revealing the home's welcoming exterior and beautifully appointed wraparound porch, perfectly positioned to showcase the picturesque surroundings. The grounds are equally impressive, featuring thoughtfully designed gardens and a serene koi pond accented by two soothing waterfalls, creating a setting of extraordinary peace and natural beauty. Inside, abundant windows and transoms fill the home with natural light. The stunning great room centers around a floor-to-ceiling stone fireplace with a handcrafted mantel, creating a warm yet sophisticated focal point. The open-concept floor plan flows seamlessly into the dining area and screened porch, providing effortless indoor-outdoor living. The chef's kitchen is both beautiful and functional, featuring a Wolf gas cooktop on the island with bar seating, Bosch wall oven and convection steam oven, custom cabinetry, farmhouse sink, and a charming window seat that quickly becomes everyone's favorite place to relax. The spacious main-level primary suite offers a spa-inspired bath complete with an iron clawfoot soaking tub, tile shower, dual vanities, designer lighting, and bidet. Two customized walk-in closets and a conveniently connected laundry room with built-in cabinetry and shelving enhance the suite's thoughtful design. An adjoining office with exposed wood beams and a wall of windows provides an inspiring workspace immersed in nature. A stylish powder room completes the main level. Upstairs, two generously sized guest bedrooms feature a split-bedroom layout, each offering space for sitting areas or reading nooks. A full bath serves the upper level. The expansive lower level provides exceptional flexibility with a large recreation and living area featuring a fireplace and access to the covered flagstone patio. Additional spaces include a fitness room, second office, art studio, 10' x 23' workshop, and two oversized storage rooms. In addition to the heated square footage, the lower level also offers substantial finished, unheated living space that includes a studio with kitchenette, bedroom, full bathroom, office, and additional flexible-use space—ideal for guests, hobbies, multigenerational living, or a private retreat. Outside, a pergola with a cozy firepit creates the perfect gathering space beneath the stars, making this property equally suited for relaxation and recreation. Ideally located just minutes from Tryon International Equestrian Center and within easy reach of Asheville, Greenville, Saluda, local vineyards, and the Blue Ridge Mountains, this private haven feels worlds away while remaining conveniently close to the region's finest destinations. A rare opportunity to own an extraordinary home where luxury, nature, privacy, and timeless craftsmanship come together in perfect harmony.

175 Green Hills Road, Mill Spring

Listing courtesy of Coldwell Banker Caine/Williams. ktamburro@cbcaine.com
Start Your Search

“ Based on information submitted to the MLS GRID as of . All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Some IDX listings have been excluded from this website. Properties may or may not be listed by the office/agent presenting the information © 2026 Canopy MLS as distributed by MLS GRID”

Last Updated: