Features & Amenities

Interior

  • Other Interior Features

    Elevator

  • Total Bedrooms

    2

  • Bathrooms

    2

  • 1/2 Bathrooms

    1

  • Above Grade Finished Area

    2327.0

  • Basement YN

    NO

  • Cooling YN

    YES

  • Cooling

    Central Air, Zoned

  • Heating YN

    YES

  • Heating

    Electric, Forced Air, Zoned

  • Main Level Bedrooms

    2

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Brick

  • Parking

    Oversized, Garage Door Opener, Attached

  • Pool

    No

  • Waterfront YN

    NO

Area & Lot

  • Property Type

    Residential

  • Property Sub Type

    Condominium

  • Architectural Style

    Contemporary

Price

  • Sales Price

    $1,098,837.1399999999

  • Tax Amount

    $16,359.07

  • Sq. Footage

    2, 327

  • Price/SqFt

    $472

HOA

  • Association

    Yes

  • Association Fee 2

    $2,616.68

  • Association Fee 2 Frequency

    Semi-Annually

  • Association Fee Includes

    N/A

School District

  • Elementary School

    SPRING RIDGE

  • Middle School

    GOV. THOMAS JOHNSON

  • High School

    GOV. THOMAS JOHNSON

Property Features

  • Senior Community YN

    NO

  • Sewer

    Public Sewer

  • Water Source

    Public

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

FREDERICK

Elementary School

SPRING RIDGE

Middle School

GOV. THOMAS JOHNSON

High School

GOV. THOMAS JOHNSON

Listing Courtesy of NON MEMBER , Non Subscribing Office

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Albert Ranney

AGENT

Albert Ranney

Call Albert today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
Luxury condominium at Visitation Frederick in the heart of Frederick's downtown, historic district. Secure building with elevator. Unit includes private, covered balcony on east side and expansive balcony on south side. Extended 2-car garage with EV charger and garage door opener. Condo fee includes water/sewer. Please note this is completed new construction. 2024 tax amount is an estimated tax calculation based on SDAT assessed value. SDAT district 02, account number 606353 This property is located within the historic district overlay and requires HPC approval for exterior modifications. $5000 capital contribution fee and $750 annual deferred water/sewer assessment for 33 years.

210 SECOND STREET E 402

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

Kellerton is a luxurious, equestrian-inspired community, nested near towns like Whittier, Cannon Bluff, and Clover Hill, and has tree-lined streets and a variety of home styles. Residents of Kellerton can enjoy the community’s many amenities including tot lots for the kids to play on, several athletic fields, walking trails, a dog park, and a beautiful award-winning clubhouse with an Olympic-sized pool! Residents get to enjoy all of this and more just by stepping out their front door. Kellerton offers a variety of customizable floorplans, each with over 10,000 structural and decorative customizations. Looking for more customization? Additional changes are available through our Design Time option. Your Designer will be with you every step of the way to help bring your vision to life. Our quality homes are backed with an industry-leading 20-year warranty structural warranty. Learn more about how Keystone Custom Homes are 80% more efficient than used homes and 50% more efficient than other new homes.

The Nottingham features a 2-story Family Room open to the eat-in Kitchen with walk-in pantry and Breakfast Area. The spacious Owner’s Suite is located on the first floor, with 2 walk-in closets and full Bathroom. A Study, formal Dining Room, Powder Room, Laundry Room, and 2-car garage complete the first level. The hallway upstairs overlooks the Family Room below. An optional Bonus Room is located over the Owner’s Suite. 3 additional Bedrooms with walk-in closets and a full Bath are on the second floor. The Nottingham can be customized to include up to 6 Bedrooms and 4.5 Bathrooms.
#MDFR2059110

FREDERICK

2600 KELLERTON AVENUE NOTTINGHAM

4 Beds

2 Baths

3,600 Sq.Ft.

$897,946

MLS#: MDFR2059110

Kellerton is a luxurious, equestrian-inspired community, nested near towns like Whittier, Cannon Bluff, and Clover Hill, and has tree-lined streets and a variety of home styles. Residents of Kellerton can enjoy the community’s many amenities including tot lots for the kids to play on, several athletic fields, walking trails, a dog park, and a beautiful award-winning clubhouse with an Olympic-sized pool! Residents get to enjoy all of this and more just by stepping out their front door. Kellerton offers a variety of customizable floorplans, each with over 10,000 structural and decorative customizations. Looking for more customization? Additional changes are available through our Design Time option. Your Designer will be with you every step of the way to help bring your vision to life. Our quality homes are backed with an industry-leading 20-year warranty structural warranty. Learn more about how Keystone Custom Homes are 80% more efficient than used homes and 50% more efficient than other new homes.

