OFF MARKET

Off market jul 2018 for $350K

$500,341

Est. refi paymentEst. refi $2,873/mo

•

2,282

sq ft

7247 Foothill, Frederick, CO 80504

About this home

Public Remarks: Nice home with a bright and open floor plan, located in Countryside. Home features three bedrooms, three baths, vaulted ceilings, a formal living area as well as a large family room, a big, open kitchen with an eating area, a newer furnace, and a newer water heater. This home also offers room to grow in the unfinished basement and offers additional storage in the crawl space. Outside there is a large stamped concrete patio, and a fully fenced yard for entertaining. Come take a look!

Single-familyProperty Type

2004Year Built

6,875 sq ftLot Size

$219Est. Price/Sq.Ft.

2 car garageParking

Listed by • Assist2Sell Smart Choice Rlty

Contact: 3036593343

Bought with Non-IRES Agent • Non-IRES

•970-593-9002 (broker)

Redfin checked: 2 minutes ago

•Source:IRES as Distributed by MLS Grid #851806

Redfin Estimate

$500,341

$150K since sold in July 2018$1,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 3% higher than the average sale price ($486K) of 6 comparable homes.

SOLD APR 10, 2026
$515,000
A
3 beds3 baths2,120 sq ft
5860 Canyon Cir, Frederick, CO 80504
Listing provided by metrolistCO
SOLD JUL 10, 2026
$519,500
B
3 beds2.5 baths1,934 sq ft
7472 Skyline Way, Frederick, CO 80504
SOLD AUG 3, 2026
$460,000
C
3 beds2.5 baths1,849 sq ft
7399 Russell Cir, Frederick, CO 80504
SOLD SEP 10, 2026
$525,000
D
3 beds3 baths1,975 sq ft
826 Catalpa St, Frederick, CO 80530
Listing provided by metrolistCO
SOLD SEP 21, 2026
$425,000
E
3 beds3 baths2,384 sq ft
334 4th St, Firestone, CO 80520
Listing provided by metrolistCO
SOLD SEP 14, 2026
$470,000
F
3 beds3 baths1,808 sq ft
7400 Russell Cir, Frederick, CO 80504
Listing provided by metrolistCO

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$237,537

Est. take-home

List your home with Redfin and save $5,003

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,772/mo

Redfin rental estimate

List your home for rent

Market trends in 80504, CO

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

98.9%

0.3% MoM

Median sale price

$580K

$5K MoM

Avg. days on market

50d

1 days MoM

Recently sold homes

239

16 MoM

New listings for sale

COMING SOON
$525,000
5 beds4 baths2,804 sq ft
6447 St Vrain Ranch Blvd, Firestone, CO 80504
Maytal Hess • Colorado Realty Network Inc.
$529,000
3 beds2 baths3,284 sq ft
9038 Shenandoah Ave, Frederick, CO 80504
$145,000
3 beds— baths1,512 sq ft
11475 Jackson St #92, Longmont, CO 80504
Erica Fong-Mancha • RE/MAX Elevate
$145,000
3 beds2 baths1,512 sq ft
11475 Jackson St, Longmont, CO 80504
COMING SOON
$549,000
3 beds3 baths2,053 sq ft
5793 Farmstead Pl, Mead, CO 80504
Devan Bonilla-Lopez • Realty Of America LLC
3D WALKTHROUGH
$644,900
4 beds3 baths3,394 sq ft
10398 Stagecoach Ave, Firestone, CO 80504
Rob Kittle • Kittle Real Estate
$580,000
4 beds3 baths2,208 sq ft
701 Eldora Pl, Longmont, CO 80504
Tara Jones • Opendoor Brokerage LLC
OPEN SUN, 10AM TO 12PM
$117,000
3 beds2 baths1,056 sq ft
11051 Yellowstone, Longmont, CO 80504
Yulissa Moreno • Realty Of America LLC
COMING SOON
$295,000
3 beds2 baths1,252 sq ft
804 Summer Hawk Dr #10101, Longmont, CO 80504
$469,000
3 beds2 baths2,552 sq ft
5414 Wolf St, Frederick, CO 80504
See all

Provided by Redfin

Sale history for 7247 Foothill

