CREME DELA CREME next to STONEBROOK !VERY DESIRABLE COMMUTER LOC! BRAGGS'S OF OWNERSHIP PRIDE! Stream on PRIVATE LOT & Mature LOVELY landscaping to include fresh fruit! 2 MASTERSUITES, 1 MN LEVELl! UNBELIEVABLE STOMPED PAVED PATIO & MUTI TIERED DECK!STONE FP "floor 2 ceiling"! Gourmet Kitchen w/ island & SS APPLIANCES!LOVELY OVERLOOK from upper level!IMPRESSIVE! SERIOUS BASEKETBALL Ct. 2 much more
Single-familyProperty Type
2003Year Built
4.92 acresLot Size
$220Est. Price/Sq.Ft.
2 car garageParking
Listed by Jeannie Thomson• Long & Foster/Webber & Associates
*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
5
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
4.92 Acres
Year renovated
2017
Sq. Ft.
3,760
Year built
2003
Style
Single Family Residential
County
Frederick County
APN
62 A 51B
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
RP
Residential Performance District
Part 402 is intended to provide for a compatible mixture of quality residential housing types within the Urban Development Area, consistent with the residential land use policies of the Comprehensive Plan. The plan identifies basic land use characteristics which are to be encouraged: Efficient land use patterns that create high-quality neighborhoods that are attractive and pedestrian oriented; Densities that promote a compact and efficient use of land; Reduced housing and public facility costs; Energy efficient housing and housing patterns; Sustainable and environmentally sensitive land use.; It is the intent of this Part 402 to allow a mixture of housing types on the land within an approved master development plan. Within this Part 402, the permitted development percentages and densities for all housing types are identified. The master development plan shall specify the amount and percentages of all proposed housing types.
Permitted uses
Include but are not limited to:
Religious facility
Housing-Group
Housing-Single unit
Housing-Multiple units
Housing-Senior
Infrastructure
Public service
Educational/school
Fire house
Library
Property details
Parking
Parking Information
# of Attached Garage Spaces: 2
Garage Features: Garage Door Opener
# of Total Garage and Parking Spaces: 2
Has Garage
# of Garage Spaces: 2
Garage
Attached Garage
Interior
Virtual Tour
Bedroom Information
# of Bedrooms On 1st Upper Level: 4
# of Bedrooms On Main Level: 1
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 2
# of Bathrooms (Half) On Main Level: 1
# of Bathrooms (Full) On Main Level: 1
# of Bathrooms (Half): 1
# of Bathrooms (Full): 3
Interior Information
Appliances: Cooktop, Dishwasher, Microwave, Oven - Double, Oven - Self Cleaning, Refrigerator, Water Conditioner - Owned, Water Heater - High-Efficiency
Entry Location: Foyer
Interior Features: Family Room Off Kitchen, Kitchen - Gourmet, Kitchen - Island, Breakfast Area, Dining Area, Master Bath(s), Entry Level Bedroom, Upgraded Countertops, Crown Moldings, WhirlPool/HotTub, Wood Floors, Floor Plan - Open