NOT LISTED FOR SALE

Estimated Value: $589,447 - $614,000

6 Beds
3.5 Baths
3,110 Sq Ft
$193/Sq Ft Est. Value

Last Sold May 11, 2015

Last sale price $364,900 $117 Per Sq Ft

Est. 64% increase in value since last sale

Current estimated payment $3,781/month

16 Days on Market

Highlights

  • 0.27 Acre Lot
  • Open Floorplan
  • Deck
  • Frederick High School Rated A-
  • Colonial Architecture
  • Wood Burning Stove

About This Home

As of May 2015

Very well maintained home in sought after Emerald Farm. Open floor plan, convenient to shopping and commuter routes, Updates include new carpet, paint and select light fixtures. 2 legal bedrooms in the lower level. Surround sound system included in lower level entertainment room. The whole house is pre-wired for CATV, Telephone & Data. This one won't last long ... must see!!!

Last Agent to Sell the Property

Christine Reeder

(301) 606-8611 chris.reeder@longandfoster.com Long & Foster Real Estate, Inc. License #581222 Listed on: 03/03/2015

Long & Foster Real Estate, Inc.

Co-Listed By

Robin Reeder

(301) 606-8610 robin.reeder@lnf.com Long & Foster Real Estate, Inc. License #581253

Last Buyer's Agent

Julie Saxon

(301) 418-2749 jsaxon23@aol.com Mackintosh, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,840

Year Built

  • Built in 1996

Lot Details

  • 0.27 Acre Lot
  • Split Rail Fence
  • Back Yard Fenced
  • Property is in very good condition
  • Property is zoned R6

HOA Fees

  • $33 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Colonial Architecture
  • Shingle Roof
  • Asphalt Roof
  • Vinyl Siding

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Two Story Ceilings
  • Ceiling Fan
  • 1 Fireplace
  • Wood Burning Stove
  • Screen For Fireplace
  • Window Treatments
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room
  • Game Room
  • Storage Room
  • Utility Room

Kitchen

  • Breakfast Room
  • Eat-In Kitchen
  • Gas Oven or Range
  • Range Hood
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • En-Suite Bathroom
  • 3.5 Bathrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Connecting Stairway
  • Sump Pump
  • Shelving
  • Basement Windows

Outdoor Features

  • Deck

Schools

  • Orchard Grove Elementary School
  • Crestwood Middle School
  • Frederick High School

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Underground Utilities
  • Natural Gas Water Heater
  • Satellite Dish
  • Cable TV Available

Community Details

  • Emerald Farm Hoa Community
  • Emerald Farm Subdivision

Listing and Financial Details

  • Tax Lot 123
  • Assessor Parcel Number 1102190338

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,840

Year Built

Built in 1996

Lot Details

0

HOA Fees

$33 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Historic: No
  • Inclusions: Parking Included In ListPrice,Parking Included In SalePrice
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Year Built: 1996
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Washer/Dryer Hookups Only, Dryer, Dishwasher, Disposal, Exhaust Fan, Range Hood, Refrigerator, Washer, Oven/Range - Gas
  • Interior Amenities: Breakfast Area, Kitchen - Table Space, Dining Area, Primary Bath(s), Window Treatments, Floor Plan - Open
  • Fireplace Features: Screen
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Wall Ceiling Types: 2 Story Ceilings, Dry Wall
  • Entry Location: Foyer
  • Levels Count: 3+
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Game Room, Family Room, Foyer, Breakfast Room, Bedroom 1, Storage Room, Utility Room
  • Basement: Yes
  • Basement Type: Connecting Stairway, Sump Pump, Daylight, Full, Fully Finished, Shelving, Windows
  • Living Area Units: Square Feet
  • Total Sq Ft: 3110
  • Living Area Sq Ft: 3110
  • Price Per Sq Ft: 155.94
  • Above Grade Finished Sq Ft: 2340
  • Below Grade Finished Sq Ft: 770
  • Total Below Grade Sq Ft: 770
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 6
  • 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: Above Grade, Below Grade
  • Construction Materials: Vinyl Siding
  • Exterior Features: Satellite Dish
  • Pool Private: No
  • Roof: Asphalt, Shingle
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Garage, Paved Driveway, Attached, Concrete Driveway
  • Garage Features: Garage Door Opener, Garage - Front Entry
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Driveway, Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C, Ceiling Fan(s)
  • Cooling: Yes
  • Heating Fuel: Natural Gas, Wood
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Security: Main Entrance Lock
  • Sewer/Septic System: Public Sewer
  • Utilities: Under Ground, Cable Tv Available
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 99.00
  • HOA Fee Frequency: Quarterly
  • Condo Co-Op Association: No
  • HOA: Yes
  • Senior Community: No