Date

Event

Price

IRES as Distributed by MLS Grid #851806

Jul 9, 2018

Sold

$350,000

$153/sq ft

Jun 12, 2018

Pending

—

May 31, 2018

Listed

$355,000

$156/sq ft

REColorado as Distributed by MLS Grid #5955720

May 31, 2018

Listed

$355,000

$156/sq ft

IRES as Distributed by MLS Grid #438594

Feb 24, 2005

Sold

$218,373

$96/sq ft

Jan 29, 2005

Listed

$252,373

$111/sq ft

Public Remarks

NEW HOME READY FOR OCCUPANCY. GREAT INCENTIVE PACKAGES - CALL FOR DETAILS. LAUNDRY ROOM OFF GARAGE. PARTIAL, UNFINISHED BASEMENT. STEP DOWN TO GREAT ROOM. VAULTED CEILING IN KITCHEN. AIR CONDITIONING. STOVE, DISHWASHER, MICROWAVE, REFRIGERATOR, WASHER, DRYER ARE ALL INCLUDED. GRANITE COUNTER TOP. SMALL TOWN LIVING WITH EASY COMMUTE TO DENVER, BOULDER, LONGMONT, LOVELAND, DIA

Year

Property tax

Land + Additions

Assessment*

2025

$3,296 (+13.4%)

$7,500 + $21,940

$29,440

2024

$2,907 (+4.3%)

$7,500 + $21,940

$29,440

2023

$2,789 (+8.0%)

$6,700 + $24,910

$31,610

2022

$2,583 (−1.0%)

$5,210 + $19,540

$24,750

2021

$2,609 (+9.1%)

$5,210 + $19,540

$24,750

2020

$2,392 (−1.4%)

$5,360 + $20,110

$25,470

2019

$2,427 (+22.0%)

$3,720 + $19,820

$23,540

2018

$1,989 (−2.2%)

$3,720 + $19,820

$23,540

2017

$2,033 (+7.3%)

$3,740 + $16,280

$20,020

2016

$1,895 (+37.3%)

$3,740 + $16,280

$20,020

2014

$1,380 (−1.0%)

$2,870 + $15,500

$18,370

2013

$1,394 (−9.5%)

$2,230 + $11,580

$13,810

2012

$1,540 (+6.1%)

$3,580 + $11,720

$15,300

2011

$1,452 (+0.6%)

$3,580 + $11,720

$15,300

2010

$1,443 (+1.4%)

$3,580 + $11,720

$15,300

2009

$1,423

$3,580 + $11,720

$15,300

Tax history for 7247 Foothill

Year

Property tax

Land + Additions

Assessment*

2025

$3,296 (+13.4%)

$7,500 + $21,940

$29,440

2024

$2,907 (+4.3%)

$7,500 + $21,940

$29,440

2023

$2,789 (+8.0%)

$6,700 + $24,910

$31,610

2022

$2,583 (−1.0%)

$5,210 + $19,540

$24,750

2021

$2,609 (+9.1%)

$5,210 + $19,540

$24,750

2020

$2,392 (−1.4%)

$5,360 + $20,110

$25,470

2019

$2,427 (+22.0%)

$3,720 + $19,820

$23,540

2018

$1,989 (−2.2%)

$3,720 + $19,820

$23,540

2017

$2,033 (+7.3%)

$3,740 + $16,280

$20,020

2016

$1,895 (+37.3%)

$3,740 + $16,280

$20,020

2014

$1,380 (−1.0%)

$2,870 + $15,500

$18,370

2013

$1,394 (−9.5%)

$2,230 + $11,580

$13,810

2012

$1,540 (+6.1%)

$3,580 + $11,720

$15,300

2011

$1,452 (+0.6%)

$3,580 + $11,720

$15,300

2010

$1,443 (+1.4%)

$3,580 + $11,720

$15,300

2009

$1,423

$3,580 + $11,720

$15,300

*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

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

6,875

Year renovated

2022

Sq. Ft.

2,282

Year built

2004

Style

Single Family Residential

County

Weld County

APN

R1330402

Parking Spaces

Basement

Yes

Accessible

HOA Dues

$24 /month

Garage

Yes