The Devonshire is a 4+ bed, 2.5+ bath home featuring an open floorplan, 2 staircases, and many unique customization options. Inside the Foyer, there is a Living Room to one side and Dining Room to the other. In the main living area, the 2-story Family Room opens to the Kitchen with a large eat-in island. The Kitchen also has a walk-in pantry and hall leading to the Study. Private Study near back stairs can be used as an optional 5th bedroom. Upstairs, the spacious Owner's Suite has 2 walk-in closets and a private full bath. Bedrooms 2, 3, & 4 share a hallway bath. The Laundry Room is conveniently located on the same floor as all bedrooms. Oversized 2-car garage included. The Devonshire can be customized to include up to 7 Bedrooms and 8.5 Bathrooms.
#MDFR2059112

FREDERICK

2600 KELLERTON AVENUE DEVONSHIRE

4 Beds

2 Baths

4,016 Sq.Ft.

$920,531

MLS#: MDFR2059112

Beautiful building with lots of flexibility and an 8 car parking lot in the rear.  This historic building has been updated with separate electrical services for the current apartments.   Could be converted back to single family house or developed as both.  Each apartment has its own HVAC unit, washer/dryer and lots of natural light.   From the five separate water heaters to the modern storm windows the Owners updated many aspects of this centrally located apartment building just off of North Market Street in Frederick,  Maryland.  Two apartments have outside spaces and two apartments have basement storage.  What Tenant does not like a parking space in the rear of their building?  or could this be your home with income potential?

The building is presently fully leased.  Call for a showing today.  At least 30 hours’ advance notice required to set up a showing.   Showings are held Monday through Friday 10 am to 4 pm out of respect for the Tenants.  Listing agent accompanies all showings.
#MDFR2080560

FREDERICK

33 E 3RD STREET

6 Beds

5 Baths

3,924 Sq.Ft.

$1,175,000

MLS#: MDFR2080560

Build Your Dream Home in Scenic Glisan Farms – 7192 Rosalees Way, Frederick, MD 21701 Nestled in the rolling hills of the picturesque Linganore wine region, this stunning cleared lot offers the perfect blend of rural charm and modern convenience. Located just off Old Annapolis Road and minutes from vibrant downtown Frederick, this homesite offers easy access to commuter routes including I-270, while still providing the serenity of country living. Offered by Maryland Heritage Custom Builders, Inc. in partnership with Glisan Farms, Inc., this property is part of a boutique community featuring expansive views, open green space, and thoughtfully placed homes. Property Highlights: Approved for a 4-Bedroom Home; Perc-approved at-grade mound septic system (gravel-based for reduced cost); 600-foot deep private well producing 1.5 GPM; Electric service nearby, with transformer adjacent to the lot; Gently sloping lot, ideal for a walkout basement; Front of house must face shared driveway for uniform aesthetics; Shared driveway maintenance agreement with two neighboring properties; Asphalt apron already in place at the entrance from Old Annapolis Rd; final driveway paving to be completed after the third home is built; No cable access; Starlink internet has worked successfully for neighboring homes; Previously part of a working farm, this lot retains its pastoral charm while offering the infrastructure needed to build a beautiful custom home. Whether you're seeking tranquility, views, or proximity to the region’s best amenities and wineries, 7192 Rosalees Way delivers. Plans are provided with a build to suit with some options.
#MDFR2073036

FREDERICK

7192 ROSALEES WAY

3 Beds

3 Baths

2,455 Sq.Ft.

$986,000

MLS#: MDFR2073036

