Features & Amenities

Interior

  • Total Bedrooms

    2

  • Bathrooms

    2

  • Above Grade Finished Area

    2500.0

  • Basement YN

    NO

  • Cooling YN

    YES

  • Cooling

    Central Air, Zoned, Electric

  • Heating YN

    YES

  • Heating

    Electric, Forced Air, Zoned

  • Main Level Bedrooms

    2

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Brick

  • Parking

    Garage, Inside Entrance

  • Pool

    Yes

  • Pool Features

    None

  • Waterfront YN

    NO

  • View

    City

Area & Lot

  • Property Type

    Residential

  • Property Sub Type

    Condominium

  • Architectural Style

    Contemporary

Price

  • Sales Price

    $1,250,000

  • Tax Amount

    18000.0

  • Sq. Footage

    2, 500

  • Price/SqFt

    $500

HOA

  • Association

    NO

School District

  • Elementary School

    SPRING RIDGE

  • Middle School

    GOV. THOMAS JOHNSON

  • High School

    GOV. THOMAS JOHNSON

Property Features

  • Accessibility Features

    Accessible Elevator Installed

  • Association Amenities

    Elevator(s)

  • Senior Community YN

    NO

  • Sewer

    Public Sewer

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

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 Kimberly Hotaling , RE/MAX Results

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 MarylandSandbox

FOUNDER

MarylandSandbox

Call Maryland 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.
O2J presents Visitation Frederick Condos (contact developer directly for more information or visit builder website) TO BE BUILT.  Located in the heart of Frederick's downtown, historic district. Starting price $1,250,000. Building includes 7 individual units, 2 assigned parking garage spaces per unit. Floor plans include 2 and 3 bedroom units + den with square footage ranging between 2500-3600 sqft. Condo fee includes water/sewer. Condominium fee varies by percentage of ownership calculated based on size of unit. TO BE BUILT - TAXES PROVIDED IN LISTING ARE AN ESTIMATE ONLY.  Tax assessed value for individual units is not currently available. 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. Contact developer for more information on availability and pricing. Photos show a representative sample of finishes included in building 1 and floor plans for building 2.

208 SECOND STREET E

Message successfully sent.

What would you like to know?

Related Properties

Stunning To Be Built Custom Home on over 2 acre homesite with views of Frederick.  Main level boasts 9 to 10 ft. ceilings, upgraded kitchen, bath(s), First Floor Primary Bedroom, and custom windows throughout.  Upper level has 2 large bedrooms and 2 full bathrooms with option for additional bedroom.  There are several options to change to meet your wants/needs.  Lower Level can be finished and has access to outside.   Construction already started so act quick to pick your options.  It is not too late to customize this home.  Located outside city limits but is a short drive to downtown amenities.  Close to I-70, Rt. 340, 15 and 40.  Construction to Permanent Loans available through First Bank and Trust.
#MDFR2052522

FREDERICK

5908 SLEEPY HOLLOW DRIVE

4 Beds

4 Baths

3,680 Sq.Ft.

$1,190,000

MLS#: MDFR2052522

Introducing "The Retreat" to be built by New London Homes.  This stunning farmhouse plan gives you everything you would ever want or need.  Situated on over 7 acres this is the perfect place to call home.  At this price the home includes 3 fully finished levels, a guest suite on the main level, open concept floorplan.  Relax on the screened porch and just take in the beauty around you.  The upper level includes a large primary suite, laundry room, spacious loft and 2 additional bedrooms with their own private full bathrooms.  You will not want to miss your opportunity to own a piece of paradise located close to Middletown & downtown Frederick.
#MDFR2057568

FREDERICK

EDGEMONT ROAD

4 Beds

4 Baths

3,545 Sq.Ft.

$1,235,000

MLS#: MDFR2057568

Welcome to this exquisite residence nestled in the highly desirable Villages of Urbana community. Offering the perfect blend of classic elegance and modern functionality, this 5-bedroom, 5-bathroom home boasts over 5,000 square feet of beautifully finished living space across three levels.

