Property Attributes
- ID#MDFR2083340
- TypeSingle Family
- Listing Status ACTIVE
- CountyFREDERICK
- CityFrederick
- NeighborhoodVillages Of Urbana
- Zip21704
- StyleColonial
- Year Built2004
- Taxes$ 12200
- Price$ 949,900
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage5325
- Lot Size0.25 Acres
Data Source:
Bright MLS
Property Description
OPEN HOUSE: SATURDAY 9/19 FROM 12PM-2PM AND SUNDAY 9/20 FROM 12PM-2PM Beautiful Brick-Front Colonial situated in the corner lot with side loaded 2 car garage, in the sought of Villages of Urbana. Freshly painted throughout all 3 levels. Former model home boasting over 5800 sf with brand new roof replaced on 5.7.2025, water heater 6 years old, original owners: featuring 5 bedrooms (potentially 8 bedrooms), 4.5 bathrooms. Many upgraded features include dual staircase, 10 feet ceiling, hardwood floors, plantation windows. Main level includes a gourmet kitchen with granite countertops & designer backsplashes, large center island, stainless steel appliances, and 42 inch cherry cabinets., large study room, formal dining room, Family room has a fireplace that you can see through from the study room, the foyer and hallways are filled with designer tiles while the entire main floor is filled with hardwood floors. Upper level with primary bedroom filled with lots of lights, tray ceiling, double walk-in closets, luxury bath with double vanity, soaking tub and separate shower, Four additional spacious bedrooms, two full baths and a convenient laundry room. Lower level is fully finished with a large recreation room, amazed with designer flooring tiles along with a huge entertainment room that will bring the sound of music to the heart of your guests and with a spacious wet bar, all for your entertainment activities.. A full bath specially designed with white tiles, 3 large additional bedrooms can be guest rooms. Sold As-Is but has home warranty until 7/2029. Popular subdivision with lots of community amenities, close to I270, shopping, restaurants and top school districts.
| Price History | |
|---|---|
| 6/3/2026 | Listed $949,900 |
General Features
| Living Area | 5325 |
|---|---|
| Sewer | Public Sewer |
| Heating | Forced Air |
| Cooling | Central A/C |
| Possession | Immediate |
| Appliances | Built-In Microwave,Built-In Range,Cooktop,Dishwasher,Disposal,Dryer,Oven - Double,Refrigerator,Washer |
| Zoning | RESIDENTIAL |
| HOA Fee | 141.00 |
| Garage Spaces | 2.00 |
| Patio/Porch Features | Brick,Terrace |
| Architectural Style | Colonial |
| Construction Materials | Brick |
| School District | FREDERICK COUNTY PUBLIC SCHOOLS |
| Year Built | 2004 |
| Levels | 3 |
| Tax Year | 2026 |
| Ownership | Fee Simple |
| Cool Fuel | Electric |
| Building Name | VILLAGES OF URBA |
| Accessibility | None |
| Assoc Fee Paid Per | Monthly |
| County | FREDERICK |
| New Construction | No |
| Property Type | Residential |
| HOA | Yes |
| Subdivision Name | VILLAGES OF URBANA |
| Garage Y/N | Yes |
| Water Access Y/N | No |
| Other Structures | Above Grade,Below Grade |
| Full Baths | 4 |
| Status | ACTIVE |
| Directions | North 270,exit 26 Urbana,left on Fingerboard |
| City | FREDERICK |
| Disclosures | Prop Disclosure |
| Senior Community Y/N | No |
| Lot Size Units | Square Feet |
| Lot Size Square Feet | 10702.00 |
| Tax Assessed Value | 931062.0 |
| Tax Annual Amount | 12200.0 |
| Home Warranty Y/N | Yes |
| Property Condition | Very Good |
| Structure Type | Detached |
| Condo/Coop Association fee Y/N | No |
| Bathrooms Count Main Level | 1.00 |
| Price Per Sq Ft Total AG | 241.52 |
| Acceptable Financing | Cash,Conventional,FHA,VA |
| Additional Parcels Y/N | No |
| Vacation Rental Y/N | No |
| Total SQFT | 5834 |
| Location Type | Corner Lot/Unit |
| Standard Status | Active |
| Year Built Source | Assessor |
Interior Features
| Interior Amenities | Additional Stairway,Attic,Bar,Bathroom - Soaking Tub,Bathroom - Walk-In Shower,Breakfast Area,Butlers Pantry,Ceiling Fan(s),Chair Railings,Crown Moldings,Dining Area,Floor Plan - Traditional,Kitchen |
|---|---|
| Heating Fuel | Natural Gas |
| Basement | Full,Fully Finished,Connecting Stairway,Walkout Stairs |
| Flooring | Ceramic Tile,Hardwood |
| Total Fireplaces | 1 |
| Fireplace Features | Double Sided |
| Hot Water | Natural Gas |
| Basement (Y/N) | Yes |
| Heating Y/N | Yes |
| Window Features | Bay/Bow |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 3933 |
| Half Baths | 1 |
| Central Air Y/N | Yes |
| Total Bedrooms | 5 |
| Below Grade Finished Area | 1392 |
| Below Grade Finished Area Unit Type | Square Feet |
| LivingAreaSource | Assessor |
| Laundry Type | Upper Floor |
| Below Grade Unfin Area Units | Square Feet |
| Below Grade Unfin SQFT | 509 |
| Below Grade Unfin SQFT Source | Assessor |
| Below Grade Finished Area Source | Assessor |
| Bedrooms Count All Upper Levels | 5 |
| Bedrooms Count Upper Level 1 | 5 |
| Bathrooms Half Main Level | 1 |
| Bathrooms Full Upper Level 1 | 3 |
| Bathrooms Full Lower Level 1 | 1 |
| Bathrooms Full All Upper Levels | 3 |
| Bathrooms Full All Lower Levels | 1 |
| Bathrooms Count Upper Level 1 | 3.00 |
| Bathrooms Count Lower Level 1 | 1.00 |
| Bathrooms Count All Upper Levels | 3 |
| Bathrooms Count All Lower Levels | 1 |
| Above Grade Finished Area Source | Assessor |
| Above Grade Finished Area Unit Type | Square Feet |
| Total Baths | 5 |
Exterior Features
| Exterior Amenities | Sidewalks,Street Lights |
|---|---|
| Pool | Yes - Community |
| Lot Features | Corner,Level,Premium |
| Water Source | Public |
| Total Parking Spaces | 8 |
| Garage Features | Garage - Side Entry |
| Type of Parking | Attached Garage,Driveway |
| Foundation Details | Other |
| Spa | No |
| Water View Y/N | No |
| Lot Size Acres | 0.25 |
| Lot Size Source | Assessor |
| Waterfront Y/N | No |
| Navigable Water Y/N | No |
| Water Oriented Y/N | No |
| # of Attached Garage Spaces | 2 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
The data relating to real estate for sale on this website comes in part from the IDX Program of Garden State Multiple Listing Service, L.L.C. and Keyes Red Door Realty & Associates, LLC. Real estate listings held by other brokerage firms are marked as IDX listing. Information deemed reliable but not guaranteed. Copyright © 2026 Garden State Multiple Listing Service, L.L.C. All rights reserved. This information is being provided for Consumer's personal, non-commercial use and may not be used for
The data relating to real estate for sale on this web-site comes in part from the Internet Listing Display database of the ALL JERSEY MULTIPLE LISTING SYSTEM, INC. Real estate listings held by brokerage firms other than this site-owner are marked with the ILD logo. The ALL JERSEY MULTIPLE LISTING SYSTEM, INC. does not warrant the accuracy, quality, reliability, suitability, completeness, usefulness or effectiveness of any information provided.
The information being provided is for consumers' personal,
The data relating to real estate for sale or rent on this web site comes in part from the IDX program of the Hudson County MLS. Real estate listings held by brokerage firms other than Keyes Red Door Realty & Associates, LLC are marked with the HCIDX mark and the information about them includes the name of the listing broker. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties
The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Keyes Red Door Realty & Associates, LLC are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website. All information deemed reliable but not guaranteed.
Last date updated: September 25, 2026 8:05 PM UTC Source: New Jersey Multiple Listing Service, Inc. "© 2026 New Jersey Multiple Listing Service, Inc. All rights reserved."
© BRIGHT, All Rights Reserved