42609 Houdini Rst Ter

Leesburg, VA 20176

$869,000
Price
4
Beds
2,795 Sq. Ft.
$311 / Sq. Ft.
2,795
Sq. Ft.
$311
per Sq. Ft.
Get preapproved with Rocket Mortgage1
a front view of a building with a yard
a front view of a house with a yard
a view of a porch with a floor to ceiling window and a flat screen tv
a kitchen with stainless steel appliances a stove a refrigerator and cabinets
a open kitchen with stainless steel appliances granite countertop a sink a stove a refrigerator and a wooden floor
a kitchen with counter top space and wooden floor
a kitchen with granite countertop a stove a sink and white cabinets with wooden floor
a large kitchen with stainless steel appliances a large counter top a sink a refrigerator and a window
a large kitchen with a lot of counter space and a wooden floor
a view of a kitchen with wooden floor and a sink
a view of an empty room with wooden floor and a window
a view of empty room with wooden floor
a view of an empty room with wooden floor and a window
an empty room with wooden floor and windows
an empty room with wooden floor and windows
a bathroom with a shower sink and mirror
a bathroom with a shower
a bathroom with a sink a vanity and a mirror
a view of a room with wooden floor
an empty room with windows and closet
an empty room with windows
a bathroom with a sink a mirror and a shower
a bathroom with a sink a toilet a mirror and shower
a view of an empty room
a view of empty room with a window
a bathroom with a sink a toilet and shower
an empty room with windows
a view of a balcony with city view
an empty room with wooden floor and windows
wooden floor in an empty room with a window
a bathroom with a shower a toilet and sink
a view of entryway and hall with wooden floor
a bathroom with a sink a toilet and shower
a view of a room with racks on the wall
a view of roof deck
a view of a balcony with wooden fence and floor
a view of a garage
a front view of a building with a garden and plants
a front view of a house with a yard
a street sign that is on a brick wall
a view of a swimming pool with an outdoor seating
a view of a swimming pool with a yard
a view of a garden with sitting area

Description

Enjoy Spring days on the front porch, deck or roof-top terrace! You will love this newly built, 24 foot wide, 4-level Townhouse in Cattail Run! Adjacent to 85 acres of preserved parkland. Discover the charm of this contemporary end unit townhouse with 2 car garage and driveway! With a spacious layout of 2,795 finished living space, you will discover 4 bedrooms and 4.5 baths. Charming stone front porch, trex deck off the kitchen and 4th level roof-top terrace! Located in a vibrant new community, this...Enjoy Spring days on the front porch, deck or roof-top terrace! You will love this newly built, 24 foot wide, 4-level Townhouse in Cattail Run! Adjacent to 85 acres of preserved parkland. Discover the charm of this contemporary end unit townhouse with 2 car garage and driveway! With a spacious layout of 2,795 finished living space, you will discover 4 bedrooms and 4.5 baths. Charming stone front porch, trex deck off the kitchen and 4th level roof-top terrace! Located in a vibrant new community, this townhouse is super close to Trader Joes, Home Depot, Costco, Target, Wegmans, Giant, various restaurants and more! Historic Town of Leesburg is about 15 minutes away. Wineries, breweries and parks are close by! Enjoy cooking in the NEW and MODERN chef's delight kitchen with SS appliances, timeless white cabinetry, farm sink and gas cooktop! Large kitchen island for entertaining and food prep. Soft close cabinets and pull out drawers are a plus. The floor plan is wide open with plenty of windows for natural light. Easy access to deck from kitchen. The primary bedroom is spacious with dual sinks in the primary bathroom. The second and third bedrooms are spacious and there is a full bath in the hallway for convenience. You will find the laundry room on upper level too. The fourth level bedroom has easy access to the outdoor terrace space. Another full bath is accessible on the fourth level. The main level entry foyer opens to a family room area/office space and there is a full bath on this main level. Plentiful guest parking. Curb appeal is a 10+! The Leesburg Outlet mall is around the corner! Cattail amenities include a tot lot, pocket parks, sidewalks, trails and open spaces! Welcome home! Where charming front porches bring neighbors together:)
  1. Listed by John Michael Emshwiller • Coldwell Banker Realty
    P: (703)-217-0609 mike.emshwiller@cbrealty.com
  2. Listed by Lisa B Moffett • Coldwell Banker Realty
    P: (703)-517-6708 lmoffett@cbmove.com

Property Details for 42609 Houdini Rst Terrace

Tax ID Number
147181227000
Ownership
Fee Simple
Condo Coop Association
No
HOA
Yes
Structure Type
End of Row/Townhouse
Style
Contemporary
Levels/Stories
4
Furnished
No
LISTING UPDATED: 03/27/2026 09:12 AM

Property Details for 42609 Houdini Rst Terrace

