REALHUB is on fire today

Properties

Browse or get in touch to schedule a walkthrough.

  • Nearby me
Price range

Popular features

Community features

Property features

Waterfront

View

Exterior Features

Interior Features

Style

10000 properties match your criteria

Updated 1 minute ago

E-Alert name

Set along one of Charlotte’s most distinguished residential corridors, this exceptional whole-floor penthouse at 974 Queens Road presents a rare convergence of scale, privacy, and architectural refinement. With a recent $250,000 price reduction, the opportunity to acquire a residence of this stature has become even more compelling.

Spanning more than 5,300 square feet, the residence occupies an entire floor and is framed by expansive east- and west-facing terraces—an uncommon luxury in such a prestigious, established setting. Morning light filters through the treetops, while evening skies unfold across the skyline, creating a serene yet dynamic backdrop throughout the day.

A secure elevator delivers you directly into a gracious foyer, setting the tone for the home’s thoughtful layout and elegant flow. Ten-foot ceilings, wide-plank hardwood flooring, and walls of glass define the interiors, while three gas fireplaces introduce warmth and architectural presence to the primary living spaces.

The kitchen is both refined and functional, appointed with premium appliances, custom cabinetry, distinctive tilework, and a waterfall-edge quartz island. Open to a light-filled family room with built-in cabinetry, the space is designed to support both everyday living and sophisticated entertaining.

The primary suite offers a true sense of retreat, with direct terrace access, a spa-inspired bath, and a generously scaled custom closet. Additional bedrooms and flexible living spaces provide comfort and versatility for guests, offices, or extended stays—each finished with the same attention to detail and proportion.

Outdoor living is a defining element of this penthouse. The expansive terraces extend the living experience beyond the interior, offering rare, usable outdoor space well-suited for entertaining, quiet reflection, or simply enjoying the mature canopy that surrounds the property.

With its recent price improvement, this penthouse stands as a distinguished offering for those seeking privacy, volume, and timeless appeal in one of Charlotte’s most desirable neighborhoods. A residence of quiet confidence—now thoughtfully repositioned.

Shown by private appointment.
#4249816

Charlotte

974 Queens Road

5 Beds

4 Baths

5,346 Sq.Ft.

$2,950,000

MLS#: 4249816

Great property to park a 1031, this property is perfect for a World Class Equestrian Center, Hunting Preserve and/or Wedding/Social Venue.  These preserves/venues are generating huge revenues.  The first time you step foot on 5690 Rocky Mount Church Rd, you’ll feel the history in the air. 
   As you walk through the rolling hills, past the pond reflecting the bright Carolina sky, and down to the riverbank with over 2,700 feet of Rocky River frontage, you’ll realize—this land has more than potential, It has heart. Whether you’re imagining a family homestead, a horse farm, or a personal retreat, it’s here waiting for you. Wildlife roam freely-deer, turkey, duck/impoundment and dove field—bringing the landscape to life.
     And though it feels like a world away, you’re just an hour from Charlotte, close enough for modern comforts yet far enough to truly escape. This land is more than an investment—it’s a dream waiting to be fulfilled. Come see it and start your story here.
#4188182

Polkton

5690 Rocky Mount Church Road

None Beds

None Baths

N/A

$2,949,500

MLS#: 4188182

A unique opportunity to own this beautifully redesigned custom luxury home in the desirable Ashbrook neighborhood. Following an extensive 16-month interior and exterior renovation, this entertainer’s paradise was created with a custom designed backyard boasting complete privacy for year-round entertainment. The backyard features a heated pool/spa w/waterfalls, artificial turf, three putting greens with LEDs, grill area, fireplaces and a Cape Cod outdoor shower. The highlight of the backyard centers around the fully equipped cabana with dual bars, fans/heaters, Bahama shutters and much more. On the interior, the lower level features an open layout with floor to ceiling windows/doors, an office/guest, chef’s kitchen with high-end appliances, scullery, wine room and a redesigned primary suite with dual vanities, standing tub and a private entry to the pool area. The second floor features a spacious loft with built-in desks, three bedrooms/bathrooms, bonus room with a bar and storage room.
#4050276

