Skip main navigation
Off market
  • $613,300

    510 Mayo Ct, Berthoud, CO 80513

    5beds
    3,103sqft
    SingleFamily
    Built in 1992
    8,311 Square Feet Lot
    $613,300 Zestimate®
    $198/sqft
    $3,662 Estimated rent

    Home value

    $613,300

    $583,000 - $644,000

    $3,662/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,662/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,662/mo

    Rent Zestimate®

    Refinance and save

    $2,859/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $2,859/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Welcome home to this beautiful five bedroom home in the sought after Berthoud Heights subdivision. The home has seen attention paid to every detail and is host to a wonderful floorplan. The home opens to a spacious living room with vaulted ceilings. The home offers a large kitchen with stainless steel appliances, granite counter tops, a breakfast nook set in a lovely bay window and a formal dining area. The kitchen overlooks the family room complete with a cozy gas fireplace, patio access and laminate flooring is shares with much of the main living area. Upstairs is host to a loft area, perfect for a home office as well as three bedrooms. The roomy master bedroom offers vaulted ceilings, a walk-in closet and a full five piece master bath with a jetted tub. The basement has been finished and greatly expanded the living area with two more bedrooms, a rec room, an additional bath and a second laundry! The home also offers a 2013 roof, a newer tankless water heater, a whole house water filtration system and a newer high efficiency modulating furnace and heat pump with a two stage A/C. Outside, the home has plenty of curb appeal with lovely landscaping, a brick facade and a heated three-car garage. The large fenced backyard features an adorable playhouse, raised garden beds and an extended partially covered patio, perfect for entertaining. Property is in close proximity to schools and is within walking distance to the elementary school. Downtown shopping, parks, and the city swimming pool are nearby as well. Great home on a great lot in a great neighborhood, this one will not last long!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 4
    Heating
    • Forced air, Heat pump, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Garbage disposal, Microwave, Range / Oven, Refrigerator
    Features
    • Flooring: Carpet, Laminate, Linoleum / Vinyl
    • Basement: Finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 3,103 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage - Attached
    Features
    • Exterior features: Wood, Brick
    Lot
    • Size: 8,311 Square Feet
    Details
    • Parcel number: 9423156011

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Frame
    • Foundation: Concrete
    • Roof: Composition
    Condition
    • Year built: 1992

    Community & HOA

    Location
    • Region: Berthoud

    Financial & listing details

    • Price per square foot: $198/sqft
    • Tax assessed value: $558,100
    • Annual tax amount: $3,530

    Price history

    DateEventPrice
    6/7/2017Sold$388,000-3%$125/sqft
    Source: IRES as distributed by MLS GRID #816413 Report a problem
    4/10/2017Listed for sale$400,000+60%$129/sqft
    Source: Kittle Real Estate #816413 Report a problem
    10/12/2011Sold$250,000-3.8%$81/sqft
    Source: Public Record Report a problem
    8/22/2011Price change$259,900-3.7%$84/sqft
    Source: RE/MAX Alliance #648993 Report a problem
    3/3/2011Listed for sale$269,900-3.3%$87/sqft
    Source: Re/Max Action Brokers #648993 Report a problem
    8/11/2010Listing removed$279,000$90/sqft
    Source: Keller Williams of NO CO-FTC #621684 Report a problem
    8/5/2010Price change$279,000+3.4%$90/sqft
    Source: Keller Williams of NO CO-FTC #621684 Report a problem
    6/7/2010Price change$269,900-3.3%$87/sqft
    Source: Keller Williams Realty of Northern Colorado #621684 Report a problem
    3/9/2010Listed for sale$279,000-7%$90/sqft
    Source: Keller Williams Realty of Northern Colorado #621684 Report a problem
    12/5/2009Listing removed$299,900$97/sqft
    Source: Bronwyn L. Schuetze #590593 Report a problem
    7/11/2009Price change$299,900-3.3%$97/sqft
    Source: Bronwyn L. Schuetze #590593 Report a problem
    3/29/2009Listed for sale$310,000$100/sqft
    Source: Bronwyn L. Schuetze #590593 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$3,530 +2.2%$34,882 -11.9%
    2024$3,454 +21.6%$39,610 -1%
    2023$2,841 -2.7%$39,995 +35%
    2022$2,920 +9.5%$29,621 -2.8%
    2021$2,667 +2.9%$30,473 +9.5%
    2020$2,591 +8.5%$27,820 -0.7%
    2019$2,389 $28,015 +15.3%
    2018$2,389 $24,307
    2017$2,389 +13.4%$24,307 +11.8%
    2016$2,106 +8.9%$21,747 0%
    2015$1,934 +2.6%$21,750 +7.4%
    2014$1,885 $20,260
    2013-- $20,260 +9.7%
    2012-- $18,470
    2011-- $18,470 -1.2%
    2010-- $18,690
    2009-- $18,690 -34.2%
    2008-- $28,400
    2007-- $28,400 +23.4%
    2006-- $23,020
    2005-- $23,020 +10.2%
    2004-- $20,890 +1%
    2002-- $20,690
    2001-- $20,690
    Find assessor info on the county website

    Neighborhood: 80513

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Ivy Stockwell
    • Middle: Turner
    • High: Berthoud
    • District: Thompson R2-J

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $613,300
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $613,300