NOT LISTED FOR SALE

254 Stallion St Frederick, MD 21702

Myersville Area

Estimated Value: $474,804

3 Beds
2.5 Baths
2,339 Sq Ft
$203/Sq Ft Est. Value

Sale Details

Date Sold: August 9, 2023

Last sale price $449,425 $192 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $2,611 / mo

1 Day on Market

Highlights

  • New Construction
  • Traditional Architecture
  • Tankless Water Heater
  • Wolfsville Elementary School Rated 10
  • 2 Car Attached Garage
  • Central Heating and Cooling System

About This Home

As of August 2023

--TO BE BUILT--Schubert D-- The largest of the Composer II series homes, offers the space and customizing details of single-family living with the convenience of a townhome. On the main living level, you're greeted by an enormous and airy kitchen with a 12 foot island perfect for entertaining. The dining room provides space for a more formal meal while the great room is perfect for movie night evenings at home. The upper level boasts three bedrooms, two baths, and a full sized 2nd floor laundry with extra shelf space and laundry tub. No need to worry about storage space with generous closets abound in both bedrooms. The Owner's Bedroom is a private retreat accented with an optional tray ceiling and featuring an enormous walk-in closet. The Owner's Bath boasts a soaking tub and separate shower with seat and a dual vanity for the ultimate in convenience. This home includes a large trex deck over the backyard! Other floorplans and homesites available. Photos are representative.

Last Agent to Sell the Property

Tineshia Johnson

(410) 878-7465 nvrbroker@nvrinc.com NVR, INC. Brokerage Phone: 4108787465 License #WVB230300909 Listed on: 03/08/2023

Last Buyer's Agent

Eartha Degannes

(888) 860-7369 md.broker@exprealty.net EXP Realty, LLC License #5002947

EXP Realty, LLC

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

Townhouse Details

Home Type

  • Townhome

Year Built

  • Built in 2023 | New Construction

Lot Details

  • 2,000 Sq Ft Lot
  • Property is in excellent condition

HOA Fees

  • $84 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Slab Foundation

Interior Spaces

  • 2,339 Sq Ft Home
  • Property has 3 Levels
  • Finished Basement

Bedrooms and Bathrooms

  • 3 Bedrooms

Utilities

  • Central Heating and Cooling System
  • Heating System Uses Natural Gas
  • Tankless Water Heater

Community Details

  • Built by RYAN HOMES
  • Schubert D Garage Tbb

Listing and Financial Details

  • Tax Lot WFRBN0056B

Townhouse Details

Home Type

Townhome

Year Built

Built in 2023 | New Construction

Lot Details

2,000 Sq Ft Lot

HOA Fees

$84 per month

Parking

2

Listing Details

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

Interior Features

  • Foundation Details: Slab
  • Levels Count: 3
  • Basement: Yes
  • Basement Type: Fully Finished
  • Total Sq Ft: 2339
  • Living Area Sq Ft: 2339
  • Price Per Sq Ft: 192.14
  • Above Grade Finished Sq Ft: 2339
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 3
  • 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
  • Construction Materials: Mixed
  • Construction Completed: No
  • 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 - Front Entry, Garage Door Opener
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage, Driveway

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Central
  • Heating: Yes
  • Hot Water: Tankless
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 84.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA: Yes
  • Senior Community: No

Schools

  • School District Source: Listing Agent

Lot Info

  • Lot Size Acres: 0.05
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 2000.00
  • Property Condition: Excellent
  • Zoning: RESIDENTIAL
  • In City Limits: Yes

Building Info

  • Builder Name: RYAN HOMES

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: NO TAX RECORD
  • Tax Lot: WFRBN0056B
  • Tax Year: 2023

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Frederick, MD

  • Sharon Cremen Real Estate Agent - Berkshire Hathaway HomeServices Homesale Realty

    Sharon Cremen

    Berkshire Hathaway HomeServices Homesale Realty

    (667) 239-9220

    56 Total Sales

    1 in Myersville

    $485,000 Price

    Sharon Cremen
     Section Image
  • Heather Nahr Real Estate Agent - RE/MAX Plus

    Heather Nahr

    RE/MAX Plus

    (240) 690-5564

    57 Total Sales

    1 in Myersville

    $550,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

    2 in Myersville

    $415K - $650K Price Range

    Elizabeth MacLaren
     Section Image
  • Brian Mokricky Real Estate Agent - Keller Williams Realty Centre

    Brian Mokricky

    Keller Williams Realty Centre

    (304) 244-3556

    90 Total Sales

    1 in Myersville

    $462,000 Price

    Brian Mokricky
     Section Image
  • Chris Dickerson Real Estate Agent - The Glocker Group Realty Results

    Chris Dickerson

    The Glocker Group Realty Results

    (814) 747-6437

    253 Total Sales

    1 in Myersville

    $364,900 Price

    Chris Dickerson
     Section Image
  • Lynn Holland Real Estate Agent - RE/MAX Realty Centre, Inc.

    Lynn Holland

    RE/MAX Realty Centre, Inc.

    (240) 541-5149

    98 Total Sales

    1 in Myersville

    $556,080 Price

    Lynn Holland
     Section Image
See All Agents

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
08/09/2023 08/09/23 Sold $449,425 0.0% $192 / Sq Ft
03/09/2023 03/09/23 Pending -- -- --
03/08/2023 03/08/23 For Sale $449,425 -- $192 / 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 $88 $447,000
2025 $6,979 $425,500 $80,000 $345,500
2024 $6,979 $375,967 $0 $0
2023 $1,438 $80,000 $80,000 $0
Source: Public Records

Agents Affiliated with this Home

  • Tineshia Johnson Real Estate Agent - NVR, INC.

    Seller's Agent in 2023

    Tineshia Johnson

    NVR, INC.

    (240) 305-1275

    3,713 Total Sales

    Tineshia Johnson
    Section Image
  • Eartha Degannes Real Estate Agent - EXP Realty, LLC

    Buyer's Agent in 2023

    Eartha Degannes

    EXP Realty, LLC

    (240) 818-4887

    5 Total Sales

    Eartha Degannes
    Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2032094

Bright MLS

APN: 02-604993

Maryland Frederick County Frederick 21702

254 Stallion St, 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.