NOT LISTED FOR SALE

3717 Singleton Terrace Frederick, MD 21704

Villages of Urbana Neighborhood

Estimated Value: $525,000 - $565,847

4 Beds
3.5 Baths
2,528 Sq Ft
$214/Sq Ft Est. Value

Last Sold July 31, 2019

Last sale price $370,000 $146 Per Sq Ft

Est. 46% increase in value since last sale

Current estimated payment $3,590/month

1 Day on Market

Highlights

  • Gourmet Kitchen
  • Clubhouse
  • Wood Flooring
  • Centerville Elementary Rated A
  • Deck
  • Community Pool

About This Home

As of July 2019

Don't miss this completely upgraded model from the well-built Ausherman homes! At over 2400 sq ft, This home offers a large open floor plan, huge master-suite with bump out on each level, and fully finished basement. The 4 bed 3.5 bath home boasts hardwood floors on the main and bedroom level, granite, a large kitchen island, and a spacious deck. The custom gourmet kitchen is one-of-a-kind in the coveted Villages of Urbana. This is a great opportunity to own a home in Blue Ribbon - Awarded, Urbana School District. Enjoy all The Villages of Urbana has to offer with walking/biking trails, shops, restaurants, community pools, and multiple playgrounds/parks. This prime, North-facing location provides a great community atmosphere with easy access to major commuter routes to Washington DC or Baltimore. You are also only minutes away from The Clarksburg Outlets and Historic Downtown Frederick.

Last Agent to Sell the Property

Troyce Gatewood

Real Broker, LLC - Frederick Listed on: 06/17/2019

Last Buyer's Agent

Amber Williams

Sweet Homes America Incorporated License #0225216413

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $3,648

Year Built

  • Built in 2002

Lot Details

  • 2,100 Sq Ft Lot
  • Property is in very good condition

HOA Fees

  • $111 Monthly HOA Fees

Home Design

  • Brick Exterior Construction

Interior Spaces

  • Property has 3 Levels
  • Family Room
  • Living Room
  • Breakfast Room
  • Den
  • Wood Flooring
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Gourmet Kitchen
  • Kitchen Island

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom

Parking

  • 2 Open Parking Spaces
  • 2 Parking Spaces
  • Parking Lot

Schools

  • Centerville Elementary School
  • Urbana Middle School
  • Urbana High School

Additional Features

  • Deck
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Tax Lot 8098
  • Assessor Parcel Number 1107232632

Community Details

Overview

  • $1,101 Capital Contribution Fee
  • Association fees include common area maintenance, pool(s), recreation facility
  • Villages Of Urbana HOA
  • Built by Ausherman
  • Villages Of Urba Community
  • Villages Of Urbana Subdivision

Amenities

  • Picnic Area
  • Clubhouse
  • Community Center

Recreation

  • Tennis Courts
  • Community Basketball Court
  • Community Playground
  • Community Pool
  • Bike Trail

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$3,648

Year Built

Built in 2002

Lot Details

0

HOA Fees

$111 per month

Listing Details

  • Property Type: Residential
  • Structure Type: Interior Row/Townhouse
  • Ownership: Fee Simple
  • Home Warranty: No
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2019-06-17
  • Federal Flood Zone: No
  • Year Built: 2002
  • Remarks Public: Don't miss this completely upgraded model from the well-built Ausherman homes! At over 2400 sq ft, This home offers a large open floor plan, huge master-suite with bump out on each level, and fully finished basement. The 4 bed 3.5 bath home boasts hardwood floors on the main and bedroom level, granite, a large kitchen island, and a spacious deck. The custom gourmet kitchen is one-of-a-kind in the coveted Villages of Urbana. This is a great opportunity to own a home in Blue Ribbon - Awarded, Urbana School District. Enjoy all The Villages of Urbana has to offer with walking/biking trails, shops, restaurants, community pools, and multiple playgrounds/parks. This prime, North-facing location provides a great community atmosphere with easy access to major commuter routes to Washington DC or Baltimore. You are also only minutes away from The Clarksburg Outlets and Historic Downtown Frederick.
  • Special Features: VirtualTour
  • Property Sub Type: Townhouses

Interior Features

  • Flooring Type: Hardwood
  • Interior Amenities: Kitchen - Gourmet, Kitchen - Island, Wood Floors
  • Fireplace: No
  • Levels Count: 3+
  • Room List: Living Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Den, Breakfast Room, Bathroom 2, Bathroom 3, Primary Bathroom, Half Bath
  • Basement: Yes
  • Basement Type: Full, Fully Finished
  • Total Sq Ft: 2528
  • Living Area Sq Ft: 2528
  • Price Per Sq Ft: 219.19
  • Above Grade Finished Sq Ft: 1688
  • Below Grade Finished Sq Ft: 840
  • Total Below Grade Sq Ft: 840
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 3717

