NOT LISTED FOR SALE

10197 Crestview Dr Frederick, MD 21702

Lewistown Neighborhood

Estimated Value: $402,334

3 Beds
2 Baths
2,080 Sq Ft
$193/Sq Ft Est. Value

Sale Details

Date Sold: June 3, 2020

Last sale price $275,000 $132 Per Sq Ft

Est. 46% increase in value since last sale

Current estimated payment $2,516 / mo

Highlights

  • 0.37 Acre Lot
  • Pond
  • Traditional Floor Plan
  • Wood Burning Stove
  • Recreation Room
  • Rambler Architecture

About This Home

As of June 2020

Experience the ease and convenience of main level living in this well maintained rancher. Featuring 3 bedrooms and 2 fulls baths on the main level along with a living room and kitchen/dining area. Finished lower level includes a large rec room, exercise area, a den and laundry room and offers walk up access to the rear yard. Wall to wall carpeting over hardwood flooring. The oversized attached garage and storage shed w/ lean to for your fire wood offer plenty of additional storage space. Exterior highlights include a rear patio and a pond. HVAC system is only 3 years young!

Last Agent to Sell the Property

Jay Day

(877) 366-2213 mdbrokers@lptrealty.com LPT Realty, LLC License #593890 Listed on: 04/21/2020

Co-Listed By

Christina Day

(877) 366-2213 mdbrokers@lptrealty.com LPT Realty, LLC

Last Buyer's Agent

Susie Monroe

(301) 365-0664 agentsusanmonroe@gmail.com Century 21 Redwood Realty License #90156

Century 21 Redwood Realty

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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,238

Year Built

  • Built in 1971

Lot Details

  • 16,177 Sq Ft Lot
  • Infill Lot
  • Partially Fenced Property
  • Privacy Fence
  • Chain Link Fence
  • Level Lot
  • Back, Front, and Side Yard
  • Property is in very good condition

Parking

  • 1 Car Attached Garage
  • 6 Driveway Spaces
  • Oversized Parking
  • Front Facing Garage

Home Design

  • Rambler Architecture
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • Property has 2 Levels
  • Traditional Floor Plan
  • Chair Railings
  • Crown Molding
  • Ceiling Fan
  • Recessed Lighting
  • 1 Fireplace
  • Wood Burning Stove
  • Double Pane Windows
  • Double Hung Windows
  • Window Screens
  • Living Room
  • Combination Kitchen and Dining Room
  • Den
  • Recreation Room
  • Home Gym
  • Carpet
  • Garden Views
  • Attic

Kitchen

  • Built-In Oven
  • Electric Oven or Range
  • Cooktop
  • Extra Refrigerator or Freezer
  • Ice Maker

Bedrooms and Bathrooms

  • 3 Main Level Bedrooms
  • En-Suite Bathroom
  • 2 Full Bathrooms
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Laundry Room
  • Laundry on lower level
  • Dryer
  • Washer

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Interior and Exterior Basement Entry
  • Sump Pump
  • Basement Windows

Home Security

  • Storm Doors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Energy-Efficient Windows

Outdoor Features

  • Pond
  • Patio
  • Exterior Lighting
  • Shed

Utilities

  • Air Filtration System
  • Central Air
  • Vented Exhaust Fan
  • Electric Baseboard Heater
  • Underground Utilities
  • Water Treatment System
  • Well
  • Electric Water Heater
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Crestview Estates Subdivision

Listing and Financial Details

  • Tax Lot 9
  • Assessor Parcel Number 1120400129

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,238

Year Built

Built in 1971

Lot Details

0.37 Acres

Parking

1

Listing Details

  • Standard Status: Closed
  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Ranch/Rambler
  • Ownership: Fee Simple
  • Home Warranty: No
  • New Construction: No
  • Story List: Lower 1, Main
  • Expected On Market: 2020-04-21
  • Federal Flood Zone: No
  • Year Built: 1971
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Cooktop, Dryer, Washer, Exhaust Fan, Refrigerator, Extra Refrigerator/Freezer, Oven - Wall, Oven/Range - Electric, Icemaker, Water Heater
  • Interior Amenities: Attic, Air Filter System, Carpet, Ceiling Fan(s), Chair Railings, Combination Kitchen/Dining, Crown Moldings, Dining Area, Entry Level Bedroom, Floor Plan - Traditional, Primary Bath(s), Pantry, Recessed Lighting, Stall Shower, Tub Shower, Water Treat System
  • Window Features: Double Pane, Double Hung, Energy Efficient, Screens
  • Fireplaces Count: 1
  • Door Features: Storm
  • Wall Ceiling Types: Dry Wall
  • Levels Count: 2
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Kitchen, Den, Exercise Room, Laundry, Recreation Room, Primary Bathroom, Full Bath
  • Basement: Yes
  • Basement Type: Daylight, Partial, Fully Finished, Heated, Interior Access, Outside Entrance, Rear Entrance, Sump Pump, Windows, Walkout Stairs
  • Laundry Type: Washer In Unit, Dryer In Unit, Lower Floor
  • Total Sq Ft: 2080
  • Living Area Sq Ft: 2080
  • Price Per Sq Ft: 264.42
  • Above Grade Finished Sq Ft: 1040
  • Below Grade Finished Sq Ft: 1040
  • Total Below Grade Sq Ft: 1040
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 3
  • Main Level Bedrooms: 3
  • Total Bathrooms: 2
  • Full Bathrooms: 2
  • Main Level Bathrooms: 2.00
  • Main Level Full Bathrooms: 2

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Other Structures List: Shed
  • Construction Materials: Vinyl Siding
  • Exterior Features: Exterior Lighting
  • Roof: Shingle
  • View: Garden/Lawn, Street
  • 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
  • Garage Features: Garage - Front Entry, Oversized
  • Attached Garage Spaces: 1
  • Total Garage And Parking Spaces: 7
  • Type Of Parking: Attached Garage, Driveway
  • Number of Spaces in Driveway: 6