As you step inside, you're greeted by gleaming hardwood floors that flow throughout most of the main level. The formal living and dining rooms exude sophistication, complete with double crown molding and ample space for entertaining. A dedicated main-level office features custom built-in bookshelves, ideal for working from home or a quiet study retreat. Plenty of storage for guests with an ample coat closet.

The heart of the home is the spacious family room, adorned with bright, oversized windows, a floor-to-ceiling stone fireplace, and built in bookshelf  creating a warm and inviting ambiance. The adjacent gourmet kitchen is a chef’s dream, offering a large center island with brand new gas range, double wall ovens, stainless steel appliances, a walk-in pantry, ample cabinet storage and a cozy breakfast nook. A charming butler’s pantry connects the kitchen and dining area, while an additional nook provides the perfect spot for a coffee station or home desk setup. A spacious laundry room is located on the main level for your convenience.

Upstairs, the luxurious primary suite is a true sanctuary featuring a tray ceiling, dual walk-in closets, and a spa-like en-suite bathroom complete with a soaking tub, separate shower, and dual vanities. Four additional generously sized bedrooms complete the upper level, including two convenient Jack-and-Jill bathrooms that provide both privacy and functionality. A generous size linen closet is perfect for all of your storage needs.

The expansive finished lower level is designed for versatility and comfort, offering the perfect space for a home theater, game room, or recreation area. A bonus room and a full bathroom make this level ideal for out-of-town guests or multi-generational living. This home features many storage area, one of the biggest being the basement storage/utility room.

Step outside to your private backyard oasis. A large deck overlooks a peaceful, tree-lined backdrop—perfect for outdoor dining, summer entertaining, or simply relaxing in nature.

ASSUMABLE LOAN MIGHT BE AVAILABLE FOR QUALIFIED BUYERS. Located just minutes from top-rated schools, neighborhood parks, community pools, walking trails, and all the amenities the Villages of Urbana has to offer, this extraordinary home delivers luxury living in one of the area's most coveted neighborhoods. Live your bliss...
#MDFR2064092

FREDERICK

3747 SPICEBUSH DRIVE

5 Beds

4 Baths

6,395 Sq.Ft.

$1,189,000

MLS#: MDFR2064092

OPEN HOUSE, SUNDAY, JULY 27 @ 1-4pm -  *Check out the Video & Floor Plan Walkthrough*  Abundant in history and modern luxury, this beautifully maintained brick Colonial is a rare opportunity in one of Frederick’s most desirable neighborhoods. Perfectly situated with direct park views and just minutes from Baker Park and Culler Lake, you’ll enjoy easy access to tennis and bocce courts, playgrounds, picnic areas, dog park, and a vibrant calendar of community events. Step inside and experience the seamless blend of classic charm and contemporary upgrades—over $150,000 in recent renovations by the current owner ensure this home is truly move-in ready. The main level features hardwood floors, a cozy gas fireplace, a formal dining room, and a stunning eat-in kitchen with soapstone counters, stainless steel appliances, slide-out drawers, and a bonus pantry. The four-season sunroom, with heated slate flooring and four sliding glass doors, brings the outdoors in and offers tranquil views of the lush, landscaped yard and inground pool. Accessibility is unmatched, with two wheelchair-accessible ramps on the side and back entrances.
The home’s flexible layout is ideal for multigenerational living or aging in place, with two primary ensuite bedrooms—one on the main level, fully updated in 2024 with heated floors, a jacuzzi tub, dual sinks, lighted mirrors, plus a new combo washer/dryer for ultimate convenience. Upstairs, the second primary suite features heated marble floors, dual vanities, a walk-in tile shower, two spacious closets, including a cedar closet. 
Two additional bedrooms and a brand-new hall bathroom (2025) with a great shower complete the upper level. The finished lower level offers a brand-new basement (2025) with wall-to-wall carpet, brand new boiler, new water heater, and a second laundry area (washer 2013, dryer 2019). The finished space is all ready for a home office, rec room, and/or craft space. 
Enjoy year-round comfort with separate AC zoning for the main level and upstairs, central heat, and new LED lighting strategically throughout. Outdoor living is a dream: the fenced rear yard features an inground pool maintained by Propools (2025), a hot tub, a pergola, a koi pond, and one of Frederick County’s oldest Lebanon Cedars, complete with a commemorative plaque. The property includes a 2 car detached garage, with an additional private off-street parking for 3 more cars. There is ample space for storage either using the outdoor shed or the clean empty attic. 
This home is more than just a place to live—it’s a lifestyle. Enjoy beautiful views from every window, original stained glass, tasteful landscaping, and the warmth of a close-knit, friendly community. Schley Park, maintained by the city but cared for by neighboring owners, creates a quaint, private atmosphere while keeping you close to dining, shopping, and all that downtown Frederick has to offer. Don’t miss your chance to own this extraordinary property—schedule your private tour today and discover why this is the perfect place to call home. *Check out the Video & Floor Plan Walkthrough*
#MDFR2066836

