$520,990
SOLD MAR 31, 2025

235 Mayfly Ln Berthoud, CO 80513

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

Recently Sold

$282 Per Sq Ft

11 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 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!

Last Agent to Sell the Property

Kerrie Young

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

Last Buyer's Agent

Mary Colwell

Dwellings Colorado Real Estate License #100005820

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,865

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 2,700 Sq Ft Lot
  • West 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
  • Cement Siding

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wired For Data
  • Double Pane Windows
  • Window Treatments
  • Great Room
  • Dining Room
  • Home Office
  • Laundry in unit

Kitchen

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

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Stubbed For A Bathroom

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 R1679027

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,865

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: 4098

Interior Features

  • Appliances: Convection Oven, Dishwasher, Microwave, Refrigerator
  • 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: Bath/Stubbed, Full, Sump Pump, Unfinished
  • Basement: Yes
  • Total Bedrooms: 3
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows, Window Coverings

Exterior Features

  • Direction Faces: West
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Cement Siding, Frame, Other
  • 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: R1679027
  • 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: 2865

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/31/2025 03/31/25 Sold $520,990 0.0% $282 / Sq Ft
02/10/2025 02/10/25 Pending -- -- --
01/30/2025 01/30/25 For Sale $520,990 -- $282 / 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 $390,742 New Conventional
Source: Public Records

Deed History

Date Type Sale Price Title Company
Special Warranty Deed $520,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
  • 1108 Wilshire Dr, Berthoud, CO 80513

    $650,000

    • 4 Beds
    • 2.5 Baths
    • 2,618 Sq Ft
    • 1108 Wilshire Dr
    • Berthoud, CO

    Welcome to this well cared for home nestled in a quiet neighborhood with pocket parks and close to many Berthoud amenities such as the destination Bike Park that is down the street, TPC golf course a few miles away and the Berthoud Rec Center. This home features a flowing open floorplan perfect for gathering in the living room, dining room and kitchen. Prepare your meals in a kitchen that boasts

    Christine Torres RE/MAX Alliance-Loveland

    Section Image
  • 2422 Tabor St, Berthoud, CO 80513

    $650,000

    • 5 Beds
    • 3.5 Baths
    • 3,429 Sq Ft
    • 2422 Tabor St
    • Berthoud, CO

    Home is tenant occupied until may. Welcome to your new home in a highly sought-after neighborhood perfectly situated between Berthoud and Loveland. This spacious 2-story gem boasts 5 bedrooms, 3 and a half bathrooms, and a 3-car garage, offering plenty of space for both relaxation and entertainment. Step inside to discover an open floor plan designed for modern living with a 2-story living area

    Matthew Fugate The Fugate Property Group

    Section Image
  • 245 Mayfly Ln, Berthoud, CO 80513

    $489,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
  • 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
  • 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
  • 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
  • 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

Source: REcolorado®

MLS Number: 1773132

REcolorado®

APN: 94242-56-006