Mcmahanhomes.com Search Results

Zoned DBO for both Residential & Office Use. Nestled in the heart of Historic Frederick City, this exquisite residence, CIRCA 1765, offers a unique blend of timeless elegance and modern luxury. Spanning over approximately 5,818 square feet first floor grade & above, this residence is a true architectural gem, showcasing colonial design elements that harmoniously blend with contemporary comforts. The property sets on 2 city lots both contiguous to one another featuring beautifully landscaped grounds that provide a serene retreat from the bustling downtown atmosphere. The level yard is adorned with mature trees and vibrant gardens & creates a picturesque backdrop for outdoor gatherings or quiet moments of reflection. Enjoy the tranquility of this unique designed garden where nature meets sophistication complimented by one of the largest & oldest colorful Ginkgo Trees in the USA certified by the MD Forestry Division. Step inside to discover a warm and inviting interior, where original wide heart plank pine hardwood flooring flows seamlessly throughout the main living areas. The home boasts with multiple fireplaces perfect for cozy evenings, 1st floor laundry, pantry, primary kitchen complimented with an adjoining galley kitchen to accommodate large gatherings. The 3rd floor serves today as the primary living quarters which includes a private owners suite that includes a large bedroom suite, separate adjoining sitting room, 2nd full kitchen, full bath with walk in shower alcove, light filled dressing room & 2 spacious oversized walk-in closets. There are 4 individual HVAC systems, spacious formal living room & dining room with restored antique chandeliers throughout the residence. The full basement, complete with interior access and ample shelving, provides possibilities for customization & or extra storage. The property's location is unparalleled a vibrant part of the inner city cultural scene, with a convenient walk to the MARC Rail Station, restaurants, & galleries. Parking is a downtown luxury & the property conveys with a newer detached garage with 3 deep bays approximately 1200 SQ/FT enhanced with a newly installed commercial grade epoxy floor finish that accommodates three vehicles plus storage alcove. In addition to the 3 bay garage there is also a guest parking lot for an additional 9 vehicles. The views from this property are nothing short of enchanting, showcasing the vibrant city scape and lush courtyard gardens that surround you. This home is not just a residence; it's a lifestyle, offering the perfect blend of comfort, elegance, and accessibility. Experience the charm of Historic Frederick City while enjoying the modern amenities and luxurious features this property has to offer. Ideal property for an upscale Air B & B, condo conversion, or professional offices due to the Frederick City DBO Zoning. This is more than just a home; it's a sanctuary where memories are made and cherished for years to come. Embrace the exclusive lifestyle that awaits you in this remarkable residence. Every space in this residence has been thoughtfully curated to offer a gracious & beautiful experience while honoring the historical features of the historic Hanna House.

5 Beds ⋅ 5 Baths

Zoned DBO for both Residential & Office Use. Nestled in the heart of Historic Frederick City, this exquisite residence, CIRCA 1765, offers a unique blend of timeless elegance and modern luxury. Spanning over approximately 5,818 square feet first floor grade & above, this residence is a true architectural gem, showcasing colonial design elements that harmoniously blend with contemporary comforts. The property sets on 2 city lots both contiguous to one another featuring beautifully landscaped grounds that provide a serene retreat from the bustling downtown atmosphere. The level yard is adorned with mature trees and vibrant gardens & creates a picturesque backdrop for outdoor gatherings or quiet moments of reflection. Enjoy the tranquility of this unique designed garden where nature meets sophistication complimented by one of the largest & oldest colorful Ginkgo Trees in the USA certified by the MD Forestry Division. Step inside to discover a warm and inviting interior, where original wide heart plank pine hardwood flooring flows seamlessly throughout the main living areas. The home boasts with multiple fireplaces perfect for cozy evenings, 1st floor laundry, pantry, primary kitchen complimented with an adjoining galley kitchen to accommodate large gatherings. The 3rd floor serves today as the primary living quarters which includes a private owners suite that includes a large bedroom suite, separate adjoining sitting room, 2nd full kitchen, full bath with walk in shower alcove, light filled dressing room & 2 spacious oversized walk-in closets. There are 4 individual HVAC systems, spacious formal living room & dining room with restored antique chandeliers throughout the residence. The full basement, complete with interior access and ample shelving, provides possibilities for customization & or extra storage. The property's location is unparalleled a vibrant part of the inner city cultural scene, with a convenient walk to the MARC Rail Station, restaurants, & galleries. Parking is a downtown luxury & the property conveys with a newer detached garage with 3 deep bays approximately 1200 SQ/FT enhanced with a newly installed commercial grade epoxy floor finish that accommodates three vehicles plus storage alcove. In addition to the 3 bay garage there is also a guest parking lot for an additional 9 vehicles. The views from this property are nothing short of enchanting, showcasing the vibrant city scape and lush courtyard gardens that surround you. This home is not just a residence; it's a lifestyle, offering the perfect blend of comfort, elegance, and accessibility. Experience the charm of Historic Frederick City while enjoying the modern amenities and luxurious features this property has to offer. Ideal property for an upscale Air B & B, condo conversion, or professional offices due to the Frederick City DBO Zoning. This is more than just a home; it's a sanctuary where memories are made and cherished for years to come. Embrace the exclusive lifestyle that awaits you in this remarkable residence. Every space in this residence has been thoughtfully curated to offer a gracious & beautiful experience while honoring the historical features of the historic Hanna House.

