NOT LISTED FOR SALE

3934 Addison Woods Rd Frederick, MD 21704

Villages of Urbana Neighborhood

Estimated Value: $577,000 - $612,497

4 Beds
3.5 Baths
2,460 Sq Ft
$242/Sq Ft Est. Value

Last Sold October 08, 2019

Last sale price $409,995 $167 Per Sq Ft

Est. 45% increase in value since last sale

Current estimated payment $4,016/month

3 Days on Market

Highlights

  • Colonial Architecture
  • 1 Fireplace
  • 2 Car Detached Garage
  • Centerville Elementary Rated A
  • Lap or Exercise Community Pool
  • Forced Air Heating and Cooling System

About This Home

As of October 2019

This large, light-filled, end-unit townhome is a quick walk to some great Villages of Urbana amenities: walk to preschool, Centerville Elementary, Urbana Middle/High, several playgrounds and the new resort-style swimming pool and work-out facility! Featuring 3 finished levels of living--including a lower level bedroom, full bath, and recreational/living area. Great gourmet kitchen with stainless steel appliances, a spacious island, and bonus sitting area because of a 3-level 8-foot bump-out! Enjoy the light-filled living room with fireplace. Spacious master bedroom suite with a dual sink vanity--plus two large walk-in closets. Walk-out from the lower level in your private fenced yard with patio!! Enjoy barbequing and morning coffee on your spacious deck. Detached 2-car garage with alley access. Gate in the fence for easy alley access. Play sports or socialize on the nearby green space. This townhome has it all! Don't miss this fantastic home!

Last Agent to Sell the Property

Eric Steinhoff

LPT Realty, LLC License #RS-0038509 Listed on: 08/31/2019

LPT Realty, LLC

Last Buyer's Agent

GORDON YOUNG JR

Compass

Compass

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $4,174

Year Built

  • Built in 2004

Lot Details

  • 3,169

HOA Fees

  • $111 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Architectural Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2,460 Sq Ft Home
  • Property has 3 Levels
  • 1 Fireplace
  • Walk-Out Basement
  • Laundry on lower level

Bedrooms and Bathrooms

Parking

  • 2 Car Detached Garage
  • Rear-Facing Garage
  • Driveway
  • On-Street Parking

Schools

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

Additional Features

  • 3,169 Sq Ft Lot
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Tax Lot 12279
  • Assessor Parcel Number 1107239300

Community Details

Overview

  • Association fees include pool(s), lawn care rear
  • Villages Of Urbana HOA
  • Villages Of Urbana Subdivision
  • Property Manager

Recreation

  • Lap or Exercise Community Pool

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$4,174

Year Built

Built in 2004

Lot Details

0

HOA Fees

$111 per month

Listing Details

  • Property Type: Residential
  • Structure Type: End Of Row/Townhouse
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Exclusions: Shelving in garage
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2019-09-01
  • Year Built: 2004
  • Special Features: None
  • Property Sub Type: Townhouses
  • Stories: 0

Interior Features

  • Fireplaces Count: 1
  • Fireplace: Yes
  • Levels Count: 3+
  • Basement: Yes
  • Basement Type: Walkout Level
  • Laundry Type: Lower Floor
  • Total Sq Ft: 2460
  • Living Area Sq Ft: 2460
  • Price Per Sq Ft: 166.66
  • Above Grade Finished Sq Ft: 2460
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 3934

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, Vinyl Siding
  • Roof: Architectural Shingle
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage: Yes
  • Garage Features: Garage - Rear Entry
  • Number Of Detached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: On Street, Driveway, Detached Garage

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 Fee Includes: Pool(s), Lawn Care Rear
  • HOA Name: VILLAGES OF URBANA
  • HOA: Yes
  • Senior Community: No
  • Community Pool Features: Fenced, Lap/Exercise

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • Elementary School: CENTERVILLE
  • Middle School: URBANA
  • High School: URBANA
  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • School District Key: 121139693024
  • School District Source: Listing Agent
  • Elementary School: CENTERVILLE
  • High School: URBANA
  • Middle Or Junior School: URBANA

Lot Info

  • Land Use Code: 010
  • Lot Size Acres: 0.07
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 3169.00
  • Year Assessed: 2019
  • Zoning: PUD
  • In City Limits: No

Rental Info

  • Vacation Rental: No
  • Property Manager: Yes

Tax Info

  • Tax Annual Amount: 4174.00
  • Assessor Parcel Number: 1107239300
  • Tax Lot: 12279
  • Tax Total Finished Sq Ft: 2460
  • County Tax Payment Frequency: Annually
  • Tax Year: 2018
  • Close Date: 10/08/2019

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 31, 2019
Closed on
Oct 7, 2019
Sold by
Steinhoff Amy S and Steinhoff Eric
Bought by
Ceballos Columna Ricardo A and Aleman Mojica Alexandra
Seller's Agent
Eric Steinhoff
LPT Realty, LLC
Buyer's Agent
GORDON YOUNG JR
Compass
List Price
$409,995
Sold Price
$409,995
Total Days on Market
3
Current Estimated Value
$596,124

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$186,129
Avg. Annual Appreciation
6.82%
Original Mortgage
$320,000
Interest Rate
3.5%
Mortgage Type
New Conventional

