Ali Haghgoo
EXP Realty, LLC
(410) 999-0791
405 Total Sales
1 in Villages of Urbana
$418,000 Price
4007 Tottenham Ct Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $897,000 - $945,000
5
Beds
3.5
Baths
4,304
Sq Ft
$214/Sq Ft
Est. Value
Highlights
- Gourmet Kitchen
- Dual Staircase
- Premium Lot
- Centerville Elementary Rated A
- Colonial Architecture
- Two Story Ceilings
About This Home
Beautiful SF home barely lived in!5BD,3FB,1HB,2 story natural light filled family room with FP,gour kit. with ctr island,42" Cherry cabinets,grnt counters,pantry,upgraded SS appl,& Ceramic tile,1st flr.office,frt porch,MB w/2 walk-in closets & gorgeous MB,finished walkout basement with plenty of storage & windows & 5th BD with FB.Property backs to woods & located on Cul-de-sac.
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: 06/12/2013
Last Buyer's Agent
(301) 644-1086 chris.reeder@longandfoster.com Long & Foster Real Estate, Inc. License #581222
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,226
Year Built
- Built in 2010
Lot Details
- 9,714 Sq Ft Lot
- Cul-De-Sac
- No Through Street
- Premium Lot
- Open Lot
- Backs to Trees or Woods
- Property is in very good condition
HOA Fees
- $94 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Front Facing Garage
- Garage Door Opener
Home Design
- Colonial Architecture
- Asphalt Roof
- Vinyl Siding
Interior Spaces
- Property has 3 Levels
- Traditional Floor Plan
- Dual Staircase
- Chair Railings
- Crown Molding
- Two Story Ceilings
- Recessed Lighting
- 1 Fireplace
- Heatilator
- Double Pane Windows
- Vinyl Clad Windows
- Window Treatments
- Window Screens
- French Doors
- Six Panel Doors
- Entrance Foyer
- Family Room Off Kitchen
- Living Room
- Dining Room
- Den
- Game Room
- Storage Room
- Wood Flooring
Kitchen
- Gourmet Kitchen
- Breakfast Area or Nook
- Built-In Self-Cleaning Double Oven
- Electric Oven or Range
- Cooktop with Range Hood
- Microwave
- Ice Maker
- Dishwasher
- Kitchen Island
- Upgraded Countertops
- Disposal
Bedrooms and Bathrooms
- 5 Bedrooms
- En-Suite Bathroom
- 3.5 Bathrooms
Laundry
- Laundry Room
- Washer and Dryer Hookup
Finished Basement
- Heated Basement
- Walk-Out Basement
- Rear Basement Entry
- Sump Pump
- Basement with some natural light
Home Security
- Home Security System
- Motion Detectors
- Carbon Monoxide Detectors
- Fire and Smoke Detector
- Fire Sprinkler System
Outdoor Features
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Heat Pump System
- Vented Exhaust Fan
- Natural Gas Water Heater
- High Speed Internet
- Cable TV Available
Listing and Financial Details
- Tax Lot 25373
- Assessor Parcel Number 1107249926
Community Details
Overview
- Association fees include management, insurance, pool(s), road maintenance, reserve funds, snow removal, trash
- Built by ADVANTAGE HOMES
- The Van Buren
- The community has rules related to alterations or architectural changes, building or community restrictions, commercial vehicles not allowed, covenants
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
Closed on
Jul 31, 2015
Sold by
Butler Maceo T and Butler Dianne M
Bought by
Current Estimated Value
Purchase Details
Listed on
Jun 12, 2013
Closed on
Sep 19, 2013
Sold by
Mercado Alfonso R and Mercado Merlina C
Bought by
Butler Maceo T and Butler Dianne M
Seller's Agent
Hilda Ellis
Long & Foster Real Estate, Inc.
Buyer's Agent
Chris Reeder
Long & Foster Real Estate, Inc.
List Price
$545,900
Sold Price
$535,000
Premium/Discount to List
-$10,900
-2%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.28%
Purchase Details
Closed on
Feb 6, 2013
Sold by
Mercado Alfonso R and Mercado Merlina C
Bought by
Mercado Alfonso R and Mercado Merlina C
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$479,290
Interest Rate
3.44%
Mortgage Type
VA
Purchase Details
Closed on
May 13, 2010
Sold by
Urbana Highlands Dev Llc
Bought by
Mercado Alfonso R and Mercado Merlinda C
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$488,860
Interest Rate
5.23%
Mortgage Type
VA
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Villages of Urbana, MD
-
Ali Haghgoo
-
Paul Katrivanos
Paul Katrivanos
RE/MAX Plus
(240) 571-2414
77 Total Sales
1 in Villages of Urbana
$600,000 Price
-
Bob Lucido
Bob Lucido
Keller Williams Lucido Agency
(667) 303-1729
2,561 Total Sales
2 in Villages of Urbana
$555K - $565K Price Range
-
Nawal Tahri-Joutey
Nawal Tahri-Joutey
RE/MAX Realty Group
(240) 474-0834
103 Total Sales
2 in Villages of Urbana
$475K - $660K Price Range
-
Ashleigh Linn
Ashleigh Linn
Sweet Willow Realty
(301) 265-3433
9 Total Sales
1 in Villages of Urbana
$441,000 Price
-
Heather Nahr
Heather Nahr
RE/MAX Plus
(240) 690-5564
57 Total Sales
3 in Villages of Urbana
$453K - $1.1M Price Range
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 |
|---|---|---|---|
| -- | Attorney | ||
| Butler Maceo T | $535,000 | Sage Title Group Llc | |
| Mercado Alfonso R | -- | Genuine Title Llc | |
| Mercado Alfonso R | $488,860 | -- |
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 | $479,290 | ||
| Previous Owner | Mercado Alfonso R | $480,729 | |
| Previous Owner | Mercado Alfonso R | $488,860 |
Source: Public Records
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 | $9,992 | $821,767 | ||
| 2025 | $6,184 | $751,233 | ||
| 2024 | $6,184 | $680,700 | $177,300 | $503,400 |
| 2023 | $8,969 | $637,433 | $0 | $0 |
| 2022 | $8,582 | $594,167 | $0 | $0 |
| 2021 | $8,433 | $550,900 | $150,400 | $400,500 |
| 2020 | $8,433 | $540,633 | $0 | $0 |
| 2019 | $8,273 | $530,367 | $0 | $0 |
| 2018 | $8,190 | $520,100 | $109,400 | $410,700 |
| 2017 | $7,861 | $520,100 | $0 | $0 |
| 2016 | $6,818 | $483,233 | $0 | $0 |
| 2015 | $6,818 | $464,800 | $0 | $0 |
| 2014 | $6,818 | $458,000 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
HE
Seller's Agent in 2013
Hilda Ellis
Long & Foster
-
Chris Reeder
Buyer's Agent in 2013
Chris Reeder
Long & Foster Real Estate, Inc.
(301) 606-8611
8 in this area
1,017 Total Sales
Map
Source: Bright MLS
MLS Number: 1003560320
APN: 07-249926
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
- 9510 Ethan Ridge Dr
- 9693 Royal Crest Cir
- 9651 Bothwell Ln
- 9237 Charterhouse Rd
- 9202 Charterhouse Rd
- 3832 Braveheart Dr
- 3861 Braveheart Dr
- 9813 Notting Hill Dr
- 3938 Addison Woods Rd
- 9754 Wyndham Dr
- 4354 Brubaker Way
- 3848 Sugarloaf Pkwy
- 3844 Sugarloaf Pkwy
- Lot 2, Thompson Driv Thompson Dr
- 9512 Hyde Place
- 3701 Spicebush Way
- 3775 Spicebush Dr
- 3671 Holborn Place
- 9715 Spencer Ln
- 3615 Spring Hollow Ln Unit 3615
- 4011 Tottenham Ct
- 4005 Tottenham Ct
- 9513 Ethan Ridge Dr
- 4003 Tottenham Ct
- 9515 Ethan Ridge Dr
- 0 Tottenham St
- 4101 Tottenham St
- 4001 Tottenham Ct
- 9516 Ethan Ridge Dr
- 9508 Ethan Ridge Dr
- 3964 Mount Nevis Pass
- 3962 Mount Nevis Pass
- 9506 Ethan Ridge Dr
- 9518 Ethan Ridge Dr
- 3965 Mount Nevis Pass
- 9504 Ethan Ridge Dr
- 9695 Royal Crest Cir
- 3960 Mount Nevis Pass
- 9339 Bishopgate Dr
- 9341 Bishopgate Dr
Your Personal Tour Guide
Ask me questions while you tour the home.