$1,449,000
OPEN SAT 1PM - 4PM

15700 Trapshire Ct Waterford, VA 20197

Estimated payment $8,956/month

Total Views 2,154
5 Beds
3.5 Baths
4,481 Sq Ft
$323 Price per Sq Ft

Highlights

  • Popular Property
  • Horses Allowed On Property
  • Heated In Ground Pool
  • Waterford Elementary School Rated A-
  • Second Kitchen
  • Panoramic View

About This Home

Welcome to Rosemont Farm at Trevor Hill – A Serene Retreat in Historic Waterford.
Set in the heart of Waterford’s rolling countryside, Rosemont Farm at Trevor Hill offers a rare opportunity to own a home in one of Loudoun County’s most cherished and picturesque historic communities. This inviting residence is part of a quaint neighborhood that enjoys 123 acres of shared open space, a haven for nature lovers and outdoor enthusiasts. With the peaceful Catoctin Creek winding through—ideal for trail riding, hiking, exploring, and even regulated hunting. The home welcomes you with a classic two-story foyer and a traditional layout designed for both comfort and entertaining. A private office with French doors provides a quiet workspace, while the formal living room features a cozy gas fireplace. The spacious dining room is perfect for gatherings, and the sun-drenched sunroom—with tile flooring and tranquil views—offers a serene space to unwind. Refinished hardwood floors grace the main level, staircase, and upper level, adding warmth and charm throughout.The kitchen is a chef’s dream, complete with an island, double ovens, gas cooktop, pantry, and a breakfast room that opens to a balcony through French doors. The adjacent family room is warmed by a pellet stove and opens to a deck overlooking the in-ground sports pool with slide and built in hot tub, along with a free-standing hot tub for year-round enjoyment and beautifully landscaped grounds for relaxation and entertaining. Upstairs, the expansive primary suite includes a sitting room, an amazing walk-in closet, and ensuite bath. Three additional bedrooms and a full bath complete the upper level with hardwood flooring throughout. The walk-out basement features a complete in-law or au pair suite with a gas fireplace, a full kitchen -with electric stove, sink, and full-size refrigerator- a bedroom, recreation rooms, and generous storage ideal for multi-generational living or guest accommodations.
Upgraded Pella vinyl windows installed in 2016, Whole-house generator for peace of mind, Owned 1000-gallon propane tank, New electric water heater Fall 2024. Step outside to enjoy the fenced, raised-bed vegetable garden, and stroll to your own flourishing private orchard featuring apple, peach, plum, cherry, pear, apricot, persimmon, walnut, pecan, and fig trees. The grounds are adorned with mature magnolia, oak, maple, birch, bald cypress, weeping willow, and vibrant crepe myrtle trees, creating a truly enchanting setting. Three storage sheds for garden tools, mowers, hobbies and pool equipment. Rosemont Farm at Trevor Hill is more than a neighborhood—it’s a lifestyle. With its blend of historic charm, natural beauty, and thoughtful upgrades, this exceptional property offers a peaceful retreat just minutes from the heart of Loudoun County.

Listing Agent

Diane Northern

Coldwell Banker Realty License #0225055509 Listed on: 08/15/2025

Coldwell Banker Realty

Open House Schedule

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,031

Year Built

  • Built in 1993

Lot Details

  • 3.06 Acre Lot
  • Cul-De-Sac
  • Hunting Land
  • North Facing Home
  • Partially Fenced Property
  • Wood Fence
  • Aluminum or Metal Fence
  • Landscaped
  • Planted Vegetation
  • Private Lot
  • Partially Wooded Lot
  • Backs to Trees or Woods
  • Property is in very good condition
  • Property is zoned A10, Agricultural

HOA Fees

  • $225 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • 4 Driveway Spaces
  • Side Facing Garage
  • Garage Door Opener

Property Views

  • Panoramic
  • Scenic Vista
  • Woods
  • Garden
  • Courtyard

Home Design

  • Colonial Architecture
  • Permanent Foundation
  • Asphalt Roof
  • Vinyl Siding
  • Masonry

Interior Spaces

  • Property has 3 Levels
  • Traditional Floor Plan
  • Two Story Ceilings
  • Ceiling Fan
  • Recessed Lighting
  • 3 Fireplaces
  • Wood Burning Fireplace
  • Self Contained Fireplace Unit Or Insert
  • Fireplace Mantel
  • Brick Fireplace
  • Transom Windows
  • French Doors
  • Family Room Off Kitchen
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Den
  • Recreation Room
  • Sun or Florida Room
  • Attic

Kitchen

  • Second Kitchen
  • Eat-In Kitchen
  • Built-In Oven
  • Gas Oven or Range
  • Cooktop
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom
  • Walk-In Closet
  • In-Law or Guest Suite
  • Soaking Tub
  • Walk-in Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Rear Basement Entry

