Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$359,999 Just Listed

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 1,514 Sq. Ft.
  • Updated 1 day ago
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 274 Longford Dr

General

  • Price: $359,999
  • Taxes: $5,409 (2025)
  • Status: Active
  • Type: Single Family
  • Source: BrightMLSMidAtlantic
  • MLS ID: MDFR2075406
  • Updated: 1/14/2026
  • Added to Site: 1 day(s) ago

Interior

  • Rooms/Areas: Living Room, Dining Room, Bedroom 2, Bedroom 3, Kitchen, Den, Bedroom 1, Laundry, Bathroom 1, Bathroom 2
  • Interior Features: Bathroom - Tub Shower, Carpet, Ceiling Fan(s), Combination Dining/Living, Crown Moldings, Dining Area
  • Appliances: Disposal, Dishwasher, Dryer, Refrigerator, Stainless Steel Appliances, Stove, Washer, Water Heater

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2
  • Main Floor Baths: 1
  • Main - Full Baths: 1
  • Lower Floor Baths: 1
  • Lower - Full Baths: 1

Bedrooms

  • Total Bedrooms: 3
  • Bedrooms Lower: 1
  • Bedrooms Main & Up: 2

Other Rooms

  • Laundry: Has Laundry, Lower Floor

Parking

  • Parking Type: Driveway, Off Street

Location

  • Municipality: Frederick City
  • County: FREDERICK
  • Subdivision: STONEGATE FARMS
  • Driving Directions: From Route 40, Turn right onto Old Camp Lane, turn left onto Andover Lane, left onto Longford Drive, driveway is on the left.
  • City Limits: Yes

School Information

  • School District: Frederick County Public Schools
  • Elementary School: Waverley
  • Middle School: Crestwood
  • High School: Governor Thomas Johnson

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central A/C, Ceiling Fan(s)
  • Cooling Fuel: Electric
  • Heating Type: Heat Pump(s)
  • Heating Fuel: Electric
  • Water Heater: Electric

Utilities

  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Split Foyer
  • Structure Type: Detached
  • Construction: Vinyl Siding
  • Basement: Yes
  • Basement Entrance: Yes
  • Basement Desc.: Connecting Stairway, Fully Finished, Heated, Interior Access, Outside Entrance, Windows
  • Foundation: Permanent
  • Stories Description: Lower 1, Main
  • Square Feet: 1,514
  • Sq. Ft. Source: Assessor
  • Living Area: 1,514 Sq. Ft.
  • Finished Above Grnd: 814 Sq. Ft.
  • Finished Below Grnd: 700 Sq. Ft.
  • Year Built: 1987
  • Year Built Source: Assessor

Unit Information

Unit 1

  • Bathrooms-Lower: 1
  • Bedrooms-Lower: 1

Lot Features

  • Lot Size (Acres): 0.18
  • Lot Size (Sq. Ft.): 8,019
  • Lot Size Source: Assessor
  • Zoning: R8

Financial Considerations

  • Price Per Sq. Ft.: $442.26
  • Assessment Year: 2025
  • City/TownTax: $2,090
  • City/TownTax Freq: Annually
  • County Tax: $3,318
  • County Tax Freq: Annually
  • Tax w/Assessment: $296,300
  • Tax Amount: $5,409
  • Tax Year: 2025
  • Tax Total Finished Sq. Ft.: 1514

Disclosures and Reports

  • Ownership: Fee Simple
  • Section: 4
  • Lot Number: 166

Listed by Long & Foster Real Estate, Inc., Leah N Duncan

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 274 Longford Dr —

  • Leah N Duncan

    Long & Foster Real Estate, Inc.

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 274 Longford Dr

School District:Frederick County Public Schools, Fort Detrick, MD
NameGradesDistance
Waverley Elementary School
201 Waverley Drive, Frederick, MD 21702
K-50.2 mi
Crestwood Middle School, Frederick, MD
7100 Foxcroft Drive, Frederick, MD 21703
6-83.3 mi
Gov. Thomas Johnson High School
1501 North Market Street, Frederick, MD 21701
9-123.2 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 274 Longford Dr Get Price Alerts and Save Property

Date
Details
Price
Change
Source
1/14/2026
Listed
$359,999
224.32%
MLS
7/20/1998
Sold
$111,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 274 Longford Dr

Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,406
12%
$296,300
12%
2023
$3,922
—
$265,033
13%
2023
$3,922
6%
$233,767
15%
2022
$3,715
8%
$202,500
4%
2020
$3,455
1%
$195,533
4%
2021
$3,424
4%
$188,567
4%
2020
$3,299
2%
$181,600
3%
2019
$3,231
4%
$176,200
3%
2018
$3,104
3%
$170,800
3%
2017
$3,004
—
$165,400
1%
2016
$3,000
1%
$163,900
1%
2015
$2,965
1%
$162,400
1%
2014
$2,949
—
$160,900
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 274 Longford Dr

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Long & Foster Real Estate, Inc., Leah N Duncan

Similar Properties near 274 Longford Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

11936 Comanche Dr, Smithsburg, MD 21783 - Photo 1
$358,900
Open House

