RENTED OCT 5, 2025

42609 Houdini Rest Terrace Leesburg, VA 20176

4 Beds
4.5 Baths
2,795 Sq Ft
3,920 Sq Ft Lot

Last Sold September 26, 2025

Last sale price $876,375 $314 Per Sq Ft

Highlights

  • New Construction
  • Rooftop Deck
  • Contemporary Architecture
  • John W. Tolbert Jr. Elementary School Rated A
  • Open Floorplan
  • Engineered Wood Flooring

About This Home

As of October 2025

FALL in love with this BRAND new 4-level Townhouse in Cattail Run! Be the FIRST to live in this amazing home! Minimum 6 month lease available or up to 24 months! Discover the charm of this contemporary end unit townhouse with 2 car garage and driveway! With a spacious layout of 2,795 finished SF on four levels, you will discover 4 bedrooms and 4.5 baths. Charming front porch, deck and 4th level terrace! Located in a vibrant new community, this townhouse is super close to 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, farm sink and gas cooking! Large kitchen island for entertaining and food prep. 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 has 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. Enjoy Fall days on the front porch. The Leesburg Outlet mall is around the corner! Welcome home! Lease purchase will be considered.

Last Agent to Rent the Property

Mike Emshwiller

mike.emshwiller@cbrealty.com Coldwell Banker Realty License #0225271131 Listed on: 09/28/2025

Coldwell Banker Realty

Co-Listed By

Lisa Moffett

(703) 517-6708 LMoffett@cbmove.com Coldwell Banker Realty License #0225068593

Last Renter's Agent

Chris Wood

(202) 714-9817 cawood65@gmail.com EXP Realty, LLC License #0225077228

EXP Realty, LLC

Townhouse Details

Home Type

  • Townhome

Year Built

  • Built in 2025 | New Construction

Lot Details

  • 3,920 Sq Ft Lot
  • Landscaped
  • Front Yard
  • Property is in excellent condition

Parking

  • 2 Car Direct Access Garage
  • 2 Driveway Spaces
  • Rear-Facing Garage
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Architectural Shingle Roof
  • HardiePlank Type

Interior Spaces

  • 2,795 Sq Ft Home
  • Property has 4 Levels
  • Open Floorplan
  • Ceiling height of 9 feet or more
  • Recessed Lighting
  • Gas Fireplace
  • Window Screens
  • Family Room Off Kitchen
  • Formal Dining Room
  • Laundry on upper level
  • Attic

Kitchen

  • Breakfast Area or Nook
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal

Flooring

  • Engineered Wood
  • Partially Carpeted
  • Ceramic Tile
  • Luxury Vinyl Plank Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Bathtub with Shower

Outdoor Features

  • Rooftop Deck
  • Terrace
  • Porch

Schools

  • Ball's Bluff Elementary School
  • Smart's Mill Middle School
  • Tuscarora High School

Utilities

  • Forced Air Heating and Cooling System
  • Air Filtration System
  • Programmable Thermostat
  • Tankless Water Heater

Additional Features

  • More Than Two Accessible Exits
  • Energy-Efficient Windows

Listing and Financial Details

  • Residential Lease
  • Security Deposit $3,950
  • Tenant pays for cable TV, insurance, internet, light bulbs/filters/fuses/alarm care, minor interior maintenance, all utilities
  • The owner pays for association fees
  • No Smoking Allowed
  • 6-Month Min and 24-Month Max Lease Term
  • Available 9/28/25
  • $50 Application Fee
  • Assessor Parcel Number 147181227000

Community Details

Overview

  • Property has a Home Owners Association
  • Association fees include common area maintenance, lawn maintenance, management, reserve funds, road maintenance, snow removal
  • Built by Pulte
  • Cattail Run Subdivision, Jayton Floorplan

Amenities

  • Common Area

Recreation

  • Community Playground
  • Jogging Path

Pet Policy

  • Pet Deposit $500
  • Dogs and Cats Allowed

Townhouse Details

Home Type

Townhome

Year Built

Built in 2025 | New Construction

Lot Details

0

Parking

2

