Refine Search
Sort by
3626 Singleton Ter, Frederick
$517,000
3 Beds ⋅ 3 Baths ⋅ MDFR2084552 MLS
Lovingly maintained and updated 3 level townhome in the sought-after Villages of Urbana, filled with natural light and designed for comfortable, easy living. The spacious open floor plan creates an inviting atmosphere from the moment you enter. The lower level offers convenient access to the one-car garage and features a generous rec room. The main level showcases a bright living and dining area, an lightful kitchen with quartz counter and tile floor. Both the lower and upper levels feature stylish luxury vinyl flooring. Going upstairs, you will enjoy the fabulous brand new master bathroom, 2 additional bedrooms and a full hall bath. Villages of Urbana offers 3 pools, one water park, library, commercial sized gym, indoor sports barn (basketball/volleyball/badminton/pickleball), outdoor tennis courts with pickleball, walking/biking trails, grocery, medical offices and so much more. Newer YMCA nearby provides nice after school programs and a huge aquatic center. Minutes to I-270. Roof is replace in 2025. AC replaced in 2021. Top-rated Urbana Schools are known for their strong academic performance. Roof replaced in 2025.

3626 Singleton Ter, Frederick

104 Mercer Ct Unit 15-6, Frederick
$779,900
2 Beds ⋅ 3 Baths ⋅ MDFR2083460 MLS
PENTHOUSE STEPS FROM BAKER PARK, MINUTES FROM DOWNTOWN FREDERICK MD: 3,050 square feet of one-level living - one of only three residences on the fifth floor of 104 Mercer Court. Cathedral ceilings, a dramatic Palladian window, abundant natural light, panoramic Catoctin Mountain views, and a striking three-sided fireplace. . . . . . . . . DUAL PRIMARY SUITES: Each of the two bedrooms has a walk-in closet, full en suite bath, and private sunroom access. A separate entrance serves the bedroom wing - ideal for guests or multigenerational living. . . . . . . . . TWO SUNROOMS: Both fully enclosed and comfortable year-round, with walls of casement windows and mountain views. Sunroom #1 adds a vaulted ceiling, half-round window, and independent climate control; Sunroom #2 features an exposed brick wall and wet bar. . . . . . . . . LIBRARY / EXECUTIVE OFFICE: Floor-to-ceiling shelving with a rolling ladder (conveys) and French doors from the living room. Additional arched built-ins anchor the dining area. . . . . . . . . KITCHEN: Granite counters, soft-close cabinetry with under-cabinet lighting, wall oven, downdraft cooktop, center island, and pantry. . . . . . . . . SINGLE-LEVEL LIVING: Assigned parking in the secure garage plus ample exterior lot parking, both with step-free elevator access to the unit, which is level throughout. Private caged storage and in-unit laundry. . . . . . . . . RECENTLY UPDATED: Fresh paint, refinished hardwoods, new lighting, and a high-efficiency heat pump (April 2026) with transferable 10-year warranty. . . . . . . . . CONDOMINIUM FEE ($824/MO) COVERS: Water, sewer, master insurance policy (owners typically carry an HO6 of about $70/month), professional management, common area maintenance inside and out, private gym, and secured entry.

104 Mercer Ct Unit 15-6, Frederick

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of . All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

board logo

© 2026 TReND. All Rights Reserved.
The data relating to real estate for sale on this website appears in part through the TReND Internet Data Exchange (IDX) program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which Real Broker NY LLC participates, and is provided by TReND through a licensing agreement. Real estate listings held by brokerage firms other than Real Broker NY LLC are marked with the IDX icon and detailed information about each listing includes the name of the listing broker.
All information provided is deemed reliable but is not guaranteed. Some properties which appear for sale on this website may no longer be available because they are under contract, have sold or are no longer being offered for sale. The information being provided is 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.