NOT LISTED FOR SALE

40844 Tulip Poplar Place Aldie, VA 20105

Willowsford Neighborhood

Estimated Value: $1,603,000 - $1,765,832

4 Beds
4.5 Baths
5,970 Sq Ft
$283/Sq Ft Est. Value

Last Sold August 08, 2023

Last sale price $1,520,000 $255 Per Sq Ft

Est. 11% increase in value since last sale

Current estimated payment $10,650/month

Highlights

  • Mountain View
  • Rambler Architecture
  • 2 Fireplaces
  • Willard Middle School Rated A
  • Backs to Trees or Woods
  • Community Pool

About This Home

As of August 2023

STUNNING AND SPACIOUS RAMBLER in award-winning WILLOWSFORD!! This popular and rarely available Drees Annandale is the ultimate main level living floor plan with 3570 finished sq ft on the main level and an additional 2400 finished sq ft on the lower level. Space abounds in this like-new home loaded with upgrades and features. The main level boasts 10 foot ceilings, custom tray ceilings, hardwood floors, a home office, and a great room with living and dining spaces complete with a wall of windows and sliding doors leading to a large covered back porch with gas fireplace and pre-wired for outdoor tv. Back inside, the highlight is the dream Chef's kitchen showcasing high-end appliances including a Sub-Zero built-in refrigerator, Wolf double ovens, gas cooktop, microwave and warming drawer, as well as two dishwashers and an abundance of cabinetry with pull out shelving and under-cabinet lighting, a pot filler, and custom wine bar to top it off! On this level you will also find an expansive primary suite with an impressive bathroom featuring a pocket door, architectural barrel ceiling, stand alone bathtub, dual vanities, custom-tiled shower, and large closets with built-ins for all your storage needs. A generously sized laundry room with sink and additional cabinetry is conveniently located adjacent to the primary suite and just off the entry from the 3-car garage. Two secondary en-suite bedrooms and one half bathroom round out this main level. A beautiful, wide staircase leads you to the lower level, where you will find a sprawling recreation room, a fourth en-suite bedroom, a bonus room perfect for a home gym, media room, or guest bedroom, and an additional 1170 sq ft of unfinished space with a rough in for a full bathroom or wet bar. The French doors will lead you to the flat backyard overlooking a beautiful protected conservancy with spectacular mountain views and sunsets. Additional features include a whole-house central vacuum, electric car chargers, pre-wired speaker system in the main living area and covered porch, landscape lighting and irrigation system. Don't miss your chance to own this stunner of a home situated on one of the most private and picturesque streets in all of Willowsford! Award-winning Willowsford prides itself on vast open spaces and a variety of healthy-living amenities, including two clubhouses with resort-style pools, fitness center, zipline, treehouses, children’s splash park, hiking and biking trails, campsites and picnic areas, sledding hills, dog parks, fishing ponds, archery range and a working farm. Ready to call Willowsford and this spectacular turn-key home yours? Schedule your visit today!

Last Agent to Sell the Property

Carol Maresca

Pearson Smith Realty, LLC Listed on: 07/27/2023

Pearson Smith Realty, LLC

Last Buyer's Agent

Viktorija Piano

Keller Williams Realty License #678256

Keller Williams Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $13,159

Year Built

  • Built in 2018

Lot Details

  • 0.46 Acre Lot
  • East Facing Home
  • Backs to Trees or Woods
  • Property is zoned TR3UBF

HOA Fees

  • $232 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Front Facing Garage
  • Side Facing Garage
  • Garage Door Opener

Home Design

  • Rambler Architecture
  • Cement Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 2 Levels
  • 2 Fireplaces
  • Mountain Views
  • Partially Finished Basement

Bedrooms and Bathrooms

Schools

  • Hovatter Elementary School
  • Willard Middle School
  • Lightridge High School

Utilities

  • Central Heating and Cooling System
  • Natural Gas Water Heater

Listing and Financial Details

  • Tax Lot 9
  • Assessor Parcel Number 290281058000

Community Details

Overview

  • Built by Drees
  • Willowsford Subdivision, Annandale Floorplan

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$13,159

Year Built

Built in 2018

Lot Details

0

HOA Fees

