See Home Value
$1,262,400
● House - Off Market

404 Yarrow Pl

Castle Pines, CO 80108
bedrooms
5 Beds
bathrooms
3 Baths
square feet
4,817 Ft²
$1,046,299
RealtyHop Estimate
-6.54%
Since Jun 1, 2022
CO-Denver
Primary Model

About This Property

Location Location Location! This beautiful 5 bedroom, 5 bathroom Executives family home is located in the highly sought after Hidden Pointe neighborhood in Castle Pines North. Boasting the best location within the neighborhood, this home is situated at the end of a quiet cul-de-sac backing to open space, walking trails, and expansive views on a .36 acre lot. Walk into this beautiful home and you will see an open floor plan with large updated gourmet kitchen with breakfast nook, granite island, double-oven and granite countertops with under cabinet lighting, new furnace and AC Unit. Hardwood flooring on the main floor and plantation shutters throughout. Walk out onto the covered large trex deck and see the amazing views as it backs to the open space and professionally landscaped mature backyard with huge upper patio perfect for outdoor entertaining.  

Spacious primary suite has views to open space, cove ceiling, updated five-piece bath with tile floor and granite counter-tops and large walk-in closet.  There are three additional bedrooms on the upper level. One has an en-suite bathroom and the additional two bedrooms share a Jack n' Jill bathroom.  

The large walk-out basement is fully finished with a large great room, kitchenette, 5th bedroom and full, updated bathroom all with easy walk-out access to the huge backyard. Additionally, the basement boasts *bonus* exercise room, theatre room, and storage/craft room.  

Additional features include wiring for hot tub in backyard and whole house vacuum system, currently not in use. The home also has a wired sound system throughout, including in the spacious 3 car garage!  

 

This home has it all: prime location, an entertainer's floorpan, beautiful updates, spacious rooms, and easy access to I-25. You do not want to miss this opportunity - this home is move-in ready and easy to show.
Unit Size
4,817 Ft²
Days on Market
-
Land Size
0.36 acres
Price per sqft
$232
Property Type
House
Property Taxes
$424
HOA Dues
$161
Year Built
1999

Payment Calculator

Cap Rate Calculator

