997 Blue Bell Rd

Berthoud, CO 80513

$750,000
Price
5
Beds
3,916 Sq. Ft.
$192 / Sq. Ft.
3,916
Sq. Ft.
$192
per Sq. Ft.
Get preapproved with Rocket Mortgage1
Coming SoonOpen: 6/20 12:00PM - 03:00PM
Coming SoonOpen: 6/20 12:00PM - 03:00PM
Professional photos coming! Amazing curb appeal
Beautiful views of Longs Peak from the living room
Rose Farm Acres
Just down the road from Berthoud Recreation Center at Waggener Farm Park
Waggener Farm Park
Waggener Farm Park
Berthoud Recreational Center pool
Berthoud Recreational Center Fitness

Description

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...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.
  1. Listed by Cody Heyne • RE/MAX Alliance-FTC South
    P: (970)-402-5469 C: (970)-402-5469 cody.heyne@remax.net

Property Details for 997 Blue Bell Road

Locale
Berthoud

Open Houses

Saturday, Jun 20th12:00 PM - 3:00 PM
PublicView contact
Sunday, Jun 21st12:00 PM - 3:00 PM
PublicView contact
LISTING UPDATED: 06/15/2026 06:10 PM

Property Details for 997 Blue Bell Road

StatusComing Soon
MLS #1061890
Days on Compass-
Taxes$6,821 / year
HOA Fees$1,158 / year
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built2020
Lot Size0.18 AC / 7,840 SF
CountyLarimer County
Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of RE/MAX Alliance-FTC South, Cody Heyne
Add your commute

Building Information for 997 Blue Bell Road

Stories-Year Built2020Building Size-Lot Size0.18 AC / 7,840 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$4,402 per month

30 year fixed, 6.36% Interest

Principal and Interest

$3,737

Property Taxes

$568

HOA Dues

$97

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 997 Blue Bell Road

Summary
Location and General Information
  • Road Access 2: City Street
  • Latitude: 40.30
  • Longitude: -105.09
Parking
  • Garage SqFt: 703
  • Total Parking: 3.00
  • Parking Features: Attached
Taxes and HOA Information
  • Fee Includes: Common Amenities, Management
  • Has HOA: Yes
  • HOA Fee: $1,158.00
  • Legal Description: LOT 34, BLOCK 3, ROSE FARM ACRES, BER (20150087956)
  • Tax Information: Yes
  • Has HOA 2: No
  • HOA2 Fee Amount: $0
  • Tax Year: 2025
  • Association Fee Frequency: Monthly
  • Has HOA Covenants: Yes
  • HOA Transfer Fee: Yes
  • Association Name: Rose Farm Acres
  • Association Phone: 970-484-0101
  • Has Association Fee: Yes
  • Has Association Reserve: Yes
  • Has Metro Tax District 2: No
  • Metro Tax District Fee: $2,698
  • Metro Tax District Fee Freq Id: Annually
  • Metro Tax District Name: Rose Farm Acres Metro District
  • Metro Tax District Website: https://www.sdaco.org/lc/sda-transparency/notice/id/3148
  • Tax Annual Amount: $6,821
  • Parcel Number: R1659678
Property
Lot Information
  • Lot Improvements: Cul-De-Sac, House Faces East, City Limits, Paved, Curbs, Gutters, Sidewalks
  • Lot Size Area: 7,921.00
  • Has Irrigation Water Rights: No
  • Has Improvements: No
Property and Assessments
  • Total Finished Area Source: Other
  • Living SqFt: 1958
  • Above Grade Finished Area Source: 1958
  • Sq Ft Apx: 1958
  • Total Finished Area: 3478
  • Property Attached YN: No
  • Are Ditches Active: No
  • Security Features: Fire Alarm
  • New Construction YN: No
  • Levels: One
Utilities
  • Sewer: Public Sewer
  • Green Energy Efficient: Windows, High Efficiency Furnace
Interior and Exterior Features
Exterior Features
  • Construction Materials: Frame
  • Exterior Features: Sprinkler System
Interior Features
  • Interior Features: Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Walk-In Closet(s), Wet Bar, Washer/Dryer Hookup, 3/4 Primary Bath
  • Laundry Features: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal, Fire Alarm
  • Window Features: Window Coverings
  • Fireplaces 1: Gas, Living Room, One
  • All Bedrooms Conform: Yes
  • Full Bathrooms: 1
  • Half Bathrooms: 0
  • Rough-in Bathrooms: 0
  • Three Quarters Bathrooms: 2
  • Baths Full Additional: 0
  • Baths Full Basement: 0
  • Baths Full Upper: 0
  • Baths Full Main: 1
  • Baths Full Lower: 0
  • Baths Half Additional: 0
  • Baths Half Basement: 0
  • Baths Half Upper: 0
  • Baths Half Main: 0
  • Baths Half Lower: 0
  • Baths Three Quarters Additional: 0
  • Baths Three Quarters Basement: 1
  • Baths Three Quarters Lower: 0
  • Baths Three Quarters Upper: 0
  • Baths Three Quarters Main: 1
