NOT LISTED FOR SALE

900 Halleck Dr Frederick, MD 21701

Wormans Mill Neighborhood

Estimated Value: $384,000 - $426,000

3 Beds
3.5 Baths
1,576 Sq Ft
$256/Sq Ft Est. Value

Sale Details

Date Sold: August 31, 2018

Last sale price $257,500 $163 Per Sq Ft

Est. 57% increase in value since last sale

Current estimated payment $2,801 / mo

6 Days on Market

Highlights

  • Private Pool
  • Open Floorplan
  • Traditional Architecture
  • Walkersville Middle School Rated 9+
  • Clubhouse
  • Attic

About This Home

As of August 2018

THIS ONE! Large end unit townhouse in Tuscarora Knolls community. With 3 bedrooms, 3-1/2 baths, a fully-finished walkout basement, and gas heat and appliances, this house is ready for YOU to make it YOUR home. HOA includes recently refurbished pool. Sellers are offering this unit AS IS and are motivated to sell quickly, so come soon and be ready to make an offer!

Last Agent to Sell the Property

Rich Ramirez

(301) 694-8000 richramirez.homes@gmail.com Long & Foster Real Estate, Inc. Listed on: 07/19/2018

Long & Foster Real Estate, Inc.

Last Buyer's Agent

Paul Hillstrom

(301) 294-3000 paul@hillstromrealestate.com Hillstrom Real Estate License #578309

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $4,338

Year Built

  • Built in 1997

Lot Details

  • 3,069 Sq Ft Lot
  • 1 Common Wall

HOA Fees

  • $98 Monthly HOA Fees

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Vinyl Siding

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Ceiling Fan
  • Entrance Foyer
  • Living Room
  • Game Room
  • Storage Room
  • Attic

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3.5 Bathrooms

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Connecting Stairway
  • Rear Basement Entry
  • Basement Windows

Parking

  • Garage
  • Front Facing Garage
  • Assigned Parking
  • Unassigned Parking

Accessible Home Design

  • Doors swing in
  • Low Pile Carpeting

Outdoor Features

  • Private Pool
  • Shed

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Heat Pump System
  • Natural Gas Water Heater

Listing and Financial Details

  • Tax Lot 230
  • Assessor Parcel Number 1102205149

Community Details

Overview

  • Tuscarora Knolls Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Playground
  • Community Pool

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$4,338

Year Built

Built in 1997

Lot Details

3,069 Sq Ft Lot

HOA Fees

$98 per month

Listing Details

  • Property Type: Residential
  • Structure Type: End Of Row/Townhouse
  • Architectural Style: Traditional
  • Accessibility Features: Low Pile Carpeting, Doors - Swing In
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Year Built: 1997
  • Special Features: VirtualTour
  • Property Sub Type: Townhouses

Interior Features

  • Interior Amenities: Breakfast Area, Kitchen - Table Space, Kitchen - Eat-In, Floor Plan - Open
  • Fireplace: No
  • Common Walls: 1 Common Wall
  • Entry Location: Foyer
  • Levels Count: 3+
  • Room List: Living Room, Primary Bedroom, Bedroom 3, Kitchen, Game Room, Foyer, Storage Room, Attic
  • Basement: Yes
  • Basement Type: Outside Entrance, Rear Entrance, Connecting Stairway, Daylight, Full, Fully Finished, Heated, Improved, Walkout Level, Windows
  • Living Area Units: Square Feet

Beds/Baths

  • Bedrooms: 3
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures List: Shed
  • Construction Materials: Combination, Brick, Vinyl Siding
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community, Yes - Personal
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage: No
  • Parking Features: Unassigned
  • Parking Space Number Assigned: 2
  • Garage Features: Garage - Front Entry

Utilities

  • Refuse: 88.00
  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Heat Pump(s), Ceiling Fan(s), Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Heat Pump(s)
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 98.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Pool - Outdoor, Reserved/Assigned Parking, Tot Lots/Playground, Club House
  • HOA: Yes
  • Senior Community: No

Lot Info

  • Improvement Assessed Value: 193200.00
  • Land Assessed Value: 49000.00
  • Lot Size Acres: 0.07
  • Lot Size Area: 3069
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 3069.00
  • Zoning: R8
  • In City Limits: Yes

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11564499
  • Tax Annual Amount: 4338.43
  • Assessor Parcel Number: 1102205149
  • Tax Lot: 230
  • County Tax Payment Frequency: Annually
  • Tax Year: 2017

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 19, 2018
Closed on
Aug 31, 2018
Sold by
Bought by
Seller's Agent
Rich Ramirez
Long & Foster Real Estate, Inc.
Buyer's Agent
Paul Hillstrom
Hillstrom Real Estate
List Price
$249,900
Sold Price
$257,500
Premium/Discount to List
$7,600
3.04%
Current Estimated Value
$403,571

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$146,071
Avg. Annual Appreciation
5.83%
Original Mortgage
$248,487
Interest Rate
0.0412%
Mortgage Type
FHA

Purchase Details

Closed on
Apr 28, 2005
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$252,000
Interest Rate
0.0562%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jun 14, 2004
Sold by
Bought by

Purchase Details

Closed on
Sep 30, 2003
Sold by
Bought by

Purchase Details

Closed on
Jan 21, 2003
Sold by
Bought by

Purchase Details

Closed on
May 26, 1999
Sold by
Bought by

Purchase Details

Closed on
Apr 18, 1997
Sold by
Bought by
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$257,500 None Available
$315,000 --
-- --
-- --
-- --
$142,000 --
$129,370 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $245,000
Closed $248,487
Previous Owner $25,000
Previous Owner $321,300
Previous Owner $63,000
Previous Owner $252,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/31/2018 08/31/18 Sold $257,500 +3.0% $163 / Sq Ft
07/25/2018 07/25/18 Pending -- -- --
07/19/2018 07/19/18 For Sale $249,900 -- $159 / Sq Ft
Source: Bright MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,849 $337,400 $90,000 $247,400
2024 $5,849 $314,333 $0 $0
2023 $5,275 $291,267 $0 $0
2022 $4,847 $268,200 $60,000 $208,200
2021 $4,612 $259,533 $0 $0
2020 $4,526 $250,867 $0 $0
2019 $4,370 $242,200 $49,000 $193,200
2018 $4,287 $240,333 $0 $0
2017 $4,260 $242,200 $0 $0
2016 $4,044 $236,600 $0 $0
2015 $4,044 $230,633 $0 $0
2014 $4,044 $224,667 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • R

    Seller's Agent in 2018

    Rich Ramirez

    Long & Foster

    Section Image
  • Paul Hillstrom

    Buyer's Agent in 2018

    Paul Hillstrom

    Hillstrom Real Estate

    (301) 648-7181

    19 Total Sales

    Paul Hillstrom
    Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: 1002071236

Bright MLS

APN: 02-205149

Maryland Frederick County Frederick 21701 Wormans Mill

900 Halleck Dr, Frederick, MD

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Bright MLS 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, and is provided by BRIGHT through a licensing agreement.
Listing information is from various brokers who participate in the Bright MLS IDX program and not all listings may be visible on the site.
The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale.
Property information displayed is deemed reliable but is not guaranteed.
Copyright 2026 Bright MLS, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.