Property Attributes
- MLS#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 web site comes in part from the Internet Data Exchange of the Greater Lehigh Valley REALTORS®. Real Estate listings held by brokerage firms (licensees) other than #firm are marked with the IDX logo and detailed information about them includes the name of the listing brokers.
The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers
©2026 Georgia Multiple Listing Service All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
The data relating to real estate for sale on this web site includes listings held by MLS-IDX Participants of the Internet Data Exchange program of the Multiple Listing Service of the Pocono Mountains Association of Realtors®. Listings marked with the Internet Data Exchange logo are not necessarily the listings of the owner of this web site. All listing data is the copyrighted property of the aforesaid Association and its MLS-IDX Participants with all rights reserved. The information contained
© BRIGHT, All Rights Reserved
Luzerne County Association of REALTORS® (LZCAOR) All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than The Brokers Realty Group Limited may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright ©2026 All rights reserved.
Last Updated: September 20, 2026 1:28 AM UTC
Susquehanna Valley Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating