404 Yarrow Place, Castle Pines, 80108

See all 1 Photos

Map View

Favorite

Notes

Payments

Request a Showing

404 Yarrow Place

Castle Pines, 80108

SOLD

$1,262,400

Sold

Beds

Baths

Garage

5,241

Sq.Ft.

0.36

Acres

MLS# 2870687

Property Details

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.

Get Directions

Print Flyer

Ask a Local Expert

Comments and Questions

*Your Name

Submit Question

Virtual Tour

Property Highlights

Price

$1,119,500

Property Type

Residential

Property Sub Type

Single Family Residence

Total Bathrooms

Year Built

1999

Acres

0.36

Location

County

Douglas

Subdivision

Castle Pines North

View

Mountain(s)

Property Details

Condition

Updated/Remodeled

Price

$1,119,500

Property Sub Type

Single Family Residence

Property Type

Residential

Building

Levels

Two

Structure Type

House

Total Area

5,241

Community

Local Schools

Elementary School

Timber Trail

High School

Rock Canyon

Middle School

Rocky Heights

School District

Douglas RE-1

Interior Features

Bedrooms and Bathrooms

3/4 Bathrooms

Bathrooms on Main Level

Bedrooms

Full Bathrooms

Total Bathrooms

Rooms and Basement

Basement Features

Finished, Full, Sump Pump, Walk-Out Access

Has Basement

Yes

Area and Spaces

Above Grade Finished Area

3,427

Below Grade Finished Area

1,390

Living Area

4,817

Appliances

Convection Oven, Dishwasher, Disposal, Double Oven, Microwave, Range, Range Hood, Refrigerator, Self Cleaning Oven, Sump Pump

Interior Features

Fireplace Features

Basement, Living Room

Flooring

Carpet, Tile, Wood

Interior Features

Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, Granite Counters, High Ceilings, Jack & Jill Bathroom, Kitchen Island, Open Floorplan, Primary Suite, Smoke Free, Walk-In Closet(s)

Security Features

Carbon Monoxide Detector(s), Smoke Detector(s)

Window Features

Double Pane Windows, Window Coverings

Heating and Cooling

Fireplaces

Heating Features

Forced Air

Building Details

Construction

Year Built

1999

Materials

Construction Materials

Brick, Frame, Wood Siding

Roof

Composition

Terms

Contingency

None Known

Exclusions

Sellers personal items, Washer and Dryer

Financing Options

Conventional

Ownership

Individual

Special Conditions

None

Special Terms

Cash, Conventional, Jumbo, VA Loan

Taxes

HOA

HOA Fee

158.00

Tax

Tax (Annual)

$5,085

Heating, Cooling & Utilities

Cooling Features

Central Air

Utilities

Sewer

Public Sewer

Utilities

Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected

Water Source

Public

Lot

Acres

0.36

Lot Features

Cul-De-Sac, Greenbelt, Landscaped, Open Space, Sprinklers In Front, Sprinklers In Rear

Lot Size

15,682

Lot Size Area Sq Ft

15,682

Exterior Features

Fire Pit, Private Yard, Rain Gutters

Fencing

Full

Patio And Porch Features

Covered, Deck, Patio

Parking

Garage Capacity

Total Parking Spaces

Homeowner's Association

Has HOA

Yes

HOA Fee Includes

Recycling, Trash

HOA Fee Period

Quarterly

Listed by Homesmart Realty.

Listing Data last updated 04/18/2024 09:46 AM

Get a Link to this Property: Copy To Clipboard

View Census Data

View Schools

Phone:

Payment Calculator

per month. Fixed. % interest.

Home Price

Down Payment

Loan Type

Interest Rate

Total interest paid over s will be:

Principal & Interest

Home Insurance

Property Tax

HOA Fees

All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 19-Apr-2024 and are subject to change without notice. All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by open source mortgage calculation software tools using common mathematical formulas. Copyright © 2024 Buying Buddy. All calculations should be independantly verified.

Interest rates and APRs presented are based on current market rates, are for informational purposes only, are subject to change without notice and may be subject to pricing add-ons related to property type, loan amount, loan-to-value, credit score and other variables - call for details.
This is not a credit decision or a commitment to lend.
Depending on loan guidelines, mortgage insurance may be required
If mortgage insurance is required, the mortgage insurance premium could increase the APR and the monthly mortgage payment. Additional loan programs may be available.
APR (annual percentage rate) reflects the effective cost of your loan on a yearly basis, taking into account such items as interest, most closing costs, discount points (also referred to as "points"), and loan-origination fees. One point is 1% of the mortgage amount (e.g., $1,000 on a $100,000 loan).
Your monthly payment is not based on APR, but instead on the interest rate on your Note.
Adjustable Rate Mortgage (ARM) rates assume no increase in the financial index after the initial fixed period. ARM rates and monthly payments are subject to increase after the fixed period.
These special rates presented here are only available when you pre-qualify and are not guaranteed until lock-in.
Amounts may be rounded up. Additional fees and closing costs apply. If the down payment is less than 20%, mortgage insurance may be needed, which could increase the monthly payment and APR.
Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. This Payment Calculator tool is Copyright © 2024 Buying Buddy. All calculations should be independantly verified.
Please contact a loan specialist to get specific payment examples and information regarding your particular needs.

