$486,990
SOLD MAR 14, 2025

228 Mayfly Ln Berthoud, CO 80513

3 Beds
2.5 Baths
1,848 Sq Ft
2,700 Sq Ft Lot

Recently Sold

$264 Per Sq Ft

10 Days on Market

Highlights

  • New Construction
  • Clubhouse
  • Great Room
  • Open Floorplan
  • Contemporary Architecture
  • Quartz Countertops

About This Home

As of March 2025

Popular home with thoughtful, spacious floor plan at Fickel Farms! Open Kitchen and Great Room design boasts upgraded white kitchen package, with stainless steel appliances. 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!

***This home qualifies for a below market fixed interest rate with Meritage Homes' preferred lender for a limited time. Terms and conditions apply. See sales counselor for details!

Last Agent to Sell the Property

Kerrie Young

Kerrie A. Young (Independent) Brokerage Email: Denver.contact@meritagehomes.com License #1302165

Last Buyer's Agent

Andrea Chirich

Kentwood RE Northern Prop Llc License #100088799

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,678

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 2,700 Sq Ft Lot
  • East Facing Home
  • Partially Fenced Property
  • Landscaped

HOA Fees

  • $90 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Insulated Garage
  • Dry Walled Garage

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Stone Siding
  • Concrete Block And Stucco Construction

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wired For Data
  • Double Pane Windows
  • Great Room
  • Dining Room
  • Home Office
  • Unfinished Basement
  • Sump Pump

Kitchen

  • Eat-In Kitchen
  • Convection Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Home Security

  • Smart Thermostat
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Energy-Efficient Appliances
  • Energy-Efficient Windows
  • Energy-Efficient Construction
  • Energy-Efficient HVAC
  • Energy-Efficient Lighting
  • Energy-Efficient Insulation
  • Energy-Efficient Thermostat

Outdoor Features

  • Exterior Lighting
  • Rain Gutters
  • Front Porch

Schools

  • Ivy Stockwell Elementary School
  • Turner Middle School
  • Berthoud High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 110 Volts
  • High-Efficiency Water Heater
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R1679036

Community Details

Overview

  • Association fees include ground maintenance, snow removal
  • Advance HOA, Phone Number (303) 482-2213
  • Built by Meritage Homes
  • Fickel Farms Subdivision, Vail Floorplan

Amenities

  • Clubhouse

Recreation

  • Community Playground
  • Community Pool
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,678

Year Built

Built in 2024 | New Construction

Lot Details

0

HOA Fees

$90 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: Duplex
  • Levels: Two
  • Year Built: 2024
  • Above Grade Finished Sq Ft: 1848
  • Current Use: Live/Work
  • Exclusions: None
  • Living Area: 1848
  • Pets Allowed: Yes
  • Property Condition: New Construction
  • 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.
  • SubdivisionName: Fickel Farms
  • Ownership: Builder
  • Property Attached Yn: Yes
  • ResoBuildingAreaSource: Builder
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 0
  • REC_BelowGradeUnfinishedArea: 864.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • Ratio Close Price By Original Li: 1.00000
  • Attribution Contact: Denver.contact@meritagehomes.com
  • Special Features: NewHome

Interior Features

  • Appliances: Convection Oven, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer
  • Interior Amenities: Eat-in Kitchen, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Quartz Counters, Smart Thermostat, Walk-In Closet(s), Wired for Data
  • Flooring: Carpet, Tile, Vinyl
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Common Walls: 1 Common Wall
  • Basement: Sump Pump, Unfinished
  • Basement: Yes
  • Total Bedrooms: 3
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: East
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Concrete, Frame, Stone
  • Exterior Features: Lighting, Rain Gutters
  • Patio and Porch Features: Front Porch
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete, Dry Walled, Insulated Garage
  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Electricity Available, Natural Gas Available, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Electric: 110V
  • Laundry Features: In Unit
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Snow Removal
  • Association Name: Advance HOA
  • Association Fee Frequency: Monthly
  • Association Amenities: Clubhouse, Park, Playground, Pool, Trail(s)
  • Association Fee: 90
  • Phone: 303-482-2213
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 1080.00
  • REC_AssociationFeeTotalAnnual: 1080.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationURL: www.advancehoa.com

Schools

  • Middle Or Junior School: Turner

Lot Info

  • Parcel Number: R1679036
  • Lot Size Acres: 0.06
  • Fencing: Partial
  • Building Area Total: 2712
  • Lot Features: Landscaped
  • Lot Size Sq Ft: 2700
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Energy Efficient: Appliances, Construction, HVAC, Insulation, Lighting, Thermostat, Water Heater, Windows

Building Info

  • Builder Name: Meritage Homes

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 2678

MLS Schools

  • Elementary School: Ivy Stockwell
  • High School: Berthoud

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/14/2025 03/14/25 Sold $486,990 0.0% $264 / Sq Ft
01/27/2025 01/27/25 Pending -- -- --
01/17/2025 01/17/25 For Sale $486,990 -- $264 / Sq Ft
Source: REcolorado®

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $2,192 $23,631 $23,631 --
2024 $2,192 $23,631 $23,631 --
2022 $6 $11 $11 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $389,592 New Conventional
Source: Public Records

