Lloidy Guevara
EXP Realty, LLC
(240) 541-5879
232 Total Sales
1 in Villages of Urbana
$502,000 Price
9060 Major Smith Ln Frederick, MD 21704
Villages of Urbana Neighborhood
4
Beds
4
Baths
3,749
Sq Ft
8,382
Sq Ft Lot
Highlights
- Fitness Center
- Clubhouse
- Community Pool
- Colonial Architecture
- Great Room
- Tennis Courts
About This Home
As of July 2026Your lucky day!! This lovely home is back on the market and ready for you to enjoy all the Villages of Urbana has to offer this summer! Original owners are reluctantly saying goodbye to this beautiful, meticulously maintained home. With numerous major updates already completed, this truly move-in ready property offers peace of mind for its next owners. Recent improvements include new carpet, vinyl plank flooring, a new roof, gutters, one HVAC unit, and a tankless water heater. The chef’s kitchen features stunning quartz countertops, stainless steel appliances, and a spacious pantry, all opening to a bright breakfast room filled with natural light from an abundance of windows. The main level offers an ideal layout for entertaining and everyday living with a large family room, separate dining room, formal living room, and access to the paver patio and fenced backyard from the breakfast room. Upstairs, the spacious primary suite offers a spa-like bath and oversized walk-in closet, along with three additional bedrooms and a hall bath. The mostly finished lower level provides exceptional space for recreation and entertaining, complete with a custom bar, half bath, generous game room, and den. Need storage? This home delivers with a large unfinished storage area featuring extensive built-in shelving for all your treasures. All of this is located in one of the area's premier communities! Ideally situated in the Villages of Urbana, you'll enjoy an easy walk to the Market District, Regional Library, miles of walking trails, three clubhouses, three pools, tennis courts, top-rated schools, and so much more.
Last Agent to Sell the Property
(301) 788-2549 cassandra@cassandrabailey.com Maryland Elite Realtors Brokerage Phone: 3017882549 License #34873 Listed on: 05/20/2026
Last Buyer's Agent
(240) 497-1700 john.coplen@johncoplengroup.com Long & Foster Real Estate, Inc. License #639590
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $7,680
Year Built
- Built in 2001
Lot Details
- 8,382 Sq Ft Lot
- Back Yard Fenced
- Property is zoned PUD
HOA Fees
- $141 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Front Facing Garage
Home Design
- Colonial Architecture
- Poured Concrete
- Asphalt Roof
- Vinyl Siding
- Concrete Perimeter Foundation
Interior Spaces
- Property has 3 Levels
- Gas Fireplace
- Great Room
- Family Room
- Living Room
- Breakfast Room
- Dining Room
- Den
- Storage Room
- Partially Finished Basement
- Basement Fills Entire Space Under The House
- Instant Hot Water
Bedrooms and Bathrooms
- 4 Bedrooms
Outdoor Features
- Patio
Utilities
- 90% Forced Air Zoned Heating and Cooling System
- Heating System Uses Natural Gas
- Electric Water Heater
Listing and Financial Details
- Tax Lot 5041
- Assessor Parcel Number 1107222734
Community Details
Overview
- Association fees include common area maintenance, management, pool(s), recreation facility, reserve funds, road maintenance, snow removal, trash
- Community Assoication Services HOA
- Villages Of Urba Community
- Villages Of Urbana Subdivision
Amenities
- Common Area
- Clubhouse
- Community Center
Recreation
- Tennis Courts
- Community Basketball Court
- Pickleball Courts
- Community Playground
- Fitness Center
- Community Pool
- Jogging Path
- Bike Trail
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
Closed on
Mar 30, 2001
Sold by
Bought by
Purchase Details
Closed on
Nov 29, 2000
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Villages of Urbana, MD
-
Lloidy Guevara
-
Preda Mendez-Lopez
Preda Mendez-Lopez
Realty One Group Performance, LLC
(757) 267-9786
48 Total Sales
1 in Villages of Urbana
$590,000 Price
-
Wyevetra Jordan
Wyevetra Jordan
The Home Team Realty Group, LLC
(240) 312-2957
97 Total Sales
1 in Villages of Urbana
$885,000 Price
-
Mrs. LILI LIU
Mrs. LILI LIU
Ten Thousand Realty
(240) 883-5822
23 Total Sales
2 in Villages of Urbana
$430K - $455K Price Range
-
Leigh Ann Fangmeyer
Leigh Ann Fangmeyer
RE/MAX Results
(240) 698-2416
41 Total Sales
2 in Villages of Urbana
$512K - $610K Price Range
-
Danielle Gottlieb
Danielle Gottlieb
RE/MAX Realty Centre, Inc.
(240) 905-5179
34 Total Sales
1 in Villages of Urbana
$490,000 Price
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $300,100 | -- | |
| Deed | $66,085 | -- |
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 | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $429,700 | New Conventional | |
| Closed | $25,000 | Credit Line Revolving | |
| Closed | $381,886 | New Conventional | |
| Closed | $343,000 | New Conventional | |
| Closed | $150,000 | Credit Line Revolving |
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 |
|---|---|---|---|---|
| 07/10/2026 07/10/26 | Sold | $824,900 | 0.0% | $220 / Sq Ft |
| 06/22/2026 06/22/26 | Pending | -- | -- | -- |
| 06/18/2026 06/18/26 | Price Changed | $824,900 | -1.8% | $220 / Sq Ft |
| 06/04/2026 06/04/26 | Price Changed | $839,900 | 0.0% | $224 / Sq Ft |
| 06/04/2026 06/04/26 | For Sale | $839,900 | -1.2% | $224 / Sq Ft |
| 05/27/2026 05/27/26 | Pending | -- | -- | -- |
| 05/20/2026 05/20/26 | For Sale | $849,900 | -- | $227 / 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 |
|---|---|---|---|---|
| 2026 | $9,464 | $681,433 | ||
| 2025 | $9,464 | $633,667 | ||
| 2024 | $9,012 | $585,900 | $201,600 | $384,300 |
| 2023 | $8,257 | $548,933 | $0 | $0 |
| 2022 | $7,792 | $511,967 | $0 | $0 |
| 2021 | $7,460 | $475,000 | $175,800 | $299,200 |
| 2020 | $7,460 | $456,867 | $0 | $0 |
| 2019 | $7,209 | $438,733 | $0 | $0 |
| 2018 | $7,023 | $420,600 | $109,300 | $311,300 |
| 2017 | $6,795 | $420,600 | $0 | $0 |
| 2016 | $6,179 | $399,067 | $0 | $0 |
| 2015 | $6,179 | $388,300 | $0 | $0 |
| 2014 | $6,179 | $383,633 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Cassandra Bailey
Seller's Agent in 2026
Cassandra Bailey
Maryland Elite Realtors
(301) 788-2549
4 in this area
100 Total Sales
-
John Coplen
J
Buyer's Agent in 2026
John Coplen
Long & Foster
(410) 591-0911
1 in this area
14 Total Sales
Map
Source: Bright MLS
MLS Number: MDFR2082570
APN: 07-222734
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.
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
- 9039 Clendenin Way
- 8822 Lew Wallace Rd
- 3648 Islington St
- 3557 Worthington Blvd Unit A
- 3611 Hope Commons Ct
- 3645 Islington St
- 3580 Sprigg St S
- 9045 Mcpherson St
- 9070 Mcpherson St
- 3550 Sprigg St S
- 3506 Rines Tavern Ln
- 3947 Sweet Briar Ct
- 3934 Sweet Briar Ln
- 9212 Landon House Way
- 9200 Landon House Way
- 8693 Satinwood Dr
- 9152 Landon House Ln
- 3775 Spicebush Dr
- 9137 Landon House Ln
- 8608 Longleaf Ln
Your Personal Tour Guide
Ask me questions while you tour the home.