Skip main navigation
Sold for $519,000 on 09/27/24
  • $519,000

    2004 Alice Ct, Frederick, MD 21702

    3beds
    2,121sqft
    Townhouse
    Built in 2024
    9,000 Square Feet Lot
    $527,200 Zestimate®
    $245/sqft
    $-- Estimated rent

    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: June 24, 2025 at 02:51am

    Listed by:

    Brittany Newman 240-457-9391,

    DRB Group Realty, LLC

    Bought with:

    Unrepresented Buyer

    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
    Services availability
    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.