Skip main navigation
For saleErrorPrice cut: $10K (7/17)
$475,000
4beds
1,856sqft

417 Union St, Frederick, MD 21701

4beds
1,856sqft
Townhouse
Built in 2023
1,782 sqft
1 Attached garage space
$256 price/sqft
$121/mo HOA

What's special

Community poolSpacious walk-in closetPrivate deckAbundance of recessed lightingLarge balconyAll stainless steel appliancesDedicated dining area

Option to sell FURNISHED! See this exquisite end-of-row townhouse, newly built in 2023 that offers a perfect blend of modern elegance and cozy comfort. With thoughtfully designed living space, this home is ideal for those seeking a sanctuary that feels both spacious and inviting. The kitchen is a chef's dream, featuring ...

42 days
|
274
|
9
|
Source: Bright MLS,MLS#: MDFR2083966MLS Logo
Travel times

Living Room

Kitchen

Primary Bedroom

Zillow last checked:

Listing updated:

Listed by:

Alexandra Ryan 443-534-6388,

EXP Realty, LLC 8888607369

Source: Bright MLS,MLS#: MDFR2083966MLS Logo

Facts & features

Interior

Bedrooms & bathrooms
  • Bedrooms: 4
  • Bathrooms: 4
  • Full bathrooms: 4
  • Main level bathrooms: 1
  • Main level bedrooms: 1
Basement
  • Area: 0
Heating
  • Central, Electric
Cooling
  • Central Air, Natural Gas
Appliances
  • Included: Microwave, Down Draft, Dishwasher, Disposal, Dryer, Energy Efficient Appliances, ENERGY STAR Qualified Dishwasher, ENERGY STAR Qualified Refrigerator, Ice Maker, Oven, Oven/Range - Gas, Refrigerator, Stainless Steel Appliance(s), Washer, Electric Water Heater
Features
  • Attic, Dining Area, Family Room Off Kitchen, Open Floorplan, Kitchen - Gourmet, Kitchen Island, Primary Bath(s), Recessed Lighting, Walk-In Closet(s), 9'+ Ceilings, Dry Wall
  • Doors: Sliding Glass, Insulated, Six Panel
  • Windows: Double Pane Windows, Energy Efficient
  • Has basement: No
  • Has fireplace: No
Interior area
  • Total structure area: 1,856
  • Total interior livable area: 1,856 sqft
  • Finished area above ground: 1,856
  • Finished area below ground: 0
Video & virtual tour

Property

Parking
  • Total spaces: 1
  • Parking features: Garage Faces Rear, Attached
  • Attached garage spaces: 1
Accessibility
  • Accessibility features: None
Features
  • Levels: Three
  • Stories: 3
  • Patio & porch: Deck
  • Exterior features: Play Area, Sidewalks, Street Lights
  • Pool features: Community
Lot
  • Size: 1,782 Square Feet
Details
  • Additional structures: Above Grade, Below Grade
  • Parcel number: 1102603767
  • Zoning: RESIDENTIAL
  • Special conditions: Standard

Construction

Type & style
  • Home type: Townhouse
  • Architectural style: A-Frame
  • Property subtype: Townhouse
Materials
  • Frame
  • Foundation: Concrete Perimeter
  • Roof: Architectural Shingle
Condition
  • Excellent
  • New construction: No
  • Year built: 2023

Utilities & green energy

  • Sewer: Public Sewer
  • Water: Public

Community & HOA

Community
  • Subdivision: Renn Quarter
HOA
  • Has HOA: Yes
  • HOA fee: $121 monthly
Location
  • Region: Frederick
  • Municipality: Frederick City

Financial & listing details

  • Price per square foot: $256/sqft
  • Tax assessed value: $446,333
  • Annual tax amount: $7,833
  • Date on market: 6/29/2026
  • Listing agreement: Exclusive Right To Sell
  • Listing terms: Cash,Conventional,FHA,VA Loan,Other
  • Ownership: Fee Simple

Price history

DateEventPrice
7/17/2026Price change$475,000-2.1%$256/sqft
Source: Bright MLS #MDFR2083966 Report a problem
6/29/2026Listed for sale$485,000+9%$261/sqft
Source: Bright MLS #MDFR2083966 Report a problem
5/11/2024Listing removed--
Source: Zillow Rentals Report a problem
4/11/2024Price change$4,500+50%$2/sqft
Source: Zillow Rentals Report a problem
2/23/2024Listed for rent$3,000$2/sqft
Source: Zillow Rentals Report a problem
2/3/2024Listing removed--
Source: Zillow Rentals Report a problem
12/29/2023Listed for rent$3,000$2/sqft
Source: Zillow Rentals Report a problem
9/13/2023Listing removed--
Source: Zillow Rentals Report a problem
8/16/2023Price change$3,000-6.3%$2/sqft
Source: Zillow Rentals Report a problem
7/31/2023Listed for rent$3,200$2/sqft
Source: Zillow Rentals Report a problem
6/29/2023Sold$444,990+2.3%$240/sqft
Source: Bright MLS #MDFR2030930 Report a problem
2/21/2023Pending sale$434,990$234/sqft
Source: Bright MLS #MDFR2030930 Report a problem
2/11/2023Price change$434,990-1.1%$234/sqft
Source: DR Horton Report a problem
2/3/2023Listed for sale$439,990$237/sqft
Source: Bright MLS #MDFR2030930 Report a problem

Public tax history

YearProperty taxesTax assessment
2025$7,921 -95.1%$429,100 +11.2%
2024$162,120 +2530%$386,000 +12.6%
2023$6,164 $342,900
2022-- --

Find assessor info on the county website

Monthly payment

Est. payment
$2,905/mo
Principal & interest
$2412
Property taxes
$372
HOA Fees
$121
More affordability toolsChevron Right

Estimated market value

$472,800

$449,000 - $496,000

$2,830/mo

Climate risks

Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.

Neighborhood: 21701

Nearby schools

Spring Ridge Elementary School
Grades PK-52.3 miles
6/10
GreatSchools® Rating
Test Score Rating
7/10
Student Progress Rating
5/10
Gov. Thomas Johnson Middle School
Grades 6-81.4 miles
6/10
GreatSchools® Rating
Test Score Rating
6/10
Student Progress Rating
6/10
Gov. Thomas Johnson High School
Grades 9-121.5 miles
5/10
GreatSchools® Rating
Test Score Rating
3/10
College Readiness Rating
6/10