- 4 beds
- 5 baths
- 5,262 sqft
- ~38 acre lot
- $807 per sqft
- 1790 build
Mayapple Farm | This is an incredible opportunity to live minutes from Middleburg on an extraordinarily unique property. The house is rich in character, known as the Nathan Ayer House, and was built in 1790 in Preston City, Connecticut, dismantled, and moved to Virginia hunt country. The quality and authenticity throughout the home is remarkable – the charming floorboards, 9 stone fireplaces, custom woodworking, original hardware, and exposed beams only begin to describe the features of this home. The kitchen, primary bathroom, and guest bathroom have been tastefully renovated by the current owner with quartzite counters, custom cabinetry, and high-end finishes. There is an inviting pool, terraces, and lush perennial gardens off the rear of the house, all surrounded by stately dry stacked stone walls. The bank barn dates back to the late 19th century and is constructed of hand-hewn oak and poplar beams and fieldstone, originally built in Leesburg, Virginia. The stone barn offers endless possibilities for entertaining, creative workspace, and, of course, horses. The home is heated and cooled by a geothermal system with seven separate zones. The property has frontage and access to Goose Creek and provides ultimate privacy.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 21, 2025
•
MLS# VALO2096804 —
The Building
-
Year Built:1790
-
Year Built Source:Assessor
-
Roof:Metal
-
New Construction:No
-
Construction Materials:Masonry, Log, Wood Siding
-
Builder Name:Nathan Ayer
-
Structure Type:Detached
-
Architectural Style:Colonial, Farmhouse/National Folk
-
Levels:3
-
Security Features:Exterior Cameras, Security System
-
Accessibility Features:None
-
Foundation Details:Concrete Perimeter
-
Basement:Yes
-
Basement Type:Walkout Level, Connecting Stairway, Improved, Interior Access
-
Building Winterized:No
-
Total SqFt Source:Assessor
-
Total Below Grade SqFt:1466
-
Total Below Grade SqFt Source:Assessor
-
Above Grade Finished Area Units:Square Feet
-
Above Grade Finished SqFt:3796
-
Above Grade Finished SqFt Source:Assessor
-
Below Grade Finished Area Units:Square Feet
-
Below Grade Unfinished Area Units:Square Feet
-
Below Grade Finished SqFt Source:Assessor
-
Below Grade Finished SqFt:1466
-
Below Grade Unfinished SqFt Source:Assessor
-
Tax Total Finished SqFt:5262
Interior
-
Interior Features:Built-Ins, Chair Railings, Crown Moldings, Dining Area, Double/Dual Staircase, Primary Bath(s), Upgraded Countertops, Wet/Dry Bar, Additional Stairway, Attic, Bathroom - Walk-In Shower, Breakfast Area, Exposed Beams, Floor Plan - Traditional, Formal/Separate Dining Room, Kitchen - Eat-In, Sound System, Wood Floors
-
Flooring Type:Stone, Wood, Tile/Brick
-
Fireplace:Yes
-
Fireplaces:9
-
Fireplace Features:Mantel(s), Stone, Wood
-
Wall & Ceilings:9'+ Ceilings, Dry Wall
-
Living Area SqFt Source:Assessor
Room Dimensions
-
Total SqFt:5262
-
Living Area SqFt:5,262 Sqft
Financial & Terms
-
Sale Type:Standard
-
Possession:Settlement
-
Lease Considered:No
Location
-
Directions:GPS 35571 Millville Rd, Middleburg : From Middleburg, right on Madison Street, becomes Foxcroft Road, cross Goose Creek, left on Snake Hill Road, left on Millville Road to drive on the left.
-
Latitude:38.98203760
-
Longitude:-77.77434618
The Property
-
Property Type:Residential
-
Property Condition:Excellent
-
Lot Size Units:Square Feet
-
Lot Size Acres:37.65
-
Lot Size Source:Assessor
-
Lot Features:Backs to Trees, Fishing Available, Front Yard, Landscaping, Open, Poolside, Premium, Private, Secluded, Stream/Creek, Unrestricted
-
Lot SqFt:1,640,034 Sqft
-
Inclusions:Fireplace accessories convey. Additional personal property can convey with agreeable terms.
-
Zoning:AR2
-
View:Creek/Stream, Pasture, Scenic Vista
-
In City Limits:No
-
Outdoor Living Structures:Terrace, Patio(s)
-
Other Structures:Above Grade, Below Grade
-
Horse:Yes
-
Horse Amenities:Horse Trails, Horses Allowed, Paddock
-
Waterview:Yes
-
Fencing:Masonry/Stone, Board, Wood
-
Waterfront:Yes
-
Water Oriented:Yes
-
Water Access:Yes
-
Water Access Features:Fishing Allowed, Private Access
-
Water Body Type:Creek/Stream
-
Navigable Water:No
-
Water Frontage In Feet:2700
-
Ground Rent Exists:No
Listing Agent
- Contact info:
- Agent phone:
- (540) 395-1680
- Office phone:
- (540) 212-9993
Taxes
-
Tax ID Number:598294674000
-
Tax Year:2025
-
Tax Annual Amount:$21,052
-
Tax Assessed Value:$2,605,710
-
Year Assessed:2025
-
County Tax:21052.00
-
Total Taxes Payment Frequency:Annually
Beds
-
Bedrooms:4
-
Upper Level Bedrooms:4
-
Upper Level 1 Bedrooms:4
Baths
-
Total Baths:5
-
Full Baths:3
-
Half Baths:2
-
Main Level Baths:2.00
-
Main Level Half Baths:2
-
Upper Level Full Baths:3
-
Upper Level Total Baths:3
-
Upper Level Total Baths:3.00
-
Upper Level Full Baths:3
Heating & Cooling
-
Cooling Type:Geothermal, Zoned
-
Central Air:No
-
Cooling Fuel:Geothermal
-
Heating:Yes
-
Heating Type:Zoned
-
Heating Fuel:Geo-thermal
Utilities
-
Sewer/Septic:Septic = # of BR
-
Hot Water:Electric
-
Water Source:Private
Appliances
-
Appliances:Dishwasher, Disposal, Icemaker, Refrigerator, Stainless Steel Appliances
-
Laundry Type:Has Laundry, Basement
Schools
-
Elementary School:Call School Board
-
Middle School:Call School Board
-
High School:CALL SCHOOL BOARD
-
School District Name:Loudoun County Public Schools
-
School District Source:Listing Agent
The Community
-
Subdivision Name:Middleburg
-
Senior Community:No
-
Exterior Features:Extensive Hardscape, Sidewalks, Stone Retaining Walls, Exterior Lighting, Gutter System, Outbuilding(s)
-
Pool:Yes - Personal
-
Pool Features:In Ground, Heated
-
Spa:No
-
HOA:No
-
Condo/Coop Association:No
Parking
-
Total Garage and Parking Spaces:2
-
Garage:Yes
-
Garage Features:Garage Door Opener, Garage - Rear Entry
-
Garage Spaces:2.00
-
Type of Parking:Detached Garage, Driveway
-
Parking Features:Gravel Driveway
-
# of Detached Garage Spaces:2
Extra Units
-
Vacation Rental:No
Monthly cost estimate

Asking price
$4,250,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$22,757
|
Taxes | $1,754 |
Insurance | $1,168 |
Utilities | $283 See report |
Total | $25,962/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/15/25
Jun 15, 2025
|
Listed / Active | BRIGHT | $4,250,000 |