Public Remarks: This beautiful home located just walking distance from the charming, historic downtown Frederick it perfect for a family looking for a great location and lots of space. The numerous upgrades make it an easy, move in ready home; from the beautiful wood floors, and updated appliances. The beautiful vaulted ceilings, pre-wired speaker systems, open floor plan, home theater and no maintenance deck makes for a perfect home for entertaining.
Quick commutes to downtown Denver&DIA, walk to great eateries, park & Frederick HS. Upgrades galore-beautiful wood flooring throughout main level, slab granite, fantastic appliances, plantation shutters, power shades, interior walls of all bedrooms insulated for sound, Nest thermostat, finished basement with great theater room, bed and bath, no maintenance deck, Rachio irrigation controls, cement fiber siding, extra hose spigot in garage. Play structure in backyard included.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
4
Baths
4
Stories
2
Lot width
—
Lot depth
—
Lot size
6,875 Sq. Ft.
Year renovated
—
Sq. Ft.
2,629
Year built
2004
Style
Single Family Residential
County
Weld County
APN
R1329902
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 31, 2026.
R-1
Residential Low Density District
This is a low-density housing district intended primarily for single-family uses on individual lots. This zone is characterized by tree-lined local streets, interconnected pedestrian circulation system and proximity to schools and parks.
Permitted uses
Include but are not limited to:
Housing-Single unit
Educational/school
Communications tower
Park & open space
Apr 17, 2026 • Active
Residential mechanical
Replace the existing air conditioning system with a new air conditioning system.
HVAC
Sep 27, 2022 • Final
Residential mechanical
Replace the existing furnace with a new unit.
HVAC
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Study Area, Satellite Avail, High Speed Internet, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s)
Laundry Features: Washer/Dryer Hookups, Main Level
Room Information
Basement: Sump Pump
Exterior
Exterior Features
Lighting
Fencing: Fenced, Wood
Patio and Porch Features: Deck
Roof: Composition
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System
Road Frontage Type: City Street
Zoning: RES
Property Information
Property Type: Residential
Waterfront: No
Subdivision Information
Subdivision Name: Countryside
MLS Area Major: Greeley/Weld
Building Information
Above Grade Finished Area: 1935
Below Grade Finished Area: 742
Building Area Total: 1935
Construction Materials: Wood/Frame, Wood Siding, Painted/Stained
Financial
Tax Information
Parcel Number: R1329902
Tax Annual Amount: 2338
Tax Year: 2016
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric
Gas: Natural Gas
Sewer: District Sewer
Location
HOA Information
Association: Yes
Association Fee: 58
Association Fee Frequency: Quarterly
Association Fee Includes: Common Amenities
Community Features: Playground, Park
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Legacy
Middle or Junior School: Coal Ridge
High School: Frederick
Location Information
Directions: From I-25 take Hwy 52 East 2.1 miles to Colorado Blvd, go North 1 mile to Tipple Pkwy, go East .4 mile to Russel Dr, go North .2 mile and turn left onto Prairie Cir, turn right onto Foothill.
Unparsed Address: 7237 Foothill St Frederick CO 80504
Street Number: 7237
Street Name: Foothill
Street Suffix: St
City: Frederick
State or Province: CO
County or Parish: Weld
Country: US
Postal Code: 80504
Coordinates: -104.95011,40.10558
Latitude: 40.10558
Longitude: -104.95011
Public facts
Beds: 4
Baths: 4.0
Sq. Ft.: 2,629
Stories: 2.0
Lot Size: 6,875 square feet
Style: Single Family Residential
Year Built: 2004
Year Renovated: —
County: Weld County
APN: R1329902
Home facts updated by county records on Aug 31, 2026
Other
Miscellaneous Information
Exclusions: Sellers personal property & projector in basemen. Seller is willing to negotiate projector.
Listing Information
Attribution Contact: 3038157896
Close Price: $378,000
Photos Count: 33
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Wednesday, February 28, 2018
Cumulative Days on Market: 14
Days on Market: 14
Listing Contract Date: Monday, January 8, 2018
Modification Timestamp: Tuesday, July 30, 2024 1:45 PM
Home Information
Levels: Two
Window Features: Window Coverings, Double Pane Windows
Year Built: 2004
Green Information
Green Energy Efficient: Thermostat
Around this home
Schools
Legacy Elementary School
Public PreK-5 • Assigned • 1.1mi
5/10
Coal Ridge Middle School
Public 6-8 • Assigned • 3.5mi
6/10
Frederick Senior High School
Public 9-12 • Assigned • 0.3mi
8/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
2/10 Fire Factor
0.00% chance of being in a wildfire in next 30 years
4/10 Heat Factor
7 days above 93° expected this year, 17 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
5/10 Air Factor
8 unhealthy days expected this year, 9 days in 30 years
Provided by First Street
Historical weather
Frederick, CO • 80504
Average low and high temperatures (°F)
42
16
52
23
65
36
65
37
72
46
85
55
92
61
87
57
79
50
69
41
55
29
53
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.5 hours in
June and 6 hours in December, placing it above the
U.S. average for solar exposure.
10.5 hrs
6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$530,000 – $641,000
Reach more buyers when you sell with Redfin. Save up to $5,570 in fees.3 minutes to get started.