David McGuire
RE/MAX Results
(301) 835-2095
31 Total Sales
2 in Clover Hill
$500K - $506K Price Range
400 Conundrum Terrace Frederick, MD 21702
Clover Hill NeighborhoodEstimated Value: $633,211
3
Beds
2
Baths
2,466
Sq Ft
$257/Sq Ft
Est. Value
Highlights
- Built in 2017 | Newly Remodeled
- Open Floorplan
- Rambler Architecture
- Yellow Springs Elementary School Rated A-
- Vaulted Ceiling
- Wood Flooring
About This Home
As of December 2017Brentwood built to customer's specifications - entered for comp purposes - features include: over 2,400 sq ft. on 2 levels, 3 beds and 2 baths on main level, finished basement w/ bath rough-in, screened in porch, hardwood floors and partial brick front! Images shown are representative only.
Last Agent to Sell the Property
(240) 309-6000 cmccarthy@nvrinc.com Keller Williams Realty Centre License #ABR00408 Listed on: 06/26/2017
Last Buyer's Agent
(844) 552-7444 datacorrect@brightmls.com Non Subscribing Office License #0225194075
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
Year Built
- Built in 2017 | Newly Remodeled
Lot Details
- 8,543 Sq Ft Lot
- Landscaped
- Property is in very good condition
HOA Fees
- $38 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Front Facing Garage
- Garage Door Opener
- Driveway
Home Design
- Rambler Architecture
- Bump-Outs
- Brick Exterior Construction
- Asphalt Roof
- Vinyl Siding
Interior Spaces
- 2,466 Sq Ft Home
- Property has 2 Levels
- Open Floorplan
- Vaulted Ceiling
- Recessed Lighting
- Low Emissivity Windows
- Vinyl Clad Windows
- Insulated Windows
- Sliding Doors
- Insulated Doors
- Entrance Foyer
- Great Room
- Dining Room
- Game Room
- Wood Flooring
- Washer and Dryer Hookup
Kitchen
- Breakfast Area or Nook
- Eat-In Kitchen
- Gas Oven or Range
- Self-Cleaning Oven
- Microwave
- Freezer
- Ice Maker
- Dishwasher
- Kitchen Island
Bedrooms and Bathrooms
- 3 Main Level Bedrooms
- En-Suite Bathroom
- 2 Full Bathrooms
Finished Basement
- Basement Fills Entire Space Under The House
- Connecting Stairway
- Sump Pump
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
- Fire Sprinkler System
Accessible Home Design
- Doors with lever handles
- Level Entry For Accessibility
Eco-Friendly Details
- Energy-Efficient Construction
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Water Dispenser
- Tankless Water Heater
- Natural Gas Water Heater
Listing and Financial Details
- Tax Lot 112
Community Details
Overview
- Built by RYAN HOMES
- Clover Ridge Subdivision, Brentwood Floorplan
Amenities
- Common Area
Recreation
- Community Playground
- 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
Jun 26, 2017
Closed on
Dec 4, 2017
Sold by
Nvr Inc
Bought by
Seller's Agent
Carolyn Scuderi McCarthy
Keller Williams Realty Centre
Buyer's Agent
datacorrect BrightMLS
Non Subscribing Office
List Price
$429,370
Sold Price
$429,370
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
$203,841
Avg. Annual Appreciation
4.52%
Original Mortgage
$343,496
Outstanding Balance
$281,606
Interest Rate
3.94%
Mortgage Type
New Conventional
Estimated Equity
$351,605
Purchase Details
Closed on
Aug 21, 2017
Sold by
Clover Ridge Llc
Bought by
Nvr Inc
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Clover Hill, MD
-
David McGuire
-
Leigh Ann Fangmeyer
Leigh Ann Fangmeyer
RE/MAX Results
(240) 698-2416
39 Total Sales
1 in Clover Hill
$674,000 Price
-
Shelley Eyler
Shelley Eyler
Berkshire Hathaway HomeServices PenFed Realty
(240) 594-5798
89 Total Sales
1 in Clover Hill
$480,000 Price
-
Arina Voznesenskaya
Arina Voznesenskaya
Compass
(571) 378-5055
108 Total Sales
1 in Clover Hill
$599,990 Price
-
Grant Bim
Grant Bim
Winning Edge
(667) 802-2623
361 Total Sales
1 in Clover Hill
$350,000 Price
-
Zarema Kumukova
Zarema Kumukova
Long & Foster Real Estate, Inc.
(240) 679-8648
44 Total Sales
1 in Clover Hill
$435,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 |
|---|---|---|---|
| $429,370 | None Available | ||
| Nvr Inc | $126,300 | None Available |
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 |
|---|---|---|---|
| Open | $343,496 |
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 |
|---|---|---|---|---|
| 12/04/2017 12/04/17 | Sold | $429,370 | 0.0% | $174 / Sq Ft |
| 06/26/2017 06/26/17 | Pending | -- | -- | -- |
| 06/26/2017 06/26/17 | For Sale | $429,370 | -- | $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 | $8,842 | $556,933 | ||
| 2025 | $8,443 | $528,500 | $110,300 | $418,200 |
| 2024 | $8,443 | $489,500 | $0 | $0 |
| 2023 | $7,803 | $450,500 | $0 | $0 |
| 2022 | $7,390 | $411,500 | $110,300 | $301,200 |
| 2021 | $7,307 | $408,667 | $0 | $0 |
| 2020 | $7,267 | $405,833 | $0 | $0 |
| 2019 | $7,213 | $403,000 | $100,300 | $302,700 |
| 2018 | $7,098 | $397,933 | $0 | $0 |
| 2017 | $1,176 | $100,300 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Carolyn Scuderi McCarthy
CS
Seller's Agent in 2017
Carolyn Scuderi McCarthy
Keller Williams Realty Centre
(240) 405-1203
2 in this area
30 Total Sales
-
datacorrect BrightMLS
DB
Buyer's Agent in 2017
datacorrect BrightMLS
Non Subscribing Office
Map
Source: Bright MLS
MLS Number: 1004314703
APN: 02-593792
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
- 122 Sunlight Ct
- 100 Sunlight Dr
- 1100 Reagans Rd
- 2075 Spring Run Cir
- 92 Pleasonton Ct
- 126 Wheeler Ln
- 1901 Belford Ct
- 2109 Peace Lily Ln
- 1954 Moran Dr
- 2128 Peace Lily Ln
- 1943 Crossing Stone Ct
- 2410 Silver Leaf Dr
- 90 Howard Ct
- 2605 Broadleaf Dr
- 6805 Hawes Ct
- 169 Midsummer Dr
- 2006 Fauna Dr
- 8322 Jordan Valley Way
- 2619 Broadleaf Dr
- 2083 Buell Dr
- 402 Conundrum Terrace
- 404 Conundrum Terrace
- 308 Conundrum Ct
- 406 Conundrum Terrace
- 2001 Quandary Dr
- 411 Conundrum Terrace
- 1 Conundrum Terrace
- 306 Conundrum Ct
- 2003 Quandary Dr
- 408 Conundrum Terrace
- 413 Conundrum Terrace
- 2000 Quandary Dr
- 304 Conundrum Ct
- 410 Conundrum Terrace
- 412 Conundrum Terrace
- 415 Conundrum Terrace
- 414 Conundrum Terrace
- 2005 Quandary Dr
- 2002 Quandary Dr
- 416 Conundrum Terrace
Your Personal Tour Guide
Ask me questions while you tour the home.