Features & Amenities

Interior

  • Other Interior Features

    Ceiling Fan(s), Kitchen Island, Pantry, Recessed Lighting, Walk-In Closet(s), Built-in Features, Crown Molding, Open Floorplan, Soaking Tub

  • Total Bedrooms

    5

  • Bathrooms

    4

  • Above Grade Finished Area

    2702.0

  • Basement YN

    YES

  • Cooling YN

    YES

  • Cooling

    Central Air, Ceiling Fan(s), Electric

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Exhaust Fan, Natural Gas, Forced Air

  • Main Level Bedrooms

    1

  • Pet friendly

    Yes

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Brick Veneer, Vinyl Siding, HardiPlank Type

  • Other Exterior Features

    Lighting

  • Parking

    Oversized, Garage Door Opener, Concrete, Garage, Attached

  • Patio and Porch Features

    Deck, Patio

  • Pool

    No

  • Waterfront YN

    NO

  • View

    City

Area & Lot

  • Lot Features

    Corner Lot, Cul-De-Sac

  • Lot Size(acres)

    0.13

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Colonial, Craftsman

Price

  • Sales Price

    $825,000

  • Tax Amount

    $7,572.48

  • Sq. Footage

    3, 812

  • Price/SqFt

    $216

HOA

  • Association

    Yes

  • Association Fee

    $76

  • Association Fee Frequency

    Monthly

  • Association Fee Includes

    N/A

School District

  • Elementary School

    OAKDALE

  • Middle School

    OAKDALE

  • High School

    OAKDALE

Property Features

  • Association Amenities

    Jogging Path, Playground

  • Foundation Details

    Concrete Perimeter

  • Senior Community YN

    NO

  • Sewer

    Septic Tank

  • Tax Lot

    113

  • 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

OAKDALE

Middle School

OAKDALE

High School

OAKDALE

Listing Courtesy of Patricia G Mills , Charis Realty Group

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 Phil Herbert

AGENT

Phil Herbert

Call Phil 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.
5703 Guilford Garden Terrace bathes in natural light from sunrise to sunset and seamlessly blends comfort, style, and functionality. This is the most popular floorplan in the Preserve at Long Branch by D.R. Horton, offering over 4,800 sq. ft. of beautifully finished living space.  Step inside to discover 5 bedrooms and 5 full bathrooms, including a rare main-level guest suite with a luxury full bath—perfect for multigenerational living or visiting guests. Enjoy morning sunrises from the deck or kitchen and unwind under star-lit evening skies.  The main level features durable luxury vinyl plank flooring, upgraded modern lighting, and an inviting open-concept layout. The gourmet kitchen is a chef’s dream, boasting stainless steel appliances, quartz countertops, an upgraded backsplash, and a spacious island ideal for meal prep and entertainment. A dining room, a bright family room, a walkout to the expansive composite deck with solar lighting, and a 2-car garage complete this level.  Throughout the home, the owners have added thoughtful upgrades and smart-home features, including premium lighting, updated ceiling fans, and custom closet organizers.   Upstairs, the expansive primary suite includes a sitting area, a spa-like en-suite bath, and a generous walk-in closet. Two additional bedrooms, a full bath, an upper-level loft/family room, and a convenient laundry room complete the second floor.  The walk-out lower level is an entertainer’s paradise, showcasing a spacious recreation room, a custom built-in electric fireplace with lighted shelving and TV mount, a bedroom with full luxury bath, abundant storage, and access to the custom stone patio with a retaining wall, white vinyl fencing, and stunning landscaping. A water softener is also included.  
Located in the highly sought-after Oakdale School District, this home offers easy access to major commuting routes, shopping, restaurants, and Historic Downtown Frederick.  Don’t miss your chance to make this breathtaking home yours!

5703 GUILFORD GARDEN TERRACE

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

