NOT LISTED FOR SALE

5544 Upshur Square Frederick, MD 21703

Estimated Value: $387,771 - $439,000

4 Beds
3.5 Baths
1,240 Sq Ft
$333/Sq Ft Est. Value

Last Sold June 28, 2019

Last sale price $280,900 $227 Per Sq Ft

Est. 47% increase in value since last sale

Current estimated payment $2,546/month

Highlights

  • Open Floorplan
  • Deck
  • Stainless Steel Appliances
  • Colonial Architecture
  • Breakfast Room
  • Eat-In Kitchen

About This Home

As of June 2019

Freshly painted ,New Roof 2019 , New Hardwood Floor, new carpet,new LED Recessed light in kitchen and master Bathroom,all new outlet and switches and cover plate Breakfast Area, Combination Kitchen/Dining, Kitchen - Eat-In, No Fireplace,all New Stainless Steel Appliances New Built-In Microwave,New Dishwasher, ,New Oven/Range-Gas,New Refrigerator with Ice maker,New flooring every rooms, and much more must see .

Last Agent to Sell the Property

Vijay Patel

(301) 748-3290 vp7883020@gmail.com Allison James Estates & Homes License #111534657 Listed on: 05/29/2019

Allison James Estates & Homes

Last Buyer's Agent

Mechelle Brooks

(240) 315-3180 mechelle@ultimatesellingteam.com Keller Williams Capital Properties

Keller Williams Capital Properties

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $2,545

Year Built

  • Built in 1999 | Remodeled in 2019

Lot Details

  • 1,600 Sq Ft Lot
  • Wood Fence

HOA Fees

  • $90 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Shingle Siding

Interior Spaces

  • 1,240 Sq Ft Home
  • Property has 3 Levels
  • Open Floorplan
  • Recessed Lighting
  • Six Panel Doors
  • Family Room
  • Living Room
  • Breakfast Room
  • Combination Kitchen and Dining Room

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom

Laundry

  • Dryer
  • Washer

Basement

  • Laundry in Basement
  • Basement with some natural light

Home Security

Parking

  • Parking Lot
  • 2 Assigned Parking Spaces

Accessible Home Design

  • Doors swing in
  • Level Entry For Accessibility

Outdoor Features

  • Deck

Schools

  • Ballenger Creek Elementary And Middle School
  • Tuscarora High School

Utilities

  • Central Heating and Cooling System
  • Natural Gas Water Heater
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 1106
  • Assessor Parcel Number 1128583400

Community Details

Overview

  • Association fees include common area maintenance
  • Ballenger Crossing Subdivision

Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$2,545

Year Built

Built in 1999 | Remodeled in 2019

Lot Details

0

HOA Fees

$90 per month

Listing Details

  • Property Type: Residential
  • Structure Type: Interior Row/Townhouse
  • Architectural Style: Colonial
  • Accessibility Features: Doors - Swing In, Level Entry - Main
  • Ownership: Fee Simple
  • Home Warranty: No
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2019-05-31
  • Year Built: 1999
  • Year Renovated: 2019
  • Remarks Public: Freshly painted ,New Roof 2019 , New Hardwood Floor, new carpet,new LED Recessed light in kitchen and master Bathroom,all new outlet and switches and cover plate Breakfast Area, Combination Kitchen/Dining, Kitchen - Eat-In, No Fireplace,all New Stainless Steel Appliances New Built-In Microwave,New Dishwasher, ,New Oven/Range-Gas,New Refrigerator with Ice maker,New flooring every rooms, and much more must see .
  • Special Features: VirtualTour
  • Property Sub Type: Townhouses

Interior Features

  • Appliances: Built-In Microwave, Dishwasher, Disposal, Icemaker, Oven/Range - Gas, Refrigerator, Stainless Steel Appliances, Washer, Dryer
  • Interior Amenities: Combination Kitchen/Dining, Floor Plan - Open, Kitchen - Eat-In, Kitchen - Island, Kitchen - Table Space, Recessed Lighting, Pantry
  • Door Features: Six Panel
  • Levels Count: 3+
  • Room List: Living Room, Dining Room, Primary Bedroom, Kitchen, Family Room, Basement, Breakfast Room, Bedroom 1, Bathroom 1, Bathroom 2, Primary Bathroom
  • Basement: Yes
  • Basement Type: Daylight, Partial
  • Laundry Type: Basement
  • Total Sq Ft: 1240
  • Living Area Sq Ft: 1240
  • Price Per Sq Ft: 221.69
  • Above Grade Finished Sq Ft: 1240
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 5544

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Shingle Siding
  • Road Surface Type: Black Top
  • Spa: No
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Assigned Spaces Count: 2
  • Garage: No
  • Parking Features: Assigned
  • Type Of Parking: Parking Lot

Utilities

  • Refuse: 88.00
  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Central
  • Heating: Yes
  • Hot Water: Natural Gas
  • Security: Carbon Monoxide Detector(s), Smoke Detector
  • Sewer/Septic System: Public Sewer
  • Utilities: Cable Tv Available, Natural Gas Available, Electric Available
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 90.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Fee Includes: Common Area Maintenance
  • HOA: Yes
  • Senior Community: No

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • Elementary School: BALLENGER CREEK
  • Middle School: BALLENGER CREEK
  • High School: TUSCARORA
  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • School District Key: 121139693024
  • School District Source: Listing Agent
  • Elementary School: BALLENGER CREEK
  • High School: TUSCARORA
  • Middle Or Junior School: BALLENGER CREEK

