Seller's Agent in 2026
Emily Grimshaw
Compass
(301) 471-5372
16 in this area
67 Total Sales
9504 Hyde Place Frederick, MD 21704
Villages of Urbana Neighborhood
3
Beds
2.5
Baths
1,868
Sq Ft
$306/ mo
HOA Fee
Highlights
- Fitness Center
- Open Floorplan
- Clubhouse
- Centerville Elementary Rated A
- Colonial Architecture
- Wood Flooring
About This Home
As of February 2026Welcome to this stunningly updated two-level condominium in the highly sought-after Villages of Urbana, home to award-winning Blue Ribbon schools and unparalleled community amenities. Offering modern upgrades and incredible convenience, this home is truly move-in ready. The main level features an open living and dining floor plan with space for a kitchen table—perfect for everyday living. The kitchen boasts newer stainless steel appliances, a stove/range, and a breakfast bar island ideal for casual meals or additional prep space. Access to the attached one-car garage with overhead storage racks is just off the kitchen for easy grocery unloading. A renovated powder room and cleverly hidden storage under the stairs complete the main level. Upstairs, the spacious primary suite includes a walk-in closet plus a second walk-in that has been converted into a cozy office—easily transformed back into a closet, if preferred. The fully renovated ensuite bathroom feels like a true luxury retreat, showcasing a stunning walk-in shower, Restoration Hardware double sink vanity, upgraded lighting, mirrored medicine cabinets, and closet storage space. Two additional bedrooms offer flexibility for guests, family, or workspace—one with access to a private, low-maintenance composite balcony. A beautifully renovated hallway full bathroom with marble flooring adds unmatched style. The upper level also features a walk-in laundry room with newer stackable washer/dryer, a folding table, and cabinetry for extra storage. Located minutes from commuter routes, shopping, dining, recreation, and downtown Frederick, this home offers the best of Urbana living with thoughtful design, comfort, style, and everyday convenience. **For a first look, please join us for an evening open house Thursday, January 8th, 5:00pm-7:00pm.**
Last Agent to Sell the Property
(240) 451-9662 emily@thegwteam.com Compass Brokerage Phone: 2404519662 License #662039 Listed on: 01/08/2026
Co-Listed By
(240) 451-9662 brookecentrafaulkner@gmail.com Compass Brokerage Phone: 2404519662 License #655225
Townhouse Details
Home Type
- Townhome
Est. Annual Taxes
- $4,295
Year Built
- Built in 2007 | Remodeled in 2025
Lot Details
- 1,868 Sq Ft Lot
- Sprinkler System
HOA Fees
Parking
- 1 Car Attached Garage
- 1 Driveway Space
- Rear-Facing Garage
- On-Street Parking
Home Design
- Colonial Architecture
- Brick Exterior Construction
- Slab Foundation
- Vinyl Siding
Interior Spaces
- 1,868 Sq Ft Home
- Property has 2 Levels
- Open Floorplan
- Crown Molding
- Recessed Lighting
- Transom Windows
- Family Room Off Kitchen
- Dining Area
Kitchen
- Eat-In Kitchen
- Stove
- Built-In Microwave
- Dishwasher
- Stainless Steel Appliances
- Kitchen Island
- Disposal
Flooring
- Wood
- Carpet
- Tile or Brick
Bedrooms and Bathrooms
- 3 Bedrooms
- En-Suite Bathroom
- Walk-In Closet
- Bathtub with Shower
- Walk-in Shower
Laundry
- Laundry Room
- Laundry on upper level
- Stacked Washer and Dryer
Outdoor Features
- Balcony
Schools
- Centerville Elementary School
- Urbana Middle School
- Urbana High School
Utilities
- Forced Air Heating and Cooling System
- Electric Water Heater
Listing and Financial Details
- Assessor Parcel Number 1107250037
Community Details
Overview
- Association fees include common area maintenance, lawn maintenance, management, pool(s), snow removal
- Villages Of Urbana Subdivision
Amenities
- Common Area
- Clubhouse
- Recreation Room
Recreation
- Tennis Courts
- Community Basketball Court
- Community Playground
- Fitness Center
- Fenced Community Pool
- Lap or Exercise Community Pool
- Jogging Path
- Bike Trail
Pet Policy
- Limit on the number of pets
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 8, 2026
Closed on
Feb 2, 2026
Sold by
Usherwood Elizabeth Ann and Brose Ryan A
Bought by
Adams Leon Ricardo
Seller's Agent
Emily Grimshaw
Compass
Buyer's Agent
Craig Marsh
Marsh Realty
List Price
$425,000
Sold Price
$430,000
Premium/Discount to List
$5,000
1.18%
Views
22
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-24.25%
Original Mortgage
$322,500
Outstanding Balance
$322,183
Interest Rate
6.06%
Mortgage Type
New Conventional
Estimated Equity
$98,370
Purchase Details
Listed on
Jun 14, 2023
Closed on
Jun 30, 2023
Sold by
Jagtap Rajendra M and Nerpawar Vrushali
Bought by
Usherwood Elizabeth Ann and Grose Ryan A
Seller's Agent
Sam Giuliani
Keller Williams Realty Centre
Buyer's Agent
Emily Grimshaw
Compass
List Price
$385,000
Sold Price
$400,000
Premium/Discount to List
$15,000
3.9%
Views
48
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.81%
Original Mortgage
$340,000
Interest Rate
6.69%
Mortgage Type
New Conventional
Purchase Details
Closed on
Feb 5, 2008
Sold by
Nvr Inc
Bought by
Jagtap Rajendra M and Vrushali Nerpawar
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$45,900
Interest Rate
6.02%
Mortgage Type
Stand Alone Second
Purchase Details
Closed on
Jan 4, 2008
Sold by
Nvr Inc
Bought by
Jagtap Rajendra M and Vrushali Nerpawar
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$45,900
Interest Rate
6.02%
Mortgage Type
Stand Alone Second
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $400,000 | None Listed On Document | |
| Deed | $306,000 | -- | |
| Deed | $306,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $340,000 | New Conventional | |
| Previous Owner | $45,900 | Stand Alone Second | |
| Previous Owner | $244,800 | Purchase Money Mortgage | |
| Previous Owner | $244,800 | Purchase Money Mortgage |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 02/06/2026 02/06/26 | Sold | $430,000 | +1.2% | $230 / Sq Ft | |
| 01/08/2026 01/08/26 | For Sale | $425,000 | +6.3% | $228 / Sq Ft | |
| 06/30/2023 06/30/23 | Sold | $400,000 | +3.9% | $214 / Sq Ft | View Prior Sale |
| 06/16/2023 06/16/23 | Pending | -- | -- | -- | |
| 06/14/2023 06/14/23 | For Sale | $385,000 | 0.0% | $206 / Sq Ft | |
| 05/11/2020 05/11/20 | Rented | $1,900 | 0.0% | -- | |
| 05/11/2020 05/11/20 | Under Contract | -- | -- | -- | |
| 03/12/2020 03/12/20 | For Rent | $1,900 | +2.7% | -- | |
| 09/12/2018 09/12/18 | Rented | $1,850 | -2.6% | -- | |
| 09/11/2018 09/11/18 | Under Contract | -- | -- | -- | |
| 08/13/2018 08/13/18 | For Rent | $1,900 | +2.7% | -- | |
| 09/01/2017 09/01/17 | Rented | $1,850 | -2.6% | -- | |
| 08/16/2017 08/16/17 | Under Contract | -- | -- | -- | |
| 06/07/2017 06/07/17 | For Rent | $1,900 | +5.6% | -- | |
| 07/10/2014 07/10/14 | Rented | $1,800 | 0.0% | -- | |
| 06/18/2014 06/18/14 | Under Contract | -- | -- | -- | |
| 06/04/2014 06/04/14 | For Rent | $1,800 | -- | -- |
Source: Bright MLS
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 | $4,846 | $354,333 | -- | -- |
| 2024 | $4,846 | $326,000 | $105,500 | $220,500 |
| 2023 | $4,532 | $310,667 | $0 | $0 |
| 2022 | $4,336 | $295,333 | $0 | $0 |
| 2021 | $4,104 | $280,000 | $85,500 | $194,500 |
| 2020 | $4,251 | $276,333 | $0 | $0 |
| 2019 | $4,152 | $272,667 | $0 | $0 |
| 2018 | $3,153 | $269,000 | $50,000 | $219,000 |
| 2017 | $3,872 | $269,000 | $0 | $0 |
| 2016 | $3,651 | $253,000 | $0 | $0 |
| 2015 | $3,651 | $245,000 | $0 | $0 |
| 2014 | $3,651 | $243,333 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Emily Grimshaw
-
Brooke Faulkner
B
Seller Co-Listing Agent in 2026
Brooke Faulkner
Compass
(240) 423-7873
1 in this area
3 Total Sales
-
Craig Marsh
Buyer's Agent in 2026
Craig Marsh
Marsh Realty
(301) 875-5978
1 in this area
645 Total Sales
-
Sam Giuliani
Seller's Agent in 2023
Sam Giuliani
Keller Williams Realty Centre
(240) 405-7726
17 in this area
41 Total Sales
-
Lisa Giuliani
Seller's Agent in 2017
Lisa Giuliani
Keller Williams Realty Centre
(240) 447-5766
71 in this area
97 Total Sales
-
John Bayley
Buyer's Agent in 2017
John Bayley
Keller Williams Realty Centre
(240) 422-0111
16 in this area
51 Total Sales
Map
Source: Bright MLS
MLS Number: MDFR2074424
APN: 07-250037
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
- 9526 Hyde Place
- 3623 Spring Hollow Dr Unit 3623
- 3641 Spring Hollow Dr Unit 3641
- 3648 Holborn Place
- 3591 Holborn Place
- 3516 Connor Place
- 3818 Sugarloaf Pkwy
- 3908 Shawfield Ln
- Lot 2, Thompson Driv Thompson Dr
- 3640 Byron Cir
- 3664 Byron Cir
- 3830 Braveheart Dr
- 3842 Braveheart Dr
- 4009 Tottenham Ct
- 4103 Tottenham St
- 9103 John Simmons St
- 3610 Hope Commons Ct
- 9657 Atterbury Ln
- 9115 Hendry Terrace
- 9200 Landon House Way
Your Personal Tour Guide
Ask me questions while you tour the home.