FREDERICK

305 COLLEGE PLACE

4 Beds

3 Baths

3,419 Sq.Ft.

$1,488,888

MLS#: MDFR2066836

Rarely available in the highly sought after Kellerton Community, this exquisite 6-bedroom, 5.5-bath luxury home, built in 2022, boasts exceptional design and premium upgrades throughout. Featuring a 3-car attached garage, a grand double staircase, and a heated in-ground saltwater pool, this residence offers a resort-style living experience.

Upon entry, you'll be greeted by stunning LVP flooring, soaring cathedral ceilings, a cozy gas fireplace, and an abundance of natural light, creating a warm and inviting atmosphere. Perfect for entertaining, this home is truly a dream. The fully fenced backyard offers serene views of a creek, planted reforestation buffer, and open space against the backdrop of Catoctin Mountain, providing a beautiful oasis and perfect for enjoying outdoor space and scenery. 

The gourmet kitchen is a chef’s dream, with a large farmhouse sink, gleaming quartz countertops, a large center island, double ovens, and cabinetry that extends to the ceiling for ample storage. The kitchen also features a full-sized Frigidaire Electrolux refrigerator and freezer with custom trim, along with a fully vented range hood. A dedicated prep kitchen with a second full sink provides additional space for entertaining, for a coffee bar, has custom wine storage, and extra cabinetry. The walk-in pantry offers even more storage for all your culinary needs. Dual staircases offer convenient access to both the kitchen and main living areas.

The open dining area is perfect for hosting, and a versatile bedroom with a full bathroom on the main level can easily be transformed into an office, playroom, or gym offering endless possibilities. Upstairs, you'll find four generously sized bedrooms, each with spacious closets, including a luxurious primary suite with a spa-like en suite bathroom. The primary bath features a luxurious soaking tub, dual vanities, and an oversized rainfall shower with triple shower heads and wall jets. A convenient laundry room is also located on the bedroom level along with 3 full bathrooms. 

The expansive finished walk-out basement includes an additional bedroom and bathroom, and opens up to the patio and stunning heated in-ground saltwater pool (installed in 2024). The patio also features a custom built in fire pit and the composite deck with vinyl railings is perfect for hosting parties with picturesque views. The lower level also includes an unfinished section, perfect for storing holiday decorations and other items.

Nestled in a picturesque neighborhood, this home offers a wealth of amenities, including a dog park, walking paths, an in ground community pool, clubhouse, fitness center, dog wash station, meeting rooms, basketball courts, and tot lots. It’s just minutes from downtown Frederick, where you can enjoy a variety of restaurants, parks, library, coffee shops, art galleries, and so much more. The Marc train is minutes away and easy access to commuter routes to DC, Baltimore, and Virginia.

This home truly has it all. Schedule your tour today!
#MDFR2060846

FREDERICK

2704 HILLFIELD DRIVE

6 Beds

5 Baths

6,629 Sq.Ft.

$1,350,000

MLS#: MDFR2060846

