Seller's Agent in 2013
Eric Steinhoff
LPT Realty, LLC
(240) 818-5744
54 in this area
214 Total Sales
9225 Charterhouse Rd Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $1,038,045 - $1,207,000
4
Beds
4.5
Baths
4,000
Sq Ft
$281/Sq Ft
Est. Value
Highlights
- Fitness Center
- Eat-In Gourmet Kitchen
- Dual Staircase
- Centerville Elementary Rated A
- Open Floorplan
- Clubhouse
About This Home
As of June 201310 Look no further! Fully loaded Avalon model features almost 6000 sf of luxury living on a premium lot backing to trees. Charming front porch, gourmet kitchen, granite, hardwoods, sunny morning room opening to large deck, cozy family room w/ stone fireplace, luxe master suite,Jack/Jill bathroom-2nd fl, FF basement w/ poss. 5th BR, full bath and huge rec room. Open house this Sat & Sun 11-2
Last Agent to Sell the Property
(240) 818-5744 steinhoff.sales@gmail.com LPT Realty, LLC License #RS-0038509 Listed on: 02/27/2013
Last Buyer's Agent
(301) 748-3290 vp7883020@gmail.com Allison James Estates & Homes License #111534657
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $5,594
Year Built
- Built in 2004
Lot Details
- 8,760 Sq Ft Lot
- Property is in very good condition
- Property is zoned PUD
HOA Fees
- $95 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Front Facing Garage
- Garage Door Opener
Home Design
- Traditional Architecture
- Brick Exterior Construction
Interior Spaces
- Property has 3 Levels
- Open Floorplan
- Dual Staircase
- Chair Railings
- Crown Molding
- Ceiling height of 9 feet or more
- Gas Fireplace
- Window Treatments
- Mud Room
- Entrance Foyer
- Great Room
- Family Room
- Sitting Room
- Living Room
- Dining Room
- Den
- Library
- Storage Room
- Laundry Room
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Room
- Double Self-Cleaning Oven
- Cooktop
- Microwave
- Dishwasher
- Kitchen Island
- Upgraded Countertops
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Bathroom
- 4.5 Bathrooms
Partially Finished Basement
- Walk-Out Basement
- Exterior Basement Entry
Eco-Friendly Details
- Energy-Efficient Appliances
Utilities
- Zoned Heating and Cooling
- Heat Pump System
- Natural Gas Water Heater
Listing and Financial Details
- Tax Lot 14006
- Assessor Parcel Number 1107237863
Community Details
Overview
- Villages Of Urbana Subdivision
Amenities
- Common Area
- Clubhouse
- Community Center
- Meeting Room
- Party Room
- Recreation Room
Recreation
- Tennis Courts
- Community Basketball Court
- Community Playground
- Fitness Center
- Community Pool
- Bike Trail
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Feb 27, 2013
Closed on
Jun 19, 2013
Sold by
Gerhart David E and Gerhart Elizabeth A
Bought by
Srinivasan Ramesh and Thiagarajan Hemamalini
Seller's Agent
Eric Steinhoff
LPT Realty, LLC
Buyer's Agent
Vijay Patel
Allison James Estates & Homes
List Price
$719,000
Sold Price
$670,000
Premium/Discount to List
-$49,000
-6.82%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$454,511
Avg. Annual Appreciation
4.21%
Original Mortgage
$502,500
Outstanding Balance
$359,037
Interest Rate
3.59%
Mortgage Type
New Conventional
Estimated Equity
$765,474
Purchase Details
Listed on
Dec 4, 2011
Closed on
Mar 19, 2012
Sold by
Rousculp Matthew D and Rousculp Jane G
Bought by
Gerhart Elizabeth A and Gerhart David E
Seller's Agent
Lisa Giuliani
Keller Williams Realty Centre
Buyer's Agent
Jonathan Karpa
Compass
List Price
$594,900
Sold Price
$600,000
Premium/Discount to List
$5,100
0.86%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.23%
Original Mortgage
$430,000
Interest Rate
3.88%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jul 30, 2007
Sold by
Hallford Christine
Bought by
Rousculp Matthew D and Rousculp Jane G
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$540,000
Interest Rate
6.73%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Jul 12, 2007
Sold by
Hallford Christine
Bought by
Rousculp Matthew D and Rousculp Jane G
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$540,000
Interest Rate
6.73%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Feb 25, 2005
Sold by
Nvr Inc
Bought by
Hallford Christine
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$510,032
Interest Rate
5.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Sep 9, 2004
Sold by
Monocacy L& Company Llc
Bought by
Nvr Inc
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Srinivasan Ramesh | $670,000 | Commonwealth Land Title Ins | |
| Gerhart Elizabeth A | $600,000 | Fatic | |
| Rousculp Matthew D | $675,000 | -- | |
| Rousculp Matthew D | $675,000 | -- | |
| Hallford Christine | $637,540 | -- | |
| Nvr Inc | $410,287 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Srinivasan Ramesh | $502,500 | |
| Previous Owner | Gerhart Elizabeth A | $430,000 | |
| Previous Owner | Rousculp Matthew D | $540,000 | |
| Previous Owner | Rousculp Matthew D | $540,000 | |
| Previous Owner | Hallford Christine | $510,032 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 06/18/2013 06/18/13 | Sold | $670,000 | -4.3% | $168 / Sq Ft | |
| 04/12/2013 04/12/13 | Pending | -- | -- | -- | |
| 03/23/2013 03/23/13 | Price Changed | $699,900 | -1.4% | $175 / Sq Ft | |
| 03/13/2013 03/13/13 | Price Changed | $709,900 | -1.3% | $177 / Sq Ft | |
| 02/27/2013 02/27/13 | For Sale | $719,000 | +19.8% | $180 / Sq Ft | |
| 03/19/2012 03/19/12 | Sold | $600,000 | 0.0% | $101 / Sq Ft | View Prior Sale |
| 02/03/2012 02/03/12 | Pending | -- | -- | -- | |
| 02/03/2012 02/03/12 | Price Changed | $600,000 | +0.9% | $101 / Sq Ft | |
| 01/11/2012 01/11/12 | For Sale | $594,900 | 0.0% | $100 / Sq Ft | |
| 12/14/2011 12/14/11 | Pending | -- | -- | -- | |
| 12/04/2011 12/04/11 | For Sale | $594,900 | -- | $100 / Sq Ft |
Source: Bright MLS
Tax History Compared to Growth
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 | $12,217 | $914,267 | -- | -- |
| 2024 | $12,217 | $850,600 | $201,800 | $648,800 |
| 2023 | $11,134 | $796,633 | $0 | $0 |
| 2022 | $10,472 | $742,667 | $0 | $0 |
| 2021 | $10,008 | $688,700 | $175,800 | $512,900 |
| 2020 | $10,008 | $676,267 | $0 | $0 |
| 2019 | $9,823 | $663,833 | $0 | $0 |
| 2018 | $9,728 | $651,400 | $109,300 | $542,100 |
| 2017 | $9,387 | $651,400 | $0 | $0 |
| 2016 | $7,361 | $614,600 | $0 | $0 |
| 2015 | $7,361 | $596,200 | $0 | $0 |
| 2014 | $7,361 | $556,033 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Eric Steinhoff
-
Vijay Patel
V
Buyer's Agent in 2013
Vijay Patel
Allison James Estates & Homes
(301) 748-3290
1 in this area
24 Total Sales
-
Lisa Giuliani
Seller's Agent in 2012
Lisa Giuliani
Keller Williams Realty Centre
(240) 447-5766
70 in this area
98 Total Sales
-
Jonathan Karpa
Buyer's Agent in 2012
Jonathan Karpa
Compass
(240) 888-4067
40 Total Sales
Map
Source: Bright MLS
MLS Number: 1003366936
APN: 07-237863
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.
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 2025 Bright MLS, Inc.
Nearby Homes
- 9349 Penrose St
- 3818 Sugarloaf Pkwy
- 3816 Sugarloaf Pkwy
- 4009 Tottenham Ct
- 9504 Hyde Place
- 3508 Connor Place
- 9526 Hyde Place
- 3624 Spring Hollow Dr
- 9537 Hyde Place
- 9610 Atterbury Ln
- Lot 2, Thompson Driv Thompson Dr
- 3528 Tabard Ln
- 9103 John Simmons St
- 9047 Clendenin Way
- 9054 Seward St
- 4346 Brubeck Terrace
- 9152 Landon House Ln
- 8828 Lew Wallace Rd
- 3557 Worthington Blvd Unit A
- 9119 Landon House Ln
- 9227 Charterhouse Rd
- 9221 Charterhouse Rd
- 9229 Charterhouse Rd
- 9219 Charterhouse Rd
- 9220 Charterhouse Rd
- 9218 Charterhouse Rd
- 9222 Charterhouse Rd
- 9216 Charterhouse Rd
- 9231 Charterhouse Rd
- 9217 Charterhouse Rd
- 9224 Charterhouse Rd
- 9214 Charterhouse Rd
- 9219 Shafers Mill Dr
- 9217 Shafers Mill Dr
- 9221 Shafers Mill Dr
- 9233 Charterhouse Rd
- 9226 Charterhouse Rd
- 9215 Shafers Mill Dr
- 9215 Charterhouse Rd
- 9212 Charterhouse Rd