NOT LISTED FOR SALE

Estimated Value: $962,000 - $1,053,000

5 Beds
4.5 Baths
5,345 Sq Ft
$191/Sq Ft Est. Value

Last Sold December 19, 2023

Last sale price $985,000 $184 Per Sq Ft

Est. 3% increase in value since last sale

Current estimated payment $6,862/month

5 Days on Market

Highlights

  • Home Theater
  • Eat-In Gourmet Kitchen
  • Dual Staircase
  • Centerville Elementary Rated A
  • Open Floorplan
  • Colonial Architecture

About This Home

As of December 2023

Step into a world of luxurious living in this stunning 5 bedrooms, 5 bath brick home that is perfectly situated in the highly sought after Urbana Schools district. Offering over 5,345 square feet of beautifully designed living space, this home showcases an array of exceptional features that promise a lifestyle of ultimate comfort and elegance.
As you walk through the front door, your eyes are immediately drawn to the stunning hardwood floors that seamlessly connect each room in the expansive, open floor plan. Once in, you will find the formal living room, dining room and den. The private study/office which takes full advantage of the sunlight coming in through the surrounding windows is followed by the family room with it's cozy fireplace, providing warmth and comfort on chilly evening.
Next you will fall in love with the spacious open layout of the family room, open gourmet kitchen, and sun-filled morning room .Connecting the kitchen to the outdoors is an exquisite 3 season room with deck that has connecting stairs leading to the lower level patio and allows you to take full advantage of this private lot that backs to woods.
The second floor features the Primary Bedroom with tray ceiling , sitting area, 2 walk-in closets and a large Jacuzzi soaking tub and separate shower, along with 4 large bedrooms and 2 sets of Jack & Jill Bathrooms.
Now onto the lower level with it's open entry to the basement that features a gas fireplace, a bar with built-in refrigerator and storage which is perfect for entertaining or having friends over to watch football or shoot some pool. There is a separate room so you can workout in your personal gym or perfect for at-home yoga studio as well. The finished basement space also includes a large theater room, a full bath and potentially a 6th bedroom .
This meticulously well maintained home has a wealth of improvements that includes new carpet on the second floor, newly painted rooms, newer windows, Bosch refrigerator with ice maker ,Jenn Air gas stove with built in vent and the driveway was just sealed and garage floor painted .
This dream home and the wonderful array of amenities the Villages of Urbana has to offer such as
3 pools, a gym, 3 clubhouses, tennis, pickle ball, playground, picnic area and fun events with neighborhood activities will allow you and your family to enjoy the life you have always dreamed of!!
I almost forgot to mention the easy access to shopping, dining, and all of the great features of Downtown Frederick plus convenient access to major commuter routes. Ready to make your dreams come true?!!

Last Listed By

Joanna Brown

Keller Williams Realty Centre Listed on: 11/17/2023

Keller Williams Realty Centre

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,924

Year Built

  • Built in 2004

Lot Details

  • 10,378 Sq Ft Lot
  • Private Lot
  • Backs to Trees or Woods

HOA Fees

  • $127 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Brick Foundation
  • Asphalt Roof

Interior Spaces

  • Property has 2.5 Levels
  • Open Floorplan
  • Dual Staircase
  • Bar
  • Chair Railings
  • Crown Molding
  • Tray Ceiling
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Fireplace With Glass Doors
  • Window Treatments
  • Entrance Foyer
  • Family Room Off Kitchen
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Home Theater
  • Den
  • Game Room
  • Sun or Florida Room
  • Screened Porch
  • Home Gym
  • Carpet
  • Intercom
  • Laundry Room
  • Basement

Kitchen

  • Eat-In Gourmet Kitchen
  • Butlers Pantry
  • Built-In Double Oven
  • Down Draft Cooktop
  • Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Upgraded Countertops
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Walk-In Closet
  • Whirlpool Bathtub
  • Bathtub with Shower

Utilities

  • Humidifier
  • Forced Air Zoned Heating and Cooling System
  • Vented Exhaust Fan
  • Water Dispenser
  • Natural Gas Water Heater
  • Multiple Phone Lines
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 9011
  • Assessor Parcel Number 1107235461

