Movoto Real Estate
Sold on 09/27/2024
  • Other
  • Entry Way
  • Kitchen
  • Living
  • Bedroom
  • View/Area
  • Floorplan

2004 Alice Ct, Frederick, MD 21702

  • $512,000

    Last sold 09/27/2024 for $519K

  • 3

    bed

  • 4

    bath

  • 2,121

    Sqft ($245/Sqft)

Townhouse not for sale
Movoto is helping 78 homebuyers near you

About 2004 Alice Ct

Property type Townhouse
Neighborhood
Year built 2024
HOA fee $99/month
Lot size 9,000 Sqft
Movoto estimate
Parking 2 garage spaces
Rental estimate
Property description
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.
Listed by
Listing Agent - Brittany D Newman
Listing Office - DRB Group Realty, LLC
Source: Bright MLS mls logo
MLS#MDFR2050538 • last updated 1 month ago
Movoto checked Bright MLS for data 4 minutes ago
Overview
Cooling/AC Central A/C, Programmable Thermostat, Electric
Heating Electric
Levels/Style Craftsman
Type Residential
Virtual Tour N/A
Status Closed
SqFt 2121
Lot Size (SqFt) 9000
Lot Size (Acres) 0.21
City/ Town Tax 1.79
Year Built 2024
Condition Excellent
Municipality Frederick City
HOA Fee 99, Monthly
New Construction (Y/N) Y
Foreclosure (Y/N) N
Interior
Total # of Bathrooms 4
# Full Baths 2
# Half Baths 2
Total # of Bedrooms 3
Basement Walkout Level
Other Room(s) Primary Bedroom, Bedroom 2, Bedroom 3, Kitchen, Family Room, Great Room
Appliances Refrigerator, Microwave, Dishwasher, Disposal, Stainless Steel Appliances, Oven/Range - Electric
Interior Features Combination Kitchen/Living, Family Room Off Kitchen, Floor Plan - Open, Walk-in Closet(s), Breakfast Area, Combination Kitchen/Dining, Kitchen - Gourmet
Accessibility Features None
Exterior
Roof Architectural Shingle, Asphalt
Garage Desc Garage - Front Entry
# Garage Spaces 2
# Parking Spaces 2
# Attached Garage Spaces 2
Parking Desc Attached Garage
Exterior Features Sidewalks, Street Lights
Existing Structures Above Grade, Below Grade
Amenities / Utilities
Sewer/ Septic Public Sewer
Pool Yes - Community
Location
Subdivision TUSCARORA CREEK
Water Source Public
Senior Community (Y/N) N
High School GOVERNOR THOMAS JOHNSON
Elementary School YELLOW SPRINGS
School District FREDERICK COUNTY PUBLIC SCHOOLS
Middle School MONOCACY
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
Zoning PUD
$512K
Range: $465K-$558K
Last 30 days 
Rental est.: $2,064/month
Gross rent multiplier: 21.0
  • Sep 2024
    mls logo MLS # MDFR2050538
  • Sep 27, 2024 Sold
    $519,000 (-0.7%)
  • Sep 4, 2024 Pending
  • Jun 24, 2024 Listed
    $522,650
  • 2004 Alice Ct
    $519K
  • Tuscarora Creek
    $589K -15% y/y
  • 21702
    $519K +3% y/y
  • Frederick
    $515K +3% y/y
No chart available
Statistics calculated by Movoto

Thinking of selling? Get a Cash Offer.

  • A smooth, fast sale
  • Skip staging and repairs
  • No strings attached
6/10
4/10
4/10
Source: GreatSchools.org © 2026. All rights reserved.

Around Tuscarora Creek

Explore everything this neighborhood has to offer. Learn more about Tuscarora Creek.
By entering my info and clicking Ask a Question below, I am providing my e-signature and express written consent to receive marketing emails, calls, and texts (including via automatic telephone dialing systems, AI generative, artificial or pre-recorded voice technology) relating to my inquiry from Movoto (and parties calling/messaging on their behalf) even if my number appears on the company, state, or national Do Not Call Registry. You also agree to ourTerms and Conditions and Privacy Policy. Consent not required to receive services (call 1-844-420-1270 to be connected without providing consent).

Nearby recently sold homes in Frederick, MD

Nearby homes for sale in Frederick, MD

Newest listings in 21702

  • Real Estate
  • MD
  • Frederick County
  • Frederick
  • 21702
  • Tuscarora Creek
  • 2004 Alice Ct
Meet with a real estate agent today (844) 430-0869
The multiple listing information is provided by BRIGHT MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Buyer to verify all information. The information provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listing information updated every 15 minutes. Terms of use & Privacy Policy, California Privacy Info. Copyright © 2005 - 2026 Movoto, Inc. All rights reserved. Equal Housing Opportunity CalDRE CalDRE #01517281
Movoto Real Estate is committed to ensuring accessibility for individuals with disabilities. We are continuously working to improve the accessibility of our web experience for everyone. We welcome feedback and accommodation requests, please submit them here.
© 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 Movoto 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: 7/3/2026. Some properties which appear for sale on this website may no longer be available because they are under contract, have Closedor are no longer being offered for sale. Some real estate firms do not participate in IDX and their listings do not appear on this website. Some properties listed with participating firms do not appear on this website at the request of the seller. This home sale information is not to be construed as an appraisal and may not be used as such for any purpose. BRIGHTMLS is the (or a) provider of this home sale information and has compiled content from various sources. Some properties represented may not have actually solddue to reporting errors.
Requests for information regarding mortgage products will be directed to Movoto.com affiliate, Lower, LLC - a licensed Mortgage Lender (NMLS #1124061), or, based on your location, may be redirected to a participating mortgage marketing partner that may pay Lower, LLC for any consumer contact information provided through this site.