• 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 » 3133 Amay James Avenue, Charlotte, NC 28208 (MLS # 4321740)

188 Freshwater Lane, Mooresville, NC 28117 (MLS # 4361754)

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
PRICE $1,249,000 dsIDX morgage calculator
BEDS 4
BATHS 4.5
HOME SIZE 5,188 sqft
LOT SIZE 37,026 sqft
Request More Info Schedule a Showing

Sellers have now moved out and had the house freshly painted and floors refinished. This home is set within the sought-after community, The Farms, this thoughtfully designed home combines timeless style with comfortable everyday living. The main level features a spacious primary suite with an updated ensuite bath, providing a private retreat with modern finishes. Entertain with ease in the formal dining room, while the inviting living room showcases a cozy fireplace and custom built-in bookcases. The well-appointed kitchen flows seamlessly into a bright breakfast area and a charming keeping room with its own fireplace"”ideal for gathering and everyday living. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and a versatile bonus room perfect for a playroom, home gym, or additional living space. The finished basement expands your living options with a large recreation room complete with a wet bar, dedicated office space, and an impressive media room featuring tiered seating"”perfect for movie nights or game days. Step outside to enjoy peaceful evenings on the terrace with an outdoor fireplace, creating a warm and inviting setting year-round. A pool company has confirmed the backyard can accommodate a pool, offering the opportunity to design your own private oasis. Residents of The Farms enjoy exceptional amenities including a clubhouse, outdoor pool, tennis courts, pickle ball and a vibrant calendar of community activities, all just minutes from the shores of Lake Norman. This home truly delivers space, style, and the lifestyle you've been searching for.

TRACT The Farms YEAR BUILT 2005
COMMUNITY The Farms GARAGE SPACES 3.0
COUNTY Iredell STATUS Active
PROPERTY TYPE(S) Single Family

SCHOOLS
Elementary School Woodland Heights
Jr. High School Woodland Heights
High School Lake Norman


ADDITIONAL DETAILS
AIR Central Air
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Double Oven, Electric Cooktop, Microwave, Oven, Tankless Water Heater
BASEMENT Daylight, Exterior Entry, Finished, Full, Interior Entry, Storage Space, Walk-Out Access, Walk-Up Access, Yes
CONSTRUCTION Brick
FIREPLACE Yes
GARAGE Attached Garage, Yes
HEAT Central, Forced Air, Natural Gas
HOA DUES 880
INTERIOR Breakfast Bar, Built-in Features, Central Vacuum, Entrance Foyer, Open Floorplan, Pantry, Storage, Walk-In Closet(s), Wet Bar
LOT 0.85 acre(s)
LOT DESCRIPTION Private, Wooded
LOT DIMENSIONS 0.85
MLS STATUS Active
PARKING Driveway, Garage Faces Side
SEWER Septic Tank
STORIES 2
SUBDIVISION The Farms
MORTGAGE CALCULATOR
   

TOTAL MONTHLY PAYMENT

0
P
I
*Estimate only

SATELLITE VIEW



 
CONTACT US ABOUT 188 FRESHWATER LANE
 / 
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 Mooresville
Date last updated: 6/30/26 12:01 AM 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

Dorthe did a great job with helping us buy and sell. I will and have recommended her to other potential clients.

Read More...
Sandy and John Goldsbury
2022-03-25

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