Purchase Details

Listed on
May 27, 2016
Closed on
Jul 29, 2016
Sold by
Us Bank National Association
Bought by
Steinhoff Amy S and Steinhoff Eric
Seller's Agent
Sherry Price
RealHome Services and Solutions, Inc.
Buyer's Agent
Non Member Member
Metropolitan Regional Information Systems, Inc.
List Price
$344,500
Sold Price
$316,934
Premium/Discount to List
-$27,566
-8%

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.43%

Purchase Details

Closed on
Feb 19, 2016
Sold by
Connor William and Connor Kathryn E
Bought by
Us Bank National Association

Purchase Details

Closed on
Feb 12, 2007
Sold by
Brown James B and Brown Lauretta Metz
Bought by
Connor William Thomas and Connor Kathryn E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$312,000
Interest Rate
8.92%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jan 19, 2007
Sold by
Brown James B and Brown Lauretta Metz
Bought by
Connor William Thomas and Connor Kathryn E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$312,000
Interest Rate
8.92%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 7, 2004
Sold by
Nvr Inc
Bought by
Brown James B and Brown Lauretta Metz
Source: Public Records

Similar Homes in Frederick, MD

  • 3409 Stone Barn Dr, Frederick, MD 21704

    $570,000

    • 3 Beds
    • 4.5 Baths
    • 1,952 Sq Ft
    • 3409 Stone Barn Dr
    • Frederick, MD

    GORGEOUS PERFECTION! This house shows like a model with beautifully accented walls. *Entry level - Office/4th bedroom with full bath. LVP floors. Garage access.*Upper Level 1: Dining area. Family Room. Updated 1/2 bath. Blanco Quartz countertops. Drawer microwave in the long kitchen island. Stainless-steel farmer's sink. Stainless-steel appliances including the double-oven gas range. Double

    Jeni Spagnoli Pearson Smith Realty, LLC

    Section Image
  • 8473 Randell Ridge Rd, Frederick, MD 21704

    $530,000

    • 3 Beds
    • 3.5 Baths
    • 2,382 Sq Ft
    • 8473 Randell Ridge Rd
    • Frederick, MD

    Welcome home to 8473 Randell Ridge Road! This wonderful 3-level 3 bedroom 3 1/2 bath townhome in the highly desirable Tallyn Ridge neighborhood is ready for you to make it your very own! Stepping into the entry level of your home you'll find your spacious rec room, full bath, and bonus storage area. Making your way to your main level you'll find an open living room, gorgeous kitchen with

    Jim Bass Real Estate Teams, LLC

    Section Image
  • 8456 Randell Ridge Rd, Frederick, MD 21704

    $519,000

    • 3 Beds
    • 3.5 Baths
    • 2,388 Sq Ft
    • 8456 Randell Ridge Rd
    • Frederick, MD

    Welcome home to 8456 Randell Ridge Road! This wonderful 3 bedroom 3 1/2 bathroom three-level townhome, in the highly desirable Tallyn Ridge community, is just waiting for you to make it your very own! Stepping into the lower level of the home, offering 9' ceilings, you will find your main entry foyer, full bath, and spacious rec room. Making your way to your main living level, which also offers

    Jim Bass Real Estate Teams, LLC

    Section Image
  • 2630 Mill Race Rd, Frederick, MD 21701

    $585,000

    • 3 Beds
    • 3.5 Baths
    • 2,647 Sq Ft
    • 2630 Mill Race Rd
    • Frederick, MD

    Located in the Mill Island section of Worman's Mill, this meticulously kept brick front townhome offers over $100,000 of thoughtful timeless updates. Roof and HVAC updated in the last couple of years, taking care of the big ticket items for you. Roof was completed with 50 year architectural shingles and warranty. HVAC system serviced twice annually. Water heater replaced within the last10 years.

    Mary Neubauer Charis Realty Group

    Section Image
  • 2618 Front Shed Dr, Frederick, MD 21702

    $538,361

    • 4 Beds
    • 3.5 Baths
    • 2,167 Sq Ft
    • 2618 Front Shed Dr
    • Frederick, MD

    The Hayward is a 3-story townhome with 4 beds and 3.5 baths. Enter the home on the first floor into a Foyer space with coat closet and access to the Garage. Continue down the hall to a first-floor Guest Suite with ensuite full bath and finished flex space. The main living area is on the second floor and features a Family Room, Kitchen, Dining Area, and Powder Room. The Kitchen features quartz

    Ben Rutt Patriot Realty, LLC

    Section Image
  • 2617 Front Shed Dr, Frederick, MD 21702

    $562,900

    • 4 Beds
    • 3.5 Baths
    • 2,167 Sq Ft
    • 2617 Front Shed Dr
    • Frederick, MD

    This Hayward Traditional is a well-designed three-story townhome end unit with 4 bedrooms and 3.5 bathrooms. On the 1st floor, a welcoming Foyer with a coat closet provides easy access to the garage. Down the hall, a flexible living space and a private Guest Suite with a walk-in closet and ensuite full bath offer an ideal setup for visitors or multi-generational living. The 2nd floor serves as

    Ben Rutt Patriot Realty, LLC

    Section Image
  • 2615 Front Shed Dr, Frederick, MD 21702

    $539,900

    • 4 Beds
    • 3.5 Baths
    • 2,167 Sq Ft
    • 2615 Front Shed Dr
    • Frederick, MD

    This Hayward Farmhouse is a beautifully designed 3-story townhome offering 4 bedrooms and 3.5 bathrooms. Step inside through the welcoming 1st-floor Foyer, featuring a coat closet and direct access to the garage. Down the hall, a versatile Flex Space awaits—ideal for a home office or workout room—along with a private Guest Suite complete with a walk-in closet and ensuite bath. On the 2nd floor,

    Ben Rutt Patriot Realty, LLC

    Section Image
  • 2613 Front Shed Dr, Frederick, MD 21702

    $534,900

    • 4 Beds
    • 3.5 Baths
    • 2,167 Sq Ft
    • 2613 Front Shed Dr
    • Frederick, MD

    This Hayward Traditional is a stunning three-story townhome offering 4 bedrooms and 3.5 bathrooms. Step inside the 1st-floor Foyer, where you'll find a convenient coat closet and direct access to the garage. Down the hall, a Flex Space provides versatility for a home office or workout area. Continue to a private Guest Suite featuring a walk-in closet and ensuite full bath—perfect for visitors or

    Ben Rutt Patriot Realty, LLC

    Section Image
  • 2611 Front Shed Dr, Frederick, MD 21702

    $563,900

    • 4 Beds
    • 3.5 Baths
    • 2,167 Sq Ft
    • 2611 Front Shed Dr
    • Frederick, MD

    This Hayward Heritage is a 3-story townhome end unit offering 4 bedrooms and 3.5 bathrooms with thoughtfully designed spaces. Step into the home through the 1st-floor Foyer, complete with a coat closet and convenient Garage access. Down the hall, you'll find a Flex Space — perfect for a home office or workout room — along with a Guest Suite featuring a walk-in closet and ensuite full bath. The

    Ben Rutt Patriot Realty, LLC

    Section Image
