459 Hanson Street • Frederick, MD 21701

$679,990 • Beds: 5 • Baths: 5 full • Sq. Feet: 3213 • MLS ID: MDFR2073190 • Subdivision: RENN QUARTER • School Dist: FREDERICK COUNTY PUBLIC SCHOOLS
Brand-New 5BR/5BA Home – The Alec Floorplan at Renn Quarter. Just one mile from Downtown Frederick, this stunning new Neo-Traditional home blends modern design with timeless charm. Enjoy an open-concept layout filled with natural light, designer finishes, and a gourmet kitchen featuring quartz countertops, stainless steel appliances, and a spacious island. The primary suite offers a spa-inspired bath with dual vanities, glass shower, and walk-in closet. Each bedroom has its own full bath—ideal for families or guests. The finished basement provides extra space for a gym, office, or media room. Smart home features, premium appliances, and limited-time builder incentives included. just steps from shops, dining, and parks. Schedule your tour today! View this listing at: http://carlislehousehunter.com/mls=MDFR2073190

Property Features

  • Garage: 2
  • Taxes: $0
  • Basement: Yes
  • Roof Type: Architectural Shingle
  • Exterior: Advanced Framing,Blown-In Insulation,Brick,HardiPl
  • Parking Notes: 2 Total Parking Spaces
  • Lot Size: 0.09 Acres
  • Lot Dimensions: 0.09 Acre(S)
  • Heating: Central
  • Fuel Type: Natural Gas
  • Cooling: Central A/C
  • Year Built: 2025
  • Water: Public
  • Sewer: Public Sewer
  • Stories: 3.0
  • HOA Fee: $80.00/Monthly
  • Additional Structures: Above Grade,Below Grade
  • Structure Type: Detached
  • Total Garage/Parking Spaces: 2
  • Pet Restrictions: No Pet Restrictions
  • Appliances: Built-In Microwave,Cooktop - Down Draft,Dishwasher,Disposal,ENERGY STAR Dishwasher,ENERGY STAR Refrigerator,Microwave,Oven - Wall,Range Hood,Refrigerator
  • Rooms: Primary Bedroom,Bedroom 2,Bedroom 3,Bedroom 4,Bedroom 5,Kitchen,Foyer,Great Room,Laundry,Office,Recreation Room,Bathroom 1,Bathroom 2,Bathroom 3,Primary Bathroom,Full Bath
  • Basement: Partially Finished
  • SQFT Total Finished: 3213
  • SQFT Above Finished: 2518
  • SQFT Below Finished: 695
  • Exterior: Exterior Lighting,Street Lights
  • Interior: Carpet,Combination Kitchen/Dining,Floor Plan - Open,Kitchen - Eat-In,Kitchen - Island,Recessed Lighting,Walk-in Closet(s)
  • Flooring: Carpet,Ceramic Tile,Vinyl
  • Windows: Double Pane,Energy Efficient,Low-E,Screens
  • Utilities: Cable TV Available,Natural Gas Available,Phone,Phone Available

School Information

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
Printed March 20, 2026

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 03/20/2026. The listing information on this page last changed on 03/20/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 03/20/2026 12:00:03 AM EST) or Bright MLS (last updated Thu 03/19/2026 11:49:46 PM EST). Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices Homesale Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
Corporate Office - 215 S Centerville Rd. Lancaster, PA 17603
James J Hafer - West Virginia Broker of Record

©2026 BHH Affiliates, LLC. An independently owned and operated franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  


Agent License Information: 
Licensed in Pennsylvania
Linda Gilbert Shover 
801 Belvedere Street, Suite 100, Carlisle, PA 17015
717-245-2100