** OPEN HOUSE: SATURDAY 7/26 & SUNDAY 7/27 FROM 1PM-3PM **
Beautiful Brick-Front Colonial situated in the corner lot with side loaded 2 car garage, in the sought of Villages of Urbana. Former model home boasting over 5800 sf with brand new roof replaced on 5.7.2025, water heater 6 years old, original owners: featuring 5 bedrooms (potentially 8 bedrooms), 4.5 bathrooms. Many upgraded features include dual staircase, 10 feet ceiling, hardwood floors, plantation windows.  Main level includes a gourmet kitchen with granite countertops & designer backsplashes, large center island, stainless steel appliances, and 42 inch cherry cabinets., large study room, formal dining room, Family room has a fireplace that you can see through from the study room, the foyer and hallways are filled with designer tiles while the entire main floor is filled with hardwood floors. Upper level with primary bedroom filled with lots of lights, tray ceiling, double walk-in closets, luxury bath with double vanity, soaking tub and separate shower,  Four additional spacious bedrooms, two full baths and a convenient laundry room.  Lower level is fully finished with a large recreation room, amazed with designer flooring tiles along with a huge entertainment room that will bring the sound of music to the heart of your guests and with a spacious wet bar, all for your entertainment activities.. A full bath specially designed with white tiles, 3 large additional bedrooms can be guest rooms. Popular subdivision with lots of community amenities, close to I270, shopping, restaurants and top school districts.
#MDFR2062940

FREDERICK

3701 SPICEBUSH WAY

5 Beds

4 Baths

5,834 Sq.Ft.

$1,099,000

MLS#: MDFR2062940

NEW PRICE. COME SEE THIS BEAUTIFUL NEW WORMALD HOME... THE CHAPMAN.  Home Under Construction and not completed. 5 BEDROOM , 4.5 BATHS WITH MAIN LEVEL SUNROOM WITH HIGH-DESIGN GLASS BARN DOORS and FINISHED LOWER-LEVEL WALKOUT BASEMENT. Many upgraded finishes are included in this home! The  stunning 10 Ft WATERFALL KITCHEN ISLAND WITH FARM SINK  IS A HIGH-LIGHT. A completely finished Lower-Level  with 1,100 square foot REC ROOM, WET BAR, 5th BEDROOM, 4th FULL BATH and your very own Private Retreat Room. Tour Builder's model of same home plan. The Chapman modern farmhouse is our largest floor plan. Chapman-77 has a 2-Car Garage. Chapman-77 main level features a spacious Kitchen and adjoining Pantry, lovely Sunroom with high-design, glass Barn Doors (painted white) and floor-to-ceiling Solarium Windows, enclosed Studio for home office with 8' French Doors and cozy Gas Fireplace in the great room. The upper level boasts a Loft for relaxing, four Large Bedrooms with Walk-In Closets, three Full Baths, and a Laundry Room with sink and wall cabinet. In the lower level, you will enjoy an oversized Recreation Room, Wet Bar with Dishwasher, Bedroom, Bath with shower, and Retreat that can be used as a fitness, media room or hobby space. This beautiful home can be yours with a Late Summer 2025 delivery. This home is located in Frederick County close to Downtown Frederick. NO CITY TAXES. *Please note that all photography shown is from the Builder's model home which includes optional features, and is for representative purposes only.  
NOTE:  The Final Interior Selections are selected on this STUNNING NEW MODERN FARMHOUSE HOME at ROSEHAVEN by WORMALD HOMES.  This location is just minutes away from hip and historic,  Frederick.  LATE  SUMMER  DELIVERY.
#MDFR2061252

FREDERICK

8788 WALNUT BOTTOM LANE

5 Beds

4 Baths

5,383 Sq.Ft.

$1,015,000

MLS#: MDFR2061252

This Devonshire Cottage is a 6 bed, 4.5 bath home featuring an open floorplan, 2 staircases, and many unique customizations. Inside the Foyer, there is a Living Room to one side and Dining Room to the other. Continue down the hall past the staircase to find the main living area where the Family Room opens to the Kitchen with a large eat-in island. The Kitchen is a chef's dream, boasting cabinets to the ceiling, quartz countertops, a double wall oven, gas stove, and a Butler's Pantry connecting to the Dining Room that includes a large walk-in pantry. A hall off the back of the Kitchen leads to the first-floor Guest Suite, Powder Room, Garage, and second staircase. The entire first floor is finished with engineered plank flooring. Upstairs, the spacious Owner's Suite has 2 walk-in closets and a private full bath. This luxurious ensuite features a tiled shower, freestanding soaker tub, and dual vanity. Bedrooms 2 also include it's own ensuite full bath, while bedrooms 3, 4, & 5 share a hallway bath. A Loft on the second floor offers a hangout space away from the day-to-day function of the first floor. The Laundry Room is conveniently located on the same floor as all bedrooms. A partially finished basement adds 389 square feet of additional living space. An oversized 2-car garage is included. 

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.
#MDFR2066484

