NOT LISTED FOR SALE

345 Lemonade Dr Berthoud, CO 80513

Estimated Value: $427,000 - $463,000

2 Beds
2 Baths
1,074 Sq Ft
$412/Sq Ft Est. Value

Last Sold June 24, 2022

Last sale price $385,000 $358 Per Sq Ft

Est. 14% increase in value since last sale

Current estimated payment $2,530/month

1 Day on Market

Highlights

  • Open Floorplan
  • Cathedral Ceiling
  • Eat-In Kitchen
  • Contemporary Architecture
  • 2 Car Attached Garage
  • Double Pane Windows

About This Home

As of June 2022

Seller is being transferred out of state - Your opportunity to own this gently lived in, less than 2 year old home located in the desirable community of Farmstead! This home was built by Aspen Homes which includes numerous upgrades including: 12x12 back patio, 8x10 stick built storage shed, central A/C, full landscaping done, plus sprinkler system, storm door, laminate flooring throughout the entire home, insulated garage door, tankless hot water heater, insulated hot & cold water lines in the crawl space, passive radon and solar rough-in! This is a must see home!

Last Agent to Sell the Property

Stephanie Klein

Group Mulberry Listed on: 06/09/2022

Group Mulberry

Last Buyer's Agent

Ben Malone

Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Boulder

Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Boulder

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,979

Year Built

  • Built in 2020

Lot Details

  • 4,975 Sq Ft Lot
  • Partially Fenced Property
  • Wood Fence
  • Level Lot
  • Sprinkler System

HOA Fees

  • $50 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway Level

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Composition Shingle
  • Rough-in for Radon

Interior Spaces

  • 1,074 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Ceiling Fan
  • Double Pane Windows
  • Storm Doors

Kitchen

  • Eat-In Kitchen
  • Electric Oven or Range
  • Self-Cleaning Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Walk-In Closet
  • Primary bathroom on main floor

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Basement

  • Sump Pump
  • Crawl Space

Accessible Home Design

  • No Interior Steps

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Energy-Efficient Thermostat
  • Rough-In for a future solar heating system

Outdoor Features

  • Patio
  • Exterior Lighting
  • Outdoor Storage

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Water Rights
  • High Speed Internet
  • Satellite Dish
  • Cable TV Available

Community Details

  • Association fees include management
  • Built by Aspen Homes
  • Farmstead Subdivision

Listing and Financial Details

  • Assessor Parcel Number R1669862

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,979

Year Built

Built in 2020

Lot Details

0

HOA Fees

$50 per month

Parking

2

Listing Details

  • Year Built: 2020
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.11
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Farmstead
  • Directions: From I-25, W on Hwy 56, S on Dorothy Dr, R on Nebraska Ave, R on Lemonade to property
  • Architectural Style: Contemporary/Modern, Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Efficiency: HVAC, Thermostat
  • Green Power: Solar Rough-In
  • Building Stories: 1
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 1074
  • Special Features: None
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Microwave, Disposal
  • Accessibility Features: Level Lot, Level Drive, No Stairs, Main Floor Bath, Main Level Bedroom, Main Level Laundry
  • Has Basement: None, Crawl Space, Rough-in for Radon, Sump Pump
  • Full Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 2
  • Door Features: Storm Door(s)
  • Interior Amenities: Satellite Avail, High Speed Internet, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
  • Window Features: Double Pane Windows
  • Dining Room Features: Laminate Floor
  • IRESDS_HasFamilyRoom: No
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Laminate Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: 3/4 Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Builder Name: Aspen Homes
  • Fencing: Partial, Wood
  • Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Water Rights Included, Level
  • Waterfront: No
  • Construction Type: Wood/Frame, Composition Siding
  • Exterior Features: Lighting
  • Other Structures: Storage
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: Garage Door Opener
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, Xcel Energy
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Berthoud
  • Gas Company: Natural Gas, Xcel Energy

Condo/Co-op/Association

  • HOA Fee Includes: Management
  • Senior Community: No
  • Association Fee: 150
  • Association Fee Frequency: Quarterly
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Ivy Stockwell
  • HighSchool: Berthoud
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Turner

Lot Info

  • Zoning: Res
  • Lot Size Sq Ft: 4975
  • Parcel #: R1669862
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2021
  • Tax Annual Amount: 1979

Multi Family

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 List to Sale Price per Sq Ft Prior Sale
06/24/2022 06/24/22 Sold $385,000 +2.8% $358 / Sq Ft
06/10/2022 06/10/22 Pending -- -- --
06/09/2022 06/09/22 For Sale $374,500 +14.8% $349 / Sq Ft
09/08/2021 09/08/21 Off Market $326,343 -- --
11/05/2020 11/05/20 Sold $326,343 +2.9% $304 / Sq Ft View Prior Sale
05/04/2020 05/04/20 Price Changed $317,000 -6.5% $295 / Sq Ft
04/22/2020 04/22/20 For Sale $339,000 -- $316 / Sq Ft
Source: IRES MLS

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,352 $28,140 $9,460 $18,680
2024 $2,268 $28,140 $9,460 $18,680
2022 $1,979 $23,262 $7,096 $16,166
2021 $1,979 $20,649 $7,300 $13,349
2020 $1,332 $13,891 $13,891 $0
2019 $8 $29 $29 $0
Source: Public Records

Agents Affiliated with this Home

  • S

    Seller's Agent in 2022

    Stephanie Klein

    Group Mulberry

    (970) 679-8084

    5 in this area

    70 Total Sales

    Stephanie Klein
    Section Image

  • B

    Buyer's Agent in 2022

    Ben Malone

    Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Boulder

    Section Image
  • Dennis Schick

    Seller's Agent in 2020

    Dennis Schick

    RE/MAX

    (970) 226-3990

    47 in this area

    920 Total Sales

    Dennis Schick
    Section Image

  • K

    Buyer's Agent in 2020

    Kaila Schurbrock

    TruNoco Property Management & Real Estate

    (970) 682-9633

    9 Total Sales

    Kaila Schurbrock
    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 967939

IRES MLS

APN: 94242-46-006

Colorado Larimer County Berthoud 80513

345 Lemonade Dr, Berthoud, CO

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

IRES MLS Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.

Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Information deemed reliable but not guaranteed by the MLS.

Nearby Homes