NOT LISTED FOR SALE

41045 Stumptown Rd Waterford, VA 20197

Estimated Value: $1,328,000 - $1,414,547

4 Beds
4.5 Baths
6,016 Sq Ft
$228/Sq Ft Est. Value

Last Sold July 12, 2024

Last sale price $1,350,000 $224 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $8,561/month

24 Days on Market

Highlights

  • Home Theater
  • Heated In Ground Pool
  • Panoramic View
  • Waterford Elementary School Rated A-
  • Gourmet Kitchen
  • Open Floorplan

About This Home

As of July 2024

BACK ON THE MARKET! Perfect home for year round enjoyment!!! Just in time for summer entertaining in your own personal oasis with panoramic views of the Blue Ridge Mountains. Heated in-ground pool, hot tub, 40' composite deck, Upper and lower level gazebos, so many updates! See attached list! And Seller is leaving most of the outdoor furniture & accessories! See attached list! This Toll Brothers "Cumberland Country Manor" model is just under 7000 sq ft with with over 6,000sf of finished living space. Huge Main Level Primary Suite opens to the back deck, separate soaking tub & shower, and spacious walk in closet. Open and airy family room with cathedral ceiling and a wall of window offering picturesque views, wood burning fireplace and rear stairs leading to the upper level loft and secondary bedrooms. Gourmet island kitchen, 42" white cabinets, granite and stainless steel appliances, New glass doors in breakfast area lead to the gazebo which is perfect for eating outside and entertaining! The upper level offers an open loft area and 3 additional bedrooms. A Princess suite with full bath, and a Jack and Jill Suite with adjoining bathroom between the other two bedrooms. Finished Walkout Basement is an entertainers dream. The wetbar area opens to the pool area and features a huge rec room with pool table, work out area, media room, and an additional room which can be used for guests, and a full bath designed for pool parties with convenient access. Workshop area with tons of storage also leads out to back yard. The highlight of your personal oasis is the heated pool with fountain. Enjoy the hottub and pool year round! Cedar Gazebo, hardscape, mature landscape, and maintenance-free fencing make this yard perfect for entertaining or just relaxing at home. Custom 3 car side load garage and oversized driveway with basketball area, All the conveniences of city life (including Comcast high speed internet) in a quiet country setting. Seller conveyances attached - everything you'll need for the pool and patio area!

Last Listed By

Julie Shiley

Coldwell Banker Realty License #WVS200300948 Listed on: 05/25/2024

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,767

Year Built

  • Built in 2004

Lot Details

  • 3.25 Acre Lot
  • Backs To Open Common Area
  • Stone Retaining Walls
  • Board Fence
  • Landscaped
  • Extensive Hardscape
  • Partially Wooded Lot
  • Backs to Trees or Woods
  • Back and Front Yard
  • Property is zoned 03

HOA Fees

  • $66 Monthly HOA Fees

Parking

  • 3 Car Direct Access Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Property Views

  • Panoramic
  • Scenic Vista
  • Woods
  • Pasture
  • Mountain
  • Garden

Home Design

  • Colonial Architecture
  • Vinyl Siding
  • Brick Front
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Wet Bar
  • Curved or Spiral Staircase
  • Dual Staircase
  • Built-In Features
  • Bar
  • Chair Railings
  • Crown Molding
  • Wainscoting
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Wood Burning Fireplace
  • Fireplace Mantel
  • Brick Fireplace
  • Double Hung Windows
  • Palladian Windows
  • Casement Windows
  • French Doors
  • Entrance Foyer
  • Family Room Off Kitchen
  • Living Room
  • Formal Dining Room
  • Home Theater
  • Den
  • Library
  • Bonus Room
  • Workshop
  • Storage Room

Kitchen

  • Gourmet Kitchen
  • Breakfast Area or Nook
  • Built-In Oven
  • Gas Oven or Range
  • Cooktop with Range Hood
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Walk-In Closet
  • Soaking Tub
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Pool

  • Heated In Ground Pool
  • Fence Around Pool

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Gazebo
  • Shed

Schools

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

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Humidifier
  • Heating System Powered By Owned Propane
  • Vented Exhaust Fan
  • Programmable Thermostat
  • Propane
  • Water Treatment System
  • Water Dispenser
  • 60 Gallon+ Electric Water Heater
  • Well
  • Water Conditioner is Owned
  • Septic Equal To The Number Of Bedrooms
  • Cable TV Available

Community Details

  • Association fees include trash, management
  • Built by Toll Brothers
  • Waterford Subdivision, Cumberland Country Manor Floorplan

