Skip main navigation
Under contract
  • Price cut: $100 (7/30)
    $484,900

    400 Collingwood Dr, Fredericksburg, VA 22405

    4beds
    1,753sqft
    : 
    $2,972/mo
    Get pre-qualified
    Single Family Residence
    Built in 1986
    0.44 Acres Lot
    $483,400 Zestimate®
    $277/sqft
    $-- HOA

    What's special

    Cozy fireplaceFinished lower levelFully fenced backyardInstalled ev charging stationSpacious corner lotAttached side-load two-car garageBright inviting floor plan
    Welcome to sought-after Clearview Heights, one of South Stafford's most desirable established neighborhoods, where you'll enjoy the freedom of **NO HOA** along with numerous major updates already completed for you. According to the previous owners, the roof was replaced in 2018, new siding was installed in 2019, new decking and HVAC system were replaced in 2020, and a new water heater was installed in 2026, offering added peace of mind for years to come. Situated on a spacious corner lot, this beautifully maintained home combines timeless charm, flexible living spaces, and an unbeatable location just minutes from Downtown Fredericksburg. Inside, you'll find beautiful hardwood floors and a bright, inviting floor plan designed for both everyday living and entertaining. The kitchen features granite countertops, ample cabinetry, and generous workspace for preparing meals or hosting family and friends. The spacious living room offers plenty of room to gather, while the finished lower level provides a separate family room centered around a cozy fireplace, creating the perfect space for movie nights, game days, a playroom, home gym, hobby room, or additional entertaining space. Step outside to your fully fenced backyard and enjoy the spacious deck, ideal for grilling, outdoor dining, relaxing with your morning coffee, or hosting guests. The corner lot provides additional outdoor space while enhancing the home's curb appeal. An attached side-load two-car garage offers abundant parking and storage, and the installed EV charging station is a valuable bonus for electric vehicle owners. The location is truly exceptional. Commuters will appreciate the close proximity to the Leeland VRE Station and I-95 for convenient access to Northern Virginia and Washington, D.C. Just minutes away, you'll find Historic Downtown Fredericksburg with its locally owned restaurants, boutiques, coffee shops, farmers markets, art galleries, riverfront parks, and year-round events. Brooks Park, the Stafford YMCA and waterpark, grocery stores, shopping, medical facilities, and everyday conveniences are all nearby. Opportunities to own a well-maintained home with **NO HOA**, significant recent updates, and this prime location in Clearview Heights are rare. Schedule your private showing today and see everything this exceptional property has to offer. Fourth bedroom is NTC.
    53 days
    |
    766
    |
    43
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Ashley Nicole Brooks 540-604-3314,

    Berkshire Hathaway HomeServices PenFed Realty 5403717653

    Source: Bright MLS,MLS#: VAST2051242MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Basement
      • Area: 521
      Heating
      • Heat Pump, Electric
      Cooling
      • Central Air, Electric
      Appliances
      • Included: Microwave, Dishwasher, Disposal, Ice Maker, Oven/Range - Electric, Refrigerator, Washer, Dryer, Water Heater, Electric Water Heater
      Features
      • Bathroom - Walk-In Shower, Ceiling Fan(s), Combination Kitchen/Dining, Dining Area, Family Room Off Kitchen, Floor Plan - Traditional, Eat-in Kitchen, Kitchen Island, Kitchen - Table Space, Primary Bath(s), Dry Wall
      • Flooring: Hardwood, Carpet
      • Doors: Sliding Glass, Six Panel, Storm Door(s)
      • Windows: Double Pane Windows
      • Basement: Partial,Finished
      • Number of fireplaces: 1
      • Fireplace features: Brick
      Interior area
      • Total structure area: 1,753
      • Total interior livable area: 1,753 sqft
      • Finished area above ground: 1,232
      • Finished area below ground: 521

      Property

      Parking
      • Total spaces: 6
      • Parking features: Garage Faces Side, Concrete, Attached, Driveway
      • Attached garage spaces: 2
      • Uncovered spaces: 4
      • Details: Garage Sqft: 430
      Accessibility
      • Accessibility features: None
      Features
      • Levels: Bi-Level,Three
      • Stories: 3
      • Patio & porch: Deck, Porch
      • Exterior features: Sidewalks, Lighting, Rain Gutters
      • Pool features: None
      • Fencing: Full
      Lot
      • Size: 0.44 Acres
      • Features: Corner Lot
      Details
      • Additional structures: Above Grade, Below Grade
      • Parcel number: 54S 6 290
      • Zoning: R1
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Brick, Vinyl Siding
      • Foundation: Crawl Space
      • Roof: Architectural Shingle
      Condition
      • New construction: No
      • Year built: 1986

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Subdivision: Clearview Heights
      HOA
      • Has HOA: No
      Location
      • Region: Fredericksburg

      Financial & listing details

      • Price per square foot: $277/sqft
      • Tax assessed value: $346,300
      • Annual tax amount: $3,244
      • Date on market: 6/25/2026
      • Listing agreement: Exclusive Right To Sell
      • Ownership: Fee Simple
      • Road surface type: Paved

        Estimated market value

        $483,400

        $459,000 - $508,000

        $2,755/mo

        Price history

        DateEventPrice
        8/5/2026Contingent$484,900$277/sqft
        Source: Bright MLS #VAST2051242 Report a problem
        7/30/2026Price change$484,9000%$277/sqft
        Source: Bright MLS #VAST2051242 Report a problem
        7/20/2026Price change$485,000-3%$277/sqft
        Source: Bright MLS #VAST2051242 Report a problem
        7/13/2026Listed for sale$500,000$285/sqft
        Source: Bright MLS #VAST2051242 Report a problem
        7/2/2026Contingent$500,000$285/sqft
        Source: Bright MLS #VAST2051242 Report a problem
        6/25/2026Listed for sale$500,000+73.3%$285/sqft
        Source: Bright MLS #VAST2051242 Report a problem
        11/27/2018Sold$288,550-0.5%$165/sqft
        Source: Public Record Report a problem
        11/1/2018Pending sale$289,900$165/sqft
        Source: CENTURY 21 New Millennium #1003407726 Report a problem
        10/18/2018Price change$289,900-3.3%$165/sqft
        Source: CENTURY 21 New Millennium #1003407726 Report a problem
        9/26/2018Listed for sale$299,777+9%$171/sqft
        Source: CENTURY 21 New Millennium #1003407726 Report a problem
        6/3/2013Sold$274,900$157/sqft
        Source: Public Record Report a problem
        4/30/2013Pending sale$274,900$157/sqft
        Source: Coldwell Banker Elite #ST8066252 Report a problem
        4/28/2013Listed for sale$274,900+58.9%$157/sqft
        Source: Coldwell Banker Elite #ST8066252 Report a problem
        3/26/2013Sold$173,000$99/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$3,198 +3.4%$346,300
        2024$3,095 +15%$346,300 +15.5%
        2023$2,691 +5.6%$299,800
        2022$2,548 +1.2%$299,800 +15.5%
        2021$2,518 $259,600
        2020$2,518 +6.1%$259,600 +10.5%
        2019$2,374 +2%$235,000
        2018$2,327 $235,000 -3.1%
        2017$2,327 -3.1%$242,500
        2016$2,401 $242,500 +7.3%
        2015-- $225,900
        2014-- $225,900 +11.9%
        2013-- $201,900
        2012-- $201,900 -5%
        2011-- $212,500
        2010-- $212,500 -17.1%
        2009-- $256,200
        2008-- $256,200 -14.6%
        2006-- $299,900
        2005-- $299,900 +61.9%
        2004-- $185,200 +26.2%
        2003-- $146,700
        2002-- $146,700 +10.1%
        2001-- $133,200
        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.

        Climate risks

        Neighborhood: Falmouth

        Getting around

        8 / 100
        Car-Dependent
        16 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Falmouth
        • Middle: Edward E. Drew
        • High: Stafford
        • District: Stafford 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