Pool

  • Heated In Ground Pool
  • Poolside Lot
  • Fence Around Pool
  • Pool Equipment Shed

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Gazebo
  • Shed
  • Storage Shed
  • Porch

Schools

  • Waterford Elementary School
  • Harmony Middle School
  • Woodgrove High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heat Pump System
  • Vented Exhaust Fan
  • Power Generator
  • Water Treatment System
  • Well
  • Electric Water Heater
  • Septic Equal To The Number Of Bedrooms

Additional Features

  • Machine Shed
  • Horses Allowed On Property

Listing and Financial Details

  • Tax Lot 11A
  • Assessor Parcel Number 378403517000

Community Details

Overview

  • Association fees include common area maintenance, snow removal, trash, management, reserve funds, road maintenance
  • Rosemont Farm At Trevor Hill HOA
  • Trevor Hill Subdivision

Recreation

  • Horse Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,031

Year Built

Built in 1993

Lot Details

0

HOA Fees

$225 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Historic: No
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 8/15/2025 12:00:00 AM
  • Year Built: 1993
  • Building Winterized: No
  • Remarks Public: Welcome to Rosemont Farm at Trevor Hill – A Serene Retreat in Historic Waterford. Set in the heart of Waterford’s rolling countryside, Rosemont Farm at Trevor Hill offers a rare opportunity to own a home in one of Loudoun County’s most cherished and picturesque historic communities. This inviting residence is part of a quaint neighborhood that enjoys 123 acres of shared open space, a haven for nature lovers and outdoor enthusiasts. With the peaceful Catoctin Creek winding through—ideal for trail riding, hiking, exploring, and even regulated hunting. The home welcomes you with a classic two-story foyer and a traditional layout designed for both comfort and entertaining. A private office with French doors provides a quiet workspace, while the formal living room features a cozy gas fireplace. The spacious dining room is perfect for gatherings, and the sun-drenched sunroom—with tile flooring and tranquil views—offers a serene space to unwind. Refinished hardwood floors grace the main level, staircase, and upper level, adding warmth and charm throughout.The kitchen is a chef’s dream, complete with an island, double ovens, gas cooktop, pantry, and a breakfast room that opens to a balcony through French doors. The adjacent family room is warmed by a pellet stove and opens to a deck overlooking the in-ground sports pool with slide and built in hot tub, along with a free-standing hot tub for year-round enjoyment and beautifully landscaped grounds for relaxation and entertaining. Upstairs, the expansive primary suite includes a sitting room, an amazing walk-in closet, and ensuite bath. Three additional bedrooms and a full bath complete the upper level with hardwood flooring throughout. The walk-out basement features a complete in-law or au pair suite with a gas fireplace, a full kitchen -with electric stove, sink, and full-size refrigerator- a bedroom, recreation rooms, and generous storage ideal for multi-generational living or guest accommodations. Upgraded Pella vinyl windows installed in 2016, Whole-house generator for peace of mind, Owned 1000-gallon propane tank, New electric water heater Fall 2024. Step outside to enjoy the fenced, raised-bed vegetable garden, and stroll to your own flourishing private orchard featuring apple, peach, plum, cherry, pear, apricot, persimmon, walnut, pecan, and fig trees. The grounds are adorned with mature magnolia, oak, maple, birch, bald cypress, weeping willow, and vibrant crepe myrtle trees, creating a truly enchanting setting. Three storage sheds for garden tools, mowers, hobbies and pool equipment. Rosemont Farm at Trevor Hill is more than a neighborhood—it’s a lifestyle. With its blend of historic charm, natural beauty, and thoughtful upgrades, this exceptional property offers a peaceful retreat just minutes from the heart of Loudoun County.
  • Special Features: OpenHouse
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Microwave, Cooktop, Dishwasher, Dryer, Disposal, Exhaust Fan, Icemaker, Oven - Wall, Refrigerator, Oven/Range - Gas, Washer, Water Heater
  • Flooring Type: Hardwood, Ceramic Tile
  • Interior Amenities: 2nd Kitchen, Attic, Bathroom - Soaking Tub, Bathroom - Stall Shower, Bathroom - Walk-In Shower, Dining Area, Family Room Off Kitchen, Floor Plan - Traditional, Formal/Separate Dining Room, Kitchen - Island, Kitchen - Table Space, Recessed Lighting, Walk-In Closet(s), Water Treat System, Wood Floors
  • Window Features: Transom
  • Fireplace Features: Brick, Mantel(s), Insert, Wood
  • Fireplaces Count: 3
  • Fireplace: Yes
  • Door Features: French
  • Wall Ceiling Types: 2 Story Ceilings, 9'+ Ceilings
  • Foundation Details: Permanent
  • Levels Count: 3
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 4, Bedroom 5, Kitchen, Family Room, Basement, Breakfast Room, Sun/Florida Room, In-Law/AuPair/Suite, Office, Recreation Room, Bathroom 3, Primary Bathroom, Full Bath
  • Basement: Yes
  • Basement Type: Fully Finished, Rear Entrance, Walkout Level
  • Laundry Type: Main Floor
  • Total Sq Ft: 4843
  • Living Area Sq Ft: 4481
  • Price Per Sq Ft: 428.57
  • Above Grade Finished Sq Ft: 3381
  • Below Grade Finished Sq Ft: 1100
  • Below Grade Sq Ft: 362
  • Total Below Grade Sq Ft: 1462
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 15700

