NOT LISTED FOR SALE

4254 Urbana Pike Frederick, MD 21704

Estimated Value: $893,677 - $1,041,000

4 Beds
4.5 Baths
4,768 Sq Ft
$197/Sq Ft Est. Value

Last Sold December 06, 2021

Last sale price $710,000 $149 Per Sq Ft

Est. 32% increase in value since last sale

Current estimated payment $5,597/month

Highlights

  • 1.89 Acre Lot
  • Colonial Architecture
  • No HOA
  • Urbana Elementary School Rated A
  • 1 Fireplace
  • 2 Car Attached Garage

About This Home

As of December 2021

Huge price cut. 1.87 Acaras Lot and a Colonel Custom Built home with over 4500 sq feet of living space. Urbana Schools, Rare find. Located just off of Urbana Pike. Home features 4 bedrooms, 4.5 baths, Deck over looking lush green, 2 car garage, finished LL with a theater room, First floor office room and a den that can be easily converted in to a bedroom. hardwood floor, Master bedroom comes with a cozy fireplace.

Last Agent to Sell the Property

Dilantha Perera

(240) 277-6625 dilanperera@comcast.net Fairfax Realty Premier Listed on: 10/12/2021

Fairfax Realty Premier

Last Buyer's Agent

Eddie DeLuca

(240) 938-2121 deluca.team@realtor.com Redfin Corp License #SP98378347

Redfin Corp

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,585

Year Built

  • Built in 1989

Lot Details

  • 1.89 Acre Lot
  • Property is zoned R1

Parking

  • 2 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • Property has 3 Levels
  • 1 Fireplace

Bedrooms and Bathrooms

  • 4 Bedrooms

Finished Basement

  • Walk-Out Basement
  • Rear Basement Entry

Schools

  • Urbana Elementary And Middle School
  • Urbana High School

Utilities

  • Forced Air Heating System
  • Heating System Uses Oil
  • Heat Pump System
  • Well
  • Electric Water Heater
  • Septic Tank

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Tax Lot 3
  • Assessor Parcel Number 1107192924

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,585

Year Built

Built in 1989

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2021-10-12
  • Year Built: 1989
  • Automatically Close On Close Date: Yes
  • Remarks Public: Huge price cut. 1.87 Acaras Lot and a Colonel Custom Built home with over 4500 sq feet of living space. Urbana Schools, Rare find. Located just off of Urbana Pike. Home features 4 bedrooms, 4.5 baths, Deck over looking lush green, 2 car garage, finished LL with a theater room, First floor office room and a den that can be easily converted in to a bedroom. hardwood floor, Master bedroom comes with a cozy fireplace.
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Fireplaces Count: 1
  • Foundation Details: Other
  • Levels Count: 3
  • Room List: Bathroom 1
  • Basement: Yes
  • Basement Type: Fully Finished, Outside Entrance, Rear Entrance, Walkout Level
  • Total Sq Ft: 5018
  • Living Area Sq Ft: 4768
  • Price Per Sq Ft: 207.84
  • Above Grade Finished Sq Ft: 3368
  • Below Grade Finished Sq Ft: 1400
  • Below Grade Sq Ft: 250
  • Total Below Grade Sq Ft: 1650
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 4254

Beds/Baths

  • Bedrooms: 4
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 3
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 3.00
  • Lower Levels Bathrooms: 1.00
  • Upper Level Full Bathrooms: 3
  • 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: Brick
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Garage Features: Built In
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage

Utilities

  • Refuse: 88.00
  • Central Air Conditioning: No
  • Cooling Fuel: Electric
  • Cooling Type: Heat Pump(s)
  • Heating Fuel: Oil, Electric
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Private Septic Tank
  • Water Source: Well

Condo/Co-op/Association

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

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • Elementary School: URBANA
  • Middle School: URBANA
  • High School: URBANA
  • Elementary School Source: 3rd Party
  • High School Source: 3rd Party
  • Middle School Source: 3rd Party
  • School District Key: 121139693024
  • School District Source: 3rd Party
  • Elementary School: URBANA
  • High School: URBANA
  • Middle Or Junior School: URBANA

Green Features

  • Clean Green Assessed: No

Lot Info

  • Improvement Assessed Value: 342200.00
  • Land Assessed Value: 139400.00
  • Land Use Code: 010
  • Lot Size Acres: 1.89
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 82328.00
  • Year Assessed: 2021
  • Zoning: R1
  • In City Limits: No

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11520724
  • Tax Annual Amount: 5585.00
  • Assessor Parcel Number: 1107192924
  • Tax Lot: 3
  • Tax Total Finished Sq Ft: 4768
  • County Tax Payment Frequency: Annually
  • Tax Year: 2020
  • Close Date: 12/06/2021

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 12, 2021
Closed on
Dec 7, 2021
Sold by
Herath Ramesh N and Herath Thanugee D
Bought by
Mugore Stembile
Seller's Agent
Dilantha Perera
Fairfax Realty Premier
Buyer's Agent
Eddie DeLuca
Redfin Corp
List Price
$750,000
Sold Price
$710,000
Premium/Discount to List
-$40,000
-5.33%
Current Estimated Value
$936,919

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$226,919
Avg. Annual Appreciation
7.41%
Original Mortgage
$697,140
Outstanding Balance
$640,062
Interest Rate
2.98%
Mortgage Type
FHA
Estimated Equity
$296,857

Purchase Details

Closed on
Jan 13, 2010
Sold by
Bank Of America National Assoc
Bought by
Herath Ramesh N and Herath Thanugee D

Purchase Details

Closed on
Apr 30, 2009
Sold by
Ayerdiz Marvin and Ayerdiz Aydelina
Bought by
Bank Of America National Assoc

Purchase Details

Closed on
Mar 3, 2006
Sold by
Cendant Mobility Fin Corp
Bought by
Ayerdiz Marvin and Ayerdiz Aydelina

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$500,000
Interest Rate
6.94%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Mar 15, 2005
Sold by
Cendant Mobility Fin Corp
Bought by
Ayerdiz Marvin and Ayerdiz Aydelina

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$500,000
Interest Rate
6.94%
Mortgage Type
Purchase Money Mortgage
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
Mugore Stembile $710,000 Classic Settlements Inc
Herath Ramesh N $375,900 --
Bank Of America National Assoc $343,000 --
Ayerdiz Marvin $625,000 --
Cendant Mobility Fin Corp $625,000 --
Ayerdiz Marvin $625,000 --
Cendant Mobility Fin Corp $625,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mugore Stembile $697,140
Previous Owner Cendant Mobility Fin Corp $500,000
Previous Owner Cendant Mobility Fin Corp $500,000
Closed Herath Ramesh N --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/06/2021 12/06/21 Sold $710,000 +1.4% $149 / Sq Ft
10/17/2021 10/17/21 Price Changed $700,000 -6.7% $147 / Sq Ft
10/12/2021 10/12/21 For Sale $750,000 -- $157 / 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 $8,190 $709,000 -- --
2024 $8,190 $664,100 $176,600 $487,500
2023 $7,154 $603,267 $0 $0
2022 $6,448 $542,433 $0 $0
2021 $5,639 $481,600 $139,400 $342,200
2020 $5,585 $463,933 $0 $0
2019 $5,331 $446,267 $0 $0
2018 $5,023 $428,600 $139,400 $289,200
2017 $4,941 $428,600 $0 $0
2016 $4,838 $412,667 $0 $0
2015 $4,838 $404,700 $0 $0
2014 $4,838 $404,700 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2006934

Bright MLS

APN: 07-192924