NOT LISTED FOR SALE

5403 Upper Mill Terrace S Frederick, MD 21703

Estimated Value: $401,000 - $410,730

3 Beds
4 Baths
1,860 Sq Ft
$219/Sq Ft Est. Value

Last Sold November 30, 2023

Last sale price $390,000 $210 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $2,455/month

Highlights

  • Open Floorplan
  • Wood Flooring
  • Breakfast Area or Nook
  • Colonial Architecture
  • No HOA
  • 1 Car Attached Garage

About This Home

As of March 2024

Welcome to this bright and spacious 3 level, 3 bedrooms, 2 full baths, 2 1/2 baths & a 1 car garage townhouse situated in the wonderful community of Westview Corporate Center. Main level with wood floors and open floor concept into kitchen & living area. Kitchen with Island, granite counter tops and dining area. Deck leading out from the kitchen area. Lower level with gas fireplace and walk out level to back yard. New carpet on the lower level and in all bedrooms. New paint throughout the entire home. Newer architectural roof. Directly across the street from Giant grocery on New Design Rd, ***FANTASTIC LOCATION*** CLOSE TO I-270, PUBLIC LIBRARY, PUBLIC TRANSPORTATION, SHOPPING, RESTAURANTS AND SO MUCH MORE.
Don't miss this opportunity Please apply on line at *** adult over 18 must apply and complete application separately**

Last Agent to Rent the Property

Johnny Diaz

(301) 881-9800 service@realty-advantage.com Realty Advantage of Maryland LLC Listed on: 12/20/2023

Realty Advantage of Maryland LLC

Last Renter's Agent

datacorrect BrightMLS

(844) 552-7444 datacorrect@brightmls.com Non Subscribing Office License #0225194075

Townhouse Details

Home Type

  • Townhome

Year Built

  • Built in 2002

Lot Details

  • 2,200 Sq Ft Lot
  • Property is in excellent condition

Parking

  • 1 Car Attached Garage
  • Parking Storage or Cabinetry
  • Front Facing Garage
  • Garage Door Opener
  • Unassigned Parking

Home Design

  • Colonial Architecture
  • Frame Construction
  • Architectural Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 1,860 Sq Ft Home
  • Property has 3 Levels
  • Open Floorplan
  • Crown Molding
  • Recessed Lighting
  • Gas Fireplace
  • Dining Area
  • Dryer

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Electric Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 3 Bedrooms

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Garage Access
  • Laundry in Basement
  • Basement Windows

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Natural Gas Water Heater

Listing and Financial Details

  • Residential Lease
  • Security Deposit $2,500
  • Tenant pays for cable TV, electricity
  • The owner pays for association fees, insurance, repairs, real estate taxes
  • Rent includes hoa/condo fee, insurance, parking
  • 12-Month Min and 36-Month Max Lease Term
  • Available 12/20/23
  • $50 Application Fee
  • $100 Repair Deductible
  • Assessor Parcel Number 1128585144

Community Details

Overview

  • No Home Owners Association
  • Westview Office Community
  • Westview Corporate Center Subdivision

Pet Policy

  • No Pets Allowed

Townhouse Details

Home Type

Townhome

Year Built

Built in 2002

Lot Details

0

Parking

1

Rental Info

  • Date Available: 2023-12-20
  • Application Fee: 50.00
  • Owner Pays: Association Fees, Insurance, Repairs, Taxes - Real Estate
  • Pets Allowed: No
  • Rent Includes: Hoa/Condo Fee, Insurance, Parking
  • Security Deposit: 2500.00
  • Tenant Pays: Cable Tv, Electricity
  • Vacation Rental: No
  • Max Lease in Months: 36
  • Min Lease in Months: 12
  • Lease Link U R L: https://apply.link/3to7bdb
  • Rent Spree Online Application: Yes

Listing Details

  • Property Type: Residential Lease
  • Structure Type: Interior Row/Townhouse
  • Architectural Style: Colonial
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Year Built: 2002
  • Building Winterized: No
  • Repair Deductible: 100.00
  • Special Features: None
  • Property Sub Type: Townhouses

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Exhaust Fan, Microwave, Oven/Range - Electric, Refrigerator, Water Heater
  • Flooring Type: Hardwood, Carpet
  • Interior Amenities: Breakfast Area, Crown Moldings, Dining Area, Floor Plan - Open, Kitchen - Island, Kitchen - Table Space, Recessed Lighting, Wood Floors
  • Fireplace Features: Gas/Propane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Basement: Yes
  • Basement Type: Daylight, Full, Full, Fully Finished, Garage Access, Improved, Walkout Level, Windows
  • Laundry Type: Basement
  • Total Sq Ft: 1860
  • Living Area Sq Ft: 1860
  • Price Per Sq Ft: 1.34
  • Above Grade Finished Sq Ft: 1860
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 3
  • Total Bathrooms: 4
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Main Level Half Bathrooms: 1
  • Lower Level Half Bathroom: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Frame
  • Roof: Architectural Shingle
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 1.00
  • Garage: Yes
  • Parking Features: Asphalt Driveway, Unassigned
  • Garage Features: Additional Storage Area, Garage - Front Entry, Garage Door Opener
  • Attached Garage Spaces: 1
  • Total Garage And Parking Spaces: 1
  • Type Of Parking: Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Condo Co-Op Association: No
  • HOA: No
  • Senior Community: No