StatusActive
MLS #VALO2116578
Days on Market25
Taxes$6,563 / year
HOA Fees$225 / month
Condo/Co-op Fees-
Compass TypeTownhouse
MLS TypeResidential / Fee Simple
Year Built2025
Lot Size0.09 AC / 3,920 SF
CountyLoudoun County
Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of Coldwell Banker Realty
Add your commute

Building Information for 42609 Houdini Rst Terrace

Stories4Residences-Year Built2025Lot Size0.09 AC / 3,920 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$4,989 per month

30 year fixed, 6.11% Interest

Principal and Interest

$4,217

Property Taxes

$547

HOA Dues

$225

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 42609 Houdini Rst Terrace

Location
Location
  • In City Limits: No
  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS
  • School District County ID: 121139189813
  • SchoolDistrictSource: Listing Agent
  • Elementary School: BALL'S BLUFF (LOUDOUN VA)
  • ElementarySchoolSource: Listing Agent
  • Middle Or Junior School: SMART'S MILL (LOUDOUN VA)
  • MiddleSchoolSource: Listing Agent
  • High School: TUSCARORA (LOUDOUN VA)
  • County: LOUDOUN
Waterfront / Water Access
Waterfront / Water Access
  • Water View: No
  • Water Access: No
  • Water Oriented: No
  • Navigable Water: No
  • Tidal Water: No
  • Riparian Rights Y/N: No
Association / Community Info
Association / Community Info
  • HOA Name: CATTAIL RUN
  • HOA Phone: 703-631-7200
  • HOA Condo Coop Fee Includes: Common Area Maintenance, Lawn Maintenance, Management, Reserve Funds, Road Maintenance, Snow Removal
  • HOA Condo Coop Amenities: Common Grounds, Jog/Walk Path, Tot Lots/Playground
  • Property Manager Y/N: Yes
  • Senior Community: No
  • Association Recreation Fee Y/N: No
  • Capital Contribution Amount: $1,000
  • Type of Condo: Home Owner Association
Taxes and Assessment
Taxes and Assessment
  • Tax Year: 2026
  • Tax Assessed Value: $852,840
  • Year Assessed: 2026
  • County Tax: $6,563
  • Improvement Assessed Value: $607,840
  • City Town Tax: $0
  • Land Assessed Value: $245,000
  • Clean Green Assessed: No
  • Land Use Code: 0
  • Loss Mitigation Fee: No
  • Historic: No
  • Zoning: PDH3
  • School Tax: $0
  • Automatically Update Tax Values Y/N: Yes
Lease Information
Lease Information
  • Pets Allowed: Yes
  • Pet Restrictions: Cats OK, Dogs OK
Rooms
Main
  • # Bedrooms Count Main Level: 0
  • # Bathrooms Count Main Level: 1
  • # Bathrooms Full Main Level: 1
  • # Bathrooms Half Main Level: 0
All Upper Levels
  • # Bedrooms Count All Upper Levels: 4
  • # Bathrooms Count All Upper Levels: 4
  • # Bathrooms Full All Upper Levels: 3
  • # Bathrooms Half All Upper Levels: 1
Upper Level 1
  • # Bedrooms Count Upper Level: 0
  • # Bathrooms Count Upper Level: 1
  • # Bathrooms Full Upper Level: 0
  • # Bathrooms Half Upper Level: 1
Upper Level 2
  • # Bedrooms Count Upper Level: 3
  • # Bathrooms Count Upper Level: 2
  • # Bathrooms Full Upper Level: 2
  • # Bathrooms Half Upper Level: 0
Upper Level 3
  • # Bedrooms Count Upper Level: 1
  • # Bathrooms Count Upper Level: 1
  • # Bathrooms Full Upper Level: 1
  • # Bathrooms Half Upper Level: 0
Rooms
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Laundry, Bathroom 2, Primary Bathroom, Full Bath
  • Stories: Main, Upper 1, Upper 2, Upper 3
Rooms Information
Room 1
  • Room Type: Bedroom 4
  • Room Level: Upper 3
  • Room Exists: Yes
  • Room Features: Flooring - Carpet
Room 2
  • Room Type: Full Bath
  • Room Level: Upper 3
  • Room Exists: Yes
  • Room Features: Flooring - Ceramic Tile
Room 3
  • Room Type: Primary Bedroom
  • Room Level: Upper 2
  • Room Exists: Yes
  • Room Features: Flooring - Carpet
Room 4
  • Room Type: Bedroom 2
  • Room Level: Upper 2
  • Room Exists: Yes
  • Room Features: Flooring - Carpet
Room 5
  • Room Type: Bedroom 3
  • Room Level: Upper 2
  • Room Exists: Yes
  • Room Features: Flooring - Carpet
