NOT LISTED FOR SALE

17008 Hamilton Station Rd Hamilton, VA 20158

Estimated Value: $1,054,000 - $1,846,978

4 Beds
2.5 Baths
3,520 Sq Ft
$450/Sq Ft Est. Value

Last Sold September 28, 2023

Last sale price $1,795,000 $510 Per Sq Ft

Est. 12% decrease in value since last sale

Current estimated payment $8,895/month

33 Days on Market

Highlights

  • Stables
  • In Ground Pool
  • Pond View
  • Kenneth W. Culbert Elementary School Rated A-
  • Fishing Allowed
  • 20.38 Acre Lot

About This Home

As of September 2023

Discover the charm and beauty of old and new at Historic Locust Hill Farm. 20.38 lush rolling acres on Hamilton Station Road, only 4 miles from Leesburg in the heart of Loudoun's Wineries, Distilleries & Breweries. Highlights include well-preserved stone dairy barn, stone springhouse and stone farmhouse. Home is a thoughtfully improved stone farmhouse with a 3-story addition added in 1988 and updated again in 2010 to include an upper level Primary Ensuite Bedroom & Bath, Hall Bath, and main level family room, kitchen, powder room and laundry/mud room as well as a lower level finished rec room/office. Property has breathtaking view of Springhouse and pond. Beautiful in-ground pool. The Bank Barn is a sight to behold--the main level has wood-looking laminate floors, just waiting for a line dance to happen and horse or cattle stalls, electric & water. This is a one-of-a-kind property. With no restrictive covenants. Also Posted In Residential as VALO2053692. Seller is not responsible for Rollback Taxes.

Last Agent to Sell the Property

Lynne McCabe

(703) 378-8810 lynnemccabe@kw.com Samson Properties License #0225223432 Listed on: 07/10/2023

Samson Properties

Last Buyer's Agent

Colleen Gustavson

(703) 443-1757 colleen@huntcountrysir.com Hunt Country Sotheby's International Realty License #0225098330

Hunt Country Sotheby's International Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,091

Year Built

  • Built in 1790 | Remodeled in 2010

Lot Details

  • 20.38 Acre Lot
  • 15 Acres are fenced
  • Board Fence
  • Private Lot
  • Cleared Lot
  • Subdivision Possible
  • Historic Home
  • Property is zoned AR1, Agriculture

Property Views

  • Pond
  • Pasture
  • Creek or Stream

Home Design

  • Colonial Architecture
  • Farmhouse Style Home
  • Stone Foundation
  • Plaster Walls
  • Shingle Roof
  • Stone Siding
  • Vinyl Siding
  • Masonry

Interior Spaces

  • Property has 4 Levels
  • Open Floorplan
  • Chair Railings
  • Crown Molding
  • Ceiling Fan
  • 1 Fireplace
  • Wood Burning Stove
  • Double Hung Windows
  • Family Room Off Kitchen
  • Living Room
  • Formal Dining Room
  • Den
  • Solid Hardwood Flooring
  • Attic

Kitchen

  • Eat-In Country Kitchen
  • Breakfast Area or Nook
  • Electric Oven or Range
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

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

Partially Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry
  • Basement Windows

Parking

  • Driveway
  • Off-Street Parking

Pool

  • In Ground Pool
  • Gunite Pool
  • Fence Around Pool

Outdoor Features

  • Pond
  • Stream or River on Lot
  • Shed
  • Utility Building
  • Outbuilding
  • Rain Gutters

Schools

  • Hamilton Elementary School
  • Blue Ridge Middle School
  • Loudoun Valley High School

Farming

  • Feed Barn
  • Beef Barn
  • 15 Acres of Pasture
  • Silo
  • Spring House
  • Horse Farm
  • Livestock

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Run-In Shed
  • Stables

Utilities

  • Zoned Heating and Cooling
  • Heating System Uses Oil
  • Heat Pump System
  • Heating System Powered By Owned Propane
  • Hot Water Baseboard Heater
  • Underground Utilities
  • 120/240V
  • Propane
  • Water Treatment System
  • Spring water is a source of water for the property
  • Well
  • Oil Water Heater
  • Septic Less Than The Number Of Bedrooms
  • Cable TV Available

Additional Features

  • Energy-Efficient Windows
  • Property is near creek

Listing and Financial Details

  • Tax Lot 2A
  • Assessor Parcel Number 381284137000

Community Details

Overview

  • No Home Owners Association

Recreation

  • Fishing Allowed

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,091

Year Built

Built in 1790 | Remodeled in 2010

Lot Details

0

