Move in condition. Every available upgrade from the builder. Unique 4 lvl Main Street townhouses is 22' wide. Gourmet, center island, eat-in kitchen with cherry cabinets, granite counters & stainless steel appliances. Gleaming hardwood floors on the entire main lvl and the upstairs hall, steps & master bedroom. Master suite with 2 closets & luxury master bath. Finished loft with full bath!
TownhomeProperty Type
2006Year Built
4,588 sq ftLot Size
$226Est. Price/Sq.Ft.
2 spacesParking
Listed by John Bayley• Keller Williams Home Towne Realty
•240-405-1660 (broker)
Bought with Non Member Member• Metropolitan Regional Information Systems, Inc.
*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
4.5
Stories
2.5
Lot width
—
Lot depth
—
Lot size
4,588 Sq. Ft.
Year renovated
—
Sq. Ft.
3,000
Year built
2006
Style
Townhouse
County
Frederick County
APN
07 242379
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.
Cable TV Available, Multiple Phone Lines, Under Ground
Water Source: Public
Location
Homeowners Association Information
HOA/Condo/Coop Amenities: Baseball Field, Basketball Courts, Common Grounds, Community Center, Jog/Walk Path, Library, Pool - Outdoor, Soccer Field, Tennis Courts, Tot Lots/Playground
HOA Fee: $100
HOA Fee Frequency: Monthly
Location Information
Directions: Sugarloaf Prkwy to Shawfield to right on Prospect Hill to house on left or Sugarloaf to Addison Woods to left on Prospect Hill to house on right
Public facts
Beds: —
Baths: 4.5
Sq. Ft.: 3,000
Stories: 2.5
Lot Size: 4,588 square feet
Style: Townhouse
Year Built: 2006
Year Renovated: —
County: Frederick County
APN: 07 242379
Home facts updated by county records on Jul 17, 2026
Around this home
Schools
Centerville Elementary
Public PreK-5 • Assigned • 0.3mi
9/10
Urbana Middle School
Public 6-8 • Assigned • 0.6mi
10/10
Urbana High School
Public 9-12 • Assigned • 0.9mi
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
7/10 Heat Factor
8 days above 102° expected this year, 18 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
$601,000 – $728,000
Reach more buyers when you sell with Redfin. Save up to $6,326 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.