**Unique Downtown Gem with Versatile Zoning** Discover the epitome of urban living at this exceptional property on coveted Church Street, just off Market Street and directly opposite the parking deck. Boasting a desirable DBO zoning for downtown business while being versatile enough for residential use, this property offers endless possibilities. 1. **Prime Location:** Situated at the heart of the action, this property is strategically located on Church Street, making it a focal point for both business and residential opportunities. Convenience meets charm in this bustling neighborhood. 2. **Versatile Zoning (DBO):** Zoned for downtown business, this property opens doors to a myriad of business ventures. Whether you envision a thriving commercial space or a stylish downtown residence, the choice is yours. 3. **Successful Airbnb Operation:** Currently operating as a successful Airbnb, this property has a proven track record for generating income. Take advantage of the established business or explore new possibilities with the flexible zoning. 4. **Multifunctional Layout:** Previously utilized as an art gallery on the first floor, a residence on the second, and an Airbnb on the third, the layout is adaptable to various uses. Live upstairs while running your business downstairs or convert it into a single-family home â the options are limitless. 5. **Stunning Interior Upgrades:** Experience modern luxury with brand-new hardwood floors, a beautifully updated kitchen, and magazine-worthy bathrooms. The interior exudes charm and sophistication, creating an inviting atmosphere. 6. **Outdoor Oasis:** Step into an urban oasis with a fenced-in double-gated yard featuring garden planters, a patio, gazebo, and gorgeous lighting. Ideal for outdoor dining for a food service business or a private retreat for residents. 7. **Off-Street Parking:** Enjoy the convenience of a fenced and double-gated yard, providing secure off-street parkingâa rare find in this vibrant downtown location. - Currently operating as a successful Airbnb - Zoned DBO for downtown business - All-new hardwood floors - Updated kitchen and baths - Fenced double-gated yard for off-street parking Don't miss this incredible opportunity to own a property that combines downtown business potential with the charm of a residential oasis. Contact us today for an exclusive private showing and unlock the endless possibilities that await!
Discover your dream countryside retreat on this expansive 17+ acre estate, where tranquility meets functionality! Surrounded by multiple fenced pastures ideal for grazing or farming, this property is a haven for nature lovers and equestrians alike. Main house has over 5,000 sq ft of space for entertaining. First floor offers a spacious foyer, large eat-in kitchen with breakfast bar, family room with vaulted ceilings and gas fireplace, sunroom with additional gas fireplace overlooking the huge patio & in-ground Gunite pool, with tiki hut, office, sizeable mudroom/laundry off of the 2 car garage, and a pool room with wet bar & side door to the patio. Upper level offers a roomy Primary bedroom with full bath and walk-in closet, 3 additional bedrooms, and a full bath in the hallway. Lower level is partially finished with recreational room, kitchenette, two additional bonus rooms and walk out to the backyard. Lots of storage available in the unfinished portion of the lower level. Exterior amenities are perfect for livestock or as a versatile space for your hobbies with a two-level 30'x60' barn, paddocks with American wire fencing, chicken coop area, & 24'x50' machine shed/pole barn with water/electric. Detached 30'x60' garage, complete with a 1 bedroom apartment(2nd bedroom potential), including living room, kitchen, and full bath, offering a cozy living space for guests, animal caretakers, or an opportunity for rental income. Main house and all outbuildings have metal roofs that were replaced in 2020. Main house HWH (2018), Heat pump (2017), a/c (2022), dishwasher (2022), gutters (2023), portable generator, well pressure tank (2023), Apartment HWH (2021), refrigerator (2022), dryer (2022).
Large price reduction! Wonderful Frederick City semi-detached historic home within walking distance to restaurants, shops, Baker Park and all that downtown Frederick has to offer! This 2 BR, 1.5 BA home has tons of charm and character. Living room with brick fireplace, separate dining room and vaulted ceiling upgraded kitchen with exposed beams and brick. Partially finished walk-up attic allows for additional future finished living space. Nice fully fenced rear yard with brick patio. Separate deeded covered parking spot just around the corner conveys with the sale - Tax ID 1102182629. Seller would consider some or all furnishings/furniture to convey with the sale if Buyer desires. Sold "as-is" but inspections welcome. This property is located in the Historic District of Frederick City.
IMMEDIATE DELIVERY. Ask about our special financing available as low as a 5.99% special interest rate! This four level 5 bedroom, 4.5 bathroom home is a quick move in home! Nestled in the most beautiful and peaceful enclave of Historic Downtown Frederick, The Renn Quarter offers quick move in single family homes across the street from Carroll Creek and our extraordinary home-sites face open spaces, Monocacy River and Carrol Creek, rolling hills, open spaces and amazing sky lines. The Renn Quarter community is less than a mile away from the heart of downtown Frederick; is the location of the future Carroll Creek Walkway Extension; and will be an amenity filled community! You will have all the conveniences and benefits of Historic Frederick, while living in a brand new, modern home! The Jade is our newest and most jaw dropping floorplan in the community! The home features a ton of our buyerâs favorite options, including the extremely desirable bonus room on the 4th level! Perfect for a kidâs playroom or private office. The ownerâs suite doubles as an adult oasis, a perfect place to relax. The on-suite bathroom features an oversized walk in shower fit for a spa, with two separate walk in closets. Three secondary bedrooms and two secondary bathrooms round out the third level, making it perfect for multiple family members. Downstairs, an open and inviting kitchen and family room screams entertainment. The gourmet kitchen is accentuated stainless steel appliances, a built-in wall oven and microwave, hood vent, quartz countertops, and a trendy herringbone, mosaic glass backsplash. A separate formal dining room which can double as an office and a half bath is situated up front, perfect for guests. A short trip to the basement opens to a beautifully finished rec room, large enough for all your entertainment needs. Around the corner, a larger basement bedroom and full bathroom complete your lower level. Contact us today to schedule a showing and to ask about our amazing incentives!
Step into a realm where historic charm intertwines seamlessly with modern comfort. The 'Queen of Rockwell Terrace,' a distinguished Greek Revival residence was built in 1929. Sitting on an expansive two-and-a-half city lots, this regal estate backs to Memorial Park, offering a serene retreat just steps away from the vibrant heart of downtown and the allure of Baker Park. A grand entrance welcomes you with a huge covered porch in the front and a screened porch at the rear, both perfect for unwinding or entertaining. The saltwater heated pool has an automatic cover, a soothing waterfall feature, a tanning ledge, bench with jets, bubblers, and a kaleidoscope of multi-color lighting options. Enclosed within custom fencing of masonry pillars and board-on-board high wood panels, this private oasis invites indulgence and relaxation. Step into the generous foyer with a custom gallery wall and exquisite woodwork. The oversized living room seamlessly flows into a dining room featuring navy silk grass cloth wallpaper and a dazzling chandelier. The first floor has two bedrooms and two full baths, with one bedroom currently serving as an office. The chef's kitchen is a culinary haven with a Wolf range, Sub Zero refrigerator, hammered Copper hood, and quartz counters. Cork floors underfoot add comfort to the culinary experience. A sitting room adjacent to the kitchen offers a cozy retreat, while open to the sunny family room, complete with a gas fireplace and just steps to the detached garage. Second floor has three spacious bedrooms and three full baths await. A BRAND-NEW primary bathroom, an epitome of luxury, adds a touch of opulence. Also new is the custom oversized walk in closet. A small kitchen and dining space on this level offers versatility, ideal for an in-law or au pair suite. Possibility for a roof top deck on second level. The walk-up attic was originally a ballroom with stage and now used for storage has potential to be further finished to bedroom or studio space. Convenience is at the forefront with a custom mudroom discreetly tucked away and a laundry room on the second level, complemented by a secondary set of washer and dryer in the basement. Not bound by an HOA and located outside the historic district. Grand Frederick homes like this don't come around often. Call today for an exclusive tour and make this extraordinary property your own.
Move in Ready 3 Bedroom, 1.5 Bathroom. Off Street Parking and a nice Fenced backyard. New Ductless Mini Split Air Conditioner. ALL New SS Appliances. Updated Kitchen with New Granite and New Tile backsplash. New Electric Range/Stove. New Built-In Microwave. New Garbage Disposal. New Dishwasher. New Refrigerator. Updated Bath. New Carpet. Updated Windows. All Fresh Paint. Ceiling Fans. Full basement for storage. Great Commuter Location close to 70, 270 & 15. 1 mile from Downtown Frederick Square, Half Mile from Shab Row.
