NOT LISTED FOR SALE

9924 Arapahoe Rd New Market, MD 21774

Estimated Value: $785,908 - $837,000

4 Beds
2.5 Baths
3,620 Sq Ft
$222/Sq Ft Est. Value

Last Sold April 11, 2019

Last sale price $531,530 $147 Per Sq Ft

Est. 48% increase in value since last sale

Current estimated payment $4,961/month

Highlights

  • Newly Remodeled
  • Open Floorplan
  • Wood Flooring
  • Deer Crossing Elementary School Rated A-
  • Lake Privileges
  • Attic

About This Home

As of April 2019

NEW MILLER AND SMITH HOME IN LAKE LINGANORE AT ASPEN NORTH. READY TO MOVE IN. The stunning 5 BR Hillrose floor plan features up to 3600 square feet, an open light-filled main level with beautiful mountain views, connoisseur kitchen with over sized island, desirable great room with stone fireplace, large Owner's suite, spacious master bathroom and much more! List price is subject to change.

Last Agent to Sell the Property

Spence Stouffer

(703) 821-2500 newhomes@millerandsmith.com Miller and Smith Homes, Inc. Listed on: 01/03/2019

Last Buyer's Agent

Shirley Matlock

(410) 465-7777 ShirleyMatlock@remax.net RE/MAX Advantage Realty License #317903

RE/MAX Advantage Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,667

Year Built

  • Built in 2018 | Newly Remodeled

HOA Fees

  • $170 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage

Home Design

  • Asphalt Roof
  • Vinyl Siding

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Tray Ceiling
  • Ceiling height of 9 feet or more
  • 1 Fireplace
  • Double Pane Windows
  • Sliding Doors
  • Entrance Foyer
  • Great Room
  • Family Room
  • Combination Kitchen and Dining Room
  • Den
  • Loft
  • Wood Flooring
  • Partially Finished Basement
  • Connecting Stairway
  • Attic

Kitchen

  • Eat-In Kitchen
  • Built-In Oven
  • Cooktop
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom

Laundry

  • Laundry Room
  • Laundry on upper level
  • Washer and Dryer Hookup

Home Security

  • Fire and Smoke Detector
  • Fire Sprinkler System

Schools

  • Deer Crossing Elementary School
  • Oakdale Middle School
  • Oakdale High School

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Programmable Thermostat
  • Underground Utilities
  • Electric Water Heater
  • Cable TV Available

Additional Features

  • Lake Privileges
  • Landscaped

Listing and Financial Details

  • Home warranty included in the sale of the property

Community Details

Overview

  • Association fees include pool(s), reserve funds, snow removal, trash, road maintenance, management, insurance
  • Built by MILLER AND SMITH
  • Aspen North At Lake Linganore Subdivision, The Hillrose Floorplan

Amenities

  • Common Area

Recreation

  • Tennis Courts
  • Community Basketball Court
  • Community Playground
  • Community Pool
  • Jogging Path
  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,667

Year Built

Built in 2018 | Newly Remodeled

Lot Details

0

HOA Fees

