112 Hyannis Place
FREDERICKSBURG, VA 22406
- 2 beds
- 2 baths
- 1,528 sqft
- 4,547 sqft lot
- $271 per sqft
- 2018 build
Stylish End-Unit Villa in the Amenity-Rich Celebrate Virginia 55+ Community! Welcome to easy, elegant living in this beautifully maintained 2-bedroom + office/den, 2-bathroom semi-detached ranch home, perfectly situated in the highly sought-after Celebrate Virginia active adult community! Designed with both comfort and style in mind, this single-level home features a spacious open-concept layout that seamlessly blends the kitchen, dining, and living areas—complete with rich 5" oak plank flooring, warm neutral paint, high ceilings, and an abundance of windows. A cozy gas fireplace sets the perfect ambiance in the living area featuring a chic lighted ceiling fan, walls of windows, and sliding glass doors that open to a private rear patio, ideal for enjoying morning coffee or evening relaxation. The chef-inspired kitchen is a showstopper, boasting a large center island with seating, granite countertops, upgraded 42” cabinetry, designer tile backsplash, and stainless steel appliances including a gas cooktop, built-in microwave and wall oven. It's an entertainer’s dream with plenty of prep space and storage. Retreat to the carpeted bedrooms for ultimate comfort, with a primary suite that offers a walk-in closet, and luxurious bath with a granite topped dual sink vanity, oversized glass enclosed shower, and spa-toned tile surround and flooring. A second bright and cheerful bedroom shares easy access to the 2nd full bath with granite topped vanity and tub/shower. The additional flex room is perfect for an office, den, or hobby space. The 1-car garage includes built-in shelving, and the driveway plus ample guest parking right next door makes hosting easy. With beautiful landscaping, a built-in sprinkler system, and access to an incredible range of community amenities—from social events to fitness and leisure—this home delivers low-maintenance living at its finest. Move-in ready and waiting for you to start your next chapter!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 11, 2025
•
MLS# VAST2037384 —
The Building
-
Year Built:2018
-
Year Built Source:Assessor
-
New Construction:No
-
Construction Materials:Vinyl Siding
-
Builder Name:Pulte
-
Builder Model:GORGEOUS HOME!
-
Structure Type:Twin/Semi-Detached
-
Architectural Style:Ranch/Rambler
-
Levels:1
-
Door Features:French, Six Panel, Sliding Glass, Storm
-
Security Features:Fire Detection System, Sprinkler System - Indoor
-
Window Features:Double Hung, Energy Efficient, Insulated
-
Accessibility Features:Doors - Lever Handle(s)
-
Foundation Details:Slab
-
Basement:No
-
Total SqFt Source:Assessor
-
Total Below Grade SqFt Source:Assessor
-
Above Grade Finished Area Units:Square Feet
-
Above Grade Finished SqFt:1528
-
Above Grade Finished SqFt Source:Assessor
-
Below Grade Finished Area Units:Square Feet
-
Below Grade Unfinished Area Units:Square Feet
-
Below Grade Finished SqFt Source:Assessor
-
Below Grade Unfinished SqFt Source:Assessor
-
Tax Total Finished SqFt:1528
Interior
-
Interior Features:Bathroom - Tub Shower, Bathroom - Walk-In Shower, Breakfast Area, Carpet, Ceiling Fan(s), Chair Railings, Crown Moldings, Dining Area, Entry Level Bedroom, Family Room Off Kitchen, Floor Plan - Open, Kitchen - Gourmet, Kitchen - Island, Kitchen - Table Space, Pantry, Primary Bath(s), Recessed Lighting, Upgraded Countertops, Wainscotting, Walk-in Closet(s), Window Treatments
-
Room List:Living Room, Dining Room, Primary Bedroom, Bedroom 2, Kitchen, Den, Foyer, Laundry, Primary Bathroom, Full Bath
-
Flooring Type:Carpet, Ceramic Tile, Hardwood
-
Fireplace:Yes
-
Fireplaces:1
-
Fireplace Features:Fireplace - Glass Doors, Gas/Propane, Mantel(s), Marble
-
Wall & Ceilings:9'+ Ceilings
-
Living Area SqFt Source:Assessor
Room Dimensions
-
Total SqFt:1528
-
Living Area SqFt:1,528 Sqft
Financial & Terms
-
Sale Type:Standard
-
Possession:Settlement
Location
-
Directions:From I-95, west on Route 17 to Left onto Celebrate Virginia Parkway, follow around to Right on Hyannis Pl. to #112 on the Right
-
Latitude:38.33748000
-
Longitude:-77.52018000
The Property
-
Property Type:Residential
-
Property Condition:Excellent
-
Lot Size Units:Square Feet
-
Lot Size Acres:0.10
-
Lot Size Source:Assessor
-
Lot Features:Backs - Open Common Area, Corner, Front Yard, Landscaping, Level, Premium, Rear Yard, SideYard(s)
-
Lot SqFt:4,547 Sqft
-
Inclusions:Ring Doorbell, Smart home capability, built-in sprinkler system, convey.
-
Exclusions:Soundbar, husky wall units and brackets do not convey.
-
Zoning:RBC
-
View:Garden/Lawn, Trees/Woods
-
In City Limits:No
-
Outdoor Living Structures:Patio(s), Porch(es)
-
Other Structures:Above Grade, Below Grade
-
Waterview:No
-
Waterfront:No
-
Water Oriented:No
-
Water Access:No
-
Navigable Water:No
-
Tidal Water:No
-
Riparian Rights:No
Listing Agent
- Contact info:
- Agent phone:
- (703) 956-5128
- Office phone:
- (703) 815-5700
Taxes
-
Tax ID Number:44CC 6 808
-
Tax Year:2024
-
Tax Lot:808
-
Tax Annual Amount:$2,921
-
Tax Assessed Value:$322,200
-
Year Assessed:2024
-
County Tax:2879.00
-
Total Taxes Payment Frequency:Annually
Beds
-
Bedrooms:2
-
Bedrooms Main Level:2
Baths
-
Total Baths:2
-
Full Baths:2
-
Main Level Baths:2.00
-
Main Level Full Baths:2
The Listing
Heating & Cooling
-
Cooling Type:Ceiling Fan(s), Central A/C
-
Central Air:Yes
-
Cooling Fuel:Electric
-
Heating:Yes
-
Heating Type:Forced Air
-
Heating Fuel:Natural Gas
Utilities
-
Sewer/Septic:Public Sewer
-
Hot Water:Electric
-
Water Source:Public
Appliances
-
Appliances:Built-In Microwave, Cooktop, Dishwasher, Disposal, Dryer, Exhaust Fan, Icemaker, Oven - Wall, Range Hood, Refrigerator, Stainless Steel Appliances, Washer, Water Dispenser, Humidifier
-
Laundry Type:Main Floor, Washer In Unit, Dryer In Unit
Schools
-
Elementary School:Rocky Run
-
Middle School:Gayle
-
High School:STAFFORD
-
School District Name:Stafford County Public Schools
-
School District Source:Listing Agent
The Community
-
Subdivision Name:Celebrate Virginia North
-
Senior Community:No
-
Exterior Features:Exterior Lighting, Sidewalks, Stone Retaining Walls, Street Lights
-
Pool:Yes - Community
-
HOA:Yes
-
Condo/Coop Association:No
-
HOA/Condo/Coop Amenities:Bike Trail, Billiard Room, Club House, Common Grounds, Community Center, Fitness Center, Hot tub, Jog/Walk Path, Meeting Room, Party Room, Picnic Area, Pool - Indoor, Pool - Outdoor, Putting Green, Tennis Courts
-
HOA Fee:$316
-
HOA Fee Frequency:Monthly
-
HOA/Condo/Coop Fee:Common Area Maintenance, Lawn Maintenance, Management, Pool(s), Recreation Facility, Reserve Funds, Road Maintenance, Snow Removal, Trash
-
HOA Name:Celebrate Virginia North
Parking
-
Total Garage and Parking Spaces:2
-
Garage:Yes
-
Garage Features:Garage Door Opener, Garage - Front Entry
-
Garage Spaces:1.00
-
Type of Parking:Attached Garage, Driveway
-
Parking Features:Concrete Driveway
-
# of Attached Garage Spaces:1
-
Driveway - # of Spaces:1
Extra Units
-
Vacation Rental:No
Monthly cost estimate

Asking price
$415,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$2,222
|
Taxes | $243 |
Insurance | $114 |
Utilities | $123 See report |
Total | $2,702/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
4/10/25
Apr 10, 2025
|
Listed / Active | BRIGHT | $415,000 |