Listing and Financial Details

  • Assessor Parcel Number 262197646000

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,767

Year Built

Built in 2004

Lot Details

0

HOA Fees

$66 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Inclusions: Hot Tub
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2024-05-25
  • Year Built: 2004
  • Automatically Close On Close Date: No
  • Remarks Public: BACK ON THE MARKET! Perfect home for year round enjoyment!!! Just in time for summer entertaining in your own personal oasis with panoramic views of the Blue Ridge Mountains. Heated in-ground pool, hot tub, 40' composite deck, Upper and lower level gazebos, so many updates! See attached list! And Seller is leaving most of the outdoor furniture & accessories! See attached list! This Toll Brothers "Cumberland Country Manor" model is just under 7000 sq ft with with over 6,000sf of finished living space. Huge Main Level Primary Suite opens to the back deck, separate soaking tub & shower, and spacious walk in closet. Open and airy family room with cathedral ceiling and a wall of window offering picturesque views, wood burning fireplace and rear stairs leading to the upper level loft and secondary bedrooms. Gourmet island kitchen, 42" white cabinets, granite and stainless steel appliances, New glass doors in breakfast area lead to the gazebo which is perfect for eating outside and entertaining! The upper level offers an open loft area and 3 additional bedrooms. A Princess suite with full bath, and a Jack and Jill Suite with adjoining bathroom between the other two bedrooms. Finished Walkout Basement is an entertainers dream. The wetbar area opens to the pool area and features a huge rec room with pool table, work out area, media room, and an additional room which can be used for guests, and a full bath designed for pool parties with convenient access. Workshop area with tons of storage also leads out to back yard. The highlight of your personal oasis is the heated pool with fountain. Enjoy the hottub and pool year round! Cedar Gazebo, hardscape, mature landscape, and maintenance-free fencing make this yard perfect for entertaining or just relaxing at home. Custom 3 car side load garage and oversized driveway with basketball area, All the conveniences of city life (including Comcast high speed internet) in a quiet country setting. Seller conveyances attached - everything you'll need for the pool and patio area!
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Microwave, Cooktop, Dishwasher, Disposal, Dryer, Exhaust Fan, Humidifier, Icemaker, Oven - Wall, Oven/Range - Gas, Range Hood, Refrigerator, Stainless Steel Appliances, Washer, Water Conditioner - Owned, Water Dispenser, Water Heater
  • Flooring Type: Carpet, Ceramic Tile, Hardwood
  • Interior Amenities: Bar, Breakfast Area, Built-Ins, Carpet, Ceiling Fan(s), Chair Railings, Crown Moldings, Curved Staircase, Dining Area, Double/Dual Staircase, Entry Level Bedroom, Family Room Off Kitchen, Floor Plan - Open, Floor Plan - Traditional, Formal/Separate Dining Room, Kitchen - Gourmet, Kitchen - Island, Primary Bath(s), Pantry, Recessed Lighting, Soaking Tub, Stall Shower, Tub Shower, Upgraded Countertops, Wainscotting, Walk-In Closet(s), Water Treat System, Wet/Dry Bar, Wood Floors
  • Window Features: Palladian, Casement, Double Hung
  • Fireplace Features: Mantel(s), Wood, Brick
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Door Features: French
  • Wall Ceiling Types: 2 Story Ceilings, 9'+ Ceilings, Cathedral Ceilings, High
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Den, Basement, Library, Foyer, Laundry, Storage Room, Workshop, Media Room, Bonus Room, Primary Bathroom
  • Basement: Yes
  • Basement Type: Full, Walkout Level
  • Laundry Type: Main Floor
  • Total Sq Ft: 6914
  • Living Area Sq Ft: 6016
  • Price Per Sq Ft: 327.99
  • Above Grade Finished Sq Ft: 4116
  • Below Grade Finished Sq Ft: 1900
  • Below Grade Sq Ft: 898
  • Total Below Grade Sq Ft: 2798
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 41045