FREDERICK

642 GROOMS STREET

6 Beds

4 Baths

4,477 Sq.Ft.

$1,094,441

MLS#: MDFR2066484

A rare opportunity is presented with this charming and exceptional property located in the heart of the award-winning historic city of Frederick, Maryland, one of Money Magazine’s “50 Best Places to Live in the US” in 2024 for its history, culture, enviable social and food scene, and flourishing economy. This luxurious property, known as The Jacob Brunner House, is on the Frederick County Registry of the National Historical Landmarks Foundation. Step inside to an era where comfort, attention to detail, and charm were the order of the day. The spacious entrance hall features a grand floating staircase and sweeping hand-carved mahogany baluster rising to the two floors above. On the main level enjoy the exceptionally high ceilings, pocket doors, and extraordinary details that include 3 fully-restored Italian marble fireplaces, built-in custom shelving in the Library, and fully-restored original wide plank flooring. A dining room and two luxurious parlors are located on this floor, as well as a full bath, and the spacious first floor kitchen, fully modernized, features the original ceiling-high cooking hearth. The grand staircase leads to a second floor that includes four spacious rooms, two fireplaces and two full baths, with many possibilities as to how you might use the spaces: bedroom, work from home, playroom, or private sitting rooms with views of stunning 2nd street. The second floor also boasts built-in finished cabinets, two laundry rooms, and a second stairway that leads to three bonus rooms with sweeping vistas of historic downtown. From the second floor you can step outside onto a beautifully-restored wrap-around covered porch, with easy access to the courtyard garden and 3-car garage below via a spiral staircase. The grand staircase opens on the third floor to a complete suite that includes a foyer/office, full kitchen, two great rooms, a full bath and ample custom built-in cabinetry and storage. The third floor also boasts an expansive view of historic Frederick, a fully-restored original fireplace, and the same high ceilings, custom woodwork and wide plank flooring that typify the entire manse. The third-floor also has independent access to the outside covered porch, spiral stair, garden and garage. Indeed, each level of the house has two points of access: the front door/grand stair and a rear door for access to the porch, gardens and garage. One of only a handful of properties with a three-car garage in historic Frederick, this home also boasts one of the largest walled gardens in the city. Step outside into the garden where peace and serenity prevail. The hard brick landscaping from the back door leads through the garden to the garage, passing by a raised deck where you can enjoy a sunbath, summer evenings with friends, or a quiet morning with your favorite cup of Joe. A brand-new jacuzzi under the garden pavilion will tempt you with every stroll through the manicured meditation garden. There is also a large potting shed with great storage, and a walkway that provides access through the garden wall directly to the street. Basement access is just outside the back door: to a very large, dry, well-maintained, well-lit basement that provides ample storage. The property is presently zoned for a single family home, for three apartments, or for a Bed and Breakfast, but like many nearby properties, it has a strong potential to be re-zoned to a multi-unit condominium investment property. It can therefore be a lovely home for a well-to-do family, a two- or three-apartment building, a high-end Airbnb investment, a traditional Bed and Breakfast, or it could be developed into a multi-condominium investment.  Walk just minutes from this property to the canal with its beautiful summer lilies, patio dining and fountains, and live music, not to mention the micro-breweries, the vibrant art and theatre offerings and award-winning restaurants.  If you have very high expectations, this property won't disappoint. Live your bliss
#MDFR2061710

FREDERICK

101 E 2ND STREET

6 Beds

4 Baths

7,662 Sq.Ft.

$1,390,000

MLS#: MDFR2061710

 - property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to receive some additional information on this specific property or similar properties?

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