NOT LISTED FOR SALE

9912 Arapahoe Rd New Market, MD 21774

Estimated Value: $753,820 - $794,000

5 Beds
3.5 Baths
3,209 Sq Ft
$240/Sq Ft Est. Value

Last Sold January 17, 2022

Last sale price $663,000 $207 Per Sq Ft

Est. 16% increase in value since last sale

Current estimated payment $4,779/month

Highlights

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

About This Home

As of January 2022

Welcome to this two year young, five bedroom, three and one half bathroom craftsman style home located in the desirable community of Aspen North, part of Lake Linganore Association. This Dillon model features over three thousand square feet of an open floor concept with a large kitchen, upgraded cabinets, huge island and eat-in kitchen. Kitchen opens into the family room with an inviting fireplace and LOTS of windows. Gleaming hardwood floors throughout the main level, beautiful paint, shelving, custom mantel & more. Dining room or office, you pick? Enjoy the breathtaking views while you drink your coffee from the second level deck. Check out the oversized bedrooms, especially the primary suite that does not disappoint. Lower level includes the fifth bedroom with a full bathroom and fabulous recreation room. Walkout basement also includes plenty of storage. No details have been missed with this home. This is a very special property in an equally special community with so much to offer. It is an absolute must see and won’t last long!! Enjoy the incredible Linganore lifestyle! 3 deep navigable lakes, 3 sandy beaches, Multiple pools, boating, fishing, swimming, tennis, basketball, beach volleyball, nature & bike trails, Frisbee golf, pickleball, Event Tent, Farmers Markets, Summer Concert Series under the stars, playgrounds and so much more ... Come and see for yourself.

Last Agent to Sell the Property

Stacy Allwein

(301) 606-6716 Stacy@allweinteam.com Real Broker, LLC - Frederick License #0225269520 Listed on: 12/10/2021

Real Broker, LLC - Frederick

Last Buyer's Agent

Stacy Delisle

(301) 646-9625 stacy.delisle@gmail.com IMPACT Maryland Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,281

Year Built

  • Built in 2019

Lot Details

  • Landscaped

HOA Fees

  • $168 Monthly HOA Fees

Parking

  • 2 Car Detached Garage
  • Front Facing Garage

Home Design

  • Asphalt Roof
  • Stone Siding
  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Ceiling height of 9 feet or more
  • Fireplace Mantel
  • Double Pane Windows
  • Sliding Doors
  • Entrance Foyer
  • Great Room
  • Family Room
  • Combination Kitchen and Dining Room
  • Den
  • Wood Flooring
  • Attic

Kitchen

  • Gas Oven or Range
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Bedrooms and Bathrooms

  • En-Suite Bathroom

Laundry

  • Laundry Room
  • Washer and Dryer Hookup

Basement

  • Walk-Out Basement
  • Connecting Stairway

Home Security

  • Fire and Smoke Detector
  • Fire Sprinkler System

Outdoor Features

  • Lake Privileges
  • Deck

Schools

  • Oakdale High School

Utilities

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

Listing and Financial Details

  • Tax Lot 46
  • Assessor Parcel Number 1127525121

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 Dillon 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

$5,281

Year Built

Built in 2019

Lot Details

0

HOA Fees

$168 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Year Built: 2019
  • Automatically Close On Close Date: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Washer/Dryer Hookups Only, Dishwasher, Disposal, Icemaker, Microwave, Oven/Range - Gas, Refrigerator, Exhaust Fan
  • Interior Amenities: Attic, Kitchen - Island, Combination Kitchen/Dining, Primary Bath(s), Upgraded Countertops, Wood Floors, Floor Plan - Open
  • Window Features: Double Pane
  • Fireplace Features: Mantel(s)
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Door Features: Sliding Glass
  • Wall Ceiling Types: 9'+ Ceilings, Dry Wall
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Room List: Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Family Room, Foyer, Study, Great Room, Laundry
  • Basement: Yes
  • Basement Type: Connecting Stairway, Walkout Level
  • Total Sq Ft: 3752
  • Living Area Sq Ft: 3209
  • Price Per Sq Ft: 259.03
  • Above Grade Finished Sq Ft: 2509
  • Below Grade Finished Sq Ft: 700
  • Below Grade Sq Ft: 543
  • Total Below Grade Sq Ft: 1243
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 5
  • All Lower Level Bedrooms: 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
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Vinyl Siding, Stone, Combination
  • 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
  • Number Of Detached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Detached Garage

