$799,990
PENDING

15 Wagon Shed Ln Middletown, MD 21769

Estimated payment $4,995/month

Total Views 15,016
4 Beds
3.5 Baths
4,914 Sq Ft
$163 Price per Sq Ft

Highlights

  • Eat-In Gourmet Kitchen
  • Open Floorplan
  • Cathedral Ceiling
  • Middletown Elementary School Rated A-
  • Colonial Architecture
  • Backs to Trees or Woods

About This Home

OPEN HOUSE CANCELLED DUE TO PENDING CONTRACT. Imagine cozy evenings by the gas fireplace in this stunning brick-front colonial in Glenbrook! Step into a grand two-story foyer with gleaming mahogany hardwood floors, leading to a gourmet kitchen with granite countertops, a central island, and high-end cabinetry—perfect for family gatherings. The luxurious primary suite boasts a tray ceiling, dual walk-in closets, and a spa-like ensuite with a soaking tub and bidet. Three additional spacious bedrooms include a Jack-and-Jill bath and one bedroom has a private ensuite. Entertain in the finished walkout basement or relax on the charming stone patio and 20x20 composite deck, ideal for seamless indoor-outdoor living. With tray ceilings, Corinthian columns, and a private office, every detail exudes sophistication. Walk to restaurants, grocery stores, and Middletown Park, with Middletown schools and downtown Frederick nearby.

Listing Agent

Christine Reeder

(301) 606-8611 chris.reeder@longandfoster.com Long & Foster Real Estate, Inc. License #581222 Listed on: 08/25/2025

Long & Foster Real Estate, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,583

Year Built

  • Built in 2009

Lot Details

  • 0.29 Acre Lot
  • Landscaped
  • Backs to Trees or Woods

HOA Fees

  • $55 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Shingle Roof
  • Asphalt Roof
  • Brick Front
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Chair Railings
  • Crown Molding
  • Tray Ceiling
  • Cathedral Ceiling
  • Ceiling Fan
  • Heatilator
  • Fireplace With Glass Doors
  • Screen For Fireplace
  • Fireplace Mantel
  • Window Treatments
  • Entrance Foyer
  • Family Room Off Kitchen
  • Living Room
  • Dining Room
  • Den
  • Library
  • Game Room
  • Storage Room
  • Home Gym
  • Wood Flooring
  • Attic

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Room
  • Built-In Self-Cleaning Double Oven
  • Cooktop
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Soaking Tub

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Connecting Stairway
  • Rear Basement Entry
  • Sump Pump
  • Basement with some natural light

Outdoor Features

  • Brick Porch or Patio

Schools

  • Middletown
  • Middletown High School

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Vented Exhaust Fan
  • Natural Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 1103170659

Community Details

Overview

  • Association fees include snow removal
  • Glenbrook Subdivision

Amenities

  • Common Area

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,583

Year Built

Built in 2009

Lot Details

0

HOA Fees