Room 6
  • Room Type: Bathroom 2
  • Room Level: Upper 2
  • Room Exists: Yes
  • Room Features: Flooring - Ceramic Tile
Room 7
  • Room Type: Primary Bathroom
  • Room Level: Upper 2
  • Room Exists: Yes
  • Room Features: Bathroom - Walk-In Shower, Flooring - Ceramic Tile
Room 8
  • Room Type: Laundry
  • Room Level: Upper 2
  • Room Exists: Yes
Room 9
  • Room Type: Kitchen
  • Room Level: Upper 1
  • Room Exists: Yes
  • Room Features: Countertop(s) - Quartz, Flooring - Luxury Vinyl Plank
Room 10
  • Room Type: Dining Room
  • Room Level: Upper 1
  • Room Exists: Yes
  • Room Features: Flooring - Luxury Vinyl Plank
Room 11
  • Room Type: Living Room
  • Room Level: Upper 1
  • Room Exists: Yes
  • Room Features: Flooring - Luxury Vinyl Plank
Room 12
  • Room Type: Family Room
  • Room Level: Main
  • Room Exists: Yes
  • Room Features: Flooring - Luxury Vinyl Plank
Building Info
Building Info
  • Builder Name: Pulte
  • Total Finished SQFT: 2,795.00
  • Total Finished SQFT Source: Estimated
  • Tax Total Finished SQFT: 2,808.00
  • Total SQFT: 2,795.00
  • Total SQFT Source: Estimated
  • Construction Materials: HardiPlank Type
  • Roof: Architectural Shingle
  • Ext Main Mid-res: http://bright-media01.prd.brightmls.com/bright/images/0000/8042/0635/7048/804206357048_512_384_WM_6RqyEg0qZOarScBY.jpg
  • Wall and Ceiling Types: 9'+ Ceilings, Dry Wall
  • Flooring Type: Ceramic Tile, Luxury Vinyl Plank, Carpet
  • Foundation Details: Slab
  • Room and Floor: Bathrooms Full-Main Level-1, Bathrooms Half-Upper Level 1-1, Bedrooms-Upper Level 2-1, Bedrooms-Upper Level 2-2, Bedrooms-Upper Level 2-3, Bathrooms Full-Upper Level 2-1, Bathrooms Full-Upper Level 2-2, Bedrooms-Upper Level 3-1, Bathrooms Full-Upper Level 3-1
  • # Bathrooms Full: 4
  • # Bathrooms Half: 1
  • Other Structure: Above Grade, Below Grade
Lot / Land Information
Lot / Land Information
  • Lot Size Source: Assessor
  • Lot Size Dimensions: 0.00 x 0.00
  • Lot Dimensions Source: Assessor
  • Lot Features: Corner, Front Yard, Landscaping
  • Parcel ID: 25836270
  • Ground Rent Exists: No
Parking
Parking
  • Type Of Parking: Attached Garage, Driveway
  • Num of Attached Garage Spaces: 2
  • Driveway - # of Spaces: 2
  • Total Garage Spaces: 2
  • Parking Features: Concrete Driveway
  • Garage Features: Garage - Rear Entry, Garage Door Opener, Inside Access
Interior Features
Interior Features
  • Interior Features: Attic, Bathroom - Tub Shower, Breakfast Area, Combination Dining/Living, Combination Kitchen/Dining, Combination Kitchen/Living, Dining Area, Family Room Off Kitchen, Floor Plan - Open, Kitchen - Gourmet, Kitchen - Table Space, Upgraded Countertops
  • Fireplace: Yes
  • Fireplaces Count: 1
  • Fireplace Features: Gas/Propane
  • Appliances: Dishwasher, Disposal, Microwave, Oven/Range - Gas, Refrigerator, Stainless Steel Appliances, Dryer, Exhaust Fan, Icemaker, Washer
  • Accessibility Features: None
  • Window Features: Energy Efficient, Screens
  • Laundry Type: Upper Floor
  • Virtual Tour URL Unbranded: https://my.matterport.com/show/?m=vn5faodYpKp&mls=1
Exterior Features
Exterior Features
  • Spa: No
  • Exterior Features: Roof Deck, Sidewalks
  • Outdoor Living Structures: Deck(s), Terrace, Porch(es)
  • Pool: No Pool
  • Horse: No
Utilities
Utilities
  • Heating: Yes
  • Cooling Type: Central A/C
  • Cooling Fuel: Electric
  • Heating Type: Forced Air, Programmable Thermostat
  • Heating Fuel: Natural Gas
  • Hot Water: Tankless
  • Water Source: Public
  • Sewer Septic: Public Sewer
Confidential Data
Listing Office
  • List Agent AOR: Northern Virginia Association of REALTORS

Property History for 42609 Houdini Rst Terrace

DateEvent & SourcePriceAppreciation
Mar 27, 2026

Price Change

