NOT LISTED FOR SALE

523 Ranchhand Dr Berthoud, CO 80513

Estimated Value: $515,000 - $527,000

3 Beds
2.5 Baths
1,911 Sq Ft
$273/Sq Ft Est. Value

Last Sold June 09, 2020

Last sale price $377,445 $198 Per Sq Ft

Est. 38% increase in value since last sale

Current estimated payment $3,172/month

116 Days on Market

Highlights

  • Under Construction
  • Open Floorplan
  • No HOA
  • Carrie Martin Elementary School Rated 9+
  • Loft
  • 2 Car Attached Garage

About This Home

As of June 2020

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.

Last Agent to Sell the Property

Dan Ruth

RE/MAX Professionals Greenwood Village Listed on: 01/16/2020

RE/MAX Professionals Greenwood Village

Last Buyer's Agent

Dan Ruth

RE/MAX Professionals Greenwood Village Listed on: 01/16/2020

RE/MAX Professionals Greenwood Village

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,927

Year Built

  • Built in 2020 | Under Construction

Lot Details

  • 5,368 Sq Ft Lot
  • Northeast Facing Home
  • Sprinkler System

Parking

  • 2 Car Attached Garage

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Composition Shingle

Interior Spaces

  • 1,911 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Double Pane Windows
  • Loft
  • Crawl Space
  • Laundry on upper level

Kitchen

  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Outdoor Features

  • Patio

Schools

  • Carrie Martin Elementary School
  • Bill Reed Middle School
  • Thompson Valley High School

Utilities

  • Forced Air Heating System
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Built by Richfield Homes
  • Prairie Star Subdivision

Listing and Financial Details

  • Assessor Parcel Number R1663384

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,927

Year Built

Built in 2020 | Under Construction

Lot Details

0

Parking

2

Listing Details

  • Year Built: 2020
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.12
  • Road Surface Type: Paved
  • Subdivision Name: Prairie Star
  • Directions: From I25, take exit 250 and head west towards Berthoud. Turn right on Berthoud Pkwy heading north, cross HWY 287 and Prairie Star sales office is on the northeast corner off Wagon Bend Rd.
  • Above Grade Finished Sq Ft: 1911
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: Yes
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 1911
  • Special Features: NewHome
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Microwave
  • Has Basement: None, Crawl Space
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Interior Amenities: Open Floorplan, Pantry, Walk-In Closet(s), Loft, Kitchen Island
  • Living Area: 1911
  • Window Features: Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Vinyl Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom3 Area: 100
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 100
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 14
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Vinyl Floor
  • Room Kitchen Area: 112
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 196
  • Room Dining Room Area: 132
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Composition
  • Builder Name: Richfield Homes
  • Lot Features: Curbs, Sidewalks, Lawn Sprinkler System
  • Waterfront: No
  • Construction Type: Wood/Frame, Composition Siding
  • Direction Faces: Northeast
  • Patio And Porch Features: Patio
  • Property Condition: Under Construction

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • IRESDS_GarageType: Attached

Utilities

  • Electric: Electric, Xcel
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Upper Level
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Berthoud
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

  • Elementary School: Carrie Martin
  • HighSchool: Thompson Valley
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Bill Reed

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 5368
  • Parcel #: R1663384
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2019
  • Tax Annual Amount: 3927

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 16, 2020
Closed on
Jun 9, 2020
Sold by
Richfield Homes Llc
Bought by
Schmaltz Cameron and Conrad Kathryn
Seller's Agent
Dan Ruth
RE/MAX Professionals Greenwood Village
Buyer's Agent
Dan Ruth
RE/MAX Professionals Greenwood Village
List Price
$370,545
Sold Price
$377,445
Premium/Discount to List
$6,900
1.86%
Current Estimated Value
$521,119

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$143,674
Avg. Annual Appreciation
6.25%
Original Mortgage
$358,573
Outstanding Balance
$317,848
Interest Rate
3.2%
Mortgage Type
New Conventional
Estimated Equity
$203,271
Source: Public Records

Range of Values:

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 Buyer Sale Price Title Company
Schmaltz Cameron $377,445 Land Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Schmaltz Cameron $358,573
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/13/2020 09/13/20 Off Market $377,445 -- --
06/09/2020 06/09/20 Sold $377,445 +1.3% $198 / Sq Ft
05/11/2020 05/11/20 Pending -- -- --
02/01/2020 02/01/20 Price Changed $372,545 +0.5% $195 / Sq Ft
01/16/2020 01/16/20 For Sale $370,545 -- $194 / Sq Ft
Source: IRES MLS

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 $4,918 $35,182 $8,201 $26,981
2024 $4,811 $35,182 $8,201 $26,981
2022 $3,999 $27,146 $6,616 $20,530
2021 $4,076 $27,928 $6,807 $21,121
2020 $3,357 $22,997 $22,997 $0
2019 $3,111 $21,721 $21,721 $0
2018 $253 $1,711 $1,711 $0
2017 $6 $10 $10 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 901917

IRES MLS

APN: 94023-31-003