• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Havmoeller by Allen Tate

List, build, or buy homes in-or-near The Palisades Charlotte NC

List, buy, or build with us | We are home®
  • Search By Community
    • The Palisades
      • Homes For Rent
      • Pending Contracts
    • Regency at Palisades
      • Pending Contracts
    • North Reach
    • Chapel Cove
    • Montreux
    • Riverpointe
    • The Sanctuary
    • River Hills
    • Tega Cay
    • The Landing
    • Reflection Pointe
    • The Vineyards
    • All of Charlotte
      • All Of Charlotte Pending Contracts
      • All of 28278 – Under Contract
  • Search by City
    • Belmont NC Homes for Sale
    • Charlotte NC Homes for Sale
    • Clover SC Homes for Sale
    • Fort Mill SC Homes for Sale
    • Gastonia NC Homes for Sale
    • Lake Wylie SC Homes for Sale
    • Matthews NC Homes for Sale
    • Pineville NC Homes for Sale
    • Rock Hill SC Homes for Sale
    • Tega Cay SC Homes for Sale
    • Waxhaw NC Homes for Sale
    • Weddington NC Homes for Sale
  • Waterfront Homes
    • All Homes In Waterfront Communities
  • Land/Lots
  • Contact Us
    • Schedule a free consultation
    • About
      • Determining The Optimal Listing Price For Your Home
      • Top 8 Reasons to work with a realtor when buying a new construction home
      • Blog
      • Relocating to Charlotte NC
    • Testimonials
      • Awards
