New - 19 hours ago

274 LONGFORD DR, Frederick, MD 21702

$359,999

$238 per ft²

3 Bed

2 Bath

1,514 Sq Ft

0.18 Acres

Listing Office: Long & Foster Real Estate, Inc.

Image 1 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 2 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 3 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 4 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 5 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 6 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 7 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 8 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 9 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 10 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 11 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 12 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 13 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 14 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 15 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 16 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 17 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 18 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 19 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 20 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 21 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 22 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 23 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 24 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 25 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 26 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 27 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 28 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 29 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 30 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Image 31 of property listing at 274 LONGFORD DR, Frederick, MD 21702

Discover this spacious split-foyer home nestled in the Stone Gate Farms community! Designed for both comfort and functionality, the upper level offers 2 bedrooms and 1 full bath, along with an open living room, kitchen, and dining area. Step out from the dining room onto the deck—perfect for relaxing or entertaining. The LVP flooring upstairs is approximately one year old, adding a fresh, modern touch. The lower level features two generously sized rooms, including 1 bedroom, a den, and 1 full bath, providing flexible living space for guests, a home office, or recreation. New carpet has recently been installed throughout the lower level. NO HOA!! Conveniently located near grocery stores, gas stations, shopping and commuter routes! Don’t miss this opportunity to make this inviting home your own!

Listing Agent: Leah N Duncan

License Number: 655373

Offered by: Long & Foster Real Estate, Inc.

Office Phone: 3016441086

MLS: #MDFR2075406

BrightMLS

Date Added: 01/14/2026 12:00:00 am

Last Update: 01/14/2026 05:05:27 pm

Days on Market: 2

Interior

General: Bathroom - Tub Shower, Carpet, Ceiling Fan(s), Combination Dining/Living, Crown Moldings, Dining Area
Rooms: Living Room, Dining Room, Bedroom 2, Bedroom 3, Kitchen, Den, Bedroom 1, Laundry, Bathroom 1, Bathroom 2
Appliances: Disposal, Dishwasher, Dryer, Refrigerator, Stainless Steel Appliances, Stove, Washer, WaterHeater
Laundry: Has Laundry, Lower Floor
Basement: Connecting stairway, Fully finished, Heated, Interior access, Outside entrance, Windows
A/C: Central A/C, Ceiling Fan(s)
Heating: true, Heat Pump(s), Electric
Disability Feature: None

Exterior

General: Above Grade, Below Grade
Style: Split Foyer

Construction

General: Vinyl Siding, 2, Permanent

Location

Originating MLS: BRIGHT_MAIN
School District: FREDERICK COUNTY PUBLIC SCHOOLS
County: FREDERICK-MD

Lot

Zoning: R8, 1102141167

Utilities

Water: Public
Sewer: Public Sewer

Financial

Source: BRIGHT_MAIN

Property

Year Built: 1987
Type: Single Family Home
Style: Split Foyer
Neighborhood: Stonegate
Parcel #: 1102141167

Schools

District: FREDERICK COUNTY PUBLIC SCHOOLS
Elementary: WAVERLEY
Middle: CRESTWOOD
High: GOVERNOR THOMAS JOHNSON

01/14/2026$359,999@ 238 per ft²Listed

01/14/2026Active

Listing Broker

Ryan Sigel

1 @

License #: RS340862

Email: ryan@theexchangerealestate.com

Phone: (717) 855-5300

Location: AL

Last Updated: 01/14/2026 05:05:27 pm

Offered by: Leah N Duncan, 655373, 2405860430 @ Long & Foster Real Estate, Inc.

MLS: #MDFR2075406

Source: BrightMLS

<IMG SRC='https://d37ukvrrv3in12.cloudfront.net/mls/logos/IDX_82.png' ALT='IDX'> Information Deemed Reliable But Not Guaranteed. The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which participates, and is provided by BRIGHT through a licensing agreement.<BR><BR>The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on this website may no longer be available because they are under contract, have sold or are no longer being offered for sale. Some real estate firms do not participate in IDX and their listings do not appear on this website. Some properties listed with participating firms do not appear on this website at the request of the seller. This home sale information is not to be construed as an appraisal and may not be used as such for any purpose. <BR> <BR>BRIGHT MLS is the (or a) provider of this home sale information and has compiled content from various sources. Some properties represented may not have actually sold due to reporting errors. ©2026 BrightMLS. All rights reserved. Data displayed may be a portion of, and not a complete set of all listings published in the MLS.

View Listing

274 LONGFORD DR, Frederick, MD 21702 is a 3 Bed, 2 Bath, 1,514 Sq Ft, 0.18 Acres, Single Family Home built in 1987.

This property is currently available and was listed by BrightMLS on 01/14/2026 12:00:00 am. The MLS # for the property is MLS #MDFR2075406.

274 LONGFORD DR, Frederick, MD 21702

Interior

Exterior

Construction

Location

Lot

Utilities

Financial

Property

Schools

Listing Broker

Property For Sale

Homes in Frederick by Price Range

Homes in Frederick by Bedrooms

Quick Links

Resources & Support

© Copyright 2025 All Rights Reserved.

Quick Links

Resources & Support

© Copyright 2025 All Rights Reserved.

Log in

Create an account

Lost Password?