NOT LISTED FOR SALE

Estimated Value: $1,163,787 - $1,225,000

4 Beds
3.5 Baths
4,379 Sq Ft
$273/Sq Ft Est. Value

Last Sold February 24, 2025

Last sale price $1,190,000 $272 Per Sq Ft

Current estimated payment $7,140/month

2 Days on Market

Highlights

  • Fitness Center
  • Colonial Architecture
  • Vaulted Ceiling
  • Sycolin Creek Elementary School Rated A-
  • Recreation Room
  • Wood Flooring

About This Home

As of February 2025

Nestled on nearly half an acre in the sought-after Hamlets at Red Cedar neighborhood, this elegant single-family home offers the perfect combination of luxury, comfort, and modern updates. With its classic brick-front facade, side-load garage, and professionally landscaped yard, this home makes an immediate impression. Inside, you’ll find a meticulously maintained and extensively upgraded interior, designed with both functionality and style in mind.
The home features warm Acacia hardwood flooring, paired with custom details like upgraded balusters, blinds, and window treatments. A complete LED lighting upgrade with dimmers throughout the home creates a modern and inviting ambiance. The interior has been freshly painted, offering a crisp and updated feel, while the newly installed carpeting in 2021 adds a touch of comfort. A dedicated home gym with rubber flooring, installed in 2021, further enhances the home’s thoughtful design.
The chef’s kitchen was completely updated in 2024, boasting new countertops, backsplash, a touchless faucet, refinished cabinets, ceramic tile floor and all-new KitchenAid appliances.
The luxurious primary bathroom underwent a stunning expansion and renovation in 2023, now featuring a curbless shower, skylight, and spa-like finishes. Additional updates include a beautifully refreshed hall bathroom and custom storage solutions throughout the home, courtesy of Closets by Design, including a Murphy bed with built-in storage in the bonus room.
The exterior of the home is equally impressive, with a 30-year warranty roof installed in 2018, new low-voltage landscape lighting added in 2023, and a gas line conveniently installed for patio grilling. A Pella sliding patio door, installed in 2023, leads to the spacious backyard, which is prepped for a potential pool with an electrical pump already installed. The property also features an invisible fence for pets, a sprinkler system for the lawn, and prewiring for an ADT security system.
Recent mechanical updates include a new Carrier HVAC system and water heater, both installed in 2024, ensuring efficiency and peace of mind. The home is also equipped with fire-protective interior sprinklers and newly replaced fire detectors throughout.
This property is a rare gem in a picturesque neighborhood known for its tree-lined streets, walking trails, and proximity to Leesburg’s shopping, dining, and entertainment. Every detail has been thoughtfully considered to make this home truly move-in ready. Schedule your private tour today and experience the unparalleled charm and luxury this home has to offer.

Last Agent to Sell the Property

Kelly McGinn

(703) 507-4444 kelly@kellysellsnova.com Pearson Smith Realty, LLC License #0225065371 Listed on: 01/31/2025

Pearson Smith Realty, LLC

Last Buyer's Agent

Sara Kasamani

(571) 308-3220 Sara.Kasamani@pearsonsmithrealty.com Pearson Smith Realty, LLC License #0225251080

Pearson Smith Realty, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,362

Year Built

  • Built in 2009

Lot Details

  • 0.47 Acre Lot
  • Property has an invisible fence for dogs
  • Sprinkler System
  • Property is zoned PDRV

HOA Fees

  • $190 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Side Facing Garage

Home Design

  • Colonial Architecture
  • Architectural Shingle Roof
  • Vinyl Siding
  • Brick Front
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 3 Levels
  • Vaulted Ceiling
  • Recessed Lighting
  • 1 Fireplace
  • Sliding Doors
  • Family Room Off Kitchen
  • Living Room
  • Dining Room
  • Den
  • Recreation Room
  • Storage Room
  • Home Gym

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior and Rear Basement Entry

Home Security

  • Fire and Smoke Detector
  • Fire Sprinkler System

Outdoor Features

  • Patio
  • Exterior Lighting

Schools

  • Sycolin Creek Elementary School
  • J. L. Simpson Middle School
  • Loudoun County High School

Utilities

  • Forced Air Heating and Cooling System
  • Natural Gas Water Heater

Listing and Financial Details

  • Tax Lot 12
  • Assessor Parcel Number 239459738000

Community Details

Overview

  • Association fees include common area maintenance, pool(s), snow removal, management
  • Hamlets At Red Cedar HOA
  • Built by PULTE HOME
  • Red Cedar South Village Subdivision, Wilshire With Florida Room Floorplan

Amenities

  • Party Room

Recreation

  • Community Playground
  • Fitness Center
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,362

Year Built

Built in 2009

Lot Details

0