$170 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Ownership: Fee Simple
  • Home Warranty: Yes
  • Inclusions: Parking Included In ListPrice,Parking Included In SalePrice
  • New Construction: Yes
  • Story List: Lower 1, Main, Upper 1
  • Year Built: 2018
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Appliances: Washer/Dryer Hookups Only, Dishwasher, Disposal, Exhaust Fan, Icemaker, Microwave, Refrigerator, Oven - Wall, Cooktop
  • Interior Amenities: Kitchen - Island, Combination Kitchen/Dining, Kitchen - Table Space, Primary Bath(s), Floor Plan - Open, Attic, Wood Floors
  • Window Features: Double Pane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Door Features: Sliding Glass
  • Wall Ceiling Types: 9'+ Ceilings, Dry Wall, Tray Ceilings
  • Levels Count: 3+
  • Room List: Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 5, Kitchen, Family Room, Basement, Foyer, Study, Great Room, Laundry, Loft, Additional Bedroom
  • Basement: Yes
  • Basement Type: Connecting Stairway, Partially Finished
  • Laundry Type: Upper Floor, Hookup
  • Total Sq Ft: 3620
  • Living Area Sq Ft: 3620
  • Price Per Sq Ft: 198.19
  • Above Grade Finished Sq Ft: 2687
  • Below Grade Finished Sq Ft: 933
  • Total Below Grade Sq Ft: 933
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Vinyl Siding
  • Construction Completed: Yes
  • Roof: Asphalt
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Garage Features: Garage - Front Entry
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C, Programmable Thermostat
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air, Programmable Thermostat
  • Heating: Yes
  • Hot Water: Electric
  • Security: Sprinkler System - Indoor, Fire Detection System
  • Sewer/Septic System: Public Sewer
  • Utilities: Cable Tv Available, Under Ground
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 169.88
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Pool - Outdoor, Tot Lots/Playground, Common Grounds, Jog/Walk Path, Tennis Courts, Water/Lake Privileges, Basketball Courts, Bike Trail
  • HOA Condo Co-Op Fee Includes: Pool(s), Reserve Funds, Snow Removal, Trash, Road Maintenance, Management, Insurance
  • HOA: Yes
  • Senior Community: No

Schools

  • Middle School Source: Listing Agent
  • Elementary School: DEER CROSSING
  • High School: OAKDALE
  • Middle Or Junior School: OAKDALE

Lot Info

  • Lot Features: Landscaping
  • Lot Size Units: Square Feet
  • Property Attached Yn: No
  • In City Limits: No

Building Info

  • Builder Name: MILLER AND SMITH

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Data Updated: No
  • Tax Year: 2018

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 3, 2019
Closed on
Mar 19, 2019
Sold by
Ms Aspen North Llc
Bought by
Franich Benjamin and Tedesco Sarah
Seller's Agent
Spence Stouffer
Miller and Smith Homes, Inc.
Buyer's Agent
Shirley Matlock
RE/MAX Advantage Realty
List Price
$532,540
Sold Price
$531,530
Premium/Discount to List
-$1,010
-0.19%
Current Estimated Value
$787,679

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$256,149
Avg. Annual Appreciation
6.52%
Original Mortgage
$504,955
Outstanding Balance
$443,037
Interest Rate
4.3%
Mortgage Type
New Conventional
Estimated Equity
$360,940

Purchase Details

Closed on
Jul 8, 2014
Sold by
Dertzbaugh Frank M and Dertzbaugh Denise
Bought by
Ms Aspen North Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$9,375,000
Interest Rate
4.18%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jun 5, 2001
Sold by
Colvin Lucie G
Bought by
Dertzbaugh Frank M and Dertzbaugh Denise
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
Franich Benjamin $531,530 Hallmark Title Inc
Ms Aspen North Llc $866,600 Hallmark Title Inc
Dertzbaugh Frank M $5,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Franich Benjamin $504,955
Previous Owner Ms Aspen North Llc $9,375,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/11/2019 04/11/19 Sold $531,530 -0.2% $147 / Sq Ft
03/06/2019 03/06/19 Pending -- -- --
01/03/2019 01/03/19 For Sale $532,540 -- $147 / 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 $7,667 $662,400 -- --
2024 $7,667 $625,900 $112,100 $513,800
2023 $6,843 $581,600 $0 $0
2022 $6,328 $537,300 $0 $0
2021 $5,725 $493,000 $92,100 $400,900
2020 $5,636 $477,733 $0 $0
2019 $5,459 $462,467 $0 $0
2018 $352 $30,000 $30,000 $0
2017 $136 $30,000 $0 $0
2016 $543 $11,667 $0 $0
2015 $543 $2,500 $0 $0
2014 $543 $2,500 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR190748

Bright MLS

APN: 27-510779