BRIGHT #VALO2116578

$869,000—
Mar 15, 2026

Price Change

BRIGHT #VALO2116578

$879,000—
Mar 6, 2026

Listed (Active)

BRIGHT #VALO2116578

$889,000—
Sep 26, 2025

Closed (Public Record)

Public Record #1914220768

$876,375—
Sep 26, 2025

Closed

BRIGHT #VALO2098178

$876,375—
Aug 10, 2025

Pending

BRIGHT #VALO2098178

—
May 28, 2025

Expired

BRIGHT #VALO2098158

—
May 28, 2025

Expired

BRIGHT #VALO2086258

—
May 28, 2025

Withdrawn

BRIGHT #VALO2098158

—
May 28, 2025

Withdrawn

BRIGHT #VALO2086258

—
May 28, 2025

Listed (Active)

BRIGHT #VALO2098178

$819,990—
May 28, 2025

Listed (Active)

BRIGHT #VALO2098158

$819,990—
Apr 9, 2025

Listed (Active)

BRIGHT #VALO2086258

—
Apr 9, 2025

Price Change

BRIGHT #VALO2086258

$819,990—
Apr 1, 2025

Temp Off Market

BRIGHT #VALO2086258

—
Mar 13, 2025

Price Change

BRIGHT #VALO2086258

$907,235—
Feb 15, 2025

Price Change

BRIGHT #VALO2086258

$937,135—
Jan 14, 2025

Listed (Active)

BRIGHT #VALO2086258

$938,185—
DateEvent & SourcePrice
03/27/2026

Price Change

BRIGHT #VALO2116578

$869,000
03/15/2026

Price Change

BRIGHT #VALO2116578

$879,000
03/06/2026

Listed (Active)

BRIGHT #VALO2116578

$889,000
09/26/2025

Closed (Public Record)

Public Record #1914220768

$876,375
09/26/2025

Closed

BRIGHT #VALO2098178

$876,375
08/10/2025

Pending

BRIGHT #VALO2098178

—
05/28/2025

Expired

BRIGHT #VALO2098158

—
05/28/2025

Expired

BRIGHT #VALO2086258

—
05/28/2025

Withdrawn

BRIGHT #VALO2098158

—
05/28/2025

Withdrawn

BRIGHT #VALO2086258

—
05/28/2025

Listed (Active)

BRIGHT #VALO2098178

$819,990
05/28/2025

Listed (Active)

BRIGHT #VALO2098158

$819,990
04/09/2025

Listed (Active)

BRIGHT #VALO2086258

—
04/09/2025

Price Change

BRIGHT #VALO2086258

$819,990
04/01/2025

Temp Off Market

BRIGHT #VALO2086258

—
03/13/2025

Price Change

BRIGHT #VALO2086258

$907,235
02/15/2025

Price Change

BRIGHT #VALO2086258

$937,135
01/14/2025

Listed (Active)

BRIGHT #VALO2086258

$938,185

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 42609 Houdini Rst Terrace

Taxable ValueLand$213,500Additions$601,820Total$815,320
Tax Record2025$6,328 ($527 / month)
Home Facts
Beds4Total Finished SqFt2,808 SqFtAbove Grade Finished SqFt2,808 SqFtStories4Lot Size3,920 SqFtStyleTownhouseYear Built2025ZoningPDH3CountyLOUDOUNAPN147-18-1227-000

Schools near 42609 Houdini Rst Terrace

This home is within Loudoun County Public Schools.
Rating
School
Type
Grades
Distance
Ball's Bluff Elementary School
Public - PK to 5
Tuscarora High School
Public - PK to 12
Smart's Mill Middle School
Public - 6 to 8
Middleburg Community Charter School
Charter - K to 5
Rating
School
Distance
Ball's Bluff Elementary School
PublicPK to 5

Tuscarora High School
PublicPK to 12

Smart's Mill Middle School
Public6 to 8

Middleburg Community Charter School
CharterK to 5

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 42609 Houdini Rst Terrace, Leesburg, VA 20176

42609 Houdini Rst Terrace is a townhouse for sale in Leesburg, VA 20176. This property was listed for sale on March 6, 2026 by Coldwell Banker Realty, it's currently listed at $869,000. It has been on the market for a total of 25 days and was last sold on September 26, 2025. This listing's school district is Loudoun County Public Schools. Nearby schools include Ball's Bluff Elementary School, Tuscarora High School and Smart's Mill Middle School. 42609 Houdini Rst Terrace is a 4-bed, 5-bath, 2,795 sqft townhouse built in 2025.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Realty

© 2026 Bright MLS. All rights reserved. All information is deemed reliable, but accuracy is not guaranteed. Listing information is from various brokers who participate in IDX and not all listings may be visible on the site. The property information being provided is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated on 03/27/2026 09:12 AM