Kuna Estates

303-564-9723

TARAH KUNA

  • Listings
    • Featured Listings
    • Sold by Tarah
    • 3D Virtual Home Tours
  • Search
    • Easy Search
    • Search Homes for Rent
    • New Construction
    • Featured Communities
  • Services
    • Listing Services
    • Buying Services
    • Home Leasing Services
    • Home Value Estimate
  • About
    • About Me
    • Testimonials
    • Contact
Home » 470 Yarrow Place Castle Pines, 80108 — MLS# 7790794

470 Yarrow Place Castle Pines, 80108 — MLS# 7790794

Start of property details

Share this property:
SHARE PRINT LINK
Previous Next
See all 36 Photos
Map View
Gallery
Open House
Favorite
Share
Notes
Payments
Request a Showing
470 Yarrow Place
Castle Pines, 80108
FOR
SALE
$1,049,000
For Sale
4
Beds
5
Baths
3
Garage
4,433
Sq.Ft.
0.25
Acres
MLS# 7790794
Listed on site 18 days since September 13th, 2023

Property Details

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.

Get Directions
Print Flyer

Ask a Local Expert

Submit Question
Virtual Tour

Property Highlights

Price
$1,049,000
Property Type
Residential
Property Sub Type
Single Family Residence
Architectural Style
Traditional
Total Bathrooms
5
Year Built
2000
Acres
0.25

Location

County
Douglas
Direction Faces
Northwest
Subdivision
Hidden Pointe

Property Details

Price
$1,049,000
Property Sub Type
Single Family Residence
Property Type
Residential

Building

Levels
Two
Structure Type
House
Total Area
4,433

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

1/2 Bathrooms
1
3/4 Bathrooms
1
Bathrooms on Main Level
1
Bedrooms
4
Full Bathrooms
3
Total Bathrooms
5

Rooms and Basement

Basement Features
Cellar, Interior Entry, Partial
Has Basement
Yes

Area and Spaces

Above Grade Finished Area
3,200
Below Grade Finished Area
1,173
Living Area
4,373

Appliances

Appliances
Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Humidifier, Microwave, Refrigerator, Washer

Interior Features

Fireplace Features
Gas Log, Great Room
Flooring
Carpet, Tile, Vinyl, Wood
Interior Features
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
Laundry Features
In Unit
Security Features
Carbon Monoxide Detector(s), Smart Cameras, Smoke Detector(s)
Window Features
Bay Window(s), Double Pane Windows, Window Coverings, Window Treatments

Heating and Cooling

Fireplaces
1
Heating Features
Forced Air, Solar

Building Details

Construction

Architectural Style
Traditional
Builder
Sanford Homes
Foundation
Slab
Year Built
2000

Materials

Construction Materials
Brick, Frame, Wood Siding
Roof
Composition

Terms

Terms

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.
Ownership
Individual
Special Conditions
None
Special Terms
Cash, Conventional, FHA, Jumbo, VA Loan

Taxes

HOA

HOA Fee
170.00

Tax

Tax (Annual)
$4,140

Heating, Cooling & Utilities

Cooling Features
Central Air

Utilities

Sewer
Public Sewer
Utilities
Electricity Connected, Natural Gas Connected
Water Source
Public

Lot

Acres
0.25
Lot Features
Cul-De-Sac, Irrigated, Landscaped, Many Trees, Master Planned, Sloped, Sprinklers In Front, Sprinklers In Rear
Lot Size
10,890
Lot Size Area Sq Ft
10,890

Exterior Features

Exterior Features
Private Yard, Rain Gutters
Fencing
Partial
Patio And Porch Features
Covered, Front Porch, Patio

Parking

Garage Capacity
3
Parking Features
Concrete
Total Parking Spaces
3

Homeowner's Association

Has HOA
Yes
HOA Ammenities
Park, Playground, Trail(s)
HOA Fee Includes
Recycling, Trash
HOA Fee Period
Quarterly
Listed by Re/max Professionals, michele@gwinproperties.com, 303-947-7743.
Listing Data last updated 2nd October, 2023 08:00 MST
Get a Link to this Property: Copy To Clipboard
QR Code link to this property
View Census Data
View Schools

Phone:
Connect with:

Payment Calculator

per month. Fixed. % interest.
per month
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 2-Oct-2023 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 © 2023 Buying Buddy. All calculations should be independantly verified.
Assumptions and Disclosures
  • 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 © 2023 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

