OFF MARKET

Off market jun 2020 for $377K

$484,902

•

1,911

sq ft

523 Ranchhand Dr, Berthoud, CO 80513

About this home

The Keystone is a two story, 3 bed, 2 1/2 bath home. The front door opens into an elegant vaulted entry with a powder room. On the main level is an open concept kitchen, dining and great room. The kitchen finishes have 42" Maple Lancaster cabinets, Bengal white granite countertops and a stainless steel whirlpool gas range oven. This home has a 20'-8" x 10' back patio. Upstairs is a spacious loft which overlooks the vaulted entry. On the second floor are two bedrooms and the owner's bedroom. The owner's bedroom has a large walk in closet. The laundry is conveniently located on the second floor. Home is under construction

Single-familyProperty Type

2020Year Built

5,368 sq ftLot Size

$254Est. Price/Sq.Ft.

2 car garageParking

Listed by Dan Ruth • RE/MAX Professionals Greenwood Village

Bought with Dan Ruth • RE/MAX Professionals Greenwood Village

Redfin checked: 3 minutes ago

•Source:REColorado as Distributed by MLS Grid #IR901917

Listing provided courtesy of Metrolist,Inc. (REColorado)

Redfin Estimate

$484,902

$107K since sold in June 2020$5,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 2.8% higher than the average sale price ($472K) of 6 comparable homes.

SOLD AUG 18, 2026
$480,000
A
3 beds3 baths1,792 sq ft
602 Great Plains Ave, Berthoud, CO 80513
Listing provided by metrolistCO
SOLD MAY 27, 2026
$490,000
B
3 beds2.5 baths2,123 sq ft
376 Country Rd, Berthoud, CO 80513
SOLD FEB 27, 2026
$465,000
C
3 beds2.5 baths2,105 sq ft
533 Grand Market Ave, Berthoud, CO 80513
SOLD AUG 27, 2026
$475,000
D
4 beds2.5 baths2,111 sq ft
2871 Night Sky Dr, Berthoud, CO 80513
SOLD APR 27, 2026
$460,000
E
3 beds2 baths1,433 sq ft
2722 Big Empty Pl, Berthoud, CO 80513
SOLD MAY 4, 2026
$459,000
F
3 beds2 baths1,683 sq ft
575 Ranchhand Dr, Berthoud, CO 80513
Listing provided by metrolistCO

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$191,984

Est. take-home

List your home with Redfin and save $4,849

Rent

$2,890/mo

Redfin rental estimate

List your home for rent

Market trends in 80513, CO

Last updated October 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-list price

98.9%

+0.3% MoM

Median sale price

$610K

$25K MoM

Avg. days on market

79d

15 days MoM

Recently sold homes

2 MoM

New listings for sale

COMING SOON
$1,075,000
3 beds2.5 baths2,708 sq ft
1846 Little Acres Ln, Berthoud, CO 80513
COMING SOON
$350,000
2 beds2.5 baths1,080 sq ft
2726 Center Park Way, Berthoud, CO 80513
$825,000
5 beds3 baths3,936 sq ft
2243 Breckenridge Dr, Berthoud, CO 80513
EmpowerHome Team Colorado • Keller Williams Realty Northern Colorado
3D WALKTHROUGH
$890,000
4 beds3.5 baths4,733 sq ft
722 Sophie St, Berthoud, CO 80513
3D WALKTHROUGH
$624,900
4 beds3 baths3,542 sq ft
1657 Vantage Pkwy, Berthoud, CO 80513
$139,000
2 beds2 baths1,088 sq ft
227 N 2nd St #4, Berthoud, CO 80513
3D WALKTHROUGH
$640,000
5 beds3.5 baths3,115 sq ft
1252 Sun River Rd, Berthoud, CO 80513
3D WALKTHROUGH
$490,000
3 beds2 baths2,986 sq ft
1544 Brant St, Berthoud, CO 80513
3D WALKTHROUGH
$1,650,000
5 beds4 baths6,569 sq ft
1030 Berthoud Peak Dr, Berthoud, CO 80513
Ann Yuska • RE/MAX Nexus
3D WALKTHROUGH
$990,000
4 beds3 baths3,248 sq ft
4901 Beverly Dr, Berthoud, CO 80513
Ann Yuska • RE/MAX Nexus
See all

