Leigh Ann Fangmeyer
RE/MAX Results
(240) 698-2416
41 Total Sales
2 in Villages of Urbana
$512K - $610K Price Range
3608 John Simmons Ct Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $960,000 - $1,023,841
5
Beds
4.5
Baths
5,178
Sq Ft
$192/Sq Ft
Est. Value
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 2025This stately NV home is ideally located at the end of a cul-de-sac on a premium lot backing to trees. The beautifully landscaped backyard features a terraced design with a stone patio, retaining wall, and a spacious, low-maintenance deck. A large side yard with a playset adds to the outdoor appeal. Enjoy breathtaking views on this expansive 0.43-acre lot—one of the largest in the community! Conveniently within walking distance to shopping, restaurants, and the library. Inside, the main level boasts a bright and airy kitchen that opens to the deck and patio, a dramatic two-story family room with a gas fireplace, formal living and dining rooms, plus a generous bonus room/office and a powder room. Upstairs, the charming owner’s suite offers a full bath and a huge walk-in closet, accompanied by three additional spacious bedrooms and two more bathrooms. The fully finished walkout basement is perfect for entertaining, featuring a large rec room with a wet bar and fireplace, a fifth bedroom with a full bath, and a bonus/media room. Roof replaced in 2021.
Last Agent to Sell the Property
(240) 309-6000 lisajgiuliani@comcast.net Keller Williams Realty Centre License #598921 Listed on: 04/02/2025
Last Buyer's Agent
(240) 497-1700 shelley.green@longandfoster.com Long & Foster Real Estate, Inc. License #530727
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $9,425
Year Built
- Built in 2000
Lot Details
- 18,657 Sq Ft Lot
- Stone Retaining Walls
- Extensive Hardscape
- Property is zoned PUD
HOA Fees
- $134 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
- 1 Fireplace
- 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
- Heating System Uses Natural Gas
- 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
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
Apr 2, 2025
Closed on
Jun 2, 2025
Sold by
Ceresko Adam Joseph and Ceresko Payvand Davari
Bought by
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
-$11,528
Avg. Annual Appreciation
-3.95%
Purchase Details
Listed on
Mar 18, 2022
Closed on
Apr 29, 2022
Sold by
Raghav Chintalapally
Bought by
Ceresko Adam Joseph and Ceresko Payvand Davari
Seller's Agent
Lisa Giuliani
Keller Williams Realty Centre
Buyer's Agent
Jamie Hilmi
Compass
List Price
$849,900
Sold Price
$935,000
Premium/Discount to List
$85,100
10.01%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.65%
Original Mortgage
$728,000
Interest Rate
4.16%
Mortgage Type
New Conventional
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.86%
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 7, 2008
Sold by
Esche Marina Madriz
Bought by
Rodriguez Maurico Kathleen M
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
New Conventional
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
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Villages of Urbana, MD
-
Leigh Ann Fangmeyer
-
Danielle Gottlieb
Danielle Gottlieb
RE/MAX Realty Centre, Inc.
(240) 905-5179
34 Total Sales
1 in Villages of Urbana
$490,000 Price
-
Raquel Gutierrez
Raquel Gutierrez
TTR Sotheby's International Realty
(202) 946-5364
84 Total Sales
1 in Villages of Urbana
$620,000 Price
-
Nicola Taylor
Nicola Taylor
TTR Sotheby's International Realty
(301) 450-6430
70 Total Sales
1 in Villages of Urbana
$410,000 Price
-
Tawfik Anounkou
Tawfik Anounkou
Keller Williams Capital Properties
(301) 381-4243
110 Total Sales
1 in Villages of Urbana
$490,000 Price
-
James McInerney
James McInerney
Responds QuicklyColdwell Banker Realty
(240) 549-5905
53 Total Sales
1 in Villages of Urbana
$446,000 Price
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 |
|---|---|---|---|
| $1,045,000 | None Listed On Document | ||
| Ceresko Adam Joseph | $935,000 | Assurance Title | |
| Chintalapally Raghav | $590,000 | None Available | |
| Robinson Arthur | $564,500 | Commonwealth Land Title Insu | |
| Rodriguez Maurico Kathleen M | $700,000 | -- | |
| Esche Marina Madriz | -- | -- | |
| Esche Paul C | $355,721 | -- | |
| Nvr Inc | $70,000 | -- |
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 |
|---|---|---|---|
| Previous Owner | $728,000 | ||
| Previous Owner | Chintalapally Raghav | $454,350 | |
| Previous Owner | Chintalapally Raghav | $472,000 | |
| Previous Owner | Robinson Arthur | $270,000 | |
| Previous Owner | Esche Marina Madriz | $488,000 | |
| Previous Owner | Esche Marina Madriz | $450,000 |
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 | Prior Sale |
|---|---|---|---|---|---|
| 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 | View Prior Sale |
| 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 | -- | $174 / 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 |
|---|---|---|---|---|
| 2026 | $11,865 | $889,033 | ||
| 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
Seller's Agent in 2025
Lisa Giuliani
Keller Williams Realty Centre
(240) 447-5766
67 in this area
90 Total Sales
-
Shelley Green
Buyer's Agent in 2025
Shelley Green
Long & Foster
(240) 401-5875
2 in this area
27 Total Sales
-
Jamie Hilmi
Buyer's Agent in 2022
Jamie Hilmi
Compass
(703) 622-8251
1 in this area
42 Total Sales
-
John Bayley
Seller's Agent in 2014
John Bayley
Keller Williams Realty Centre
(240) 422-0111
12 in this area
46 Total Sales
-
GM
Buyer's Agent in 2014
Greg Myers
Remax Realty Group
Map
Source: Bright MLS
MLS Number: MDFR2061674
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 2026 Bright MLS, Inc.
Nearby Homes
- 9212 Landon House Way
- 3611 Hope Commons Ct
- 9200 Landon House Way
- 9171 Landon House Ln
- 9140 Kenway Ln
- 9137 Landon House Ln
- 3506 Rines Tavern Ln
- 9063 Major Smith Ln
- 3557 Worthington Blvd Unit A
- 9045 Mcpherson St
- 3626 Singleton Terrace
- 9039 Clendenin Way
- 9064 Knott Ln
- 9070 Mcpherson St
- 3580 Sprigg St S
- 3550 Sprigg St S
- 3510 Starlight St Unit 401
- 3422 Angelica Way Unit 103
- 3544 Winthrop Ln
- 3650 Tavistock Rd
- 3606 John Simmons Ct
- 9119 Hendry Terrace
- 3609 John Simmons Ct
- 3604 John Simmons Ct
- 9121 Hendry Terrace
- 9123 Hendry Terrace
- 9117 Hendry Terrace
- 3602 John Simmons Ct
- 3607 John Simmons Ct
- 9125 Hendry Terrace
- 3605 John Simmons Ct
- 3516 Tabard Ln
- 3514 Tabard Ln
- 3518 Tabard Ln
- 3520 Tabard Ln
- 3603 John Simmons Ct
- 3522 Tabard Ln
- 3524 Tabard Ln
- 9127 Hendry Terrace
- 9105 John Simmons St
Your Personal Tour Guide
Ask me questions while you tour the home.