Beds/Baths

  • Bedrooms: 5
  • All Lower Level Bedrooms: 1
  • Lower Level Bedroom: 1
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Upper Level Full Bathrooms: 2
  • Lower Level Full Bathrooms: 1
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Other Structures List: Gazebo, Machine Shed, Pool Equipment Shed, Shed, Storage Barn/Shed
  • Construction Materials: Masonry, Vinyl Siding
  • Pool Features: Fenced, Heated, In Ground
  • Road Surface Type: Black Top
  • Roof: Asphalt
  • View: Courtyard, Garden/Lawn, Panoramic, Scenic Vista, Trees/Woods
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Personal
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Concrete Driveway
  • Garage Features: Garage - Side Entry, Garage Door Opener
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 6
  • Type Of Parking: Attached Garage, Driveway
  • Number of Spaces in Driveway: 4

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C, Ceiling Fan(s), Zoned
  • Electric Service: Generator
  • Heating Fuel: Electric
  • Heating Type: Heat Pump(s), Zoned
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Septic = # Of Br
  • Water Source: Well
  • Internet Services: Cable

Condo/Co-op/Association

  • HOA Fees: 225.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Fee Includes: Common Area Maintenance, Snow Removal, Trash, Management, Reserve Funds, Road Maintenance
  • HOA Name: ROSEMONT FARM AT TREVOR HILL
  • HOA: Yes
  • Senior Community: No
  • Association Recreation Fee: No

Schools

  • School District: LOUDOUN COUNTY PUBLIC SCHOOLS
  • Elementary School: WATERFORD
  • Middle School: HARMONY
  • High School: WOODGROVE
  • Elementary School Source: Listing Agent
  • High School Source: 3rd Party
  • Middle School Source: Listing Agent
  • School District Key: 121139189813
  • School District Source: 3rd Party
  • Elementary School: WATERFORD
  • High School: WOODGROVE
  • Middle Or Junior School: HARMONY

Lot Info

  • Horses: Yes
  • Fencing: Aluminum, Partially, Wood
  • Horse Amenities: Horse Trails, Horses Allowed
  • Lot Features: Backs To Trees, Cul-De-Sac, Hunting Available, Landscaping, Partly Wooded, Poolside, Private, Trees/Wooded, Vegetation Planting
  • Lot Size Acres: 3.06
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 133294.00
  • Outdoor Living Structures: Balcony, Deck(s), Patio(s), Porch(es)
  • Property Condition: Very Good
  • Year Assessed: 2025
  • Zoning: A10
  • Zoning Description: Agricultural
  • In City Limits: No

Rental Info

  • Ground Rent Exists: No
  • Lease Considered: No
  • Vacation Rental: No
  • Property Manager: No

Tax Info

  • Tax Annual Amount: 10031.00
  • Assessor Parcel Number: 378403517000
  • Tax Lot: 11A
  • Tax Total Finished Sq Ft: 4481
  • County Tax Payment Frequency: Annually
  • Tax Year: 2025

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $9,741 $1,210,100 $350,700 $859,400
2024 $10,031 $1,159,700 $325,700 $834,000
2023 $9,097 $1,035,830 $290,700 $745,130
2022 $8,002 $899,120 $220,500 $678,620
2021 $7,625 $778,090 $180,500 $597,590
2020 $7,574 $731,740 $180,500 $551,240
2019 $7,402 $708,280 $180,500 $527,780
2018 $7,505 $691,720 $180,500 $511,220
2017 $7,555 $671,590 $180,500 $491,090
2016 $7,719 $674,120 $0 $0
2015 $8,163 $538,700 $0 $538,700
2014 $7,001 $455,610 $0 $455,610
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/15/2025 08/15/25 For Sale $1,449,000 0.0% $323 / Sq Ft
08/10/2025 08/10/25 Price Changed $1,449,000 -- $323 / Sq Ft
Source: Bright MLS

Purchase History

Date Type Sale Price Title Company
Deed $331,340 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $194,000 New Conventional
Closed $314,000 No Value Available
Source: Public Records