Welcome to this stunning Covington model single-family home in the highly sought-after Kellerton community! From the moment you arrive, you'll be charmed by the inviting front porch—perfect for enjoying your morning coffee. Step inside to a bright and welcoming foyer, where you'll find a private home office to the right, featuring an elegant arched bay window that fills the space with natural light. A full bath conveniently sits just outside the office, adding flexibility for guests or remote work needs. The heart of the home is the expansive open-concept living space. The spacious dining area seamlessly flows into the family room, where a cozy gas fireplace creates a warm and inviting atmosphere. The gourmet kitchen is a chef’s dream, boasting white cabinetry, Quartz counters, sleek stainless steel appliances, a massive island, a large pantry, and a sliding glass door leading to your future deck—perfect for indoor-outdoor entertaining. Beautiful luxury vinyl wood flooring runs throughout the main level, enhancing the home's modern elegance. Upstairs, the luxurious primary suite is a true retreat, complete with his-and-her walk-in closets and a spa-like ensuite bath featuring a soaking tub and a separate shower. Three additional generously sized bedrooms and another full bath complete the upper level. The fully finished basement offers incredible versatility, featuring a spacious recreation area with a bar, a level walkout to the backyard, a full bath, and two additional bedrooms—ideal for guests or multigenerational living. Freshly painted and move-in ready, this home is waiting for its new owners. Don't miss this incredible opportunity to own in Kellerton—schedule your showing today!
#MDFR2079174

FREDERICK

1710 TROTTER STREET

5 Beds

4 Baths

4,396 Sq.Ft.

$749,900

MLS#: MDFR2079174

Experience elevated living in the prestigious Wormans Mill community of Frederick, Maryland. Set along a charming colonial courtyard, this impeccably maintained residence offers timeless elegance, modern comfort, and effortless convenience. Enjoy true low-maintenance living with exterior care and snow removal included. The main level features all-new flooring and fresh paint, a light-filled great room with a gas fireplace, and a beautifully updated kitchen with gas cooking, double ovens, and brand-new appliances. A sunny morning room and private porch provide inviting spaces to enjoy coffee or unwind at day’s end. The main level also offers two bedrooms plus a spacious primary suite with a recently updated luxurious bath, along with a convenient main-level laundry room. The finished lower level provides additional living space with a cozy fireplace, half bath, and abundant storage. Added peace of mind comes with a brand-new roof, and an attached two-car garage. Just steps from boutique dining, cafés, parks, and premier community amenities—including a pool, clubhouse, fitness center, courts, and scenic walking paths—this home delivers both luxury and lifestyle. All just minutes from Wegmans, major shopping, commuter routes, and historic downtown Frederick. Welcome home to elegance, convenience, and refined community living. Schedule your private tour today.
#MDFR2079460

FREDERICK

2654 BROOK VALLEY ROAD

3 Beds

2 Baths

3,311 Sq.Ft.

$680,000

MLS#: MDFR2079460

Welcome to Wilson! This beautifully reimagined 1920s Charming Colonial in Downtown Frederick blends timeless appeal with modern efficiency across a classic three-story layout. Thoughtfully renovated down to the studs, this home has been completely updated with new plumbing, electrical, insulation, siding, gutters, roof, windows, HVAC, and high-efficiency systems—offering peace of mind and contemporary comfort.

Warm, inviting, and full of character, the main level features a stunning new kitchen with white cabinetry, and accented dark center island, granite countertops, stainless steel appliances, electric cooking, and a spacious walk-in pantry. The main level also offers a flexible living/family room, a separate dining room, a convenient laundry room with washer and dryer, and a stylish half bath.

Upstairs, you’ll find three generously sized primary suites, each with its own private full bathroom—along with walk-in closet space, providing both comfort and privacy for all.  The finished basement adds versatile living space perfect for a game room, home office, exercise, or additional lounge area, plus a separate utility room with excellent storage.

