Skip main navigation
For sale
    • $865,000

    42609 Houdini Rest Ter, Leesburg, VA 20176

    4beds
    2,795sqft
    : 
    $5,858/mo
    Get pre-qualified
    Townhouse
    Built in 2025
    3,920 Square Feet Lot
    $861,500 Zestimate®
    $309/sqft
    $225/mo HOA

    What's special

    Farm sinkPlentiful guest parkingRoof-top terraceCharming stone front porchSs appliancesGas cooktopTimeless white cabinetry
    Enjoy outdoor living 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:)
    18 hours
    135
    8

    Zillow last checked:

    Listing updated:

    Listed by:

    Mike Emshwiller 703-217-0609,

    Coldwell Banker Realty 7034717220,

    Co-Listing Agent: Lisa B Moffett 703-517-6708,

    Coldwell Banker Realty

    Source: Bright MLS,MLS#: VALO2137158MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 5
      • Full bathrooms: 4
      • 1/2 bathrooms: 1
      • Main level bathrooms: 1
      Basement
      • Area: 0
      Heating
      • Forced Air, Programmable Thermostat, Natural Gas
      Cooling
      • Central Air, Electric
      Appliances
      • Included: Dishwasher, Disposal, Microwave, Oven/Range - Gas, Refrigerator, Stainless Steel Appliance(s), Dryer, Exhaust Fan, Ice Maker, Washer, Tankless Water Heater
      • Laundry: Upper Level
      Features
      • Attic, Bathroom - Tub Shower, Breakfast Area, Combination Dining/Living, Combination Kitchen/Dining, Combination Kitchen/Living, Dining Area, Family Room Off Kitchen, Open Floorplan, Kitchen - Gourmet, Kitchen - Table Space, Upgraded Countertops, 9'+ Ceilings, Dry Wall
      • Flooring: Ceramic Tile, Luxury Vinyl, Carpet
      • Windows: Energy Efficient, Screens
      • Has basement: No
      • Has fireplace: No
      Interior area
      • Total structure area: 2,795
      • Total interior livable area: 2,795 sqft
      • Finished area above ground: 2,795
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage Faces Rear, Garage Door Opener, Inside Entrance, Concrete, Attached, Driveway
      • Attached garage spaces: 2
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: None
      Features
      • Levels: Four
      • Stories: 4
      • Patio & porch: Deck, Terrace, Porch, Roof Deck
      • Exterior features: Sidewalks
      • Pool features: None
      Lot
      • Size: 3,920 Square Feet
      • Features: Corner Lot, Front Yard, Landscaped
      Details
      • Additional structures: Above Grade, Below Grade
      • Parcel number: 147181227000
      • Zoning: PDH3
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: Townhouse
      • Architectural style: Contemporary
      • Property subtype: Townhouse
      Materials
      • HardiPlank Type
      • Foundation: Slab
      • Roof: Architectural Shingle
      Condition
      • Excellent
      • New construction: No
      • Year built: 2025
      Details
      • Builder model: Jayton
      • Builder name: Pulte

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Subdivision: Cattail Run
      HOA
      • Has HOA: Yes
      • Amenities included: Common Grounds, Jogging Path, Tot Lots/Playground
      • Services included: Common Area Maintenance, Maintenance Grounds, Management, Reserve Funds, Road Maintenance, Snow Removal
      • HOA fee: $225 monthly
      • HOA name: CATTAIL RUN
      Location
      • Region: Leesburg

      Financial & listing details

      • Price per square foot: $309/sqft
      • Tax assessed value: $852,840
      • Annual tax amount: $6,563
      • Date on market: 9/28/2026
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA,VA Loan
      • Ownership: Fee Simple

        Estimated market value

        $861,500

        $818,000 - $905,000

        $4,197/mo

        Price history

        DateEventPrice
        9/28/2026Listed for sale$865,000-1.3%$309/sqft
        Source: Bright MLS #VALO2137158 Report a problem
        9/26/2025Sold$876,375$314/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026$6,865 +8.5%$852,840 +4.6%
        2025$6,328 $815,320
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 20176

        Getting around

        24 / 100
        Car-Dependent
        23 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Ball's Bluff
        • Middle: Smart's Mill
        • High: Tuscarora
        • District: Loudoun County Public Schools

        Source: Bright MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Leesburg Topics

                Search
                Updates
                Favorites
                Plan
                Inbox