OPEN SUN 6/2 - 1:00-4:00 Beautiful Brick front colonial situated on a large, level and fenced lot. You and your family will love this home! First floor library/office, center island kitchen with high-end stainless steel appliances, two story foyer, 9 foot ceilings, custom trim and columns, family room with gas FP, large master suite and spa bath, two car garage, a partially finished basement, front porch, formal dining room, a large patio for cookouts or entertaining and sooo much more. You will even get a FREE One-Year Warranty covering all the major systems of this home! There's economical gas cooking, hot water heater and furnace. There's even fresh paint and a brand-new architectural shingle roof! I think you'll be happy you included this one on your list, especially at this price.
Welcome to this fantastic, colonial-style home in the sought after neighborhood of Green Hill Manor, boasting four bedrooms, two and a half baths, beautiful table-space kitchen w/ breakfast bar, open family room, office and formal dining room, fresh paint throughout and new carpet on main lvl. Basement is partially finished to create a play area and has plenty of storage
*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
0.36 Acres
Year renovated
—
Sq. Ft.
3,507
Year built
1999
Style
Single Family Residential
County
Frederick County
APN
01 032879
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 8, 2026.
R3
Residential District 3
The purpose of the residential density districts is to promote healthful and convenient distribution of population with sufficient densities to maintain a high standard of physical design and community service. Residential density districts will conform to the County Comprehensive Plan and will be located within areas identified for residential development. The districts, as a group, are intended to provide for a variety of dwelling types and densities and to offer housing choices at various economic levels. It is further the intent to establish various densities of residential developments in order to efficiently and effectively provide for necessary public services and facilities. The following residential density districts and maximum densities are hereby established.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Group
Housing-Single unit
Housing-Multiple units
Property details
Parking
Parking Information
# of Attached Garage Spaces: 2
Garage Features: Garage - Front Entry
# of Total Garage and Parking Spaces: 2
Has Garage
# of Garage Spaces: 2
Paved Driveway
Attached Garage
Interior
Virtual Tour
Bedroom Information
# of Bedrooms On 1st Upper Level: 4
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 2
# of Bathrooms (Half) On Main Level: 1
# of Bathrooms (Full) On All Upper Levels: 2
# of Bathrooms (Half): 1
# of Bathrooms (Full): 2
Interior Information
Appliances: Built-In Microwave, Dishwasher, Disposal, Dryer, Exhaust Fan, Extra Refrigerator/Freezer, Icemaker, Refrigerator, Stove, Washer, Microwave, Oven/Range - Gas, Washer - Front Loading, Dryer - Front Loading
Door Features: Insulated, Six Panel, Sliding Glass, Storm
Flooring Type: Carpet, Hardwood
Interior Features: Carpet, Chair Railings, Dining Area, Family Room Off Kitchen, Formal/Separate Dining Room, Kitchen - Island, Master Bath(s), Walk-in Closet(s), Window Treatments, Wood Floors
Living Area Sq.Ft. Source: Assessor
Wall & Ceiling Types: 9'+ Ceilings
Room Information
Living Room, Dining Room, Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Game Room, Family Room, Foyer, Breakfast Room, Laundry, Office, Storage Room, Bathroom 2, Master Bathroom
Laundry Type: Has Laundry, Main Floor
Fireplace Information
Has Fireplace
# of Fireplaces: 1
Gas/Propane, Mantel(s)
Basement Information
Basement: Yes
Full, Partially Finished
Exterior
Property Information
Not Federal Flood Zone
Property Manager Present
Total Below Grade Sq. Ft.: 1347
Irrigation Water Rights
Horse: No
Improvement Assessed Value: $310,400
Ownership Interest: Fee Simple
Property Condition: Very Good
Year Built Source: Assessor
Building Information
Construction Materials: Brick Front, Vinyl Siding
Main Entrance Orientation: South
Other Structures: Above Grade, Below Grade
Outdoor Living Structures: Patio(s)
Roof: Architectural Shingle
Structure Type: Detached
Window Features: Double Pane, Screens
Other Structures: Shed
Exterior Information
Satellite Dish
Fencing: Rear
Lot Information
Lot Features: Landscaping, Level
Tidal Water: No
Land Information
Land Assessed Value: $113,700
Above Grade Information
Finished Sq.Ft.: 2,607
Finished Sq.Ft. Source: Assessor
Below Grade Information
Unfinished Sq.Ft.: 447
Unfinished Sq.Ft. Source: Assessor
Finished Sq.Ft.: 900
Finished Sq.Ft. Source: Assessor
Financial
Tax Information
County Tax: $4,850
Tax Assessed Value: $417,300
Tax Year: 2018
Tax Annual Amount: $4,938
Assessments Information
Year Assessed: 2019
Utilities
Utilities Information
Central Air
Cooling Type: Central A/C, Ceiling Fan(s)
Cooling Fuel: Electric
Forced Air
Heating Fuel: Natural Gas
Hot Water: Natural Gas
Sewer Septic: Public Sewer
Water Source: Public
Location
Homeowners Association Information
HOA/Condo/Coop Fee Includes: Common Area Maintenance, Management, Trash
HOA/Condo/Coop Amenities: Tot Lots/Playground, Non-Lake Recreational Area, Soccer Field
HOA Fee: $400
HOA Fee Frequency: Annually
School Information
Elementary School: CARROLL MANOR
Middle Or Junior School: BALLENGER CREEK
High School: TUSCARORA
School District Name: FREDERICK COUNTY PUBLIC SCHOOLS
Elementary School Source: 3rd Party
Middle School Source: 3rd Party
High School Source: 3rd Party
School District Source: 3rd Party
Location Information
Outside City Limits
Directions: Union Ridge Dr intersects with New Design Rd a little south of Frederick. Take Union Ridge Dr west to #5886 on right.
Entry Floor Number: 1
Public facts
Beds: —
Baths: 2.5
Sq. Ft.: 3,507
Stories: 2.0
Lot Size: 0.36 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: —
County: Frederick County
APN: 01 032879
Home facts updated by county records on Oct 8, 2026
Around this home
Schools
Carroll Manor Elementary School
Public PreK-5 • Assigned • 0.4mi
5/10
Ballenger Creek Middle School
Public 6-8 • Assigned • 5.5mi
7/10
Tuscarora High School
Public 9-12 • Assigned • 4.9mi
6/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 103° expected this year, 16 days in 30 years
4/10 Wind Factor
7% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Adamstown, MD • 21710
Average low and high temperatures (°F)
38
22
43
27
62
38
70
47
74
54
85
64
90
70
82
62
80
59
69
45
58
38
43
28
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 4 hours in December, placing it below the
U.S. average for solar exposure.
9.2 hrs
4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$627,000 – $759,000
Reach more buyers when you sell with Redfin. Save up to $6,597 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.