Similar Homes in Waterford, VA

  • 15724 Trapshire Ct, Waterford, VA 20197

    $1,759,000

    • 4 Beds
    • 3.5 Baths
    • 5,736 Sq Ft
    • 15724 Trapshire Ct
    • Waterford, VA

    **140K Price Improvement!!**This horse lovers paradise is nestled within Rosemont Farm, an exclusive equestrian community of just 22 homes outside of historic Waterford, Virginia, this spectacular property has use of 120+ acres of common area riding and walking trails. At the heart of this magnificent property is a stunning cedar Acorn Deck Home situated on 6.65 acres of lush, pastoral land

    Jim Shebest Coldwell Banker Realty

    Section Image
  • 15731 Elsie Virginia Place, Waterford, VA 20197

    $1,449,999

    • 4 Beds
    • 4.5 Baths
    • 4,836 Sq Ft
    • 15731 Elsie Virginia Place
    • Waterford, VA

    Welcome to your new home at 15731 Elsie Virginia Pl, Waterford VA, 20197! This stunning Carrington home, just eight years old, is situated on a generous 3.77-acre lot, offering views of both sunrises and sunsets. Enjoy wandering in the backyard and the beauty of the small tributary that runs through the property and eventually feeds into the North Fork of the Catoctin Creek. This

    Jeremy Dalpiaz Douglas Elliman of Metro DC, LLC - Arlington

    Section Image
  • 0 Audrey Jean Dr Unit VALO2076702, Waterford, VA 20197

    $1,495,000

    • 4 Beds
    • 3.5 Baths
    • 3,850 Sq Ft
    • 0 Audrey Jean Dr
    • Unit VALO2076702
    • Waterford, VA

    Last lot available in this established Waterford neighborhood. Spectacular sunsets on over 5 acres. Priced here is our FIRST FLOOR PRIMARY SUITE - the Ash Lawn. Includes Carrington's signature farmhouse kitchen! Other plans also available to be customized. See Sales Manager for more details.Visit our DECORATED MODEL HOMES AND SALES OFFICE-16670 & 16658 Huntwick Place, Hamilton , VA 20158.

    Daniel Boris Pearson Smith Realty, LLC

    Section Image
  • 15061 Lynnford Ct, Waterford, VA 20197

    $1,450,000

    • 5 Beds
    • 3.5 Baths
    • 4,168 Sq Ft
    • 15061 Lynnford Ct
    • Waterford, VA

    Welcome to 15061 Lynnford Court—an exceptional luxury estate tucked away on a quiet cul-de-sac in the prestigious Waterford community, surrounded by scenic equestrian estates and renowned wineries. Offering a perfect balance of elegance, craftsmanship, and sweeping Blue Ridge Mountain views, this home delivers privacy, comfort, and timeless style.Situated on a beautifully landscaped lot,

    Matt Leiva Keller Williams Realty

    Section Image
  • 15019 Lynnford Ct, Waterford, VA 20197

    $1,374,900

    • 4 Beds
    • 4.5 Baths
    • 4,193 Sq Ft
    • 15019 Lynnford Ct
    • Waterford, VA

    Check out the Property Tour - It has all the info you need about this wonderful property.Step into timeless elegance at 15019 Lynnford Ct., where luxury and lifestyle converge on 2.14 beautifully sited acres in the heart of Loudoun County. Now that the 4th of July festivities have passed, it's the perfect moment to tour this impeccably maintained home, which combines timeless design with

    Geri Deane Hunt Country Sotheby's International Realty

    Section Image
  • 14735 Huber Place, Waterford, VA 20197

    $1,438,335

    • 4 Beds
    • 4.5 Baths
    • 4,868 Sq Ft
    • 14735 Huber Place
    • Waterford, VA

    Seize the extraordinary opportunity to own this breathtaking home, nestled on a sprawling highly desirable 5.00-acre homesite. This brand new incredible SINGLE FAMILY HOME by Van Metre Homes at GLENMORE FARM is ready to move in IMMEDIATELY. This BELMONT II floorplan features 4 bedrooms, 4 full plus 1 half bathrooms, and a 2 car garage providing a perfect blend of space and sophistication. As you

    Shannon L Bray Pearson Smith Realty, LLC

    Section Image
  • 14707 Farmall Ct, Waterford, VA 20197

    $1,599,000

    • 5 Beds
    • 4.5 Baths
    • 5,081 Sq Ft
    • 14707 Farmall Ct
    • Waterford, VA

    Tucked away on 3.7 serene acres surrounded by sweeping mountain views, this stunning Craftsman-style home is the perfect blend of country charm and modern elegance. Boasting 5 spacious bedrooms and 4 beautifully appointed baths on the upper level alone, this home offers over 5,100 finished square feet across two thoughtfully designed levels. A full basement with rough-ins provides endless

    Angie Bresnahan Keller Williams Realty

    Section Image

Source: Bright MLS

MLS Number: VALO2104380

Bright MLS

APN: 378-40-3517