Features

—

Last updated by owner on Nov 22, 2022.

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

Aug 19, 2026 • Final

Residential roofing

Remove and replace the roof on a residential building using GAF shingles.

Roofing

Mar 24, 2022 • Final

Residential mechanical

Replace the furnace.

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.

Property details

Parking

Parking Features
Covered Spaces: 2
Garage: Yes
Attached Garage: Yes
Garage Spaces: 2
Parking Features: Garage Door Opener

Interior

Bathroom Information
Bathrooms (Full): 2
Bathrooms (Half): 1
Bathrooms (Three Quarter): 0

Bedroom Information
Bedrooms Total: 3

Heating & Cooling
Cooling: Yes
Central Air, Ceiling Fan(s)
Heating: Yes
Forced Air

Interior Features
Electric Range/Oven, Dishwasher, Refrigerator, Microwave, Disposal
Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s)
Laundry Features: Washer/Dryer Hookups, Lower Level

Room Information
Basement: Partial, Unfinished

Exterior

Exterior Features
Fencing: Fenced
Patio and Porch Features: Patio
Roof: Composition

Land Information
Road Surface Type: Paved, Asphalt

Lot Information
Horse(s): No
Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System
Road Frontage Type: City Street
Zoning: SFR

Property Information
Property Type: Residential
Waterfront: No

Subdivision Information
Subdivision Name: Countryside
MLS Area Major: Greeley/Weld

Building Information
Above Grade Finished Area: 1742
Below Grade Finished Area: 540
Building Area Total: 1742
Construction Materials: Wood/Frame

Financial

Tax Information
Parcel Number: R1330402
Tax Annual Amount: 2033
Tax Year: 2017

Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan

Utilities

Utility Information
Utilities: Natural Gas Available
Gas: Natural Gas

Location

HOA Information
Association: Yes
Association Fee: 19
Association Fee Frequency: Monthly
Association Fee Includes: Common Amenities
Community Features: 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
Unparsed Address: 7247 Foothill Frederick CO 80504
Street Number: 7247
Street Name: Foothill
City: Frederick
State or Province: CO
County or Parish: Weld
Country: US
Postal Code: 80504
Coordinates: -104.95011,40.10634
Latitude: 40.10634
Longitude: -104.95011

Public facts

Beds: 5
Baths: 3.5
Sq. Ft.: 2,282
Stories: 2.0
Parking Spaces: 2
Basement: Yes
Accessible: No
Lot Size: 6,875 square feet
Style: Single Family Residential
Year Built: 2004
Year Renovated: 2022
County: Weld County
APN: R1330402
HOA Dues: $24/month
Garage: Yes
Features: —

Home facts updated by owner on Nov 22, 2022

Other

Miscellaneous Information
Exclusions: Mounted TVs and mounts, washer and dryer.

Listing Information
Attribution Contact: 3036593343
Close Price: $350,000
Photos Count: 15
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed

Listing Date Information
Close Date: Monday, July 9, 2018
Cumulative Days on Market: 13
Days on Market: 13
Listing Contract Date: Thursday, May 31, 2018
Modification Timestamp: Tuesday, July 30, 2024 7:09 PM

Home Information
Levels: Tri-Level
Window Features: Window Coverings
Year Built: 2004

Around this home

Schools

Legacy Elementary School

Public PreK-5 • Assigned • 1.0mi

5/10

Coal Ridge Middle School

Public 6-8 • Assigned • 3.5mi

6/10

Frederick Senior High School

Public 9-12 • Assigned • 0.4mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Local insights from Redfin agents

A vibrant northern Colorado community known for its scenic mountain views, extensive parks and trails, greenways, and a mix of established neighborhoods and newer housing options.
2 months ago • Longmont
Brent Sena
Redfin agent
125 deals
Was this helpful?

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)

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

$477,000 – $577,000

Reach more buyers when you sell with Redfin. Save up to $5,003 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$1,120,000

5 beds5 baths4,199 sq ft

7988 Wisdom Ct, Frederick, CO 80530

Mark Peters • A+ Property

NEW CONSTRUCTION3D WALKTHROUGH

$529,990

3 beds2.5 baths2,253 sq ft