Last updated: 12 months ago (REcolorado MLS #2870687)

Price History

Date / Event Date Event Price
Aug 6, 2025 Withdrawn -
Withdrawn
Jun 20, 2025 Price Decreased $1,275,000
↓ $25K (1.9%)
Price Decreased
May 1, 2025 Listed by Madison & Company Properties $1,300,000
Listed by Madison & Company Properties
Welcome to your new home in the coveted Hidden Pointe neighborhood-where thoughtful updates, generous living spaces, and a premium location come together. This 5-bedroom, 5-bathroom home offers over 5,200 square feet of refined living space, situated at the end of a Cul-De-Sac, backing to open space and scenic trails. Step inside to find a grand entrance and fresh indoor paint. The kitchen is designed for gatherings and everyday living, featuring granite countertops, a gas stove, a center island, and ample cabinetry. Adjacent living and dining areas provide a bright and open flow, with large windows that frame peaceful views of the backyard and open space. The main floor also offers a private office with built-in shelving and a desk-perfect for working from home or organizing daily life. Upstairs, the spacious primary suite welcomes you with vaulted ceilings, a five-piece bathroom with dual vanities, a soaking tub, and a walk-in closet. Additional bedrooms are generously sized and thoughtfully laid out with ample storage. The fully finished walk-out basement expands the home's functionality, featuring a theater room, fitness space, a large open play area, a fifth bedroom, a 3/4 bathroom, and direct access to the backyard. Outdoor living is easy with an upgraded fenced yard, enhanced landscaping, and a spacious deck equipped with a gas line ready for grilling and entertaining. This home also features a new roof and gutters, an upgraded sprinkler system, and a three-car garage providing plenty of space for vehicles. The location within Hidden Pointe offers a true Colorado lifestyle- a fantastic community, surrounded by open space, and trails, yet close to top-rated Douglas County schools including Timber Trail Elementary, Rocky Heights Middle School, and Rock Canyon High School. Spacious house on a fantastic lot, this home is ready to welcome its next owner.
May 10, 2022 Sold
Sold
Apr 7, 2022 Listed by HomeSmart Realty $1,119,500
Listed by HomeSmart Realty
Show More

Property Highlights

Garage
Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 1999
  • Effective Year Built: 2021
  • Building Count: 1
  • Total Rooms: 5
  • Bedroom Count: 4
  • Bathroom Count: 4
  • Full Bathrooms: 4
  • Partial Bathrooms: 4
  • Building Condition: 3
  • Building Quality: 4
  • Construction Type: 6
  • Building Style: 28
  • Exterior Walls Type: 19
  • Interior Walls Type: 3
  • Roof Shape Type: 7
  • Roof Cover Type: 3
  • Floor Count: 200
  • Living Units: 1
  • Floor Cover: 3
  • Basement Type: 1
  • Basement Area: 1,814
  • Garage Type: 7
  • Garage Square Area: 695
  • Parking Space Count: 2
  • Patio Type: 20
  • Porch Type: 8
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 15,682
  • Total Building Area: 5,241
  • Gross Building Area: 5,241
  • Building Area: 4,817
  • Building Area Measurement: L

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 4,817
  • Heating Fuel Type: 0

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: GREEN VALLEY
  • Land Acres: 0000000360
  • Standard Land Use Code: 1001
  • County Land Use Code: 1112
  • Legal Description 1: LOT 6 BLK 3 GREEN VALLEY #1B 0.360 AM/L

Neighborhood

  • School District Name: Douglas County School District RE-1
  • Census Tract: 014125

Geography

  • Assessors Map Reference: 242-B
  • Account Number: R0415956
  • Parcel: 0415956
  • Block: 3
  • Lot: 6
  • Meridian: SEC 33 TWN 06S RNG 67W QTR NE
  • Municipality: DOUGLAS COUNTY RE 1
  • Latitude: 39.4883
  • Longitude: -104.893

    Address

  • Full Address: 404 Yarrow Pl
  • Address - House Number: 404
  • Address - Street Name: Yarrow
  • Address - Suffix Type: Pl
  • State: CO
  • City Name: Castle Pines
  • Carrier Code: C007
  • 4-Digit Zip Code: 3429
  • Zip Code: 80108

Valuation

    Tax

  • Total Area: 5,240
  • Tax Year: 2022
  • Tax Amount: $488,772
  • Tax Rate Code Area: 3535

    Appraisal Valuation

  • Standard Deviation: 0.1057
  • Valuation Date: Mar 08, 2023
  • Confidence Score: 89
  • Final Value: 1,115,650
  • High Value: 1,233,604
  • Low Value: 997,696

    Market Valuation

  • Market Total Value: $806,886
  • Market Land Value: $155,366
  • Market Improvement Value: $651,520

    Assessments Valuation

  • Assessed Year: 2022
  • Assessed Total Value: $56,080
  • Assessed Land Value: $10,800
  • Assessed Improvements Value: $45,280

    Sales

  • Current Sale Contract Date: May 05, 2022
  • Current Sale Recording Date: May 10, 2022
  • Current Sale Price:
  • Current Sale Document Type: 71
  • Current Sale Input Document Number: 33675
  • Previous Sale Recording Date: Apr 23, 2015
  • Previous Sale Contract Date: Apr 21, 2015
  • Previous Sale Amount: $644,000
  • Previous Sale Document Type: 71
Data used for valuation calculations is provided by RealtyHop, and other third party sources

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Castle Pines


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals



Frequently Asked Questions

When was property at 404 Yarrow Place built and last sold?
The property at 404 Yarrow Place was built in 1999 and last sold on May 5, 2022 for $1,262,400.
How much is this home worth?
The estimated value of the home located at 404 Yarrow Place is $0.
What are some comparable homes to 404 Yarrow Place?
There are currently no comparable homes to 404 Yarrow Place.