Landlord's Agent in 2026
Suleman Hooda
Johnson-Needham Realty LLC
(410) 294-5233
557 Cascade Way Frederick, MD 21703
Frederick Heights/Overlook NeighborhoodEstimated Value: $276,933 - $301,000
2
Beds
1.5
Baths
1,148
Sq Ft
$248/Sq Ft
Est. Value
Highlights
- Contemporary Architecture
- Traditional Floor Plan
- Combination Kitchen and Dining Room
- Frederick High School Rated A-
- Central Air
- 5-minute walk to Overlook Park
About This Home
As of April 2026This End Unit Townhome has lots to offer in sought after community of Overlook. Affordable price point and fantastic location. You'll love the modern look this home offers. Laminated Plan Flooring throughout! Enjoy the convenience of two assigned parking spaces in front of the home and the benefits of a larger yard. Don't miss out on this fantastic opportunity to rent at affordable pricing. Pet Friendly - Small pet welcomed! Contact us today for a private showing.
Last Agent to Rent the Property
(301) 869-5001 hooda.suleman@gmail.com Johnson-Needham Realty LLC Brokerage Phone: 3018695001 Listed on: 03/18/2026
Last Renter's Agent
(571) 386-1075 homegirllacy@gmail.com Pearson Smith Realty, LLC License #SP40002574
Townhouse Details
Home Type
- Townhome
Year Built
- Built in 1991
Lot Details
- 1,365 Sq Ft Lot
- Property is Fully Fenced
- Board Fence
Home Design
- Contemporary Architecture
- Frame Construction
Interior Spaces
- 1,148 Sq Ft Home
- Property has 2 Levels
- Traditional Floor Plan
- Fireplace Mantel
- Combination Kitchen and Dining Room
- Laminate Flooring
Kitchen
- Electric Oven or Range
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 2 Bedrooms
Laundry
- Laundry in unit
- Dryer
- Washer
Parking
- Assigned parking located at #577
- Parking Lot
- 2 Assigned Parking Spaces
Utilities
- Central Air
- Heat Pump System
- Electric Water Heater
Listing and Financial Details
- Residential Lease
- Security Deposit $1,999
- Tenant pays for electricity, insurance, water, utilities - some, sewer
- No Smoking Allowed
- 12-Month Min and 24-Month Max Lease Term
- Available 3/18/26
- Assessor Parcel Number 1102159244
Community Details
Overview
- Property has a Home Owners Association
- Clagett Enterprises Inc. HOA
- Overlook Subdivision
Pet Policy
- Limit on the number of pets
- Pet Size Limit
- Pet Deposit Required
- Breed Restrictions
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 19, 2024
Closed on
Sep 10, 2024
Sold by
Holland Jordan and Amaya Adriana
Bought by
Anderson Nicole
Seller's Agent
Fernando Mejia
Samson Properties
Buyer's Agent
Blake Hering
Samson Properties
List Price
$280,000
Sold Price
$280,000
Views
93
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
-$3,129
Avg. Annual Appreciation
0.95%
Original Mortgage
$224,000
Outstanding Balance
$221,046
Interest Rate
6.47%
Mortgage Type
New Conventional
Estimated Equity
$63,187
Purchase Details
Listed on
Jul 14, 2022
Closed on
Aug 25, 2022
Sold by
Benavides Wilber H and Giron Sylvia Yamileth
Bought by
Holland Jodan and Amaya Adriana
Seller's Agent
Karina Diaz
RE/MAX Excellence Realty
Buyer's Agent
Dana Thingelstad
Keller Williams Realty Centre
List Price
$227,000
Sold Price
$245,000
Premium/Discount to List
$18,000
7.93%
Views
4
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.73%
Original Mortgage
$10,000
Interest Rate
5.22%
Mortgage Type
FHA
Purchase Details
Listed on
Aug 15, 2019
Closed on
Oct 11, 2019
Sold by
Felder Natalene
Bought by
Ruiz Benavides Wilber H and Ruiz Giron Sylvia Yamileth
Seller's Agent
Sarah Gemmell
Long & Foster Real Estate, Inc.
Buyer's Agent
Roberto Zani
Smart Realty, LLC
List Price
$187,000
Sold Price
$187,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.83%
Original Mortgage
$183,612
Interest Rate
4.25%
Mortgage Type
FHA
Purchase Details
Closed on
Sep 28, 2004
Sold by
Peralta Luis and Peralta Katie
Bought by
Felder Natalene
Purchase Details
Closed on
Sep 13, 2004
Sold by
Peralta Luis and Peralta Katie
Bought by
Felder Natalene
Purchase Details
Closed on
Nov 17, 2003
Sold by
Cox Nalbro Lee
Bought by
Peralta Luis and Peralta Katie
Purchase Details
Closed on
Oct 31, 2002
Sold by
Schneider Douglas Knight
Bought by
Cox Nalbro Lee
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Anderson Nicole | $280,000 | Doma Title | |
| Anderson Nicole | $280,000 | Doma Title | |
| Holland Jodan | $245,000 | None Listed On Document | |
| Holland Jodan | $245,000 | None Listed On Document | |
| Ruiz Benavides Wilber H | $187,000 | Cardinal Title Group Llc | |
| Felder Natalene | $167,000 | -- | |
| Felder Natalene | $167,000 | -- | |
| Peralta Luis | $132,500 | -- | |
| Cox Nalbro Lee | $110,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Anderson Nicole | $224,000 | |
| Closed | Anderson Nicole | $224,000 | |
| Previous Owner | Holland Jodan | $10,000 | |
| Previous Owner | Holland Jodan | $240,562 | |
| Previous Owner | Ruiz Benavides Wilber H | $183,612 | |
| Closed | Felder Natalene | -- |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 04/20/2026 04/20/26 | Rented | $1,999 | 0.0% | -- | |
| 03/18/2026 03/18/26 | For Rent | $1,999 | +1.2% | -- | |
| 02/07/2025 02/07/25 | Rented | $1,975 | 0.0% | -- | |
| 01/07/2025 01/07/25 | Price Changed | $1,975 | -1.3% | $2 / Sq Ft | |
| 12/06/2024 12/06/24 | Price Changed | $2,000 | -2.4% | $2 / Sq Ft | |
| 10/07/2024 10/07/24 | For Rent | $2,050 | 0.0% | -- | |
| 09/11/2024 09/11/24 | Sold | $280,000 | 0.0% | $244 / Sq Ft | View Prior Sale |
| 07/22/2024 07/22/24 | For Sale | $280,000 | 0.0% | $244 / Sq Ft | |
| 07/20/2024 07/20/24 | Off Market | $280,000 | -- | -- | |
| 07/19/2024 07/19/24 | For Sale | $280,000 | +14.3% | $244 / Sq Ft | |
| 08/26/2022 08/26/22 | Sold | $245,000 | +7.9% | $219 / Sq Ft | View Prior Sale |
| 07/14/2022 07/14/22 | For Sale | $227,000 | +21.4% | $203 / Sq Ft | |
| 10/11/2019 10/11/19 | Sold | $187,000 | 0.0% | $167 / Sq Ft | View Prior Sale |
| 08/28/2019 08/28/19 | Pending | -- | -- | -- | |
| 08/15/2019 08/15/19 | For Sale | $187,000 | -- | $167 / Sq Ft |
Source: Bright MLS
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 |
|---|---|---|---|---|
| 2025 | $3,600 | $202,400 | $55,000 | $147,400 |
| 2024 | $3,600 | $191,600 | -- | -- |
| 2023 | $3,338 | $180,800 | $0 | $0 |
| 2022 | $3,105 | $170,000 | $55,000 | $115,000 |
| 2021 | $2,834 | $159,933 | $0 | $0 |
| 2020 | $2,764 | $149,867 | $0 | $0 |
| 2019 | $2,560 | $139,800 | $40,000 | $99,800 |
| 2018 | $2,361 | $132,333 | $0 | $0 |
| 2017 | $2,158 | $139,800 | $0 | $0 |
| 2016 | $2,201 | $117,400 | $0 | $0 |
| 2015 | $2,201 | $117,200 | $0 | $0 |
| 2014 | $2,201 | $117,000 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Suleman Hooda
-
Lacy Cheek
Tenant's Agent in 2026
Lacy Cheek
Pearson Smith Realty, LLC
(202) 486-5955
2 Total Sales
-
Chelsie Clark
Buyer's Agent in 2025
Chelsie Clark
Keller Williams Flagship
(443) 222-1166
84 Total Sales
-
Fernando Mejia
Seller's Agent in 2024
Fernando Mejia
Samson Properties
(202) 740-4997
2 in this area
46 Total Sales
-
Blake Hering
Buyer's Agent in 2024
Blake Hering
Samson Properties
(240) 643-4067
1 in this area
123 Total Sales
-
Karina Diaz
Seller's Agent in 2022
Karina Diaz
RE/MAX
(240) 645-5414
2 in this area
45 Total Sales
Map
Source: Bright MLS
MLS Number: MDFR2077030
APN: 02-159244
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
- 1090 E Thornhill Place
- 591 Winterspice Dr
- 607 Himes Ave Unit 102
- 401 Linden Ave
- 526 Essex Place
- 617 Himes Ave
- 524 Lancaster Place Unit 524
- 12 Coats Bridge Place
- 584 Ellison Ct
- 1112 Providence Ct
- 1011 Cheryls Ct
- 519 Ellison Ct
- 519 Beebe Ct
- 525 Beebe Ct
- 1139 Providence Ct
- 502 Bradley Ct
- 500 Bradley Ct Unit 4B
- 500 Patton Cir Unit H
- 1228 Danielle Dr
- 116 Whiskey Creek Cir
- 559 Cascade Way
- 561 Cascade Way
- 556 Hollyberry Way
- 560 Hollyberry Way
- 563 Cascade Way
- 540 Cascade Way
- 562 Hollyberry Way
- 565 Cascade Way
- 564 Hollyberry Way
- 567 Cascade Way
- 538 Cascade Way
- 536 Cascade Way
- 566 Hollyberry Way
- 542 Cascade Way
- 534 Cascade Way
- 552 Cascade Way
- 554 Cascade Way
- 550 Cascade Way
- 544 Cascade Way
- 556 Cascade Way
Your Personal Tour Guide
Ask me questions while you tour the home.