7329 Arkansas St, Frederick, CO 80530

$305,000

3 beds2 baths1,440 sq ft

6130 Mallow, Frederick, CO 80530

Norma Rivera • Brokers Guild Real Estate

$435,000

5 beds4 baths2,646 sq ft

676 Mcclure Ave, Firestone, CO 80520

Richard A. Lupinetti • Real Metro Realty

$587,000

3 beds3 baths3,568 sq ft

177 3rd St, Firestone, CO 80520

3D WALKTHROUGH

$575,000

5 beds3 baths2,019 sq ft

306 Hawthorn St, Frederick, CO 80530

New listings for sale in 80504

COMING SOON

$525,000

5 beds4 baths2,804 sq ft

6447 St Vrain Ranch Blvd, Firestone, CO 80504

Listing provided by REColorado as Distributed by MLS Grid

$529,000

3 beds2 baths3,284 sq ft

9038 Shenandoah Ave, Frederick, CO 80504

$145,000

3 beds— baths1,512 sq ft

11475 Jackson St #92, Longmont, CO 80504

Listing provided by REColorado as Distributed by MLS Grid

$145,000

3 beds2 baths1,512 sq ft

11475 Jackson St, Longmont, CO 80504

COMING SOON

$549,000

3 beds3 baths2,053 sq ft

5793 Farmstead Pl, Mead, CO 80504

Listing provided by REColorado as Distributed by MLS Grid

3D WALKTHROUGH

$644,900

4 beds3 baths3,394 sq ft

10398 Stagecoach Ave, Firestone, CO 80504

Listing provided by REColorado as Distributed by MLS Grid

$580,000

4 beds3 baths2,208 sq ft

701 Eldora Pl, Longmont, CO 80504

Listing provided by REColorado as Distributed by MLS Grid

OPEN SUN, 10AM TO 12PM

$117,000

3 beds2 baths1,056 sq ft

11051 Yellowstone, Longmont, CO 80504

Listing provided by REColorado as Distributed by MLS Grid

COMING SOON

$295,000

3 beds2 baths1,252 sq ft

804 Summer Hawk Dr #10101, Longmont, CO 80504

Home values near 7247 Foothill

Data from public records.

Address	Redfin Estimate
7240 Foothill Street, Frederick, CO 3 Beds \| 2.5 Baths \| 3038 Sq. Ft.	$566,537
7238 Foothill Street, Frederick, CO 3 Beds \| 2 Baths \| 2208 Sq. Ft.	$489,293

Address	Redfin Estimate
7242 Foothill Street, Frederick, CO 2 Beds \| 3 Baths \| 1652 Sq. Ft.	$463,523
7244 Foothill Street, Frederick, CO 3 Beds \| 2 Baths \| 1464 Sq. Ft.	$498,687

Address	Redfin Estimate
7236 Foothill Street, Frederick, CO 5 Beds \| 4 Baths \| 3050 Sq. Ft.	$557,296
7246 Foothill Street, Frederick, CO 3 Beds \| 3 Baths \| 1935 Sq. Ft.	$519,431

Property information provided by IRES as Distributed by MLS Grid when last listed in 2018. This data may not show owner updates. Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

80504 homes for sale
80621 homes for sale
80530 homes for sale
80514 homes for sale
80516 homes for sale

Eagle Crest homes for sale
Idaho Creek homes for sale
Prairie Greens homes for sale
Glens of Dacono homes for sale
Wyndham Hill homes for sale

Houses for rent in Frederick	Agents near me	Fort Collins, CO homes for sale	Frederick Housing Market
Houses for sale near me	Denver, CO homes for sale	Aurora, CO homes for sale
Land for sale near me	Colorado Springs, CO homes for sale	Arvada, CO homes for sale
Open Houses near me	Boulder, CO homes for sale	Frederick Property Records
Condos for sale near me	Littleton, CO homes for sale	CO New Listings

Denver homes for sale
Boulder homes for sale
Arvada homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 80504, CO

Sale history for 7247 Foothill

Tax history for 7247 Foothill

Public record

Property details

Around this home

Schools

Lifestyle

Local insights from Redfin agents

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 80504

Home values near 7247 Foothill

More real estate resources