Provided by Redfin

Sale history for 523 Ranchhand Dr

Date

Event

Price

IRES as Distributed by MLS Grid #901917

Jun 9, 2020

Sold

$377,445

$198/sq ft

Jun 5, 2020

Pending

—

Feb 1, 2020

Price Changed

$372,545

$195/sq ft

Jan 16, 2020

Listed

$370,545

$194/sq ft

Public Remarks

IRES as Distributed by MLS Grid #7591382

Jun 9, 2020

Sold

$377,445

$198/sq ft

Feb 1, 2020

Price Changed

$372,545

$195/sq ft

Jan 16, 2020

Listed

$370,545

$194/sq ft

Jan 16, 2020

Listed

$372,545

$195/sq ft

REColorado as Distributed by MLS Grid #IR901917

Jun 9, 2020

Sold

$377,445

$198/sq ft

Jan 16, 2020

Listed

$372,545

$195/sq ft

Public Records

Nov 15, 2019

Sold

$589,411

$308/sq ft

Public Records

May 10, 2019

Sold

$2,562,000

$1,341/sq ft

Join or sign in to view all info

Tax history for 523 Ranchhand Dr

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

2.5

Stories

Lot width

—

Lot depth

—

Lot size

5,368 Sq. Ft.

Year renovated

2019

Sq. Ft.

1,985

Year built

2019

Style

Single Family Residential

County

Larimer County

APN

R1663384

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 21, 2026.

PUD

Planned Unit Development Overlay District

The Planned Unit Development PUD Overlay District was used as an overlay zone to supplements one or more underlying standard zone districts as found in this Code. The PUD Overlay District is no longer available as an option to zoning. Previously-approved PUDs are recognized. Any unimproved property with an approved PUD is encouraged to rezone their property to a zone district recognized in the Town's Zoning Chapter of the Development Code. Amendments to an existing PUD Overlay District will require the applicant to rezone the property and provide a Neighborhood Master Plan. Further subdivision processes may be required.

Property details

Parking

Parking/Garage Information
Parking Total: 2
Garage Spaces: 2
AttachedGarageYN: Yes

Interior

Bedroom Information
Bedrooms Total: 3
Upper Level Bedrooms: 3

Bathroom Information
Bathrooms Total Integer: 3
Bathrooms Full: 2
Bathrooms Half: 1
Upper Level Bathrooms: 2
Main Level Bathrooms: 1

Room 1 Information
Bedroom
Level: Upper

Room 2 Information
Kitchen
Level: Main

Room 3 Information
Dining Room
Level: Main

Room 4 Information
Primary Bedroom
Level: Upper

Room 5 Information
Laundry
Level: Upper

Room 6 Information
Game Room
Level: Upper

Room 7 Information
Bedroom
Level: Upper

Room 8 Information
Great Room
Level: Main

Room 9 Information
Bathroom (Full)
Level: Upper

Room 10 Information
Bathroom (Full)
Level: Upper

Room 11 Information
Bathroom (1/2)
Level: Main

Interior Features
Interior Features: Kitchen Island,Open Floorplan,Pantry,Walk-In Closet(s)
Appliances: Dishwasher, Microwave, Oven
Flooring: Tile
Window Features: Double Pane Windows

Basement Information
Basement: Crawl Space

Exterior

Building Information
Builder Model: Keystone
Building Area Total: 1,911
Building Area Source: Plans
Structure Type: House
Construction Materials: Wood Frame

Exterior Features
Patio And Porch Features: Patio
Roof: Composition

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Property Condition: Under Construction
Living Area: 1,911
Above Grade Finished Area: 1,911
Levels: Two
Direction Faces: Northeast
Possible Use: Residential
Ownership: Builder