Beds/Baths

  • Bedrooms: 4
  • Main Level Bedrooms: 1
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 2.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Main Level Full Bathrooms: 1
  • 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, Shed
  • Construction Materials: Brick, Brick Front, Vinyl Siding
  • Exterior Features: Extensive Hardscape, Exterior Lighting, Stone Retaining Walls, Secure Storage
  • Pool Features: Fenced, In Ground, Heated
  • View: Garden/Lawn, Mountain, Panoramic, Pasture, 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: 3.00
  • Garage: Yes
  • Parking Features: Asphalt Driveway
  • Garage Features: Garage - Side Entry, Garage Door Opener, Inside Access, Oversized
  • Attached Garage Spaces: 3
  • Total Garage And Parking Spaces: 3
  • Type Of Parking: Attached Garage, Driveway, Off Street

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Ceiling Fan(s), Central A/C, Programmable Thermostat, Zoned
  • Heating Fuel: Propane - Owned
  • Heating Type: Central, Forced Air, Programmable Thermostat, Humidifier, Zoned
  • Heating: Yes
  • Hot Water: 60+ Gallon Tank, Electric
  • Sewer/Septic System: Septic = # Of Br
  • Utilities: Cable Tv, Propane
  • Water Source: Well
  • Internet Services: Broadband, Cable

Condo/Co-op/Association

  • HOA Fees: 66.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Fee Includes: Trash, Management
  • HOA: Yes
  • Senior Community: No

Schools

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

Lot Info

  • Additional Parcels: No
  • Fencing: Board
  • Lot Features: Backs - Open Common Area, Backs To Trees, Front Yard, Landscaping, Partly Wooded, Rear Yard
  • Lot Size Acres: 3.25
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 141570.00
  • Outdoor Living Structures: Deck(s), Patio(s)
  • Year Assessed: 2023
  • Zoning: 03
  • In City Limits: No

Building Info

  • Builder Name: Toll Brothers

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 7767.00
  • Assessor Parcel Number: 262197646000
  • Tax Total Finished Sq Ft: 6016
  • County Tax Payment Frequency: Annually
  • Tax Year: 2019
  • Close Date: 07/12/2024

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 25, 2024
Closed on
Jul 11, 2024
Sold by
Smith Robert Joseph and Smith Nancy
Bought by
Michael Hammond Geyer Revocable Trust and Helen Merita Geyer Revocable Trust
Seller's Agent
Julie Shiley
Coldwell Banker Realty
Buyer's Agent
Scott Petersen
Pearson Smith Realty, LLC
List Price
$1,350,000
Sold Price
$1,350,000
Total Days on Market
24
Views
55
Current Estimated Value
$1,370,637

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$20,637
Avg. Annual Appreciation
1.94%
Original Mortgage
$945,000
Outstanding Balance
$939,514
Interest Rate
7.03%
Mortgage Type
New Conventional
Estimated Equity
$431,123

Purchase Details

Closed on
Nov 8, 2022
Sold by
Smith Robert Joseph
Bought by
Robert Joseph Smith And Nancy Jean Smith Revo

Purchase Details

Listed on
Feb 17, 2020
Closed on
Mar 9, 2020
Sold by
Anderson Jonathan E and Anderson Elizabeth D
Bought by
Smith Robert J and Smith Nancy J
Seller's Agent
Bob Caines
RE/MAX Distinctive Real Estate, Inc.
Buyer's Agent
Julie Shiley
Coldwell Banker Realty
List Price
$813,000
Sold Price
$813,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.72%
Original Mortgage
$831,699
Interest Rate
3.5%
Mortgage Type
VA

Purchase Details

Closed on
Dec 6, 2004
Sold by
Toll Land Ix L P
Bought by
Anderson Jonathan E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$460,000
Interest Rate
5.69%
Mortgage Type
New Conventional

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

Purchase History

Date Buyer Sale Price Title Company
Michael Hammond Geyer Revocable Trust $1,350,000 Psr Title
Robert Joseph Smith And Nancy Jean Smith Revo -- --
Smith Robert J $813,000 Old Towne Title
Anderson Jonathan E $728,444 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Michael Hammond Geyer Revocable Trust $945,000
Previous Owner Smith Robert Joseph $150,001
Previous Owner Smith Robert J $847,215
Previous Owner Smith Robert J $831,699
Previous Owner Anderson Jonathan E $300,000
Previous Owner Anderson Jonathan E $417,000
Previous Owner Anderson Jonathan E $460,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/12/2024 07/12/24 Sold $1,350,000 0.0% $224 / Sq Ft
05/25/2024 05/25/24 For Sale $1,350,000 +66.1% $224 / Sq Ft
03/10/2020 03/10/20 Sold $813,000 0.0% $135 / Sq Ft
02/17/2020 02/17/20 Pending -- -- --
02/17/2020 02/17/20 For Sale $813,000 -- $135 / Sq Ft
Source: Bright MLS