Rental Info

  • Date Available: 2025-09-28
  • Application Fee: 50.00
  • Owner Pays: Association Fees
  • Pet Deposit: 500.00
  • Pets: Cats Ok, Dogs Ok, Pet Addendum/Deposit
  • Pets Allowed: Yes
  • Security Deposit: 3950.00
  • Smoking Allowed Yn: No
  • Tenant Pays: Cable Tv, Insurance, Internet, Light Bulbs/Filters/Fuses/Alarm Care, Minor Interior Maintenance, Utilities - All
  • Vacation Rental: No
  • Property Manager: No
  • Max Lease in Months: 24
  • Min Lease in Months: 6
  • Rent Spree Online Application: No

Listing Details

  • Property Type: Residential Lease
  • Structure Type: End Of Row/Townhouse
  • Architectural Style: Contemporary
  • Accessibility Features: 2+ Access Exits
  • Historic: No
  • New Construction: Yes
  • Story List: Main, Upper 1, Upper 2, Upper 3
  • Federal Flood Zone: No
  • Year Built: 2025
  • Automatically Close On Close Date: No
  • Building Winterized: No
  • Special Features: 4098
  • Property Sub Type: Townhouses

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Oven/Range - Gas, Refrigerator, Stainless Steel Appliances
  • Flooring Type: Ceramic Tile, Engineered Wood, Luxury Vinyl Plank, Partially Carpeted
  • Interior Amenities: Air Filter System, Attic, Bathroom - Tub Shower, Breakfast Area, Carpet, Combination Dining/Living, Combination Kitchen/Dining, Combination Kitchen/Living, Dining Area, Family Room Off Kitchen, Floor Plan - Open, Formal/Separate Dining Room, Kitchen - Island, Primary Bath(s), Recessed Lighting, Walk-In Closet(s)
  • Window Features: Energy Efficient, Screens
  • Fireplace Features: Gas/Propane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Wall Ceiling Types: 9'+ Ceilings, Dry Wall
  • Foundation Details: Slab
  • Levels Count: 4
  • Basement: No
  • Laundry Type: Upper Floor
  • Total Sq Ft: 2795
  • Living Area Sq Ft: 2795
  • Price Per Sq Ft: 1.41
  • Above Grade Finished Sq Ft: 2795
  • Above Grade Finished 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: 4
  • Upper Level Bathrooms: 1.00
  • Upper Level 2 Bathrooms: 2.00
  • Upper Level 3 Bathrooms: 1.00
  • Main Level Full Bathrooms: 1
  • Upper Level 3 Full Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade
  • Construction Materials: Hardiplank Type
  • Construction Completed: Yes
  • Exterior Features: Roof Deck, Sidewalks
  • Roof: Architectural Shingle
  • Spa: No
  • 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: Concrete Driveway
  • Garage Features: Garage - Rear Entry, Garage Door Opener, Inside Access
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 4
  • Type Of Parking: Attached Garage, Driveway
  • Number of Spaces in Driveway: 2

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air, Programmable Thermostat
  • Heating: Yes
  • Hot Water: Tankless
  • Sewer/Septic System: Public Sewer
  • Water Source: Public
  • Municipal Trash: No
  • Internet Services: Fiber Optic

Condo/Co-op/Association

  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Common Grounds, Jog/Walk Path, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Common Area Maintenance, Lawn Maintenance, Management, Reserve Funds, Road Maintenance, Snow Removal
  • HOA: Yes
  • Senior Community: No
  • Association Recreation Fee: No

Schools

  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • Elementary School: BALL'S BLUFF
  • High School: TUSCARORA
  • Middle Or Junior School: SMART'S MILL

Lot Info

  • Horses: No
  • Lot Features: Corner, Front Yard, Landscaping
  • Lot Size Acres: 0.09
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 3920.00
  • Outdoor Living Structures: Deck(s), Terrace, Porch(es)
  • Property Condition: Excellent
  • Zoning: PDH3

Building Info

  • Builder Name: Pulte

Tax Info

  • Assessor Parcel Number: 147181227000

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Matterport 3D Tour

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

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/05/2025 10/05/25 Rented $3,950 0.0% --
10/03/2025 10/03/25 Under Contract -- -- --
09/28/2025 09/28/25 For Rent $3,950 0.0% --
09/26/2025 09/26/25 Sold $876,375 +6.9% $314 / Sq Ft View Prior Sale
08/10/2025 08/10/25 Pending -- -- --
05/28/2025 05/28/25 For Sale $819,990 -- $293 / Sq Ft
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Bright MLS

MLS Number: VALO2107802

Bright MLS