Skip main navigation
Off market
    • $702,500

    3247 Stone Barn Dr, Frederick, MD 21704

    4beds
    4baths
    2,726sqft
    Townhouse
    Built in 2017
    2,178 Square Feet Lot
    $702,500 Zestimate®
    $258/sqft
    $3,464 Estimated rent

    Home value

    $702,500

    $667,000 - $738,000

    $3,464/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,464/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,464/mo

    Rent Zestimate®

    Refinance and save

    $4,381/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,381/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    This FULLY-FURNISHED Landon II model home has every upgrade imaginable. Dan Ryan Builders just moved out so this is your chance to rent this 4-level home available for a short-term or long-term lease (short-term has higher rent). Gourmet kitchen, luxury master bath, roof top deck with wet bar, wood floors everywhere except the bedrooms. This home has it all. Look at the pictures to see all the upgrades! Current owners are Maryland licensed real estate agents.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    Heating
    • Forced air
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Refrigerator, Washer
    • Laundry: In Unit
    Features
    • Flooring: Hardwood
    • Basement: Partially finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 2,726 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stone, Vinyl
    Lot
    • Size: 2,178 sqft
    Details
    • Parcel number: 07593552

    Construction

    Type & style
    • Home type: Townhouse
    Materials
    • Roof: Other
    Condition
    • Year built: 2017

    Community & neighborhood

    Location
    • Region: Frederick

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $115 monthly

    Other

    Other facts
    • Acreage \ 0.05
    • Appliances \ Appliances \ Central Vacuum
    • Appliances \ Appliances \ Cooktop - Down Draft
    • Appliances \ Appliances \ Dishwasher
    • Appliances \ Appliances \ Disposal
    • Appliances \ Appliances \ Dryer - Front Loading
    • Appliances \ Appliances \ ENERGY STAR Clothes Washer
    • Appliances \ Appliances \ ENERGY STAR Dishwasher
    • Appliances \ Appliances \ ENERGY STAR Refrigerator
    • Appliances \ Appliances \ Microwave
    • Appliances \ Appliances \ Oven - Double
    • Appliances \ Appliances \ Washer - Front Loading
    • Appliances \ Appliances \ Washer/Dryer Hookups Only
    • Appliances \ Appliances \ Water Heater
    • Appliances \ Central Vacuum
    • Appliances \ Cooktop - Down Draft
    • Appliances \ Disposal
    • Appliances \ Oven - Double
    • Appliances \ Washer\Dryer Hookups Only
    • Appliances \ Water Heater
    • Basement \ BasementType \ Sump Pump
    • Basement \ HasBasement \ 1
    • Bathrooms \ HalfBaths \ 2
    • CondoFee \ 0
    • CvrdParking1Spaces \ 0
    • CvrdParking2Spaces \ 0
    • Directions \ Rt. 355 to left into development
    • Elementary School: SUGARLOAF
    • Exterior Type: Stone
    • Exterior \ Combination
    • Exterior \ Shake Siding
    • ExteriorFeatures \ Flood Lights
    • ExteriorFeatures \ Sidewalks
    • GarageType \ Garage Door Opener
    • HOAFee \ 125
    • HalfBaths \ 2
    • HasBodyOfWater \ 0
    • HasPool \ 0
    • HasWaterAccess \ 0
    • HasWaterFront \ 0
    • HasWaterView \ 0
    • Heating and Cooling \ Cooling \ Ceiling Fan(s)
    • Heating and Cooling \ Cooling \ Central A/C
    • Heating and Cooling \ Heating \ Forced Air
    • Heating system: Forced Air
    • High School: URBANA
    • InteriorFeatures \ Crown Moldings
    • InteriorFeatures \ Dining Area
    • InteriorFeatures \ Family Room Off Kitchen
    • InteriorFeatures \ Floor Plan - Open
    • InteriorFeatures \ Kitchen - Eat-In
    • InteriorFeatures \ Kitchen - Island
    • InteriorFeatures \ Kitchen - Table Space
    • InteriorFeatures \ Primary Bath(s)
    • InteriorFeatures \ Recessed Lighting
    • InteriorFeatures \ Upgraded Countertops
    • InteriorFeatures \ Wet\Dry Bar
    • InteriorFeatures \ Window Treatments
    • InteriorFeatures \ Wood Floors
    • IsForeClosure \ 0
    • IsNewConstruction \ 1
    • Laundry: In Unit
    • ListingDate \ 2022-06-20T00: 00
    • Location \ Directions \ Rt. 355 to left into development
    • Lot \ Acreage \ 0.05
    • Lot \ LotSquareFootage \ 2025
    • Lot \ TotalSquareFeet \ 2726
    • LotSquareFootage \ 2025
    • MLS Listing ID: MDFR2020170
    • MLS Name: Long & Foster (Long & Foster)
    • Materials \ Roofing \ Shingle
    • Middle School: URBANA
    • NoOfLevels \ 0
    • Other Exterior Features \ Exterior \ Combination
    • Other Exterior Features \ Exterior \ Shake Siding
    • Other Exterior Features \ Exterior \ Stone
    • Other Exterior Features \ Exterior \ Vinyl Siding
    • Other Exterior Features \ ExteriorFeatures \ Flood Lights
    • Other Exterior Features \ ExteriorFeatures \ Sidewalks
    • Other Fees \ HOAFee \ 125
    • Other Interior Features \ Fireplaces \ 1
    • Other Interior Features \ InteriorFeatures \ Crown Moldings
    • Other Interior Features \ InteriorFeatures \ Dining Area
    • Other Interior Features \ InteriorFeatures \ Family Room Off Kitchen
    • Other Interior Features \ InteriorFeatures \ Floor Plan - Open
    • Other Interior Features \ InteriorFeatures \ Kitchen - Eat-In
    • Other Interior Features \ InteriorFeatures \ Kitchen - Island
    • Other Interior Features \ InteriorFeatures \ Kitchen - Table Space
    • Other Interior Features \ InteriorFeatures \ Primary Bath(s)
    • Other Interior Features \ InteriorFeatures \ Recessed Lighting
    • Other Interior Features \ InteriorFeatures \ Upgraded Countertops
    • Other Interior Features \ InteriorFeatures \ Wet/Dry Bar
    • Other Interior Features \ InteriorFeatures \ Window Treatments
    • Other Interior Features \ InteriorFeatures \ Wood Floors
    • Other \ CondoFee \ 0
    • Other \ IsForeClosure \ 0
    • Other \ IsNewConstruction \ 1
    • Other \ ListingDate \ 2022-06-20T00: 00
    • Other \ NoOfLevels \ 0
    • Other \ Ownership \ Other
    • Other \ TotalLeasedUnits \ 0
    • Other \ TotalNoOfUnits \ 0
    • Other \ TotalTaxes \ 0
    • Other \ TotalUnfurnishedUnits \ 0
    • Ownership \ Other
    • Parking \ CvrdParking1Spaces \ 0
    • Parking \ CvrdParking2Spaces \ 0
    • Parking \ GarageType \ Garage Door Opener
    • Parking \ Parking \ Attached Garage
    • School District: FREDERICK COUNTY PUBLIC SCHOOLS
    • Sewer \ Public Sewer
    • Style \ End of Row\Townhouse
    • TotalLeasedUnits \ 0
    • TotalNoOfUnits \ 0
    • TotalSquareFeet \ 2726
    • TotalTaxes \ 0
    • TotalUnfurnishedUnits \ 0
    • Type and Style \ Style \ End of Row/Townhouse
    • Utilities \ Sewer \ Public Sewer
    • View Type \ HasWaterView \ 0
    • Water \ HasBodyOfWater \ 0
    • Water \ HasPool \ 0
    • Water \ HasWaterAccess \ 0
    • Water \ HasWaterFront \ 0
    • Water \ Public
    • Water \ Water \ Public

    Price history

    DateEventPrice
    3/23/2020Listing removed$549,900$202/sqft
    Source: Long & Foster Real Estate, Inc. #MDFR261006 Report a problem
    3/9/2020Listed for sale$549,900+12.2%$202/sqft
    Source: Long & Foster Real Estate, Inc. #MDFR261006 Report a problem
    6/12/2017Sold$490,000$180/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$8,326 +27.9%$570,633 +7.1%
    2024$6,510 +6%$532,700 +1.7%
    2023$6,141 +1.7%$524,000 -1.6%
    2022$6,039 +1.7%$532,700 +5.2%
    2021$5,937 +5%$506,600
    2020$5,655 +5.3%--
    2019$5,372 +5.5%$506,600 +16.6%
    2018$5,090 $434,300
    2017$5,090 $434,300

    Find assessor info on the county website

    Neighborhood: 21704

    Nearby homes

    Skip to the end of the carouselSkip to the beginning of the carousel

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: SUGARLOAF
    • Middle: URBANA
    • High: URBANA HIGH
    • District: FREDERICK COUNTY PUBLIC SCHOOLS

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $702,500
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $702,500

    Nearby cities

    Nearby zip codes

    Other Frederick Topics

      Search
      Updates
      Favorites
      Plan
      Inbox