NOT LISTED FOR SALE

8540 Mill Reef Rd Upperville, VA 20184

Estimated Value: $2,348,000

4 Beds
4.5 Baths
4,633 Sq Ft
$507/Sq Ft Est. Value

Sale Details

Date Sold: December 7, 2017

Last sale price $9,000,000 $1,943 Per Sq Ft

Current estimated payment $15,030 / mo

707 Days on Market

Highlights

  • Guest House
  • Greenhouse
  • Colonial Architecture
  • Stables
  • 440 Acre Lot
  • 3 Fireplaces

About This Home

As of December 2017

Part of Paul & Bunny Mellon's iconic estate, Rokeby Farm consists of 440 spectacular acres. Private mile long airstrip. Breathtaking mountain views & rolling pastures. 24 stall stable & other 8 barns/storage buildings. 9 cottages/tenant houses. Greenhouses & gardens. Stone main residence designed by architects,Cross & Son, currently used as farm operations office. VOF Easement.

Last Agent to Sell the Property

Kathryn Harrell

(540) 687-6395 info@wfp.com Washington Fine Properties, LLC License #0225101776 Listed on: 10/29/2015

Washington Fine Properties, LLC

Co-Listed By

Tom Anderson

thomas.anderson@wfp.com Washington Fine Properties, LLC

Last Buyer's Agent

Non Member Member

beta@mris.net Metropolitan Regional Information Systems, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $62,604

Year Built

  • Built in 1951

Lot Details

  • 440 Acre Lot
  • Masonry wall
  • Board Fence
  • Open Lot
  • Property is zoned RA

Parking

  • Circular Driveway

Home Design

  • Colonial Architecture
  • Stone Siding

Interior Spaces

  • Property has 3 Levels
  • 3 Fireplaces
  • Dining Area
  • Eat-In Country Kitchen

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4.5 Bathrooms

Basement

  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry

Outdoor Features

  • Greenhouse
  • Shed
  • Storage Shed
  • Tenant House

Additional Homes

  • Guest House

Farming

  • Cattle or Dairy Barn
  • Machine Shed

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Stables

Utilities

  • Window Unit Cooling System
  • Radiator
  • Heating System Uses Oil
  • Well
  • Electric Water Heater
  • Septic Tank

Listing and Financial Details

  • Assessor Parcel Number 6063-26-9336

Community Details

Overview

  • No Home Owners Association

Recreation

  • Horse Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$62,604

Year Built

Built in 1951

Lot Details

440 Acres

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Historic: No
  • Inclusions: Parking Included In ListPrice,Parking Included In SalePrice
  • New Construction: No
  • Story List: Main, Upper 1, Upper 2
  • Year Built: 1951
  • Special Assessment Payment: Annually
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Kitchen - Country, Kitchen - Table Space, Dining Area
  • Fireplaces Count: 3
  • Fireplace: Yes
  • Levels Count: 3+
  • Basement: Yes
  • Basement Type: Outside Entrance, Full
  • Living Area Units: Square Feet

Beds/Baths

  • Bedrooms: 4
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 3.00
  • Upper Level 2 Bathrooms: 1.00
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures List: Barn/Stable, Greenhouse, Guest House, Tenant House, Barn, Horse Stable, Cattle/Dairy Barn, Shed Shop, Storage Barn/Shed, Machine Shed
  • Construction Materials: Stone
  • Pool Private: No
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage: No
  • Parking Features: Circular Driveway, Paved Driveway, Detached
  • Type Of Parking: Driveway

Utilities

  • Central Air Conditioning: No
  • Cooling Type: Window Unit(s)
  • Cooling: Yes
  • Heating Fuel: Oil
  • Heating Type: Radiator
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Septic Exists
  • Water Source: Well

Condo/Co-op/Association

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

Lot Info

  • Fencing: Board, Masonry/Stone
  • Horse Amenities: Horses Allowed, Horse Trails
  • Improvement Assessed Value: 4422500.00
  • Land Assessed Value: 1844200.00
  • Lot Features: Open
  • Lot Size Acres: 440.00
  • Lot Size Area: 19166400
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 19166400.00
  • Property Attached Yn: No
  • Zoning: RA

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 62604.33
  • Assessor Parcel Number: 6063-26-9336
  • County Tax Payment Frequency: Annually
  • Tax Year: 2015

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 29, 2015
Closed on
Dec 4, 2017
Sold by
Bought by
Seller's Agent
Kathryn Harrell
Washington Fine Properties, LLC
Buyer's Agent
Non Member Member
Metropolitan Regional Information Systems, Inc.
List Price
$18,000,000
Sold Price
$9,000,000
Premium/Discount to List
-$9,000,000
-50%
Current Estimated Value
$2,348,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$6,652,000
Avg. Annual Appreciation
-13.10%
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$9,000,000 None Available
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
12/07/2017 12/07/17 Sold $9,000,000 -9.1% $1,943 / Sq Ft
10/05/2017 10/05/17 Pending -- -- --
07/10/2017 07/10/17 Price Changed $9,900,000 -17.3% $2,137 / Sq Ft
05/13/2016 05/13/16 Price Changed $11,975,000 -33.5% $2,585 / Sq Ft
10/29/2015 10/29/15 For Sale $18,000,000 -- $3,885 / Sq Ft
Source: Bright MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $80,394 $8,982,600 $2,341,000 $6,641,600
2025 $73,436 $7,594,200 $1,235,800 $6,358,400
2024 $71,627 $7,594,200 $1,235,800 $6,358,400
2023 $68,589 $7,594,200 $1,640,800 $5,953,400
2022 $67,242 $7,445,000 $1,640,800 $5,804,200
2021 $65,743 $6,612,600 $1,856,400 $4,756,200
2020 $65,743 $6,612,600 $1,856,400 $4,756,200
2019 $65,743 $6,612,600 $1,856,400 $4,756,200
2018 $64,949 $6,612,600 $1,856,400 $4,756,200
2016 $65,125 $6,266,700 $1,844,200 $4,422,500
2015 -- $6,266,700 $1,844,200 $4,422,500
2014 -- $6,266,700 $1,844,200 $4,422,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: 1000129083

Bright MLS

APN: 6063-26-9336

Your Personal Tour Guide

Ask me questions while you tour the home.