Home » 4033 Long Arrow Drive, Concord, NC 28025 (MLS # 4412395)

20124 Bascom Ridge Drive, Cornelius, NC 28031 (MLS # 4408389)

Profile
Searches
Listings
Login
Save to Favorites
Print
Share
Share via
Share on Twitter Twitter
Share on Facebook Facebook
Share by Email Email
Email a Friend
View Virtual Tour
PRICE $3,900,000 dsIDX morgage calculator
BEDS 5
BATHS 6.5
HOME SIZE 9,724 sqft
LOT SIZE 27,008 sqft
Request More Info Schedule a Showing

Welcome to an extraordinary Mediterranean-inspired waterfront estate where timeless architecture meets luxury lakefront living. Perfectly positioned to capture breathtaking sunset views across the water, this exceptional residence offers nearly 9,800 square feet of thoughtfully designed living space with every detail curated for comfort, entertaining, and everyday elegance. A grand two-story foyer with custom iron doors and Brazilian cherry staircase sets the tone for the home's impressive interior. The expansive great room showcases soaring ceilings, a dramatic wall of windows framing panoramic lake views, and seamless access to outdoor living spaces. The gourmet chef's kitchen is appointed with rare Labrador Blue granite countertops, premium Thermador and GE appliances, a spacious island, warming drawer, and inviting gathering spaces designed for hosting family and friends. The adjoining bar features a stunning backlit onyx countertop, creating a true showpiece for entertaining. The luxurious main-level primary suite is a private retreat with tranquil water views, a fireplace, private deck access, a spa-inspired bath, and an oversized custom walk-in closet. An elevator provides convenient access to all three levels of the home. Two stunning staircases lead to the second floor, where you'll find a beautiful executive office overlooking the water, a private secondary office ideal for working from home, and three spacious bedrooms, each featuring its own private en-suite bath. A versatile flex space tucked off the rear staircase provides the perfect setting for a media room, children's playroom, or additional lounge area, offering flexibility to fit your lifestyle. Designed for both relaxation and recreation, the walk-out lower level offers an impressive second living area complete with a second kitchen, wine cellar and tasting room, theater, fitness room, guest suite, and direct access to the patio and waterfront. Whether hosting large gatherings or enjoying quiet evenings at home, every space embraces the beauty of lakeside living. Outside, enjoy beautifully landscaped grounds, expansive decks and covered patios, a private boardwalk leading to a floating dock with boat lift, accommodations for multiple jet skis, and Wi-Fi extending all the way to the dock. Additional highlights include four HVAC systems, a tile roof, three garages, circular drive with fountain, security system, and whole-home EERO mesh Wi-Fi coverage. This one-of-a-kind Lake Norman waterfront estate delivers an unparalleled lifestyle where luxury, craftsmanship, and spectacular waterfront views come together to create an unforgettable place to call home.

TRACT Crown Harbor YEAR BUILT 2005
COMMUNITY Crown Harbor GARAGE SPACES 3.0
COUNTY Mecklenburg STATUS Coming Soon
PROPERTY TYPE(S) Single Family

SCHOOLS
Elementary School Cornelius
Jr. High School Bailey
High School William Amos Hough


ADDITIONAL DETAILS
AIR Ceiling Fan(s), Central Air, ENERGY STAR Qualified Equipment
AIR CONDITIONING Yes
APPLIANCES Bar Fridge, Dishwasher, Disposal, Double Oven, Dryer, Electric Oven, Gas Oven, Gas Range, Gas Water Heater, Ice Maker, Microwave, Oven, Plumbed For Ice Maker, Refrigerator, Self Cleaning Oven, Warming Drawer, Washer
BASEMENT Exterior Entry, Finished, Interior Entry, Storage Space, Walk-Out Access, Yes
EXTERIOR Boat Slip, Dock
FIREPLACE Yes
GARAGE Attached Garage, Yes
HEAT Central, ENERGY STAR Qualified Equipment, Forced Air, Natural Gas
HOA DUES 300
INTERIOR Built-in Features, Elevator, Entrance Foyer, Kitchen Island, Pantry, Storage, Walk-In Closet(s)
LOT 0.62 acre(s)
LOT DESCRIPTION Cul-De-Sac, Waterfront
LOT DIMENSIONS 0.62
MLS STATUS Coming Soon
PARKING Circular Driveway, Garage Faces Front, Garage Faces Side
SEWER Public Sewer
STORIES 2
STYLE Mediterranean
SUBDIVISION Crown Harbor
UTILITIES Cable Available, Natural Gas Available, Cable Connected, Electricity Connected, Underground Utilities
VIEW Yes
VIEW DESCRIPTION Water
WATER Public
WATER ACCESS Lake Norman
WATERFRONT Yes
MORTGAGE CALCULATOR
   

TOTAL MONTHLY PAYMENT

0
P
I
*Estimate only

SATELLITE VIEW



 
CONTACT US ABOUT 20124 BASCOM RIDGE DRIVE
 / 
We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for Ann-Dorthe Havmoeller to contact you even if your name is on a Federal or State "Do not call List".

Listed with EXP Realty LLC Ballantyne
Date last updated: 8/9/26 11:29 PM PDT

The data relating to real estate on this website derive in part from the Internet Data Exchange program. Brokers make an effort to deliver accurate information, but buyers should independently verify any information on which they will rely in a transaction. All properties are subject to prior sale, change or withdrawal. Neither Havmoeller nor any listing broker shall be responsible for any typographical errors, misinformation, or misprints, and they shall be held totally harmless from any damages arising from reliance upon this data. This data is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Properties reported may be listed or sold by various participants in the MLS
© 2026 Carolina Multiple Listing Services, Inc.

CMLS

This IDX solution is (c) Diverse Solutions 2026.

Save favorite listings, searches, and get the latest alerts

or
Sign in to, or create an account using your existing social account:

Forgot password?
Create an Account
Fill in your email, and we'll send you a message with instructions on how to reset your password. Please make sure to use the same email address you provided during registration.
close Back to Login
close

Save your favorite listings, searches, and receive the latest listing alerts

or
Sign in to, or create an account using your existing social account:

Already have an account? Login

Primary Sidebar

Real Estate Search

We recently relocated to Charlotte in Aug 2024 and specifically did not secure a realtor until knowing our area(...)

Read More...
James Taylor
Thanks for making our first NC experience a great one thus far.

Our Coverage Areas

  • Charlotte

Footer

  • The Palisades
  • Regency At Palisades
  • North Reach
  • Chapel Cove
  • Montreux
  • Riverpointe
  • The Sanctuary
  • River Hills
  • Tega Cay
  • The Landing
  • Reflection Pointe
  • The Vineyards
  • All of Charlotte
  • About
  • Charlotte NC
  • Contact Us
  • Terms of Use
  • Sitemap

Copyright© 2026 · Quality Homes in Great Locations · Business Optimization Services Powered by Kompani Group

Luxury Portfolio International Real Estate - Well Connected logo
Allen Tate Realtors - You Make A Difference - Red Penguin Quality Service Certification
Officail Realtor symbol
Leading Real Estate Companies of The World logo mark
Allen Tate Realtors Legends Club designation
Allen Tate Power Player designation