Community Details

Overview

  • Built by M/I HOMES
  • Villages Of Urbana Subdivision, Exquisite Floorplan
  • Villages Of Urba Community

Recreation

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

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,924

Year Built

Built in 2004

Lot Details

0

HOA Fees

$127 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2023-11-30
  • Year Built: 2004
  • Automatically Close On Close Date: No
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Appliances: Cooktop - Down Draft, Dishwasher, Disposal, Exhaust Fan, Humidifier, Icemaker, Intercom, Microwave, Oven - Double, Oven - Wall, Refrigerator, Water Dispenser, Stainless Steel Appliances
  • Interior Amenities: Upgraded Countertops, Primary Bath(s), Window Treatments, Whirlpool/Hottub, Floor Plan - Open, Double/Dual Staircase, Formal/Separate Dining Room, Intercom, Kitchen - Eat-In, Pantry, Butlers Pantry, Bar, Carpet, Ceiling Fan(s), Chair Railings, Crown Moldings, Dining Area, Family Room Off Kitchen, Kitchen - Table Space, Kitchen - Gourmet, Recessed Lighting, Soaking Tub, Store/Office, Tub Shower, Walk-In Closet(s)
  • Fireplace Features: Fireplace - Glass Doors
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Wall Ceiling Types: 9'+ Ceilings, Cathedral Ceilings, Dry Wall, Tray Ceilings
  • Foundation Details: Brick/Mortar
  • Levels Count: 2.5
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Game Room, Family Room, Den, Basement, Foyer, Breakfast Room, Sun/Florida Room, Exercise Room, Laundry, Office, Media Room, Bathroom 1, Bathroom 2, Bathroom 3, Primary Bathroom, Half Bath, Screened Porch
  • Basement: Yes
  • Total Sq Ft: 7414
  • Living Area Sq Ft: 5345
  • Price Per Sq Ft: 193.17
  • Above Grade Finished Sq Ft: 4892
  • Below Grade Finished Sq Ft: 453
  • Below Grade Sq Ft: 2069
  • Total Below Grade Sq Ft: 2522
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 9315

Beds/Baths

  • Bedrooms: 5
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 3
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 3.00
  • Lower Levels Bathrooms: 1.00
  • Upper Level Full Bathrooms: 3
  • 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: Combination, Brick
  • Roof: Asphalt
  • 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: Asphalt Driveway, Private
  • Garage Features: Garage Door Opener
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air, Humidifier, Zoned
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Utilities: Cable Tv Available, Multiple Phone Lines
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 127.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Bike Trail, Jog/Walk Path, Pool - Outdoor, Tennis Courts, Tot Lots/Playground
  • HOA: Yes
  • Senior Community: No

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • School District Key: 121139693024
  • School District Source: Listing Agent

Lot Info

  • Horses: No
  • Land Use Code: R
  • Lot Features: Backs To Trees, Private
  • Lot Size Acres: 0.24
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 10378.00
  • Year Assessed: 2023
  • Zoning: R
  • In City Limits: No

Building Info

  • Builder Name: M/I HOMES

Rental Info

  • Pets: No Pet Restrictions
  • Pets Allowed: Yes
  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 8924.00
  • Assessor Parcel Number: 1107235461
  • Tax Lot: 9011
  • Tax Total Finished Sq Ft: 5345
  • County Tax Payment Frequency: Annually
  • Tax Year: 2022
  • Close Date: 12/19/2023

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 17, 2023
Closed on
Dec 19, 2023
Sold by
Lambert James Vincent and Saah-Lambert Sahar
Bought by
Riley Derrick C and Riley Kristen D
Seller's Agent
Joanna Brown
Keller Williams Realty Centre
Buyer's Agent
Donna Gibson
Berkshire Hathaway HomeServices PenFed Realty
List Price
$945,000
Sold Price
$985,000
Premium/Discount to List
$40,000
4.23%
Total Days on Market
5
Views
158
Current Estimated Value
$1,019,049

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$34,049
Avg. Annual Appreciation
4.12%
Original Mortgage
$886,500
Interest Rate
7.44%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 6, 2006
Sold by
Hahne Robert E
Bought by
Lambert James Vincent and Saa Sahar

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
6.71%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Aug 30, 2006
Sold by
Hahne Robert E
Bought by
Lambert James Vincent and Saa Sahar

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
6.71%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Apr 5, 2004
Sold by
M/I Homes Of Dc Llc
Bought by
Hahne Robert E and Bozinko Susan M

