Register Now
Already registered? Login

Sign in to take advantage of all this site has to offer. Save your favorite listings and searches – also receive email updates when listings you like come on the market for free!
*Contact Information is NOT Shared*

The Brown Family Team

The Brown Family Team
Real Estate Teams, LLC
50 Citizens Way Ste 400
Frederick, MD 

Office: 301-695-3020
Direct: 301-644-2777
Cell: 301-748-3802

Email Us

Quick Search

view all



No Min.

No Max.
Back to Saved Search
Listing 7 out of 431
$1,245,000 For Sale

304 Upper College Terrace
Frederick, MD 21701

5 beds, 3 full, 2 partial baths | Single Family Home
5,859 sq ft; lot: 16117 sq ft lot - MLS# MDFR252900
Property Photo


This stately home is located on one of the best streets in the charming Baker Park neighborhood. The street is a short walk to historic downtown Frederick~s shops and restaurants. Enjoy summer concerts and fantastic walking paths in Baker Park, which is located just steps away. Constructed in 1937, the approximately 6000 square foot home was renovated in 2014 to suit modern standards while retaining its historic charm. In addition to all new plumbing and electric, the home was modernized with a central vacuum system, Fujitsu mini-split HVAC, natural gas boiler, and a new hot water heater. The kitchen was completely renovated with new cabinetry, soapstone counters, a french blue Lacanche range, and heated floors in the banquette dining area. The spacious living room has a natural gas fireplace and access to the side porch. The formal dining room features the home~s original chandelier. There is a half-bath on the first floor and an office with original built-in cabinets.Upstairs is an impressive master suite with a private porch, walk-in closet, bedroom, and a sitting room with a natural gas fireplace. The master bathroom is tiled in marble with soapstone counters and a steam shower. A laundry room was added to the second floor. There are an additional 4 large bedrooms and two full baths on the second and third floors. The basement has a large, finished recreation room with a working wood fireplace, a quarter bath, the original laundry area, and plenty of unfinished storage space.Enjoy the beautiful backyard from a new flagstone patio. An invisible fence and an irrigation system were recently added. The backyard has a custom Amish-built storage shed, a custom playhouse, and a recently paved driveway with parking for up to 6 vehicles.


  • Property Type: Single Family Home
  • Sub Type: Detached
  • Listing Status: Active
  • County/Area: Frederick County
  • Zip Code: 21701
  • Year Built: 1937
  • Subdivision/Neighborhood: Baker Park
  • School District: Frederick County Public Schools
  • Elementary School: Parkway
  • Middle School: West Frederick
  • High School: Frederick
  • Sq.Ft.: 5,859 sq ft
  • Style: Federal
  • Stories: 3+ Story
  • Bedrooms: 5
  • Full Baths: 3
  • Half Baths: 2
  • Basement: See Basement Details
  • Fireplace: Gas/Propane, 3
  • Lot Size: 16117 sq ft lot
  • Baths: 5
  • Pool or Spa: Yes - Community
  • View: Garden/Lawn, Street
  • Zoning: R6
  • Above Grade Fin SQFT: 3,956
  • Above Grade Fin SQFT Source: Estimated
  • Above Grade Finished Area Units: Square Feet
  • Appliances: Central Vacuum, Dryer - Front Loading, Extra Refrigerator/Freezer, Freezer, Microwave, Oven/Range - Gas, Washer
  • Basement Details: Yes, Full, Heated, Improved, Interior Access, Partially Finished, Poured Concrete, Sump Pump, Windows
  • Basement Footprint Percent: 100.00
  • Bathrooms Count All Lower Levels: 1
  • Bathrooms Count All Upper Levels: 3
  • Bathrooms Count Lower Level 1: 1.00
  • Bathrooms Count Main Level: 1
  • Bathrooms Count Upper Level 1: 2.00
  • Bathrooms Count Upper Level 2: 1.00
  • Bathrooms Full All Upper Levels: 3
  • Bathrooms Full Upper Level 1: 2
  • Bathrooms Full Upper Level 2: 1
  • Bathrooms Half All Lower Levels: 1
  • Bathrooms Half Lower Level 1: 1
  • Bathrooms Half Main Level: 1
  • Bedrooms Count All Upper Levels: 5
  • Bedrooms Count Upper Level 1: 3
  • Bedrooms Count Upper Level 2: 2
  • Below Grade Fin SQFT: 438
  • Below Grade Fin SQFT Source: Estimated
  • Below Grade Finished Area Units: Square Feet
  • Below Grade Unfin Area Units: Square Feet
  • Below Grade Unfin SQFT: 1,465
  • Below Grade Unfin SQFT Source: Estimated
  • Building Level Count: 4
  • Central Air Y/N: Yes
  • Community Pool Features: Fenced, Filtered, In Ground
  • Construction Materials: Batts Insulation, Block, Brick, Cement Siding, Copper Plumbing, CPVC/PVC, Glass, HardiPlank Type, Mixed Plumbing, Stick Built
  • Cooling: Electric
  • Cooling Type: Attic Fan, Ceiling Fan(s), Central A/C, Energy Star Cooling System, Heat Pump(s), Programmable Thermostat, Zoned
  • Directions: From Washington DC: Take I-270 North, continue on US-15 North. Take Exit 14 Rosemont Avenue. Turn left at the light at end of the exit. Continue on Rosemont Avenue .6 miles and turn right on Upper College Terrace. House is located on the left side of the street
  • Door Features: Six Panel
  • Electric Service: 120/240V, 200+ Amp Service, Circuit Breakers
  • Entry Floor Number: 1
  • Exterior Features: Flood Lights, Lawn Sprinkler, Outbuilding(s), Secure Storage, Sidewalks, Street Lights, Underground Lawn Sprinkler
  • Fencing: Invisible
  • Flooring Type: Carpet, Hardwood, Heated, Marble, Wood
  • Foundation Details: Concrete Perimeter
  • Heating: Natural Gas, Central, Electric
  • Heating Type: Central, Energy Star Heating System, Heat Pump(s), Hot Water, Programmable Thermostat, Radiant, Radiator, Zoned
  • Heating Y/N: Yes
  • Hot Water: Electric, Multi-tank, Natural Gas
  • Improvements: Above Grade, Below Grade
  • Interior Features: Ceiling Fan(s), Central Vacuum, Floor Plan - Traditional, Formal/Separate Dining Room, Kitchen - Eat-In, Kitchen - Gourmet, Master Bath(s), Recessed Lighting, Upgraded Countertops, Wood Floors
  • Land Use Code: 010
  • Laundry Type: Basement, Dryer In Unit, Has Laundry, Upper Floor
  • Location Type: Downtown
  • Lot Features: Front Yard, Landscaping, Rear Yard
  • Lot SQFT: 16,082
  • Lot Size Source: Plat Map/Survey
  • Lot Size Units: Square Feet
  • Main Entrance Orientation: West
  • Municipality: Frederick City
  • OtherStructuresList:Other Structures: Storage Barn/Shed, Other
  • Outdoor Living Structures: Balcony, Porch(es)
  • Ownership Interest: Fee Simple
  • Parking Features: Asphalt Driveway, Private
  • Photo Option: Lister Will Upload All
  • Property Condition: As-is Condition, Restored, Shows Well, Turn Key
  • Road Responsibility: City/County
  • Road Surface Type: Alley, Black Top, Paved
  • Roof: Slate
  • Room List: Living Room, Dining Room, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Game Room, Bedroom 1, Office, Storage Room, Bathroom 1, Bathroom 2, Bathroom 3
  • SchoolDistrictSource: Listing Agent
  • Security Features: Carbon Monoxide Detector(s), Security System, Smoke Detector
  • Sewer Septic: Public Sewer
  • Story List: Lower 1, Main, Upper 1, Upper 2
  • Tax Annual Amount: 11211.0
  • Tax Total Finished SQFT: 3,624
  • Tax Year: 2018
  • Total Below Grade SQFT: 1,903
  • Total Below Grade SQFT Source: Estimated
  • Total Finished SQFT: 4,394
  • Total Finished SQFT Source: Estimated
  • Total Garage and Parking Spaces: 6
  • Total Non-Garage Parking Spaces: 6
  • Total SQFT Source: Estimated
  • Type Of Parking: Driveway, Off Street
  • Utilities: Above Ground, Cable TV, DSL Available, Natural Gas Available, Phone
  • Wall & Ceiling Types: 9'+ Ceilings, Dry Wall, Plaster Walls
  • Water Source: Public
  • Window Features: Storm, Wood Frame
  • Year Built Source: Public Records
Courtesy of Buyself Incorporated

The Brown Family Team | Real Estate Teams, LLC
Office: 301-695-3020 | Direct: 301-644-2777 | Cell: 301-748-3802
50 Citizens Way, Suite 400 - Frederick, MD 21701
Copyright © 2017, All Rights Reserved

ABR - Accredited Buyer RepresentativeCRS - Certified Residential SpecialistEqual Housing OpportunityGRI - Graduate, REALTOR® InstituteMLS membershipREALTOR® certification

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu