NOT LISTED FOR SALE

16970 Hamilton Station Rd Hamilton, VA 20158

Estimated Value: $1,675,000 - $1,793,000

5 Beds
6.5 Baths
8,620 Sq Ft
$204/Sq Ft Est. Value

Last Sold March 29, 2024

Last sale price $1,700,000 $197 Per Sq Ft

Est. 3% increase in value since last sale

Current estimated payment $10,473/month

80 Days on Market

Highlights

  • Horses Allowed On Property
  • Second Kitchen
  • Eat-In Gourmet Kitchen
  • Kenneth W. Culbert Elementary School Rated A-
  • Home Theater
  • Panoramic View

About This Home

As of March 2024

Spectacular 8,620 sq/ft custom home on 10 acres overlooking surrounding farmland
and with breathtaking mountain views. Conveniently located just 7 miles from
Leesburg shops and restaurants, 25 minutes from Dulles International Airport, located in the heart of Loudoun wine country. No HOA or restrictions.



Gorgeous custom design and meticulous owner attention to detail sets this home apart. The
house is endowed throughout with elegant and custom crafted features such as crown
molding, wainscoting, chair rail, tray and coffered ceilings.



Both an entertainer's and a family's dream home, the main floor has a large dining and
living room, and three cozy fireplaces ideal for family and friend gatherings. A large
chefs kitchen has all the luxuries for fine cooking and dining including a gas 6 burner chefs
range and commercial hood, double wall ovens, 2 dishwashers and an oversized refrigerator, as well as a sun filled adjoining breakfast room.



Immediately noticed upon entering the main floor is the abundance of natural light and a rear 3rd staircase to the upper level. The family room stands out with coffered ceilings  and built in custom wall cabinetry.



On upper level can be found 4 bedrooms  each with their own private bathrooms and walk in closets.  The owners suite includes a fully renovated ensuite bathroom with double vanities, a huge tiled walk-in shower, a deep soaking tub, and a sitting room with a 3 sided gas fireplace.



The lower level includes 2,945 sq/ft of finished living space that has all the amenities needed
to make this a superb choice as living quarters for in-laws, friends and guests.
Completely private it includes a full kitchen with a cook top, wall oven, microwave,
dishwasher, a family room with a stacked stone fireplace, bedroom and media room each
with a full bath, and a walkout to a large patio and backyard. Basement is adorned with many
windows providing an unique abundance of natural light throughout.

Last Agent to Sell the Property

Lynne McCabe

Samson Properties License #0225223432 Listed on: 10/27/2023

Samson Properties

Last Buyer's Agent

Marc Dosik

Century 21 Redwood Realty

Century 21 Redwood Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,966

Year Built

  • Built in 2003

Lot Details

  • 10.1 Acre Lot
  • Rural Setting
  • West Facing Home
  • Extensive Hardscape
  • No Through Street
  • Private Lot
  • Interior Lot
  • Level Lot
  • Cleared Lot
  • Partially Wooded Lot
  • Backs to Trees or Woods
  • Back, Front, and Side Yard
  • Property is in excellent condition
  • Property is zoned AR1

Parking

  • 3 Car Direct Access Garage
  • Side Facing Garage
  • Driveway

Property Views

  • Panoramic
  • Scenic Vista
  • Woods
  • Pasture
  • Mountain

Home Design

  • Colonial Architecture
  • Bump-Outs
  • Slab Foundation
  • Architectural Shingle Roof
  • Concrete Perimeter Foundation
  • Masonry

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Wet Bar
  • Curved or Spiral Staircase
  • Dual Staircase
  • Built-In Features
  • Chair Railings
  • Crown Molding
  • Wainscoting
  • Tray Ceiling
  • Two Story Ceilings
  • Ceiling Fan
  • Recessed Lighting
  • 3 Fireplaces
  • Double Sided Fireplace
  • Fireplace With Glass Doors
  • Fireplace Mantel
  • Gas Fireplace
  • Window Treatments
  • Mud Room
  • Entrance Foyer
  • Family Room Off Kitchen
  • Sitting Room
  • Living Room
  • Formal Dining Room
  • Home Theater
  • Den
  • Bonus Room
  • Sun or Florida Room
  • Storage Room
  • Utility Room
  • Attic

Kitchen

  • Eat-In Gourmet Kitchen
  • Second Kitchen
  • Breakfast Area or Nook
  • Gas Oven or Range
  • Self-Cleaning Oven
  • Six Burner Stove
  • Range Hood
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile or Brick

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 located on main level
  • Electric Front Loading Dryer
  • Front Loading Washer

Improved Basement

  • Heated Basement
  • Walk-Out Basement
  • Rear Basement Entry
  • Laundry in Basement
  • Basement Windows