Room Information
Room 1
  • RoomDescription: Carpet
  • RoomLength: 10.0
  • RoomLevel: Main
  • RoomType: Bedroom 2
  • RoomWidth: 10.0
Room 2
  • RoomDescription: Carpet
  • RoomLength: 10.0
  • RoomLevel: Main
  • RoomType: Bedroom 3
  • RoomWidth: 10.0
Room 3
  • RoomDescription: Carpet
  • RoomLength: 15.0
  • RoomLevel: Basement
  • RoomType: Bedroom 4
  • RoomWidth: 12.0
Room 4
  • RoomDescription: Carpet
  • RoomLength: 11.0
  • RoomLevel: Basement
  • RoomType: Bedroom 5
  • RoomWidth: 12.0
Room 5
  • RoomDescription: Luxury Vinyl
  • RoomLength: 18.0
  • RoomLevel: Main
  • RoomType: Dining Room
  • RoomWidth: 10.0
Room 6
  • RoomDescription: Luxury Vinyl
  • RoomLength: 18.0
  • RoomLevel: Main
  • RoomType: Kitchen
  • RoomWidth: 11.0
Room 7
  • RoomDescription: Luxury Vinyl
  • RoomLength: 6.0
  • RoomLevel: Main
  • RoomType: Laundry
  • RoomWidth: 9.0
Room 8
  • RoomDescription: Luxury Vinyl
  • RoomLength: 18.0
  • RoomLevel: Main
  • RoomType: Living Room
  • RoomWidth: 14.0
Room 9
  • RoomDescription: Carpet
  • RoomLength: 16.0
  • RoomLevel: Main
  • RoomType: Primary Bedroom
  • RoomWidth: 15.0
  • Room Features: 3/4 Primary Bath
Room 10
  • RoomDescription: Carpet
  • RoomLength: 17.0
  • RoomLevel: Basement
  • RoomType: Recreation Room
  • RoomWidth: 31.0
Rental
Rental Information
  • Horse YN: No
  • Occupant Type: Owner

Property History for 997 Blue Bell Road

DateEvent & SourcePriceAppreciation
Sep 3, 2020

Sold (Public Record)

Public Record #677601939

$575,800—
Sep 3, 2020

Sold (Public Record)

Public Record #1406757290

$575,800

-100.0% / yr

Jul 31, 2020

Sold (Public Record)

Public Record #673863893

$3,642,500—
DateEvent & SourcePrice
09/03/2020

Sold (Public Record)

Public Record #677601939

$575,800
09/03/2020

Sold (Public Record)

Public Record #1406757290

$575,800

-100.0% / yr

07/31/2020

Sold (Public Record)

Public Record #673863893

$3,642,500

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 997 Blue Bell Road

Taxable ValueLand$10,519Additions$30,219Total$40,738
Tax Record2025$6,821 ($568 / month)
Home Facts
Beds5Total Finished SqFt3,329 SqFtAbove Grade Finished SqFt1,885 SqFtFinished Basement SqFt1,444 SqFtStories1Lot Size7,919 SqFtStyleSingle Family ResidenceYear Built2020CountyLARIMERAPN94233-33-034Fireplace TypeHas Fireplace

Schools near 997 Blue Bell Road

This home is within Thompson R2-J School District.
Rating
School
Type
Grades
Distance
Ivy Stockwell Elementary School
Public - K to 5
Turner Middle School
Public - 6 to 8
Berthoud High School
Public - 9 to 12
Loveland Classical School
Charter - K to 12
Rating
School
Distance
Ivy Stockwell Elementary School
PublicK to 5

Turner Middle School
Public6 to 8

Berthoud High School
Public9 to 12

Loveland Classical School
CharterK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Explore Nearby Homes

More information about 997 Blue Bell Road, Berthoud, CO 80513

997 Blue Bell Road is a single family home Coming Soon in Berthoud, CO 80513. This property is currently priced at $750,000. This listing's school district is Thompson R2-J School District. Nearby schools include Ivy Stockwell Elementary School, Turner Middle School and Berthoud High School. 997 Blue Bell Road is a 5-bed, 3-bath, 3,916 sqft single family home built in 2020.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of RE/MAX Alliance-FTC South, Cody Heyne

Based on information submitted to the MLS GRID as of 06/15/2026 06:10 PM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX 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. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.