Nestled in the prestigious Green Hill Manor, this exquisite Colonial home offers a harmonious blend of elegance and comfort. Spanning 4026 sq. ft. , the residence features four spacious bedrooms and three and a half luxurious bathrooms, designed for both relaxation and entertaining. Step inside to discover a warm and inviting interior adorned with rich wood floors, crown moldings, and recessed lighting that create an ambiance of sophistication. The gourmet kitchen, complete with upgraded countertops, stainless steel appliances, and an expansive island, flows seamlessly into the family room, making it the perfect space for gatherings. Enjoy cozy evenings by the gas fireplace or unwind in the primary suite, featuring a spa-like soaking tub and walk-in closet. Outside, the beautifully landscaped 0.37-acre lot features a level rear yard and a charming patio, perfect for alfresco dining or quiet moments in the garden. With an attached two-car garage and ample driveway parking, convenience is at your fingertips. This home is not just a residence; it's a lifestyle, offering a serene retreat with modern amenities in a sought-after community. Experience the perfect blend of luxury and comfort in this exceptional property.
Single-familyProperty Type
2004Year Built
0.37 acresLot Size
$178Est. Price/Sq.Ft.
2 garage spacesParking
Listed by Scott Wilburn• Core Partners Realty LLC
•717-718-0748 (broker)
•michael@segarrahomes.com (broker)
Listed by Carrie Wilburn• Core Partners Realty LLC
•717-718-0748 (broker)
•michael@segarrahomes.com (broker)
Bought with Charles Van Swol• Cummings & Co. Realtors
Exceptional opportunity to secure this beautiful estate in Green Hill Manor. Meticulously kept, this is a rare find. Enter into the grand foyer, you are greeted with sweeping wood floors. Den/library on the right, light filled formal living and dining rooms on the left. Gourmet kitchen that will make any chef's dream come true, fresh with stainless steel appliances and granite counter tops. Large dining area for all those gatherings, 4 seasons room perfect for your morning coffee, or for all your sun loving plants. The family room off the kitchen features new hard wood floors, gas burning fire place, and built in shelving. Laundry/mud room off the 2 car garage - featuring ceiling storage. The fully finished basement offers a home gym and second office/flex space, home theatre area, and wet bar with full fridge. There is plenty of space for storage with 3 additional closest and full bath room. Head to the 3rd level with brand new hardwood flooring where you will be pampered by the primary en suite with sitting room, walk in closet, luxurious garden tub, dual sinks, separate standing shower, and water closet. 3 additional bedrooms are spacious and 3rd full bath finish the interior of this beautiful home. The outdoor area is as aesthetically pleasing as it is functional. The stone porch is a lovely way to spend the evenings. You don't want to miss out on the fantastic opportunity to own your own little piece of paradise. Welcome to 5904 Union Ridge Drive.
BRIGHT MLS #MDFR246714
Jun 18, 2019
Sold
$490,000
$122/sq ft
May 21, 2019
Pending
—
May 18, 2019
Listed
$489,999
$122/sq ft
+35
This home is an entertainers dream! Just imagine the get togethers you can have here! The sunroom offers a great place to watch your favorite team play! And just imagine the cookouts you can have with the rear covered porch, stone patio, and fenced yard! Or, maybe you enjoy evenings by the fire pit! Either way, this home gives you the opportunity to have it all! Inside you have an open spacious floor plan with your own office, a kitchen / family room combo with a large island and a breakfast room! Not to mention the separate dining room / living room combo! Upstairs you have 3 spacious bedroom in addition to the master suite with a walk in closet and master bathroom featuring a 2 person soaking tub, full shower and separate sinks! The lower level offers a 2nd family room, a rec room, full bathroom, and a wet bar! Have I mentioned that this home is an entertainers dream? There's also an additional room that could be another sleeping area of 2nd office or just for storage! You also could save thousands by taking advantage of our special financing! Ask your Realtor for more information and schedule your private tour TODAY!
BRIGHT MLS #MDFR244708
May 7, 2019
Listing Removed
—
Apr 29, 2019
Price Changed
$499,900
$124/sq ft
Apr 20, 2019
Listed
$514,900
$128/sq ft
BRIGHT MLS #1005064668
Oct 28, 2011
Sold
$345,000
$86/sq ft
Feb 13, 2011
Listing Removed
—
Nov 30, 2010
Listed
$349,900
$87/sq ft
Public Records
Mar 24, 2004
Sold
$146,331
$36/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$7,379 (+8.2%)
2025
$6,821 (+8.9%)
2024
$6,264 (+8.7%)
2023
$5,761 (+4.5%)
$114,500 + $395,500
$510,000
2022
$5,511 (+3.8%)
2021
$5,308 (+3.3%)
2020
$5,136 (+2.5%)
$114,500 + $330,900
$445,400
2019
$5,011 (+1.6%)
2018
$4,931 (+5.3%)
$114,500 + $298,700
$413,200
2017
$4,682 (+8.7%)
2015
$4,309 (−0.3%)
$114,500 + $245,700
$360,200
2014
$4,324 (−1.2%)
2013
$4,376
2012
$4,376
2011
$4,376
2010
$4,376 (+0.1%)
2009
$4,370
Tax history for 5904 Union Ridge Dr
Year
Property tax
Land + Additions
Assessment*
2026
$7,379 (+8.2%)
2025
$6,821 (+8.9%)
2024
$6,264 (+8.7%)
2023
$5,761 (+4.5%)
$114,500 + $395,500
$510,000
2022
$5,511 (+3.8%)
2021
$5,308 (+3.3%)
2020
$5,136 (+2.5%)
$114,500 + $330,900
$445,400
2019
$5,011 (+1.6%)
2018
$4,931 (+5.3%)
$114,500 + $298,700
$413,200
2017
$4,682 (+8.7%)
2015
$4,309 (−0.3%)
$114,500 + $245,700
$360,200
2014
$4,324 (−1.2%)
2013
$4,376
2012
$4,376
2011
$4,376
2010
$4,376 (+0.1%)
2009
$4,370
*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
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.37 Acres
Year renovated
—
Sq. Ft.
3,444
Year built
2004
Style
Single Family Residential
County
Frederick County
APN
01 038591
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
Garage Sq. Ft.: 380
# of Attached Garage Spaces: 2
Garage Features: Additional Storage Area, Garage - Front Entry
# of Total Garage and Parking Spaces: 6
Has Garage
# of Garage Spaces: 2
Driveway - # of Spaces: 4
Paved Parking
Attached Garage, Driveway, On Street
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 1st Lower Level: 1
# of Bathrooms (Full) On All Upper Levels: 2
# of Bathrooms (Full) On All Lower Levels: 1
# of Bathrooms (Half): 1
# of Bathrooms (Full): 3
Interior Information
Appliances: Cooktop, Dishwasher, Disposal, Dryer - Gas, Exhaust Fan, Oven - Single, Refrigerator, Stainless Steel Appliances, Washer, Water Heater
Door Features: Six Panel, Sliding Glass, Storm
Flooring Type: Ceramic Tile, Vinyl, Wood
Not Furnished
Interior Features: Bar, Soaking Tub, Stall Shower, Tub Shower, Breakfast Area, Built-Ins, CeilngFan(s), Chair Railings, Combination Dining/Living, Combination Kitchen/Dining, Combination Kitchen/Living, Crown Moldings, Dining Area, Family Room Off Kitchen, Floor Plan - Traditional, Formal/Separate Dining Room, Kitchen - Eat-In, Kitchen - Gourmet, Kitchen - Island, Pantry, Master Bath(s), Recessed Lighting, Sprinkler System, Store/Office, Upgraded Countertops, Walk-in Closet(s), Wet/Dry Bar, Wood Floors
Lot Features: Front Yard, Landscaping, Level, Rear Yard
Tidal Water: No
Land Information
Land Assessed Value: $119,000
Above Grade Information
Unfinished Sq.Ft.: 0
Unfinished Sq.Ft. Source: Estimated
Finished Sq.Ft.: 2,889
Finished Sq.Ft. Source: Estimated
Below Grade Information
Unfinished Sq.Ft.: 644
Unfinished Sq.Ft. Source: Estimated
Finished Sq.Ft.: 1,137
Finished Sq.Ft. Source: Estimated
Financial
Tax Information
Agricultural Tax Due: No
County Tax: $6,740
Tax Assessed Value: $556,067
Tax Year: 2025
Tax Annual Amount: $6,740
Assessments Information
Year Assessed: 2025
Lease Information
Lease Considered: No
Utilities
Utilities Information
Central Air
Cooling Type: Ceiling Fan(s), Central A/C, Ductless/Mini-Split
Cooling Fuel: Electric
200+ Amp Service
Heat Pump(s)
Heating Fuel: Natural Gas
Hot Water: Natural Gas
Sewer Septic: Public Sewer
Water Source: Public
Location
Homeowners Association Information
HOA Fee: $325
HOA Fee Frequency: Annually
School Information
School District Name: FREDERICK COUNTY PUBLIC SCHOOLS
Location Information
Outside City Limits
Directions: From Montgomery County: 270N to 80W, take exit 26. Follow to Union Ridge Drive. House will be on the right from Baltimore. 70W to 15S. Left onto Mountville Road, Left onto Adamstown Road, Right onto Decatur Drive, Left onto Union Ridge Drive. House will be on the left.
Road Surface Type: Black Top
Public facts
Beds: —
Baths: 3.5
Sq. Ft.: 3,444
Stories: 2.0
Lot Size: 0.37 acres
Style: Single Family Residential
Year Built: 2004
Year Renovated: —
County: Frederick County
APN: 01 038591
Home facts updated by county records on Oct 8, 2026
Around this home
Schools
Carroll Manor Elementary School
Public PreK-5 • Assigned • 0.3mi
5/10
Ballenger Creek Middle School
Public 6-8 • Assigned • 5.5mi
7/10
Tuscarora High School
Public 9-12 • Assigned • 4.8mi
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, 17 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
$681,000 – $824,000
Reach more buyers when you sell with Redfin. Save up to $7,163 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.