Seller's Agent in 2025
Lisa Giuliani
Keller Williams Realty Centre
(240) 447-5766
77 in this area
106 Total Sales
3608 John Simmons Ct Frederick, MD 21704
Villages of Urbana Neighborhood
5
Beds
4.5
Baths
4,898
Sq Ft
0.43
Acres
Highlights
- Fitness Center
- Eat-In Gourmet Kitchen
- Open Floorplan
- Urbana Elementary School Rated A
- 0.43 Acre Lot
- Colonial Architecture
About This Home
As of June 2025OPEN HOUSE CANCELLED! This gorgeous NV home is perfectly situated at the end of a cul-de-sac on a premium lot backing to trees. Terraced back yard with stone patio and retaining wall, expansive low maintenance deck. Huge side yard with playset. Fabulous views! Lot is .43 acres making it one of the largest in the community. Walking distance to shopping, restaurants and library.
Main level features a spacious floorplan with a bright and sunny kitchen that opens to a large deck and patio, dramatic 2 story family room w/ gas fireplace, formal living and dining room plus a large bonus room/office and powder room. Upstairs is a charming owner's suite with full bath and huge walk in closet, plus three additional large bedrooms and two additional baths. The fully finished walk out basement is equipped with a huge rec room w/ wet bar and another fireplace, a 5th bedroom & full bath and a bonus/media room. Roof replaced in 2021. Such a great house!
Last Agent to Sell the Property
Keller Williams Realty Centre License #598921 Listed on: 03/18/2022
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $7,224
Year Built
- Built in 2000
Lot Details
- 0.43 Acre Lot
- Stone Retaining Walls
- Extensive Hardscape
- Property is zoned PUD
HOA Fees
- $115 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
Home Design
- Colonial Architecture
- Asphalt Roof
- Brick Front
- Concrete Perimeter Foundation
Interior Spaces
- Property has 3 Levels
- Open Floorplan
- Cathedral Ceiling
- Recessed Lighting
- 2 Fireplaces
- Family Room Off Kitchen
- Dining Area
- Alarm System
- Basement
Kitchen
- Eat-In Gourmet Kitchen
- Kitchen Island
Bedrooms and Bathrooms
Outdoor Features
- Patio
- Playground
Utilities
- Forced Air Heating and Cooling System
- Natural Gas Water Heater
- Multiple Phone Lines
- Satellite Dish
- Cable TV Available
Listing and Financial Details
- Tax Lot 105
- Assessor Parcel Number 1107223528
Community Details
Overview
- Association fees include pool(s), snow removal, trash
- Built by NV HOMES
- Villages Of Urbana Subdivision, Kingsmill Floorplan
- Villages Of Urba Community
Amenities
- Community Center
- Recreation Room
Recreation
- Tennis Courts
- Community Playground
- Fitness Center
- Community Pool
- Jogging Path
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 2, 2025
Closed on
Jun 2, 2025
Sold by
Ceresko Adam Joseph and Ceresko Payvand Davari
Bought by
Kudis Gary and Kudis Marvine
Seller's Agent
Lisa Giuliani
Keller Williams Realty Centre
Buyer's Agent
Shelley Green
Long & Foster Real Estate, Inc.
List Price
$1,065,000
Sold Price
$1,045,000
Premium/Discount to List
-$20,000
-1.88%
Views
73
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
$2,274
Avg. Annual Appreciation
0.78%
Purchase Details
Listed on
Feb 4, 2014
Closed on
Mar 28, 2014
Sold by
Robinson Arthur and Collier Jessica
Bought by
Chintalapally Raghav and Joginpalli Navyatha
Seller's Agent
John Bayley
Keller Williams Realty Centre
Buyer's Agent
Greg Myers
RE/MAX Realty Group
List Price
$599,900
Sold Price
$590,000
Premium/Discount to List
-$9,900
-1.65%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.24%
Original Mortgage
$472,000
Interest Rate
4.37%
Mortgage Type
New Conventional
Purchase Details
Closed on
Aug 28, 2013
Sold by
Rodriguez Mauricio and Rodriguez Kathleen M
Bought by
Robinson Arthur and Collier Jessica
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$270,000
Interest Rate
4.43%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 11, 2008
Sold by
Esche Marina Madriz
Bought by
Rodriguez Maurico Kathleen M
Purchase Details
Closed on
Mar 7, 2008
Sold by
Esche Marina Madriz
Bought by
Rodriguez Maurico Kathleen M
Purchase Details
Closed on
Feb 14, 2006
Sold by
Esche Paul C and Esche Marina M
Bought by
Esche Marina Madriz
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$450,000
Interest Rate
6.25%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan
Purchase Details
Closed on
Feb 9, 2006
Sold by
Esche Paul C and Esche Marina M
Bought by
Esche Marina Madriz
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$450,000
Interest Rate
6.25%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan
Purchase Details
Closed on
Oct 13, 2000
Sold by
Nvr Inc
Bought by
Esche Paul C and Esche Marina M
Purchase Details
Closed on
May 26, 2000
Sold by
Kiplinger Washington Editors Inc
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $1,045,000 | None Listed On Document | |
| Deed | $1,045,000 | None Listed On Document | |
| Deed | $590,000 | None Available | |
| Deed | $564,500 | Commonwealth Land Title Insu | |
| Deed | $700,000 | -- | |
| Deed | $700,000 | -- | |
| Deed | -- | -- | |
| Deed | -- | -- | |
| Deed | $355,721 | -- | |
| Deed | $70,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $454,350 | New Conventional | |
| Previous Owner | $472,000 | New Conventional | |
| Previous Owner | $270,000 | New Conventional | |
| Previous Owner | $488,000 | Stand Alone Refi Refinance Of Original Loan | |
| Previous Owner | $450,000 | Stand Alone Refi Refinance Of Original Loan | |
| Previous Owner | $450,000 | New Conventional | |
| Closed | -- | No Value Available |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 06/02/2025 06/02/25 | Sold | $1,045,000 | -1.9% | $202 / Sq Ft |
| 04/09/2025 04/09/25 | Pending | -- | -- | -- |
| 04/02/2025 04/02/25 | For Sale | $1,065,000 | +13.9% | $206 / Sq Ft |
| 04/29/2022 04/29/22 | Sold | $935,000 | -1.6% | $191 / Sq Ft |
| 03/26/2022 03/26/22 | Price Changed | $950,000 | +1.6% | $194 / Sq Ft |
| 03/19/2022 03/19/22 | Pending | -- | -- | -- |
| 03/19/2022 03/19/22 | Off Market | $935,000 | -- | -- |
| 03/18/2022 03/18/22 | For Sale | $849,900 | +44.1% | $174 / Sq Ft |
| 03/28/2014 03/28/14 | Sold | $590,000 | -1.7% | $160 / Sq Ft |
| 02/19/2014 02/19/14 | Pending | -- | -- | -- |
| 02/04/2014 02/04/14 | For Sale | $599,900 | -- | $162 / 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 | $11,257 | $830,167 | -- | -- |
| 2024 | $11,257 | $771,300 | $206,800 | $564,500 |
| 2023 | $10,240 | $719,667 | $0 | $0 |
| 2022 | $9,605 | $668,033 | $0 | $0 |
| 2021 | $9,041 | $616,400 | $176,800 | $439,600 |
| 2020 | $9,195 | $598,933 | $0 | $0 |
| 2019 | $8,867 | $581,467 | $0 | $0 |
| 2018 | $6,610 | $564,000 | $110,300 | $453,700 |
| 2017 | $7,934 | $564,000 | $0 | $0 |
| 2016 | $7,005 | $511,200 | $0 | $0 |
| 2015 | $7,005 | $484,800 | $0 | $0 |
| 2014 | $7,005 | $471,600 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Lisa Giuliani
-
Shelley Green
Buyer's Agent in 2025
Shelley Green
Long & Foster
(240) 401-5875
2 in this area
28 Total Sales
-
Jamie Hilmi
Buyer's Agent in 2022
Jamie Hilmi
Compass
(703) 622-8251
1 in this area
49 Total Sales
-
John Bayley
Seller's Agent in 2014
John Bayley
Keller Williams Realty Centre
(240) 422-0111
18 in this area
51 Total Sales
-
G
Buyer's Agent in 2014
Greg Myers
Remax Realty Group
Map
Source: Bright MLS
MLS Number: MDFR2015912
APN: 07-223528
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
- 3528 Tabard Ln
- 9232 Landon House Way
- 3514 John Simmons St
- 9114 Kenway Ln
- 9128 Kenway Ln
- 3640 Byron Cir
- 3453 Sugarloaf Pkwy
- 3460 Sugarloaf Pkwy
- 9084 Clendenin Way
- 3557 Worthington Blvd Unit A
- 3577 Bremen St
- 9047 Clendenin Way
- 3514 Urbana Pike
- 3701 Spicebush Way
- 8828 Lew Wallace Rd
- 3613 Urbana Pike
- 3636 Worthington Blvd
- 3412 Angelica Way Unit 402
- 3851 Triton Ln
- 3506 Connor Place