Charlotte

1331 Ashcraft Lane

4 Beds

4 Baths

4,315 Sq.Ft.

$2,945,000

MLS#: 4050276

Twin Lakes Custom Home Community is located on 116 acres, offering low Union county taxes and award winning schools. Residents of Twin Lakes will enjoy walking trails, a water front gazebo, championship-grade pickleball courts, and a community dock for kayacks, canoes, and stand-up paddle boards.  This is a beautiful 6 Bedroom, 6 Bath, 2 half-bath home custom built with the finest of finishes by Peters Custom Homes.
#3913468

Weddington

415 Crepe Myrtle Lane

6 Beds

6 Baths

7,474 Sq.Ft.

$2,928,053

MLS#: 3913468

Discover The Churchill, Downtown Asheville’s first ultra-luxury condominium community, setting a new standard for elevated city living. This landmark address will feature 44 refined residences in the heart of downtown, steps from Asheville’s best restaurants, galleries, and cultural experiences.  Thoughtfully designed and constructed to the highest standards, The Churchill blends timeless architecture with modern innovation. Each residence ranges from approximately 1,200 to 2,400 square feet and includes private terraces from 100 to 1,600 square feet — many equipped for natural gas grills, space heaters, or fire pits. Interiors feature 9.5–10’ ceilings, Sub-Zero and Wolf appliances, double waterfall stone countertops, custom cabinetry in white oak or walnut, authentic French white oak flooring, vented fireplaces, dual-zone HVAC, and smart home technology for lighting, climate, and window treatments. Enhanced soundproofing, solid core doors, under-floor sound mats, and acoustic separations ensure privacy and tranquility.  Amenities at The Churchill redefine luxury living. The grand lobby welcomes residents and guests with 14’ ceilings, elegant architectural details, and a concierge desk offering personalized service. The 9th floor Sunrise Garden Terrace provides lush landscaping, fire pits, and a yoga deck overlooking the Blue Ridge Mountains, while the Sunset Owners’ Lounge and Patio offer panoramic city and mountain views, indoor and outdoor fireplaces, and a full outdoor kitchen for entertaining.  Additional amenities include a state-of-the-art fitness center with yoga area, a private game room with media lounge, shuffleboard, and poker tables, secure deeded parking with EV-charging options, climate-controlled storage, high-speed elevators, local art installations, and an adjacent dog walking area. The building incorporates eco-friendly features including a green roof and energy-efficient design in accordance with the newest North Carolina State Building Code, proactively adopted for enhanced safety and quality. Early commitment secures priority residence selection along with parking and storage assignments.
#4312872

Asheville

161 Church Street 704

3 Beds

3 Baths

2,398 Sq.Ft.

$2,925,560

MLS#: 4312872

Experience an exquisite blend of timeless elegance & beautifully renovated sophistication, the epitome of luxury living in this meticulously restored historic home. Nestled in prestigious Biltmore Forest, it marries yesteryear's charm with modern comfort. Step through the grand entrance adorned with its original 100-yr-old refurbished chandelier sparkling like new - be transported to an era of grandeur. Indulge in the state-of-the-art gourmet kitchen boasting top-tier appliances and Italian Carrera marble countertops, embodying modern culinary luxury. The open design seamlessly connects kitchen, dining and living areas creating a harmonious space where family & friends can gather for memorable meals and engaging conversations. Historic luxury artfully modernized. A rare opportunity to own a piece of history while enjoying the comforts of current living, this is more than a home; it's a lifestyle refined by the past and designed for today's discerning connoisseur–your dream home awaits!
#4061853

Asheville

3 Fairway Place

6 Beds

5 Baths

6,530 Sq.Ft.

$2,925,000

MLS#: 4061853

