$512,490
SOLD MAR 25, 2025

249 Mayfly Ln Berthoud, CO 80513

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

Recently Sold

$288 Per Sq Ft

2% Below List Price

45 Days on Market

Highlights

  • New Construction
  • Clubhouse
  • Loft
  • Open Floorplan
  • Contemporary Architecture
  • Great Room

About This Home

As of March 2025

Live Now in this stylish new home close to Old Town Berthoud! Enjoy coffee and privacy from your covered porch facing west on the pocket park. This perfectly designed home fits every lifestyle for modern living. entertain and have fun at your new kitchen featuring Harbor Grey cabinets, white quartz tops, stainless appliances, and a large eat in island. Relax with family and friends in the open great room or upstairs loft. With its new finishes, builder warranty, and extreme energy efficiency, this home provides easy maintenance and will save on monthly energy bills. The unfinished basement allows for your future dream rec room. 2 car garage, and storage space abounds. Tech package, lighting package and 6' privacy fencing included! Also included is the Fridge, Washer/Dryer, Blinds and Organizational Kitchen Package. This home is ready for you near lovely Pioneer Park. No Metro Tax!

***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 Listed on: 01/17/2025

Last Buyer's Agent

Philip Cooper

Group Harmony License #100079063

Group Harmony

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

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
  • Loft

Kitchen

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

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry in unit
  • Dryer
  • Washer

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 R1679024

Community Details

Overview

  • Association fees include ground maintenance, snow removal
  • Advance HOA, Phone Number (303) 482-2213
  • Built by Meritage Homes
  • Fickel Farms Subdivision, Telluride 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: 1778
  • Current Use: Live/Work
  • Exclusions: None
  • Living Area: 1778
  • Pets Allowed: Yes
  • Property Condition: New Construction
  • Directions: From I25 Head West on Highway 56 (County Rd 8) towards Berthoud Approx. 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: 849.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.98368
  • Attribution Contact: Denver.contact@meritagehomes.com
  • Special Features: NewHome

Interior Features

  • Appliances: Convection Oven, Dishwasher, 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: 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: 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: R1679024
  • Lot Size Acres: 0.06
  • Fencing: Partial
  • Building Area Total: 2627
  • 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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 17, 2025
Closed on
Mar 24, 2025
Sold by
Meritage Homes Of Colorado Inc
Bought by
Gronstal David
Seller's Agent
Kerrie Young
Kerrie A. Young (Independent)
Buyer's Agent
Philip Cooper
Group Harmony
List Price
$520,990
Sold Price
$512,490
Premium/Discount to List
-$8,500
-1.63%
Views
2
Current Estimated Value
$512,211

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$279
Avg. Annual Appreciation
-0.11%
Original Mortgage
$523,508
Outstanding Balance
$521,732
Interest Rate
6.87%
Mortgage Type
VA
Estimated Equity
-$9,521
Source: Public Records

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

Purchase History

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

Mortgage History

Date Status Loan Amount Loan Type
Open $523,508 VA
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/25/2025 03/25/25 Sold $512,490 -0.5% $288 / Sq Ft
03/03/2025 03/03/25 Pending -- -- --
02/26/2025 02/26/25 Price Changed $514,990 -1.0% $290 / Sq Ft
02/11/2025 02/11/25 Price Changed $519,990 -0.2% $292 / Sq Ft
02/06/2025 02/06/25 For Sale $520,990 0.0% $293 / Sq Ft
01/18/2025 01/18/25 Pending -- -- --
01/17/2025 01/17/25 For Sale $520,990 -- $293 / Sq Ft
Source: REcolorado®

Tax History Compared to Growth

Source: Public Records

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,272 $23,631 $23,631 --
2024 $2,192 $23,631 $23,631 --
2022 $6 $11 $11 --
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 8522658

REcolorado®

APN: 94242-56-003