About Home value Property history Tax history Market statistics Schools Neighborhood Places of interest

245 Mayfly Ln, Berthoud, CO 80513

$508,000

Last sold 06/20/2025 for $509K

3
bed
3
bath
1,848
Sqft ($276/Sqft)

House not for sale

About 245 Mayfly Ln

Property type House

Year built 2023

HOA fee $90/month

Lot size 2,700 Sqft

Movoto estimate

Parking 2 garage spaces

Property description

Popular home with thoughtful, spacious floor plan at Fickel Farms! Open Kitchen and Great Room design boasts upgraded kitchen package, with stainless steel appliances and granite countertops. Gas Stove, Fridge, Dish Washer and Microwave included. Relax with morning coffee on the large, covered Patio and 6’ high privacy fence. Energy Efficient Features, Tech Package, Lighting package, Unfinished Basement and Two Car Garage standard. Enjoy game night with the family upstairs in the loft area. 3 Bedrooms, 2.5 Baths and several linen closets are included for storage. The Covered Front patio is sunny and charming with a picket fence opening to a Green Belt. Walk down Fickel Farm Trail to enjoy Pioneer Park, future pool and Clubhouse. Close to Old Town Berthoud! Photos are representative only and are not of the actual home. Actual finishes, elevation, and features may vary

Listed by

Listing Agent - Kerrie Young

Listing Office - Kerrie A. Young (Independent)

Source: REcolorado MLS

MLS#8365095 • last updated 1 year ago

Movoto checked REcolorado MLS for data 12 minutes ago

Overview
Cooling/AC	Central Air
Heating	Forced Air, Natural Gas
Levels/Style	Two, Contemporary, Duplex
SubType	Single Family Residence
Type	Residential
MLS #	8365095
SqFt	1848
Status	Closed
Lot Size (SqFt)	2700
Property Tax	2876
Builder Name	Meritage Homes
Year Built	2023
HOA	Advance HOA, 303-482-2213
HOA Fee	Monthly, 90
Condition	New Construction

Interior
Total # of Bathrooms	3
# of Full Baths	2
# of Half Baths	1
Total # of Bedrooms	3
Laundry	In Unit
Flooring	Carpet, Tile, Vinyl
Interior Features	Butcher Counters, Eat-in Kitchen, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Smart Thermostat, Walk-In Closet(s), Wired For Data

Exterior
Exterior	Lighting, Rain Gutters
Construction	Cement Siding, Frame, Other
Roof	Composition
Fencing	Partial
Foundation	Slab
Parking Desc	Concrete, Dry Walled, Insulated Garage
# Parking Spaces	2
# of Garage Spaces	2
Patio/Porch	Front Porch
Lot Features	Landscaped

Amenities / Utilities
Water Source	Public
HOA Fees Include	Maintenance Grounds, Snow Removal

Location
County	Larimer
Subdivision	Fickel Farms
Elem School	Ivy Stockwell
High School	Berthoud
Middle School	Turner
Elementary School District	Thompson R2-J
Middle School District	Thompson R2-J
High School District	Thompson R2-J
APN	R1679025
Zoning	RES
Directions	From I25 Head West On Highway 56 (County Rd 8) Towards Berthoud Aprox 5 Miles Then Take A Left On Pyramid Street. Take A Right On East 4th St To The Models.

Lot/ Land Details
Current Use	Live/Work
Road Frontage	Public
Road Responsibility	Public Maintained Road
Road Surface	Paved

$508K

Range: $477K-$538K

Last 30 days

Lower your payment with the loan terms that fit you.

Jun 2025
Public Records
Jun 24, 2025 Sold
$509,990
Jun 2025
MLS # 8365095
Jun 21, 2025 Sold
$509,990
Jun 20, 2025 Sold
$509,990 (+4.1%)
May 13, 2025 Pending
—
Apr 10, 2025 Listed
$489,990 (-6.3%)
Apr 10, 2025 Listed
$522,990
May 2025
MLS # uw5u2ax1y5
May 9, 2025 Closeout
—
Apr 24, 2025 Listed
$489,990

Year Property taxes Tax assessment
2025
$3,168 +39.4%

$31,307 +32.48%
2024
$2,272 +3.7%

$23,631
2023
$2,192 +208631.4%

$23,631 +214727.27%
2022
$1

$11

245 Mayfly Ln
$509K
—
80513
$629K -12% y/y
Berthoud
$629K -12% y/y

No chart available

Statistics calculated by Movoto

	Est. value	Bed/bath	Sqft	mi
321 Fickel Farm Trl, Berthoud, CO 80513	$465,000	3/3	1,400	0.06
311 Fickel Farm Trl, Berthoud, CO 80513	$462,000	3/3	1,377	0.06
329 Fickel Farm Trl, Berthoud, CO 80513	$472,000	3/3	1,451	0.07
309 Fickel Farm Trl, Berthoud, CO 80513	$466,000	3/3	1,409	0.07
339 Fickel Farm Trl, Berthoud, CO 80513	$478,000	3/3	1,400	0.07
349 Fickel Farm Trl, Berthoud, CO 80513	$461,000	3/3	1,377	0.07
249 E 4th St, Berthoud, CO 80513	$525,000	3/2	—	0.08
357 Fickel Farm Trl, Berthoud, CO 80513	$430,000	2/1	—	0.08

Estimated values are based on public record data and automated valuation models. Values are not guaranteed and may not reflect current market conditions.