Weiming Qi
Weichert, REALTORS
(240) 816-3553
52 Total Sales
2 in Villages of Urbana
$453K - $520K Price Range
3727 Singleton Terrace Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $503,000 - $541,000
4
Beds
3.5
Baths
2,416
Sq Ft
$218/Sq Ft
Est. Value
Highlights
- Fitness Center
- Colonial Architecture
- Tennis Courts
- Centerville Elementary Rated A
- Community Pool
- Community Center
About This Home
As of August 2020Back on the market due to buyers' loan falling through! Welcome to this gorgeous Brick front end-unit luxurious townhouse in exclusive Villages of Urbana! This home is truly move-in ready! Freshly-painted throughout in today's colors, this sun-drenched home boasts 4 bedrooms, 3.5 bathrooms, new hardwood floors and carpet, a large master bedroom with en-suite master bath, walk-in closets, and so much more. Updated kitchen with granite counters, new lights and hardware, and many upgrades. Entertain on the main level, featuring a living room, kitchen, and a family room that opens to an expansive deck. The lower level has ceramic tile, and is walk-out level, and opens to a backyard. Enhanced community amenities with parks & swimming pool. Close to shopping, tons of restaurants, 270, blue-ribbon schools, trails & parks.
Last Agent to Sell the Property
Mandy Kaur
(301) 658-6186 mandy.kaur@redfin.com Redfin Corp License #SP98360618 Listed on: 05/24/2020
Last Buyer's Agent
(703) 476-8741 realtortjtaneja@gmail.com e Venture LLC License #0225239483
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
Townhouse Details
Home Type
- Townhome
Est. Annual Taxes
- $3,759
Year Built
- Built in 2003
Lot Details
- 2,815 Sq Ft Lot
- Property is in good condition
HOA Fees
- $111 Monthly HOA Fees
Home Design
- Colonial Architecture
- Brick Exterior Construction
Interior Spaces
- Property has 3 Levels
- Combination Kitchen and Dining Room
Kitchen
- Gas Oven or Range
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Laundry in Basement
Parking
- On-Street Parking
- 2 Assigned Parking Spaces
Schools
- Centerville Elementary School
- Urbana Middle School
- Urbana High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Vented Exhaust Fan
- Natural Gas Water Heater
Listing and Financial Details
- Tax Lot 8055
- Assessor Parcel Number 1107232462
Community Details
Overview
- Villages Of Urba Community
- Villages Of Urbana Subdivision
Amenities
- Picnic Area
- Common Area
- Community Center
Recreation
- Tennis Courts
- Community Basketball Court
- Fitness Center
- 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
May 24, 2020
Closed on
Aug 3, 2020
Sold by
Sankuratri Llc
Bought by
Seller's Agent
Mandy Kaur
Redfin Corp
Buyer's Agent
TJ Taneja
e Venture LLC
List Price
$375,000
Sold Price
$380,000
Premium/Discount to List
$5,000
1.33%
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
$146,718
Avg. Annual Appreciation
5.48%
Original Mortgage
$342,000
Outstanding Balance
$297,107
Interest Rate
3.1%
Mortgage Type
New Conventional
Estimated Equity
$229,611
Purchase Details
Closed on
Apr 24, 2020
Sold by
U S Bank National Association
Bought by
Sankuratri Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$219,600
Interest Rate
3.3%
Mortgage Type
Commercial
Purchase Details
Closed on
Jan 2, 2020
Sold by
Toppert Kurtis Lee and Toppert Sara M
Bought by
U S Bank National Association
Purchase Details
Closed on
Jun 19, 2008
Sold by
Sokhon Nora and Sokhon Chhoura
Bought by
Deutsche Bank National Trust Co
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$305,210
Interest Rate
6.13%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Apr 8, 2008
Sold by
Deutsche Bank National Trust Co
Bought by
Kuppa Krishna and Prasanna Janaswamy
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$305,210
Interest Rate
6.13%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Jun 24, 2003
Sold by
Ausherman Development Corp
Bought by
Sokhon Nora and Sokhon Chhoura
Purchase Details
Closed on
Dec 30, 2002
Sold by
Monocacy Land Company Llc
Bought by
Ausherman Development Corp
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Villages of Urbana, MD
-
Weiming Qi
-
Jay Fleurantin
Jay Fleurantin
Keller Williams Realty Centre
(240) 808-8279
13 Total Sales
1 in Villages of Urbana
$625,000 Price
-
Sharon Ledbetter
Sharon Ledbetter
Weichert, REALTORS
(240) 998-1488
101 Total Sales
2 in Villages of Urbana
$530K - $760K Price Range
-
Lynn Holland
Lynn Holland
RE/MAX Realty Centre, Inc.
(240) 541-5149
98 Total Sales
1 in Villages of Urbana
$543,000 Price
-
Steve Baumgartner
Steve Baumgartner
Compass
(240) 635-9156
63 Total Sales
1 in Villages of Urbana
$840,000 Price
-
Laurie Roberts
Laurie Roberts
CENTURY 21 New Millennium
(301) 835-1824
53 Total Sales
1 in Villages of Urbana
$415,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 |
|---|---|---|---|
| $380,000 | Advantage Settlement Inc | ||
| Sankuratri Llc | $274,620 | Solidifi | |
| U S Bank National Association | $275,120 | None Available | |
| Deutsche Bank National Trust Co | $352,400 | -- | |
| Kuppa Krishna | $310,000 | -- | |
| Sokhon Nora | $287,000 | -- | |
| Ausherman Development Corp | $365,000 | -- |
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 | $342,000 | ||
| Previous Owner | Sankuratri Llc | $219,600 | |
| Previous Owner | Toppert Kurtis | $332,859 | |
| Previous Owner | Toppert Kurtis Lee | $332,859 | |
| Previous Owner | Kuppa Krishna M | $275,614 | |
| Previous Owner | Kuppa Krishna M | $307,914 | |
| Previous Owner | Deutsche Bank National Trust Co | $305,210 | |
| Previous Owner | Kuppa Krishna | $305,210 | |
| Previous Owner | Sokhon Nora | $332,000 | |
| Previous Owner | Sokhon Nora | $62,250 |
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 |
|---|---|---|---|---|
| 08/03/2020 08/03/20 | Sold | $380,000 | +1.3% | $157 / Sq Ft |
| 07/09/2020 07/09/20 | Pending | -- | -- | -- |
| 07/06/2020 07/06/20 | For Sale | $375,000 | 0.0% | $155 / Sq Ft |
| 06/05/2020 06/05/20 | Pending | -- | -- | -- |
| 05/24/2020 05/24/20 | For Sale | $375,000 | 0.0% | $155 / Sq Ft |
| 12/01/2012 12/01/12 | Rented | $1,950 | -11.4% | -- |
| 12/01/2012 12/01/12 | Under Contract | -- | -- | -- |
| 10/25/2012 10/25/12 | For Rent | $2,200 | -- | -- |
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 | $6,095 | $449,267 | ||
| 2025 | $5,781 | $418,233 | ||
| 2024 | $5,781 | $387,200 | $135,000 | $252,200 |
| 2023 | $5,343 | $367,700 | $0 | $0 |
| 2022 | $5,097 | $348,200 | $0 | $0 |
| 2021 | $4,852 | $328,700 | $115,000 | $213,700 |
| 2020 | $4,950 | $321,000 | $0 | $0 |
| 2019 | $4,839 | $313,300 | $0 | $0 |
| 2018 | $3,582 | $305,600 | $65,000 | $240,600 |
| 2017 | $4,454 | $305,600 | $0 | $0 |
| 2016 | $4,132 | $285,733 | $0 | $0 |
| 2015 | $4,132 | $275,800 | $0 | $0 |
| 2014 | $4,132 | $272,400 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Mandy Kaur
MK
Seller's Agent in 2020
Mandy Kaur
Redfin Corp
-
TJ Taneja
TT
Buyer's Agent in 2020
TJ Taneja
e Venture LLC
(571) 379-3939
1 in this area
29 Total Sales
-
Alex Saenger
Seller's Agent in 2015
Alex Saenger
Century 21 New Millennium
(703) 599-7933
90 Total Sales
-
Kenneth Grant
Buyer's Agent in 2015
Kenneth Grant
Pearson Smith Realty, LLC
(301) 520-1840
10 in this area
144 Total Sales
-
EA
Buyer's Agent in 2012
Ed Andrews
Long & Foster
Map
Source: Bright MLS
MLS Number: MDFR264316
APN: 07-232462
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
- 3717 Singleton Terrace
- 3741 Singleton Terrace
- 3844 Sugarloaf Pkwy
- 3701 Spicebush Way
- 3848 Sugarloaf Pkwy
- 3626 Singleton Terrace
- 3544 Winthrop Ln
- 3938 Addison Woods Rd
- 3620 Holborn Place
- 3615 Spring Hollow Ln Unit 3615
- 3612 Byron Cir
- 3775 Spicebush Dr
- 9410 Prospect Hill Place
- 9237 Charterhouse Rd
- 3611 Hope Commons Ct
- 9202 Charterhouse Rd
- 3947 Sweet Briar Ct
- 9212 Landon House Way
- 9200 Landon House Way
- 9171 Landon House Ln
- 3719 Singleton Terrace
- 3715 Singleton Terrace
- 3721 Singleton Terrace
- 3723 Singleton Terrace
- 3713 Singleton Terrace
- 3725 Singleton Terrace
- 3711 Singleton Terrace
- 3709 Singleton Terrace
- 3600 Hartwick Ln
- 3602 Hartwick Ln
- 3707 Singleton Terrace
- 3604 Hartwick Ln
- 3705 Singleton Terrace
- 3716 Singleton Terrace
- 3714 Singleton Terrace
- 3718 Singleton Terrace
- 3606 Hartwick Ln
- 3720 Singleton Terrace
- 3703 Singleton Terrace
- 3712 Singleton Terrace
Your Personal Tour Guide
Ask me questions while you tour the home.