Schools

  • School District Source: Listing Agent

Lot Info

  • Lot Size Acres: 0.05
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 2200.00
  • Property Condition: Excellent
  • Zoning: RESIDENTIAL

Tax Info

  • Assessor Parcel Number: 1128585144
  • Tax Data Updated: No

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 26, 2023
Closed on
Nov 29, 2023
Sold by
Costello Evan A and Costello Mara P
Bought by
Garcia Jose Servando Lop and Ortiz Heidy Veronica
Seller's Agent
Greg Salley
Long & Foster Real Estate, Inc.
Buyer's Agent
Johnny Diaz
Realty Advantage of Maryland LLC
List Price
$399,999
Sold Price
$390,000
Premium/Discount to List
-$9,999
-2.5%
Views
99
Current Estimated Value
$411,326

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$21,326
Avg. Annual Appreciation
2.07%
Original Mortgage
$312,000
Outstanding Balance
$306,949
Interest Rate
7.63%
Mortgage Type
New Conventional
Estimated Equity
$100,734

Purchase Details

Listed on
Jul 21, 2015
Closed on
Dec 3, 2015
Sold by
Fannie Mae
Bought by
Costello Evan A and Costello Mara P
Seller's Agent
David King
Long & Foster Real Estate, Inc.
Buyer's Agent
Anthony Lioi
RE/MAX Solutions
List Price
$267,795
Sold Price
$235,000
Premium/Discount to List
-$32,795
-12.25%

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.54%
Original Mortgage
$188,000
Interest Rate
3.89%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 29, 2015
Sold by
Stake Patrick M and Stake Andrea M
Bought by
Federal National Mortgage Association

Purchase Details

Closed on
Nov 21, 2002
Sold by
Martin Westview Park Llc
Bought by
Stake Patrick M and Stake Andrea M
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Garcia Jose Servando Lop $390,000 None Listed On Document
Garcia Jose Servando Lop $390,000 None Listed On Document
Costello Evan A $235,000 Attorney
Federal National Mortgage Association $361,118 None Available
Stake Patrick M $195,296 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Garcia Jose Servando Lop $312,000
Closed Garcia Jose Servando Lop $312,000
Previous Owner Costello Evan A $188,000
Closed Stake Patrick M --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/01/2024 03/01/24 Rented $2,500 0.0% --
12/20/2023 12/20/23 For Rent $2,500 0.0% --
11/30/2023 11/30/23 Sold $390,000 -2.5% $210 / Sq Ft View Prior Sale
11/06/2023 11/06/23 Pending -- -- --
10/26/2023 10/26/23 For Sale $399,999 +70.2% $215 / Sq Ft
12/03/2015 12/03/15 Sold $235,000 -2.1% $126 / Sq Ft View Prior Sale
10/08/2015 10/08/15 Pending -- -- --
09/28/2015 09/28/15 Price Changed $239,997 -5.9% $129 / Sq Ft
08/24/2015 08/24/15 Price Changed $254,995 -4.3% $137 / Sq Ft
08/22/2015 08/22/15 Price Changed $266,500 -0.4% $143 / Sq Ft
08/18/2015 08/18/15 Price Changed $267,500 0.0% $144 / Sq Ft
08/16/2015 08/16/15 Price Changed $267,600 0.0% $144 / Sq Ft
08/06/2015 08/06/15 Price Changed $267,700 0.0% $144 / Sq Ft
07/21/2015 07/21/15 For Sale $267,795 -- $144 / 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,799 $325,700 $80,000 $245,700
2024 $3,799 $306,433 $0 $0
2023 $3,362 $287,167 $0 $0
2022 $3,199 $267,900 $70,000 $197,900
2021 $2,997 $259,167 $0 $0
2020 $2,997 $250,433 $0 $0
2019 $2,895 $241,700 $63,000 $178,700
2018 $2,863 $236,767 $0 $0
2017 $2,781 $241,700 $0 $0
2016 $2,705 $226,900 $0 $0
2015 $2,705 $226,900 $0 $0
2014 $2,705 $226,900 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2042958

Bright MLS

APN: 28-585144