Deed History

Date Type Sale Price Title Company
Special Warranty Deed $486,990 None Listed On Document
Source: Public Records

Similar Homes in Berthoud, CO

  • 1141 Blue Bell Rd, Berthoud, CO 80513

    $550,000

    • 3 Beds
    • 2.5 Baths
    • 1,839 Sq Ft
    • 1141 Blue Bell Rd
    • Berthoud, CO

    Welcome to 1141 Blue Bell Road - A Slice of Colorado Heaven! Imagine waking up to breathtaking mountain views, sipping your morning coffee on the covered patio as the sun rises over the foothills. The crisp Colorado air invites you to start the day with a scenic tour along nearby trails or a quick round of golf at the prestigious TPC Colorado - just minutes from your doorstep. Unlike the newer

    Michelle Clifford Compass - Boulder

    Section Image
  • 249 E 4th St, Berthoud, CO 80513

    $469,990

    • 3 Beds
    • 2.5 Baths
    • 1,848 Sq Ft
    • 249 E 4th St
    • Berthoud, CO

    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,

    Kerrie Young Kerrie A. Young (Independent)

    Section Image
  • 245 Mayfly Ln, Berthoud, CO 80513

    $522,990

    • 3 Beds
    • 2.5 Baths
    • 1,848 Sq Ft
    • 245 Mayfly Ln
    • Berthoud, CO

    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,

    Kerrie Young Kerrie A. Young (Independent)

    Section Image
  • 349 Fickel Farm Trail, Berthoud, CO 80513

    $458,750

    • 3 Beds
    • 2.5 Baths
    • 1,377 Sq Ft
    • 349 Fickel Farm Trail
    • Berthoud, CO

    Ready in March! Introducing The Hillsdale at The Fickel Farm by CB Signature Homes in Berthoud! No Metro District! All homes feature full basements, two car garages, in addition to the quality construction that you've come to expect! Features include quartz countertops, luxury vinyl floors, custom Milarc cabinetry, decorative front entry door, designer interior, hardware and plumbing fixtures,

    John DeWitt RE/MAX Alliance-Greeley

    Section Image
  • 367 Fickel Farm Trail, Berthoud, CO 80513

    $461,050

    • 3 Beds
    • 2.5 Baths
    • 1,400 Sq Ft
    • 367 Fickel Farm Trail
    • Berthoud, CO

    Ready in April! Introducing The Jackson at Fickel Farm by CB Signature Homes in Berthoud! No Metro District! All homes feature full basements, two car rear loaded garages in addition to the quality construction that you've come to expect! Features include quartz countertops, luxury vinyl floors, custom Milarc style cabinetry, decorative front entry door, designer interior, hardware and plumbing

    John DeWitt RE/MAX Alliance-Greeley

    Section Image
  • 245 E 4th St, Berthoud, CO 80513

    $499,990

    • 3 Beds
    • 2.5 Baths
    • 2,024 Sq Ft
    • 245 E 4th St
    • Berthoud, CO

    Welcome to The Aspen, a beautiful two-story home designed for comfort and entertainment. With an open-concept floorplan, this home offers plenty of space for gatherings, featuring a loft that provides additional flexibility for work or relaxation. The covered outdoor living area is ideal for enjoying meals al fresco with friends, and the upper-level laundry room makes household chores more

    Kerrie Young Kerrie A. Young (Independent)

    Section Image
  • 255 E 4th St, Berthoud, CO 80513

    $454,990

    • 3 Beds
    • 2.5 Baths
    • 1,575 Sq Ft
    • 255 E 4th St
    • Berthoud, CO

    Now selling in the quaint town of Berthoud, with a great location near Boulder, Loveland, and Fort Collins. Berthoud is known for its historic downtown and outdoorsy lifestyle nestled close to the mountains. Nearby numerous parks and trails including the future Waggener Park & Recreation Center, soon breaking ground. An adventure is just outside your door, with the new Heron Lakes TPC Golf Club

    Kerrie Young Kerrie A. Young (Independent)

    Section Image
  • 377 Fickel Farm Trail, Berthoud, CO 80513

    $455,750

    • 3 Beds
    • 2.5 Baths
    • 1,377 Sq Ft
    • 377 Fickel Farm Trail
    • Berthoud, CO

    Ready in April! Large park with playground right down the walkway! Introducing The Hillsdale at Fickel Farm by CB Signature Homes in Berthoud! No Metro District! All homes feature two car garages in addition to the quality construction that you've come to expect! Features include quartz countertops, luxury vinyl floors, custom Milarc cabinetry, decorative front entry door, designer interior,

    John DeWitt RE/MAX Alliance-Greeley

    Section Image
  • 379 W Remuda Rd, Berthoud, CO 80513

    $479,990

    • 3 Beds
    • 2.5 Baths
    • 1,848 Sq Ft
    • 379 W Remuda Rd
    • Berthoud, CO

    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,

    Kerrie Young Kerrie A. Young (Independent)

    Section Image

Source: REcolorado®

MLS Number: 6206291

REcolorado®

APN: 94242-57-007