Laurie Roberts
CENTURY 21 New Millennium
(301) 835-1824
53 Total Sales
1 in Villages of Urbana
$415,000 Price
3570 Shady Pines St Frederick, MD 21704
Villages of Urbana NeighborhoodEstimated Value: $837,000 - $871,330
5
Beds
2.5
Baths
3,816
Sq Ft
$223/Sq Ft
Est. Value
Highlights
- Community Pool
- Cottage
- Forced Air Heating and Cooling System
- Urbana Elementary School Rated A
- 2 Car Detached Garage
About This Home
As of July 2023IMPROVED PRICE! Sellers want to be under contract this weekend! This Main Street Charleston II w/ double porch located in the very desirable Stone Barn section of The Villages of Urbana is an absolute showstopper! Less than two years old, the sellers have barely had time to enjoy all of the beautiful upgrades and amenities this home has to offer. Open concept floorplan with a great big cook's kitchen with oversized island and upgraded appliances and cabinetry opens to a warm and inviting family room and eating area. There is a gigantic pantry and a separate drop zone/mud room area. Main level also features a legal bedroom/office and a half bath. High end LVP throughout. Upstairs is an owner's suite with ample closet space, a fabulous on suite bath and access to a private balcony. The three secondary bedrooms are all spacious. And in addition there is a loft area that's perfect for play room, teen hangout, office...so many possibilities. The basement is a blank canvas that awaits your finishing touches! Simply fabulous!
Last Agent to Sell the Property
(240) 309-6000 lisajgiuliani@comcast.net Keller Williams Realty Centre License #598921 Listed on: 05/25/2023
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,349
Year Built
- Built in 2021
Lot Details
- 4,440 Sq Ft Lot
HOA Fees
- $115 Monthly HOA Fees
Parking
- 2 Car Detached Garage
- Rear-Facing Garage
Home Design
- Cottage
- Vinyl Siding
- Concrete Perimeter Foundation
Interior Spaces
- Property has 3 Levels
- Unfinished Basement
- Basement Fills Entire Space Under The House
Bedrooms and Bathrooms
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 1107600901
Community Details
Overview
- Villages Of Urbana Subdivision
Recreation
- Community Pool
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
Listed on
May 25, 2023
Closed on
Jul 6, 2023
Sold by
Hodeen Michael E and Hodeen Emily O
Bought by
Seller's Agent
Lisa Giuliani
Keller Williams Realty Centre
Buyer's Agent
JIANBO CHEN
Samson Properties
List Price
$775,000
Sold Price
$778,000
Premium/Discount to List
$3,000
0.39%
Views
49
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$71,583
Avg. Annual Appreciation
2.79%
Original Mortgage
$622,400
Outstanding Balance
$539,275
Interest Rate
6.18%
Mortgage Type
New Conventional
Estimated Equity
$310,308
Purchase Details
Closed on
Nov 19, 2021
Sold by
Main Street Homes At Urbana Llc
Bought by
Hodeen Michael E and Hodeen Emily O
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$577,194
Interest Rate
3.05%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 6, 2021
Sold by
Urbana Investment Properties Ii Llc
Bought by
Main Street Homes At Urbana Llc
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Villages of Urbana, MD
-
Laurie Roberts
-
Jim Bass
Jim Bass
Real Estate Teams, LLC
(240) 693-3591
409 Total Sales
10 in Villages of Urbana
$375K - $900K Price Range
-
Jonathan Lahey
Jonathan Lahey
EXP Realty, LLC
(301) 778-2966
727 Total Sales
3 in Villages of Urbana
$860K - $960K Price Range
-
Jim Keating
Jim Keating
Keller Williams Realty Centre
(240) 376-2694
167 Total Sales
1 in Villages of Urbana
$625,000 Price
-
Tony Villeda
Tony Villeda
Vista Properties Group
(844) 365-2166
131 Total Sales
1 in Villages of Urbana
$510,000 Price
-
Larry Quaynor
Larry Quaynor
Jobin Realty
(571) 380-8689
40 Total Sales
1 in Villages of Urbana
$936,975 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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $778,000 | Kensington Realty Title | ||
| Hodeen Michael E | $644,737 | Fidelity National Ttl Ins Co | |
| Main Street Homes At Urbana Llc | $625,000 | Community Title Network Llc |
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 | Borrower | Loan Amount |
|---|---|---|---|
| Open | $622,400 | ||
| Previous Owner | Hodeen Michael E | $577,194 |
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/05/2023 07/05/23 | Sold | $778,000 | +0.4% | $204 / Sq Ft |
| 06/01/2023 06/01/23 | Price Changed | $775,000 | -0.4% | $203 / Sq Ft |
| 05/31/2023 05/31/23 | Off Market | $778,000 | -- | -- |
| 05/31/2023 05/31/23 | Pending | -- | -- | -- |
| 05/28/2023 05/28/23 | Price Changed | $750,000 | -3.2% | $197 / Sq Ft |
| 05/25/2023 05/25/23 | For Sale | $775,000 | -- | $203 / 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 | $10,514 | $823,967 | ||
| 2025 | $9,939 | $749,033 | ||
| 2024 | $9,939 | $674,100 | $170,000 | $504,100 |
| 2023 | $9,299 | $650,567 | $0 | $0 |
| 2022 | $8,993 | $627,033 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Lisa Giuliani
Seller's Agent in 2023
Lisa Giuliani
Keller Williams Realty Centre
(240) 447-5766
67 in this area
90 Total Sales
-
JIANBO CHEN
Buyer's Agent in 2023
JIANBO CHEN
Samson Properties
(301) 693-3710
15 in this area
94 Total Sales
Map
Source: Bright MLS
MLS Number: MDFR2034786
APN: 07-600901
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
- 8623 Satinwood Dr
- 8900 Shady Pines Dr
- 8443 Red Sage Ln S
- 8693 Satinwood Dr
- 8814 Shady Pines Dr
- 3231 Stone Barn Dr
- 3601 Katherine Way
- 3636 Islington St
- 3648 Islington St
- 3650 Tavistock Rd
- 3618 Worthington Blvd
- 8822 Lew Wallace Rd
- 9012 Bealls Farm Rd
- 3550 Sprigg St S
- 3564 Sprigg St S
- 9070 Mcpherson St
- 3297 Raymonds Way
- 3506 Rines Tavern Ln
- 9039 Clendenin Way
- 9063 Major Smith Ln
- 3572 Shady Pines St
- 3566 Shady Pines St
- 3574 Shady Pines St
- 3564 Shady Pines St
- 8629 Loblolly Ln
- 3576 Shady Pines St
- 8627 Loblolly Ln
- 3562 Shady Pines St
- 8625 Loblolly Ln
- 8630 Red Timber Place
- 3578 Shady Pines St
- 8623 Loblolly Ln
- 8628 Red Timber Place
- 3560 Shady Pines St
- 8626 Red Timber Place
- 8621 Loblolly Ln
- 8613 Satinwood Dr
- 8624 Red Timber Place
- 9021 Shady Pines Dr
- 8611 Satinwood Dr
Your Personal Tour Guide
Ask me questions while you tour the home.