Lot Information
Lot Size Square Feet: 5,368
Lot Size Acres: 0.12
Lot Features: Sprinklers In Front
Water Source: Public
Road Surface Type: Paved
Zoning: RES

Financial

Tax Information
Tax Annual Amount: $3,927
Tax Year: 2019
Parcel Number: R1663384

Utilities

Utility Information
Utilities: Cable Available, Electricity Available, Natural Gas Available
Sewer: Public Sewer

Heating & Cooling
Heating: Forced Air

Location

School Information
Elementary School: Carrie Martin
Elementary School District: Thompson R2-J
Middle Or Junior School: Bill Reed
Middle Or Junior School District: Thompson R2-J
High School: Thompson Valley
High School District: Thompson R2-J

Public facts

Beds: 3
Baths: 2.5
Sq. Ft.: 1,985
Stories: 2.0
Lot Size: 5,368 square feet
Style: Single Family Residential
Year Built: 2019
Year Renovated: 2019
County: Larimer County
APN: R1663384

Home facts updated by county records on Oct 21, 2026

Around this home

Schools

K - 12
Preschool & daycare

Carrie Martin Elementary School

Public PreK-5 • Assigned • 1.2mi

8/10

Bill Reed Middle School

Public 6-8 • Assigned • 3.9mi

3/10

Thompson Valley High School

Public 9-12 • Assigned • 3.5mi

4/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

2/10 Fire Factor

0.00% chance of being in a wildfire in next 30 years

3/10 Heat Factor

7 days above 92° expected this year, 19 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

4/10 Air Factor

6 unhealthy days expected this year, 7 days in 30 years

Provided by First Street

Historical weather

Berthoud, CO • 80513

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.5 hours in June and 5.9 hours in December, placing it above the U.S. average for solar exposure.

10.5 hrs

5.9 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$461,000 – $558,000

Reach more buyers when you sell with Redfin. Save up to $4,849 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$800,000

3 beds1 bath1,230 sq ft

515 E County Road 8, Berthoud, CO 80513

Fully fenced acres • Wood burning stove • Multiple sheds

Listing provided by REColorado as Distributed by MLS Grid

$1,175,000

3 beds3 baths3,208 sq ft

5215 E County Road 16, Loveland, CO 80537

11 acres • Spacious kitchen • Extensive cabinetry

$389,500

2 beds1 bath864 sq ft

1406 S Douglas Ave, Loveland, CO 80537

Soft-close cabinets • Custom tile • 7,977 sq ft lot

$379,900

2 beds2 baths1,736 sq ft

652 Lake Ave, Berthoud, CO 80513

New roof • New gutters • New carpet

$655,000

3 beds2.5 baths3,373 sq ft

412 E Michigan Ave, Berthoud, CO 80513

Main floor living • South facing lot • Granite countertops

FOR SALE BY OWNER

$604,000

2 beds2 baths1,606 sq ft

648 5th St, Berthoud, CO 80513

Detached garage • Built 1900 • Listed 66 days

New listings for sale in 80513

COMING SOON

$1,075,000

3 beds2.5 baths2,708 sq ft

1846 Little Acres Ln, Berthoud, CO 80513

3 acre property • Corrals & arena • 3 acre lot

COMING SOON

$350,000

2 beds2.5 baths1,080 sq ft

2726 Center Park Way, Berthoud, CO 80513

Longs peak views • Off-street parking • Detached garage

$825,000

5 beds3 baths3,936 sq ft

2243 Breckenridge Dr, Berthoud, CO 80513

Front courtyard • Covered back porch • Garden boxes

Listing provided by REColorado as Distributed by MLS Grid

3D WALKTHROUGH

$890,000

4 beds3.5 baths4,733 sq ft

722 Sophie St, Berthoud, CO 80513

Full acre • Approved for a shop • In-ground pool

3D WALKTHROUGH

$624,900

4 beds3 baths3,542 sq ft

1657 Vantage Pkwy, Berthoud, CO 80513

Granite counters • Covered porch • Outdoor pools

