404 Yarrow Pl
About This Property
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.
Payment Calculator
Your Estimated Monthly Payment
Cap Rate Calculator
What does this mean?
Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.
How much can I actually make?
Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.
How is cap rate calculated?
Cap Rate = Net Operating Income (NOI) / Property Asset Value.
When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.
Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.
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 | |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017