Elegant Brick Front Colonial style home located in the highly desired “Villages of Urbana” community. This gem offers approx. 5000 sq ft of finished living space lovingly maintained by the original owners. The professional landscaped lot is just under a quarter acre offering private rear yard that backs to tree line and gorgeous paver patio. Main level offers Two Story Foyer, Formal Living Room,  Formal Dining Room,  Den/Office,  Spacious Two Story Family Room off kitchen with gas fireplace,  Powder Room, Laundry Room. And Kitchen  that includes  quartz countertops, stainless appliances w/double wall oven,  kitchen island,  morning room w/ eat-in area and so much more.  Upper level boasts master suite w/remodeled master bath, walk-in closets and tray ceilings plus 3 additional very spacious bedrooms and full hall bath. Lower level is fully finished except for two nice storage areas. It also includes full bath, new slider door to lovely patio walk out level. All the big ticket items that you don’t always notice have been addressed for you, included but not limited to, roof replaced, all new Pella Windows, new patio door, new stainless appliances, updated master bathroom, newer washer and dryer, newer HVAC,  garage doors replaced, new garage door openers and so much more. Complete list available with detailed costs if desired. Solar panels are paid in full and greatly assist in electrical costs.  Residents of this community enjoy access to many amenities, including tennis, basketball and pickleball courts, fitness center, walking trails, elegant clubhouses, and two swimming pool complexes with water slides and a lazy river. Nearby attractions include the YMCA, Blue Ribbon public schools, Urbana District Park, Library, Several shops, restaurants and grocery stores. Easy access to Rt 270, Rt 355 and Rt 80 for commuters.
#MDFR2079644

FREDERICK

9102 TRAVENER CIRCLE

4 Beds

3 Baths

4,966 Sq.Ft.

$899,900

MLS#: MDFR2079644

Circa 1880, this downtown Frederick home carries the kind of character you simply can’t recreate. Set right on Church Street—one of the most recognizable and loved streets in the city—this six-bedroom property blends historic detail with the right modern updates in a way that actually feels natural, not forced. Inside, the home immediately shows off what makes these properties so special. Original solid hardwood floors run throughout, paired with exposed brick and timber that have been preserved rather than covered up. There’s a sense of depth and texture here that newer homes just don’t have. Every room feels intentional, with just the right balance of old and new. The kitchen has been completely redone with a clean, high-end finish, designed for someone who enjoys cooking and entertaining. It opens comfortably into the main living areas, making the flow of the home feel easy and connected without losing the defined spaces that give older homes their charm. With six true bedrooms, there’s a lot of flexibility here—whether you need space for guests, offices, or just room to spread out. Each level has its own full bathroom, which makes day-to-day living simple and practical, especially for a home of this size. Out back, the courtyard feels like a true extension of the home. Surrounded by exposed brick walls, the space is both private and full of character, with thoughtful landscaping that brings it to life throughout the year. In the spring and summer, it naturally fills in with color and greenery, creating a setting that feels tucked away and quiet despite being right in the middle of downtown. Whether you’re hosting friends or just stepping outside for a few minutes, it’s a space that is timeless in its beauty. One of the standout features is the outdoor space above ground level. The primary bedroom includes its own private balcony, while the third-floor balcony offers a view that’s hard to come by—looking out over the steeples of downtown Frederick. It’s a subtle reminder of exactly where you are, and why people love being here. All of this sits just steps from everything downtown Frederick has to offer—restaurants, shops, coffee, and the overall energy that makes this area so desirable. Homes like this don’t come around often, especially ones that have been updated in a way that still respects what they are. This is one you feel the moment you walk in. OPEN SATURDAY APRIL 18TH 11 - 1 P.M. - STOP BY AND TOUR THIS AMAZING HOME!
#MDFR2076878

FREDERICK

200 E CHURCH STREET

6 Beds

3 Baths

3,308 Sq.Ft.

$1,099,999

MLS#: MDFR2076878

