NOT LISTED FOR SALE

4005 Wyndham Way Frederick, MD 21704

Villages of Urbana Neighborhood

Estimated Value: $883,000 - $937,000

4 Beds
2.5 Baths
3,822 Sq Ft
$236/Sq Ft Est. Value

Sale Details

Date Sold: June 29, 2012

Last sale price $487,000 $127 Per Sq Ft

Est. 85% increase in value since last sale

Current estimated payment $5,843 / mo

6 Days on Market

Highlights

  • Fitness Center
  • Gourmet Kitchen
  • Colonial Architecture
  • Centerville Elementary Rated A
  • Open Floorplan
  • Clubhouse

About This Home

As of June 2012

Spacious & inviting 4 BR, 2.5 BA brick-front Victoria model Ryan home in the new section of Villages of Urbana.Gourmet Kitch w/ granite, ss appliances, dbl wall ovens, island/brkfst bar. Lrg FR w/ stone gas FP. Formal DR & LR. Sunny morning room. Finished lower level. 4 sizable BR's on upper level. Composite deck, patio, front porch, 2 car gar & upgrades galore!

Last Agent to Sell the Property

Elaine Koch

(301) 615-3000 elaine@elainekoch.com TTR Sotheby's International Realty Listed on: 04/09/2012

TTR Sotheby's International Realty

Last Buyer's Agent

Jitendrakumar Mehta

globex56@yahoo.com Globex Realty Inc. License #MRIS:3007362

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,181

Year Built

  • Built in 2009

Lot Details

  • 8,820 Sq Ft Lot
  • Back Yard Fenced
  • Landscaped
  • Property is in very good condition

HOA Fees

  • $95 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Colonial Architecture
  • Brick Front

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Chair Railings
  • Crown Molding
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Recessed Lighting
  • Fireplace With Glass Doors
  • Palladian Windows
  • French Doors
  • Six Panel Doors
  • Entrance Foyer
  • Family Room Off Kitchen
  • Living Room
  • Dining Room
  • Storage Room
  • Wood Flooring
  • Partially Finished Basement
  • Space For Rooms
  • Attic

Kitchen

  • Gourmet Kitchen
  • Breakfast Room
  • Built-In Double Oven
  • Cooktop
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom
  • 2.5 Bathrooms

Laundry

  • Laundry Room
  • Front Loading Dryer
  • Front Loading Washer

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Vented Exhaust Fan
  • Programmable Thermostat
  • Electric Water Heater
  • Cable TV Available

Additional Features

  • Garage doors are at least 85 inches wide
  • Energy-Efficient Appliances

Listing and Financial Details

  • Tax Lot 20097
  • Assessor Parcel Number 1107252250

Community Details

Overview

  • Association fees include management, insurance, pool(s), snow removal, trash
  • Built by RYAN
  • Villages Of Urbana Subdivision, Victoria Floorplan

Amenities

  • Common Area
  • Clubhouse
  • Community Center

Recreation

  • Tennis Courts
  • Community Playground
  • Fitness Center
  • Community Pool
  • Jogging Path
  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,181

Year Built

Built in 2009

Lot Details

8,820 Sq Ft Lot

HOA Fees