See All Homes in Frederick

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
Ceballos Columna Ricardo A $409,995 Prestige Title & Escrow Llc
Steinhoff Amy S $303,000 Monocacy Title Inc
Us Bank National Association $329,000 Attorney
Connor William Thomas $416,000 --
Connor William Thomas $416,000 --
Brown James B $379,945 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ceballos Ricardo A $287,474
Closed Ceballos Columna Ricardo A $320,000
Previous Owner Connor William Thomas $312,000
Previous Owner Connor William Thomas $312,000
Closed Brown James B --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/08/2019 10/08/19 Sold $409,995 0.0% $167 / Sq Ft
08/31/2019 08/31/19 For Sale $409,995 +29.4% $167 / Sq Ft
08/02/2016 08/02/16 Sold $316,934 -7.3% $134 / Sq Ft
06/17/2016 06/17/16 Price Changed $342,000 -0.7% $144 / Sq Ft
05/27/2016 05/27/16 For Sale $344,500 -- $145 / 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
2024 $6,695 $462,700 $135,000 $327,700
2023 $6,055 $429,033 $0 $0
2022 $5,645 $395,367 $0 $0
2021 $5,304 $361,700 $115,000 $246,700
2020 $5,373 $357,367 $0 $0
2019 $5,300 $353,033 $0 $0
2018 $4,087 $348,700 $65,000 $283,700
2017 $4,877 $348,700 $0 $0
2016 $4,559 $322,167 $0 $0
2015 $4,559 $308,900 $0 $0
2014 $4,559 $306,667 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Eric Steinhoff

    Seller's Agent in 2019

    Eric Steinhoff

    LPT Realty, LLC

    (240) 818-5744

    70 in this area

    243 Total Sales

    Eric Steinhoff
    Section Image
  • GORDON YOUNG JR

    Buyer's Agent in 2019

    GORDON YOUNG JR

    Compass

    (410) 707-7722

    109 Total Sales

    GORDON YOUNG JR
    Section Image

  • S

    Seller's Agent in 2016

    Sherry Price

    RealHome Services and Solutions, Inc.

    (770) 612-7322

    798 Total Sales

    Sherry Price
    Section Image

  • N

    Buyer's Agent in 2016

    Non Member Member

    Metropolitan Regional Information Systems

See All Agents

Map

Source: Bright MLS

MLS Number: MDFR252506

Bright MLS

APN: 07-239300

Maryland Frederick County Frederick 21704 Villages of Urbana

3934 Addison Woods Rd, Frederick, MD

This home is located at 3934 Addison Woods Rd, Frederick, MD 21704 since 31 August 2019 and is currently estimated at $596,124, approximately $242 per square foot. This property was built in 2004. 3934 Addison Woods Rd 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