Green Features

  • Clean Green Assessed: No

Lot Info

  • Horses: No
  • Fencing: Wood
  • Improvement Assessed Value: 146900.00
  • Land Assessed Value: 63400.00
  • Land Use Code: 010
  • Lot Size Acres: 0.04
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 1600.00
  • Outdoor Living Structures: Deck(s)
  • Year Assessed: 2019
  • Zoning: PUD
  • In City Limits: No

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11571742
  • Tax Annual Amount: 2545.00
  • Assessor Parcel Number: 1128583400
  • Tax Lot: 1106
  • Tax Total Finished Sq Ft: 1240
  • County Tax Payment Frequency: Annually
  • Tax Year: 2018
  • Close Date: 06/28/2019

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 24, 2019
Sold by
Estocko Idalma and Estocko Idalma Esperanza
Bought by
Estocko Idalma Esperanza and Estocko Joseph
Current Estimated Value
$412,943

Purchase Details

Listed on
May 29, 2019
Closed on
Aug 5, 2019
Sold by
Chilin Zuly Cordero
Bought by
Cordero Chilin Zuly and Estocko Idalma
Seller's Agent
Vijay Patel
Allison James Estates & Homes
Buyer's Agent
Mechelle Brooks
Keller Williams Capital Properties
List Price
$274,900
Sold Price
$280,900
Premium/Discount to List
$6,000
2.18%

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.27%
Original Mortgage
$140,450
Outstanding Balance
$123,498
Interest Rate
4%
Mortgage Type
New Conventional
Estimated Equity
$289,445

Purchase Details

Listed on
May 29, 2019
Closed on
Jun 28, 2019
Sold by
Mid Maryland Motors Llc
Bought by
Chilin Zuly Cordero
Seller's Agent
Vijay Patel
Allison James Estates & Homes
Buyer's Agent
Mechelle Brooks
Keller Williams Capital Properties
List Price
$274,900
Sold Price
$280,900
Premium/Discount to List
$6,000
2.18%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$140,450
Outstanding Balance
$123,498
Interest Rate
4%
Mortgage Type
New Conventional
Estimated Equity
$289,445

Purchase Details

Listed on
Jan 28, 2019
Closed on
Apr 24, 2019
Sold by
Ballenger Crossings Llc
Bought by
Mid Maryland Motors Llc
Seller's Agent
Vijay Patel
Allison James Estates & Homes
Buyer's Agent
Vijay Patel
Allison James Estates & Homes
List Price
$234,900
Sold Price
$195,000
Premium/Discount to List
-$39,900
-16.99%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
659.72%
Original Mortgage
$156,000
Interest Rate
4.2%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 10, 2005
Sold by
Cendant Mobility Financial Corp
Bought by
Ballenger Crossings Llc

Purchase Details

Closed on
Mar 11, 2005
Sold by
Thomas Christine E and Thomas James Bird
Bought by
Crabtree James D and Crabtree Christine E

Purchase Details

Closed on
Jan 13, 1999
Sold by
Nvr Inc
Bought by
Thomas Christine E and Thomas James Bird
Source: Public Records

Range of Values:

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
Estocko Idalma Esperanza -- None Available
Cordero Chilin Zuly -- None Available
Chilin Zuly Cordero $280,900 Lawyers Signature Settlement
Mid Maryland Motors Llc $195,000 Lawyers Signature Settlement
Ballenger Crossings Llc $281,000 --
Cendant Mobility Financial Corp $281,000 --
Crabtree James D -- --
Thomas Christine E $127,840 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Chilin Zuly Cordero $140,450
Previous Owner Mid Maryland Motors Llc $156,000
Closed Thomas Christine E --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/28/2019 06/28/19 Sold $280,900 +2.2% $227 / Sq Ft
05/29/2019 05/29/19 For Sale $274,900 +41.0% $222 / Sq Ft
04/24/2019 04/24/19 Sold $195,000 -17.0% $106 / Sq Ft View Prior Sale
04/02/2019 04/02/19 For Sale $234,900 +20.5% $128 / Sq Ft
03/11/2019 03/11/19 Off Market $195,000 -- --
01/28/2019 01/28/19 For Sale $234,900 -- $128 / Sq Ft
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

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,477 $328,600 $85,000 $243,600
2024 $3,477 $306,867 $0 $0
2023 $3,177 $285,133 $0 $0
2022 $3,021 $263,400 $80,000 $183,400
2021 $2,806 $245,700 $0 $0
2020 $2,736 $228,000 $0 $0
2019 $2,530 $210,300 $63,400 $146,900
2018 $2,457 $209,667 $0 $0
2017 $2,508 $210,300 $0 $0
2016 $2,358 $208,400 $0 $0
2015 $2,358 $203,867 $0 $0
2014 $2,358 $199,333 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR246254

Bright MLS

APN: 28-583400