Purchase Details

Closed on
Dec 30, 2003
Sold by
M/I Homes Of Dc Llc
Bought by
Hahne Robert E and Bozinko Susan M

Purchase Details

Closed on
Sep 29, 2003
Sold by
Monocacy Land Company Llc
Bought by
M/I Homes Of D C L L C

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
Riley Derrick C $985,000 Classic Settlements
Lambert James Vincent $835,000 --
Lambert James Vincent $835,000 --
Hahne Robert E $689,261 --
Hahne Robert E $689,261 --
M/I Homes Of D C L L C $292,378 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Riley Derrick $922,195
Closed Riley Derrick C $886,500
Previous Owner Lambert James Vincent $100,000
Previous Owner Lambert James Vincent $650,000
Previous Owner Lambert James Vincent $650,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/19/2023 12/19/23 Sold $985,000 +4.2% $184 / Sq Ft
11/25/2023 11/25/23 For Sale $945,000 -4.1% $177 / Sq Ft
11/23/2023 11/23/23 Off Market $985,000 -- --
11/22/2023 11/22/23 Pending -- -- --
11/17/2023 11/17/23 For Sale $945,000 -- $177 / 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 $12,564 $879,200 $202,600 $676,600
2023 $11,409 $820,333 $0 $0
2022 $10,690 $761,467 $0 $0
2021 $10,140 $702,600 $176,000 $526,600
2020 $10,140 $687,633 $0 $0
2019 $9,926 $672,667 $0 $0
2018 $9,802 $657,700 $109,500 $548,200
2017 $9,480 $657,700 $0 $0
2016 $8,212 $624,433 $0 $0
2015 $8,212 $607,800 $0 $0
2014 $8,212 $588,133 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in Frederick, MD

  • 1807 Colt Ln, Frederick, MD 21702

    $1,100,671

    • 6 Beds
    • 4.5 Baths
    • 5,587 Sq Ft
    • 1807 Colt Ln
    • Frederick, MD

    Key Features: Open-concept main living area includes the Kitchen, Family Room, and Breakfast Area // 2-story Family Room with wall-of-windows and gas fireplace // Kitchen features a large eat-in island with quartz countertops, gas range, stainless steel appliances, and soft-close cabinetry // 1st-floor Guest Suite with ensuite full bath // 2 stair cases leading to the second floor // Owner's

    Ben Rutt Patriot Realty, LLC

    Section Image
  • 3701 Spicebush Way, Frederick, MD 21704

    $1,150,000

    • 5 Beds
    • 4.5 Baths
    • 5,325 Sq Ft
    • 3701 Spicebush Way
    • Frederick, MD

    Beautiful Brick-Front single family home situated in the corner lot with side loaded 2 car garage, in the sought of Villages of Urbana. Former model home, featuring 5 bedrooms (potentially 8 bedrooms), 4.5 bathrooms, gourmet kitchen with granite countertops & designer backsplashes, large center island, stainless steel appliances, and 42 inch cherry cabinets. Windows have been updated with most

    LINH HANG Excel Realty Corp.

    Section Image
  • 3608 John Simmons Ct, Frederick, MD 21704

    $1,065,000

    • 5 Beds
    • 4.5 Baths
    • 5,178 Sq Ft
    • 3608 John Simmons Ct
    • Frederick, MD

    This stately NV home is ideally located at the end of a cul-de-sac on a premium lot backing to trees. The beautifully landscaped backyard features a terraced design with a stone patio, retaining wall, and a spacious, low-maintenance deck. A large side yard with a playset adds to the outdoor appeal. Enjoy breathtaking views on this expansive 0.43-acre lot—one of the largest in the community!

    Lisa Giuliani Keller Williams Realty Centre

    Section Image
  • 3971 Triton St, Frederick, MD 21704

    $780,000

    • 4 Beds
    • 4 Baths
    • 2,304 Sq Ft
    • 3971 Triton St
    • Frederick, MD

    Delightful colonial on a quiet street in the desirable Villages of Urbana!This immaculate, move-in-ready home features an updated kitchen that opens to a sunny morning room, leading to a spacious deck and patio added in 2020 — perfect for outdoor living and entertaining. A cozy family room is conveniently located just off the kitchen. Upstairs offers four bedrooms, including a spacious owner’s

    Lisa Giuliani Keller Williams Realty Centre

    Section Image
  • 9126 Travener Cir, Frederick, MD 21704

    $900,000

    • 5 Beds
    • 4.5 Baths
    • 5,430 Sq Ft
    • 9126 Travener Cir
    • Frederick, MD

    Welcome Home to this spectacular Colonial in the Villages of Urbana! This home features over 5400 finished square feet of living space with 5 bedrooms and 4.5 bathrooms. Three fully finished levels with 9-foot ceilings throughout. Fall in love with your new home today. This has everything that you need, a large master suite with jet-tub, 2nd bedroom with its own private bathroom and two more

    Drew Hutchison Witz Realty, LLC

    Section Image
  • 4108 Brushfield Dr, Frederick, MD 21704

    $1,050,000

    • 4 Beds
    • 4.5 Baths
    • 4,900 Sq Ft
    • 4108 Brushfield Dr
    • Frederick, MD

    This is the one you’ve been waiting for…Urbana living at its finest, 4108 Brushfield Drive! Welcome to this stunning 4-bedroom, 4 full and 1 half bath home, located in the highly sought-after Urbana community! This beautifully designed home offers a perfect blend of luxury, functionality, and style, with a host of premium features that will suit a variety of lifestyles. Step inside to find a

    Stacy Delisle IMPACT Maryland Real Estate

    Section Image
  • 3015 Herb Garden Dr, Frederick, MD 21704

    $975,000

    • 3 Beds
    • 4 Baths
    • 3,832 Sq Ft
    • 3015 Herb Garden Dr
    • Frederick, MD

    Welcome home to this stunning NV model on the best lot in the Woodlands, Urbana’s premiere 55 Plus Community! Nestled on a beautiful lot that backs to privacy and great views--this lovely NV Clarkson model provides a private retreat for you to relax and unwind. The covered front porch is perfect for sitting and enjoying the greenery and blooms at the nearby Herb Garden. Inside the home, you’ll

    Eric Steinhoff LPT Realty, LLC

    Section Image
  • 3637 Red Sage Way N, Frederick, MD 21704

    $1,099,995

    • 4 Beds
    • 4.5 Baths
    • 4,980 Sq Ft
    • 3637 Red Sage Way N
    • Frederick, MD

    This beautiful NV home is one of the newest homes in the Villages of Urbana and is located in the highly sought-after Stonebarn Village section of the Villages. This home has been meticulously maintained–so all that you have to do is move in! With 4 bedrooms, 4 and a half baths and on-trend modern features, this is a great opportunity to own a fantastic home–close to all the amenities of this

    Eric Steinhoff LPT Realty, LLC

    Section Image
  • 2704 Camomile Dr W, Frederick, MD 21704

    $924,000

    • 3 Beds
    • 4 Baths
    • 3,608 Sq Ft
    • 2704 Camomile Dr W
    • Frederick, MD

    Nestled in the sought-after 55+ community of The Woodlands of Urbana, this stunning energy efficient Colonial offers unparalleled mountain views with spectacular sunsets! Luxury wide plank vinyl flooring, custom window treatments, and a WiFi smart home system complement the soaring 9’ ceilings. The open floor plan is anchored by an eat-in kitchen, boasting an infinity center island, quartz

    Jackie Ball Daley Northrop Realty

    Section Image

Source: Bright MLS

MLS Number: MDFR2041886

Bright MLS

APN: 07-235461