Skip main navigation
Pending
  • $750,000

    997 Blue Bell Rd, Berthoud, CO 80513

    5beds
    3,916sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 2020
    7,921 Square Feet Lot
    $751,100 Zestimate®
    $192/sqft
    $97/mo HOA

    What's special

    Better than new, this beautifully upgraded modern farmhouse ranch combines thoughtful design, everyday comfort, and some of the most captivating views Berthoud has to offer. From the moment you step inside, Longs Peak commands your attention, framed by double sliding patio doors and visible throughout the living room, dining area, and kitchen. It's a view that transforms ordinary moments into something special. The open-concept living room is anchored by a stunning stone fireplace and filled with natural light. The chefs gourmet kitchen features quartz countertops, an oversized island, gas range, double ovens, and plenty of workspace, making it equally suited for hosting a crowd or enjoying a quiet evening at home. The main floor primary suite provides a comfortable retreat, while two additional bedrooms offer flexibility for family, hobbies, or a dedicated office. The main floor laundry room with a farmhouse sink adds convenience to everyday living. Step through the patio doors onto the extended west-facing covered patio, where gorgeous mountain views and unforgettable Colorado sunsets create an outdoor space you'll find yourself enjoying year-round. The beautifully landscaped backyard offers room to relax, entertain, and enjoy the outdoors, while wired mesh fencing is ready to make this home for the furry family members as well. The finished basement is move-in ready with a spacious rec room, a kitchenette and bar, two additional bedrooms with walk-in closets, and exceptional flexibility for multi-generational living, extended guests, or independent living arrangements. A 3-car garage, radon mitigation system, and meticulous maintenance throughout, further enhance the home's appeal. Located within walking distance of Berthoud High School and connected to miles of neighborhood trails, it is also a short drive to the Berthoud Recreation Center, Waggener Farm Park, downtown Berthoud, TPC Colorado golf course, and convenient commuting to both Loveland and Longmont.
    35 days
    |
    108
    |
    2
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Cody Heyne 970-226-3990,

    RE/MAX Alliance-FTC South

    Source: IRES as distributed by MLS GRID,MLS#: 1061890MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 3
      • Full bathrooms: 1
      • 3/4 bathrooms: 2
      • Main level bathrooms: 2
      Primary bedroom
      • Description: Carpet
      • Features: 3/4 Primary Bath
      • Level: Main
      • Area: 240 Square Feet
      • Dimensions: 15 x 16
      Bedroom 2
      • Description: Carpet
      • Level: Main
      • Area: 100 Square Feet
      • Dimensions: 10 x 10
      Bedroom 3
      • Description: Carpet
      • Level: Main
      • Area: 100 Square Feet
      • Dimensions: 10 x 10
      Bedroom 4
      • Description: Carpet
      • Level: Basement
      • Area: 180 Square Feet
      • Dimensions: 12 x 15
      Bedroom 5
      • Description: Carpet
      • Level: Basement
      • Area: 132 Square Feet
      • Dimensions: 12 x 11
      Dining room
      • Description: Luxury Vinyl
      • Level: Main
      • Area: 180 Square Feet
      • Dimensions: 10 x 18
      Kitchen
      • Description: Luxury Vinyl
      • Level: Main
      • Area: 198 Square Feet
      • Dimensions: 11 x 18
      Laundry
      • Description: Luxury Vinyl
      • Level: Main
      • Area: 54 Square Feet
      • Dimensions: 9 x 6
      Living room
      • Description: Luxury Vinyl
      • Level: Main
      • Area: 252 Square Feet
      • Dimensions: 14 x 18
      Recreation room
      • Description: Carpet
      • Level: Basement
      • Area: 527 Square Feet
      • Dimensions: 31 x 17
      Heating
      • Forced Air
      Cooling
      • Central Air, Ceiling Fan(s)
      Appliances
      • Included: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
      • Laundry: Washer/Dryer Hookup
      Features
      • Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Walk-In Closet(s), Wet Bar
      • Windows: Window Coverings
      • Basement: Partially Finished
      • Number of fireplaces: 1
      • Fireplace features: Gas, Living Room, One
      Interior area
      • Total structure area: 1,958
      • Total interior livable area: 3,916 sqft
      • Finished area above ground: 1,958

      Property

      Parking
      • Total spaces: 3
      • Parking features: Attached
      • Attached garage spaces: 3
      • Details: Attached
      Accessibility
      • Accessibility features: Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
      Features
      • Levels: One
      • Stories: 1
      • Exterior features: Sprinkler System
      • Fencing: Fenced
      • Has view: Yes
      • View description: Mountain(s), Hills
      Lot
      • Size: 7,921 Square Feet
      • Features: Cul-De-Sac, City Limits, Paved, Curbs, Gutters, Sidewalks
      Details
      • Parcel number: R1659678
      • Zoning: RES
      • Special conditions: Private Owner

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Contemporary
      • Property subtype: Single Family Residence
      Materials
      • Frame
      • Roof: Composition
      Condition
      • New construction: No
      • Year built: 2020
      Details
      • Builder name: Richmond American Homes

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: City
      • Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail, Underground Utilities
      Green energy
      • Energy efficient items: Windows, High Efficiency Furnace

      Community & HOA

      Community
      • Features: Park, Trail(s)
      • Security: Fire Alarm
      • Subdivision: Rose Farm Acres
      HOA
      • Has HOA: Yes
      • Services included: Common Amenities, Management
      • HOA fee: $97 monthly
      • HOA name: Rose Farm Acres
      • HOA phone: 970-484-0101
      Location
      • Region: Berthoud

      Financial & listing details

      • Price per square foot: $192/sqft
      • Tax assessed value: $651,800
      • Annual tax amount: $6,821
      • Date on market: 6/15/2026
      • Listing terms: Cash,Conventional,FHA,VA Loan
      • Exclusions: Basement TV, Washer, Dryer, Stairlift & Chair. All furniture is negotiable.
      • Electric utility on property: Yes
      • Road surface type: Asphalt, Concrete

        Estimated market value

        $751,100

        $714,000 - $789,000

        $3,957/mo

        Price history

        DateEventPrice
        6/21/2026Pending sale$750,000$192/sqft
        Source: IRES as distributed by MLS GRID #1061890 Report a problem
        6/19/2026Listed for sale$750,000+30.3%$192/sqft
        Source: IRES as distributed by MLS GRID #1061890 Report a problem
        9/8/2020Sold$575,800$147/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$6,821 -1.3%$40,738 -11.9%
        2024$6,909 +14.1%$46,230 -1%
        2023$6,057 +34.8%$46,678 +29.4%
        2022$4,493 +39.2%$36,064 +34.8%
        2021$3,228 +318.2%$26,762 +39.2%
        2020$772 +10125.7%$19,227 +311.3%
        2019$8 $4,675 +17880.8%
        2018$8 $26
        2017$8 +4%$26 +52.9%
        2016$7 $17
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 80513

        Getting around

        16 / 100
        Car-Dependent
        23 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Ivy Stockwell
        • Middle: Turner
        • High: Berthoud

        Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes