2004 Alice Court
Frederick, MD 21702
- 3 beds
- 4 baths
- 2,121 sqft
- 9,000 sqft lot
- $244 per sqft
- 2024 build
More homes
The only brand new garage townhomes featuring exquisite Modern Farm House exteriors and backing to open green space! Welcome home to the Harlow II at Tuscarora Creek East where you will be within 15 minutes of vibrant downtown Frederick yet tucked in the rolling hills and tranquility of this sought after area! This modern, open concept home boasts 2121 square feet of luxurious living space including a stunning all brick front, 3 bedrooms with 2 full and 2 half baths and oversized 2 car front entry garage. You will enjoy cooking in your spacious kitchen with lots of natural light throughout and beautiful gray cabinets with sparkling white quartz countertops and stainless steel appliances. This home will be completed in July so you can move in before the new school year starts! This one will surely not last long! Call for your personal tour today!! *Photos may not be of actual home. Photos may be of similar home/floorplan if home is under construction or if this is a base price listing.
Listing courtesy of BRIGHT / DRB Group Realty, LLC
Last checked:
Checking…
•
Last updated Oct 24, 2024
•
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
MLS# MDFR2050538 —
The Building
-
Year Built:2024
-
Year Built Source:Estimated
-
New Construction:Yes
-
Builder Name:Drb Homes
-
Builder Model:HARLOW II
-
Construction Completed:No
-
Construction Materials:Vinyl Siding, Brick Front
-
Structure Type:Interior Row/Townhouse
-
Architectural Style:Craftsman
-
Levels:3
-
Roof:Architectural Shingle, Asphalt
-
Accessibility Features:None
-
Foundation Details:Slab, Concrete Perimeter
-
Basement:Yes
-
Basement Type:Walkout Level
-
Total SqFt Source:Estimated
-
Total Below Grade SqFt Source:Estimated
-
Above Grade Finished Area Units:Square Feet
-
Above Grade Finished SqFt:2121
-
Above Grade Finished SqFt Source:Estimated
-
Below Grade Finished Area Units:Square Feet
-
Below Grade Finished SqFt Source:Estimated
Interior
-
Interior Features:Combination Kitchen/Living, Family Room Off Kitchen, Floor Plan - Open, Walk-in Closet(s), Breakfast Area, Combination Kitchen/Dining, Kitchen - Gourmet
-
Room List:Primary Bedroom, Bedroom 2, Bedroom 3, Kitchen, Family Room, Great Room
-
Fireplace:No
-
Living Area SqFt Source:Estimated
Room Dimensions
-
Total SqFt:2121
-
Living Area SqFt:2,121 Sqft
Financial & Terms
-
Sale Type:Standard
-
Buyer Financing:Conventional
-
Possession:Settlement
Location
-
Directions:From I-70 W, take exit 53B toward US-15 N onto US-40 W (Frederick Fwy) and go for 1.6 mi. Continue on US-15 N (Frederick Fwy) for 0.8 mi. Take exit 14 toward Rosemont Avenue and go for 0.1 mi. Turn right onto Rosemont Ave. Go for 2.7 mi. Take the 1st exit from roundabout onto Christophers Xing. Go for 0.7 mi. Take the 3rd exit from roundabout onto Walter Martz Rd. Go for 0.5 mi. Turn right onto Reagans Rd. Stay straight on Reagans Rd and search for Homesite 2029.
-
Latitude:39.47193614
-
Longitude:-77.42906525
The Property
-
Property Type:Residential
-
Property Condition:Excellent
-
Lot Size Units:Square Feet
-
Lot Size Acres:0.21
-
Lot Size Source:Estimated
-
Lot SqFt:9,000 Sqft
-
Zoning:PUD
-
In City Limits:Yes
-
Other Structures:Above Grade, Below Grade
-
Water View:No
-
Waterfront:No
-
Water Oriented:No
-
Water Access:No
-
Navigable Water:No
-
Tidal Water:No
-
Riparian Rights:No
Listing Agent
- Contact info:
- Agent phone:
- (240) 457-9391
- Office phone:
- (240) 457-9391
Taxes
-
Tax ID Number:NO TAX RECORD
-
Tax Year:2024
-
Tax Lot:2029
-
City/Town Tax:1.79
-
Total Taxes Payment Frequency:Annually
Beds
-
Bedrooms:3
-
Upper Level Bedrooms:3
-
Bedrooms Upper Level:3
Baths
-
Total Baths:4
-
Full Baths:2
-
Half Baths:2
-
Main Level Baths:1.00
-
Main Level Half Baths:1
-
Upper Level Full Baths:2
-
Upper Level Half Baths:1
-
Upper Level Total Baths:3
-
Upper Level Total Baths:1.00
-
Upper Level 2 Total Baths:2.00
-
Upper Level 2 Full Baths:2
-
Upper Level Half Baths:1
The Listing
-
Close Sale Type:Standard Sale
Heating & Cooling
-
Cooling Type:Central A/C, Programmable Thermostat
-
Central Air:Yes
-
Cooling Fuel:Electric
-
Heating:Yes
-
Heating Type:Programmable Thermostat, Heat Pump(s)
-
Heating Fuel:Electric
Utilities
-
Sewer/Septic:Public Sewer
-
Hot Water:Electric
-
Water Source:Public
Appliances
-
Appliances:Refrigerator, Microwave, Dishwasher, Disposal, Stainless Steel Appliances, Oven/Range - Electric
Schools
-
Elementary School:Yellow Springs
-
Middle School:Monocacy
-
High School:GOVERNOR THOMAS JOHNSON
-
School District Name:Frederick County Public Schools
-
School District Source:Listing Agent
The Community
-
Subdivision Name:Tuscarora Creek
-
Senior Community:No
-
Exterior Features:Sidewalks, Street Lights
-
Pool:Yes - Community
-
HOA:Yes
-
Condo/Coop Association:No
-
HOA/Condo/Coop Amenities:Jog/Walk Path, Swimming Pool, Club House, Tot Lots/Playground, Bike Trail
-
HOA Fee:$99
-
HOA Fee Frequency:Monthly
Parking
-
Total Garage and Parking Spaces:2
-
Garage:Yes
-
Garage Features:Garage - Front Entry
-
Garage Spaces:2.00
-
Type of Parking:Attached Garage
-
# of Attached Garage Spaces:2
Extra Units
-
Vacation Rental:No
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Max Internet Speed
Provided by BroadbandNow®
This is the maximum advertised internet speed available for this home. Under 10 Mbps is in the slower range, and anything above 30 Mbps is considered fast. For heavier internet users, some plans allow for more than 100 Mbps.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
9/27/24
Sep 27, 2024
|
Sold | BRIGHT | $519,000 | -0.7% |
9/4/24
Sep 4, 2024
|
Pending | BRIGHT | $522,650 | |
6/24/24
Jun 24, 2024
|
Listed / Active | BRIGHT | $522,650 |