$55 per month

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
  • Year Built: 2009
  • Automatically Close On Close Date: No
  • Building Winterized: No
  • Remarks Public: OPEN HOUSE CANCELLED DUE TO PENDING CONTRACT. Imagine cozy evenings by the gas fireplace in this stunning brick-front colonial in Glenbrook! Step into a grand two-story foyer with gleaming mahogany hardwood floors, leading to a gourmet kitchen with granite countertops, a central island, and high-end cabinetry—perfect for family gatherings. The luxurious primary suite boasts a tray ceiling, dual walk-in closets, and a spa-like ensuite with a soaking tub and bidet. Three additional spacious bedrooms include a Jack-and-Jill bath and one bedroom has a private ensuite. Entertain in the finished walkout basement or relax on the charming stone patio and 20x20 composite deck, ideal for seamless indoor-outdoor living. With tray ceilings, Corinthian columns, and a private office, every detail exudes sophistication. Walk to restaurants, grocery stores, and Middletown Park, with Middletown schools and downtown Frederick nearby.
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Exhaust Fan, Humidifier, Icemaker, Microwave, Oven - Double, Oven - Self Cleaning, Oven - Wall, Refrigerator, Washer, Dryer
  • Interior Amenities: Attic, Breakfast Area, Family Room Off Kitchen, Kitchen - Gourmet, Kitchen - Island, Kitchen - Table Space, Dining Area, Kitchen - Eat-In, Primary Bath(s), Chair Railings, Crown Moldings, Window Treatments, Upgraded Countertops, Wood Floors, Floor Plan - Open
  • Fireplace Features: Fireplace - Glass Doors, Heatilator, Mantel(s), Screen
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Wall Ceiling Types: 2 Story Ceilings, 9'+ Ceilings, Cathedral Ceilings, Tray Ceilings
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Game Room, Family Room, Library, Foyer, Breakfast Room, Exercise Room, Laundry, Office, Storage Room, Bathroom 2, Bathroom 3, Primary Bathroom
  • Basement: Yes
  • Basement Type: Connecting Stairway, Rear Entrance, Sump Pump, Daylight, Partial, Full, Fully Finished, Improved, Outside Entrance, Walkout Level
  • Total Sq Ft: 5102
  • Living Area Sq Ft: 4914
  • Price Per Sq Ft: 234.33
  • Above Grade Finished Sq Ft: 3414
  • Below Grade Finished Sq Ft: 1500
  • Below Grade Sq Ft: 188
  • Total Below Grade Sq Ft: 1688
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 15

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Brick, Combination, Brick Front
  • Exterior Features: Sidewalks
  • Roof: Asphalt, Shingle
  • 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: Garage Door Opener
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Off Street, Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Ceiling Fan(s), Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air, Humidifier
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 55.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Common Grounds
  • HOA Condo Co-Op Fee Includes: Snow Removal
  • HOA: Yes
  • Senior Community: No

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • Elementary School: MIDDLETOWN
  • Middle School: MIDDLETOWN
  • High School: MIDDLETOWN
  • 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: MIDDLETOWN
  • High School: MIDDLETOWN
  • Middle Or Junior School: MIDDLETOWN

Lot Info

  • Additional Parcels: No
  • Lot Features: Backs To Trees, Landscaping
  • Lot Size Acres: 0.29
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 12455.00
  • Outdoor Living Structures: Brick
  • Zoning: R
  • In City Limits: Yes

Rental Info

  • Lease Considered: No
  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 8583.00
  • Assessor Parcel Number: 1103170659
  • County Tax Payment Frequency: Annually
  • Tax Year: 2025

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Map

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

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,172 $647,367 -- --
2024 $8,172 $590,333 $0 $0
2023 $7,494 $533,300 $108,300 $425,000
2022 $7,477 $532,033 $0 $0
2021 $7,450 $530,767 $0 $0
2020 $7,522 $529,500 $103,200 $426,300
2019 $7,421 $528,000 $0 $0
2018 $7,392 $526,500 $0 $0
2017 $7,103 $525,000 $0 $0
2016 $5,935 $505,100 $0 $0
2015 $5,935 $485,200 $0 $0
2014 $5,935 $465,300 $0 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/14/2025 09/14/25 Pending -- -- --
08/25/2025 08/25/25 For Sale $799,990 +6.7% $163 / Sq Ft
05/12/2022 05/12/22 Sold $750,000 +9.5% $153 / Sq Ft
04/01/2022 04/01/22 Pending -- -- --
03/25/2022 03/25/22 For Sale $685,000 -- $139 / Sq Ft
Source: Bright MLS

Purchase History

Date Type Sale Price Title Company
Deed $750,000 Foley John P
Interfamily Deed Transfer -- --
Deed -- --
Deed $510,000 --
Interfamily Deed Transfer -- --
Deed $470,640 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $167,337 Construction
Open $425,000 New Conventional
Previous Owner $339,724 New Conventional
Previous Owner $399,000 Adjustable Rate Mortgage/ARM
Previous Owner $408,000 New Conventional
Previous Owner $376,512 New Conventional
Closed -- No Value Available
Source: Public Records

Source: Bright MLS

MLS Number: MDFR2069414

Bright MLS

APN: 03-170659