11936 Comanche Dr  Smithsburg, MD 21783

  • Single Family
  • Active
  • Updated 8 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,542
    Sq. Ft.
Listed by RE/MAX Results, Elizabeth MacLaren
12829 Bradbury Ave, Smithsburg, MD 21783 - Photo 1 Price Reduced
-$15,000 (-4.11%)
$350,000

12829 Bradbury Ave  Smithsburg, MD 21783

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,762
    Sq. Ft.
Listed by Redfin Corp, Caron S Prideaux

Just Listed near 274 Longford Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

24744 Raven Rock Rd, Smithsburg, MD 21783 - Photo 1 Just Listed
$499,900

24744 Raven Rock Rd  Smithsburg, MD 21783

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 3,344
    Sq. Ft.
Listed by Mackintosh , Inc., Randall E Wagner and Mackintosh , Inc., Christy L Hemshrodt
24607 Hells Delight Rd, Smithsburg, MD 21783 - Photo 1 Just Listed
$429,900

24607 Hells Delight Rd  Smithsburg, MD 21783

  • Single Family
  • Active
  • Updated 17 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 3,480
    Sq. Ft.
Listed by Fathom Realty MD, LLC, William J Campbell
12103 Itnyre Rd, Smithsburg, MD 21783 - Photo 1 Just Listed
$249,000
Open House

12103 Itnyre Rd  Smithsburg, MD 21783

  • Single Family
  • Active
  • Updated 10 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,256
    Sq. Ft.
Listed by Hurley Real Estate & Auctions, Kaleb M Hurley
30 Georgetown Rd, Walkersville, MD 21793 - Photo 1 Just Listed
$399,900
Open House

30 Georgetown Rd  Walkersville, MD 21793

  • Single Family
  • Active
  • Updated 17 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,240
    Sq. Ft.
Listed by RE/MAX Results, Sue P Collins

Price Reduced near 274 Longford Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

12829 Bradbury Ave, Smithsburg, MD 21783 - Photo 1 Price Reduced
-$15,000 (-4.11%)
$350,000

12829 Bradbury Ave  Smithsburg, MD 21783

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,762
    Sq. Ft.
Listed by Redfin Corp, Caron S Prideaux
2318 Persimmon Dr, Ijamsville, MD 21754 - Photo 1 Price Reduced
-$15,000 (-2.61%)
$560,000
Open House

2318 Persimmon Dr  Ijamsville, MD 21754

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,728
    Sq. Ft.
Listed by Rebecca Lewis (240) 603-8418
8109 Old Hagerstown Rd, Middletown, MD 21769 - Photo 1 Price Reduced
-$4,100 (-0.91%)
$444,900

8109 Old Hagerstown Rd  Middletown, MD 21769

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,628
    Sq. Ft.
Listed by Hyatt & Company Real Estate LLC, Robert P. Frey
1936 Old National Pike, Middletown, MD 21769 - Photo 1 Price Reduced
-$36,000 (-7.74%)
$429,000

1936 Old National Pike  Middletown, MD 21769

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 2
    Total Baths
  • 4,236
    Sq. Ft.
Listed by Mackintosh, Inc., Ellen K Keyser

Recent Sales near 274 Longford Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

267 Longford Dr, Frederick, MD 21702 - Photo 1 Sold
$325,000

267 Longford Dr  Frederick, MD 21702

  • Single Family
  • Closed
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,514
    Sq. Ft.
Listed by Long & Foster Real Estate, Inc., Ryan N Lancaster and Long & Foster Real Estate, Inc., Michael B. Carpel
Sold by Long & Foster Real Estate, Inc., Bahador Tabarzadi
167 Stonegate Dr, Frederick, MD 21702 - Photo 1 Sold
$307,000

167 Stonegate Dr  Frederick, MD 21702

  • Single Family
  • Closed
  • Updated 8 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,098
    Sq. Ft.
Listed by Marsh Realty, Robert R Marsh
Sold by Real Broker, LLC -, Troyce P Gatewood
171 Stonegate Dr, Frederick, MD 21702 - Photo 1 Sold
$320,000

171 Stonegate Dr  Frederick, MD 21702

  • Townhouse
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,278
    Sq. Ft.
Listed by Spring Hill Real Estate, LLC., Aida M Blumen
Sold by The Agency DC, Joana Gomes
116 Deerfield Pl, Frederick, MD 21702 - Photo 1 Sold
$395,000

116 Deerfield Pl  Frederick, MD 21702

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,560
    Sq. Ft.
Listed by Berkshire Hathaway HomeServices PenFed Realty, Jenna Clark
Sold by RE/MAX Excellence Realty, Jose Salvador Rivera Jr

274 Longford Drive, Frederick, MD 21702 (MLS# MDFR2075406) is a Single Family property with 3 bedrooms and 2 full bathrooms. 274 Longford Drive is currently listed for $359,999 and was received on January 14, 2026. Want to learn more about 274 Longford Drive? Do you have questions about finding other Single Family real estate for sale in Frederick? You can browse all Frederick real estate or contact a Coldwell Banker agent to request more information.

Tour this property