$95 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Accessibility Features: >84" Garage Door
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Lower 2, Main, Upper 1, Upper 2
  • Year Built: 2009
  • Special Assessment Payment: Annually
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Washer/Dryer Hookups Only, Cooktop, Dishwasher, Disposal, Dryer - Front Loading, Energy Efficient Appliances, Exhaust Fan, Icemaker, Microwave, Oven - Double, Oven - Wall, Refrigerator, Washer - Front Loading
  • Interior Amenities: Breakfast Area, Family Room Off Kitchen, Kitchen - Gourmet, Kitchen - Island, Dining Area, Primary Bath(s), Chair Railings, Crown Moldings, Upgraded Countertops, Wood Floors, Recessed Lighting, Floor Plan - Open
  • Window Features: Palladian
  • Fireplace Features: Fireplace - Glass Doors
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Door Features: French, Six Panel
  • Wall Ceiling Types: 9'+ Ceilings, Dry Wall
  • Entry Location: Foyer
  • Levels Count: 3+
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Foyer, Breakfast Room, Laundry, Storage Room, Attic
  • Basement: Yes
  • Basement Type: Partially Finished, Space For Rooms
  • Living Area Units: Square Feet
  • Total Sq Ft: 4528
  • Living Area Sq Ft: 3822
  • Price Per Sq Ft: 168.32
  • Above Grade Finished Sq Ft: 2970
  • Below Grade Finished Sq Ft: 852
  • Below Grade Sq Ft: 706
  • Total Below Grade Sq Ft: 1558
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Combination, Brick, Brick Front
  • Exterior Features: Sidewalks, Street Lights
  • Pool Private: No
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Garage, Asphalt Driveway, Asphalt Driveway
  • Garage Features: Garage - Front Entry, Garage Door Opener
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Driveway, Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Ceiling Fan(s), Central A/C, Programmable Thermostat
  • Cooling: Yes
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air, Programmable Thermostat
  • Heating: Yes
  • Hot Water: Electric
  • Security: Main Entrance Lock, Smoke Detector, Security System
  • Sewer/Septic System: Public Sewer
  • Utilities: Cable Tv Available
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 95.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Bike Trail, Club House, Common Grounds, Community Center, Exercise Room, Jog/Walk Path, Pool - Outdoor, Tennis Courts, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Management, Insurance, Pool(s), Snow Removal, Trash
  • HOA: Yes

Lot Info

  • Fencing: Rear
  • Improvement Assessed Value: 321300.00
  • Land Assessed Value: 119300.00
  • Lot Features: Landscaping
  • Lot Size Acres: 0.20
  • Lot Size Area: 8820
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 8820.00
  • Outdoor Living Structures: Deck(s), Patio(s), Porch(es)
  • Property Attached Yn: No
  • Property Condition: Very Good

Building Info

  • Builder Name: RYAN

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11585548
  • Tax Annual Amount: 5181.46
  • Assessor Parcel Number: 1107252250
  • Tax Lot: 20097
  • Tax Year: 2011

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
Apr 9, 2012
Closed on
Jun 29, 2012
Sold by
Bought by
Seller's Agent
Elaine Koch
TTR Sotheby's International Realty
Buyer's Agent
Jitendrakumar Mehta
Globex Realty Inc.
List Price
$499,900
Sold Price
$487,000
Premium/Discount to List
-$12,900
-2.58%
Current Estimated Value
$902,069

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$415,069
Avg. Annual Appreciation
4.48%
Original Mortgage
$389,600
Interest Rate
0.0376%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 29, 2009
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$308,959
Interest Rate
0.0493%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

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
$487,000 Excalibur Title & Escrow Llc
$479,530 --
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 $262,000
Closed $265,000
Closed $300,000
Closed $377,000
Closed $387,400
Closed $389,600
Previous Owner $308,959
Previous Owner $308,959
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/29/2012 06/29/12 Sold $487,000 -2.6% $127 / Sq Ft
04/15/2012 04/15/12 Pending -- -- --
04/09/2012 04/09/12 For Sale $499,900 -- $131 / 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 $9,998 $720,000
2024 $9,998 $667,300 $201,900 $465,400
2023 $9,130 $624,133 $0 $0
2022 $8,594 $580,967 $0 $0
2021 $8,224 $537,800 $175,800 $362,000
2020 $8,224 $522,667 $0 $0
2019 $8,008 $507,533 $0 $0
2018 $7,865 $492,400 $109,300 $383,100
2017 $7,631 $492,400 $0 $0
2016 $6,951 $471,333 $0 $0
2015 $6,951 $460,800 $0 $0
2014 $6,951 $454,067 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Elaine Koch

    Seller's Agent in 2012

    Elaine Koch

    TTR Sotheby's International Realty

    (301) 840-7320

    2 in this area

    231 Total Sales

    Elaine Koch
    Section Image

  • J

    Buyer's Agent in 2012

    Jitendrakumar Mehta

    Globex Realty Inc.

See All Agents

Map

Source: Bright MLS

MLS Number: 1004483423

Bright MLS

APN: 07-252250

Maryland Frederick County Frederick 21704 Villages of Urbana

4005 Wyndham Way, Frederick, MD

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 2026 Bright MLS, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.