An exceptional, stabilized investment portfolio opportunity centrally located in the heart of downtown Brevard. This fully occupied portfolio sale is a rare chance to confidently invest in the core of Brevard's vibrant city center, and take part in its incredible long-term community growth. The offering consists of two buildings, with 5 long standing stabilized tenants in place, all with main street signage and frontage. Both buildings were renovated and modernized in 2014 for optimal space allocation, aesthetics, improved energy efficiency, and life safety. The diverse group of tenant uses that occupy these properties benefit from high visibility, easy access, and tremendous foot traffic at this location. This investment has been
remarkably well managed and cared for over the years, which can be seen in every aspect of both buildings.
Don't miss this rare downtown opportunity.
#4319306

Brevard

36 & 44 E Main Street

None Beds

None Baths

N/A

$2,925,000

MLS#: 4319306

Paint a picture of an exquisite residence designed for comfort, entertainment, and privacy and you will see 7 Walnut Grove. Located in a gated community near Asheville, it's a blend of opulent amenities and natural beauty, standing on 10 acres of land that offer breathtaking panoramic views and are perfect for equestrian pursuits. The entryway sets a tone of elegance from the first impression, hinting at the quality and craftsmanship present throughout the home.  Six stone fireplaces add aesthetic appeal while the primary suite includes a jacuzzi tub, a marble shower with multiple heads, and an adjoining steam room for ultimate relaxation. The land is suitable for horses, with the possibility of building a 4-stall horse barn with HOA approval, making it an ideal estate for equestrian enthusiasts. An in-law or caretaker suite with a mini kitchen and private porch is attached through the gallery hall.
#4118495

Asheville

7 Walnut Grove Lane

5 Beds

6 Baths

11,163 Sq.Ft.

$2,910,000

MLS#: 4118495

None
#4135430

Charlotte

3714 Haven Drive

5 Beds

5 Baths

5,354 Sq.Ft.

$2,905,000

MLS#: 4135430

202+/- Acres. HUGE PRICE REDUCTION and now BETTER THAN EVER after EXTENSIVE grounds work!  Boasting over two hundred acres nearly surrounded by USFS with almost 3/4 mile of Nolichucky River frontage, this incredible mountain property features an amazing rustic yet modern lodge with multiple outbuildings & alternate living spaces to create your very own private retreat in the heart of the Appalchian Mountains. Whether you're wanting a mountain estate or bug out property, this large private riverfront property is perfect for hunting, fishing, hiking, camping, homesteading or use as a family compound, luxurious off-grid getaway or lodge. While the effects of Hurricane Helene are still somewhat evident along the banks of the Nolichucky River, this property has undergone extensive repairs and updates to roads, buildings and infrastructure. The river is back to its former beauty, and the lodge itself stands unaffected and ever vigilent high atop its mountain perch. While the main house retains the charm of Appalachia with its tasteful upgrades & modern amenities, the guest & river houses provide even more room for friends & family. Scattered throughout the property you'll find serene brooks, mountain springs, noisy waterfalls, a trout pond, a bass pond & even a professional skeet shooting range, all as peacefull as you'd imagine. With miles of gravel roads, plenty of space to expand,and even a new homesite on the river, this incredible mountain property is a once in a lifetime opportunity to create a legacy for you & your family or a world class corporate retreat or nature/game preserve. This property, like the mountain on which is sits is timeless, resilient, and unbelievably beautiful. You need to see it to believe it. Call for more information or to schedule a private tour.
#4327209

Green Mountain

2736 White Oak Flats Road

4 Beds

4 Baths

2,964 Sq.Ft.

$2,900,000

MLS#: 4327209

Discover the perfect blend of peaceful country living and convenient access to Asheville, Brevard, and Hendersonville. Six parcels make up this multi generational 59 +/- acre parcel.  It is just minutes from the Turkey Pen entrance of Pisgah National Forest—an outdoor lover’s paradise with hiking, horseback riding, and mountain biking right at your doorstep. Approximately 20+ acres are gentle and level terrain. Whether you're envisioning a private estate, equestrian retreat, or working farm, this land offers the freedom to bring your vision to life. Enrolled in both the Wildlife Conservation Land Program and the Present-Use Value Program, the property also provides valuable tax deferment benefits. At its center sits a well-maintained brick ranch home, surrounded by open fields perfect for grazing, riding, or future home sites. A peaceful pond adds to the charm, offering a serene place to unwind and soak in the natural beauty. Multiple potential building sites. Ideal for a family estate or homesteading and farming.
#4312252

