Skip main navigation
Sold for $582,000
  • $582,000

    623 Bushytail Dr, Frederick, MD 21703

    5beds
    3,406sqft
    Single Family Residence
    Built in 2005
    8,008 Square Feet Lot
    $618,500 Zestimate®
    $171/sqft
    $3,400 Estimated rent

    Home value

    $618,500

    $588,000 - $649,000

    $3,400/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,400/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,400/mo

    Rent Zestimate®

    Refinance and save

    $3,725/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

    $3,725/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

    Gas fireplaceCenter islandDining roomHardwoods floorsFenced backyardBilliard tableLarge walk-in closet
    This sunny and spacious stone front traditional colonial home in Frederick convenient location, minutes to commuter routes I-270, I-70, route 15. It's in close proximity to shops and restaurants. 5 Bedroom, 3.5 bathroom Home has approximately 3,406 SQFT on 3-finished levels (Total SQFT: 3684); newer Architectural Asphalt Shingle Roof (2021). The home features include a two story entrance foyer with decorative ceiling light; Hardwoods floors in up level and main level; Crown decorative moldings in large family room, dining room & living room; Family room large windows, recessed lighting, ceiling fan, gas fireplace with marble base and glass screen. Bright and spacious kitchen includes stainless steel double sinks and cabinet storage space; recessed lighting; center island; breakfast area and upgraded marble countertops. The huge Main Bedroom has vaulted ceilings with decorative chandelier light; a large walk-in closet with window and two ceiling lights; and an attached Bath with a soaking tub, shower, double sink vanity and a toilet area. Upstairs additional three bedrooms all with build-in ceiling lights and Hardwoods floors. Full finished basement have a bedroom with ceiling light, laminates floor and a full bathroom ; sliding glass door with windows bring full daylight and walkout into the fenced backyard; spacious recreation room with recessed lighting, a largely wall mirror, also bookshelf, billiard table, balls and sticks all are included. Attached two car garage doors have the two lack keys, two wall build-in garage door openers and two garage door remotes.

    Zillow last checked:

    Listing updated:

    Listed by:

    Jian Bai 240-529-4679,

    UnionPlus Realty, Inc.

    Bought with:

    CHRISTIAN BRIANDT, 628468

    Real Estate Professionals, Inc.

    Source: Bright MLS,MLS#: MDFR2036290MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    • Main level bathrooms: 1
    Rooms
    • Room types: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 5, Kitchen, Family Room, Basement, Foyer, Bedroom 1, Laundry, Recreation Room, Storage Room, Utility Room, Bathroom 1, Full Bath, Half Bath
    Primary bedroom
    • Features: Cathedral/Vaulted Ceiling, Attached Bathroom, Flooring - HardWood, Flooring - Vinyl, Walk-In Closet(s), Bathroom - Tub Shower, Countertop(s) - Ceramic, Soaking Tub, Double Sink
    • Level: Upper
    Bedroom 1
    • Features: Flooring - HardWood
    • Level: Upper
    Bedroom 2
    • Features: Flooring - HardWood
    • Level: Upper
    Bedroom 3
    • Features: Flooring - HardWood
    • Level: Upper
    Bedroom 5
    • Features: Flooring - Laminated
    • Level: Lower
    Bathroom 1
    • Level: Upper
    Basement
    • Features: Basement - Finished, Flooring - Laminated, Flooring - Concrete
    • Level: Lower
    Dining room
    • Features: Crown Molding, Flooring - HardWood
    • Level: Main
    Family room
    • Features: Flooring - HardWood, Crown Molding, Ceiling Fan(s), Fireplace - Gas, Fireplace - Other
    • Level: Main
    Foyer
    • Features: Flooring - HardWood, Cathedral/Vaulted Ceiling
    • Level: Main
    Other
    • Features: Flooring - Tile/Brick, Bathroom - Tub Shower
    • Level: Lower
    Other
    • Features: Countertop(s) - Ceramic, Flooring - Vinyl, Bathroom - Tub Shower
    • Level: Upper
    Half bath
    • Level: Main
    Kitchen
    • Features: Flooring - Laminated, Double Sink, Dining Area, Granite Counters, Flooring - Renewable, Kitchen Island, Kitchen - Electric Cooking, Eat-in Kitchen
    • Level: Main
    Laundry
    • Level: Upper
    Living room
    • Features: Flooring - HardWood, Crown Molding
    • Level: Main
    Recreation room
    • Features: Flooring - Laminated, Basement - Finished
    • Level: Lower
    Storage room
    • Features: Flooring - Concrete
    • Level: Lower
    Utility room
    • Features: Flooring - Concrete
    • Level: Lower
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Central Air, Ceiling Fan(s), Electric
    Appliances
    • Included: Microwave, Dishwasher, Disposal, Dryer, Exhaust Fan, Oven/Range - Electric, Washer, Refrigerator, Gas Water Heater
    • Laundry: Upper Level, Common Area, Laundry Room
    Features
    • Crown Molding, Dining Area, Open Floorplan, Eat-in Kitchen, Kitchen Island, Walk-In Closet(s), Formal/Separate Dining Room, Recessed Lighting, Upgraded Countertops, Ceiling Fan(s), Other, 2 Story Ceilings, 9'+ Ceilings, Cathedral Ceiling(s), Dry Wall, Vaulted Ceiling(s)
    • Flooring: Hardwood, Laminate, Vinyl, Ceramic Tile, Wood
    • Doors: Six Panel
    • Windows: Double Pane Windows
    • Basement: Full,Finished,Interior Entry,Exterior Entry,Rear Entrance,Walk-Out Access,Windows
    • Number of fireplaces: 1
    • Fireplace features: Screen, Gas/Propane, Marble
    Interior area
    • Total structure area: 3,684
    • Total interior livable area: 3,406 sqft
    • Finished area above ground: 2,556
    • Finished area below ground: 850

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage Faces Front, Garage Door Opener, Inside Entrance, Concrete, Off Site, Attached, Driveway, Off Street
    • Attached garage spaces: 2
    • Has uncovered spaces: Yes
    Accessibility
    • Accessibility features: None
    Features
    • Levels: Three
    • Stories: 3
    • Exterior features: Lighting, Sidewalks, Street Lights
    • Pool features: None
    • Fencing: Full,Panel,Back Yard,Wood
    Lot
    • Size: 8,008 Square Feet
    Details
    • Additional structures: Above Grade, Below Grade
    • Parcel number: 1102255200
    • Zoning: R
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial,Traditional
    • Property subtype: Single Family Residence
    Materials
    • Frame, Concrete, Copper Plumbing, Stone, Vinyl Siding, Asphalt
    • Foundation: Concrete Perimeter
    • Roof: Asphalt,Architectural Shingle,Shingle
    Condition
    • Very Good
    • New construction: No
    • Year built: 2005

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable, Fixed Wireless

    Community & HOA

    Community
    • Subdivision: Emerald Farm
    HOA
    • Has HOA: Yes
    • HOA fee: $125 semi-annually
    • HOA name: EMERALD FARM HOMEOWNERS ASSOC
    Location
    • Region: Frederick
    • Municipality: Frederick City

    Financial & listing details

    • Price per square foot: $171/sqft
    • Tax assessed value: $421,500
    • Annual tax amount: $6,722
    • Date on market: 7/9/2023
    • Listing agreement: Exclusive Right To Sell
    • Ownership: Fee Simple

    Price history

    DateEventPrice
    8/29/2023Sold$582,000-8.9%$171/sqft
    Source: Bright MLS #MDFR2036290 Report a problem
    8/5/2023Pending sale$639,000$188/sqft
    Source: Bright MLS #MDFR2036290 Report a problem
    7/10/2023Listed for sale$639,000+42%$188/sqft
    Source: Bright MLS #MDFR2036290 Report a problem
    9/24/2018Listing removed$449,900$132/sqft
    Source: UnionPlus Realty, Inc. #1000467380 Report a problem
    5/1/2018Listed for sale$449,900+0.2%$132/sqft
    Source: Unionplus Realty, Inc. #1000467380 Report a problem
    8/5/2017Listing removed$449,000$132/sqft
    Source: UnionPlus Realty, Inc. #FR9942286 Report a problem
    7/27/2017Price change$449,000-2.2%$132/sqft
    Source: UnionPlus Realty, Inc. #FR9942286 Report a problem
    5/10/2017Listed for sale$459,000+8.5%$135/sqft
    Source: UnionPlus Realty, Inc. #FR9942286 Report a problem
    7/14/2005Sold$422,950$124/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$9,469 -95.2%$513,900 +9.9%
    2024$196,434 +2492.4%$467,700 +11%
    2023$7,577 +12.7%$421,500 +12.3%
    2022$6,722 +2.2%$375,300 +2.3%
    2021$6,577 +2.8%$366,800
    2020$6,398 +2.5%--
    2019$6,243 +3.7%$349,800 +3.7%
    2018$6,019 +46.8%$337,433 -3.5%
    2017$4,100 -18.5%$349,800 +11.9%
    2016$5,032 $312,700 +4.4%
    2015$5,032 $299,567 +4.6%
    2014$5,032 $286,433 +4.8%
    2013-- $273,300
    2012-- $273,300
    2011-- $273,300 -38.4%
    2010-- $443,400 +7.2%
    2009-- $413,630 +4.7%
    2008-- $395,156 +11.6%
    2007-- $354,090 +11.8%
    2006-- $316,710 +13.4%
    2005-- $279,330
    Find assessor info on the county website

    Neighborhood: 21703

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Frederick County Public Schools

    Source: Bright 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
    $618,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
    $618,500