18 days ago
Property Listed
17 days ago
Property info last updated

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 2nd October, 2023 08:00 MST. 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.
IDX Logo
The Digital Millennium Copyright Act of 1998, 17 U.S.C. §512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: DMCAnotice@MLSGrid.com. The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Listing Data last updated: 2nd October, 2023 08:00 MST
Equal Housing Opportunity
Privacy Policy
Service by Buying Buddy® IDX CRM
Copyright © 2003 - 2023 Buying Buddy. All rights reserved.
Email to a friend Share on Facebook Share on Twitter Share on Pinterest! Copy Direct Link
470 Yarrow Place - MLS#7790794 - $1,049,000
Listed by Re/max ProfessionalsIDX Logo
{"property_id":"denver_7790794","AboveGradeFinishedArea":"3200","AccessibilityFeatures":null,"Appliances":"Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Humidifier, Microwave, Refrigerator, Washer","ArchitecturalStyle":"Traditional","AssociationAmenities":"Park, Playground, Trail(s)","AssociationFee":"170.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Recycling, Trash","AssociationYN":"1","AttributionContact":"Michele@GwinProperties.com, 303-947-7743","Basement":"Cellar, Interior Entry, Partial","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"1173","BuilderModel":null,"BuilderName":"Sanford Homes","BuyerFinancing":null,"CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Brick, Frame, Wood Siding","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Douglas","CoveredSpaces":null,"CurrentFinancing":null,"DaysOnMarket":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"Northwest","DoorFeatures":null,"Electric":null,"ElementarySchool":"Timber Trail","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.","ExteriorFeatures":"Private Yard, Rain Gutters","Fencing":"Partial","FireplaceFeatures":"Gas Log, Great Room","FireplaceYN":null,"FireplacesTotal":"1","Flooring":"Carpet, Tile, Vinyl, Wood","FoundationDetails":"Slab","GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air, Solar","HighSchool":"Rock Canyon","HorseAmenities":null,"HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"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","LaundryFeatures":"In Unit","Levels":"Two","ListAgentFullName":"Michele Gwin","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, FHA, Jumbo, VA Loan","LivingArea":null,"LotFeatures":"Cul-De-Sac, Irrigated, Landscaped, Many Trees, Master Planned, Sloped, Sprinklers In Front, Sprinklers In Rear","LotSizeArea":"10890.00","LotSizeDimensions":null,"LotSizeSquareFeet":"10890.00","MainLevelBathrooms":"1","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"Rocky Heights","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":"Concrete","ParkingTotal":"3","PatioAndPorchFeatures":"Covered, Front Porch, Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"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.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Douglas RE-1","SecurityFeatures":"Carbon Monoxide Detector(s), Smart Cameras, Smoke Detector(s)","seller_office_id":null,"SeniorCommunityYN":null,"Sewer":"Public Sewer","SkiFeatures":null,"SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":"None","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"House","TaxAnnualAmount":"4140.00","Utilities":"Electricity Connected, Natural Gas Connected","View":null,"ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/www.listingsmagic.com\/sps\/tour-slider\/index.php?property_ID=252622&ld_reg=Y","WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Bay Window(s), Double Pane Windows, Window Coverings, Window Treatments","YearBuilt":"2000","Zoning":null,"ZoningDescription":null,"property_uid":"REC2034720170","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"7790794","acreage":null,"acres":"0.25","address":null,"address_direction":null,"address_flg":"1","address_num":"470","agent_id":"056149","area":null,"baths_total":"5.00","bedrooms_total":"4","car_spaces":"3","city":"Castle Pines","coseller_id":null,"coagent_id":"56149T","days_on_market":null,"finished_sqft_total":"4373","geocode_address":"470 Yarrow Place","geocode_status":null,"lat":"39.48795025","lon":"-104.89391245","office_id":"REM39","office_name":"RE\/MAX Professionals","orig_price":"1049000","photo_count":"36","previous_price":null,"price":"1049000","prop_img":"\/listing\/photos\/denver\/7790794-0.jpeg","property_type":"Residential","sqft_total":"4433","state":"CO","street_type":"Place","street_name":"Yarrow","sub_area":"Hidden Pointe","unit":null,"zip_code":"80108","listing_dt":"2023-09-14","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"update_dt":"2023-09-14 07:31:04","create_dt":"2023-09-13 20:18:04","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}

Praise

Customer Review

"We loved working with Tarah. We recently sold and purchased houses with her guidance and expertise supporting us through the process. Tarah builds trust though her outstanding customer service, communication and 100% follow through on commitments. "

More Testimonials

Meet Tarah

I am a modern real estate professional with a wealth of experience in the industry; by seamlessly combining sophisticated sales expertise with state-of-the-art marketing strategies and corporate executive career experience, I consistently deliver outstanding results for my clients. I bring a depth of experience and a commitment to excellence to every transaction.

Contact Tarah

Kuna Estates, LLC | Coldwell Banker | 6501 E Belleview Ave #500, Englewood, CO 80111 | (m) 303-564-9723 | (e) Tarah@KunaEstates.com

Copyright © 2023 · Kuna Estates, LLC · Property Sitemap

Coldwell Banker Residential Real EstateColdwell Banker Global Luxury

Realtor LogoEqual Housing Logo

Banker Residential Brokerage fully supports the principles of the Fair Housing Act and the Equal Opportunity Act

{{{disclaimer_txt}}}
Listing Data last updated: 2nd October, 2023 08:00 MST
Equal Housing Opportunity
Privacy Policy
Service by Buying Buddy® IDX CRM
Copyright © 2003 - 2023 Buying Buddy. All rights reserved.