Utilities

  • Refuse: 88.00
  • 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: 2012.11
  • HOA Fee Frequency: Annually
  • 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

  • School District Source: Listing Agent
  • High School: OAKDALE

Green Features

  • Clean Green Assessed: No

Lot Info

  • Improvement Assessed Value: 359600.00
  • Land Assessed Value: 91000.00
  • Lot Features: Landscaping
  • Lot Size Units: Square Feet
  • Outdoor Living Structures: Deck(s)
  • In City Limits: No

Building Info

  • Builder Name: MILLER AND SMITH

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11554939
  • Tax Annual Amount: 5281.00
  • Assessor Parcel Number: 1127525121
  • Tax Lot: 46
  • County Tax Payment Frequency: Annually
  • Tax Year: 2021

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 10, 2021
Closed on
Jan 18, 2022
Sold by
Shaun Pierce Ernest
Bought by
Ramsey Gregory and Ramsey Laura
Seller's Agent
Stacy Allwein
Real Broker, LLC - Frederick
Buyer's Agent
Stacy Delisle
IMPACT Maryland Real Estate
List Price
$649,900
Sold Price
$663,000
Premium/Discount to List
$13,100
2.02%
Current Estimated Value
$769,205

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$106,205
Avg. Annual Appreciation
3.95%
Original Mortgage
$428,000
Interest Rate
3.45%
Mortgage Type
New Conventional

Purchase Details

Listed on
Apr 12, 2019
Closed on
Jun 21, 2019
Sold by
Ms Aspen North Llc
Bought by
Pierce Ernest Shaun and Pierce Morgan B
Seller's Agent
Spence Stouffer
Miller and Smith Homes, Inc.
Buyer's Agent
Eric McLellan
Keller Williams Realty Centre
List Price
$485,820
Sold Price
$479,990
Premium/Discount to List
-$5,830
-1.2%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.45%
Original Mortgage
$471,295
Interest Rate
3.9%
Mortgage Type
FHA

Purchase Details

Closed on
Jul 8, 2014
Sold by
Union #2 Llc
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
Oct 11, 2006
Sold by
Stancill Raymond T and Stancill Cheryl L
Bought by
Radcliffe Albert A and Mann Gail C

Purchase Details

Closed on
Sep 28, 2006
Sold by
Stancill Raymond T and Stancill Cheryl L
Bought by
Radcliffe Albert A and Mann Gail C

Purchase Details

Closed on
Oct 13, 1998
Sold by
Siegfried Kristine M
Bought by
Stancill Raymond T and Stancill Cheryl L
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
Ramsey Gregory $663,000 Hallein Katrina
Pierce Ernest Shaun $479,990 Hallmark Title Inc
Ms Aspen North Llc $61,900 Hallmark Title Inc
Radcliffe Albert A $19,500 --
Radcliffe Albert A $19,500 --
Stancill Raymond T $4,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Closed Ramsey Gregory $428,000
Previous Owner Pierce Ernest Shaun $471,295
Previous Owner Ms Aspen North Llc $9,375,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/17/2022 01/17/22 Sold $663,000 +2.0% $207 / Sq Ft
12/12/2021 12/12/21 Pending -- -- --
12/10/2021 12/10/21 For Sale $649,900 +35.4% $203 / Sq Ft
06/28/2019 06/28/19 Sold $479,990 0.0% $158 / Sq Ft View Prior Sale
05/02/2019 05/02/19 Price Changed $479,990 -1.2% $158 / Sq Ft
04/12/2019 04/12/19 For Sale $485,820 -- $160 / 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 $6,678 $610,333 -- --
2024 $6,678 $571,900 $111,000 $460,900
2023 $6,094 $531,467 $0 $0
2022 $5,791 $491,033 $0 $0
2021 $5,132 $450,600 $91,000 $359,600
2020 $4,988 $418,067 $0 $0
2019 $4,566 $385,533 $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
  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2009894

Bright MLS

APN: 27-525121