Outside, enjoy a covered rear porch overlooking the expansive 0.83-acre lot—an incredible find in Downtown Frederick—offering endless possibilities for gardening and entertaining. Additional exterior features include a newly paved expansive driveway, brand new 1 car detached garage with electric, and a sprawling front porch.

Ideally located near major commuter routes, this one-of-a-kind home combines historic charm, modern upgrades, and rare outdoor space—making it a must-see!
#MDFR2080150

FREDERICK

629 WILSON PLACE

3 Beds

3 Baths

2,832 Sq.Ft.

$799,900

MLS#: MDFR2080150

New on site 1 day ago
***OPEN HOUSES*** Saturday, 4/18 from 12-2 pm AND Sunday, 4/19 from 10-12pm ***OPEN HOUSES*** Welcome to this beautifully maintained 4-bedroom, 3.5-bath home in the highly sought-after River Oaks neighborhood. Featuring newer LVP flooring, newer carpet, and fresh paint throughout, this home offers both comfort and style. The spacious first floor offers a formal living room, formal dining room, and a large kitchen, along with a private first-floor office—perfect for working from home—a bright morning room ideal for casual dining, and a relaxing screened-in porch for enjoying the outdoors. The fully finished basement provides additional living space while still offering plenty of storage. The luxurious primary suite boasts a fully updated ensuite bath, a comfortable sitting room, and two walk-in closets. Conveniently located near major commuter routes and just minutes from downtown Frederick, this home combines suburban charm with easy access to shopping, dining, and entertainment. Situated within the desirable Oakdale High School feeder pattern, this is an exceptional opportunity you won’t want to miss.  Available April 16th.
#MDFR2079502

FREDERICK

5867 WINTER OAKS PLACE

4 Beds

3 Baths

3,305 Sq.Ft.

$749,900

MLS#: MDFR2079502

Come experience luxurious active adult living with NVHomes at 55+ Bloomfields. With expansive and sophisticated amenities in the works, including a well-appointed community clubhouse and pool, access to shops and dining, a social atmosphere, and inclusive community activities, you won't ever want to leave. Discover your dream home in the Delphi, a stunning two-story home that seamlessly blends luxury, comfort and smart design. Step into a world of elegance with the main-level Owner’s Suite, offering a private sanctuary. The heart of the home beats in the expansive great room, where 9’ ceilings and large windows create an airy, inviting atmosphere perfect for both every living and entertaining. The flexible living spaces throughout the home adapt effortlessly to any lifestyle. For those who love to entertain, optional upgrades like a covered porch with a fireplace or a lower-level recreation room with a wet bar turn your home into the ultimate gathering spot. The Delphi – the perfect balance of style, functionality, and comfort in a home.  With state-of-the-art upgrades, such as LED lighting, ecobee smart thermostats, and Wi-Fi-enabled garage doors, this home is made for easy-living. *Current incentives include a free finished recreation room, and $15,000 closing costs concessions with use of NVR Mortgage. See Sales Representative for details*
#MDFR2076748

FREDERICK

2619 BROADLEAF DRIVE

3 Beds

3 Baths

4,034 Sq.Ft.

$809,990

MLS#: MDFR2076748

Come experience luxurious active adult living with NVHomes at 55+ Bloomfields. With expansive and sophisticated amenities in the works, including a well-appointed community clubhouse and pool, access to shops and dining, a social atmosphere, and inclusive community activities, you won't ever want to leave. Meet the Bonair – where stylish living gets a fresh, fun twist! This thoughtfully designed one-level home combines the best of both worlds with its welcoming open layout and smart privacy features. The expansive kitchen, with its impressive 9’ ceilings, flows seamlessly into a sun-filled great room that’s perfect for both casual gatherings and elegant entertaining. Retreat to your peaceful owner’s suite when you need some quiet time, while the flexible bedroom and bonus space adapt to whatever life throws your way. The arrival center keeps daily chaos at bay, and the oversized garage handles everything from cars to storage with ease.  Welcome home to the perfect blend of luxury and livability. With state-of-the-art upgrades, such as LED lighting, ecobee smart thermostats, and Wi-Fi-enabled garage doors, this home is made for easy-living. **Current incentives include a free finished recreation room, and $15,000 closing costs concessions with use of NVR Mortgage. See Sales Representative for details. **
#MDFR2076744