HURRY to SAT APRIL 11th OPEN HOUSE from 12:00-2:00PM. This WORMALD  INVENTORY HOME has so many quality features and a new price for the Open HOUSE at 12:00 TODAY. Homesite 99.  This 5,423. Square Foot COMPLETED Modern Farmhouse home is ready for Move-in.  Enjoy a Sunroom with Floor-to-Ceiling Solarium Windows,  High Design Glass walls and Glass Barn Doors.  The Chapman offers 5 very spacious bedrooms (4 on the Upper Floor and one BR on the lower-level),  4.5 baths (3 on the Upper Floor and one on Lower level) home w/ 2-Car Garage. The Primary Bedroom is light-filled and features 2 Large Closets and Upgrade Carpet.  The 4 secondary Bedrooms are oversized to accommodate King-sized beds and offer large closets with access to a bathroom.  No one has to go into the hall to access a bathroom. The open loft space allows for gatherings on the bedroom level.  There is ample space for entertaining throughout the home including the 1100 Square Ft Recreation room and unique Retreat Room with “Hidden Door” to surprise your friends. This home includes High-End Features like Built-In Central Vacuum System throughout the house and High End Kitchen selections (MARBLE BACKSPLASH, High-Level QUARTZ KITCHEN Countertop and GLASS CABINETS.  You’ll find premium finishes throughout including an private Studio (Home Office) with 8’ GLASS FRENCH DOORS, GLASS BARN DOORS around the spacious KEEPING ROOM (Used as Sunroom)  with Solarium Windows, and Cozy Gas Fireplace in the Great Room. The Kitchen features upgrade Cabinets and 10 ft Island, Bosch Dishwasher, and high-design Marble Backsplash.  You’ll find Stylish Quartz Countertops in the Kitchen, Owners Suite, and all Secondary Baths. The Owners Bath is luxurious with a Soak Tub, Rain Shower Head, Sport Shower and Heavy Glass Shower Door. LVP flooring is included on the main floor and upper hallway and loft. Close to historic downtown Frederick but NO CITY TAXES.  Call for a personal tour between 11:00 to 4:30PM to see this beautiful NEW home. SOME Photographs shown are of Wormald Homes Chapman Model, not the Subject Property.  New Home Sales Office across the Street - 8744 Rosehaven Lane.
#MDFR2065360

FREDERICK

8785 HELLEBER SPRING CIRCLE

5 Beds

4 Baths

5,423 Sq.Ft.

$999,900

MLS#: MDFR2065360

HUGE PRICE DROP. Your dream home awaits!!! Exceptional Main-Level Living in a Newly Built Custom Luxury Home – Kellerton Community
Experience the perfect blend of sophistication, comfort, and convenience in this one-of-a-kind, just-built custom residence—offered directly by the owner, bypassing the wait and complexities of new construction. Every detail has been thoughtfully curated with high-end finishes to create a home that is as functional as it is beautiful.

The inviting foyer opens to a private study on one side and an elegant formal dining room on the other. Beyond, discover a chef’s dream kitchen featuring professional-grade stainless steel appliances, an oversized island with a five-burner gas cooktop and a mosaic backsplash. 
 The fully finished walk-in pantry compliments this spacious with custom cabinetry, a coffee bar, and a prep sink. The adjoining breakfast nook, surrounded by abundant natural light from upgraded windows, flows seamlessly into the dramatic two-story living room, where soaring cathedral ceilings, expansive windows, and a striking double-sided fireplace create an airy yet warm ambiance.

The primary suite, ideally located on the main level, offers two generous walk-in closets and a spa-inspired bath. Upstairs, three spacious bedrooms—each with its own walk-in closet—share a well-appointed bath with a dual vanity.

The lower level provides a partially finished space with an egress window, ideal for a future fifth bedroom, along with a full bath rough-in, offering endless possibilities for expansion.

This rare opportunity to own a brand-new, move-in-ready luxury home in Kellerton is not to be missed. Schedule your private showing and experience the craftsmanship and lifestyle this property delivers.
*Sellers offering a credit to buyer to build another full bathroom on top or basement level. Ask agent for details.•*
#MDFR2076156

FREDERICK

1823 COLT LANE

5 Beds

2 Baths

4,400 Sq.Ft.

$929,900

MLS#: MDFR2076156

New on site 4 days ago
OFFER DEADLINE HAS BEEN SET FOR TUESDAY APRIL 28TH AT NOON. Welcome to this meticulously maintained home in the highly sought-after Urbana Highlands, proudly offered by its original owners. A true reflection of pride of ownership, this residence combines thoughtful updates with a timeless, functional layout.

Step inside to a welcoming foyer, where a private den or home office sits to the left, ideal for today’s flexible lifestyle. To the right, a formal living room seamlessly connects to the dining room, creating an inviting space for entertaining. Enter the kitchen, the heart of the home, which unfolds with a beautifully renovated kitchen featuring crisp white cabinetry, quartz countertops, and a stylish tile backsplash. A bright morning room just beyond offers the perfect space for casual dining and everyday living.

The adjacent family room is both warm and inviting, highlighted by a double-sided gas fireplace that connects effortlessly to the kitchen, enhancing both ambiance and flow.

Outdoor living is equally impressive, with doors from the morning room leading to a stunning brick paver patio with a pergola, all set within a beautifully landscaped yard complete with uplighting, creating a serene setting both day and night.

Additional main-level features include a convenient powder room and a mudroom area near the entry from the garage. Hardwood flooring extends throughout both the main and upper levels, adding to the home’s cohesive and refined feel. Natural light fills the home, enhanced by an abundance of windows and elegant plantation shutters throughout. 

Upstairs, you’ll find three spacious secondary bedrooms, all featuring hardwood flooring and generous closet space. Two of the bedrooms share a recently renovated bathroom, and the third has an en suite bathroom, also recently renovated.  This layout offers both comfort and privacy for family or guests.

The primary suite is a true retreat, highlighted by a double-door entry and vaulted ceilings that create an open, airy feel. A spacious closet and a thoughtfully designed wet bar area, perfect for morning coffee or unwinding at the end of the day, add to the suite’s appeal. The recently renovated en-suite bath offers a spa-like experience, complete with a beautiful soaking tub, refined finishes, and a calming atmosphere.

The fully finished lower level expands the home’s living space and is ideal for both everyday enjoyment and entertaining. It features a large recreation area with a bar area, a sitting area with a centerpiece gas fireplace, and a fourth full bath, making it perfectly suited for movie nights or hosting guests. Ample storage and a convenient walk-up exit to the backyard add both functionality and flexibility.

Notable updates include new windows in 2018, new HVAC units in 2019, a new roof, and wide gutters in 2021.  

Ideally situated in the sought-after Urbana Highlands, this home offers access to a community pool, tennis, and basketball courts. Everyday conveniences, including shopping, dining, and top-rated schools, are all just moments away, along with beautifully maintained parks, green spaces, and the YMCA of South Frederick County.  Blending thoughtful updates, timeless design, and a premier location, this is a truly special offering in one of Urbana’s most desirable neighborhoods.
#MDFR2077186

FREDERICK

3905 ABERDEEN WAY

4 Beds

4 Baths

4,238 Sq.Ft.

$935,000

MLS#: MDFR2077186

New on site 4 days ago
Set on over three private acres and thoughtfully custom-built, this exceptional ranch-style home represents one of the most desirable settings you’ll find in Frederick County. Combining refined design, quality craftsmanship, and true one-level living, the property offers a rare balance of privacy, comfort, and natural beauty. Energy-efficient features, including geothermal systems, further enhance the home’s forward-thinking design.

Inside, the main level is finished with hardwood flooring throughout and designed to accommodate both everyday living and effortless entertaining. The open-concept kitchen is a standout, featuring premium appliances such as a wall oven, six-burner cooktop, abundant cabinetry, and a generous center island. It flows naturally into a casual dining space, which opens to a stunning screened porch, perfect for enjoying the outdoors in comfort.

The adjacent family room features a gas fireplace as its focal point and extends out to a flagstone deck that overlooks the beautifully landscaped grounds, creating a seamless connection between indoor and outdoor living.

The primary suite is privately situated in its own wing of the home and showcases expansive windows on two sides, framing some of the best views on the property. The spa-inspired en-suite bath includes a large walk-in shower, dual vanity, and elegant tile work, along with a dedicated dressing area and custom closet systems.

On the opposite wing, you’ll find two additional bedrooms and a beautifully appointed hall bath with upscale finishes. Additional main-level spaces include a formal dining room overlooking the front yard, a comfortable sitting room ideal for reading or relaxing, as well as a laundry room, mudroom, and powder room.

The lower level spans the full footprint of the home and offers exceptional flexibility, with potential for expanded living space, recreation areas, additional bathroom, or additional bedrooms. With a six-bedroom perc in place, egress windows, rough-in plumbing, and walk-out access to the side yard, the layout is already well-suited for future finishing. High ceilings add to the sense of openness and possibility.

The home includes an oversized garage with epoxy-coated floors, which is a sought after ammenity.  low maintenance and a vast space for storage, hobbies, and utility! 

Carefully maintained and beautifully executed, this home reflects true pride of ownership throughout. With its thoughtful layout, quality finishes, and effortless livability, it offers a rare opportunity to own a property that feels both refined and comfortable. Recent updates include professionally designed landscaping enhanced by a comprehensive outdoor lighting package, creating a beautifully illuminated setting after sunset.  Custom-style black aluminum fence surrounds the rear yard, offering a classic architectural detail that blends seamlessly with the outdoor setting. A freshly painted interior paired with custom-designed molding details throughout creates a polished and cohesive aesthetic.  Ideally located just minutes from downtown Frederick while still enjoying the benefit of no city taxes, this is a special offering in an exceptional setting. A home like this doesn’t come along often!
#MDFR2080744

FREDERICK

8103 MOJAVE COURT

3 Beds

2 Baths

3,019 Sq.Ft.

$1,195,000

MLS#: MDFR2080744

 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.