Get Walk Score Content

Property History

75 days ago

Property information last updated

711 days ago

Date Sold

743 days ago

Status Active. This is the date the listing was placed on market.

NOTE: Cumulative Days on Market: 743. Data provided by the MLS.

Similar Properties

Listings courtesy of REcolorado as distributed by MLS GRID IDX information is provided exclusively for consumers' personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MLS GRID. Based on information submitted to the MLS GRID as of 04/18/2024 09:46 AM. 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.

DMCA Notice

Listing Data last updated: 04/18/2024 09:46 AM

404 Yarrow Place - MLS#2870687 - $1,119,500

Sold by Homesmart Realty

{"property_id":"denver_2870687","AboveGradeFinishedArea":"3427","AccessibilityFeatures":null,"Appliances":"Convection Oven, Dishwasher, Disposal, Double Oven, Microwave, Range, Range Hood, Refrigerator, Self Cleaning Oven, Sump Pump","ArchitecturalStyle":null,"AssociationAmenities":null,"AssociationFee":"158.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Recycling, Trash","AssociationYN":"1","AttributionContact":null,"Basement":"Finished, Full, Sump Pump, Walk-Out Access","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"1390","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":"Conventional","CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Brick, Frame, Wood Siding","Contingency":"None Known","Cooling":"Central Air","CountyOrParish":"Douglas","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":"Timber Trail","Exclusions":"Sellers personal items,  Washer and Dryer","ExteriorFeatures":"Fire Pit, Private Yard, Rain Gutters","Fencing":"Full","FireplaceFeatures":"Basement, Living Room","FireplaceYN":null,"FireplacesTotal":"2","Flooring":"Carpet, Tile, Wood","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air","HighSchool":"Rock Canyon","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, Granite Counters, High Ceilings, Jack & Jill Bathroom, Kitchen Island, Open Floorplan, Primary Suite, Smoke Free, Walk-In Closet(s)","InternetAddressDisplayYN":null,"LaundryFeatures":null,"Levels":"Two","ListAgentFullName":"Christopher Wells","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, Jumbo, VA Loan","LivingArea":null,"LotFeatures":"Cul-De-Sac, Greenbelt, Landscaped, Open Space, Sprinklers In Front, Sprinklers In Rear","LotSizeArea":"15682.00","LotSizeDimensions":null,"LotSizeSquareFeet":"15682.00","MainLevelBathrooms":"1","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"Rocky Heights","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":null,"ParkingTotal":"3","PatioAndPorchFeatures":"Covered, Deck, Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":null,"PropertyCondition":"Updated\/Remodeled","PropertySubType":"Single Family Residence","public_remarks":"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.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Douglas RE-1","SecurityFeatures":"Carbon Monoxide Detector(s), Smoke Detector(s)","seller_office_id":null,"SeniorCommunityYN":"0","Sewer":"Public Sewer","SkiFeatures":null,"SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":"None","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"House","TaxAnnualAmount":"5085.00","Utilities":"Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected","View":"Mountain(s)","ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/tours.upshotimaging.com\/1980904","WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Double Pane Windows, Window Coverings","YearBuilt":"1999","Zoning":null,"ZoningDescription":null,"property_uid":"REC2025518015","listing_status":"sold","mls_status":"Closed","mls_id":"denver","listing_num":"2870687","acreage":null,"acres":"0.36","address":null,"address_direction":null,"address_flg":"1","address_num":"404","agent_id":"00668N","area":null,"baths_total":"5.00","bedrooms_total":"5","car_spaces":"3","city":"Castle Pines","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"4817","geocode_address":"404 Yarrow Place","geocode_status":null,"lat":"39.4882591","lon":"-104.89318733","office_id":"2HOME","office_name":"HomeSmart Realty","orig_price":"1119500","photo_count":"40","previous_price":null,"price":"1119500","prop_img":"\/images\/property\/denver\/2870687-1.jpeg","property_type":"Residential","sqft_total":"5241","state":"CO","street_type":"Place","street_name":"Yarrow","sub_area":"Castle Pines North","unit":null,"zip_code":"80108","listing_dt":"2022-04-07","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":"55045438","sold_dt":"2022-05-09","sold_price":"1262400","webapi_update_dt":null,"update_dt":"2024-02-04 09:34:23","create_dt":"2022-04-07 00:00:00","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}

Start of property details

Property Details

Ask a Local Expert

Property Highlights

Location

Property Details

Building

Community

Local Schools

Interior Features

Bedrooms and Bathrooms

Rooms and Basement

Area and Spaces

Appliances

Interior Features

Heating and Cooling

Building Details

Construction

Materials

Terms

Terms

Taxes

HOA

Tax

Heating, Cooling & Utilities

Utilities

Lot

Exterior Features

Parking

Homeowner's Association

Payment Calculator

Assumptions and Disclosures

Property History

Similar Properties