This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
$509,990
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
Full Property Details for 245 Mayfly Ln
Sign in to view more details. Local MLS Rules require you to be signed in. Not a member yet? Sign up now.
General
- Sold For: $509,990
- HOA FEE: $90/month
- Taxes: $2,876 (2023)
- Status: Closed
- Type: Duplex
- Source: MetroList_Colorado
- MLS ID: 8365095
- Added to Site: 383 day(s) ago
Interior
- 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
- Appliances: Convection Oven, Dishwasher, Microwave, Refrigerator
- Flooring: Carpet, Tile, Vinyl
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 2
- Half Bathrooms: 1
- Main Floor Baths: 1
Bedrooms
- Total Bedrooms: 3
Other Rooms
- Laundry: In Unit
Additional Information
- Shared Amenities: Clubhouse, Park, Playground, Pool, Trail(s)
- Security/Safety: Carbon Monoxide Detector(s), Smoke Detector(s)
Exterior
- Exterior Features: Lighting, Rain Gutters
- Porch/Patio/Deck: Front Porch
Parking
- Garage: Yes
- Garage Spaces: 2
- Total Spaces: 2
- Parking Features: Concrete, Dry Walled, Insulated Garage
Location
- County: Larimer
- Subdivision: Fickel Farms
- Driving 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.
- Direction Faces: West
School Information
- Elem School District: Thompson R2-J
- Midd School District: Thompson R2-J
- High School District: Thompson R2-J
- Elementary School: Ivy Stockwell
- Middle School: Turner
- High School: Berthoud
Community
- Association: Yes
- Assoc. Name: Advance HOA
- Assoc. Fees Include: Maintenance Grounds, Snow Removal
- Pets Allowed: Yes
- Management Type: Professionally Managed
Heating & Cooling
- Cooling Type: Central Air
- Heating Type: Forced Air, Natural Gas
Utilities
- Gas: Yes
- Sewer: Public Sewer
- Water: Public
- Utility Description: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Available, Phone Available
Structural Information
- Architectural Style: Contemporary
- Structure Type: Duplex
- Builder: Meritage Homes
- Model: Vail
- Construction: Cement Siding, Frame, Other
- Basement: Yes
- Basement Desc.: Bath/Stubbed, Full, Sump Pump, Unfinished
- Roof: Composition
- Common Walls: 1 Common Wall
- Windows: Double Pane Windows, Window Coverings
- Square Feet: 2,712
- Sq. Ft. Source: Builder
- Living Area: 1,848 Sq. Ft.
- Current Bldg. Use: Live/Work
- Year Built: 2023
- Property Condition: New Construction
Lot Features
- Lot Size (Acres): 0.06
- Lot Size (Sq. Ft.): 2,700
- Frontage: Public
- Street/Road Desc.: Paved
- Road Maintenance: Public Maintained Road
- Fence: Yes
- Lot Features: Landscaped
- Zoning: RES
- Fencing (Description): Partial
Green Features
- Energy Efficient: Appliances, Construction, HVAC, Insulation, Lighting, Thermostat, Water Heater, Windows
Financial Considerations
- Association Fee: Yes
- Association Fee: $90
- Assoc Fee Freq.: Monthly
- Assoc Fee /Annual: $1,080
- Tax Amount: $2,876
- Tax Year: 2023
- Terms: 1031 Exchange, Cash, Conventional, FHA, VA Loan
Disclosures and Reports
- Ownership: Builder
- Special Conditions: None
- Documents Avail.: HOA Docs Available
- Legal Description: LOT 4, BLOCK 4, FICKEL FARM PUD FOURTH FILING; BER (20220015532)
- Exclusions: None
- Property ID: R1679025
- Lot Number: 404
Listed by Kerrie A. Young (Independent)
Sold by RE/MAX Professionals
Schools serving 245 Mayfly Ln
| Name | Grades | Distance |
|---|---|---|
Ivy Stockwell Elementary School 175 5th Street, Berthoud, CO 80513 | K-5 | 0.7 mi |
Turner Middle School 950 Massachusetts Avenue, Berthoud, CO 80513 | 6-8 | 1 mi |
Berthoud High School 850 Spartan Avenue, Berthoud, CO 80513 | 9-12 | 0.9 mi |
Home Warranty : Included
245 Mayfly Lane, Berthoud, CO 80513 (MLS# 8365095) is a Duplex property that was sold at $509,990 on June 20, 2025. Want to learn more about 245 Mayfly Lane? Do you have questions about finding other Duplex real estate for sale in Berthoud? You can browse all Berthoud real estate or contact a Coldwell Banker agent to request more information.

