Welcome to your Urban Oasis in the Villages of Urbana! This Gorgeous 4 Bedroom, 4.5 Bath Neo-Traditional 4 Finished Level Home boasts a Fully Fenced Backyard featuring a 13x16 Vinyl and Trex Deck off the Main Level and Staircase down to the Professionally Hardscaped Patio with a 12x12 Amish Built Gazebo that houses a 6 Person Hot Tub; has been Meticulously Maintained by the Original Owners and has undergone Recent Updates and Upgrades to keep up with the Modern Times. Enjoy the Covered Front Porch within your Gated Fully Fenced Yard. You are then welcomed into the Main Level featuring a Formal Living Room; Formal Dining Room; Powder Room; Bumped Out Family Room w/ Gas Fireplace; Bumped Out Breakfast Nook with access to the Backyard Deck; and a Gourmet Kitchen with Granite Countertops, Island, & Butlers Pantry. The Main Level recently underwent a Professional Makeover with All New Kitchen Upgrades: 4-Piece Stainless Steel Bosch Appliances; Built in Miele Coffee Maker; 2 Tone Painted Maple Cabinets with Under Cabinet Lighting; Tile Backsplash; New Pendant Lights, New Chandeliers; Maple Hardwood Floors Refinished with Warm Gray (main level); Walls Painted; and New Window Treatments. Traveling Upstairs note the Custom Runner over the Stained Oak Staircase. The Primary Bedroom features Cherry Maple Hardwood Floors; 2 Closets; Attached Ceramic Full Bathroom with Spa Tub; Oversized Ceramic Stall Shower; and 2 Separate Vanities. Each of the Two Additional Bedrooms have been Upgraded with durable Bamboo Floors and the Hallway has Cherry Maple Hardwood Floors. Full Ceramic Hall Bathroom w/ Tub Shower; a convenient Walk-in Ceramic Laundry Room with Front Loading Washer & Dryer; and Linen Closet complete this Level. The Large Finished Loft on the 3rd Floor has the 4th Bedroom with bonus Sitting Area; durable Cork Floors; 2 Walk-in Closets; and an Ensuite Ceramic Full Bathroom w/ Tub Shower. The Elegant Glass Door on the Main Level leads you to the Basement featuring a Finished Recreation Room with Dry Bar and LVP Floors; Full Ceramic Tiled Bathroom w/ Tub Shower; 2 Closets; and the Separate Utility & Storage Room. The Backyard Oasis is Fully Fenced with the 6 ft Tall Privacy Vinyl Fence with 2 Gates accessing the Alley & 1 Gate connecting you to the Front Yard, a Raised Garden; multiple Flower Beds, Mature Trees, Hardscaped, nook under the Deck and ready for entertaining and relaxing. Have peace of mind knowing the Roof on both the Home and 2 Car Detached Garage have been Replaced in Jan 2022; Exterior of the home was Professionally Painted and Sealed in 2020; CINCH 1 Year Home Warranty is Included. The Villages of Urbana features multiple community pools, gym, trails, playgrounds, tennis, basketball courts, community events and more! Shopping centers close by and is great for commuters! 1.5 Minute Video Tour is uploaded. (Agent related to the Sellers. )
Single-familyProperty Type
2007Year Built
4,920 sq ftLot Size
$249Est. Price/Sq.Ft.
2 car garageParking
Listed by Jessica Almodovar• RE/MAX Realty Plus
•301-831-5600 (broker)
Listed by Maureen Nichols• RE/MAX Realty Plus
•301-831-5600 (broker)
Bought with Lisa Giuliani• Keller Williams Realty Centre
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
—
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
4,920 Sq. Ft.
Year renovated
—
Sq. Ft.
2,178
Year built
2007
Style
Single Family Residential
County
Frederick County
APN
07 241518
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 17, 2026.
PUD
Planned Development District
The Planned Development Districts (Planned Unit Development and Mixed Use Development) are floating zones established to provide for new development and redevelopment within identified growth areas that result in an integrated mixture of commercial, employment, residential, recreational, civic and/or cultural land uses as provided within the appropriate Frederick County Comprehensive, Community, or Corridor Plan. These uses planned and developed as a unit are intended to: Result in an efficient use of land and the efficient extension of public facilities; Allow innovative design involving flexibility not permitted within Euclidean zoning districts; Promote continuity of new development with existing development through building and site design, including consideration of architectural elements, landscape design, building placement, and street network; Promote building and site design that reduces dependence on vehicular movement through the provision of bicycle, pedestrian, and transit friendly elements which include transportation circulation networks linking internal and external residential, commercial, employment areas, and recreation, open spaces and public facilities; Result in an integrated mixture of uses within the Mixed Use Development District and a mixture of housing types within the Planned Unit Development District; Promote the protection, preservation, and integration of historic resources into the planned development through reuse, adaptive use, and rehabilitation; Promote the evaluation, protection, and integration of natural features and sensitive environmental resources into building and site design; Provide development flexibility to respond to market demands.
Permitted uses
Include but are not limited to:
Community / recreation center
Healthcare
Housing-Single unit
Housing-Multiple units
Housing-Senior
Public service
Educational/school
Death related/funeral home
Property details
Parking
Parking Information
Garage Sq. Ft.: 404
# of Detached Garage Spaces: 2
Garage Features: Garage Door Opener, Garage - Front Entry, Additional Storage Area
# of Total Garage and Parking Spaces: 2
Has Garage
# of Garage Spaces: 2
Detached Garage, On Street, Alley
Interior
Virtual Tour
Bedroom Information
# of Bedrooms On 1st Upper Level: 3
# of Bedrooms On 2nd Upper Level: 1
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 2
# of Bathrooms (Full) On 2nd Upper Level: 1
# of Bathrooms (Half) On Main Level: 1
# of Bathrooms (Full) On 1st Lower Level: 1
# of Bathrooms (Full) On All Upper Levels: 3
# of Bathrooms (Full) On All Lower Levels: 1
# of Bathrooms (Half): 1
# of Bathrooms (Full): 4
Interior Information
Appliances: Dishwasher, Disposal, Icemaker, Oven/Range - Gas, Refrigerator, Built-In Microwave, Dryer - Front Loading, Energy Efficient Appliances, Stainless Steel Appliances, Washer - Front Loading
Flooring Type: Bamboo, Hardwood, Ceramic Tile
Interior Features: Butlers Pantry, Family Room Off Kitchen, Kitchen - Island, Dining Area, Chair Railings, Crown Moldings, Upgraded Countertops, Master Bath(s), Floor Plan - Open, Formal/Separate Dining Room, Pantry, Stall Shower, Tub Shower, Wet/Dry Bar, WhirlPool/HotTub, Window Treatments, Wood Floors
Living Area Sq.Ft. Source: Estimated
Room Information
Living Room, Dining Room, Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Foyer, Breakfast Room, Laundry, Recreation Room, Utility Room, Attic, Master Bathroom, Full Bath, Half Bath
Laundry Type: Upper Floor, Has Laundry, Dryer In Unit, Washer In Unit
Fireplace Information
Has Fireplace
# of Fireplaces: 1
Mantel(s), Gas/Propane
Basement Information
Basement: Yes
Sump Pump, Full, Partially Finished, Space For Rooms, Improved, Heated, Interior Access, Windows, Connecting Stairway
Basement Footprint Percent: 100.00
Basement Finished Percent: 65.00
Exterior
Property Information
Not Federal Flood Zone
Property Manager Present
Total Below Grade Sq. Ft.: 1122
Irrigation Water Rights
Improvement Assessed Value: $325,900
Ownership Interest: Fee Simple
Property Condition: Excellent
Year Built Source: Assessor
Year Major Reno/Remodel: 2022
Building Information
Builder Name: PARKWOOD HOMES
Building Name: VILLAGES OF URBANA
Construction Materials: Fiber Cement
Foundation Details: Concrete Perimeter, Passive Radon Mitigation
Main Entrance Orientation: Northeast
Other Structures: Above Grade, Below Grade
Outdoor Living Structures: Porch(es), Deck(s), Patio(s)
Roof: Shingle, Metal
Structure Type: Detached
Window Features: Double Hung, Energy Efficient, Vinyl Clad
Other Structures: Gazebo
Exterior Information
Sidewalks, Hot Tub, Extensive Hardscape, Stone Retaining Walls
Fencing: Fully, Picket, Vinyl, Privacy, Rear
Pool Information
Community Pool Features: In Ground, Lap/Exercise
Community Pool
Property Green Features
Energy Efficient: Appliances, HVAC, Construction
Energy Generation: PV Solar Array(s) Leased
Lot Information
Lot Features: Rear Yard, Front Yard
Tidal Water: No
Land Information
Land Assessed Value: $196,800
Above Grade Information
Unfinished Sq.Ft.: 25
Unfinished Sq.Ft. Source: Estimated
Finished Sq.Ft.: 2,673
Finished Sq.Ft. Source: Estimated
Below Grade Information
Unfinished Sq.Ft.: 386
Unfinished Sq.Ft. Source: Estimated
Finished Sq.Ft.: 736
Finished Sq.Ft. Source: Estimated
Financial
Tax Information
County Tax: $5,801.97
Tax Assessed Value: $522,700
Tax Year: 2025
Tax Annual Amount: $7,439.44
Assessments Information
Year Assessed: 2022
Utilities
Utilities Information
Cable
Central Air
Cooling Type: Central A/C, Zoned
Cooling Fuel: Electric
Photovoltaics Third-Party Owned
Forced Air, Zoned
Heating Fuel: Natural Gas
Hot Water: Natural Gas
Sewer Septic: Public Sewer
Cable TV Available, Multiple Phone Lines, Under Ground
Water Source: Public
Municipal Trash: No
Location
Homeowners Association Information
HOA/Condo/Coop Fee Includes: Common Area Maintenance, Lawn Care Rear, Management, Pool(s), Recreation Facility, Road Maintenance, Snow Removal, Trash, Health Club
HOA/Condo/Coop Amenities: Basketball Courts, Bike Trail, Club House, Common Grounds, Community Center, Fitness Center, Jog/Walk Path, Picnic Area, Pool - Outdoor, Swimming Pool, Tennis Courts, Tot Lots/Playground
HOA Fee: $134
HOA Fee Frequency: Monthly
School Information
Elementary School: CENTERVILLE
Middle Or Junior School: URBANA
High School: URBANA
School District Name: FREDERICK COUNTY PUBLIC SCHOOLS
Elementary School Source: Listing Agent
Middle School Source: Listing Agent
High School Source: Listing Agent
School District Source: Listing Agent
Location Information
Outside City Limits
Cross Street: Addison Woods & Prospect Hill
Directions: From I-270 take Exit 26 to Urbana MD 80 / Fingerboard Rd and go East. Left onto Campus Dr. Right onto Addison Woods Rd. 3925 is on your Right. Park along street and be mindful to allow other cars/neighbors to also be able to park. Look for American Flag on front porch.
Public facts
Beds: —
Baths: 2.5
Sq. Ft.: 2,178
Stories: 2.0
Lot Size: 4,920 square feet
Style: Single Family Residential
Year Built: 2007
Year Renovated: —
County: Frederick County
APN: 07 241518
Home facts updated by county records on Jul 17, 2026
Around this home
Schools
Centerville Elementary
Public PreK-5 • Assigned • 0.2mi
9/10
Urbana Middle School
Public 6-8 • Assigned • 0.6mi
10/10
Urbana High School
Public 9-12 • Assigned • 0.8mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
6/10 Heat Factor
7 days above 102° expected this year, 17 days in 30 years
3/10 Wind Factor
7% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Frederick, MD • 21704
Average low and high temperatures (°F)
37
23
43
28
61
40
69
49
74
55
85
65
90
72
82
63
78
60
69
47
57
39
43
29
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.2 hours in
June and 3.9 hours in December, placing it below the
U.S. average for solar exposure.
9.2 hrs
3.9 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$807,000 – $977,000
Reach more buyers when you sell with Redfin. Save up to $8,491 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.