Mills River

71 Happy Valley Drive

3 Beds

2 Baths

1,953 Sq.Ft.

$2,900,000

MLS#: 4312252

This beautiful home is nestled in the heart of Foxcroft and offers everything one could want. Spacious and inviting, it features multiple living areas, including a cozy living room, a family room, and a downstairs playroom—perfect for all kinds of activities and uses. The open-concept kitchen boasts ample storage, modern appliances, and a charming breakfast area with a view of the serene backyard patio. Designed for both comfort and style, this timeless home is well thought out. The spacious downstairs primary suite is a true retreat, featuring two separate bathroom spaces and a generous closet that connects to a private home gym. Upstairs, three additional bedrooms and two full baths ensure everyone has their own space. The expansive backyard features low-maintenance turf and natural areas that blend seamlessly with the landscape as well as a covered patio, perfect for entertaining.
#4219881

Charlotte

2315 Red Fox Trail

4 Beds

4 Baths

5,214 Sq.Ft.

$2,900,000

MLS#: 4219881

Stately story & a half home on flat .82 acre lot w/circular drive.Spacious foyer opens to LR w/ FP.Adjoined by oversized DR connected by wine bar to fabulous kitchen/family room with FP.Breakfast room surrounded by wrap around windows,computer niche,drop zone & laundry down.Great room w/ FP, coffered ceiling,& french doors opening to uncovered/covered patio.Primary on main with two spacious walk in closet,stunning bathroom with shower & free standing tub. Two additional bedrooms, one full & one half bath on main. Guest wing up w/ br,flex space,full bath&oversized cedar closet perfect for off season clothes.Opposite wing up w/ bonus/5th br full bath &exercise room.Private flat backyard fenced in pool w/ tons of decking. Detached 2 car garage w/ bonus/6th br above.Full bath, kitchenette down & additional patio w/ tv perfect for entertaining by the pool.Shed w/ wood working space. Covered garden.The layout,livability,&privacy of this home is unrivaled you must see it to believe it!
#4257447

Charlotte

2410 Vernon Drive

6 Beds

5 Baths

5,158 Sq.Ft.

$2,900,000

MLS#: 4257447

Great opportunity acreage for development!Property was rezoned commercial..This property offers 42+- acres.Located just outside the town of Troutman right behind the concrete plant off Murdock road. This property offers easy access to I-77 and is very close to major commercial growth. There are two homes and numerous barns/buildings on the property that will convey at no value.
#4025673

Troutman

134 Iredell Avenue

None Beds

None Baths

N/A

$2,900,000

MLS#: 4025673

Located on a quiet cul-de-sac in the Sailview Community, this remodeled home offers stunning views of Lake Norman's main channel from almost every room. Inside, you'll find custom cabinetry and shelving in the gourmet kitchen, bar, fireplace surround, and owner's bath/closet. The home boasts top-of-the-line appliances, heated Travertine flooring, a sunroom addition, and Control4 Smart Home Automation. These are just some of the many recent updates that make this home special. Outside, discover a luxurious backyard paradise with newly constructed retaining walls, a hot tub terrace, a four-hole putting green, fire features, and a remote patio awning. One of the many highlights is a private white sand beach overlooking beautiful Lake Norman. As part of the Sailview Community, you'll also have access to a lap pool, clubhouse, sand volleyball court, and pickleball/tennis courts.
**NEW ROOF - construction completed on July 18th**
#4242255

Denver

3988 Channel Point Lane

4 Beds

4 Baths

4,107 Sq.Ft.

$2,900,000

MLS#: 4242255

1 ... 199 200 201 202 203 ... 666
* Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2024. First Multiple Listing Service, Inc.
 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.