NOT LISTED FOR SALE

2629 Front Shed Dr Frederick, MD 21702

Estimated Value: $521,445

4 Beds
3.5 Baths
2,150 Sq Ft
$243/Sq Ft Est. Value

Last Sold October 23, 2024

Last sale price $525,799 $245 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $2,986/month

202 Days on Market

Highlights

  • New Construction
  • Clubhouse
  • Community Pool
  • Frederick High School Rated A-
  • Traditional Architecture
  • 2-minute walk to North Crossing Park

About This Home

As of October 2024

This Hayward Traditional is a 3-story townhome with 4 beds and 3.5 baths. Enter the home on the first floor into a Foyer space with coat closet and access to the Garage. The hallway leads back to a Guest Suite with ensuite full bathroom. The main living area is on the second floor and features a Family Room with triple windows, Kitchen, Dining Area, and Powder Room. This stunning Kitchen is finished with quartz countertops, recessed lighting, Whirlpool stainless steel appliances, crown molding, 42" cabinets, and engineered plank flooring. The Dining Area has doors leading out to a composite deck. Upstairs, the Owner's Suite has a walk-in closet and private bathroom with dual vanity and tile flooring. Two additional bedrooms with double-door closets, a full bathroom, Laundry Room, and hall closet complete the third floor.

Keystone Custom Homes is building a community of new homes in Frederick, MD, a city that has recently been ranked among the top 100 best places to live in the United States! Kellerton is a luxurious, equestrian-inspired community, nested near towns like Whittier, Cannon Bluff, and Clover Hill, and has tree-lined streets and a variety of home styles. Residents of Kellerton look forward to the community’s many amenities including tot lots for the kids to play on, several athletic fields, walking trails, a dog park, and a beautiful award-winning clubhouse with an Olympic-sized pool! Residents get to enjoy all of this and more just by stepping out their front door.

Price shown includes all applicable incentives when using a Keystone Custom Homes preferred lender. Price subject to change without notice.

Last Agent to Sell the Property

Ben Rutt

(717) 963-2903 info@keystonecustomhome.com Patriot Realty, LLC Listed on: 10/05/2023

Patriot Realty, LLC

Last Buyer's Agent

Aaron LaMere

(301) 208-2288 info@tlgestates.com Century 21 Redwood Realty License #661449

Century 21 Redwood Realty

Townhouse Details

Home Type

  • Townhome

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 2,200 Sq Ft Lot

HOA Fees

  • $88 Monthly HOA Fees

Parking

  • 1 Car Direct Access Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Frame Construction
  • Shingle Roof
  • Composition Roof
  • Stick Built Home

Interior Spaces

  • 2,150 Sq Ft Home
  • Property has 3 Levels
  • Entrance Foyer
  • Family Room
  • Dining Room
  • Laundry Room

Bedrooms and Bathrooms

  • In-Law or Guest Suite

Utilities

  • Forced Air Heating and Cooling System
  • 200+ Amp Service
  • Electric Water Heater

Community Details

Overview

  • Association fees include lawn maintenance
  • Built by Keystone Custom Homes
  • Kellerton Subdivision, Hayward Traditional Floorplan

Amenities

  • Picnic Area
  • Common Area
  • Clubhouse

Recreation

  • Soccer Field
  • Community Basketball Court
  • Community Playground
  • Community Pool
  • Dog Park
  • Jogging Path
  • Bike Trail

Townhouse Details

Home Type

Townhome

Year Built

Built in 2024 | New Construction

Lot Details

0

HOA Fees

$88 per month

Parking

1

Listing Details

  • Property Type: Residential
  • Structure Type: Interior Row/Townhouse
  • Architectural Style: Traditional
  • Ownership: Fee Simple
  • New Construction: Yes
  • Story List: Main, Upper 1, Upper 2
  • Federal Flood Zone: No
  • Year Built: 2024
  • Automatically Close On Close Date: No
  • Special Features: NewHome
  • Property Sub Type: Townhouses

Interior Features

  • Foundation Details: Slab
  • Levels Count: 3
  • Room List: Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Kitchen, Family Room, Foyer, In-Law/AuPair/Suite, Laundry, Bathroom 2, Primary Bathroom, Full Bath, Half Bath
  • Basement: No
  • Total Sq Ft: 2150
  • Living Area Sq Ft: 2150
  • Price Per Sq Ft: 233.48
  • Above Grade Finished Sq Ft: 2150
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Frame, Stick Built
  • Construction Completed: Yes
  • Roof: Composite, Shingle
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 1.00
  • Garage: Yes
  • Garage Features: Inside Access
  • Attached Garage Spaces: 1
  • Total Garage And Parking Spaces: 1
  • Type Of Parking: Off Street, Attached Garage, Driveway

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Electric Service: 200+ Amp Service
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 88.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Basketball Courts, Bike Trail, Club House, Common Grounds, Dog Park, Jog/Walk Path, Picnic Area, Soccer Field, Swimming Pool, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Lawn Maintenance
  • HOA: Yes
  • Senior Community: No

Schools

  • School District Source: 3rd Party

Lot Info

  • Lot Size Acres: 0.05
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 2200.00
  • Zoning: RESIDENTIAL
  • In City Limits: No

Building Info

  • Builder Name: Keystone Custom Homes

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: NO TAX RECORD
  • Tax Year: 2024

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 5, 2023
Closed on
Oct 30, 2024
Sold by
Ridgewall Llc
Bought by
Mccluney Charles H and Clay Ronald D
Seller's Agent
Ben Rutt
Patriot Realty, LLC
Buyer's Agent
Aaron LaMere
Century 21 Redwood Realty
List Price
$501,990
Sold Price
$525,799
Premium/Discount to List
$23,809
4.74%
Views
171
Current Estimated Value
$521,445

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$4,354
Avg. Annual Appreciation
-0.66%
Original Mortgage
$520,000
Outstanding Balance
$514,794
Interest Rate
6.09%
Mortgage Type
VA
Estimated Equity
$6,651
Source: Public Records

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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Mccluney Charles H $520,000 None Listed On Document
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mccluney Charles H $520,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/23/2024 10/23/24 Sold $525,799 +4.7% $245 / Sq Ft
04/24/2024 04/24/24 Pending -- -- --
10/05/2023 10/05/23 For Sale $501,990 -- $233 / Sq Ft
Source: Bright MLS

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 $1,558 $443,400 $85,000 $358,400
2024 $1,558 $85,000 $85,000 --
2023 $1,528 $85,000 $85,000 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2040662

Bright MLS

APN: 02-605284