$490,000
SOLD AUG 6, 2025

1100 Blue Bell Rd Berthoud, CO 80513

4 Beds
3.5 Baths
1,954 Sq Ft
4,475 Sq Ft Lot

Recently Sold

$251 Per Sq Ft

7% Below List Price

41 Days on Market

Highlights

  • Primary Bedroom Suite
  • Recreation Room
  • High Ceiling
  • Contemporary Architecture
  • Wood Flooring
  • Front Porch

About This Home

As of August 2025

Welcome to your dream home in Rose Farm—light, bright, and full of thoughtful upgrades that make it truly move-in ready. Situated on a premium corner lot, this stunning 4-bedroom, 4-bathroom home is even better than new. This one-year-old beauty has already been upgraded with over $90,000 in premium finishes, saving you time, money, and stress.

You’ll love the modern, cozy feel from the moment you step inside—luxury window treatments, high-end appliances, and sleek glass shower doors give every space a polished look. The finished basement adds a fourth bedroom and bathroom, along with an electric fireplace that creates the perfect retreat or guest space. California Closet systems throughout the home ensure every inch is as functional as it is beautiful.

Step outside to your extended patio, where the private fenced yard and professional landscaping create a peaceful oasis—ideal for entertaining or enjoying a quiet evening under the stars.

This home goes beyond builder-grade, offering the upgrades and comforts already in place so you can move in and enjoy from day one. From thoughtful storage to high-style finishes, every detail has been done for you. All that’s left to do is move in and start living.

Last Agent to Sell the Property

Jake Upwell

Compass - Denver Brokerage Email: jake.upwell@compass.com,720-401-5093 License #100089266 Listed on: 06/05/2025

Compass - Denver

Last Buyer's Agent

Tommy Thompson

Revolve Real Estate, LLC License #40040573

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,138

Year Built

  • Built in 2023 | Remodeled

Lot Details

  • 4,475 Sq Ft Lot
  • South Facing Home
  • Property is Fully Fenced
  • Landscaped

HOA Fees

  • $97 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Frame Construction
  • Composition Roof

Interior Spaces

  • 2-Story Property
  • High Ceiling
  • Electric Fireplace
  • Double Pane Windows
  • Living Room
  • Dining Room
  • Recreation Room
  • Bonus Room

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • 1 Bedroom in Basement

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Patio
  • Front Porch

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Connected
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Seller's Personal Property, Window Treatments in Primary Bedroom, Mineral Rights Excluded.
  • Assessor Parcel Number R1682773

Community Details

Overview

  • Association fees include reserves
  • Rose Farm Acres HOA, Phone Number (970) 484-0101
  • Built by CB Signature Homes
  • Rose Farm Subdivision, Jackson Floorplan

Recreation

  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,138

Year Built

Built in 2023 | Remodeled

Lot Details

0

HOA Fees

$97 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: Two
  • Year Built: 2023
  • Above Grade Finished Sq Ft: 1400
  • Exclusions: Seller's Personal Property, Window Treatments in Primary Bedroom, Mineral Rights Excluded.
  • Living Area: 1954
  • Property Condition: Updated/Remodeled
  • SubdivisionName: Rose Farm
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 1
  • REC_ExpectedActiveDate: 2025-06-05
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.93333
  • Special Features: NewHome

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer
  • Fireplaces: 1
  • Interior Amenities: High Ceilings, High Speed Internet, Kitchen Island, Pantry, Primary Suite, Walk-In Closet(s)
  • Flooring: Carpet, Vinyl, Wood
  • Fireplace Features: Electric, Recreation Room
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Full
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 554
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: South
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Frame
  • Patio and Porch Features: Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2

Utilities

  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Laundry Features: In Unit
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Reserves
  • Association Name: Rose Farm Acres HOA
  • Association Fee Frequency: Monthly
  • Association Amenities: Park, Trail(s)
  • Association Fee: 96.5
  • Phone: 970-484-0101
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 1158.00
  • REC_AssociationFeeTotalAnnual: 1158.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_AssociationURL: https://ccgcolorado.com/

Schools

  • Middle Or Junior School: Turner

Lot Info

  • Parcel Number: R1682773
  • Lot Size Acres: 0.1
  • Fencing: Full
  • Building Area Total: 1954
  • Lot Features: Landscaped
  • Lot Size Sq Ft: 4475

Building Info

  • Builder Name: CB Signature Homes

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 1138

MLS Schools

  • Elementary School: Ivy Stockwell
  • High School: Berthoud

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 5, 2025
Closed on
Aug 6, 2025
Sold by
Austin-Mills Mary Katherine
Bought by
Albion Rentals Sylvan Llc
Seller's Agent
Jake Upwell
Compass - Denver
Buyer's Agent
Tommy Thompson
Revolve Real Estate, LLC
List Price
$525,000
Sold Price
$490,000
Premium/Discount to List
-$35,000
-6.67%
Views
28
Current Estimated Value
$498,582

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$8,582
Avg. Annual Appreciation
4.33%

Purchase Details

Listed on
Aug 21, 2023
Closed on
Apr 23, 2024
Sold by
Cb Signature Homes Llc
Bought by
Austin-Mills Mary Katherine
Seller's Agent
John DeWitt
RE/MAX Alliance-Greeley
Buyer's Agent
Laura Levy
Coldwell Banker Realty-Boulder
List Price
$458,250
Sold Price
$459,830
Premium/Discount to List
$1,580
0.34%
Views
166

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.05%

Purchase Details

Closed on
Sep 14, 2023
Sold by
Ridgeview Investments Llc
Bought by
Cb Signature Homes Llc
Source: Public Records

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

Purchase History

Date Type Sale Price Title Company
Warranty Deed $490,000 None Listed On Document
Special Warranty Deed $459,830 None Listed On Document
Special Warranty Deed $550,000 None Listed On Document
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/06/2025 08/06/25 Sold $490,000 -3.9% $251 / Sq Ft
07/07/2025 07/07/25 Price Changed $510,000 -2.9% $261 / Sq Ft
06/05/2025 06/05/25 For Sale $525,000 +14.2% $269 / Sq Ft
04/23/2024 04/23/24 Sold $459,830 -3.2% $235 / Sq Ft View Prior Sale
03/05/2024 03/05/24 Price Changed $474,830 +2.5% $243 / Sq Ft
09/25/2023 09/25/23 Price Changed $463,250 +0.4% $237 / Sq Ft
08/29/2023 08/29/23 Price Changed $461,550 +0.7% $236 / Sq Ft
08/21/2023 08/21/23 For Sale $458,250 -- $235 / Sq Ft
Source: REcolorado®

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 $1,138 $15,524 $7,471 $8,053
2024 $208 $23,631 $23,631 --
2022 $209 $2,175 $2,175 $0
2021 $208 $2,175 $2,175 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 7953837

REcolorado®

APN: 94233-44-009