HOA Fees

$190 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Inclusions: Pool table, Murphy bed, misc attached shelving.
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2025-01-31
  • Year Built: 2009
  • Automatically Close On Close Date: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Icemaker, Microwave, Oven/Range - Gas, Refrigerator, Washer
  • Flooring Type: Hardwood, Ceramic Tile, Carpet
  • Interior Amenities: Kitchen - Island, Dining Area, Family Room Off Kitchen, Kitchen - Table Space, Pantry, Recessed Lighting, Walk-In Closet(s), Upgraded Countertops, Wood Floors
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Door Features: Sliding Glass
  • Wall Ceiling Types: Vaulted Ceilings
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Room List: Living Room, Dining Room, Kitchen, Family Room, Den, Study, Exercise Room, Recreation Room, Storage Room
  • Basement: Yes
  • Basement Type: Full, Walkout Stairs, Rear Entrance, Interior Access
  • Laundry Type: Main Floor
  • Total Sq Ft: 4379
  • Living Area Sq Ft: 4379
  • Price Per Sq Ft: 411.56
  • Above Grade Finished Sq Ft: 2855
  • Below Grade Finished Sq Ft: 1524
  • Total Below Grade Sq Ft: 1524
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Brick Front, Vinyl Siding
  • Exterior Features: Sidewalks, Exterior Lighting, Underground Lawn Sprinkler
  • Roof: Architectural Shingle
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Asphalt Driveway
  • Garage Features: Garage - Side Entry
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Security: Sprinkler System - Indoor, Smoke Detector
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 190.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Exercise Room, Pool - Outdoor, Party Room, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Common Area Maintenance, Pool(s), Snow Removal, Management
  • HOA Name: HAMLETS AT RED CEDAR
  • HOA: Yes
  • Senior Community: No

Schools

  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • School District Source: Listing Agent
  • Elementary School: SYCOLIN CREEK
  • High School: LOUDOUN COUNTY
  • Middle Or Junior School: J. L. SIMPSON

Lot Info

  • Agricultural District: 00
  • Fencing: Invisible
  • Lot Size Acres: 0.47
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 20473.00
  • Outdoor Living Structures: Patio(s)
  • Zoning: PDRV
  • In City Limits: No

Building Info

  • Builder Name: PULTE HOME

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 8362.00
  • Assessor Parcel Number: 239459738000
  • Tax Lot: 12
  • Tax Year: 2024

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 31, 2025
Closed on
Feb 21, 2025
Sold by
Tremeau Cynthia
Bought by
Ouellette Jesse and Ouellette Nicole
Seller's Agent
Kelly McGinn
Pearson Smith Realty, LLC
Buyer's Agent
Sara Kasamani
Pearson Smith Realty, LLC
List Price
$1,175,000
Sold Price
$1,190,000
Premium/Discount to List
$15,000
1.28%
Views
76
Current Estimated Value
$1,193,697

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$3,697
Avg. Annual Appreciation
0.38%
Original Mortgage
$1,000,000
Outstanding Balance
$994,081
Interest Rate
6.93%
Mortgage Type
New Conventional
Estimated Equity
$199,616

Purchase Details

Closed on
Oct 9, 2015
Sold by
Tremeau Laurent and Tremeau Cynthia
Bought by
Tremeau Cynthia

Purchase Details

Closed on
Nov 4, 2011
Sold by
Pulte Home Corporation
Bought by
Tremeau Laurent

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$503,991
Interest Rate
4.08%
Mortgage Type
New Conventional
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
Ouellette Jesse $1,190,000 Chicago Title
Tremeau Cynthia -- None Available
Tremeau Laurent $559,990 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ouellette Jesse $1,000,000
Previous Owner Tremeau Laurent $503,991
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/24/2025 02/24/25 Sold $1,190,000 +1.3% $272 / Sq Ft
02/03/2025 02/03/25 Pending -- -- --
01/31/2025 01/31/25 For Sale $1,175,000 -- $268 / 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 $8,123 $1,009,010 $379,700 $629,310
2024 $8,363 $966,770 $379,700 $587,070
2023 $8,493 $970,620 $379,700 $590,920
2022 $7,421 $833,870 $274,700 $559,170
2021 $6,906 $704,650 $259,700 $444,950
2020 $6,752 $652,390 $199,700 $452,690
2019 $6,615 $633,060 $199,700 $433,360
2018 $6,397 $589,570 $179,700 $409,870
2017 $6,241 $554,760 $179,700 $375,060
2016 $6,528 $570,150 $0 $0
2015 $5,928 $342,600 $0 $342,600
2014 $6,291 $364,940 $0 $364,940
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Source: Bright MLS

MLS Number: VALO2086900

Bright MLS

APN: 239-45-9738