---TO BE BUILT---The Columbia single-family home is just as inviting as it is functional. Discover a magnificently spacious floor plan with custom flex areas. The welcoming family room effortlessly flows into the gourmet kitchen and dining area, so you never miss a moment. Add a covered porch for those warm summer nights and use the family entry to control clutter. On the second floor, 4 large bedrooms await, with the option to change one to a cozy loft for more living and entertaining space. Your luxurious owner's suite offers a walk-in closet and spa-like double vanity bath. Photos are representative. Other floorplans and homesites available.
*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
7,243 Sq. Ft.
Year renovated
—
Sq. Ft.
2,912
Year built
2024
Style
Single Family Residential
County
Frederick County
APN
02 606628
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 17, 2026.
R-8
Medium Density Residential District
The R8 District is intended to provide for residences in an urban residential environment with a maximum density of 8 dwellings per acre. In addition, this district is intended to accommodate a complement of residential support uses normally utilized during the daily activities of residents, to protect these areas from the encroachment of incompatible uses and to guide development within the district to occur in a manner that complies with the Comprehensive Plan.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Group
Housing-Single unit
Housing-Multiple units
Park & open space
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
Attached Garage, Driveway
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
Living Area Sq.Ft. Source: Estimated
Room Information
Living Room, Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Study, Laundry, Master Bathroom, Full Bath, Half Bath
Basement Information
Basement: Yes
Full
Exterior
Property Information
Irrigation Water Rights
Ownership Interest: Fee Simple
Year Built Source: Estimated
Building Information
Builder Name: Ryan Homes
Construction Completed
Construction Materials: Mixed
Foundation Details: Concrete Perimeter
Other Structures: Above Grade
Structure Type: Detached
Pool Information
Community Pool
Lot Information
Tidal Water: No
Above Grade Information
Finished Sq.Ft.: 2,423
Finished Sq.Ft. Source: Estimated
Financial
Tax Information
Tax Year: 2024
Utilities
Utilities Information
Central Air
Cooling Type: Central A/C
Cooling Fuel: Electric
Central
Heating Fuel: Natural Gas
Hot Water: Tankless
Sewer Septic: Public Sewer
Water Source: Public
Location
Homeowners Association Information
HOA Fee: $30
HOA Fee Frequency: Monthly
School Information
Elementary School: WHITTIER
Middle Or Junior School: WEST FREDERICK
High School: FREDERICK
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
In City Limits
Directions: 2200 Campbell Hill Way, Frederick, MD 21702
Public facts
Beds: —
Baths: 3.5
Sq. Ft.: 2,912
Stories: 2.0
Lot Size: 7,243 square feet
Style: Single Family Residential
Year Built: 2024
Year Renovated: —
County: Frederick County
APN: 02 606628
Home facts updated by county records on Jul 17, 2026
Around this home
Schools
Waverley Elementary School
Public PreK-5 • Assigned • 0.9mi
4/10
Crestwood Middle School
Public 6-8 • Assigned • 3.8mi
5/10
Gov. Thomas Johnson High School
Public 9-12 • Assigned • 2.9mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Historical weather
Frederick, MD • 21702
Average low and high temperatures (°F)
34
21
40
26
58
38
66
47
71
54
82
64
87
70
79
62
76
59
66
47
54
38
41
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 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
$656,000 – $794,000
Reach more buyers when you sell with Redfin. Save up to $6,896 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.