$139,000

2 beds2 baths1,088 sq ft

227 N 2nd St #4, Berthoud, CO 80513

Private bedrooms • Walk-in tile showers • Large kitchen island

3D WALKTHROUGH

$640,000

5 beds3.5 baths3,115 sq ft

1252 Sun River Rd, Berthoud, CO 80513

Main-level living • Large pantry • Open kitchen

3D WALKTHROUGH

$490,000

3 beds2 baths2,986 sq ft

1544 Brant St, Berthoud, CO 80513

Corner lot • New roof • Fresh exterior paint

3D WALKTHROUGH

$1,650,000

5 beds4 baths6,569 sq ft

1030 Berthoud Peak Dr, Berthoud, CO 80513

Custom home • Spacious lot • Dedicated office

Listing provided by REColorado as Distributed by MLS Grid

Home values near 523 Ranchhand Dr

Data from public records.

Address	Redfin Estimate
502 Ranchhand Dr, Berthoud, CO 3 Beds \| 2.5 Baths \| 2296 Sq. Ft.	$569,169
530 Ranchhand Dr, Berthoud, CO 3 Beds \| 3.5 Baths \| 2558 Sq. Ft.	$607,902
548 Ranchhand Dr, Berthoud, CO 3 Beds \| 3 Baths \| 3628 Sq. Ft.	$563,077
531 Ranchhand Dr, Berthoud, CO 4 Beds \| 3 Baths \| 2257 Sq. Ft.	$528,411
549 Ranchhand Dr, Berthoud, CO 5 Beds \| 3 Baths \| 2208 Sq. Ft.	$504,643
546 Ten Gallon Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1650 Sq. Ft.	$491,694
500 Ten Gallon Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1650 Sq. Ft.	$490,315

Address	Redfin Estimate
514 Ranchhand Dr, Berthoud, CO 5 Beds \| 4 Baths \| 3676 Sq. Ft.	—
536 Ranchhand Dr, Berthoud, CO 2 Beds \| 2 Baths \| 3610 Sq. Ft.	$573,437
501 Ranchhand Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1682 Sq. Ft.	$485,149
537 Ranchhand Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1435 Sq. Ft.	$478,792
555 Ranchhand Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1435 Sq. Ft.	$459,136
530 Ten Gallon Dr, Berthoud, CO 2 Beds \| 2 Baths \| 1433 Sq. Ft.	$464,264
503 Ten Gallon Dr, Berthoud, CO 3 Beds \| 2.5 Baths \| 1985 Sq. Ft.	$501,179

Address	Redfin Estimate
522 Ranchhand Dr, Berthoud, CO 3 Beds \| 2.5 Baths \| 2296 Sq. Ft.	$557,445
540 Ranchhand Dr, Berthoud, CO 3 Beds \| 2.5 Baths \| 1988 Sq. Ft.	$542,896
515 Ranchhand Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1435 Sq. Ft.	$454,905
543 Ranchhand Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1683 Sq. Ft.	$499,930
554 Ten Gallon Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1650 Sq. Ft.	$482,499
524 Ten Gallon Dr, Berthoud, CO 3 Beds \| 2 Baths \| 1433 Sq. Ft.	$495,036
543 Country Rd, Berthoud, CO 3 Beds \| 2.5 Baths \| 1985 Sq. Ft.	$487,779

Property information provided by REColorado as Distributed by MLS Grid when last listed in 2020. This data may not match . Learn more.

More real estate resources

Cities
Zip Codes
Neighborhoods
Popular Searches

Berthoud homes for sale
Boulder homes for sale
Fort Collins homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Campion	Agents near me	Fort Collins, CO homes for sale	Campion Housing Market
Houses for sale near me	Denver, CO homes for sale	Aurora, CO homes for sale
Land for sale near me	Colorado Springs, CO homes for sale	Arvada, CO homes for sale
Open Houses near me	Boulder, CO homes for sale	Campion Property Records
Condos for sale near me	Littleton, CO homes for sale	CO New Listings