Schools

  • Elementary School: ORCHARD GROVE
  • High School: FREDERICK
  • Middle Or Junior School: CRESTWOOD

Lot Info

  • Fencing: Fully, Rear, Split Rail
  • Improvement Assessed Value: 195200.00
  • Land Assessed Value: 100300.00
  • Lot Size Acres: 0.27
  • Lot Size Area: 11696
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 11696.00
  • Outdoor Living Structures: Deck(s)
  • Property Attached Yn: No
  • Property Condition: Very Good
  • Zoning: R6
  • In City Limits: Yes

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11523054
  • Tax Annual Amount: 4839.70
  • Assessor Parcel Number: 1102190338
  • Tax Lot: 123
  • County Tax Payment Frequency: Annually
  • Tax Year: 2014

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Feb 3, 2025
Sold by
Haldeman Duane R and Haldeman Ilise R
Bought by
Duane Richard Haldeman Revocable Living Trust and Ilise Rosen Haldeman Revocable Living Trust
Current Estimated Value
$599,612

Purchase Details

Listed on
Mar 3, 2015
Closed on
May 11, 2015
Sold by
Usher Keith Andrew and Usher Sandra Maria
Bought by
Haldeman Duane R and Haldeman Ilise R
Seller's Agent
Christine Reeder
Long & Foster Real Estate, Inc.
Buyer's Agent
Julie Saxon
Mackintosh, Inc.
List Price
$364,900
Sold Price
$364,900

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.78%
Original Mortgage
$291,920
Interest Rate
3.66%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 8, 1995
Sold by
Lovell Regency Homes Ltd Part
Bought by
Usher Keith Anderson and Usher Sandra M

Purchase Details

Closed on
Oct 5, 1995
Sold by
Emerald Farm Assoc
Bought by
Lovell Regency Homes Ltd Part
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

Date Buyer Sale Price Title Company
Duane Richard Haldeman Revocable Living Trust -- None Listed On Document
Duane Richard Haldeman Revocable Living Trust -- None Listed On Document
Haldeman Duane R $364,900 None Available
Usher Keith Anderson $197,560 --
Lovell Regency Homes Ltd Part $23,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Haldeman Duane R $291,920
Closed Usher Keith Anderson --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/11/2015 05/11/15 Sold $364,900 0.0% $117 / Sq Ft
03/19/2015 03/19/15 Pending -- -- --
03/03/2015 03/03/15 For Sale $364,900 -- $117 / Sq Ft
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

Tax History

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 $7,276 $482,900 $106,600 $376,300
2024 $7,276 $439,800 $0 $0
2023 $6,720 $396,700 $0 $0
2022 $6,362 $353,600 $100,300 $253,300
2021 $6,069 $345,867 $0 $0
2020 $6,069 $338,133 $0 $0
2019 $5,930 $330,400 $100,300 $230,100
2018 $5,774 $318,767 $0 $0
2017 $5,511 $330,400 $0 $0
2016 $4,827 $295,500 $0 $0
2015 $4,827 $284,333 $0 $0
2014 $4,827 $273,167 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: 1001184533

Bright MLS

APN: 02-190338