Beds/Baths

  • Bedrooms: 4
  • All Lower Level Bedrooms: 1
  • Lower Level Bedroom: 1
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Upper Level Full Bathrooms: 2
  • Lower Level Full Bathrooms: 1
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Brick
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage: No
  • Open Parking Spaces Count: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Parking Lot

Utilities

  • Refuse: 88.00
  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 111.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Basketball Courts, Bike Trail, Club House, Community Center, Picnic Area, Pool - Outdoor, Tennis Courts, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Common Area Maintenance, Pool(s), Recreation Facility
  • HOA Name: VILLAGES OF URBANA
  • HOA: Yes
  • Senior Community: No

Fee Information

  • Capital Contribution Fee: 1101.09

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • Elementary School: CENTERVILLE
  • Middle School: URBANA
  • High School: URBANA
  • Elementary School Source: 3rd Party
  • High School Source: 3rd Party
  • Middle School Source: 3rd Party
  • School District Key: 121139693024
  • School District Source: 3rd Party
  • Elementary School: CENTERVILLE
  • High School: URBANA
  • Middle Or Junior School: URBANA

Green Features

  • Clean Green Assessed: No

Lot Info

  • Improvement Assessed Value: 211600.00
  • Land Assessed Value: 115000.00
  • Land Use Code: 010
  • Lot Size Acres: 0.05
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 2100.00
  • Outdoor Living Structures: Deck(s)
  • Property Condition: Very Good
  • Year Assessed: 2019
  • Zoning: PUD
  • In City Limits: No

Building Info

  • Builder Name: Ausherman

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11574955
  • Tax Annual Amount: 3648.00
  • Assessor Parcel Number: 1107232632
  • Tax Lot: 8098
  • Tax Total Finished Sq Ft: 2388
  • County Tax Payment Frequency: Annually
  • Tax Year: 2018
  • Close Date: 07/31/2019

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Nov 23, 2020
Sold by
Wenzler Melissa Altieri and Wenzler Patrick J
Bought by
Wenzler Melissa Altieri and Wenzler Patrick Jordan
Current Estimated Value
$541,962

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$358,841
Outstanding Balance
$323,187
Interest Rate
2.71%
Mortgage Type
FHA
Estimated Equity
$215,735

Purchase Details

Listed on
Jun 17, 2019
Closed on
Jul 30, 2019
Sold by
Dhima Mihallaq and Dhima Brunilda
Bought by
Altieri Melissa C and Wenzler Patrick J
Seller's Agent
Troyce Gatewood
Real Broker, LLC - Frederick
Buyer's Agent
Amber Williams
Sweet Homes America Incorporated
List Price
$370,000
Sold Price
$370,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.42%
Original Mortgage
$363,298
Interest Rate
3.62%
Mortgage Type
FHA

Purchase Details

Closed on
Dec 11, 2002
Sold by
Ausherman Development Corp
Bought by
Dhima Mihallaq and Dhima Brunilda
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Wenzler Melissa Altieri -- Accommodation
Altieri Melissa C $370,000 Strategic Natl Ttl Group Llc
Dhima Mihallaq $228,850 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Wenzler Melissa Altieri $358,841
Closed Altieri Melissa C $363,298
Previous Owner Dhima Mihallaq $100,000
Previous Owner Dhima Mihallaq $125,000
Previous Owner Dhima Mihallaq $100,000
Closed Dhima Mihallaq --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/31/2019 07/31/19 Sold $370,000 0.0% $146 / Sq Ft
06/19/2019 06/19/19 Pending -- -- --
06/17/2019 06/17/19 For Sale $370,000 -- $146 / Sq Ft
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

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 $6,128 $454,133 -- --
2024 $6,128 $415,900 $135,000 $280,900
2023 $5,557 $386,133 $0 $0
2022 $5,192 $356,367 $0 $0
2021 $4,877 $326,600 $115,000 $211,600
2020 $4,972 $319,000 $0 $0
2019 $4,816 $311,400 $0 $0
2018 $3,561 $303,800 $65,000 $238,800
2017 $4,436 $303,800 $0 $0
2016 $3,926 $284,200 $0 $0
2015 $3,926 $274,400 $0 $0
2014 $3,926 $265,567 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Troyce Gatewood

    Seller's Agent in 2019

    Troyce Gatewood

    Real Broker, LLC - Frederick

    (301) 329-6193

    33 in this area

    1,056 Total Sales

    Section Image
  • Amber Williams

    Buyer's Agent in 2019

    Amber Williams

    Sweet Homes America Incorporated

    (703) 944-3884

    50 Total Sales

    Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR245830

Bright MLS

APN: 07-232632

Maryland Frederick County Frederick 21704 Villages of Urbana

3717 Singleton Terrace, Frederick, MD

This home is located at 3717 Singleton Terrace, Frederick, MD 21704 since 17 June 2019 and is currently estimated at $541,962, approximately $214 per square foot. This property was built in 2002. 3717 Singleton Terrace is a home located in Frederick County with nearby schools including Centerville Elementary, Urbana Middle School, and Urbana High School.

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.

Bright MLS 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