Listing Details

  • Property Type: Farm
  • Structure Type: Detached
  • Architectural Style: Colonial, Farmhouse/National Folk
  • Habitable Residence: Yes
  • Ownership: Fee Simple
  • Historic: Yes
  • Inclusions: Stone Barn, Outbuildings, Pond, 3 Run-in Sheds
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1, Upper 2
  • Expected On Market: 2023-07-10
  • Federal Flood Zone: No
  • Year Built: 1790
  • Year Renovated: 2010
  • Automatically Close On Close Date: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Appliances: Built-In Microwave, Dishwasher, Disposal, Dryer, Icemaker, Oven/Range - Electric, Refrigerator, Washer
  • Flooring Type: Solid Hardwood, Wood
  • Interior Amenities: Attic, Breakfast Area, Ceiling Fan(s), Chair Railings, Crown Moldings, Dining Area, Family Room Off Kitchen, Floor Plan - Open, Floor Plan - Traditional, Formal/Separate Dining Room, Kitchen - Country, Kitchen - Eat-In, Kitchen - Table Space, Stove - Wood, Walk-In Closet(s), Water Treat System, Window Treatments
  • Window Features: Double Hung, Energy Efficient
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Wall Ceiling Types: Plaster Walls, Masonry, Dry Wall
  • Foundation Details: Stone
  • Levels Count: 4
  • Room List: Living Room, Dining Room, Kitchen, Family Room, Den, Laundry, Attic, Half Bath
  • Basement: Yes
  • Basement Type: Full, Heated, Improved, Interior Access, Outside Entrance, Partially Finished, Walkout Level, Windows
  • Laundry Type: Main Floor
  • Total Sq Ft: 3820
  • Living Area Sq Ft: 3520
  • Price Per Sq Ft: 614.73
  • Above Grade Finished Sq Ft: 2920
  • Below Grade Finished Sq Ft: 600
  • Below Grade Sq Ft: 300
  • Total Below Grade Sq Ft: 900
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 4
  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2
  • Upper Level Bathrooms: 2.00
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Other Structures List: Barn/Farm Building, Barn/Stable, Horse Stable, Run-in Shed, Shed, Silo(s), Spring House, Utility Building
  • Construction Materials: Masonry, Stone, Vinyl Siding
  • Exterior Features: Gutter System, Outbuilding(s)
  • Pool Features: Fenced, Gunite, In Ground
  • Roof: Shingle
  • View: Creek/Stream, Pasture, Pond, Water
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Personal
  • Tidal Water: No
  • Water View: Yes

Garage/Parking

  • Garage: No
  • Type Of Parking: Driveway, Off Street

Utilities

  • Central Air Conditioning: No
  • Cooling Fuel: Electric
  • Cooling Type: Zoned, Heat Pump(s)
  • Electric Service: 120/240V
  • Heating Fuel: Electric, Oil, Propane - Owned
  • Heating Type: Zoned, Baseboard - Hot Water
  • Heating: Yes
  • Hot Water: Electric, Oil
  • Sewer/Septic System: Septic < # Of Br
  • Utilities: Under Ground, Propane, Cable Tv Available
  • Water Source: Spring, Well
  • Municipal Trash: No
  • Internet Services: Fiber Optic

Condo/Co-op/Association

  • Condo Co-Op Association: No
  • HOA: No
  • Senior Community: No
  • Association Recreation Fee: No

Schools

  • Elementary School Source: Listing Agent
  • High School Source: 3rd Party
  • Middle School Source: 3rd Party
  • School District Source: 3rd Party
  • Elementary School: HAMILTON
  • High School: LOUDOUN VALLEY
  • Middle Or Junior School: BLUE RIDGE

Lot Info

  • Horses: Yes
  • Agricultural District: Land Use Tax to be paid by Buyer
  • Crops Included: No
  • Farm Features: Shed(s), Silo(s), Feed Barn
  • Farm Land Area Units: Acres
  • Farm Operation: Horse, Livestock, General, Beef
  • Fenced Acres: 15.00
  • Fencing: Board
  • Horse Amenities: Horses Allowed, Stable(s)
  • Lot Features: Cleared, Fishing Available, Not In Development, Pond, Private, Stream/Creek, Subdivision Possible
  • Lot Size Acres: 20.38
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 887753.00
  • Pasture Acres: 15.00
  • Remarks Farm: 1790's Built Stone Barn, Springhouse and Farm House family purchase in the 1940's and used for cattle/dairy operation.
  • Zoning: AR1
  • Zoning Description: Agriculture
  • Farmland Preservation: No
  • In City Limits: No

Rental Info

  • Lease Considered: No
  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 8091.00
  • Assessor Parcel Number: 381284137000
  • Tax Lot: 2A
  • County Tax Payment Frequency: Semi-Annually
  • Tax Year: 2023

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 10, 2023
Closed on
Sep 28, 2023
Sold by
Mark A Miller Revocable Trust and Kimberly Jo Miller Revocable Trust
Bought by
Aha Investments Llc
Seller's Agent
Lynne McCabe
Samson Properties
Buyer's Agent
Colleen Gustavson
Hunt Country Sotheby's International Realty
List Price
$1,795,000
Sold Price
$1,795,000
Views
354
Current Estimated Value
$1,582,245

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$212,755
Avg. Annual Appreciation
-5.14%
Original Mortgage
$1,256,500
Outstanding Balance
$1,231,652
Interest Rate
7.09%
Mortgage Type
New Conventional
Estimated Equity
$350,593

Purchase Details

Closed on
Oct 29, 2015
Sold by
The Mark A Miller Revocable Trust Dated
Bought by
The Kimberly Jo Miller Revocable Trust D
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Aha Investments Llc $1,795,000 First American Title Insurance
The Kimberly Jo Miller Revocable Trust D -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Aha Investments Llc $1,256,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/28/2023 09/28/23 Sold $1,795,000 0.0% $510 / Sq Ft
08/13/2023 08/13/23 Pending -- -- --
07/10/2023 07/10/23 For Sale $1,795,000 0.0% $510 / Sq Ft
07/01/2023 07/01/23 Price Changed $1,795,000 -- $510 / Sq Ft
Source: Bright MLS

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 $8,145 $1,011,810 $257,650 $754,160
2024 $8,141 $941,210 $242,390 $698,820
2023 $7,955 $909,160 $180,890 $728,270
2022 $7,449 $836,990 $164,310 $672,680
2021 $5,619 $780,820 $341,000 $439,820
2020 $5,470 $734,790 $321,000 $413,790
2019 $5,328 $719,450 $321,000 $398,450
2018 $5,287 $696,840 $321,000 $375,840
2017 $5,230 $676,180 $321,000 $355,180
2016 $5,324 $464,940 $0 $0
2015 $5,300 $466,970 $106,000 $360,970
2014 $4,951 $428,690 $81,720 $346,970
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Bright MLS

MLS Number: VALO2051536

Bright MLS

APN: 381-28-4137