Tax History Compared to Growth

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
2024 $10,312 $1,192,140 $327,800 $864,340
2023 $9,534 $1,089,570 $292,800 $796,770
2022 $8,381 $941,730 $222,200 $719,530
2021 $8,047 $821,080 $182,200 $638,880
2020 $7,937 $766,880 $182,200 $584,680
2019 $7,768 $743,330 $182,200 $561,130
2018 $7,855 $723,940 $182,200 $541,740
2017 $8,041 $714,770 $182,200 $532,570
2016 $7,537 $658,260 $0 $0
2015 $8,000 $522,660 $0 $522,660
2014 $7,848 $504,370 $0 $504,370
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in Waterford, VA

  • 15058 Bankfield Dr, Waterford, VA 20197

    $1,450,000

    • 5 Beds
    • 6.5 Baths
    • 7,933 Sq Ft
    • 15058 Bankfield Dr
    • Waterford, VA

    One of the largest homes on the market in Loudoun County. Magnificent Colonial Home on three acres in sought after Waterford Ridge. This home has 8597 total square feet. NUMEROUS UPGRADES & ENHANCEMENTS, a 3-car garage with an epoxy aspartic floor. This home is on three park-like acres which is both private and open with a STUNNING VISTA. A beautiful fenced yard which is backed by trees and more

    Louis Cironi Evergreen Ridge Realty

    Section Image
  • 15058 Bankfield Dr, Waterford, VA 20197

    $1,450,000

    • 5 Beds
    • 6.5 Baths
    • 7,933 Sq Ft
    • 15058 Bankfield Dr
    • Waterford, VA

    One of the largest homes on the market in Loudoun County. IMMEDIATE AVAILABILITY upon a successful settlement. Magnificent Colonial Home on three acres in sought after Waterford Ridge. This home has 8597 total square feet. NUMEROUS UPGRADES & ENHANCEMENTS, a 3-car garage with an epoxy aspartic floor. This home is on three park-like acres which is both private and open with a STUNNING VISTA. A

    Louis Cironi Evergreen Ridge Realty

    Section Image
  • 15064 Barlow Dr, Waterford, VA 20197

    $1,495,000

    • 6 Beds
    • 6.5 Baths
    • 8,169 Sq Ft
    • 15064 Barlow Dr
    • Waterford, VA

    Luxury living with panoramic vista and mountain views! This elegant home has three fully finished levels and a total of 8,100 square feet of refined living space. This home blends timeless elegance with modern comfort. The main level has expansive windows, soaring ceilings, and designer finishes throughout. Enjoy preparing meals in the well appointed kitchen with oversized island, stainless

    Kelly Gaitten Berkshire Hathaway HomeServices PenFed Realty

    Section Image
  • 15600 Britenbush Ct, Waterford, VA 20197

    $1,449,000

    • 4 Beds
    • 5 Baths
    • 4,036 Sq Ft
    • 15600 Britenbush Ct
    • Waterford, VA

    Equestrian dream home/farmette now available in a horse friendly community, ready for your horses! This charming Cape Cod is located in the exclusive Rosemont Farm enclave, set on over 5 fully fenced acres with a welcoming front porch. This rare beauty comes complete with 125 acres of manicured community riding trails, large 3 stall barn (that can be expanded to 5 stalls) which boasts a heated

    Michele Gibson Samson Properties

    Section Image
  • 38936 Silver King Cir, Waterford, VA 20197

    $1,475,000

    • 5 Beds
    • 4.5 Baths
    • 5,234 Sq Ft
    • 38936 Silver King Cir
    • Waterford, VA

    Welcome to a rare opportunity on one of Glenmore Farm's most premium lots! This 2023 built Belmont II model by Van Metre offers the absolute best of both worlds - the feeling of brand new construction while also having completed all of the post-build to-dos and upgrades! This lot was one of the first ones purchased in the neighborhood, which is no surprise because it boasts STUNNING mountain

    Taylor Tolbert Pearson Smith Realty, LLC

    Section Image
  • 14864 Huber Place, Waterford, VA 20197

    $1,431,340

    • 5 Beds
    • 5.5 Baths
    • 4,792 Sq Ft
    • 14864 Huber Place
    • Waterford, VA

    MAY 2025 DELIVERY!! Seize the extraordinary opportunity to own this breathtaking home, nestled on a sprawling highly desirable 4.45-acre homesite! This brand-new incredible SINGLE-FAMILY HOME by Van Metre Homes at GLENMORE FARM is ready to move in MAY 2025!! This BELMONT II floorplan features 5 bedrooms, 5 full plus 1 half bathrooms, rear deck, and a 2 car garage with electric car charging

    Shannon L Bray Pearson Smith Realty, LLC

    Section Image

Source: Bright MLS

MLS Number: VALO2071992

Bright MLS

APN: 262-19-7646