NOT LISTED FOR SALE

470 Yarrow Place Castle Pines, CO 80108

Estimated Value: $1,091,000 - $1,178,000

4 Beds
4.5 Baths
4,373 Sq Ft
$259/Sq Ft Est. Value

Last Sold December 01, 2023

Last sale price $1,045,000 $239 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $6,631/month

30 Days on Market

Highlights

  • Located in a master-planned community
  • Primary Bedroom Suite
  • Traditional Architecture
  • Timber Trail Elementary School Rated A
  • Aspen Trees
  • Wood Flooring

About This Home

As of December 2023

Welcome to this beautiful two-story home in the serene community of Hidden Pointe in Castle Pines North. Located near the picturesque Coyote Ridge Park and just a short drive from the breathtaking Daniel's Park this property is a nature lover's dream. As you approach this exquisite residence you'll be greeted by a newly upgraded exterior boasting fresh paint that enhances its curb appeal. The new roof adds both beauty and peace of mind ensuring your investment is well-protected for years to come. Upon entering you'll step onto gleaming new hardwood floors that grace the main level creating a bright and welcoming atmosphere. The abundance of natural light that pours through large windows further enhances the home's inviting ambiance with new interior paint. The heart of this home is the kitchen featuring a spacious island and top-of-the-line appliances. It's a chef's dream ideal for preparing gourmet meals or hosting gatherings with friends and family. For those who appreciate the environment the home boasts an owned solar system and new HVAC system adding to its eco-friendly appeal and reducing utility costs. Upstairs the custom primary 5-piece bathroom is a masterpiece offering a spa-like retreat within your own home. It's a sanctuary of relaxation and indulgence. Step outside into the private backyard where mature landscaping creates a tranquil oasis. The lush greenery and well-maintained yard provide a perfect backdrop for outdoor activities or simply unwinding in peace. Nestled in a cul-de-sac this home offers a sense of seclusion and peace. The neighborhood itself is a haven boasting scenic trails and charming playgrounds where friends and family can play and explore. This exquisite Castle Pines North home is a true masterpiece of luxury living. With its brand new upgrades and serene surroundings it offers a haven of comfort and style. Don't miss the opportunity to make this extraordinary property your own and experience the beauty and charm it has to offer.

Last Agent to Sell the Property

Michele Gwin

RE/MAX Professionals Brokerage Email: Michele@GwinProperties.com,303-947-7743 License #100056149 Listed on: 09/13/2023

RE/MAX Professionals

Last Buyer's Agent

Lisa Hoyer

West and Main Homes Inc License #100067466

West and Main Homes Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,140

Year Built

  • Built in 2000

Lot Details

  • 0.25 Acre Lot
  • Cul-De-Sac
  • Northwest Facing Home
  • Partially Fenced Property
  • Landscaped
  • Planted Vegetation
  • Sloped Lot
  • Front and Back Yard Sprinklers
  • Irrigation
  • Aspen Trees
  • Partially Wooded Lot
  • Many Trees
  • Private Yard
  • Grass Covered Lot

HOA Fees

  • $57 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Wood Siding
  • Radon Mitigation System

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Wired For Data
  • Built-In Features
  • Bar Fridge
  • High Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Double Pane Windows
  • Window Treatments
  • Bay Window
  • Great Room with Fireplace

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Double Convection Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • Jack-and-Jill Bathroom

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Basement

  • Partial Basement
  • Interior Basement Entry
  • Basement Cellar

Home Security

  • Smart Thermostat
  • Outdoor Smart Camera
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Solar Heating System

Outdoor Features

  • Covered Patio or Porch
  • Rain Gutters

Schools

  • Timber Trail Elementary School
  • Rocky Heights Middle School
  • Rock Canyon High School

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Natural Gas Connected
  • Gas Water Heater
  • High Speed Internet

Listing and Financial Details

  • Exclusions: Seller's personal belongings, 2 freezers in garage (refrigerator in garage will stay), pull up bar in garage, reverse osmosis water faucet (soap dispenser to be put in it's place), white curtains in guest bedroom.
  • Assessor Parcel Number R0415959

Community Details

Overview

  • Association fees include recycling, trash
  • Hidden Pointe HOA, Phone Number (303) 985-9623
  • Built by Sanford Homes
  • Hidden Pointe Subdivision
  • Located in a master-planned community

Recreation

  • Community Playground
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,140

Year Built

Built in 2000

Lot Details

0

HOA Fees

$57 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Structure Type: House
  • Levels: Two
  • Year Built: 2000
  • Above Grade Finished Sq Ft: 3200
  • Exclusions: Seller's personal belongings, 2 freezers in garage (refrigerator in garage will stay), pull up bar in garage, reverse osmosis water faucet (soap dispenser to be put in it's place), white curtains in guest bedroom.
  • Living Area: 4373
  • SubdivisionName: Hidden Pointe
  • Co List Office Mls Id: RECREM39
  • Co List Office Phone: 303-972-9999
  • Ownership: Individual
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 0
  • REC_BelowGradeUnfinishedArea: 60.00
  • REC_ExpectedActiveDate: 2023-09-14
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 3
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.99619
  • Attribution Contact: Michele@GwinProperties.com,303-947-7743
  • Special Features: VirtualTour