Outdoor Features

  • Balcony
  • Patio

Schools

  • Kenneth W. Culbert Elementary School
  • Blue Ridge Middle School
  • Loudoun Valley High School

Horse Facilities and Amenities

  • Horses Allowed On Property

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heat Pump System
  • Heating System Powered By Owned Propane
  • Vented Exhaust Fan
  • Underground Utilities
  • 200+ Amp Service
  • Water Treatment System
  • 60 Gallon+ Propane Water Heater
  • Well
  • Water Conditioner is Owned
  • Septic Equal To The Number Of Bedrooms
  • Phone Available
  • Satellite Dish
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Debutts Subdivision

Listing and Financial Details

  • Tax Lot 1A
  • Assessor Parcel Number 381390228000

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,966

Year Built

Built in 2003

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2023-10-27
  • Year Built: 2003
  • Automatically Close On Close Date: No
  • Remarks Public: Spectacular 8,620 sq/ft custom home on 10 acres overlooking surrounding farmland and with breathtaking mountain views. Conveniently located just 7 miles from Leesburg shops and restaurants, 25 minutes from Dulles International Airport, located in the heart of Loudoun wine country. No HOA or restrictions. <br><br> Gorgeous custom design and meticulous owner attention to detail sets this home apart. The house is endowed throughout with elegant and custom crafted features such as crown molding, wainscoting, chair rail, tray and coffered ceilings. <br><br> Both an entertainer's and a family's dream home, the main floor has a large dining and living room, and three cozy fireplaces ideal for family and friend gatherings. A large chefs kitchen has all the luxuries for fine cooking and dining including a gas 6 burner chefs range and commercial hood, double wall ovens, 2 dishwashers and an oversized refrigerator, as well as a sun filled adjoining breakfast room. <br><br> Immediately noticed upon entering the main floor is the abundance of natural light and a rear 3rd staircase to the upper level. The family room stands out with coffered ceilings  and built in custom wall cabinetry. <br><br> On upper level can be found 4 bedrooms  each with their own private bathrooms and walk in closets.  The owners suite includes a fully renovated ensuite bathroom with double vanities, a huge tiled walk-in shower, a deep soaking tub, and a sitting room with a 3 sided gas fireplace. <br><br> The lower level includes 2,945 sq/ft of finished living space that has all the amenities needed to make this a superb choice as living quarters for in-laws, friends and guests. Completely private it includes a full kitchen with a cook top, wall oven, microwave, dishwasher, a family room with a stacked stone fireplace, bedroom and media room each with a full bath, and a walkout to a large patio and backyard. Basement is adorned with many windows providing an unique abundance of natural light throughout.
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Microwave, Dishwasher, Disposal, Dryer - Electric, Dryer - Front Loading, Exhaust Fan, Icemaker, Oven/Range - Gas, Oven - Single, Oven - Self Cleaning, Range Hood, Refrigerator, Six Burner Stove, Stainless Steel Appliances, Washer - Front Loading, Washer, Water Conditioner - Owned, Water Heater
  • Flooring Type: Hardwood, Carpet, Tile/Brick
  • Interior Amenities: 2nd Kitchen, Additional Stairway, Attic, Breakfast Area, Built-Ins, Carpet, Ceiling Fan(s), Chair Railings, Crown Moldings, Dining Area, Double/Dual Staircase, Family Room Off Kitchen, Floor Plan - Open, Formal/Separate Dining Room, Kitchen - Gourmet, Kitchen - Island, Kitchen - Table Space, Pantry, Primary Bath(s), Recessed Lighting, Soaking Tub, Stall Shower, Tub Shower, Upgraded Countertops, Wainscotting, Walk-In Closet(s), Water Treat System, Wet/Dry Bar, Window Treatments, Wood Floors, Store/Office, Curved Staircase
  • Fireplace Features: Fireplace - Glass Doors, Gas/Propane, Mantel(s), Double Sided
  • Fireplaces Count: 3
  • Fireplace: Yes
  • Wall Ceiling Types: 2 Story Ceilings, 9'+ Ceilings, Dry Wall, Tray Ceilings
  • Foundation Details: Concrete Perimeter, Slab
  • Levels Count: 3
  • Room Count: 29
  • Room List: Living Room, Dining Room, Primary Bedroom, Sitting Room, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Family Room, Foyer, Sun/Florida Room, Laundry, Mud Room, Office, Storage Room, Utility Room, Media Room, Bathroom 1, Bathroom 2, Bathroom 3, Bonus Room, Primary Bathroom, Full Bath, Half Bath
  • Basement: Yes
  • Basement Type: Daylight, Partial, Heated, Improved, Outside Entrance, Rear Entrance, Walkout Level, Windows
  • Laundry Type: Main Floor, Basement, Lower Floor
  • Total Sq Ft: 8620
  • Living Area Sq Ft: 8620
  • Price Per Sq Ft: 316.30
  • Above Grade Finished Sq Ft: 5675
  • Below Grade Finished Sq Ft: 2945
  • Total Below Grade Sq Ft: 2945
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 16970

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Masonry
  • Exterior Features: Bump-Outs, Extensive Hardscape, Satellite Dish
  • Roof: Architectural Shingle
  • View: Mountain, Panoramic, Pasture, Scenic Vista, Trees/Woods
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage: Yes
  • Garage Features: Garage - Side Entry, Inside Access
  • Attached Garage Spaces: 3
  • Total Garage And Parking Spaces: 3
  • Type Of Parking: Attached Garage, Driveway

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Electric Service: 200+ Amp Service
  • Heating Fuel: Central, Electric, Propane - Owned
  • Heating Type: Central, Forced Air, Heat Pump(s), Zoned
  • Heating: Yes
  • Hot Water: Propane, 60+ Gallon Tank
  • Sewer/Septic System: Septic = # Of Br
  • Utilities: Cable Tv Available, Phone Available, Propane, Under Ground, Sewer Available, Water Available
  • Water Source: Well
  • Internet Services: Fiber Optic