FREDERICK

2615 BROADLEAF DRIVE

2 Beds

2 Baths

3,357 Sq.Ft.

$729,990

MLS#: MDFR2076744

INCENTVE ALREADY APPLIED TO THE PRICE! INCLUDED FINISHED BASEMENT AREA 1! BRAND NEW SINGLE FAMILY HOMES STARTING IN THE UPPER $600'S BACKING TO OPEN GREEN SPACE IN FREDERICK, MD!!

FINAL OPPORTUNITY for a single family brand new home at Tuscarora Creek East in desirable Frederick, MD!! The Regent II is a beautifully designed home with an open-concept floor plan. Enter through the attached 2-car SIDE ENTRY garage to step into the stunning kitchen, you will immediately notice the spacious island and breakfast area, which flows seamlessly into the family room. This home is appointed with a grad formal dining room with tray ceiling as well as a first floor guest bedroom with a full bath! The primary suite is a true retreat, featuring an expansive walk-in closet, a dual vanity, and an oversized Roman shower for the ultimate spa-like experience. Additionally, the home's optional loft offers the perfect place for a home office or relaxation space. This home includes a finished basement with egress and an optional full bath.  Schedule a tour learn more about this amazing home! *Photos may not be of actual home. Photos may be of similar home/floorplan if home is under construction or if this is a base price listing.
#MDFR2073656

FREDERICK

HOMESITE 830 REAGANS ROAD

4 Beds

4 Baths

3,708 Sq.Ft.

$749,990

MLS#: MDFR2073656

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

CORNER PENTHOUSE: RARE opportunity to own a 2,950 sq. ft. corner luxurious condo! Park Place at Worman’s
Mill is a conveniently located, secure condominium building. If you
want to simplify your life without down-sizing, this is a must see. The
2,950 square foot unit includes a spacious foyer, living room, dining
room, sunroom, kitchen, family room, laundry room, three guests
bedrooms, a primary bedroom, three and a half bathrooms and two
private balconies. That is accurate…four bedrooms plus an additional
space for an office. Two of the bedrooms have attached baths. The
primary bathroom has a soaking tub situated perfectly for admiring the
gorgeous view. Speaking of views, enjoy gazing at mountains, trees, or
water -- your choice from the 26 windows letting in natural light! Visible
updates abound, but attention to detail is not limited to the interior
features. Meticulous maintenance or replacement has been
documented. The condo association has demonstrated similar care for
the building with recent replacements of the roof, elevators, and lobby
décor. No special assessment was needed due to the well-managed
association. Concerned about storage space? There is a large storage
area within the unit and 2 storage closets in a separate building behind
the condominium through the garage. That’s right. This condo has
garage parking. Three deeded parking spaces are yours to enjoy in
good weather or bad (33, 34 and 35). In addition to those three spaces
inside the secure garage, there is a deeded space right in front of the
building (25). Again, that is accurate…four deeded parking spaces.
Once your car is parked, you have many options. Stroll through the
nature preserve and enjoy the wildlife. Walk to a variety of
restaurants, shops/service providers, or enjoy the many amenities in
Worman’s Mill including multiple pools, a lending library, tot lot, pickle
ball/tennis/basketball courts, gym, and a club house. These units don’t
come on the market often. Don’t miss your chance to own this one.
#MDFR2077550

FREDERICK

2520 WATERSIDE DRIVE 410

4 Beds

3 Baths

2,950 Sq.Ft.

$839,000

MLS#: MDFR2077550

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.

$939,900

MLS#: MDFR2076156

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