H
Seller's Agent in 2014
Hilda Ellis
Long & Foster
3820 Shetland Ct Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $1,072,629 - $1,158,000
4
Beds
4
Baths
6,200
Sq Ft
$180/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- Waterfall on Lot
- Dual Staircase
- Centerville Elementary Rated A
- Open Floorplan
- Colonial Architecture
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
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
$443,657
Avg. Annual Appreciation
4.29%
Original Mortgage
$641,250
Outstanding Balance
$490,850
Interest Rate
4.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Estimated Equity
$627,807
Purchase Details
Closed on
Oct 25, 2002
Sold by
Bought by
Purchase Details
Closed on
Jul 26, 2002
Sold by
Bought by
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
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 | $641,250 | ||
| Closed | -- |
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 |
|---|---|---|---|---|
| 2025 | $11,853 | $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
-
-
Eric Steinhoff
Buyer's Agent in 2014
Eric Steinhoff
LPT Realty, LLC
(240) 818-5744
52 in this area
199 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
- 3998 Braidwood Dr
- 9667 Ethan Ridge Dr
- 9876 Notting Hill Dr
- 9549 Fingerboard Rd
- 9712 Thompson Dr
- Lot 2, Thompson Driv Thompson Dr
- 9393 Penrose St
- 3928 Shawfield Ln
- 9555 Hyde Place
- 3671 Holborn Place
- 4222 Ijamsville Rd
- 4104 Brushfield Dr
- 3615 Spring Hollow Ln Unit 3615
- 3632 Holborn Place Unit 3632
- 3612 Spring Hollow Dr
- 3818 Sugarloaf Pkwy
- 3591 Holborn Place
- 3729 Singleton Terrace
- 3701 Spicebush Way
- 3706 Singleton Terrace
- 3818 Shetland Ct
- 3822 Shetland Ct
- 9727 Royal Crest Cir
- 9725 Royal Crest Cir
- 9729 Royal Crest Cir
- 3816 Shetland Ct
- 9723 Royal Crest Cir
- 3823 Shetland Ct
- 3819 Shetland Ct
- 9731 Royal Crest Cir
- 3817 Shetland Ct
- 3821 Shetland Ct
- 3814 Shetland Ct
- 9718 Royal Crest Cir
- 3815 Shetland Ct
- 9721 Royal Crest Cir
- 9716 Royal Crest Cir
- 9733 Royal Crest Cir
- 9720 Royal Crest Cir
- 3812 Shetland Ct
Your Personal Tour Guide
Ask me questions while you tour the home.