11 W Second St, Frederick

Listing courtesy of Real Estate Teams, LLC. Contact:

$1,299,000

Luxury condo in downtown Frederick, adjacent to Visitation Hotel Frederick and Wye Oak Tavern! Move-in ready! Five units sold and delivered. Only 2 units remaining! Secure entry and elevator. This 3 bedroom, 2 full and one half bath unit features large open floor plan, gourmet kitchen with quartz countertops, hardwood flooring throughout, large primary suite with marble tile shower and two, large walk-in closets,. Deck space for outdoor dining, guest bedroom with en-suite bathroom, powder room, and separate laundry room. Two deeded garage parking spaces. Park in the garage and an elevator will deliver you to single floor living in the heart of downtown Frederick.

3 Beds ⋅ 3 Baths

Luxury condo in downtown Frederick, adjacent to Visitation Hotel Frederick and Wye Oak Tavern! Move-in ready! Five units sold and delivered. Only 2 units remaining! Secure entry and elevator. This 3 bedroom, 2 full and one half bath unit features large open floor plan, gourmet kitchen with quartz countertops, hardwood flooring throughout, large primary suite with marble tile shower and two, large walk-in closets,. Deck space for outdoor dining, guest bedroom with en-suite bathroom, powder room, and separate laundry room. Two deeded garage parking spaces. Park in the garage and an elevator will deliver you to single floor living in the heart of downtown Frederick.

208 Second St E Unit 202, Frederick

Listing courtesy of RE/MAX Results. Contact:

$659,999

Exposed brick, rustic beams, original hardwood floors, and timeless architectural details capture the charm of Historic Downtown Frederick. Beautifully renovated in 2019 by the original developer of Moore’s Row next door, this three-level duplex blends historic character with modern comfort and is move-in ready. The home offers three bedrooms, 2.5 bathrooms, high ceilings, and flexible finished space for everyday living, guests, entertaining, or a home office. Thoughtful updates throughout complement the original details while providing the conveniences of today. Outside, enjoy a private fenced backyard with green space, a shaded hardscape area, and alley access. An oversized two-car garage with electricity and dedicated parking pads adds rare convenience, along with easy access into the home from the front and back. Located just blocks from Market Street, locally owned shops, restaurants, galleries, arts centers, and antique stores, the home is also conveniently close to the Frederick MARC Train Station for commuting to Washington, D.C., and Montgomery County. Turnkey, distinctive, and full of character, 230 E. 6th Street offers a rare opportunity to enjoy the best of historic Frederick with modern comfort and convenience. With a recent price improvement, this is an exceptional opportunity to own a beautifully renovated historic home offering the character, convenience, and parking that are so difficult to find in Downtown Frederick. Schedule your tour today!

3 Beds ⋅ 3 Baths

Exposed brick, rustic beams, original hardwood floors, and timeless architectural details capture the charm of Historic Downtown Frederick. Beautifully renovated in 2019 by the original developer of Moore’s Row next door, this three-level duplex blends historic character with modern comfort and is move-in ready. The home offers three bedrooms, 2.5 bathrooms, high ceilings, and flexible finished space for everyday living, guests, entertaining, or a home office. Thoughtful updates throughout complement the original details while providing the conveniences of today. Outside, enjoy a private fenced backyard with green space, a shaded hardscape area, and alley access. An oversized two-car garage with electricity and dedicated parking pads adds rare convenience, along with easy access into the home from the front and back. Located just blocks from Market Street, locally owned shops, restaurants, galleries, arts centers, and antique stores, the home is also conveniently close to the Frederick MARC Train Station for commuting to Washington, D.C., and Montgomery County. Turnkey, distinctive, and full of character, 230 E. 6th Street offers a rare opportunity to enjoy the best of historic Frederick with modern comfort and convenience. With a recent price improvement, this is an exceptional opportunity to own a beautifully renovated historic home offering the character, convenience, and parking that are so difficult to find in Downtown Frederick. Schedule your tour today!

