Property Details
Property Details
- Bright MLS: MDFR2089286
- Status: ACT
- List Price: $938,800
- Square Feet: 2,228
- Year Built: 2026
- Zoning: DB
Interior Features
Interior Features
- Interior Features: Bathroom - Stall Shower, Bathroom - Walk-In Shower, Breakfast Area, Combination Dining/Living, Combination Kitchen/Dining, Combination Kitchen/Living, Dining Area, Entry Level Bedroom, Family Room Off Kitchen, Floor Plan - Open, Kitchen - Eat-In, Kitchen - Gourmet, Kitchen - Island, Pantry, Primary Bath(s), Recessed Lighting, Sprinkler System, Walk-in Closet(s), Other
- Flooring: Luxury Vinyl Plank, Ceramic Tile
- Appliances Included: Built-In Microwave, Dishwasher, Disposal, Exhaust Fan, Icemaker, Oven/Range - Electric, Refrigerator, Stainless Steel Appliances
- Heat System: Central, Forced Air
- Cooling: Central A/C, Multi Units
- Stories: 4
- Fireplace: 2
Exterior Features
Exterior Features
- Construction Materials: Advanced Framing, Batts Insulation, Blown-In Insulation, Brick, HardiPlank Type, Metal Siding, Steel Siding, Stick Built, Stone, Other
- Lot Description: Landscaping, Private, Zero Lot Line
- Exterior Features: Extensive Hardscape, Exterior Lighting, Gutter System, Sidewalks, Street Lights
- Foundation: Passive Radon Mitigation, Slab
- Roof: Metal
- Parking Types: Attached Garage
- Lot Features: Landscaping, Private, Zero Lot Line
- Window Features: Double Pane, Energy Efficient, Insulated, Low-E, Wood Frame, Transom
Community
Community
- Address: 2 Water Street
- Subdivision: Downtown Frederick
- Town: Frederick
- State: MD
- Zip: 21701
Finance
Schools
- Elementary School: Spring Ridge
- Junior High: Governor Thomas Johnson
- High School: Governor Thomas Johnson
- High School District: Frederick County Public Schools
Other Details
Other Details
- Date Listed: 09/14/2026
- Broker Name: Long & Foster Real Estate, Inc.











Copyright 2026 BRIGHT, All Rights Reserved. Information Deemed Reliable But Not Guaranteed. The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which Anthony Hayes participates, and is provided by BRIGHT through a licensing agreement. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.Data last updated September 18, 2026. Some properties which appear for sale on this website may no longer be available because they are under contract, have Closed or are no longer being offered for sale.