$232 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Ranch/Rambler
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main
  • Expected On Market: 2023-07-27
  • Year Built: 2018
  • Automatically Close On Close Date: No
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Fireplaces Count: 2
  • Fireplace: Yes
  • Foundation Details: Concrete Perimeter
  • Levels Count: 2
  • Basement: Yes
  • Basement Type: Partially Finished
  • Total Sq Ft: 7140
  • Living Area Sq Ft: 5970
  • Price Per Sq Ft: 420.17
  • Above Grade Finished Sq Ft: 3570
  • Below Grade Finished Sq Ft: 2400
  • Below Grade Sq Ft: 1170
  • Total Below Grade Sq Ft: 3570
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 40844

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Cement Siding
  • View: Mountain
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage: Yes
  • Garage Features: Garage - Front Entry, Garage - Side Entry, Garage Door Opener
  • Attached Garage Spaces: 3
  • Total Garage And Parking Spaces: 3
  • Type Of Parking: Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Central
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 695.70
  • HOA Fee Frequency: Quarterly
  • Condo Co-Op Association: No
  • HOA: Yes
  • Senior Community: No

Fee Information

  • Capital Contribution Fee: 0.25

Schools

  • School District: LOUDOUN COUNTY PUBLIC SCHOOLS
  • Elementary School: HOVATTER
  • Middle School: WILLARD
  • High School: LIGHTRIDGE
  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • School District Key: 121139189813
  • School District Source: Listing Agent
  • Elementary School: HOVATTER
  • High School: LIGHTRIDGE
  • Middle Or Junior School: WILLARD

Lot Info

  • Lot Features: Backs To Trees
  • Lot Size Acres: 0.46
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 20038.00
  • Year Assessed: 2023
  • Zoning: TR3UBF
  • In City Limits: No

Building Info

  • Builder Name: Drees

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 13159.00
  • Assessor Parcel Number: 290281058000
  • Tax Lot: 9
  • Tax Total Finished Sq Ft: 5970
  • County Tax Payment Frequency: Annually
  • Tax Year: 2023
  • Close Date: 08/08/2023

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 27, 2023
Closed on
Aug 7, 2023
Sold by
Bergman Harrison and Kassinove Gabriella
Bought by
Sound Therapy Land Trust and Costello
Seller's Agent
Carol Maresca
Pearson Smith Realty, LLC
Buyer's Agent
Viktorija Piano
Keller Williams Realty
List Price
$1,500,000
Sold Price
$1,520,000
Premium/Discount to List
$20,000
1.33%
Views
96
Current Estimated Value
$1,687,208

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$167,208
Avg. Annual Appreciation
5.22%

Purchase Details

Closed on
Dec 22, 2021
Sold by
Fred Bergman
Bought by
Bergman Harrison and Kassinove Gabriella

Purchase Details

Closed on
Oct 14, 2021
Sold by
Deborah Bergman
Bought by
Bergman Harrison

Purchase Details

Closed on
Feb 16, 2021
Sold by
Bergman Deborah
Bought by
Bergman Deborah and Bergman Fred

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 14, 2021
Sold by
Bergman Deborah
Bought by
Bergman Deborah and Bergman Fred

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 14, 2019
Sold by
Drees Homes Of Dc Inc
Bought by
Bergman Deborah

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 17, 2018
Sold by
Willowsford Operations Llc
Bought by
Drees Homes Of Dc Inc
Source: Public Records

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
Sound Therapy Land Trust $1,520,000 First American Title Insurance
Bergman Harrison -- Walsh Colucci Lubeley & Walsh
Bergman Harrison -- --
Bergman Deborah -- None Available
Bergman Deborah $1,192,360 None Listed On Document
Bergman Deborah $1,185,315 Stewart Title & Escrow Inc
Drees Homes Of Dc Inc $1,308,411 Loudoun Commercial Title Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Bergman Harrison $200,000
Previous Owner Bergman Fred $320,500
Previous Owner Bergman Deborah $320,500
Previous Owner Bergman Deborah $300,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/08/2023 08/08/23 Sold $1,520,000 +1.3% $255 / Sq Ft
07/27/2023 07/27/23 Pending -- -- --
07/27/2023 07/27/23 For Sale $1,500,000 -- $251 / 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
2025 $14,690 $1,824,790 $499,200 $1,325,590
2024 $13,416 $1,550,990 $499,200 $1,051,790
2023 $12,937 $1,478,560 $499,200 $979,360
2022 $12,761 $1,433,820 $379,200 $1,054,620
2021 $11,685 $1,192,360 $329,200 $863,160
2020 $11,114 $1,073,770 $284,200 $789,570
2019 $7,007 $932,310 $284,200 $648,110
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: VALO2054556

Bright MLS

APN: 290-28-1058