Seller's Agent in 2015
Eric Steinhoff
LPT Realty, LLC
(240) 818-5744
51 in this area
197 Total Sales
9104 Charterhouse Rd Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $1,161,000 - $1,299,000
5
Beds
5.5
Baths
5,296
Sq Ft
$231/Sq Ft
Est. Value
Highlights
- Fitness Center
- Gourmet Kitchen
- Open Floorplan
- Centerville Elementary Rated A
- 0.35 Acre Lot
- Colonial Architecture
About This Home
As of November 2015Stunning! Rare opportunity. One of the best homes on one of the best lots in the Villages of Urbana! Custom built-ins, molding & designer finishes throughout. Open floor plan, floor-to-ceiling windows. Master suite w/super luxurious Master Bath. Custom built-ins in HUGE closet. Incredible finished walk-out basement w/basketball court. Covered porch w/skylights/bar/grill & circ. stairs to patio.
Last Agent to Sell the Property
(877) 366-2213 mdbrokers@lptrealty.com LPT Realty, LLC License #RS-0038509 Listed on: 12/07/2014
Last Buyer's Agent
(240) 309-6000 lisajgiuliani@comcast.net Keller Williams Realty Centre License #598921
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $7,328
Year Built
- Built in 2005
Lot Details
- 15,227 Sq Ft Lot
- Property is zoned PUD
HOA Fees
- $95 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Driveway
Home Design
- Colonial Architecture
- Brick Exterior Construction
Interior Spaces
- Property has 3 Levels
- Open Floorplan
- 1 Fireplace
- Family Room Off Kitchen
- Dining Area
Kitchen
- Gourmet Kitchen
- Breakfast Area or Nook
- Kitchen Island
Bedrooms and Bathrooms
- 5 Bedrooms
- 5.5 Bathrooms
Finished Basement
- Walk-Out Basement
- Rear Basement Entry
- Basement Windows
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
Listing and Financial Details
- Tax Lot 14037
- Assessor Parcel Number 1107238681
Community Details
Overview
- Villages Of Urba Community
- Villages Of Urbana Subdivision
Amenities
- Common Area
- Community Library
Recreation
- Tennis Courts
- Soccer Field
- Community Basketball Court
- Community Playground
- Fitness Center
- Community Pool
- Jogging Path
- Bike Trail
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
Dec 7, 2014
Closed on
Oct 30, 2015
Sold by
Bought by
Seller's Agent
Eric Steinhoff
LPT Realty, LLC
Buyer's Agent
Lisa Giuliani
Keller Williams Realty Centre
List Price
$849,900
Sold Price
$725,000
Premium/Discount to List
-$124,900
-14.7%
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
$494,147
Avg. Annual Appreciation
5.02%
Original Mortgage
$580,000
Interest Rate
0.0379%
Mortgage Type
New Conventional
Purchase Details
Closed on
Apr 17, 2014
Sold by
Bought by
Purchase Details
Closed on
May 16, 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
$775,200
Interest Rate
0.055%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Dec 2, 2004
Sold by
Bought by
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
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 |
|---|---|---|---|
| $725,000 | United Title Service Llc | ||
| -- | None Available | ||
| $960,030 | -- | ||
| $311,947 | -- |
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 |
|---|---|---|---|
| Closed | $510,000 | ||
| Closed | $580,000 | ||
| Closed | $250,000 | ||
| Closed | $775,200 | ||
| Closed | $96,900 | ||
| Closed | $191,909 |
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 |
|---|---|---|---|---|
| 11/06/2015 11/06/15 | Sold | $725,000 | -2.0% | $137 / Sq Ft |
| 05/15/2015 05/15/15 | Price Changed | $739,900 | -12.9% | $140 / Sq Ft |
| 02/11/2015 02/11/15 | Pending | -- | -- | -- |
| 12/07/2014 12/07/14 | For Sale | $849,900 | -- | $160 / 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 | $12,430 | $1,039,000 | -- | -- |
| 2024 | $12,430 | $941,200 | $205,100 | $736,100 |
| 2023 | $11,464 | $875,300 | $0 | $0 |
| 2022 | $10,945 | $809,400 | $0 | $0 |
| 2021 | $10,789 | $743,500 | $176,500 | $567,000 |
| 2020 | $10,789 | $743,500 | $176,500 | $567,000 |
| 2019 | $10,749 | $743,500 | $176,500 | $567,000 |
| 2018 | $11,119 | $781,800 | $110,000 | $671,800 |
| 2017 | $10,539 | $781,800 | $0 | $0 |
| 2016 | $8,923 | $684,567 | $0 | $0 |
| 2015 | $8,923 | $633,000 | $0 | $0 |
| 2014 | $8,923 | $625,267 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Eric Steinhoff
-
Lisa Giuliani
Buyer's Agent in 2015
Lisa Giuliani
Keller Williams Realty Centre
(240) 447-5766
70 in this area
95 Total Sales
Map
Source: Bright MLS
MLS Number: 1003270824
APN: 07-238681
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 2026 Bright MLS, Inc.
Nearby Homes
- 9202 Charterhouse Rd
- 3962 Triton St
- 3829 Bush Creek Dr
- 3928 Shawfield Ln
- 3701 Spicebush Way
- 3818 Sugarloaf Pkwy
- 9175 Bealls Farm Rd
- 3706 Singleton Terrace
- 3611 Hope Commons Ct
- 3816 Fulham Rd
- 3729 Singleton Terrace
- 3647 Singleton Terrace
- 9424 Singleton Place
- 3814 Addison Woods Rd
- 3626 Singleton Terrace
- 9009 Bealls Farm Rd
- 8822 Lew Wallace Rd
- 3625 Singleton Terrace
- 3557 Worthington Blvd Unit A
- 3544 Winthrop Ln
- 9100 Charterhouse Rd
- 9102 Charterhouse Rd
- 9101 Charterhouse Rd
- 9106 Charterhouse Rd
- 9103 Charterhouse Rd
- 9100 Whitmore Ln
- 9105 Charterhouse Rd
- 9102 Whitmore Ln
- 4001 Broadstone St
- 9107 Charterhouse Rd
- 9110 Charterhouse Rd
- 4003 Broadstone St
- 9104 Whitmore Ln
- 4000 Broadstone St
- 9109 Charterhouse Rd
- 9103 Whitmore Ln
- 9112 Charterhouse Rd
- 9106 Whitmore Ln
- 4005 Broadstone St
- 3938 Sweetbriar Ln
Your Personal Tour Guide
Ask me questions while you tour the home.