Utilities

  • Refuse: 88.00
  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Ceiling Fan(s), Central A/C
  • Heating Fuel: Electric, Wood
  • Heating Type: Baseboard - Electric, Wood Burn Stove
  • Heating: Yes
  • Hot Water: Electric
  • Security: Smoke Detector
  • Sewer/Septic System: Public Sewer
  • Utilities: Under Ground, Cable Tv
  • Water Source: Well

Condo/Co-op/Association

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

Schools

  • School District Source: Listing Agent

Green Features

  • Clean Green Assessed: No

Lot Info

  • Fencing: Partially, Chain Link, Privacy
  • Improvement Assessed Value: 119600.00
  • Land Assessed Value: 78100.00
  • Lot Features: Level, Front Yard, Sideyard(s), Rear Yard, Pond
  • Lot Size Acres: 0.37
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 16177.00
  • Outdoor Living Structures: Patio(s)
  • Property Condition: Very Good
  • Zoning: R
  • In City Limits: No

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11538737
  • Tax Annual Amount: 2238.00
  • Assessor Parcel Number: 1120400129
  • Tax Lot: 9
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2020

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

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
Apr 21, 2020
Closed on
Jun 3, 2020
Sold by
Stull Renee M and Stull Donald R
Bought by
Seller's Agent
Jay Day
LPT Realty, LLC
Buyer's Agent
Susie Monroe
Century 21 Redwood Realty
List Price
$275,000
Sold Price
$275,000
Current Estimated Value
$402,334

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$127,334
Avg. Annual Appreciation
6.22%
Original Mortgage
$261,250
Outstanding Balance
$225,867
Interest Rate
3.2%
Mortgage Type
New Conventional
Estimated Equity
$176,467

Purchase Details

Closed on
Jun 30, 2003
Sold by
Stull Donald R
Bought by
Stull Donald R and Stull Renee M
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Lewistown, MD

  • Pablo Hurtarte Real Estate Agent - RE/MAX Realty Centre, Inc.

    Pablo Hurtarte

    RE/MAX Realty Centre, Inc.

    (301) 264-6730

    84 Total Sales

    1 in Lewistown

    $42,000 Price

    Pablo Hurtarte
     Section Image
  • Heather Nahr Real Estate Agent - RE/MAX Plus

    Heather Nahr

    RE/MAX Plus

    (240) 690-5564

    57 Total Sales

    1 in Lewistown

    $690,000 Price

    Heather Nahr
     Section Image
  • Elizabeth MacLaren Real Estate Agent - RE/MAX Results

    Elizabeth MacLaren

    RE/MAX Results

    (301) 835-2488

    42 Total Sales

    1 in Lewistown

    $350,000 Price

    Elizabeth MacLaren
     Section Image
  • Jim Bass Real Estate Agent - Real Estate Teams, LLC

    Jim Bass

    Real Estate Teams, LLC

    (240) 693-3591

    407 Total Sales

    7 in Lewistown

    $152K - $1.3M Price Range

    Jim Bass
     Section Image
  • Larry Pendleton Real Estate Agent - Rory S. Coakley Realty, Inc.

    Larry Pendleton

    Rory S. Coakley Realty, Inc.

    (301) 756-5816

    27 Total Sales

    1 in Lewistown

    $270,000 Price

    Larry Pendleton
     Section Image
  • Jim Keating Real Estate Agent - Keller Williams Realty Centre

    Jim Keating

    Keller Williams Realty Centre

    (240) 376-2694

    163 Total Sales

    2 in Lewistown

    $245K - $555K Price Range

    Jim Keating
     Section Image
See All Agents

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
$275,000 None Available
Stull Donald R -- --
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 $261,250
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
06/03/2020 06/03/20 Sold $275,000 0.0% $132 / Sq Ft
04/21/2020 04/21/20 For Sale $275,000 -- $132 / 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 $2,923 $305,533
2025 $2,751 $287,800 $93,700 $194,100
2024 $2,751 $257,767 $0 $0
2023 $2,532 $227,733 $0 $0
2022 $2,384 $197,700 $78,100 $119,600
2021 $2,302 $192,967 $0 $0
2020 $2,274 $188,233 $0 $0
2019 $1,290 $183,500 $71,600 $111,900
2018 $2,151 $183,500 $71,600 $111,900
2017 $2,246 $183,500 $0 $0
2016 $2,002 $185,800 $0 $0
2015 $2,002 $180,933 $0 $0
2014 $2,002 $176,067 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Jay Day Real Estate Agent - LPT Realty, LLC

    Seller's Agent in 2020

    Jay Day

    LPT Realty, LLC

    (866) 702-9038

    2 in this area

    1,115 Total Sales

    Jay Day
    Section Image
  • Christina Day Real Estate Agent - LPT Realty, LLC

    Seller Co-Listing Agent in 2020

    Christina Day

    LPT Realty, LLC

    (240) 405-4883

    1 in this area

    215 Total Sales

    Christina Day
    Section Image
  • Susie Monroe Real Estate Agent - Century 21 Redwood Realty

    Buyer's Agent in 2020

    Susie Monroe

    Century 21 Redwood Realty

    (301) 996-9284

    15 Total Sales

    Susie Monroe
    Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR262140

Bright MLS

APN: 20-400129

Maryland Frederick County Frederick 21702 Lewistown

10197 Crestview Dr, Frederick, MD

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.

Bright MLS 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
Your Personal Tour Guide

Ask me questions while you tour the home.