Seller's Agent in 2021
Sunna Ahmad
Cummings & Co. Realtors
(562) 787-0424
2 in this area
265 Total Sales
9217 Shafers Mill Dr Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $1,040,000 - $1,213,000
5
Beds
4
Baths
6,058
Sq Ft
$187/Sq Ft
Est. Value
Highlights
- Fitness Center
- Second Kitchen
- Open Floorplan
- Centerville Elementary Rated A
- Eat-In Gourmet Kitchen
- Curved or Spiral Staircase
About This Home
As of September 2021Absolutely impeccable custom NV Homes Wynter Hall Model sparing no upgrade offering the top of the line builder's package, plus every superior addition imaginable such as fully owned solar panels, exquisite bathrooms, private park in a fenced backyard quarters and MORE! Located in the sought after Villages of Urbana Community Boasting exquisite design elements, gorgeous hardwood floors, custom lighting & moulding, dual stairs, and an exceptional open floor plan! Grand two story foyer adorned with an elegant staircase appointed with decorative wooden balusters. Opposing formal living and study rooms complements with three piece crown moulding, Palladian windows and tray ceilings. Sensational two story great room graced with a floor to ceiling sunbathed window and a crystal chandelier. Prepare delectable meals in the chef inspired custom kitchen offering modern elegance yet comfort and style with sleek dual-tone granite counters, tile backsplash, professional grade appliances, a massive island, breakfast bar, mullion cabinetry, prep sink, gas cooking, walk-in pantry, chandelier lighting, butler's pantry and a casual dining area.
A main level bedroom surrounded by gracious crown moulding and a luxurious upgraded full bathroom. A main level office with custom built-ins, laundry room, and a mudroom conclude the masterfully designed main level. A secondary staircase gives access from the kitchen to the upper level. Enter into the spectacular primary bedroom suite highlighted with a custom walk-in closet and tray ceilings. The luxurious En-Suite bathroom features dual vanities, stand alone tub, oversized shower with an upgraded shower head. Three graciously sized bedrooms with an upgraded bathroom complete the upper level sleeping quarters. Continue downstairs to the truly impressive lower level emphasizing a massive recreation room with built-ins galore, custom bar with granite, exercise area and a bonus room, media room, full bath -- all with walk-up rear entry to a fenced backyard quarters, complete with an impressive private playground and massive low maintenance deck. It does not stop there! The villages of Urbana has to offer -- Shafer's Mill community center, a massive community pool, YMCA center, restaurants and shopping centers nearby . Enjoy the embodiment of Maryland's good life.
ALL OFFERS DUE AUGUST 2, 2021 | MONDAY 4 PM
Last Agent to Sell the Property
Cummings & Co. Realtors License #674044 Listed on: 07/29/2021
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $8,227
Year Built
- Built in 2005 | Remodeled in 2019
Lot Details
- 8,395 Sq Ft Lot
- Sprinkler System
- Property is in excellent condition
- Property is zoned PUD
HOA Fees
- $105 Monthly HOA Fees
Parking
- 2 Car Direct Access Garage
- 4 Driveway Spaces
- Front Facing Garage
- Garage Door Opener
- On-Street Parking
Home Design
- Colonial Architecture
- Bump-Outs
- Brick Exterior Construction
- Shingle Roof
Interior Spaces
- Property has 3 Levels
- Open Floorplan
- Wet Bar
- Curved or Spiral Staircase
- Dual Staircase
- Built-In Features
- Bar
- Chair Railings
- Crown Molding
- Wainscoting
- Tray Ceiling
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- 1 Fireplace
- Double Pane Windows
- Vinyl Clad Windows
- Insulated Windows
- Window Treatments
- Window Screens
- Double Door Entry
- Insulated Doors
- Mud Room
- Family Room Off Kitchen
- Living Room
- Formal Dining Room
- Den
- Recreation Room
- Bonus Room
- Sun or Florida Room
- Storage Room
- Home Gym
- Efficiency Studio
Kitchen
- Eat-In Gourmet Kitchen
- Kitchenette
- Second Kitchen
- Breakfast Room
- Butlers Pantry
- Double Oven
- Built-In Range
- Stove
- Built-In Microwave
- Dishwasher
- Kitchen Island
- Upgraded Countertops
- Disposal
Flooring
- Wood
- Carpet
- Marble
- Terrazzo
- Vinyl
Bedrooms and Bathrooms
- En-Suite Primary Bedroom
- En-Suite Bathroom
- Walk-In Closet
- Soaking Tub
- Bathtub with Shower
- Walk-in Shower
Laundry
- Laundry Room
- Laundry on main level
- Front Loading Dryer
- Front Loading Washer
Finished Basement
- Heated Basement
- Walk-Up Access
- Connecting Stairway
- Rear Basement Entry
- Sump Pump
- Shelving
- Space For Rooms
- Basement Windows
Eco-Friendly Details
- Energy-Efficient Appliances
- Solar owned by seller
- Cooling system powered by solar connected to the grid
Outdoor Features
- Deck
- Brick Porch or Patio
- Playground
- Play Equipment
Utilities
- Multiple cooling system units
- Central Heating and Cooling System
- Vented Exhaust Fan
- Programmable Thermostat
- Water Dispenser
- Natural Gas Water Heater
Listing and Financial Details
- Tax Lot 14093
- Assessor Parcel Number 1107237995
Community Details
Overview
- Villages Of Urba Community
- Villages Of Urbana Subdivision
Amenities
- Day Care Facility
- Clubhouse
- Game Room
- Community Center
- Party Room
- Community Library
- Recreation Room
Recreation
- Tennis Courts
- Community Playground
- Fitness Center
- Community Pool
- Jogging Path
- Bike Trail
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 29, 2021
Closed on
Sep 10, 2021
Sold by
Annavarapu Lalith Sandeep and Annavarapu Mahalakshmi
Bought by
Zhu Yun Feng and Wang Fang
Seller's Agent
Sunna Ahmad
Cummings & Co. Realtors
Buyer's Agent
Tao Sun
UnionPlus Realty, Inc.
List Price
$915,000
Sold Price
$920,000
Premium/Discount to List
$5,000
0.55%
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
$212,573
Avg. Annual Appreciation
4.44%
Original Mortgage
$828,000
Outstanding Balance
$761,582
Interest Rate
2.8%
Mortgage Type
VA
Estimated Equity
$329,752
Purchase Details
Listed on
Jun 6, 2018
Closed on
Jul 11, 2018
Sold by
Schiller Scott and Schiller Jaynia
Bought by
Annavarapu Lalith Sandeep and Annavarapu Mahalakshmi
Seller's Agent
Stacy Delisle
IMPACT Maryland Real Estate
Buyer's Agent
Kenneth Grant
Pearson Smith Realty, LLC
List Price
$764,900
Sold Price
$720,027
Premium/Discount to List
-$44,873
-5.87%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.06%
Original Mortgage
$648,024
Interest Rate
4.5%
Mortgage Type
New Conventional
Purchase Details
Listed on
Nov 1, 2013
Closed on
Feb 28, 2014
Sold by
Hamerski Ryan and Hamerski Megan
Bought by
Schiller Scott and Schiller Jaynia
Seller's Agent
Eric Steinhoff
LPT Realty, LLC
Buyer's Agent
Kelly Jaeger
RE/MAX Results
List Price
$674,900
Sold Price
$649,900
Premium/Discount to List
-$25,000
-3.7%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.37%
Original Mortgage
$417,000
Interest Rate
4.32%
Mortgage Type
New Conventional
Purchase Details
Closed on
Sep 17, 2010
Sold by
Aurora Loan Services Llc
Bought by
Hamerski Ryan and Hamerski Megan
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$503,223
Interest Rate
4.75%
Mortgage Type
FHA
Purchase Details
Closed on
Mar 26, 2010
Sold by
Salcedo Edgardo M and Salcedo Ana M
Bought by
Aurora Loan Services Llc
Purchase Details
Closed on
Jun 3, 2005
Sold by
Nvr Inc
Bought by
Salcedo Edgardo M and Salcedo Ana M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$143,000
Interest Rate
5.83%
Mortgage Type
Stand Alone Second
Purchase Details
Closed on
Feb 25, 2005
Sold by
Monocacy L& Company Llc
Bought by
Nvr Inc
Purchase Details
Closed on
Feb 4, 2005
Sold by
Monocacy L& Company Llc
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Zhu Yun Feng | $920,000 | Landmark Title Services Inc | |
| Annavarapu Lalith Sandeep | $720,027 | Certified Title Corp | |
| Schiller Scott | $649,900 | Westcor Land Title Ins Co | |
| Hamerski Ryan | $510,000 | -- | |
| Aurora Loan Services Llc | $440,926 | -- | |
| Salcedo Edgardo M | $715,000 | -- | |
| Nvr Inc | $139,650 | -- | |
| Nvr Inc | $139,650 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Zhu Yun Feng | $828,000 | |
| Previous Owner | Annavarapu Lalith Sandeep | $638,500 | |
| Previous Owner | Annavarapu Lalith Sandeep | $642,000 | |
| Previous Owner | Annavarapu Lalith Sandeep | $647,000 | |
| Previous Owner | Annavarapu Lalith Sandeep | $648,024 | |
| Previous Owner | Schiller Scott | $368,000 | |
| Previous Owner | Schiller Scott | $417,000 | |
| Previous Owner | Hamerski Ryan | $496,000 | |
| Previous Owner | Hamerski Ryan | $503,223 | |
| Previous Owner | Salcedo Ana M | $664,000 | |
| Previous Owner | Salcedo Ana M | $107,900 | |
| Previous Owner | Salcedo Ana M | $650,000 | |
| Previous Owner | Salcedo Ana M | $87,000 | |
| Previous Owner | Salcedo Edgardo M | $143,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 09/10/2021 09/10/21 | Sold | $920,000 | +0.5% | $152 / Sq Ft |
| 08/03/2021 08/03/21 | Pending | -- | -- | -- |
| 07/29/2021 07/29/21 | For Sale | $915,000 | 0.0% | $151 / Sq Ft |
| 07/28/2021 07/28/21 | Price Changed | $915,000 | +27.1% | $151 / Sq Ft |
| 07/16/2018 07/16/18 | Sold | $720,027 | -5.9% | $124 / Sq Ft |
| 06/23/2018 06/23/18 | Pending | -- | -- | -- |
| 06/06/2018 06/06/18 | For Sale | $764,900 | +17.7% | $131 / Sq Ft |
| 02/28/2014 02/28/14 | Sold | $649,900 | 0.0% | $148 / Sq Ft |
| 01/23/2014 01/23/14 | Pending | -- | -- | -- |
| 01/12/2014 01/12/14 | Price Changed | $649,900 | -3.7% | $148 / Sq Ft |
| 11/01/2013 11/01/13 | For Sale | $674,900 | -- | $154 / 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 | $12,656 | $949,733 | -- | -- |
| 2024 | $12,656 | $886,800 | $201,600 | $685,200 |
| 2023 | $11,524 | $830,200 | $0 | $0 |
| 2022 | $10,831 | $773,600 | $0 | $0 |
| 2021 | $10,180 | $717,000 | $175,800 | $541,200 |
| 2020 | $10,315 | $694,500 | $0 | $0 |
| 2019 | $9,918 | $672,000 | $0 | $0 |
| 2018 | $7,612 | $649,500 | $109,300 | $540,200 |
| 2017 | $8,537 | $649,500 | $0 | $0 |
| 2016 | $7,538 | $573,367 | $0 | $0 |
| 2015 | $7,538 | $535,300 | $0 | $0 |
| 2014 | $7,538 | $520,500 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
-
Buyer's Agent in 2021
Tao Sun
UnionPlus Realty, Inc.
(202) 270-8495
3 in this area
101 Total Sales
-
Seller's Agent in 2018
Stacy Delisle
IMPACT Maryland Real Estate
(301) 646-9625
36 in this area
150 Total Sales
-
Seller Co-Listing Agent in 2018
Josie Medwick
IMPACT Maryland Real Estate
(240) 394-5804
24 Total Sales
-
Buyer's Agent in 2018
Kenneth Grant
Pearson Smith Realty, LLC
(301) 520-1840
14 in this area
243 Total Sales
-
Seller's Agent in 2014
Eric Steinhoff
LPT Realty, LLC
(240) 818-5744
65 in this area
227 Total Sales
Map
Source: Bright MLS
MLS Number: MDFR2002938
APN: 07-237995
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
- 9349 Penrose St
- 3747 Spicebush Dr
- 3904 Sweet Briar Ln
- 3926 Shawfield Ln
- 4006 Belgrave Cir
- 9693 Royal Crest Cir
- 9132 Belvedere Dr
- 3701 Spicebush Way
- 4009 Tottenham Ct
- 3836 Sugarloaf Pkwy
- 3835 Sugarloaf Pkwy
- 3851 Triton Ln
- 3620 Denison St
- 3681 Spring Hollow Dr Unit 3681
- 3506 Connor Place
- 3804 Addison Woods Rd
- 3655 Spring Hollow Dr
- 3623 Spring Hollow Dr Unit 3623
- 9657 Bothwell Ln
- 3648 Holborn Place
- 9219 Shafers Mill Dr
- 9215 Shafers Mill Dr
- 9218 Charterhouse Rd
- 9216 Charterhouse Rd
- 9220 Charterhouse Rd
- 9221 Shafers Mill Dr
- 9213 Shafers Mill Dr
- 9218 Shafers Mill Dr
- 9214 Charterhouse Rd
- 9216 Shafers Mill Dr
- 9220 Shafers Mill Dr
- 9222 Charterhouse Rd
- 9223 Shafers Mill Dr
- 4007 Shafers Mill Ct
- 9212 Charterhouse Rd
- 9224 Charterhouse Rd
- 9221 Charterhouse Rd
- 4005 Shafers Mill Ct
- 9225 Charterhouse Rd
- 9225 Shafers Mill Dr