Interior Features

  • Appliances: Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Humidifier, Microwave, Refrigerator, Washer
  • Fireplaces: 1
  • Interior Amenities: Breakfast Nook, Built-in Features, Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, Jack & Jill Bathroom, Kitchen Island, Primary Suite, Radon Mitigation System, Smart Thermostat, Solid Surface Counters, Stone Counters, Walk-In Closet(s), Wet Bar, Wired for Data
  • Flooring: Carpet, Tile, Vinyl, Wood
  • Fireplace Features: Gas Log, Great Room
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Common Walls: No Common Walls
  • Basement: Cellar, Interior Entry, Partial
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1173
  • Main Level Bathrooms: 1
  • Window Features: Bay Window(s), Double Pane Windows, Window Coverings, Window Treatments

Exterior Features

  • Direction Faces: Northwest
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Brick, Frame, Wood Siding
  • Exterior Features: Private Yard, Rain Gutters
  • Patio and Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Electricity Connected, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Solar
  • Water Source: Public
  • Laundry Features: In Unit
  • Security: Carbon Monoxide Detector(s), Smart Cameras, Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Recycling, Trash
  • Association Name: Hidden Pointe HOA
  • Association Fee Frequency: Quarterly
  • Association Amenities: Park, Playground, Trail(s)
  • Association Fee: 170
  • Phone: 303-985-9623
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 680.00
  • REC_AssociationFeeTotalAnnual: 680.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0

Schools

  • Middle Or Junior School: Rocky Heights

Lot Info

  • Horses: No
  • Parcel Number: R0415959
  • Lot Size Acres: 0.25
  • Fencing: Partial
  • Building Area Total: 4433
  • Lot Features: Cul-De-Sac, Irrigated, Landscaped, Many Trees, Master Planned, Sloped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 10890
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Sanford Homes

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 4140

MLS Schools

  • Elementary School: Timber Trail
  • High School: Rock Canyon

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 13, 2023
Closed on
Dec 1, 2023
Sold by
Courchaine Adam and Courchaine Dara
Bought by
Desmarteau Sean and Desmarteau Ellesse
Seller's Agent
Michele Gwin
RE/MAX Professionals
Buyer's Agent
Lisa Hoyer
West and Main Homes Inc
List Price
$1,049,000
Sold Price
$1,045,000
Premium/Discount to List
-$4,000
-0.38%
Views
288
Current Estimated Value
$1,133,966

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$88,966
Avg. Annual Appreciation
3.77%
Original Mortgage
$214,300
Outstanding Balance
$81,087
Interest Rate
7.63%
Estimated Equity
$1,036,663

Purchase Details

Closed on
Oct 13, 2017
Sold by
Stewart Robert B and Stewart Robin A
Bought by
Courchaine Adam and Courchaine Dara

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$630,722
Interest Rate
3.78%
Mortgage Type
VA

Purchase Details

Closed on
Feb 16, 2000
Sold by
Sanford Homes Of Colorado Lllp
Bought by
Stewart Robert B and Stewart Robin A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$226,500
Interest Rate
8.19%
Mortgage Type
Balloon

Purchase Details

Closed on
Jan 1, 2000
Sold by
Colo North Co & South Platte Co & Colo B
Bought by
Sanford Homes Colo

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$226,500
Interest Rate
8.19%
Mortgage Type
Balloon

Purchase Details

Closed on
May 11, 1999
Sold by
Elken Stephen F and Donal Robert
Bought by
South Platte Co
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
Desmarteau Sean $1,045,000 Apex Title
Courchaine Adam $662,000 First American Title
Stewart Robert B $364,753 Land Title
Sanford Homes Colo -- --
South Platte Co $95,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Desmarteau Sean $214,300
Open Desmarteau Sean $726,200
Previous Owner Courchaine Adam $630,722
Previous Owner Stewart Robert B $226,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/01/2023 12/01/23 Sold $1,045,000 +1.0% $239 / Sq Ft
10/12/2023 10/12/23 Price Changed $1,035,000 -1.3% $237 / Sq Ft
09/14/2023 09/14/23 For Sale $1,049,000 -- $240 / 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
2024 $6,740 $71,100 $13,270 $57,830
2023 $6,802 $71,100 $13,270 $57,830
2022 $4,140 $47,500 $9,190 $38,310
2021 $4,307 $47,500 $9,190 $38,310
2020 $3,987 $45,040 $8,430 $36,610
2019 $4,001 $45,040 $8,430 $36,610
2018 $3,563 $39,470 $8,440 $31,030
2017 $3,318 $39,470 $8,440 $31,030
2016 $3,425 $39,970 $9,150 $30,820
2015 $3,683 $39,970 $9,150 $30,820
2014 $3,328 $33,920 $8,760 $25,160
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 7790794

REcolorado®

APN: 2231-331-05-048