230 E 6th, Frederick

Listing courtesy of Maryland Elite Realtors. Contact:

$475,000

Experience the charm of downtown living in this exceptional second-floor condo, ideally located just one block from Market Street in the heart of historic Frederick. A spacious foyer welcomes you upon entry and leads to a private staircase that opens into a beautifully designed living space where modern finishes blend seamlessly with timeless character. The open-concept floor plan features a generous living room, spacious dining area, and a gourmet kitchen appointed with quartz countertops, stainless steel appliances, upgraded lighting, and a striking exposed brick accent wall that adds warmth and architectural appeal. The owner's suite serves as a peaceful retreat, offering views of the backyard, a spacious walk-in closet, and a spa-inspired en-suite bath complete with a double-bowl vanity and an oversized walk-in shower featuring a luxurious 16-inch rain shower head. Two additional bedrooms are situated at the front of the home, accompanied by a second full bathroom conveniently located off the main hallway. Enjoy multiple outdoor living spaces, including a private covered slate balcony, rear deck, shared patio, and expansive backyard—perfect for relaxing, entertaining, or simply enjoying the outdoors. Rounding out this exceptional property is the rare convenience of private off-street parking, a highly sought-after amenity in downtown Frederick. Perfectly positioned within walking distance of Carroll Creek, Market Street, award-winning restaurants, boutique shopping, breweries, entertainment, and year-round community events, this beautifully updated condo offers the ideal combination of historic charm, modern luxury, and an unbeatable downtown lifestyle. Adding to its appeal, this property offers exceptional flexibility for homeowners and investors alike. The unit has been operating as a highly successful Airbnb, generating $36,315.79 in annual rental income while maintaining strong year-round occupancy. Future reservations can be transferred to a new owner or cancelled to accommodate a traditional owner-occupant with a 30-day closing. Looking for even greater potential? This condo may also be purchased together with the first-floor unit at 118 W. All Saints Street (MLS #FR2083498), providing a rare opportunity to own both residences. Live in one while continuing to generate income from the other, expand your investment portfolio with two established short-term rentals, or purchase this unit on its own and enjoy everything downtown Frederick has to offer. Whether you're searching for your next home, a turnkey investment, or the opportunity to do both, this is a rare offering in one of Frederick's most desirable downtown locations.

3 Beds ⋅ 2 Baths

Experience the charm of downtown living in this exceptional second-floor condo, ideally located just one block from Market Street in the heart of historic Frederick. A spacious foyer welcomes you upon entry and leads to a private staircase that opens into a beautifully designed living space where modern finishes blend seamlessly with timeless character. The open-concept floor plan features a generous living room, spacious dining area, and a gourmet kitchen appointed with quartz countertops, stainless steel appliances, upgraded lighting, and a striking exposed brick accent wall that adds warmth and architectural appeal. The owner's suite serves as a peaceful retreat, offering views of the backyard, a spacious walk-in closet, and a spa-inspired en-suite bath complete with a double-bowl vanity and an oversized walk-in shower featuring a luxurious 16-inch rain shower head. Two additional bedrooms are situated at the front of the home, accompanied by a second full bathroom conveniently located off the main hallway. Enjoy multiple outdoor living spaces, including a private covered slate balcony, rear deck, shared patio, and expansive backyard—perfect for relaxing, entertaining, or simply enjoying the outdoors. Rounding out this exceptional property is the rare convenience of private off-street parking, a highly sought-after amenity in downtown Frederick. Perfectly positioned within walking distance of Carroll Creek, Market Street, award-winning restaurants, boutique shopping, breweries, entertainment, and year-round community events, this beautifully updated condo offers the ideal combination of historic charm, modern luxury, and an unbeatable downtown lifestyle. Adding to its appeal, this property offers exceptional flexibility for homeowners and investors alike. The unit has been operating as a highly successful Airbnb, generating $36,315.79 in annual rental income while maintaining strong year-round occupancy. Future reservations can be transferred to a new owner or cancelled to accommodate a traditional owner-occupant with a 30-day closing. Looking for even greater potential? This condo may also be purchased together with the first-floor unit at 118 W. All Saints Street (MLS #FR2083498), providing a rare opportunity to own both residences. Live in one while continuing to generate income from the other, expand your investment portfolio with two established short-term rentals, or purchase this unit on its own and enjoy everything downtown Frederick has to offer. Whether you're searching for your next home, a turnkey investment, or the opportunity to do both, this is a rare offering in one of Frederick's most desirable downtown locations.

120 W All Saints St, Frederick

Listing courtesy of Charis Realty Group. Contact: