Preda Mendez-Lopez
Realty One Group Performance, LLC
(757) 267-9786
48 Total Sales
1 in Villages of Urbana
$590,000 Price
3820 Shetland Ct Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $1,104,493
4
Beds
4
Baths
6,200
Sq Ft
$178/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- Open Floorplan
- Colonial Architecture
- Waterfall on Lot
- Dual Staircase
- Deck
About This Home
As of June 2014Well kept,brk frt NV Wynterhall model, waterfall stairs to 2nd flr, 4 BR, 2 FB,2 HB,hwd & cer. on main lvl, gourmet kit. granite cntr, 2 sty foyer & fam rm, garage w/ non-slip flr, lrg wndw tinted, lrg trex-like deck, AWESOME master BR w/ ceramic tile mbth,waterfall stair to bsmt w/ wet bar,game & cinema area w/ frpl, wndws & french dr to patio. MUST SEE MOVE IN CONDITION.
Last Agent to Sell the Property
Hilda Ellis
(301) 975-9500 hillda.ellis@lnf.com Long & Foster Real Estate, Inc. License #MRIS:3028209 Listed on: 03/31/2014
Last Buyer's Agent
(877) 366-2213 mdbrokers@lptrealty.com LPT Realty, LLC License #RS-0038509
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
- $5,826
Year Built
- Built in 2002 | Remodeled in 2010
Lot Details
- 11,674 Sq Ft Lot
- Cul-De-Sac
- Landscaped
- Extensive Hardscape
- Private Lot
- Premium Lot
- Irregular Lot
- Sprinkler System
- Property is in very good condition
- Property is zoned PUD
HOA Fees
- $94 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Front Facing Garage
- Garage Door Opener
- Driveway
Home Design
- Colonial Architecture
- Frame Construction
- Asphalt Roof
- Shingle Siding
- Vinyl Siding
- Brick Front
Interior Spaces
- Property has 3 Levels
- Open Floorplan
- Wet Bar
- Dual Staircase
- Built-In Features
- Chair Railings
- Crown Molding
- Tray Ceiling
- Vaulted Ceiling
- Recessed Lighting
- 2 Fireplaces
- Heatilator
- Double Pane Windows
- Vinyl Clad Windows
- Window Treatments
- Palladian Windows
- Bay Window
- Window Screens
- French Doors
- Six Panel Doors
- Entrance Foyer
- Great Room
- Family Room Off Kitchen
- Living Room
- Dining Room
- Den
- Workshop
- Storage Room
- Wood Flooring
- Attic
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Area or Nook
- Butlers Pantry
- Built-In Self-Cleaning Double Oven
- Electric Oven or Range
- Cooktop with Range Hood
- Microwave
- Extra Refrigerator or Freezer
- Ice Maker
- Dishwasher
- Kitchen Island
- Upgraded Countertops
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Bathroom
- 4 Bathrooms
- Whirlpool Bathtub
Laundry
- Laundry Room
- Front Loading Dryer
- Front Loading Washer
Finished Basement
- Heated Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Connecting Stairway
- Rear Basement Entry
- Sump Pump
- Workshop
- Rough-In Basement Bathroom
- Basement Windows
Home Security
- Storm Doors
- Carbon Monoxide Detectors
- Fire and Smoke Detector
- Flood Lights
Eco-Friendly Details
- Energy-Efficient Appliances
Outdoor Features
- Deck
- Brick Porch or Patio
- Waterfall on Lot
Utilities
- Humidifier
- Forced Air Zoned Heating and Cooling System
- Heating System Uses Natural Gas
- Heat Pump System
- Vented Exhaust Fan
- Underground Utilities
- 60 Gallon+ Natural Gas Water Heater
- High Speed Internet
- Multiple Phone Lines
- Cable TV Available
Listing and Financial Details
- Tax Lot 25018
- Assessor Parcel Number 1107233523
Community Details
Overview
- Association fees include management, insurance, pool(s), road maintenance, reserve funds, snow removal, trash
- Built by NVR
- Urbana Highlands Subdivision, Wynterhall Floorplan
- The community has rules related to alterations or architectural changes, building or community restrictions, commercial vehicles not allowed, covenants
Amenities
- Common Area
Recreation
- Tennis Courts
- Community Basketball Court
- Community Playground
- 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
Mar 31, 2014
Closed on
Jun 16, 2014
Sold by
Bought by
Seller's Agent
Hilda Ellis
Long & Foster Real Estate, Inc.
Buyer's Agent
Eric Steinhoff
LPT Realty, LLC
List Price
$695,000
Sold Price
$675,000
Premium/Discount to List
-$20,000
-2.88%
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
$429,493
Avg. Annual Appreciation
4.14%
Original Mortgage
$641,250
Interest Rate
4.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Oct 25, 2002
Sold by
Bought by
Purchase Details
Closed on
Jul 26, 2002
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Villages of Urbana, MD
-
Preda Mendez-Lopez
-
Wyevetra Jordan
Wyevetra Jordan
The Home Team Realty Group, LLC
(240) 312-2957
98 Total Sales
1 in Villages of Urbana
$885,000 Price
-
Mrs. LILI LIU
Mrs. LILI LIU
Ten Thousand Realty
(240) 883-5822
23 Total Sales
2 in Villages of Urbana
$430K - $455K Price Range
-
Leigh Ann Fangmeyer
Leigh Ann Fangmeyer
RE/MAX Results
(240) 698-2416
41 Total Sales
2 in Villages of Urbana
$512K - $610K Price Range
-
Danielle Gottlieb
Danielle Gottlieb
RE/MAX Realty Centre, Inc.
(240) 905-5179
34 Total Sales
1 in Villages of Urbana
$490,000 Price
-
Nicola Taylor
Nicola Taylor
TTR Sotheby's International Realty
(301) 450-6430
73 Total Sales
1 in Villages of Urbana
$410,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 |
|---|---|---|---|
| $675,000 | Monocacy Title Inc | ||
| $546,080 | -- | ||
| $230,382 | -- |
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 | $555,200 | ||
| Closed | $641,250 | ||
| Previous Owner | $531,100 |
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 |
|---|---|---|---|---|
| 06/16/2014 06/16/14 | Sold | $675,000 | -1.8% | $109 / Sq Ft |
| 05/01/2014 05/01/14 | Pending | -- | -- | -- |
| 04/23/2014 04/23/14 | Price Changed | $687,500 | +0.3% | $111 / Sq Ft |
| 04/23/2014 04/23/14 | Price Changed | $685,500 | -1.4% | $111 / Sq Ft |
| 03/31/2014 03/31/14 | For Sale | $695,000 | -- | $112 / 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 | $12,295 | $1,043,300 | ||
| 2025 | $12,295 | $957,300 | ||
| 2024 | $11,853 | $871,300 | $178,300 | $693,000 |
| 2023 | $10,944 | $815,633 | $0 | $0 |
| 2022 | $10,458 | $759,967 | $0 | $0 |
| 2021 | $10,052 | $704,300 | $150,600 | $553,700 |
| 2020 | $10,052 | $689,533 | $0 | $0 |
| 2019 | $9,655 | $674,767 | $0 | $0 |
| 2018 | $9,361 | $660,000 | $109,600 | $550,400 |
| 2017 | $8,882 | $660,000 | $0 | $0 |
| 2016 | $7,590 | $574,667 | $0 | $0 |
| 2015 | $7,590 | $532,000 | $0 | $0 |
| 2014 | $7,590 | $519,800 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
H
Seller's Agent in 2014
Hilda Ellis
Long & Foster
-
Eric Steinhoff
Buyer's Agent in 2014
Eric Steinhoff
LPT Realty, LLC
(240) 818-5744
49 in this area
197 Total Sales
Map
Source: Bright MLS
MLS Number: 1002904892
APN: 07-233523
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
- 9653 Bothwell Ln
- 3861 Braveheart Dr
- 9693 Royal Crest Cir
- 9712 Thompson Dr
- 9813 Notting Hill Dr
- Lot 2, Thompson Driv Thompson Dr
- 9715 Spencer Ln
- 9510 Ethan Ridge Dr
- 4104 Tottenham St
- 9754 Wyndham Dr
- 9237 Charterhouse Rd
- 9512 Hyde Place
- 3928 Shawfield Ln
- 3671 Holborn Place
- 3938 Addison Woods Rd
- 4222 Ijamsville Rd
- 3615 Spring Hollow Ln Unit 3615
- 9215 Shafers Mill Dr
- 3844 Sugarloaf Pkwy
- 3612 Spring Hollow Dr
- 3817 Shetland Ct
- 3819 Shetland Ct
- 3815 Shetland Ct
- 3952 Braveheart Cir
- 3950 Braveheart Cir
- 3954 Braveheart Cir
- 3948 Braveheart Cir
- 3813 Shetland Ct
- 3818 Shetland Ct
- 3821 Shetland Ct
- 3816 Shetland Ct
- 3956 Braveheart Cir
- 3946 Braveheart Cir
- 3814 Shetland Ct
- 3811 Shetland Ct
- 3823 Shetland Ct
- 3900 Braveheart Cir
- 3944 Braveheart Cir
- 3958 Braveheart Cir
- 3822 Shetland Ct
Your Personal Tour Guide
Ask me questions while you tour the home.