Condo/Co-op/Association

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

Schools

  • School District: LOUDOUN COUNTY PUBLIC SCHOOLS
  • Elementary School: KENNETH W. CULBERT
  • Middle School: BLUE RIDGE
  • High School: LOUDOUN VALLEY
  • Elementary School Source: Listing Agent
  • High School Source: 3rd Party
  • Middle School Source: 3rd Party
  • School District Key: 121139189813
  • School District Source: 3rd Party
  • Elementary School: KENNETH W. CULBERT
  • High School: LOUDOUN VALLEY
  • Middle Or Junior School: BLUE RIDGE

Lot Info

  • Horses: Yes
  • Horse Amenities: Horses Allowed
  • Land Use Code: AGRICULTURE
  • Lot Features: Backs To Trees, Cleared, Interior, No Thru Street, Not In Development, Partly Wooded, Private, Rear Yard, Rural, Sideyard(s), Front Yard, Level
  • Lot Size Acres: 10.10
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 439956.00
  • Outdoor Living Structures: Balcony, Patio(s)
  • Property Condition: Excellent
  • Year Assessed: 2023
  • Zoning: AR1
  • In City Limits: No

Rental Info

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

Tax Info

  • Tax Annual Amount: 10966.00
  • Assessor Parcel Number: 381390228000
  • Tax Lot: 1A
  • Tax Total Finished Sq Ft: 8620
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2023
  • Close Date: 03/29/2024

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 27, 2023
Closed on
Apr 1, 2024
Sold by
Campbell Tony and Bikowski Cheryl A
Bought by
Modha Punita Bharat and Modha Bharat
Seller's Agent
Lynne McCabe
Samson Properties
Buyer's Agent
Marc Dosik
Century 21 Redwood Realty
List Price
$1,795,000
Sold Price
$1,700,000
Premium/Discount to List
-$95,000
-5.29%
Views
187
Current Estimated Value
$1,751,195

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$51,195
Avg. Annual Appreciation
2.41%
Original Mortgage
$500,000
Outstanding Balance
$471,705
Interest Rate
6.12%
Mortgage Type
New Conventional
Estimated Equity
$1,284,243
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
Modha Punita Bharat $1,700,000 Jacquies Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Modha Punita Bharat $500,000
Previous Owner Campbell Tony $647,000
Previous Owner Campbell Tony $377,260
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/29/2024 03/29/24 Sold $1,700,000 -5.3% $197 / Sq Ft
01/16/2024 01/16/24 Pending -- -- --
10/27/2023 10/27/23 For Sale $1,795,000 -- $208 / 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,620 $1,227,760 $247,630 $980,130
2023 $10,966 $1,253,260 $186,890 $1,066,370
2022 $9,437 $1,060,280 $171,070 $889,210
2021 $8,604 $986,220 $248,900 $737,320
2020 $8,640 $942,380 $228,900 $713,480
2019 $8,449 $917,840 $228,900 $688,940
2018 $8,515 $894,110 $228,900 $665,210
2017 $8,440 $860,450 $228,900 $631,550
2016 $8,462 $739,000 $0 $0
2015 $8,449 $744,430 $118,630 $625,800
2014 $8,635 $747,650 $102,280 $645,370
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: VALO2059192

Bright MLS

APN: 381-39-0228