Backup offers
$10,000 Closing Credit¹
#5103870, Mick Madsen, Listing office: RE/MAX Professionals
#8005896·
Listing office: Madison & Company Properties·
Listing agent: Paula Ramsbottom·
Listing office phone: 303-771-3850
$1,300,000 List price
404 Yarrow Pl Castle Pines, CO 80108
$10,000
Closing credit¹
5 beds
3 full, 2 partial
5,058 sqft
0.4 acres
$257 / sqft
House
Property details
About 404 Yarrow Pl
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. Move-in ready with modern updates and an unbeatable setting, this home is ready to welcome its next owner.
Highlights
Home typeSingle Family Residence
HeatingForced Air
StatusActive
CoolingCentral Air
Size5,058 sqft
BasementYes
Lot size0.36 Acres
Year built2001
ParkingConcrete
MLS #8005896
Attached garage3 spaces
FireplaceBasement, Family Room, Living Room
Summary
- Partial Bathrooms: 2
- Full Bathrooms: 3
- Appliances: Dishwasher, Double Oven, Dryer, Gas Water Heater, Microwave, Range, Range Hood, Refrigerator, Washer, Water Softener
- Basement: Yes
- Flooring Type: Wood
- Interior: Audio/Video Controls, Breakfast Bar, Built-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, In-Law Floorplan, Jack & Jill Bathroom, Open Floorplan, Primary Suite, Walk-In Closet(s)
- Fireplace: Basement, Family Room, Living Room
- Total Bedroom Count: 5
- Garage Space: 3 spaces
- Attached Garage: Yes
- Parking: Concrete
- Exterior: Balcony, Gas Valve, Private Yard
- Architectural Style: Contemporary, Traditional
- Heating: Forced Air
- Cooling: Central Air
- List Price: $1,300,000
- Price/SqFt: $257
- HOA Amount: $176 Quarterly
- Annual Tax Amount: $8,780
- Tax Year: 2023
- Lot: Cul-De-Sac, Landscaped, Many Trees, Open Lot, Sprinklers In Front, Sprinklers In Rear
- Year Built: 2001
- Living Area: 5,058 SqFt
- Lot Size: 0.36 Acres
- MLS Number: 8005896
- MLS Name: RECOLORADO
- Office Name: Madison & Company Properties
- Office Phone: (303) 771-3850
- Listing Agent: Paula Ramsbottom
Listings courtesy of REColorado as distributed by MLS GRID.
All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.
©2025 METROLIST, INC., DBA RECOLORADO® - All Rights Reserved.
Presented by Rocket Homes Real Estate, LLC
Licensed in Colorado Brokerage License # EC. 100073419
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Rocket Homes Real Estate, LLC are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.
The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
© 2025 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved
6455 S. Yosemite St., Suite 300
Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 6/7/2025, 9:42:27 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$1,300,000
404 Yarrow Pl
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| May 10, 2022 | Home Sold | $1,262,400 |
| Apr 23, 2015 | Home Sold | $644,000 |
| Oct 29, 2003 | Home Sold | $550,000 |
| Aug 10, 2000 | Home Sold | $527,000 |
| Dec 28, 1999 | Home Sold | $478,600 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2023 | $90,720 | $8,780 |
| 2022 | $56,080 | $4,887 |
| 2021 | $57,690 | $5,084 |
| 2020 | $52,330 | $4,632 |
| 2019 | $52,690 | $4,513 |
| 2018 | $49,990 | $4,201 |
| 2017 | $49,990 | $4,452 |
History based on county public records data.
Nearby schools
7
Timber Trail Elementary School
Public District KG-5
1.1 mi
•690 W Castle Pines Pkwy
6
Buffalo Ridge Elementary School
Public District KG-5
1.5 mi
•7075 Shoreham Dr
7
Wildcat Mountain Elementary School
Public District KG-5
3.0 mi
•6585 Lionshead Pkwy
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $165,576. Residents of Castle Pines, CO typically earn between $100k-200k each year. Residents typically live in married, no kids family. The most common level of education of people living in this area is post secondary degree.
How much money do the neighbors make?
6%
<35k
19%
35k-100k
38%
100k-200k
37%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
24%
Single, No Kids
5%
Single, with Kids
37%
Married, No Kids
34%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
17%
<11 yrs old
13%
12-17 yrs old
9%
18-34 yrs old
53%
35-64 yrs old
8%
65+ yrs old
What do the neighbors do for fun?
Skiing/snowboarding
PGA/LPGA
College Football
Where do the neighbors shop?
BJs Wholesale Club
Stein Mart
Express/Express For Men
Where do the neighbors go to eat?
Panera
Cracker Barrel
Sonic
What do the neighbors drive?
Infiniti
Lexus
Kia
What do the neighbors listen to?
Adult Hits
Oldies
New Country
All data provided by Home Junction and Claritas
Similar homes for sale
1 day on RocketBackup offers
$10,000 Closing Credit¹
#7188392, Stephanie Bryant, Listing office: Huntington Properties LLC
$10,000 Closing Credit¹
#IR1033041, Christopher Crow, Listing office: Black Feather Realty
$10,000 Closing Credit¹
#6893241, Shari Peck, Listing office: Madison & Company Properties
$10,000 Closing Credit¹
#7527625, The HomeSmiths Team, Listing office: Keller Williams DTC
3 days on Rocket
$10,000 Closing Credit¹
#7306425, Natalie Force, Listing office: The Steller Group, Inc
Tour
$10,000 Closing Credit¹
#7223058, Doug Hutchins, Listing office: eXp Realty, LLC
2 days on Rocket
$10,000 Closing Credit¹
#2995785, Stacie Chadwick, Listing office: LIV Sotheby's International Realty
$10,000 Closing Credit¹
#6702332, Mary Jane Ogle, Listing office: Exp Realty LLC
$10,000 Closing Credit¹
#5103660, Peter Droogsma, Listing office: Equity Colorado Real Estate
Frequently asked questions
About 404 Yarrow Pl
The listing price of 404 Yarrow Pl property is $1,300,000.
The property 404 Yarrow Pl is a house located in Castle Pines, Colorado, 80108.
Active Listing: 404 Yarrow Pl is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 404 Yarrow Pl are: Timber Trail Elementary School (GreatSchools Rating 7/10), Buffalo Ridge Elementary School (GreatSchools Rating 6/10), Wildcat Mountain Elementary School (GreatSchools Rating 7/10), Dc Montessori Charter School (GreatSchools Rating 6/10), American Academy (GreatSchools Rating 9/10), Rocky Heights Middle School (GreatSchools Rating 8/10), Rock Canyon High School (GreatSchools Rating 10/10), Eagle Academy (GreatSchools Rating 1/10), Highlands Ranch High School (GreatSchools Rating 7/10).
According to the records, the last property tax for 2023 is $8,780 (source: MLS/based on county public records data).
The last sale was on May 10, 2022 for $1,262,400 (source: MLS/tax record).
The property at 404 Yarrow Pl has 5 bedrooms and 3 full and 2 half bathrooms.
The property 404 Yarrow Pl is 5,058 SqFt (source: MLS/tax record).
The year of construction for 404 Yarrow Pl is 2001.
This home is located at 404 Yarrow Pl in Castle Pines, CO and zip code 80108 in the Hidden Pointe neighborhood. This 5,058 square foot home, which was built in 2001, sits on a 0.36 acre lot. Features: 5 bedrooms, 5 bathrooms. It has been listed on Rocket Homes since April 25, 2025 and is currently priced at $1,300,000.
In May 2025 more than 5 listings in Castle Pines, CO were sold above the asking price. During the same period more than 5 listings were sold at asking price, while more than 19 were sold below. The number of listings in Castle Pines, CO increased by 17.6% between April and May 2025. In May 2025 median list price was $869,375 and the average listing age was 33 days.
From Rocket Homes Real Estate and based on county public records data.