Skip main navigation
Sold for $519,000
  • $519,000

    2004 Alice Ct, Frederick, MD 21702

    3beds
    2,121sqft
    Townhouse
    Built in 2024
    9,000 Square Feet Lot
    $514,800 Zestimate®
    $245/sqft
    $2,937 Estimated rent

    Home value

    $514,800

    $474,000 - $556,000

    $2,937/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $2,937/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,937/mo

    Rent Zestimate®

    Refinance and save

    $3,210/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,210/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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.

    Zillow last checked: 7 hours ago

    Listing updated: March 12, 2026 at 10:43am

    Listed by:

    Brittany Newman 240-457-9391,

    DRB Group Realty, LLC

    Bought with:

    Unrepresented

    Unrepresented Buyer Office

    Source: Bright MLS,MLS#: MDFR2050538MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 4
    • Full bathrooms: 2
    • 1/2 bathrooms: 2
    • Main level bathrooms: 1
    Primary bedroom
    • Level: Upper
    Bedroom 2
    • Level: Upper
    Bedroom 3
    • Level: Upper
    Family room
    • Level: Upper
    Great room
    • Level: Main
    Kitchen
    • Level: Upper
    Heating
    • Programmable Thermostat, Heat Pump, Electric
    Cooling
    • Central Air, Programmable Thermostat, Electric
    Appliances
    • Included: Refrigerator, Microwave, Dishwasher, Disposal, Stainless Steel Appliance(s), Oven/Range - Electric, Electric Water Heater
    Features
    • Combination Kitchen/Living, Family Room Off Kitchen, Open Floorplan, Walk-In Closet(s), Breakfast Area, Combination Kitchen/Dining, Kitchen - Gourmet
    • Basement: Walk-Out Access
    • Has fireplace: No
    Interior area
    • Total structure area: 2,121
    • Total interior livable area: 2,121 sqft
    • Finished area above ground: 2,121
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage Faces Front, Attached
    • Attached garage spaces: 2
    Accessibility
    • Accessibility features: None
    Features
    • Levels: Three
    • Stories: 3
    • Exterior features: Sidewalks, Street Lights
    • Pool features: Community
    Lot
    • Size: 9,000 sqft
    Details
    • Additional structures: Above Grade, Below Grade
    • Parcel number: NO TAX RECORD
    • Zoning: PUD
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: Townhouse
    • Architectural style: Craftsman
    • Property subtype: Townhouse
    Materials
    • Vinyl Siding, Brick Front
    • Foundation: Slab, Concrete Perimeter
    • Roof: Architectural Shingle,Asphalt
    Condition
    • Excellent
    • New construction: Yes
    • Year built: 2024
    Details
    • Builder model: HARLOW II
    • Builder name: DRB Homes

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public

    Community & neighborhood

    Location
    • Region: Frederick
    • Subdivision: Tuscarora Creek
    • Municipality: Frederick City

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $99 monthly
    • Amenities included: Jogging Path, Pool, Clubhouse, Tot Lots/Playground, Bike Trail

    Other

    Other facts
    • Listing agreement: Exclusive Right To Sell
    • Ownership: Fee Simple

    Price history

    DateEventPrice
    9/27/2024Sold$519,000-0.7%$245/sqft
    Source: Bright MLS #MDFR2050538 Report a problem
    9/4/2024Pending sale$522,650$246/sqft
    Source: Bright MLS #MDFR2050538 Report a problem
    6/24/2024Listed for sale$522,650$246/sqft
    Source: Bright MLS #MDFR2050538 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: 21702

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Yellow Springs
    • Middle: Monocacy
    • High: Governor Thomas Johnson
    • District: Frederick County Public Schools

    Source: Bright MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $514,800
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $514,800